| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP00: Foundation Environment |
| 1 | F0401Z1 | Supplier Master - Batch Upload | 37 | VO | SQNL | Ledger Inquiry Sequence | Character | UDC | 1 | 0 |
| TOP01: Address Book |
| 2 | F0401 | Supplier Master | 23 | A6 | SQNL | Ledger Inquiry Sequence | Character | UDC | 1 | 0 |
| TOP03: Accounts Receivable |
| 3 | F03012 | Customer Master by Line of Business | 22 | AI | SQNL | Ledger Inquiry Sequence | Character | UDC | 1 | 0 |
| 4 | F03012Z1 | Customer Master LOB-Batch Table | 35 | VO | SQNL | Ledger Inquiry Sequence | Character | UDC | 1 | 0 |
User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.
TOPUDC H01 / SQ (Account Ledger Sequence Code) stock values
| Value | Description | Special Handling Code | Hard Coded |
|---|
| 1 | 1 | Document number | | N |
| 2 | 2 | Net due date | | N |
| 3 | 3 | Invoice date | | N |
| 4 | 4 | Stmnt # (A/R) or Inv # (A/P) | | N |
| 5 | 5 | PO number | | N |
| 6 | 6 | Document type, document number | | N |
| 7 | 7 | Matching document (A/R only) | | N |
| 8 | 8 | G/L date | | N |
| 9 | A | Summarized by document | | N |
| 10 | B | Summarized by due dte/document | | N |
