| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP40: Inventory/OP Base |
1 | F43800 | Summary Voucher Match | 1 | PR | MATC | Type - Match Record Type | Character | Generic Edit | 1 | 0 |
TOP43: Procurement |
2 | F43121 | Purchase Order Receiver File | 1 | PR | MATC | Type - Match Record Type | Character | Generic Edit | 1 | 0 |
3 | F43121T | Purchase Order Receiver Tag File | 1 | PR | MATC | Type - Match Record Type | Character | Generic Edit | 1 | 0 |
4 | F43121TB | Purchase Order Receiver Tag Table | 1 | PR | MATC | Type - Match Record Type | Character | Generic Edit | 1 | 0 |
5 | F43121Z1 | Receipts Unedited Transaction Table | 18 | SZ | MATC | Type - Match Record Type | Character | Generic Edit | 1 | 0 |
6 | F4314Z | Voucher Match Selection File | 100 | PN | MATC | Type - Match Record Type | Character | Generic Edit | 1 | 0 |
7 | F74U0141 | ACM - Application / Certificate Master | 8 | AC | MATC | Type - Match Record Type | Character | Generic Edit | 1 | 0 |
TOP43A: Purchase Order Receipt/Routing |
8 | F43126 | Purchase Order Receiver Multiple Account | 1 | P4 | MATC | Type - Match Record Type | Character | Generic Edit | 1 | 0 |
9 | F43126T | Purchase Order Receiver Multiple Account Tag File | 1 | P4 | MATC | Type - Match Record Type | Character | Generic Edit | 1 | 0 |
10 | F43127 | Purchase Order Receiver Non-Billable | 1 | PR | MATC | Type - Match Record Type | Character | Generic Edit | 1 | 0 |
TOP43E: Requisition Self Service |
11 | F43E121 | eRequisition Receiver file | 17 | ER | MATC | Type - Match Record Type | Character | Generic Edit | 1 | 0 |
TOP47: Electronic Commerce |
12 | F47032T | EDI Shipping Notice Detail- Inbound Tag | 19 | SZ | MATC | Type - Match Record Type | Character | Generic Edit | 1 | 0 |
TOP54R: Rental Management |
13 | F54R12 | Purchase Order Receiver Rentals File | 44 | RR | MATC | Type - Match Record Type | Character | Generic Edit | 1 | 0 |
TOP74U: United Kingdom Localizations |
14 | F74U0422 | SPC Application/Certificate Cross Reference File - UK - 43 | 9 | AC | MATC | Type - Match Record Type | Character | Generic Edit | 1 | 0 |
15 | F74U0425 | SPC - Certificate Master - UK - 43 | 9 | SF | MATC | Type - Match Record Type | Character | Generic Edit | 1 | 0 |
TOP75I: India |
16 | F75I008 | Purchase Order Receiver Tag File - IND - 43 | 1 | PO | MATC | Type - Match Record Type | Character | Generic Edit | 1 | 0 |
17 | F75I309 | Personal Consumption - CENVAT setoff - IND - 41 | 22 | CS | MATC | Type - Match Record Type | Character | Generic Edit | 1 | 0 |
18 | F75I323 | Purchase Order Receiver AR3 Information - IND - 43 | 1 | RA | MATC | Type - Match Record Type | Character | Generic Edit | 1 | 0 |
19 | F75I346 | Excise - D3-Form Table | 41 | Q9 | MATC | Type - Match Record Type | Character | Generic Edit | 1 | 0 |
20 | F75I409 | Personal Consumption - VAT setoff - IND - 41 | 12 | VS | MATC | Type - Match Record Type | Character | Generic Edit | 1 | 0 |
21 | F75I741 | Service Tax A/P File - IND - 04 | 8 | ST | MATC | Type - Match Record Type | Character | Generic Edit | 1 | 0 |
TOP76B: Brazil |
22 | F7611B | Nota Fiscal Detail - BRA - 42 | 12 | FD | MATC | Type - Match Record Type | Character | Generic Edit | 1 | 0 |
23 | F761BA | AS Fiscal file book - 09 | 11 | FB | MATC | Type - Match Record Type | Character | Generic Edit | 1 | 0 |
TOP89: Conversion Programs |
24 | F43121TA | ERP 9.0 temp F43121T for upgrade | 1 | PR | MATC | Type - Match Record Type | Character | Generic Edit | 1 | 0 |