| DOCTYPE |
smallint
0
|
Document T...(more) Join Now
|
|
|
|
| INVCNMBR |
char(21)
''
|
Invoice Nu...(more) Join Now
|
|
|
|
| LNITMSEQ |
int
0
|
Line Item ...(more) Join Now
|
|
|
|
| CMPNTSEQ |
int
0
|
Component ...(more) Join Now
|
|
|
|
| ITEMNMBR |
char(31)
''
|
Item Numbe...(more) Join Now
|
|
|
join ... more text available
|
| DECPLCUR |
smallint
0
|
Number of ...(more) Join Now
|
|
|
|
| DECPLQTY |
smallint
0
|
Decimal Pl...(more) Join Now
|
|
|
|
| INVINDX |
int
0
|
Inventory ...(more) Join Now
|
|
|
|
| CSLSINDX |
int
0
|
Cost Of Sa...(more) Join Now
|
|
|
|
| SLSINDX |
int
0
|
Sales Inde...(more) Join Now
|
|
|
|
| MKDNINDX |
int
0
|
Markdown I...(more) Join Now
|
|
|
|
| RTNSINDX |
int
0
|
Returns In...(more) Join Now
|
|
|
|
| INUSINDX |
int
0
|
In Use Ind...(more) Join Now
|
|
|
|
| INSRINDX |
int
0
|
In Service...(more) Join Now
|
|
|
|
| DMGDINDX |
int
0
|
Damaged In...(more) Join Now
|
|
|
|
| ITMTSHID |
char(15)
''
|
Item Tax S...(more) Join Now
|
|
|
|
| IVITMTXB |
smallint
0
|
IV Item Ta...(more) Join Now
|
|
|
|
| NONINVEN |
smallint
0
|
Non IV: Th...(more) Join Now
|
|
|
|
| QUANTITY |
numeric(19,5)
0.00
|
QTY: The n...(more) Join Now
|
|
|
|
| QTYINSVC |
numeric(19,5)
0.00
|
QTY In Ser...(more) Join Now
|
|
|
|
| QTYINUSE |
numeric(19,5)
0.00
|
QTY In Use...(more) Join Now
|
|
|
|
| QTYDMGED |
numeric(19,5)
0.00
|
QTY Damage...(more) Join Now
|
|
|
|
| QTYRTRND |
numeric(19,5)
0.00
|
QTY Return...(more) Join Now
|
|
|
|
| QTYONHND |
numeric(19,5)
0.00
|
QTY On Han...(more) Join Now
|
|
|
|
| EXTQTYSEL |
numeric(19,5)
0.00
|
Existing Q...(more) Join Now
|
|
|
|
| UOFM |
char(9)
''
|
U Of M: Th...(more) Join Now
|
|
|
See I... more text available
|
| QTYBSUOM |
numeric(19,5)
0.00
|
QTY In Bas...(more) Join Now
|
|
|
|
| UNITCOST |
numeric(19,5)
0.00
|
Unit Cost:...(more) Join Now
|
|
|
|
| EXTDCOST |
numeric(19,5)
0.00
|
Extended C...(more) Join Now
|
|
|
|
| DISCSALE |
numeric(19,5)
0.00
|
Discount A...(more) Join Now
|
|
|
|
| TRDISAMT |
numeric(19,5)
0.00
|
Trade Disc...(more) Join Now
|
|
|
|
| ATYALLOC |
numeric(19,5)
0.00
|
QTY Alloca...(more) Join Now
|
|
|
|
| LOCNCODE |
char(11)
''
|
Location C...(more) Join Now
|
|
|
join ... more text available
|
| MRKDNTYP |
smallint
0
|
Markdown T...(more) Join Now
|
|
|
|
| MRKDNAMT |
numeric(19,5)
0.00
|
Markdown A...(more) Join Now
|
|
|
|
| MRKDNPCT |
smallint
0
|
Markdown P...(more) Join Now
|
|
|
|
| PRCLEVEL |
char(11)
''
|
PriceLevel...(more) Join Now
|
|
|
|
| XTNDPRCE |
numeric(19,5)
0.00
|
Extended P...(more) Join Now
|
|
|
|
| UNITPRCE |
numeric(19,5)
0.00
|
Unit Price...(more) Join Now
|
|
|
|
| TAXAMNT |
numeric(19,5)
0.00
|
Tax Amount...(more) Join Now
|
|
|
|
| BKTSLSAM |
numeric(19,5)
0.00
|
Backout Sa...(more) Join Now
|
|
|
|
| TXBTXAMT |
numeric(19,5)
0.00
|
Taxable Ta...(more) Join Now
|
|
|
|
| BSIVCTTL |
tinyint
0
|
Based On I...(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
|
| DSCRIPTN |
char(31)
''
|
Descriptio...(more) Join Now
|
|
|
|
| ITEMDESC |
char(101)
''
|
Item Descr...(more) Join Now
|
|
|
|
| EXPTSHIP |
datetime
'1/1/1900'
|
Expected S...(more) Join Now
|
|
|
|
| ACTLSHIP |
datetime
'1/1/1900'
|
Actual Shi...(more) Join Now
|
|
|
|
| ReqShipDate |
datetime
'1/1/1900'
|
Requested ...(more) Join Now
|
|
|
|
| COMDLRAM |
numeric(19,5)
0.00
|
Commission...(more) Join Now
|
|
|
|
| CMPSERNM |
tinyint
0
|
Component ...(more) Join Now
|
|
|
|
| COMMNTID |
char(15)
''
|
Comment ID...(more) Join Now
|
|
|
join ... more text available
|
| BRKFLD1 |
smallint
0
|
Break Fiel...(more) Join Now
|
|
|
|
| BRKFLD2 |
smallint
0
|
Break Fiel...(more) Join Now
|
|
|
|
| BRKFLD3 |
smallint
0
|
Break Fiel...(more) Join Now
|
|
|
|
| TRXSORCE |
char(13)
''
|
Transactio...(more) Join Now
|
|
|
|
| IVCLINEERR |
binary(4)
0
|
IVC LINE E...(more) Join Now
|
|
|
|
| BackoutTradeDisc |
numeric(19,5)
0.00
|
Backout Tr...(more) Join Now
|
|
|
|
| PRSTADCD |
char(15)
''
|
Primary Sh...(more) Join Now
|
|
|
join ... more text available
|
| SHIPMTHD |
char(15)
''
|
Shipping M...(more) Join Now
|
|
|
join ... more text available
|
| ISLINEINTRA |
tinyint
0
|
IsLineIntr...(more) Join Now
|
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|