Column | Description | Data Type | Length | Tables This Field Is In | In Query () |
USERID | User ID |
String | 16 | View | |
DOCTYPE | Document Type |
Integer | 2 | View | |
DOCNUMBR | Document Number |
String | 22 | View | |
VCHRNMBR | Voucher Number |
String | 22 | View | |
MODULEID | Module ID |
Integer | 2 | View | |
DOCDATE | Document Date |
Date | 4 | View | |
DUEDATE | Due Date |
Date | 4 | View | |
CustVenID | Customer Vendor ID |
String | 16 | View | |
CURTRXAM | Current Trx Amount |
Currency | 10 | View | |
ORCTRXAM | Originating Current Trx Amount |
Currency | 10 | View | |
CURNCYID | Currency ID |
String | 16 | View | |
VOIDSTTS | Void Status 0 = Document has not been voided. |
Integer | 2 | View | |
APPLDAMT | Applied Amount |
Currency | 10 | View | |
ORAPPAMT | Originating Applied Amount |
Currency | 10 | View | |
DISTKNAM | Discount Taken Amount |
Currency | 10 | View | |
ORDISTKN | Originating Discount Taken Amount |
Currency | 10 | View | |
DISAVTKN | Discount Available Taken |
Currency | 10 | View | |
ORDATKN | Originating Discount Available Taken |
Currency | 10 | View | |
TAXDTLID | Tax Detail ID |
String | 16 | View | |
GSTDSAMT | GST Discount Amount |
Currency | 10 | View | |
PPSAMDED | PPS Amount Deducted |
Currency | 10 | View |