| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
---|
| 1 | VNUKID | Unique Key ID (Internal) | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 2 | VNDOC | Document (Voucher Invoice etc.) | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 3 | VNDCT | Document Type | String | UDC (00 DT) | 2 | 0 | Allow NULL? |
| 4 | VNCO | Company | String | Generic Edit | 5 | 0 | Allow NULL? |
| 5 | VNDGJ | Date - For G/L (and Voucher) - Julian | Date | Generic Edit | 6 | 0 | |
| 6 | VNEXA | Name - Alpha Explanation | String | Generic Edit | 30 | 0 | Allow NULL? |
| 7 | VNSDTE | Date - Stop | Date | Generic Edit | 6 | 0 | |
| 8 | VNRF | Frequency - Recurring | String | UDC (H00 RF) | 2 | 0 | Allow NULL? |
| 9 | VNPOSG | Posting Group | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 10 | VNSEN | Posting Sequence | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 11 | VNHST | Status Code | Character | UDC (H00 HS) | 1 | 0 | Allow NULL? |
| 12 | VNREVR | Reverse | Character | UDC (H09 RF) | 1 | 0 | Allow NULL? |
| 13 | VNGCFL | Allocation Basis Flag | Character | UDC (09 GF) | 1 | 0 | Allow NULL? |
| 14 | VNSRCV | Source Version | String | Generic Edit | 10 | 0 | Allow NULL? |
| 15 | VNRFAC | Rate Factor | Numeric | Generic Edit | 15 | 8 | Allow NULL? |
| 16 | VNFLT | From Ledger Type | String | Generic Edit | 2 | 0 | Allow NULL? |
| 17 | VNSULF | Source Units Ledger Flag | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 18 | VNUM | Unit of Measure | String | UDC (00 UM) | 2 | 0 | Allow NULL? |
| 19 | VNFMYIU | Source Period Basis Amounts | Character | UDC (09 AU) | 1 | 0 | Allow NULL? |
| 20 | VNFPN | From Period Number - General Ledger | Numeric | Generic Edit | 2 | 0 | Allow NULL? |
| 21 | VNFFY | From Fiscal Year | Numeric | Generic Edit | 2 | 0 | Allow NULL? |
| 22 | VNFCTY | From Century - General Ledger | Numeric | Generic Edit | 2 | 0 | Allow NULL? |
| 23 | VNGCAT | Source Amount Type | Character | UDC (09 AT) | 1 | 0 | Allow NULL? |
| 24 | VNSPGS | Source Pool Grouping Source | Character | UDC (09 PG) | 1 | 0 | Allow NULL? |
| 25 | VNSPIDV | Source Pool Id Version | String | Generic Edit | 10 | 0 | Allow NULL? |
| 26 | VNBASV | Basis Version | String | Generic Edit | 10 | 0 | Allow NULL? |
| 27 | VNBASR | Basis Ratio | String | UDC (09 RT) | 2 | 0 | Allow NULL? |
| 28 | VNBLT | Based Upon Thru Ledger Type | String | Generic Edit | 2 | 0 | Allow NULL? |
| 29 | VNBMYIU | Basis Period Basis Amounts | Character | UDC (09 AU) | 1 | 0 | Allow NULL? |
| 30 | VNBPNO | Based Upon Period Number | Numeric | Generic Edit | 2 | 0 | Allow NULL? |
| 31 | VNBFY | Based Upon Fiscal Year | Numeric | Generic Edit | 2 | 0 | Allow NULL? |
| 32 | VNBCTR | Base Century | Numeric | Generic Edit | 2 | 0 | Allow NULL? |
| 33 | VNBGAT | Basis Amount Type | Character | UDC (09 AT) | 1 | 0 | Allow NULL? |
| 34 | VNBPGS | Basis Pool Grouping Source | Character | UDC (09 PG) | 1 | 0 | Allow NULL? |
| 35 | VNBPIDV | Basis Pool Id Version | String | Generic Edit | 10 | 0 | Allow NULL? |
| 36 | VNALTA | Apply To Ledger Type | String | Generic Edit | 2 | 0 | Allow NULL? |
| 37 | VNDBUF | Destination Business Unit Flag | Character | UDC (09 BF) | 1 | 0 | Allow NULL? |
| 38 | VNDEBU | Destination Business Unit | String | Generic Edit | 12 | 0 | Allow NULL? |
| 39 | VNOVERRDE | Override Name | String | Generic Edit | 5 | 0 | Allow NULL? |
| 40 | VNDOAF | Destination Object Account Flag | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 41 | VNAOBA | Apply To Object Account | String | Generic Edit | 6 | 0 | Allow NULL? |
| 42 | VNDSUF | Destination Subsidiary Flag | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 43 | VNASBA | Apply To Subsidiary | String | Generic Edit | 8 | 0 | Allow NULL? |
| 44 | VNDSLF | Destination Subledger Flag | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 45 | VNASBL | Apply To Subledger | String | Generic Edit | 8 | 0 | Allow NULL? |
| 46 | VNASBT | Apply To Subledger Type | Character | UDC (00 ST) | 1 | 0 | Allow NULL? |
| 47 | VNOFBF | Offset Business Unit Flag | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 48 | VNOFBU | Offset Business Unit | String | Generic Edit | 12 | 0 | Allow NULL? |
| 49 | VNOOBF | Offset Object Account Flag | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 50 | VNOOBJ | Offset Object Account | String | Generic Edit | 6 | 0 | Allow NULL? |
| 51 | VNOSUF | Offset Subsidiary Flag | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 52 | VNOSUB | Offset Subsidiary | String | Generic Edit | 8 | 0 | Allow NULL? |
| 53 | VNOSBF | Offset Subledger Flag | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 54 | VNOSBL | Offset Subledger | String | Generic Edit | 8 | 0 | Allow NULL? |
| 55 | VNOSBT | Offset Subledger Type | Character | UDC (00 ST) | 1 | 0 | Allow NULL? |
| 56 | VNAN8 | Address Number | Numeric | UDC | 8 | 0 | Allow NULL? |
| 57 | VNAHBU | Alternate Home Business Unit | String | Generic Edit | 12 | 0 | Allow NULL? |
| 58 | VNJBCD | Job Type (Craft) Code | String | UDC (06 G) | 6 | 0 | Allow NULL? |
| 59 | VNJBST | Job Step | String | UDC (06 GS) | 4 | 0 | Allow NULL? |
| 60 | VNJPGCF | Job Pool Grouping Code Flag | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 61 | VNPID | Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 62 | VNUSER | User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 63 | VNJOBN | Work Station ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 64 | VNUPMJ | Date - Updated | Date | Generic Edit | 6 | 0 | |
| 65 | VNUPMT | Time - Last Updated | Numeric | Generic Edit | 6 | 0 | Allow NULL? |