| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
---|
| 1 | AYBKTP | Record Type - Bank Transit | Character | UDC (00 BT) | 1 | 0 | Allow NULL? |
| 2 | AYTNST | Transit Number - Bank | String | Generic Edit | 20 | 0 | Allow NULL? |
| 3 | AYCBNK | Bank Account Number - Customer | String | Generic Edit | 20 | 0 | Allow NULL? |
| 4 | AYAN8 | Address Number | Numeric | UDC | 8 | 0 | Allow NULL? |
| 5 | AYDL01 | Description | String | Generic Edit | 30 | 0 | Allow NULL? |
| 6 | AYAID | Account ID | String | Generic Edit | 8 | 0 | Allow NULL? |
| 7 | AYNXTC | Next Payment Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 8 | AYCHKD | Bank Account - Control Digit | String | Generic Edit | 2 | 0 | Allow NULL? |
| 9 | AYCRCD | Currency Code - From | String | Generic Edit | 3 | 0 | Allow NULL? |
| 10 | AYRLN | BACS System-Reference/Roll Number | String | Generic Edit | 18 | 0 | Allow NULL? |
| 11 | AYBACS | Bank System - User Number | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
| 12 | AYRFNM | Bank System - Reference Name | String | Generic Edit | 18 | 0 | Allow NULL? |
| 13 | AYBAID | Bank Transit Short ID | String | Generic Edit | 8 | 0 | Allow NULL? |
| 14 | AYMCU | Business Unit | String | Generic Edit | 12 | 0 | Allow NULL? |
| 15 | AYSWFT | SWIFT Code | String | Generic Edit | 15 | 0 | Allow NULL? |
| 16 | AYADPI | Pre-Note Option Code | Character | UDC (H00 AD) | 1 | 0 | Allow NULL? |
| 17 | AYCHKQ | Payment Print Queue | String | Generic Edit | 10 | 0 | Allow NULL? |
| 18 | AYATTQ | Payment Attachment Print Queue | String | Generic Edit | 10 | 0 | Allow NULL? |
| 19 | AYDBTQ | Payment Debit Statement Print Queue | String | Generic Edit | 10 | 0 | Allow NULL? |
| 20 | AYALGN | Number of Alignment Checks | Numeric | Generic Edit | 4 | 0 | Allow NULL? |
| 21 | AYSDTL | Detail Lines per A/P Payment Stub | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
| 22 | AYFLR | Float Days for Checks - Receivables | Numeric | Generic Edit | 3 | 0 | Allow NULL? |
| 23 | AYFLP | Float Days for Checks - Payables | Numeric | Generic Edit | 3 | 0 | Allow NULL? |
| 24 | AYCKSV | Checking or Savings Account | Character | UDC (H00 CK) | 1 | 0 | Allow NULL? |
| 25 | AYUKID | Unique Key ID (Internal) | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 26 | AYCTR | Country | String | UDC (00 CN) | 3 | 0 | Allow NULL? |
| 27 | AYNXTA | Next Automatic Debit Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 28 | AYUPMJ | Date - Updated | Date | Generic Edit | 6 | 0 | |
| 29 | AYUPMT | Time - Last Updated | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
| 30 | AYPID | Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 31 | AYUSER | User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 32 | AYJOBN | Work Station ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 33 | AYIBAN | International Bank Account Number | String | Generic Edit | 34 | 0 | Allow NULL? |
| 34 | AYAN8BK | Address Number - Bank | Numeric | Generic Edit | 8 | 0 | Allow NULL? |