| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
---|
| 1 | NLAN8 | Address Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 2 | NLBNK | Bank Account Number | String | Generic Edit | 34 | 0 | Allow NULL? |
| 3 | NLCRC | Payment Handling Code | String | UDC (00 HC) | 3 | 0 | Allow NULL? |
| 4 | NLBRK | Payment Account | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 5 | NLBKT | Bank Account Type | Character | UDC (74 BK) | 1 | 0 | Allow NULL? |
| 6 | NLDL01 | Description | String | Generic Edit | 30 | 0 | Allow NULL? |
| 7 | NLBKA | Bank Address Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 8 | NLSWF | Transit Number - Bank | String | Generic Edit | 34 | 0 | Allow NULL? |
| 9 | NLGPN | Payment Category Code | Character | UDC (74 GP) | 1 | 0 | Allow NULL? |
| 10 | NLKCP | Domestic Cost Code | Character | UDC (74 DC) | 1 | 0 | Allow NULL? |
| 11 | NLKGV | Correspondant Cost | Character | UDC (74 KC) | 1 | 0 | Allow NULL? |
| 12 | NLNOC | Normal or cheque | Character | UDC (74 NO) | 1 | 0 | Allow NULL? |
| 13 | NLSDD | Type of receipt | String | Generic Edit | 3 | 0 | Allow NULL? |
| 14 | NLDDT | Customer Number | String | Generic Edit | 30 | 0 | Allow NULL? |
| 15 | NLCRCD | Currency Code - From | String | Generic Edit | 3 | 0 | Allow NULL? |
| 16 | NLSWFT | SWIFT Code | String | Generic Edit | 15 | 0 | Allow NULL? |
| 17 | NLCSU | Processing Code | Character | UDC (74 SU) | 1 | 0 | Allow NULL? |
| 18 | NLCCX | Check Crossing Code | Character | UDC (74 CC) | 1 | 0 | Allow NULL? |
| 19 | NLCVC | Check Forwarding Code | Character | UDC (74 CV) | 1 | 0 | Allow NULL? |
| 20 | NLCB1 | Payment Instruction code 1 | String | UDC (74 I1) | 2 | 0 | Allow NULL? |
| 21 | NLCB2 | Payment Instruction code 2 | String | UDC (74 I1) | 2 | 0 | Allow NULL? |
| 22 | NLCB3 | Payment Instruction code 3 | String | UDC (74 I1) | 2 | 0 | Allow NULL? |
| 23 | NLCB4 | Payment Instruction code 4 | String | UDC (74 I1) | 2 | 0 | Allow NULL? |
| 24 | NLCGG | Goods code | String | UDC (74 CG) | 2 | 0 | Allow NULL? |
| 25 | NLARTN | Article Number | String | UDC (74 AN) | 2 | 0 | Allow NULL? |
| 26 | NLA1 | Nature of Payment Code 1 | String | Generic Edit | 40 | 0 | Allow NULL? |
| 27 | NLA2 | Nature of Payment Code 2 | String | Generic Edit | 40 | 0 | Allow NULL? |
| 28 | NLHAN | Trader Number | String | Generic Edit | 4 | 0 | Allow NULL? |
| 29 | NLMTB | Maximum to pay | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 30 | NLAGB | Number of remittance letters | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 31 | NLTTP | Transit type | String | UDC (74 TT) | 2 | 0 | Allow NULL? |
| 32 | NLUSER | User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 33 | NLUPMJ | Date - Updated | Date | Generic Edit | 6 | 0 | |
| 34 | NLUPMT | Time - Last Updated | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
| 35 | NLPID | Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 36 | NLJOBN | Work Station ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 37 | NLUKID | Unique Key ID (Internal) | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 38 | NLACTN | Action Code | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 39 | NLSRID | System Identification | String | Generic Edit | 8 | 0 | Allow NULL? |