| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP03B: Enhanced Accounts Receivable |
| 1 | F03B11 | Customer Ledger | 134 | RP | SHPN | Shipment Number | Numeric | Generic Edit | 8 | 0 |
| 2 | F03B11P | Customer Ledger Purge File | 134 | RP | SHPN | Shipment Number | Numeric | Generic Edit | 8 | 0 |
| 3 | F03B11Z1 | Batch Invoices | 184 | VJ | SHPN | Shipment Number | Numeric | Generic Edit | 8 | 0 |
| 4 | F03B11Z2 | F03B11 Interoperability Table | 148 | SY | SHPN | Shipment Number | Numeric | Generic Edit | 8 | 0 |
| 5 | F03B14 | Receipts Detail | 121 | RZ | SHPN | Shipment Number | Numeric | Generic Edit | 8 | 0 |
| 6 | F03B14P | Receipts Detail Purge File | 121 | RZ | SHPN | Shipment Number | Numeric | Generic Edit | 8 | 0 |
| 7 | F03B14Z2 | F03B14 Interoperability Table | 134 | SZ | SHPN | Shipment Number | Numeric | Generic Edit | 8 | 0 |
| 8 | F03B40 | A/R Deduction Management | 38 | RB | SHPN | Shipment Number | Numeric | Generic Edit | 8 | 0 |
| 9 | F03B465 | A/R Netting Workfile | 55 | RO | SHPN | Shipment Number | Numeric | Generic Edit | 8 | 0 |
| 10 | F03B575 | Auto Debit Invoice Select and Build | 144 | RD | SHPN | Shipment Number | Numeric | Generic Edit | 8 | 0 |
| TOP40: Inventory/OP Base |
| 11 | F4011Z | Batch Receiver File - Order Details | 247 | SZ | SHPN | Shipment Number | Numeric | Generic Edit | 8 | 0 |
| 12 | F4211Z1 | Sales Order Detail Unedited Transaction File | 237 | SZ | SHPN | Shipment Number | Numeric | Generic Edit | 8 | 0 |
| 13 | F4215 | Shipment Header | 1 | XH | SHPN | Shipment Number | Numeric | Generic Edit | 8 | 0 |
| 14 | F4217 | Shipment Reference Numbers | 1 | XI | SHPN | Shipment Number | Numeric | Generic Edit | 8 | 0 |
| TOP40R: Demand Scheduling |
| 15 | F40R12 | Cumulative Quantities | 15 | CQ | SHPN | Shipment Number | Numeric | Generic Edit | 8 | 0 |
| 16 | F40R12WF | CUM Rollback Workfile | 18 | CQ | SHPN | Shipment Number | Numeric | Generic Edit | 8 | 0 |
| 17 | F40R41 | Demand History | 9 | DI | SHPN | Shipment Number | Numeric | Generic Edit | 8 | 0 |
| 18 | F40R42 | Cumulative Quantity History | 18 | CH | SHPN | Shipment Number | Numeric | Generic Edit | 8 | 0 |
| 19 | F47UI002 | ASN Extract Packaging Work File | 6 | SP | SHPN | Shipment Number | Numeric | Generic Edit | 8 | 0 |
| TOP40S: Supply Chain Self Service |
| 20 | F4947SW | Self-Service Shipment Tracking Work File | 3 | SW | SHPN | Shipment Number | Numeric | Generic Edit | 8 | 0 |
| TOP42: Sales Management |
| 21 | F4211 | Sales Order Detail File | 224 | SD | SHPN | Shipment Number | Numeric | Generic Edit | 8 | 0 |
| 22 | F42119 | Sales Order History File | 224 | SD | SHPN | Shipment Number | Numeric | Generic Edit | 8 | 0 |
| 23 | F42199 | S.O. Detail Ledger File | 224 | SL | SHPN | Shipment Number | Numeric | Generic Edit | 8 | 0 |
| 24 | F42565 | Invoice Print File | 95 | IW | SHPN | Shipment Number | Numeric | Generic Edit | 8 | 0 |
| 25 | F42UI11 | SO Detail Cache File (MBF) | 136 | ZD | SHPN | Shipment Number | Numeric | Generic Edit | 8 | 0 |
| 26 | F42UI12 | Sales Order Detail Cache 2 (MBF) | 82 | ZD | SHPN | Shipment Number | Numeric | Generic Edit | 8 | 0 |
| TOP43: Procurement |
| 27 | F43080 | Approvals Fields Constants | 186 | PD | SHPN | Shipment Number | Numeric | Generic Edit | 8 | 0 |
| 28 | F4311 | Purchase Order Detail File | 188 | PD | SHPN | Shipment Number | Numeric | Generic Edit | 8 | 0 |
| 29 | F4311Z | Purchase Order Generator File | 224 | PW | SHPN | Shipment Number | Numeric | Generic Edit | 8 | 0 |
| 30 | F4311Z1 | Purchase Order Detail Unedited Transaction Table | 202 | SZ | SHPN | Shipment Number | Numeric | Generic Edit | 8 | 0 |
| 31 | F43121 | Purchase Order Receiver File | 118 | PR | SHPN | Shipment Number | Numeric | Generic Edit | 8 | 0 |
| 32 | F43121Z | Receiver workfile | 135 | PW | SHPN | Shipment Number | Numeric | Generic Edit | 8 | 0 |
| 33 | F43121Z1 | Receipts Unedited Transaction Table | 178 | SZ | SHPN | Shipment Number | Numeric | Generic Edit | 8 | 0 |
| 34 | F43199 | P.O. Detail Ledger File - Flexible Version | 188 | OL | SHPN | Shipment Number | Numeric | Generic Edit | 8 | 0 |
| TOP46: Warehouse Management |
| 35 | F4600 | Warehouse Requests | 90 | R1 | SHPN | Shipment Number | Numeric | Generic Edit | 8 | 0 |
| 36 | F4600PU | Warehouse Requests - Purged | 89 | R1 | SHPN | Shipment Number | Numeric | Generic Edit | 8 | 0 |
| 37 | F4611 | Warehouse Suggestions | 151 | R2 | SHPN | Shipment Number | Numeric | Generic Edit | 8 | 0 |
| 38 | F4611PU | Warehouse Suggestions - Purged | 152 | R2 | SHPN | Shipment Number | Numeric | Generic Edit | 8 | 0 |
| 39 | F4615 | Carton Recommendations | 2 | CR | SHPN | Shipment Number | Numeric | Generic Edit | 8 | 0 |
| 40 | F4620 | Carton Detail Information | 16 | CD | SHPN | Shipment Number | Numeric | Generic Edit | 8 | 0 |
| 41 | F46200 | Bulk Pick Requests | 27 | BR | SHPN | Shipment Number | Numeric | Generic Edit | 8 | 0 |
| 42 | F46200PU | Bulk Pick Requests - Purged | 27 | BR | SHPN | Shipment Number | Numeric | Generic Edit | 8 | 0 |
| 43 | F4622 | Unusable Label Numbers | 4 | UL | SHPN | Shipment Number | Numeric | Generic Edit | 8 | 0 |
| 44 | F46UI15 | Carton Recommendations - Work File | 2 | RC | SHPN | Shipment Number | Numeric | Generic Edit | 8 | 0 |
| TOP46L: License Plating |
| 45 | F46L99 | License Plate History | 57 | LM | SHPN | Shipment Number | Numeric | Generic Edit | 8 | 0 |
| TOP47: Electronic Commerce |
| 46 | F47012 | EDI Purchase Order Detail - Inbound | 248 | SZ | SHPN | Shipment Number | Numeric | Generic Edit | 8 | 0 |
| 47 | F47027 | EDI P.O. Acknowledgment Detail - Outbound | 252 | SZ | SHPN | Shipment Number | Numeric | Generic Edit | 8 | 0 |
| 48 | F47032 | EDI Shipping Notice Detail - Inbound | 160 | SZ | SHPN | Shipment Number | Numeric | Generic Edit | 8 | 0 |
| 49 | F47037 | EDI Shipping Notice Detail - Outbound | 176 | SZ | SHPN | Shipment Number | Numeric | Generic Edit | 8 | 0 |
| 50 | F470371 | EDI Shipping Notice Detail - Outbound | 151 | SZ | SHPN | Shipment Number | Numeric | Generic Edit | 8 | 0 |
| 51 | F470373 | EDI ASN Shipping | 16 | AG | SHPN | Shipment Number | Numeric | Generic Edit | 8 | 0 |
| 52 | F47047 | EDI Invoice Detail (Sales) - Outbound | 251 | SZ | SHPN | Shipment Number | Numeric | Generic Edit | 8 | 0 |
| 53 | F470472 | EDI Invoice Expanded Detail (Sales) | 12 | S6 | SHPN | Shipment Number | Numeric | Generic Edit | 8 | 0 |
| 54 | F47072 | EDI Receiving Advice Detail - Inbound | 206 | SZ | SHPN | Shipment Number | Numeric | Generic Edit | 8 | 0 |
| 55 | F47077 | EDI Receiving Advice Detail - Outbound | 207 | SZ | SHPN | Shipment Number | Numeric | Generic Edit | 8 | 0 |
| 56 | F47092 | EDI Request for Quote Detail - Inbound | 248 | SZ | SHPN | Shipment Number | Numeric | Generic Edit | 8 | 0 |
| 57 | F47107 | EDI Response to RFQ Detail - Outbound | 248 | SZ | SHPN | Shipment Number | Numeric | Generic Edit | 8 | 0 |
| 58 | F47114 | EDI Lockbox/Payment Detail - Payment | 44 | Z4 | SHPN | Shipment Number | Numeric | Generic Edit | 8 | 0 |
| 59 | F47132 | EDI Purchase Order Change Detail - Inbound | 249 | SZ | SHPN | Shipment Number | Numeric | Generic Edit | 8 | 0 |
| 60 | F47147 | EDI P.O. Change Acknowledgment Detail - Outbound | 251 | SZ | SHPN | Shipment Number | Numeric | Generic Edit | 8 | 0 |
| 61 | F47191 | EDI Acknowledgement Header | 21 | AH | SHPN | Shipment Number | Numeric | Generic Edit | 8 | 0 |
| 62 | F47UI001 | ASN Extract Work File | 6 | SZ | SHPN | Shipment Number | Numeric | Generic Edit | 8 | 0 |
| TOP49: Transportation Management |
| 63 | F49110 | Transportation Bill of Lading Workfile | 4 | BW | SHPN | Shipment Number | Numeric | Generic Edit | 8 | 0 |
| 64 | F49111 | Carton Detail Shipment Workfile | 4 | CD | SHPN | Shipment Number | Numeric | Generic Edit | 8 | 0 |
| 65 | F49130 | Shipment Document Workfile | 8 | BW | SHPN | Shipment Number | Numeric | Generic Edit | 8 | 0 |
| 66 | F49140 | SSCC Print Label Workfile | 5 | BW | SHPN | Shipment Number | Numeric | Generic Edit | 8 | 0 |
| 67 | F49141 | Packing List Workfile | 6 | PW | SHPN | Shipment Number | Numeric | Generic Edit | 8 | 0 |
| 68 | F49380 | Seal Numbers | 6 | SU | SHPN | Shipment Number | Numeric | Generic Edit | 8 | 0 |
| 69 | F4941 | Shipment Routing Steps | 1 | RS | SHPN | Shipment Number | Numeric | Generic Edit | 8 | 0 |
| 70 | F4942 | Shipment Detail | 1 | IS | SHPN | Shipment Number | Numeric | Generic Edit | 8 | 0 |
| 71 | F4943 | Shipment Pieces | 1 | SP | SHPN | Shipment Number | Numeric | Generic Edit | 8 | 0 |
| 72 | F4944 | Shipment/Load Options and Equipment | 1 | OE | SHPN | Shipment Number | Numeric | Generic Edit | 8 | 0 |
| 73 | F4945 | Shipment Charges | 1 | SC | SHPN | Shipment Number | Numeric | Generic Edit | 8 | 0 |
| 74 | F4947 | Shipment Status Codes | 1 | ST | SHPN | Shipment Number | Numeric | Generic Edit | 8 | 0 |
| 75 | F49490 | Document Selection | 1 | TQ | SHPN | Shipment Number | Numeric | Generic Edit | 8 | 0 |
| 76 | F4957 | Transportation Confirmed Batch Shipment | 1 | BC | SHPN | Shipment Number | Numeric | Generic Edit | 8 | 0 |
| 77 | F49591 | Document Print - Batch Selection | 9 | DB | SHPN | Shipment Number | Numeric | Generic Edit | 8 | 0 |
| 78 | F49594 | Document Print - Document Detail | 27 | DI | SHPN | Shipment Number | Numeric | Generic Edit | 8 | 0 |
| 79 | F49621 | Load Compartment Detail | 11 | TD | SHPN | Shipment Number | Numeric | Generic Edit | 8 | 0 |
| 80 | F4963 | Load In-transit | 3 | TI | SHPN | Shipment Number | Numeric | Generic Edit | 8 | 0 |
| 81 | F49631 | Load In-transit Ledger | 8 | TO | SHPN | Shipment Number | Numeric | Generic Edit | 8 | 0 |
| 82 | F49632 | Load In-transit Left on Board | 3 | LB | SHPN | Shipment Number | Numeric | Generic Edit | 8 | 0 |
| 83 | F49633 | Load In-Transit Confirmed Quantities | 4 | IQ | SHPN | Shipment Number | Numeric | Generic Edit | 8 | 0 |
| 84 | F49634 | Load In-Transit Confirmed Quantities Detail | 1 | QD | SHPN | Shipment Number | Numeric | Generic Edit | 8 | 0 |
| 85 | F49696 | Document Register Detail | 11 | DJ | SHPN | Shipment Number | Numeric | Generic Edit | 8 | 0 |
| 86 | F49697 | Document Register Summary | 13 | DN | SHPN | Shipment Number | Numeric | Generic Edit | 8 | 0 |
| 87 | F49721 | Spot Quote Detail | 2 | QS | SHPN | Shipment Number | Numeric | Generic Edit | 8 | 0 |
| 88 | F4981 | Freight Audit History | 2 | FH | SHPN | Shipment Number | Numeric | Generic Edit | 8 | 0 |
| 89 | F49T30 | Sales Confirm Staging Table | 4 | SO | SHPN | Shipment Number | Numeric | Generic Edit | 8 | 0 |
| TOP76B: Brazil - Reporting System Only |
| 90 | F76B947 | SPED Job Hash Codes - BR - 09 | 3 | SH | PN | Period Number - General Ledger | Numeric | Generic Edit | 2 | 0 |
| TOP89: Conversion Programs |
| 91 | F4215T | OBSOLETE - Shipment Header Tag File | 1 | XT | SHPN | Shipment Number | Numeric | Generic Edit | 8 | 0 |
| 92 | F4311TA | Temp table for ERP 9.0 upgrade | 7 | PD | SHPN | Shipment Number | Numeric | Generic Edit | 8 | 0 |
| 93 | F43121TA | ERP 9.0 temp F43121T for upgrade | 9 | PR | SHPN | Shipment Number | Numeric | Generic Edit | 8 | 0 |
| 94 | F43199A | Temp F43199 for ERP 9.0 Upgrade | 188 | OL | SHPN | Shipment Number | Numeric | Generic Edit | 8 | 0 |
| 95 | F4600T | OBSOLETE - Warehouse Requests Tag File | 5 | R1 | SHPN | Shipment Number | Numeric | Generic Edit | 8 | 0 |
| 96 | F4600TPU | OBSOLETE - Warehouse Requests Tag File - Purged | 5 | R1 | SHPN | Shipment Number | Numeric | Generic Edit | 8 | 0 |
| 97 | F4611T | OBSOLETE - Warehouse Suggestions Tag File | 5 | R2 | SHPN | Shipment Number | Numeric | Generic Edit | 8 | 0 |
| 98 | F4611TPU | OBSOLETE - Warehouse Suggestions Tag File - Purged | 5 | R2 | SHPN | Shipment Number | Numeric | Generic Edit | 8 | 0 |
