| DOCTYPE |
smallint
0
|
Document T...(more) Join Now
|
|
|
|
| INVCNMBR |
char(21)
''
|
Invoice Nu...(more) Join Now
|
|
|
|
| BACHNUMB |
char(15)
''
|
Batch Numb...(more) Join Now
|
|
|
join ... more text available
|
| BCHSOURC |
char(15)
''
|
Batch Sour...(more) Join Now
|
|
|
|
| PCKSLPNO |
char(21)
''
|
Packing Sl...(more) Join Now
|
|
|
|
| CUSTNMBR |
char(15)
''
|
Customer N...(more) Join Now
|
|
|
join ... more text available
|
| CUSTNAME |
char(65)
''
|
Customer N...(more) Join Now
|
|
|
|
| CSTPONBR |
char(21)
''
|
Customer P...(more) Join Now
|
|
|
|
| POSTDATE |
datetime
'1/1/1900'
|
Post Date:...(more) Join Now
|
|
|
|
| GLPOSTDT |
datetime
'1/1/1900'
|
GL Posting...(more) Join Now
|
|
|
|
| DOCDATE |
datetime
'1/1/1900'
|
Document D...(more) Join Now
|
|
|
|
| QUOTEDAT |
datetime
'1/1/1900'
|
Quote Date...(more) Join Now
|
|
|
|
| ORDRDATE |
datetime
'1/1/1900'
|
Order Date...(more) Join Now
|
|
|
|
| DISCDATE |
datetime
'1/1/1900'
|
Discount D...(more) Join Now
|
|
|
|
| DUEDATE |
datetime
'1/1/1900'
|
Due Date: ...(more) Join Now
|
|
|
|
| HOLDNT |
tinyint
0
|
Hold NT: ...(more) Join Now
|
|
|
|
| SHIPMTHD |
char(15)
''
|
Shipping M...(more) Join Now
|
|
|
join ... more text available
|
| TAXEXMT1 |
char(25)
''
|
Tax Exempt...(more) Join Now
|
|
|
|
| TAXEXMT2 |
char(25)
''
|
Tax Exempt...(more) Join Now
|
|
|
|
| TAXSCHID |
char(15)
''
|
Tax Schedu...(more) Join Now
|
|
|
join ... more text available
|
| FRTSCHID |
char(15)
''
|
Freight Sc...(more) Join Now
|
|
|
join ... more text available
|
| FRGTTXBL |
smallint
0
|
Freight Ta...(more) Join Now
|
|
|
|
| FRTTXAMT |
numeric(19,5)
0.00
|
Freight Ta...(more) Join Now
|
|
|
|
| MSCSCHID |
char(15)
''
|
Misc Sched...(more) Join Now
|
|
|
join ... more text available
|
| MISCTXBL |
smallint
0
|
Misc Taxab...(more) Join Now
|
|
|
|
| MSCTXAMT |
numeric(19,5)
0.00
|
Misc Tax A...(more) Join Now
|
|
|
|
| SLPRSNID |
char(15)
''
|
Salesperso...(more) Join Now
|
|
|
join ... more text available
|
| SALSTERR |
char(15)
''
|
Sales Terr...(more) Join Now
|
|
|
join ... more text available
|
| TXRGNNUM |
char(25)
''
|
Tax Regist...(more) Join Now
|
|
|
|
| PYMTRMID |
char(21)
''
|
Payment Te...(more) Join Now
|
|
|
SY033... more text available
|
| PRCLEVEL |
char(11)
''
|
Price Leve...(more) Join Now
|
|
|
|
| LOCNCODE |
char(11)
''
|
Location C...(more) Join Now
|
|
|
join ... more text available
|
| CURNCYID |
char(15)
''
|
Currency I...(more) Join Now
|
|
|
join ... more text available
|
| COMMNTID |
char(15)
''
|
Comment ID...(more) Join Now
|
|
|
join ... more text available
|
| DOCAMNT |
numeric(19,5)
0.00
|
Document A...(more) Join Now
|
|
|
|
| SUBTOTAL |
numeric(19,5)
0.00
|
Subtotal: ...(more) Join Now
|
|
|
|
| FRTAMNT |
numeric(19,5)
0.00
|
Freight Am...(more) Join Now
|
|
|
|
| MISCAMNT |
numeric(19,5)
0.00
|
Misc Amoun...(more) Join Now
|
|
|
|
| TAXAMNT |
numeric(19,5)
0.00
|
Tax Amount...(more) Join Now
|
|
|
|
| TXBTXAMT |
numeric(19,5)
0.00
|
Taxable Ta...(more) Join Now
|
|
|
|
| BCKTXAMT |
numeric(19,5)
0.00
|
Backout Ta...(more) Join Now
|
|
|
|
| BKTSLSAM |
numeric(19,5)
0.00
|
Backout Sa...(more) Join Now
|
|
|
|
| BKTFRTAM |
numeric(19,5)
0.00
|
Backout Fr...(more) Join Now
|
|
|
|
| BKTMSCAM |
numeric(19,5)
0.00
|
Backout Mi...(more) Join Now
|
|
|
|
| DISCFRGT |
numeric(19,5)
0.00
|
Discount A...(more) Join Now
|
|
|
|
| DISCMISC |
numeric(19,5)
0.00
|
Discount A...(more) Join Now
|
|
|
|
| TRDISPCT |
smallint
0
|
Trade Disc...(more) Join Now
|
|
|
|
| TRDISAMT |
numeric(19,5)
0.00
|
Trade Disc...(more) Join Now
|
|
|
|
| ACCTAMNT |
numeric(19,5)
0.00
|
Account Am...(more) Join Now
|
|
|
|
| PYMTRCVD |
numeric(19,5)
0.00
|
Payment Re...(more) Join Now
|
|
|
|
| CODAMNT |
numeric(19,5)
0.00
|
COD Amount...(more) Join Now
|
|
|
|
| EXTDCOST |
numeric(19,5)
0.00
|
Extended C...(more) Join Now
|
|
|
|
| DISCRTND |
numeric(19,5)
0.00
|
Discount R...(more) Join Now
|
|
|
|
| DISAVTKN |
numeric(19,5)
0.00
|
Discount A...(more) Join Now
|
|
|
|
| DISTKNAM |
numeric(19,5)
0.00
|
Discount T...(more) Join Now
|
|
|
|
| DISAVAMT |
numeric(19,5)
0.00
|
Discount A...(more) Join Now
|
|
|
|
| DSCDLRAM |
numeric(19,5)
0.00
|
Discount D...(more) Join Now
|
|
|
|
| DSCPCTAM |
smallint
0
|
Discount P...(more) Join Now
|
|
|
|
| MRKDNAMT |
numeric(19,5)
0.00
|
Markdown A...(more) Join Now
|
|
|
|
| PRBTADCD |
char(15)
''
|
Primary Bi...(more) Join Now
|
|
|
join ... more text available
|
| PRSTADCD |
char(15)
''
|
Primary Sh...(more) Join Now
|
|
|
join ... more text available
|
| CNTCPRSN |
char(61)
''
|
Contact Pe...(more) Join Now
|
|
|
|
| ADDRESS1 |
char(61)
''
|
Address 1:...(more) Join Now
|
|
|
|
| ADDRESS2 |
char(61)
''
|
Address 2:...(more) Join Now
|
|
|
|
| ADDRESS3 |
char(61)
''
|
Address 3:...(more) Join Now
|
|
|
|
| CITY |
char(35)
''
|
City: The...(more) Join Now
|
|
|
|
| STATE |
char(29)
''
|
State: Th...(more) Join Now
|
|
|
|
| ZIPCODE |
char(11)
''
|
Zip Code: ...(more) Join Now
|
|
|
|
| CCode |
char(7)
''
|
Country Co...(more) Join Now
|
|
|
|
| COUNTRY |
char(61)
''
|
Country: ...(more) Join Now
|
|
|
|
| PHNUMBR1 |
char(21)
''
|
Phone Numb...(more) Join Now
|
|
|
|
| PHNUMBR2 |
char(21)
''
|
Phone Numb...(more) Join Now
|
|
|
|
| PHONE3 |
char(21)
''
|
Phone 3: T...(more) Join Now
|
|
|
|
| FAXNUMBR |
char(21)
''
|
Fax Number...(more) Join Now
|
|
|
|
| COMAPPTO |
smallint
0
|
Commission...(more) Join Now
|
|
|
|
| COMDLRAM |
numeric(19,5)
0.00
|
Commission...(more) Join Now
|
|
|
|
| NCOMAMNT |
numeric(19,5)
0.00
|
Non-Commis...(more) Join Now
|
|
|
|
| UPSZONE |
char(3)
''
|
UPS Zone: ...(more) Join Now
|
|
|
|
| LSTUSRED |
char(15)
''
|
Last User ...(more) Join Now
|
|
|
|
| LSTEDTDT |
datetime
'1/1/1900'
|
Last Edit ...(more) Join Now
|
|
|
|
| MODIFDT |
datetime
'1/1/1900'
|
Date the r...(more) Join Now
|
|
|
|
| CREATDDT |
datetime
'1/1/1900'
|
Created Da...(more) Join Now
|
|
|
|
| USER2ENT |
char(15)
''
|
User To En...(more) Join Now
|
|
|
|
| NOTEINDX |
numeric(19,5)
0.00
|
Note Index...(more) Join Now
|
|
|
join ... more text available
|
| TIMESPRT |
smallint
0
|
Times Prin...(more) Join Now
|
|
|
|
| NOCARTNS |
smallint
0
|
Number Of ...(more) Join Now
|
|
|
|
| USERDEF1 |
char(21)
''
|
User Defin...(more) Join Now
|
|
|
|
| USERDEF2 |
char(21)
''
|
User Defin...(more) Join Now
|
|
|
|
| VOIDSTTS |
smallint
0
|
Void Statu...(more) Join Now
|
|
|
|
| TRXSORCE |
char(13)
''
|
Transactio...(more) Join Now
|
|
|
|
| PSTGSTUS |
smallint
0
|
Posting St...(more) Join Now
|
|
|
|
| IVCHDER1 |
binary(4)
0
|
IVC HDR Er...(more) Join Now
|
|
|
|
| IVCHDER2 |
binary(4)
0
|
IVC HDR Er...(more) Join Now
|
|
|
|
| IVCLINEERR |
binary(4)
0
|
IVC LINE E...(more) Join Now
|
|
|
|
| LNITMSEQ |
int
0
|
Line Item ...(more) Join Now
|
|
|
|
| COMMENT_1 |
char(51)
''
|
[4]Comment...(more) Join Now
|
|
|
|
| COMMENT_2 |
char(51)
''
|
[4]Comment...(more) Join Now
|
|
|
|
| COMMENT_3 |
char(51)
''
|
[4]Comment...(more) Join Now
|
|
|
|
| COMMENT_4 |
char(51)
''
|
[4]Comment...(more) Join Now
|
|
|
|
| ECTRX |
tinyint
0
|
EC Transac...(more) Join Now
|
|
|
|
| ShipToName |
char(65)
''
|
ShipToName...(more) Join Now
|
|
|
|
| Tax_Date |
datetime
'1/1/1900'
|
Tax Date: ...(more) Join Now
|
|
|
|
| APLYWITH |
tinyint
0
|
Apply With...(more) Join Now
|
|
|
|
| WITHHAMT |
numeric(19,5)
0.00
|
Withholdin...(more) Join Now
|
|
|
|
| BackoutTradeDisc |
numeric(19,5)
0.00
|
Backout Tr...(more) Join Now
|
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|
| CMMTTEXT |
text
|
Comment Te...(more) Join Now
|
|
|
|