| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP00: Foundation Environment |
| 1 | F0030 | Bank Transit Master | 1 | AY | BKTP | Record Type - Bank Transit | Character | UDC | 1 | 0 |
| TOP04: Accounts Payable |
| 2 | F0030W | Bank Account/Supplier Number Worktable | 2 | AX | BKTP | Record Type - Bank Transit | Character | UDC | 1 | 0 |
| 3 | F0401M | Multiple Vendor Bank Account Status | 2 | A6 | BKTP | Record Type - Bank Transit | Character | UDC | 1 | 0 |
| 4 | F0417M | Multiple Vendor Bank Account Types | 3 | KB | BKTP | Record Type - Bank Transit | Character | UDC | 1 | 0 |
| TOP74D: Germany - Reporting System Only |
| 5 | F74030G | Germany-Bank Transit Number Master - Addtl Informatio - 04 | 1 | AY | BKTP | Record Type - Bank Transit | Character | UDC | 1 | 0 |
| TOP89: Conversion Programs |
| 6 | F7460 | Next Auto Debit Number | 1 | QL | BKTP | Record Type - Bank Transit | 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 00 / BT (Bank Type Code) stock values
| Value | Description | Special Handling Code | Hard Coded |
|---|
| 1 | B | Valid Bank Transit Numbers | | N |
| 2 | C | Customer Bank Account | | N |
| 3 | D | Default-A/R Drafts, Auto Debit | | N |
| 4 | G | Internal G/L Bank Account | | N |
| 5 | H | Dutch Bank Accounts | | N |
| 6 | M | G/L Bank/CC for A/P Payments | | N |
| 7 | O | Foreign Originator DFI | | Y |
| 8 | P | Auto Receipts Payor | | Y |
| 9 | R | Foreign Receiver DFI | | Y |
| 10 | V | Vendor Bank Acct - Bank Tape | | N |
| 11 | X | Vendor Bank Acct - Alternate | | N |
| 12 | Y | Vendor Bank Acct - Multiple | | N |
