| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP00: Foundation Environment |
| 1 | F0039 | Generated Documents Definition | 4 | GN | OSEQ | Sequence Number | Numeric | Generic Edit | 4 | 0 |
| TOP37: Quality Management |
| 2 | F40318 | Preference Profile - Quality Management | 13 | QC | OSEQ | Sequence Number | Numeric | Generic Edit | 4 | 0 |
| TOP40: Inventory/OP Base |
| 3 | F40070 | Preference Master File | 5 | PF | OSEQ | Sequence Number | Numeric | Generic Edit | 4 | 0 |
| 4 | F4015 | Order Templates | 3 | OT | OSEQ | Sequence Number | Numeric | Generic Edit | 4 | 0 |
| 5 | F40301 | Preference Profile - Payment Terms | 25 | PT | OSEQ | Sequence Number | Numeric | Generic Edit | 4 | 0 |
| 6 | F40302 | Preference Profile - Unit of Measure | 24 | PU | OSEQ | Sequence Number | Numeric | Generic Edit | 4 | 0 |
| 7 | F40303 | Preference Profile - Revenue Cost Center | 24 | RV | OSEQ | Sequence Number | Numeric | Generic Edit | 4 | 0 |
| 8 | F40304 | Preference Profile - End Use | 24 | PE | OSEQ | Sequence Number | Numeric | Generic Edit | 4 | 0 |
| 9 | F40305 | Preference Profile - Print Messages | 12 | RM | OSEQ | Sequence Number | Numeric | Generic Edit | 4 | 0 |
| 10 | F40305R | Preference Resolution Ledger - Print Messages | 14 | RM | OSEQ | Sequence Number | Numeric | Generic Edit | 4 | 0 |
| 11 | F40306 | Preference Profile - Inventory Sourcing | 12 | SR | OSEQ | Sequence Number | Numeric | Generic Edit | 4 | 0 |
| 12 | F40307 | Preference Profile - Product Allocations | 28 | LA | OSEQ | Sequence Number | Numeric | Generic Edit | 4 | 0 |
| 13 | F40308 | Preference Profile - Grade and Potency | 27 | GS | OSEQ | Sequence Number | Numeric | Generic Edit | 4 | 0 |
| 14 | F40309 | Preference Profile - Delivery Date | 12 | DY | OSEQ | Sequence Number | Numeric | Generic Edit | 4 | 0 |
| 15 | F40309R | Preference Resolution Ledger - Delivery Date | 14 | DY | OSEQ | Sequence Number | Numeric | Generic Edit | 4 | 0 |
| 16 | F40310 | Preference Profile - Line of Business | 23 | LB | OSEQ | Sequence Number | Numeric | Generic Edit | 4 | 0 |
| 17 | F40311 | Preference Profile - Price Code 1 | 23 | P1 | OSEQ | Sequence Number | Numeric | Generic Edit | 4 | 0 |
| 18 | F40312 | Preference Profile - Price Code 2 | 23 | P2 | OSEQ | Sequence Number | Numeric | Generic Edit | 4 | 0 |
| 19 | F40313 | Preference Profile - Price Code 3 | 23 | P3 | OSEQ | Sequence Number | Numeric | Generic Edit | 4 | 0 |
| 20 | F40314 | Preference Profile - Price Adjustment Schedule | 12 | PJ | OSEQ | Sequence Number | Numeric | Generic Edit | 4 | 0 |
| 21 | F40314R | Preference Resolution Ledger - Price Adjustment Schedule | 14 | PJ | OSEQ | Sequence Number | Numeric | Generic Edit | 4 | 0 |
| 22 | F40315 | Preference Profile - Invoice Cycling | 12 | PI | OSEQ | Sequence Number | Numeric | Generic Edit | 4 | 0 |
| 23 | F40315R | Preference Resolution Ledger - Invoice Cycle | 14 | PI | OSEQ | Sequence Number | Numeric | Generic Edit | 4 | 0 |
| 24 | F40316 | Preference Profile - Order Preparation | 12 | OP | OSEQ | Sequence Number | Numeric | Generic Edit | 4 | 0 |
| 25 | F40316R | Preference Resolution Ledger - Order Preparation Days | 14 | OP | OSEQ | Sequence Number | Numeric | Generic Edit | 4 | 0 |
| 26 | F40318R | Preference Resolution Ledger - Quality Management | 15 | QC | OSEQ | Sequence Number | Numeric | Generic Edit | 4 | 0 |
| 27 | F40329 | Preference Profile - Document Distribution | 12 | DD | OSEQ | Sequence Number | Numeric | Generic Edit | 4 | 0 |
| 28 | F40330 | Preference Profile - Document Set | 12 | DG | OSEQ | Sequence Number | Numeric | Generic Edit | 4 | 0 |
| 29 | F40331 | Preference Profile - Options and Equipment | 12 | OE | OSEQ | Sequence Number | Numeric | Generic Edit | 4 | 0 |
| 30 | F40332 | Preference Profile - Customer Freight | 12 | CF | OSEQ | Sequence Number | Numeric | Generic Edit | 4 | 0 |
| 31 | F40333 | Preference Profile - Carrier | 12 | CA | OSEQ | Sequence Number | Numeric | Generic Edit | 4 | 0 |
| 32 | F40334 | Preference Profile - Mode of Transport | 12 | MT | OSEQ | Sequence Number | Numeric | Generic Edit | 4 | 0 |
| 33 | F40338 | Preference Profile - Payment Terms (Branch) | 12 | PT | OSEQ | Sequence Number | Numeric | Generic Edit | 4 | 0 |
| 34 | F40338R | Preference Resolution Ledger - Payment Terms (Branch) | 14 | PT | OSEQ | Sequence Number | Numeric | Generic Edit | 4 | 0 |
| 35 | F40339 | Preference Profile - Product Allocations (Branch) | 12 | LA | OSEQ | Sequence Number | Numeric | Generic Edit | 4 | 0 |
| 36 | F40341 | Preference Profile - Next Order Status | 12 | NS | OSEQ | Sequence Number | Numeric | Generic Edit | 4 | 0 |
| 37 | F40341R | Preference Resolution Ledger - Next Order Status | 14 | NS | OSEQ | Sequence Number | Numeric | Generic Edit | 4 | 0 |
| 38 | F40344 | Preference Profile - Sales Commission | 12 | SA | OSEQ | Sequence Number | Numeric | Generic Edit | 4 | 0 |
| 39 | F40344R | Preference Resolution Ledger - Sales Commission | 14 | SA | OSEQ | Sequence Number | Numeric | Generic Edit | 4 | 0 |
| 40 | F40345 | Preference Profile - Customer Currency | 12 | CR | OSEQ | Sequence Number | Numeric | Generic Edit | 4 | 0 |
| 41 | F40345R | Preference Resolution Ledger - Customer Currency | 14 | CR | OSEQ | Sequence Number | Numeric | Generic Edit | 4 | 0 |
| 42 | F40347 | Preference Profile - Pricing UOM (Branch) | 12 | RI | OSEQ | Sequence Number | Numeric | Generic Edit | 4 | 0 |
| 43 | F40347R | Preference Resolution Ledger - Pricing UOM (Branch) | 14 | RI | OSEQ | Sequence Number | Numeric | Generic Edit | 4 | 0 |
| 44 | F40349 | Preference Profile - Revenue Business Unit (Branch) | 12 | RV | OSEQ | Sequence Number | Numeric | Generic Edit | 4 | 0 |
| 45 | F40349R | Preference Resolution Ledger - Revenue Bus Unit (Branch) | 14 | RV | OSEQ | Sequence Number | Numeric | Generic Edit | 4 | 0 |
| 46 | F40350 | Preference Profiles - Conatiner Deposit/Rental | 12 | OQ | OSEQ | Sequence Number | Numeric | Generic Edit | 4 | 0 |
| 47 | F40741 | Preference Adjustment History | 6 | PH | OSEQ | Sequence Number | Numeric | Generic Edit | 4 | 0 |
| 48 | F40UI002 | Supplier History Rebuild -workfile | 3 | UT | OSEQ | Sequence Number | Numeric | Generic Edit | 4 | 0 |
| 49 | F40UI17 | Allocation Work File | 21 | ZG | OSEQ | Sequence Number | Numeric | Generic Edit | 4 | 0 |
| 50 | F40UI74 | Price Adjustment History Work File | 14 | AW | OSEQ | Sequence Number | Numeric | Generic Edit | 4 | 0 |
| 51 | F4211Z1 | Sales Order Detail Unedited Transaction File | 240 | SZ | OSEQ | Sequence Number | Numeric | Generic Edit | 4 | 0 |
| TOP41: Inventory Management |
| 52 | F4101H | Item Hierarchy (Web) | 4 | IH | OSEQ | Sequence Number | Numeric | Generic Edit | 4 | 0 |
| TOP42: Sales Management |
| 53 | F4074 | Price Adjustment Ledger File | 8 | AL | OSEQ | Sequence Number | Numeric | Generic Edit | 4 | 0 |
| 54 | F4211 | Sales Order Detail File | 227 | SD | OSEQ | Sequence Number | Numeric | Generic Edit | 4 | 0 |
| 55 | F42119 | Sales Order History File | 227 | SD | OSEQ | Sequence Number | Numeric | Generic Edit | 4 | 0 |
| 56 | F42199 | S.O. Detail Ledger File | 227 | SL | OSEQ | Sequence Number | Numeric | Generic Edit | 4 | 0 |
| 57 | F42565 | Invoice Print File | 10 | IW | OSEQ | Sequence Number | Numeric | Generic Edit | 4 | 0 |
| 58 | F42UI12 | Sales Order Detail Cache 2 (MBF) | 84 | ZD | OSEQ | Sequence Number | Numeric | Generic Edit | 4 | 0 |
| 59 | F47027T | Tag for F47027 - EDI P.O. Acknowledgment Detail - Outbound | 27 | UZ | OSEQ | Sequence Number | Numeric | Generic Edit | 4 | 0 |
| 60 | F470371T | Tag for F470371- EDI shipping Notice Detail - Outbound | 45 | UZ | OSEQ | Sequence Number | Numeric | Generic Edit | 4 | 0 |
| 61 | F47047T | Tag for F47047- EDI Invoice Detail (Sales) - Outbound | 27 | UZ | OSEQ | Sequence Number | Numeric | Generic Edit | 4 | 0 |
| 62 | F47107T | Tag for F47107- EDI Response to RFQ Detail - Outbound | 27 | UZ | OSEQ | Sequence Number | Numeric | Generic Edit | 4 | 0 |
| 63 | F47147T | Tag F47147 - EDI P.O. Change Acknowledgment Detail-Outbound | 27 | UZ | OSEQ | Sequence Number | Numeric | Generic Edit | 4 | 0 |
| TOP42B: Sales Order Entry |
| 64 | F4011ZT | Batch Receiver File - Order Details Tag | 21 | UZ | OSEQ | Sequence Number | Numeric | Generic Edit | 4 | 0 |
| 65 | F47012T | EDI Purchase Order Detail Tag - Inbound | 21 | UZ | OSEQ | Sequence Number | Numeric | Generic Edit | 4 | 0 |
| 66 | F47092T | EDI Request for Quote Detail Tag - Inbound | 21 | UZ | OSEQ | Sequence Number | Numeric | Generic Edit | 4 | 0 |
| 67 | F47132T | EDI Purchase Order Change Detail Tag - Inbound | 21 | UZ | OSEQ | Sequence Number | Numeric | Generic Edit | 4 | 0 |
| TOP43Q: Strategic Sourcing |
| 68 | F43Q403 | Bidder Response Decline | 5 | RI | OSEQ | Sequence Number | Numeric | Generic Edit | 4 | 0 |
| TOP45: Advanced Pricing |
| 69 | F4070 | Price Adjustment Schedule | 2 | SN | OSEQ | Sequence Number | Numeric | Generic Edit | 4 | 0 |
| 70 | F4511W | Pricing Structure View | 5 | AP | OSEQ | Sequence Number | Numeric | Generic Edit | 4 | 0 |
| 71 | F4574 | Key Reference Table | 53 | KR | OSEQ | Sequence Number | Numeric | Generic Edit | 4 | 0 |
| 72 | F4575 | Ship and Debit History | 7 | AH | OSEQ | Sequence Number | Numeric | Generic Edit | 4 | 0 |
| 73 | F4575TMP | Ship and Debit History - Temp Table | 7 | AH | OSEQ | Sequence Number | Numeric | Generic Edit | 4 | 0 |
| 74 | F4576 | Ship and Debit Claims | 6 | AC | OSEQ | Sequence Number | Numeric | Generic Edit | 4 | 0 |
| 75 | F4576TMP | Ship and Debit Claims- Temp Table | 6 | AC | OSEQ | Sequence Number | Numeric | Generic Edit | 4 | 0 |
| 76 | F4576Z1 | Ship and Debit Claims Unedited Transaction Table | 19 | Z1 | OSEQ | Sequence Number | Numeric | Generic Edit | 4 | 0 |
| TOP46: Warehouse Management |
| 77 | F4620 | Carton Detail Information | 21 | CD | OSEQ | Sequence Number | Numeric | Generic Edit | 4 | 0 |
| TOP47: Electronic Commerce |
| 78 | F470473 | EDI Invoice Detail Charges | 10 | S7 | OSEQ | Sequence Number | Numeric | Generic Edit | 4 | 0 |
| TOP48: Work Order Processing |
| 79 | F4808 | Order Routing Approval Master | 4 | CA | OSEQ | Sequence Number | Numeric | Generic Edit | 4 | 0 |
| 80 | F4818 | Order Approval Audit | 3 | CB | OSEQ | Sequence Number | Numeric | Generic Edit | 4 | 0 |
| TOP49: Transportation Management |
| 81 | F490051 | Generate Tracking Number Segment | 4 | XG | OSEQ | Sequence Number | Numeric | Generic Edit | 4 | 0 |
| 82 | F490053 | Generate Tracking Number Separator | 4 | ZG | OSEQ | Sequence Number | Numeric | Generic Edit | 4 | 0 |
| 83 | F49025 | Connected Vehicles (Conversion from World File) | 3 | CV | OSEQ | Sequence Number | Numeric | Generic Edit | 4 | 0 |
| 84 | F49140 | SSCC Print Label Workfile | 7 | BW | OSEQ | Sequence Number | Numeric | Generic Edit | 4 | 0 |
| 85 | F49141 | Packing List Workfile | 33 | PW | OSEQ | Sequence Number | Numeric | Generic Edit | 4 | 0 |
| 86 | F4936 | Connected Vehicle Detail | 3 | CW | OSEQ | Sequence Number | Numeric | Generic Edit | 4 | 0 |
| 87 | F4943 | Shipment Pieces | 3 | SP | OSEQ | Sequence Number | Numeric | Generic Edit | 4 | 0 |
| 88 | F4945 | Shipment Charges | 6 | SC | OSEQ | Sequence Number | Numeric | Generic Edit | 4 | 0 |
| 89 | F4947 | Shipment Status Codes | 3 | ST | OSEQ | Sequence Number | Numeric | Generic Edit | 4 | 0 |
| 90 | F49612 | Load Vehicles | 3 | TD | OSEQ | Sequence Number | Numeric | Generic Edit | 4 | 0 |
| 91 | F4962 | Load Compartments | 6 | TE | OSEQ | Sequence Number | Numeric | Generic Edit | 4 | 0 |
| 92 | F49631 | Load In-transit Ledger | 15 | TO | OSEQ | Sequence Number | Numeric | Generic Edit | 4 | 0 |
| 93 | F49632 | Load In-transit Left on Board | 11 | LB | OSEQ | Sequence Number | Numeric | Generic Edit | 4 | 0 |
| 94 | F4970 | Freight Rate Schedule | 2 | FT | OSEQ | Sequence Number | Numeric | Generic Edit | 4 | 0 |
| 95 | F4973 | Rate Structure Definition | 2 | TL | OSEQ | Sequence Number | Numeric | Generic Edit | 4 | 0 |
| 96 | F4981 | Freight Audit History | 7 | FH | OSEQ | Sequence Number | Numeric | Generic Edit | 4 | 0 |
| TOP89: Conversion Programs |
| 97 | F40344A | Temporay Preference Profile - Sales Commission | 12 | SA | OSEQ | Sequence Number | Numeric | Generic Edit | 4 | 0 |
| 98 | F4074TEM | Price Adjustment Ledger File - Temp for Upgrade | 6 | AL | OSEQ | Sequence Number | Numeric | Generic Edit | 4 | 0 |
| TOP90CA: CRM Foundation |
| 99 | F4107 | Item Feature Table | 2 | IF | OSEQ | Sequence Number | Numeric | Generic Edit | 4 | 0 |
| TOPH95: Tech Resources/Applications |
| 100 | F82199 | World Writer Query Conversion Log | 5 | FU | OSEQ | Sequence Number | Numeric | Generic Edit | 4 | 0 |
| 101 | F8399 | FASTR Conversion Log | 5 | FU | OSEQ | Sequence Number | Numeric | Generic Edit | 4 | 0 |
