| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
---|
| 1 | BRAN8 | Address Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 2 | BRCRRP | Currency Code - Accounts Payable | String | Generic Edit | 3 | 0 | Allow NULL? |
| 3 | BRCRCA | Currency Code - A/B Amounts | String | Generic Edit | 3 | 0 | Allow NULL? |
| 4 | BRTRAP | Payment Terms - A/P | String | Generic Edit | 3 | 0 | Allow NULL? |
| 5 | BRTAX | Tax ID | String | Generic Edit | 20 | 0 | Allow NULL? |
| 6 | BRTAXC | Person/Corporation Code | Character | UDC (H00 TA) | 1 | 0 | Allow NULL? |
| 7 | BRTX2 | Tax ID - Additional - Individual | String | Generic Edit | 20 | 0 | Allow NULL? |
| 8 | BRPYIN | Payment Instrument | Character | UDC (00 PY) | 1 | 0 | Allow NULL? |
| 9 | BREDPM | Batch Processing Mode | Character | UDC (H40 EE) | 1 | 0 | Allow NULL? |
| 10 | BREDII | Item Type Identifier | Character | UDC (40 II) | 1 | 0 | Allow NULL? |
| 11 | BREDQD | Quantity Decimals | Numeric | Generic Edit | 1 | 0 | Allow NULL? |
| 12 | BREDAD | Amount Decimals | Numeric | Generic Edit | 1 | 0 | Allow NULL? |
| 13 | BRMINO | Minimum Order Value | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 14 | BRMAXO | Maximum Order Value | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 15 | BRVUMD | Unit of Measure - Volume Display | String | UDC (00 UM) | 2 | 0 | Allow NULL? |
| 16 | BRWUMD | Unit of Measure - Weight Display | String | UDC (00 UM) | 2 | 0 | Allow NULL? |
| 17 | BRFRTH | Freight Handling Code | String | UDC (42 FR) | 3 | 0 | Allow NULL? |
| 18 | BRDEL1 | Delivery Instructions Line 1 | String | Generic Edit | 30 | 0 | Allow NULL? |
| 19 | BRDAYEXPIR | Number of Days Expiration | Numeric | Generic Edit | 3 | 0 | Allow NULL? |
| 20 | BRDAYSDUE | Number of Days Due | Numeric | Generic Edit | 3 | 0 | Allow NULL? |
| 21 | BRDAYAWARD | Number of Days Awarded | Numeric | Generic Edit | 3 | 0 | Allow NULL? |
| 22 | BRDAYOUTB | Number of Days Out | Numeric | Generic Edit | 3 | 0 | Allow NULL? |
| 23 | BRURCD | User Reserved Code | String | Generic Edit | 2 | 0 | Allow NULL? |
| 24 | BRURDT | User Reserved Date | Date | Generic Edit | 6 | 0 | |
| 25 | BRURAT | User Reserved Amount | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 26 | BRURAB | User Reserved Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 27 | BRURRF | User Reserved Reference | String | Generic Edit | 15 | 0 | Allow NULL? |
| 28 | BRTORG | Transaction Originator | String | Generic Edit | 10 | 0 | Allow NULL? |
| 29 | BRUSER | User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 30 | BRPID | Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 31 | BRJOBN | Work Station ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 32 | BRUPMJ | Date - Updated | Date | Generic Edit | 6 | 0 | |
| 33 | BRTDAY | Time of Day | Numeric | Generic Edit | 6 | 0 | Allow NULL? |