| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
---|
| 1 | VBKCO | Document Company | String | Generic Edit | 5 | 0 | Allow NULL? |
| 2 | VBDOC | Document (Voucher Invoice etc.) | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 3 | VBDCT | Document Type | String | UDC (00 DT) | 2 | 0 | Allow NULL? |
| 4 | VBSFX | Document Pay Item | String | Generic Edit | 3 | 0 | Allow NULL? |
| 5 | VBSFXE | Pay Item Extension Number | Numeric | Generic Edit | 2 | 0 | Allow NULL? |
| 6 | VBAN8 | Address Number | Numeric | UDC | 8 | 0 | Allow NULL? |
| 7 | VBDDJ | Date - Net Due | Date | Generic Edit | 6 | 0 | |
| 8 | VBDGJ | Date - For G/L (and Voucher) - Julian | Date | Generic Edit | 6 | 0 | |
| 9 | VBPN | Period Number - General Ledger | Numeric | Generic Edit | 2 | 0 | Allow NULL? |
| 10 | VBFY | Fiscal Year | Numeric | Generic Edit | 2 | 0 | Allow NULL? |
| 11 | VBBRTXTT | ASU - Total Taxable Base | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 12 | VBBRRD | Reduction of IR | Numeric | Generic Edit | 5 | 2 | Allow NULL? |
| 13 | VBBRALQ | Retention/Aggregation Rate | Numeric | Generic Edit | 5 | 3 | Allow NULL? |
| 14 | VBAAP | Amount Open | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 15 | VBAA | Amount | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 16 | VBBRAAD | Deduction Amount | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 17 | VBMCU | Business Unit | String | Generic Edit | 12 | 0 | Allow NULL? |
| 18 | VBGLC | G/L Offset | String | Generic Edit | 4 | 0 | Allow NULL? |
| 19 | VBAN8J | Address Number - Alternate Payee | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 20 | VBBRRCT | Receita Code | Numeric | UDC (76B RC) | 4 | 0 | Allow NULL? |
| 21 | VBBRISS | ISS Code | Numeric | UDC (76B IS) | 4 | 0 | Allow NULL? |
| 22 | VBBRINSS | INSS Code | Numeric | UDC (76B IC) | 4 | 0 | Allow NULL? |
| 23 | VBBRTXTP | Tax Type | String | UDC (76B TR) | 2 | 0 | Allow NULL? |
| 24 | VBODCT | Document Type - Original | String | UDC (00 DT) | 2 | 0 | Allow NULL? |
| 25 | VBODOC | Document - Original | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 26 | VBVINV | Supplier Invoice Number | String | Generic Edit | 25 | 0 | Allow NULL? |
| 27 | VBTAX | Tax ID | String | Generic Edit | 20 | 0 | Allow NULL? |
| 28 | VBUSER | User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 29 | VBPID | Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 30 | VBJOBN | Work Station ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 31 | VBUPMJ | Date - Updated | Date | Generic Edit | 6 | 0 | |
| 32 | VBUPMT | Time - Last Updated | Numeric | Generic Edit | 6 | 0 | Allow NULL? |