Column | Description | Data Type | Length | Tables This Field Is In | In Query () |
USERID | User ID |
String | 16 | View | |
TIME1 | Time |
Time | 4 | View | |
VENDORID | Vendor ID |
String | 16 | View | |
DOCTYPE | Document Type |
Integer | 2 | View | |
VCHRNMBR | Voucher Number |
String | 22 | View | |
PMVDMSGS | PM Void Messages |
Long Integer | 4 | View | |
DOCDATE | Document Date |
Date | 4 | View | |
DOCNUMBR | Document Number |
String | 22 | View | |
DOCAMNT | Document Amount |
Currency | 10 | View | |
ORDOCAMT | Originating Document Amount |
Currency | 10 | View | |
CURTRXAM | Current Trx Amount |
Currency | 10 | View | |
ORCTRXAM | Originating Current Trx Amount |
Currency | 10 | View | |
DISTKNAM | Discount Taken Amount |
Currency | 10 | View | |
ORDISTKN | Originating Discount Taken Amount |
Currency | 10 | View | |
DISCAMNT | Discount Amount |
Currency | 10 | View | |
DISCDATE | Discount Date |
Date | 4 | View | |
TRXSORCE | TRX Source |
String | 14 | View | |
TEN99AMNT | 1099 Amount |
Currency | 10 | View | |
OR1099AM | Originating 1099 Amount |
Currency | 10 | View | |
WROFAMNT | Write Off Amount |
Currency | 10 | View | |
ORWROFAM | Originating Write Off Amount |
Currency | 10 | View | |
DISAMTAV | Discount Amount Available |
Currency | 10 | View | |
ODISAMTAV | Originating Discount Amount Available |
Currency | 10 | View | |
PRCHAMNT | Purchases Amount |
Currency | 10 | View | |
OPURAMT | Originating Purchases Amount |
Currency | 10 | View | |
TRDISAMT | Trade Discount Amount |
Currency | 10 | View | |
ORTDISAM | Originating Trade Discount Amount |
Currency | 10 | View | |
MSCCHAMT | Misc Charges Amount |
Currency | 10 | View | |
ORMISCAMT | Originating Misc Amount |
Currency | 10 | View | |
FRTAMNT | Freight Amount |
Currency | 10 | View | |
ORFRTAMT | Originating Freight Amount |
Currency | 10 | View | |
TAXAMNT | Tax Amount |
Currency | 10 | View | |
ORTAXAMT | Originating Tax Amount |
Currency | 10 | View | |
TTLPYMTS | Total Payments |
Currency | 10 | View | |
OTOTPAY | Originating Total Payments |
Currency | 10 | View | |
CNTRLTYP | Control Type |
Integer | 2 | View | |
CHANGED | Changed |
Boolean | 2 | View | |
PSTGSTUS | Posting Status 1 = Work |
Integer | 2 | View | |
CHEKBKID | Checkbook ID |
String | 16 | View | |
PSTGDATE | Posting Date |
Date | 4 | View | |
CURNCYID | Currency ID |
String | 16 | View | |
DEYDESCR | Key Description |
String | 32 | View | |
VOIDDATE | Void Date |
Date | 4 | View |