Column | Description | Data Type | Length | Tables This Field Is In | In Query () |
CUSTNMBR | Customer Number |
String | 16 | View | |
CPRCSTNM | Corporate Customer Number |
String | 16 | View | |
DOCNUMBR | Document Number |
String | 22 | View | |
CHEKNMBR | Check Number |
String | 22 | View | |
BACHNUMB | Batch Number |
String | 16 | View | |
BCHSOURC | Batch Source |
String | 16 | View | |
TRXSORCE | TRX Source |
String | 14 | View | |
RMDTYPAL | RM Document Type-All 0 = Reserved for balance carried forward records |
Integer | 2 | View | |
DUEDATE | Due Date |
Date | 4 | View | |
DOCDATE | Document Date |
Date | 4 | View | |
POSTDATE | Post Date |
Date | 4 | View | |
PSTUSRID | Post User ID |
String | 16 | View | |
GLPOSTDT | GL Posting Date |
Date | 4 | View | |
LSTEDTDT | Last Edit Date |
Date | 4 | View | |
LSTUSRED | Last User to Edit |
String | 16 | View | |
ORTRXAMT | Original Trx Amount |
Currency | 10 | View | |
CURTRXAM | Current Trx Amount |
Currency | 10 | View | |
SLSAMNT | Sales Amount |
Currency | 10 | View | |
COSTAMNT | Cost Amount |
Currency | 10 | View | |
FRTAMNT | Freight Amount |
Currency | 10 | View | |
MISCAMNT | Misc Amount |
Currency | 10 | View | |
TAXAMNT | Tax Amount |
Currency | 10 | View | |
COMDLRAM | Commission Dollar Amount |
Currency | 10 | View | |
CASHAMNT | Cash Amount |
Currency | 10 | View | |
DISTKNAM | Discount Taken Amount |
Currency | 10 | View | |
DISAVAMT | Discount Available Amount |
Currency | 10 | View | |
DISCRTND | Discount Returned |
Currency | 10 | View | |
DISCDATE | Discount Date |
Date | 4 | View | |
DSCDLRAM | Discount Dollar Amount |
Currency | 10 | View | |
DSCPCTAM | Discount Percent Amount |
Integer | 2 | View | |
WROFAMNT | Write Off Amount |
Currency | 10 | View | |
TRXDSCRN | Transaction Description |
String | 32 | View | |
CSPORNBR | Customer Purchase Order Number |
String | 22 | View | |
SLPRSNID | Salesperson ID |
String | 16 | View | |
SLSTERCD | Sales Territory Code |
String | 16 | View | |
DINVPDOF | Date Invoice Paid Off |
Date | 4 | View | |
PPSAMDED | PPS Amount Deducted |
Currency | 10 | View | |
GSTDSAMT | GST Discount Amount |
Currency | 10 | View | |
DELETE1 | Delete |
Boolean | 2 | View | |
TAXSCHID | Tax Schedule ID |
String | 16 | View | |
SLSCHDID | Sales Schedule ID |
String | 16 | View | |
FRTSCHID | Freight Schedule ID |
String | 16 | View | |
MSCSCHID | Misc Schedule ID |
String | 16 | View | |
CURNCYID | Currency ID |
String | 16 | View | |
SHIPMTHD | Shipping Method |
String | 16 | View | |
PYMTRMID | Payment Terms ID |
String | 22 | View | |
TRDISAMT | Trade Discount Amount |
Currency | 10 | View | |
NOTEINDX | Note Index |
Currency | 10 | View | |
VOIDSTTS | Void Status 0 = Document has not been voided. |
Integer | 2 | View | |
VOIDDATE | Void Date |
Date | 4 | View | |
BALFWDNM | Balance Forward Number |
String | 22 | View | |
CSHRCTYP | Cash Receipt Type |
Integer | 2 | View | |
Tax_Date | Tax Date |
Date | 4 | View | |
APLYWITH | Apply Withholding |
Boolean | 2 | View | |
SALEDATE | Sale Date |
Date | 4 | View | |
CORRCTN | Correction |
Boolean | 2 | View | |
SIMPLIFD | Simplified |
Boolean | 2 | View | |
Electronic | Electronic |
Boolean | 2 | View | |
ECTRX | EC Transaction |
Boolean | 2 | View | |
BKTSLSAM | Backout Sales Amount |
Currency | 10 | View | |
BackoutTradeDisc | Backout Trade Discount Amount |
Currency | 10 | View | |
BKTFRTAM | Backout Freight Amount |
Currency | 10 | View | |
BKTMSCAM | Backout Misc Amount |
Currency | 10 | View | |
Factoring | Factoring |
Boolean | 2 | View | |
DIRECTDEBIT | Direct Debit |
Boolean | 2 | View | |
ADRSCODE | Address Code |
String | 16 | View | |
EFTFLAG | EFT Flag |
Boolean | 2 | View |