Column | Description | Data Type | Length | Tables This Field Is In | In Query () |
VENDORID | Vendor ID |
String | 16 | View | |
VENDNAME | Vendor Name |
String | 66 | View | |
DOCNUMBR | Document Number |
String | 22 | View | |
VNDCHKNM | Vendor Check Name |
String | 66 | View | |
DOCTYPE | Document Type |
Integer | 2 | View | |
PMTDOCID | PmntDocID |
String | 16 | View | |
CHEKNMBR | Check Number |
String | 22 | View | |
PDOCSTPM | PmntDocStatePM |
Integer | 2 | View | |
CHEKBKID | Checkbook ID |
String | 16 | View | |
DOCDATE | Document Date |
Date | 4 | View | |
DUEDATE | Due Date |
Date | 4 | View | |
DOCAMNT | Document Amount |
Currency | 10 | View | |
ORDOCAMT | Originating Document Amount |
Currency | 10 | View | |
CURNCYID | Currency ID |
String | 16 | View | |
CURRNIDX | Currency Index |
Integer | 2 | View | |
TRXDSCRN | Transaction Description |
String | 32 | View | |
NOTEINDX | Note Index |
Currency | 10 | View | |
VALSTRG1 | ValueUserDefnStr1 |
String | 66 | View | |
VALSTRG2 | ValueUserDefnStr2 |
String | 66 | View | |
VALSTRG3 | ValueUserDefnStr3 |
String | 66 | View | |
VALSTRG4 | ValueUserDefnStr4 |
String | 66 | View | |
VALSTRG5 | ValueUserDefnStr5 |
String | 66 | View | |
VALSTRG6 | ValueUserDefnStr6 |
String | 66 | View | |
VALDATE1 | ValueUserDefnDate1 |
Date | 4 | View | |
VALDATE2 | ValueUserDefnDate2 |
Date | 4 | View | |
VALCURR1 | ValueUserDefnCurr1 |
Currency | 10 | View | |
VALCURR2 | ValueUserDefnCurr2 |
Currency | 10 | View | |
VALBACT1 | ValueUserDefnBankAcct1 |
String | 36 | View | |
VALBACT2 | ValueUserDefnBankAcct2 |
String | 36 | View | |
TRXSORCE | TRX Source |
String | 14 | View | |
UPDATED | Updated |
Boolean | 2 | View |