| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP05: Time Accounting and HRM Base |
1 | F06149 | Fiscal and Anniversary Rollover Work File | 3 | Y7 | DTE | Date | Date | Generic Edit | 6 | 0 |
TOP07: Payroll |
2 | F06147 | Fiscal and Anniversary Year History | 3 | YD | DTE | Date | Date | Generic Edit | 6 | 0 |
3 | F073911 | Leave Rollover Balance Report Work File | 4 | Y8 | DTE | Date | Date | Generic Edit | 6 | 0 |
4 | F074001 | New Hire Reporting Workfile - OneWorld Only | 110 | NH | DTE | Date | Date | Generic Edit | 6 | 0 |
TOP09: General Accounting |
5 | F0911R1 | Account Reconciliations Header - OneWorld ONLY | 5 | GL | DTE | Date | Date | Generic Edit | 6 | 0 |
TOP12: Fixed Assets |
6 | F1205 | Equipment Messages | 4 | FT | DTE | Date | Date | Generic Edit | 6 | 0 |
7 | F1205P | Equipment Messages Purge Table | 4 | FT | DTE | Date | Date | Generic Edit | 6 | 0 |
TOP15: Property Management |
8 | F151991 | G/L Transaction A/R Application Work File | 15 | NB | DTE | Date | Date | Generic Edit | 6 | 0 |
TOP31B: Blend Management |
9 | F31B03 | Barrel Master Table | 91 | BM | DTE | Date | Date | Generic Edit | 6 | 0 |
TOP34: Requirements Planning |
10 | F43213 | SRS Ship Dates | 5 | VP | DTE | Date | Date | Generic Edit | 6 | 0 |
TOP39: Advanced Stock Valuation |
11 | F39120W | Period Detail Work File | 21 | TW | DTE | Date | Date | Generic Edit | 6 | 0 |
TOP40: Inventory/OP Base |
12 | F41508 | Default Tank Information | 2 | PC | DTE | Date | Date | Generic Edit | 6 | 0 |
TOP41B: Bulk Stock Management |
13 | F41503 | Tank Strapping Table Maintenance | 12 | PB | DTE | Date | Date | Generic Edit | 6 | 0 |
14 | F41511 | Bulk Product Transaction File | 67 | PA | DTE | Date | Date | Generic Edit | 6 | 0 |
TOP42: Sales Management |
15 | F42UI01 | SO Header Cache File (MBF) | 99 | ZH | DTE | Date | Date | Generic Edit | 6 | 0 |
TOP46: Warehouse Management |
16 | F4600PU | Warehouse Requests - Purged | 86 | R1 | DTE | Date | Date | Generic Edit | 6 | 0 |
17 | F4600TPU | Warehouse Requests Tag File - Purged | 8 | R1 | DTE | Date | Date | Generic Edit | 6 | 0 |
18 | F4601PU | Warehouse Task Header - Purged | 18 | TH | DTE | Date | Date | Generic Edit | 6 | 0 |
19 | F4611PU | Warehouse Suggestions - Purged | 149 | R2 | DTE | Date | Date | Generic Edit | 6 | 0 |
20 | F4611TPU | Warehouse Suggestions Tag File - Purged | 8 | R2 | DTE | Date | Date | Generic Edit | 6 | 0 |
21 | F46130PU | Putaway Reservations - Purged | 88 | R3 | DTE | Date | Date | Generic Edit | 6 | 0 |
22 | F46200PU | Bulk Pick Requests - Purged | 35 | BR | DTE | Date | Date | Generic Edit | 6 | 0 |
TOP49: Transportation Management |
23 | F49631 | Load In-transit Ledger | 63 | TO | DTE | Date | Date | Generic Edit | 6 | 0 |
TOP75C: China - Reporting System Only |
24 | F0018CN | China - Transmitted vouchers to JinSui | 6 | CT | DTE | Date | Date | Generic Edit | 6 | 0 |
TOPD3N: dcLINK (data collection) - DSI |
25 | FD3N120W | Asset Field Counts | 8 | FA | DTE | Date | Date | Generic Edit | 6 | 0 |
TOPH95: Tech Resources/Applications |
26 | F82199 | World Writer Query Conversion Log | 11 | FU | DTE | Date | Date | Generic Edit | 6 | 0 |
27 | F8399 | FASTR Conversion Log | 10 | FU | DTE | Date | Date | Generic Edit | 6 | 0 |
28 | F93081 | Unicode Flat File Encoding Configuration | 13 | UF | DTE | Date | Date | Generic Edit | 6 | 0 |