| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP31B: Blend Management |
1 | F31B85 | Weigh Tag Master | 33 | WT | NLIN | Number of Lines | Numeric | Generic Edit | 5 | 0 |
2 | F31B91 | Bill Of Lading Master | 47 | BL | NLIN | Number of Lines | Numeric | Generic Edit | 5 | 0 |
TOP39: Advanced Stock Valuation |
3 | F39120 | Temporary Period Build File for Stock Valuation | 19 | TF | NLIN | Number of Lines | Numeric | Generic Edit | 5 | 0 |
4 | F39120W | Period Detail Work File | 16 | TW | NLIN | Number of Lines | Numeric | Generic Edit | 5 | 0 |
TOP40: Inventory/OP Base |
5 | F40UI002 | Supplier History Rebuild -workfile | 19 | UT | NLIN | Number of Lines | Numeric | Generic Edit | 5 | 0 |
6 | F40UI801 | Generic Error Table | 3 | ZB | NLIN | Number of Lines | Numeric | Generic Edit | 5 | 0 |
7 | F43800 | Summary Voucher Match | 7 | PR | NLIN | Number of Lines | Numeric | Generic Edit | 5 | 0 |
TOP41: Inventory Management |
8 | F4111 | Item Ledger File | 1 | IL | NLIN | Number of Lines | Numeric | Generic Edit | 5 | 0 |
9 | F41291Z | Landed Cost Cache Table | 24 | IG | NLIN | Number of Lines | Numeric | Generic Edit | 5 | 0 |
10 | F41UI001 | Inventory Transactions Detail File | 4 | IT | NLIN | Number of Lines | Numeric | Generic Edit | 5 | 0 |
TOP41B: Bulk Stock Management |
11 | F41511 | Bulk Product Transaction File | 9 | PA | NLIN | Number of Lines | Numeric | Generic Edit | 5 | 0 |
12 | F41512 | Gain/Loss Transactions File | 12 | PT | NLIN | Number of Lines | Numeric | Generic Edit | 5 | 0 |
TOP43: Procurement |
13 | F43092 | Purchase Order Receipt Routing File | 6 | PX | NLIN | Number of Lines | Numeric | Generic Edit | 5 | 0 |
14 | F43092Z | Receipt Routing Work File | 11 | PV | NLIN | Number of Lines | Numeric | Generic Edit | 5 | 0 |
15 | F43092Z1 | Receipt Routing Unedited Transaction Table | 19 | SZ | NLIN | Number of Lines | Numeric | Generic Edit | 5 | 0 |
16 | F43099 | Receipt Routing Ledger File | 6 | PO | NLIN | Number of Lines | Numeric | Generic Edit | 5 | 0 |
17 | F43121 | Purchase Order Receiver File | 8 | PR | NLIN | Number of Lines | Numeric | Generic Edit | 5 | 0 |
18 | F43121T | Purchase Order Receiver Tag File | 6 | PR | NLIN | Number of Lines | Numeric | Generic Edit | 5 | 0 |
19 | F43121TB | Purchase Order Receiver Tag Table | 7 | PR | NLIN | Number of Lines | Numeric | Generic Edit | 5 | 0 |
20 | F43121Z | Receiver workfile | 7 | PW | NLIN | Number of Lines | Numeric | Generic Edit | 5 | 0 |
21 | F43121Z1 | Receipts Unedited Transaction Table | 25 | SZ | NLIN | Number of Lines | Numeric | Generic Edit | 5 | 0 |
22 | F4314Z | Voucher Match Selection File | 107 | PN | NLIN | Number of Lines | Numeric | Generic Edit | 5 | 0 |
TOP43A: Purchase Order Receipt/Routing |
23 | F43126 | Purchase Order Receiver Multiple Account | 7 | P4 | NLIN | Number of Lines | Numeric | Generic Edit | 5 | 0 |
24 | F43126T | Purchase Order Receiver Multiple Account Tag File | 7 | P4 | NLIN | Number of Lines | Numeric | Generic Edit | 5 | 0 |
TOP43E: Requisition Self Service |
25 | F43E121 | eRequisition Receiver file | 18 | ER | NLIN | Number of Lines | Numeric | Generic Edit | 5 | 0 |
TOP43S: Supplier Self Service |
26 | F4313 | POFLIP | 7 | PF | NLIN | Number of Lines | Numeric | Generic Edit | 5 | 0 |
TOP46: Warehouse Management |
27 | F4600 | Warehouse Requests | 9 | R1 | NLIN | Number of Lines | Numeric | Generic Edit | 5 | 0 |
28 | F4600PU | Warehouse Requests - Purged | 9 | R1 | NLIN | Number of Lines | Numeric | Generic Edit | 5 | 0 |
29 | F4602 | Location Detail Information | 83 | IF | NLIN | Number of Lines | Numeric | Generic Edit | 5 | 0 |
30 | F4611 | Warehouse Suggestions | 15 | R2 | NLIN | Number of Lines | Numeric | Generic Edit | 5 | 0 |
31 | F4611PU | Warehouse Suggestions - Purged | 15 | R2 | NLIN | Number of Lines | Numeric | Generic Edit | 5 | 0 |
32 | F4611Z1 | Unedited Suggestion Table | 28 | SZ | NLIN | Number of Lines | Numeric | Generic Edit | 5 | 0 |
TOP46L: License Plating |
33 | F46LUI01 | Assign/Remove Items To LP Work File | 28 | WF | NLIN | Number of Lines | Numeric | Generic Edit | 5 | 0 |
TOP47: Electronic Commerce |
34 | F47042 | EDI Invoice Detail - Inbound | 104 | SZ | NLIN | Number of Lines | Numeric | Generic Edit | 5 | 0 |
35 | F47122 | EDI Product Activity Data Detail - Inbound | 61 | MJ | NLIN | Number of Lines | Numeric | Generic Edit | 5 | 0 |
36 | F47127 | EDI Product Activity Data Detail - Outbound | 61 | MJ | NLIN | Number of Lines | Numeric | Generic Edit | 5 | 0 |
TOP49: Transportation Management |
37 | F4962 | Load Compartments | 18 | TE | NLIN | Number of Lines | Numeric | Generic Edit | 5 | 0 |
TOP55: Reserved for Clients |
38 | F74H1009 | Intrastat - Small Transaction Work Table | 7 | IS | NLIN | Number of Lines | Numeric | Generic Edit | 5 | 0 |
39 | F74U0141 | ACM - Application / Certificate Master | 7 | AC | NLIN | Number of Lines | Numeric | Generic Edit | 5 | 0 |
TOP74: EMEA Localization |
40 | F0018T | Intrastat Revision | 6 | TD | NLIN | Number of Lines | Numeric | Generic Edit | 5 | 0 |
41 | F740018 | Intrastat Revision Additional - CZE - 74 | 6 | AI | NLIN | Number of Lines | Numeric | Generic Edit | 5 | 0 |
TOP76A: Argentina |
42 | F76A393 | Calculated costs detail - 76A | 19 | C3 | NLIN | Number of Lines | Numeric | Generic Edit | 5 | 0 |
TOP76B: Brazil - Reporting System Only |
43 | F7611B | Nota Fiscal Detail - Brazil | 18 | FD | NLIN | Number of Lines | Numeric | Generic Edit | 5 | 0 |
44 | F761BA | AS Fiscal file book | 17 | FB | NLIN | Number of Lines | Numeric | Generic Edit | 5 | 0 |
TOP76H: Chile |
45 | F76H611 | Actual Item Ledger File - CHI - 41 - 76H | 1 | AL | NLIN | Number of Lines | Numeric | Generic Edit | 5 | 0 |
TOP89: Conversion Programs |
46 | F43121TA | ERP 9.0 temp F43121T for upgrade | 7 | PR | NLIN | Number of Lines | Numeric | Generic Edit | 5 | 0 |