| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP04: Accounts Payable |
1 | F0411Z1T | Voucher Transactions Batch Upload - Voucher Match Automation | 10 | VT | NLIN | Number of Lines | Numeric | Generic Edit | 5 | 0 |
TOP31B: Blend Management |
2 | F31B85 | Weigh Tag Master | 33 | WT | NLIN | Number of Lines | Numeric | Generic Edit | 5 | 0 |
3 | F31B91 | Bill Of Lading Master | 47 | BL | NLIN | Number of Lines | Numeric | Generic Edit | 5 | 0 |
TOP39: Advanced Stock Valuation |
4 | F39120 | Temporary Period Build File for Stock Valuation | 19 | TF | NLIN | Number of Lines | Numeric | Generic Edit | 5 | 0 |
5 | F39120W | Period Detail Work File | 16 | TW | NLIN | Number of Lines | Numeric | Generic Edit | 5 | 0 |
TOP40: Inventory/OP Base |
6 | F40UI002 | Supplier History Rebuild -workfile | 19 | UT | NLIN | Number of Lines | Numeric | Generic Edit | 5 | 0 |
7 | F40UI801 | Generic Error Table | 3 | ZB | NLIN | Number of Lines | Numeric | Generic Edit | 5 | 0 |
8 | F43800 | Summary Voucher Match | 7 | PR | NLIN | Number of Lines | Numeric | Generic Edit | 5 | 0 |
TOP40G: Grower Management |
9 | F40G95 | Pay On Proceeds Log File | 12 | PP | NLIN | Number of Lines | Numeric | Generic Edit | 5 | 0 |
TOP41: Inventory Management |
10 | F4111 | Item Ledger File | 1 | IL | NLIN | Number of Lines | Numeric | Generic Edit | 5 | 0 |
11 | F41291Z | Landed Cost Cache Table | 24 | IG | NLIN | Number of Lines | Numeric | Generic Edit | 5 | 0 |
12 | F41UI001 | Inventory Transactions Detail File | 4 | IT | NLIN | Number of Lines | Numeric | Generic Edit | 5 | 0 |
TOP41B: Bulk Stock Management |
13 | F41511 | Bulk Product Transaction File | 9 | PA | NLIN | Number of Lines | Numeric | Generic Edit | 5 | 0 |
14 | F41512 | Gain/Loss Transactions File | 12 | PT | NLIN | Number of Lines | Numeric | Generic Edit | 5 | 0 |
TOP43: Procurement |
15 | F43092 | Purchase Order Receipt Routing File | 6 | PX | NLIN | Number of Lines | Numeric | Generic Edit | 5 | 0 |
16 | F43092Z | Receipt Routing Work File | 11 | PV | NLIN | Number of Lines | Numeric | Generic Edit | 5 | 0 |
17 | F43092Z1 | Receipt Routing Unedited Transaction Table | 19 | SZ | NLIN | Number of Lines | Numeric | Generic Edit | 5 | 0 |
18 | F43099 | Receipt Routing Ledger File | 6 | PO | NLIN | Number of Lines | Numeric | Generic Edit | 5 | 0 |
19 | F43121 | Purchase Order Receiver File | 8 | PR | NLIN | Number of Lines | Numeric | Generic Edit | 5 | 0 |
20 | F43121T | Purchase Order Receiver Tag File | 6 | PR | NLIN | Number of Lines | Numeric | Generic Edit | 5 | 0 |
21 | F43121TB | Purchase Order Receiver Tag Table | 7 | PR | NLIN | Number of Lines | Numeric | Generic Edit | 5 | 0 |
22 | F43121Z | Receiver workfile | 7 | PW | NLIN | Number of Lines | Numeric | Generic Edit | 5 | 0 |
23 | F43121Z1 | Receipts Unedited Transaction Table | 25 | SZ | NLIN | Number of Lines | Numeric | Generic Edit | 5 | 0 |
24 | F43147 | Freight Distribution Workfile | 10 | FD | NLIN | Number of Lines | Numeric | Generic Edit | 5 | 0 |
25 | F4314Z | Voucher Match Selection File | 107 | PN | NLIN | Number of Lines | Numeric | Generic Edit | 5 | 0 |
26 | F74U0141 | ACM - Application / Certificate Master | 7 | AC | NLIN | Number of Lines | Numeric | Generic Edit | 5 | 0 |
TOP43A: Purchase Order Receipt/Routing |
27 | F43126 | Purchase Order Receiver Multiple Account | 7 | P4 | NLIN | Number of Lines | Numeric | Generic Edit | 5 | 0 |
28 | F43126T | Purchase Order Receiver Multiple Account Tag File | 7 | P4 | NLIN | Number of Lines | Numeric | Generic Edit | 5 | 0 |
29 | F43127 | Purchase Order Receiver Non-Billable | 7 | PR | NLIN | Number of Lines | Numeric | Generic Edit | 5 | 0 |
TOP43E: Requisition Self Service |
30 | F43E121 | eRequisition Receiver file | 18 | ER | NLIN | Number of Lines | Numeric | Generic Edit | 5 | 0 |
TOP43S: JSSS/Supplier Self Service |
31 | F4313 | POFLIP | 7 | PF | NLIN | Number of Lines | Numeric | Generic Edit | 5 | 0 |
TOP46: Warehouse Management |
32 | F4600 | Warehouse Requests | 9 | R1 | NLIN | Number of Lines | Numeric | Generic Edit | 5 | 0 |
33 | F4600PU | Warehouse Requests - Purged | 9 | R1 | NLIN | Number of Lines | Numeric | Generic Edit | 5 | 0 |
34 | F4602 | Location Detail Information | 83 | IF | NLIN | Number of Lines | Numeric | Generic Edit | 5 | 0 |
35 | F4611 | Warehouse Suggestions | 15 | R2 | NLIN | Number of Lines | Numeric | Generic Edit | 5 | 0 |
36 | F4611PU | Warehouse Suggestions - Purged | 15 | R2 | NLIN | Number of Lines | Numeric | Generic Edit | 5 | 0 |
37 | F4611Z1 | Unedited Suggestion Table | 28 | SZ | NLIN | Number of Lines | Numeric | Generic Edit | 5 | 0 |
TOP46L: License Plating |
38 | F46LUI01 | Assign/Remove Items To LP Work File | 28 | WF | NLIN | Number of Lines | Numeric | Generic Edit | 5 | 0 |
TOP47: Electronic Commerce |
39 | F47042 | EDI Invoice Detail - Inbound | 104 | SZ | NLIN | Number of Lines | Numeric | Generic Edit | 5 | 0 |
40 | F47122 | EDI Product Activity Data Detail - Inbound | 61 | MJ | NLIN | Number of Lines | Numeric | Generic Edit | 5 | 0 |
41 | F47127 | EDI Product Activity Data Detail - Outbound | 61 | MJ | NLIN | Number of Lines | Numeric | Generic Edit | 5 | 0 |
TOP49: Transportation Management |
42 | F4962 | Load Compartments | 18 | TE | NLIN | Number of Lines | Numeric | Generic Edit | 5 | 0 |
TOP54R: Rental Management |
43 | F54R12 | Purchase Order Receiver Rentals File | 6 | RR | NLIN | Number of Lines | Numeric | Generic Edit | 5 | 0 |
TOP74: EMEA Localization |
44 | F0018T | Intrastat Revision | 6 | TD | NLIN | Number of Lines | Numeric | Generic Edit | 5 | 0 |
45 | F740018 | Intrastat Revision Additional - CZE - 74 | 6 | AI | NLIN | Number of Lines | Numeric | Generic Edit | 5 | 0 |
46 | F740018O | Original Transaction Detail for Data Extraction | 9 | OT | NLIN | Number of Lines | Numeric | Generic Edit | 5 | 0 |
TOP74U: United Kingdom Localizations |
47 | F74U0425 | SPC - Certificate Master - UK - 43 | 98 | SF | NLIN | Number of Lines | Numeric | Generic Edit | 5 | 0 |
TOP75I: India |
48 | F75I008 | Purchase Order Receiver Tag File - IND - 43 | 7 | PO | NLIN | Number of Lines | Numeric | Generic Edit | 5 | 0 |
49 | F75I2242 | VAT- Deferred Amounts for the Purchase cycle | 5 | DA | NLIN | Number of Lines | Numeric | Generic Edit | 5 | 0 |
50 | F75I323 | Purchase Order Receiver AR3 Information - IND - 43 | 7 | RA | NLIN | Number of Lines | Numeric | Generic Edit | 5 | 0 |
51 | F75I3574 | Consignment - Issues/Receipts Transactions | 16 | CT | NLIN | Number of Lines | Numeric | Generic Edit | 5 | 0 |
52 | F75I380 | Excise - RG-1 - Transaction File - IND | 22 | RG | NLIN | Number of Lines | Numeric | Generic Edit | 5 | 0 |
53 | F75I402 | Purchase Tax Form Details | 5 | PT | NLIN | Number of Lines | Numeric | Generic Edit | 5 | 0 |
54 | F75I402T | Purchase Tax Form Details -Secondary | 5 | PT | NLIN | Number of Lines | Numeric | Generic Edit | 5 | 0 |
55 | F75I741 | Service Tax A/P File - IND - 04 | 14 | ST | NLIN | Number of Lines | Numeric | Generic Edit | 5 | 0 |
TOP76A: Argentina |
56 | F76A393 | Calculated costs detail - 76A | 19 | C3 | NLIN | Number of Lines | Numeric | Generic Edit | 5 | 0 |
TOP76B: Brazil |
57 | F7611B | Nota Fiscal Detail - BRA - 42 | 18 | FD | NLIN | Number of Lines | Numeric | Generic Edit | 5 | 0 |
58 | F761BA | AS Fiscal file book - 09 | 17 | FB | NLIN | Number of Lines | Numeric | Generic Edit | 5 | 0 |
TOP76H: Chile |
59 | F76H611 | Actual Item Ledger File - CHI - 41 - 76H | 1 | AL | NLIN | Number of Lines | Numeric | Generic Edit | 5 | 0 |
TOP89: Conversion Programs |
60 | F43121TA | ERP 9.0 temp F43121T for upgrade | 7 | PR | NLIN | Number of Lines | Numeric | Generic Edit | 5 | 0 |