| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP00: Foundation Environment |
1 | F0911 | Account Ledger | 133 | GL | DLNID | DistributionLine Number | Numeric | Generic Edit | 6 | 3 |
TOP09: General Accounting |
2 | F0911P | Purge - Account Ledger | 133 | GL | DLNID | DistributionLine Number | Numeric | Generic Edit | 6 | 3 |
3 | F0911Z1 | Journal Entry Transactions - Batch File | 185 | VN | DLNID | DistributionLine Number | Numeric | Generic Edit | 6 | 3 |
4 | F0911Z4 | F0911 Interoperability Table | 160 | SZ | DLNID | DistributionLine Number | Numeric | Generic Edit | 6 | 3 |
TOP40: Inventory/OP Base |
5 | F4209 | Held Orders | 25 | HO | DLNID | DistributionLine Number | Numeric | Generic Edit | 6 | 3 |
TOP42: Sales Management |
6 | F42800G1 | Sales Update G Batch Detail Workfile | 124 | DG | DLNID | DistributionLine Number | Numeric | Generic Edit | 6 | 3 |
TOP43: Procurement |
7 | F43147 | Freight Distribution Workfile | 11 | FD | DLNID | DistributionLine Number | Numeric | Generic Edit | 6 | 3 |
8 | F4314Z | Voucher Match Selection File | 4 | PN | DLNID | DistributionLine Number | Numeric | Generic Edit | 6 | 3 |
9 | F4316 | Purchase Order Multiple Account File | 6 | P3 | DLNID | DistributionLine Number | Numeric | Generic Edit | 6 | 3 |
10 | F4316T | Purchase Order Multiple Account Tag File | 6 | P3 | DLNID | DistributionLine Number | Numeric | Generic Edit | 6 | 3 |
11 | F4317 | Purchase Order Detail Non-Billable | 6 | PD | DLNID | DistributionLine Number | Numeric | Generic Edit | 6 | 3 |
12 | F43199 | P.O. Detail Ledger File - Flexible Version | 213 | OL | DLNID | DistributionLine Number | Numeric | Generic Edit | 6 | 3 |
13 | F43632Z | Open Purchase Order by Item Work File | 10 | OI | DLNID | DistributionLine Number | Numeric | Generic Edit | 6 | 3 |
TOP43A: Purchase Order Receipt/Routing |
14 | F43126 | Purchase Order Receiver Multiple Account | 8 | P4 | DLNID | DistributionLine Number | Numeric | Generic Edit | 6 | 3 |
15 | F43126T | Purchase Order Receiver Multiple Account Tag File | 8 | P4 | DLNID | DistributionLine Number | Numeric | Generic Edit | 6 | 3 |
16 | F43127 | Purchase Order Receiver Non-Billable | 8 | PR | DLNID | DistributionLine Number | Numeric | Generic Edit | 6 | 3 |
TOP43B: Voucher Match and Landed Cost |
17 | F43146T | Voucher Match Multiple Account Tag File | 6 | P5 | DLNID | DistributionLine Number | Numeric | Generic Edit | 6 | 3 |
TOP43E: Requisition Self Service |
18 | F43E16 | Requisition Multiple Account File | 6 | P3 | DLNID | DistributionLine Number | Numeric | Generic Edit | 6 | 3 |