| SERIES |
smallint
0
|
Series: In...(more) Join Now
|
|
|
|
| DOCTYPE |
smallint
0
|
Document T...(more) Join Now
|
|
|
|
| DOCNUMBR |
char(21)
''
|
Document N...(more) Join Now
|
|
|
|
| SQNCLINE |
numeric(19,5)
0.00
|
Sequence L...(more) Join Now
|
|
|
|
| CUSTNMBR |
char(15)
''
|
Customer N...(more) Join Now
|
|
|
join ... more text available
|
| CCode |
char(7)
''
|
Country Co...(more) Join Now
|
|
|
|
| TXRGNNUM |
char(25)
''
|
Tax Regist...(more) Join Now
|
|
|
|
| TCC |
char(31)
''
|
Tax Commod...(more) Join Now
|
|
|
|
| NUMASS |
numeric(19,5)
0.00
|
Net Unit M...(more) Join Now
|
|
|
|
| QUANTITY |
numeric(19,5)
0.00
|
QTY: This ...(more) Join Now
|
|
|
|
| LMASS |
numeric(19,5)
0.00
|
Line Mass:...(more) Join Now
|
|
|
|
| TMCODE |
char(7)
''
|
Transport ...(more) Join Now
|
|
|
|
| TRANSNATURE |
char(7)
''
|
Transactio...(more) Join Now
|
|
|
|
| SUPPUNITS |
numeric(19,5)
0.00
|
Supplement...(more) Join Now
|
|
|
|
| TRADREF |
char(21)
''
|
Traders Re...(more) Join Now
|
|
|
|
| GOODSVALUE |
numeric(19,5)
0.00
|
Goods Valu...(more) Join Now
|
|
|
|
| TAXAMNT |
numeric(19,5)
0.00
|
Tax Amount...(more) Join Now
|
|
|
|
| NOTEINDX |
numeric(19,5)
0.00
|
Note Index...(more) Join Now
|
|
|
join ... more text available
|
| DOCDATE |
datetime
'1/1/1900'
|
Document D...(more) Join Now
|
|
|
|
| Tax_Date |
datetime
'1/1/1900'
|
Tax Date: ...(more) Join Now
|
|
|
|
| Reference_Date |
datetime
'1/1/1900'
|
Reference ...(more) Join Now
|
|
|
|
| POSTED |
tinyint
0
|
Posted: Tr...(more) Join Now
|
|
|
|
| VOIDSTTS |
smallint
0
|
Void Statu...(more) Join Now
|
|
|
|
| ORGDSVAL |
numeric(19,5)
0.00
|
Originatin...(more) Join Now
|
|
|
|
| ORTAXAMT |
numeric(19,5)
0.00
|
Originatin...(more) Join Now
|
|
|
|
| CURRNIDX |
smallint
0
|
Currency I...(more) Join Now
|
|
|
join ... more text available
|
| ITEMNMBR |
char(31)
''
|
Item Numbe...(more) Join Now
|
|
|
join ... more text available
|
| ITEMDESC |
char(101)
''
|
Item Descr...(more) Join Now
|
|
|
|
| PRT |
char(7)
''
|
Port: Port...(more) Join Now
|
|
|
|
| RGN |
char(7)
''
|
Region: Re...(more) Join Now
|
|
|
|
| CNTRYORGN |
char(7)
''
|
Country Or...(more) Join Now
|
|
|
|
| PRCDRRGM |
char(7)
''
|
Procedure/...(more) Join Now
|
|
|
|
| INCTRMS |
char(7)
''
|
Incoterms:...(more) Join Now
|
|
|
|
| STTSTCLVL |
numeric(19,5)
0.00
|
Statistica...(more) Join Now
|
|
|
|
| ORGNTNGSTTSTCLVL |
numeric(19,5)
0.00
|
Originatin...(more) Join Now
|
|
|
|
| Included_On_Return |
tinyint
0
|
Included o...(more) Join Now
|
|
|
|
| INTRSTTRTRNID |
char(21)
''
|
Intrastat ...(more) Join Now
|
|
|
|
| DECLID |
char(15)
''
|
Declarant ...(more) Join Now
|
|
|
|
| LOCNCODE |
char(11)
''
|
Location C...(more) Join Now
|
|
|
join ... more text available
|
| ARRDISP |
char(1)
''
|
Arrival/De...(more) Join Now
|
|
|
|
| PERIOD |
char(5)
''
|
Period: Th...(more) Join Now
|
|
|
|
| AUDITTRAIL |
char(13)
''
|
Audit Trai...(more) Join Now
|
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|