| 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 |