Legacy platform

Table reference

Individual tables and table groups that can be truncated.

  • The following tables can be truncated individually:
    • INTEROP_ERROR_DISPATCH
    • INV_INVENTORY_ITEM_LOCK
    • PLT_DBVERIFY_SCRIPT
    • PLT_EOF_STATUS
    • PLT_PAGED_DATA
    • PLT_PROCESS_STATUS
    • PLT_SDF_FILE_STATUS
    • YFS_AWAITING_INDEX
    • YFS_CATALOG_MASS_AUDIT
    • YFS_CONFIRM_DEMAND_PLAN
    • YFS_CURRENT_PRO_NO_DETAIL
    • YFS_EXPORT
    • YFS_IMPORT
    • YFS_INVENTORY_ACTIVITY
    • YFS_INVENTORY_DEMAND_DTLS
    • YFS_INVENTORY_SUPPLY_TEMP
    • YFS_MONITOR_ALERT
    • YFS_REPROCESS_ERROR
    • YFS_SHIPMENT_STATISTICS
    • YFS_SNAPSHOT
    • YFS_STATISTICS_DETAIL
    • YFS_STATUS_AUDIT
    • YFS_TASK_Q
    • YPM_MASS_AUDIT
    • YPM_PROMOTION_USAGE
  • To truncate a logical group of tables, enter the name that is assigned to the group.
    Table 1. Table groups that can be truncated
    Group name Tables in the group
    GROUP.ASYNC_REQ
    • YFS_ASYNC_REQ
    • YFS_ASYNC_REQ_ERROR
    GROUP.INBOX
    • YFS_INBOX
    • YFS_INBOX_REFERENCES
    • YFS_INBOX_NOTES
    • YFS_INBOX_AUDIT
    GROUP.DOCUMENT
    • DOCUMENT
    • DOCUMENT_CLONE
    • DOCUMENT_RESTORE
    • DOCUMENT_LIFESPAN
    GROUP.BLOB
    • BLOB_TRACK
    • DATA_TABLE
    • DATA_TABLE_RESTORE
    • TRANS_DATA
    • RANS_DATA_RESTORE
    GROUP.RES_POOL
    • YFS_RES_POOL_STD_CAPCTY_PERD
    • YFS_RES_POOL_CAPCTY_CONSMPTN
    • YFS_RES_POOL_CAPCTY_OVERRIDE
    • YFS_RES_POOL_CONSMPTN_DTLS
    • YFS_RES_POOL_DOW_CAPCTY
    • YFS_RES_POOL_CAPACITY_LOCK
    • YFS_CAPACITY_AVAILABILITY
    GROUP.INV_ITEM
    • YFS_INVENTORY_ITEM
    • YFS_GLOBAL_SERIAL_NUM
    • YFS_ITEM_NODE_VELOCITY_DUMP
    • YFS_ITEM_NODE_VELOCITY
    • INV_INVENTORY_ITEM_LOCK
    • YFS_INVENTORY_ALERTS
    • YFS_INVENTORY_ALERT_DETAIL
    • INV_ALERT_DTL_RELATIONSHIP
    • YFS_INVENTORY_ACTIVITY
    • YFS_IBA_TRIGGER
    • YFS_INV_OWN_TRANSFER_RCD
    • YFS_INV_OWN_TRANSFER_RCD
    • YFS_INVENTORY_RECEIPT
    • YFS_INVENTORY_SHIPMENT
    • YFS_INVENTORY_MATCH
    • YFS_INVENTORY_ITEM_NOD_COST
    • YFS_INVENTORY_PENDING_ADJ
    • YFS_INVENTORY_SUPPLY
    • YFS_INVENTORY_SUPPLY_ADDNL
    • YFS_INVENTORY_SUPPLY_TEMP
    • YFS_INVENTORY_DEMAND
    • YFS_INVENTORY_DEMAND_DTLS
    • YFS_INVENTORY_DEMAND_ADDNL
    • YFS_INVENTORY_TAG
    • YFS_INVENTORY_AUDIT
    • YFS_INVENTORY_RESERVATION
    • YFS_TRANSACTION_LOCK
    GROUP.APPROVAL
    • YFS_TRANSACTION_INFO
    • YFS_TRANSACTION_APPROVER
    • YFS_TRANS_APPROVAL_STATUS
    • YFS_TRANSACTION_VIOLATION
    • YFS_TRANS_VIOLATION_REFERENCE
    GROUP.YCS
    • YCS_MANIFEST_UPS_HDR
    • YCS_INTERNATIONAL_RECORD
    • YCS_COMMODITY_RECORD
    • YCS_MANIFEST_UPS_DTL
    GROUP.YIC
    • YIC_CONFIG_REGRESSION_TEST
    • YIC_BOM_HEADER
    • YIC_BOM_PROP
    • YIC_BOM_LINE