Column | Description | Data Type | Length | Tables This Field Is In | In Query () |
DOCTYPE | Document Type |
Integer | 2 | View | |
RMDTYPAL | RM Document Type-All 0 = Reserved for balance carried forward records |
Integer | 2 | View | |
RMDNUMWK | RM Document Number-WORK |
String | 18 | View | |
DOCNUMBR | Document Number |
String | 22 | View | |
DOCPRFIX | Document Prefix |
String | 4 | View | |
DOCDESCR | Document Description |
String | 32 | View | |
DOCDATE | Document Date |
Date | 4 | View | |
BACHNUMB | Batch Number |
String | 16 | View | |
BCHSOURC | Batch Source |
String | 16 | View | |
NOTEINDX | Note Index |
Currency | 10 | View | |
CUSTNMBR | Customer Number |
String | 16 | View | |
CUSTNAME | Customer Name |
String | 66 | View | |
ADRSCODE | Address Code |
String | 16 | View | |
SLPRSNID | Salesperson ID |
String | 16 | View | |
SALSTERR | Sales Territory |
String | 16 | View | |
COMAPPTO | Commission Applied To |
Integer | 2 | View | |
COMDLRAM | Commission Dollar Amount |
Currency | 10 | View | |
NCOMAMNT | Non-Commissioned Amount |
Currency | 10 | View | |
SHIPMTHD | Shipping Method |
String | 16 | View | |
CSTPONBR | Customer PO Number |
String | 22 | 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 | |
COSTAMNT | Cost Amount |
Currency | 10 | View | |
SLSAMNT | Sales Amount |
Currency | 10 | View | |
TRDISAMT | Trade Discount Amount |
Currency | 10 | View | |
TRDDISCT | Trade Discount |
Integer | 2 | View | |
FRTAMNT | Freight Amount |
Currency | 10 | View | |
MISCAMNT | Misc Amount |
Currency | 10 | View | |
TAXAMNT | Tax Amount |
Currency | 10 | View | |
BKTSLSAM | Backout Sales Amount |
Currency | 10 | View | |
BKTFRTAM | Backout Freight Amount |
Currency | 10 | View | |
BKTMSCAM | Backout Misc Amount |
Currency | 10 | View | |
TXENGCLD | Tax Engine Called |
Boolean | 2 | View | |
DOCAMNT | Document Amount |
Currency | 10 | View | |
APPLDAMT | Applied Amount |
Currency | 10 | View | |
CASHAMNT | Cash Amount |
Currency | 10 | View | |
CBKIDCSH | Checkbook ID Cash |
String | 16 | View | |
CASHDATE | Cash Date |
Date | 4 | View | |
DCNUMCSH | Document Number Cash |
String | 22 | View | |
CHEKAMNT | Check Amount |
Currency | 10 | View | |
CBKIDCHK | Checkbook ID Check |
String | 16 | View | |
CBKIDCRD | Checkbook ID Credit Card |
String | 16 | View | |
CHEKNMBR | Check Number |
String | 22 | View | |
CHEKDATE | Check Date |
Date | 4 | View | |
DCNUMCHK | Document Number Check |
String | 22 | View | |
CRCRDAMT | Credit Card Amount |
Currency | 10 | View | |
CRCRDNAM | Credit Card Name |
String | 16 | View | |
RCTNCCRD | Receipt Number Credit Card |
String | 22 | View | |
CRCARDDT | Credit Card Date |
Date | 4 | View | |
DCNUMCRD | Document Number Credit Card |
String | 22 | View | |
DISCRTND | Discount Returned |
Currency | 10 | View | |
DISTKNAM | Discount Taken Amount |
Currency | 10 | View | |
DISAVTKN | Discount Available Taken |
Currency | 10 | View | |
WROFAMNT | Write Off Amount |
Currency | 10 | View | |
PPSAMDED | PPS Amount Deducted |
Currency | 10 | View | |
GSTDSAMT | GST Discount Amount |
Currency | 10 | View | |
ACCTAMNT | Account Amount |
Currency | 10 | View | |
PYMTRMID | Payment Terms ID |
String | 22 | View | |
DISAVAMT | Discount Available Amount |
Currency | 10 | View | |
DISCDATE | Discount Date |
Date | 4 | View | |
DUEDATE | Due Date |
Date | 4 | View | |
DSCDLRAM | Discount Dollar Amount |
Currency | 10 | View | |
DSCPCTAM | Discount Percent Amount |
Integer | 2 | View | |
CURNCYID | Currency ID |
String | 16 | View | |
POSTED | Posted |
Boolean | 2 | View | |
LSTEDTDT | Last Edit Date |
Date | 4 | View | |
LSTUSRED | Last User to Edit |
String | 16 | View | |
RMTREMSG | RM TRX Posting Error Messages |
Long Integer | 4 | View | |
RMDPEMSG | RM Dist Posting Error Messages |
Long Integer | 4 | View | |
GLPOSTDT | GL Posting Date |
Date | 4 | View | |
POSTEDDT | Posted Date |
Date | 4 | View | |
PTDUSRID | Posted User ID |
String | 16 | View |