Column | Description | Data Type | Length | Tables This Field Is In | In Query () |
DOCTYPE | Document Type |
Integer | 2 | View | |
INVCNMBR | Invoice Number |
String | 22 | View | |
BACHNUMB | Batch Number |
String | 16 | View | |
BCHSOURC | Batch Source |
String | 16 | View | |
PCKSLPNO | Packing Slip Number |
String | 22 | View | |
CUSTNMBR | Customer Number |
String | 16 | View | |
CUSTNAME | Customer Name |
String | 66 | View | |
CSTPONBR | Customer PO Number |
String | 22 | View | |
POSTDATE | Post Date |
Date | 4 | View | |
GLPOSTDT | GL Posting Date |
Date | 4 | View | |
DOCDATE | Document Date |
Date | 4 | View | |
QUOTEDAT | Quote Date |
Date | 4 | View | |
ORDRDATE | Order Date |
Date | 4 | View | |
DISCDATE | Discount Date |
Date | 4 | View | |
DUEDATE | Due Date |
Date | 4 | View | |
HOLDNT | Hold NT |
Boolean | 2 | View | |
SHIPMTHD | Shipping Method |
String | 16 | View | |
TAXEXMT1 | Tax Exempt 1 |
String | 26 | View | |
TAXEXMT2 | Tax Exempt 2 |
String | 26 | View | |
TAXSCHID | Tax Schedule ID |
String | 16 | View | |
FRTSCHID | Freight Schedule ID |
String | 16 | View | |
FRGTTXBL | Freight Taxable 1 = Taxable |
Integer | 2 | View | |
FRTTXAMT | Freight Tax Amount |
Currency | 10 | View | |
MSCSCHID | Misc Schedule ID |
String | 16 | View | |
MISCTXBL | Misc Taxable 1 = Taxable |
Integer | 2 | View | |
MSCTXAMT | Misc Tax Amount |
Currency | 10 | View | |
MRKDNAMT | Markdown Amount |
Currency | 10 | View | |
SLPRSNID | Salesperson ID |
String | 16 | View | |
SALSTERR | Sales Territory |
String | 16 | View | |
TXRGNNUM | Tax Registration Number |
String | 26 | View | |
PYMTRMID | Payment Terms ID |
String | 22 | View | |
PRCLEVEL | PriceLevel |
String | 12 | View | |
LOCNCODE | Location Code |
String | 12 | View | |
CURNCYID | Currency ID |
String | 16 | View | |
COMMNTID | Comment ID |
String | 16 | View | |
DOCAMNT | Document Amount |
Currency | 10 | View | |
SUBTOTAL | Subtotal |
Currency | 10 | View | |
FRTAMNT | Freight Amount |
Currency | 10 | View | |
MISCAMNT | Misc Amount |
Currency | 10 | View | |
TAXAMNT | Tax Amount |
Currency | 10 | View | |
TXBTXAMT | Taxable Tax Amount |
Currency | 10 | View | |
TRDISAMT | Trade Discount Amount |
Currency | 10 | View | |
ACCTAMNT | Account Amount |
Currency | 10 | View | |
PYMTRCVD | Payment Received |
Currency | 10 | View | |
CODAMNT | COD Amount |
Currency | 10 | View | |
EXTDCOST | Extended Cost |
Currency | 10 | View | |
DISAVTKN | Discount Available Taken |
Currency | 10 | View | |
DISCRTND | Discount Returned |
Currency | 10 | View | |
DISTKNAM | Discount Taken Amount |
Currency | 10 | View | |
DISAVAMT | Discount Available Amount |
Currency | 10 | View | |
DSCDLRAM | Discount Dollar Amount |
Currency | 10 | View | |
DSCPCTAM | Discount Percent Amount |
Integer | 2 | View | |
PRBTADCD | Primary Billto Address Code |
String | 16 | View | |
PRSTADCD | Primary Shipto Address Code |
String | 16 | View | |
CNTCPRSN | Contact Person |
String | 62 | View | |
ADDRESS1 | Address 1 |
String | 62 | View | |
ADDRESS2 | Address 2 |
String | 62 | View | |
ADDRESS3 | Address 3 |
String | 62 | View | |
CITY | City |
String | 36 | View | |
STATE | State |
String | 30 | View | |
ZIPCODE | Zip Code |
String | 12 | View | |
CCode | Country Code |
String | 8 | View | |
COUNTRY | Country |
String | 62 | View | |
PHNUMBR1 | Phone Number 1 |
String | 22 | View | |
PHNUMBR2 | Phone Number 2 |
String | 22 | View | |
PHONE3 | Phone 3 |
String | 22 | View | |
FAXNUMBR | Fax Number |
String | 22 | View | |
COMAPPTO | Commission Applied To |
Integer | 2 | View | |
COMDLRAM | Commission Dollar Amount |
Currency | 10 | View | |
NCOMAMNT | Non-Commissioned Amount |
Currency | 10 | View | |
UPSZONE | UPS Zone |
String | 4 | View | |
LSTUSRED | Last User to Edit |
String | 16 | View | |
LSTEDTDT | Last Edit Date |
Date | 4 | View | |
MODIFDT | Modified Date |
Date | 4 | View | |
CREATDDT | Created Date |
Date | 4 | View | |
USER2ENT | User To Enter |
String | 16 | View | |
NOTEINDX | Note Index |
Currency | 10 | View | |
TIMESPRT | Times Printed |
Integer | 2 | View | |
NOCARTNS | Number Of Cartons |
Integer | 2 | View | |
USERDEF1 | User Defined 1 |
String | 22 | View | |
USERDEF2 | User Defined 2 |
String | 22 | View | |
VOIDSTTS | Void Status 0 = Document has not been voided. |
Integer | 2 | View | |
TRXSORCE | TRX Source |
String | 14 | View | |
LNITMSEQ | Line Item Sequence |
Long Integer | 4 | View | |
COMMENT_1 | Comment[1] |
String | 52 | View | |
COMMENT_2 | Comment[2] |
String | 52 | View | |
COMMENT_3 | Comment[3] |
String | 52 | View | |
COMMENT_4 | Comment[4] |
String | 52 | View | |
ECTRX | EC Transaction |
Boolean | 2 | View | |
ShipToName | ShipToName |
String | 66 | View | |
Tax_Date | Tax Date |
Date | 4 | View | |
APLYWITH | Apply Withholding |
Boolean | 2 | View | |
WITHHAMT | Withholding Amount |
Currency | 10 | View | |
CMMTTEXT | Comment Text |
Text | 2 | View |