| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP40: Inventory/OP Base |
1 | F49211 | Sales Order Detail File - Tag File | 143 | UD | JOBSQ | Job Sequence Number | String | Generic Edit | 15 | 0 |
2 | F49211Z1 | Sales Order Detail Tag Unedited Transaction File | 158 | S1 | JOBSQ | Job Sequence Number | String | Generic Edit | 15 | 0 |
3 | F49219 | Sales Order Detail - Tag History File | 116 | UD | JOBSQ | Job Sequence Number | String | Generic Edit | 15 | 0 |
TOP40R: Demand Scheduling |
4 | F40R11 | Demand Detail | 39 | DD | JOBSQ | Job Sequence Number | String | Generic Edit | 15 | 0 |
5 | F40R41 | Demand History | 44 | DI | JOBSQ | Job Sequence Number | String | Generic Edit | 15 | 0 |
6 | F47173 | EDI Demand Scheduling Detail | 42 | ES | JOBSQ | Job Sequence Number | String | Generic Edit | 15 | 0 |
TOP42: Sales Management |
7 | F42565 | Invoice Print File | 178 | IW | JOBSQ | Job Sequence Number | String | Generic Edit | 15 | 0 |
8 | F42UI12 | Sales Order Detail Cache 2 (MBF) | 128 | ZD | JOBSQ | Job Sequence Number | String | Generic Edit | 15 | 0 |
TOP46: Warehouse Management |
9 | F4600 | Warehouse Requests | 98 | R1 | JOBSQ | Job Sequence Number | String | Generic Edit | 15 | 0 |
10 | F4600PU | Warehouse Requests - Purged | 94 | R1 | JOBSQ | Job Sequence Number | String | Generic Edit | 15 | 0 |
11 | F4611 | Warehouse Suggestions | 158 | R2 | JOBSQ | Job Sequence Number | String | Generic Edit | 15 | 0 |
12 | F4611PU | Warehouse Suggestions - Purged | 157 | R2 | JOBSQ | Job Sequence Number | String | Generic Edit | 15 | 0 |
13 | F4611Z1 | Unedited Suggestion Table | 165 | SZ | JOBSQ | Job Sequence Number | String | Generic Edit | 15 | 0 |
14 | F4620 | Carton Detail Information | 61 | CD | JOBSQ | Job Sequence Number | String | Generic Edit | 15 | 0 |
TOP47: Electronic Commerce |
15 | F470372 | EDI ASN Demand Scheduling Detail | 36 | AI | JOBSQ | Job Sequence Number | String | Generic Edit | 15 | 0 |
16 | F470472 | EDI Invoice Expanded Detail (Sales) | 80 | S6 | JOBSQ | Job Sequence Number | String | Generic Edit | 15 | 0 |
TOP49: Transportation Management |
17 | F49110 | Transportation Bill of Lading Workfile | 80 | BW | JOBSQ | Job Sequence Number | String | Generic Edit | 15 | 0 |