| DOCTYPE |
smallint
0
|
Document T...(more) Join Now
|
PM10000.DOCTYPE
|
|
|
| INVCNMBR |
char(21)
''
|
|
|
|
|
| LNITMSEQ |
int
0
|
Line Item ...(more) Join Now
|
PA01301.LNITMSEQ
|
|
|
| CMPNTSEQ |
int
0
|
Component ...(more) Join Now
|
SOP10200.CMPNTSEQ
|
|
|
| NONINVEN |
smallint
0
|
Non-IV: Th...(more) Join Now
|
SOP10200.NONINVEN
|
|
|
| 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
|
|
|
|
| ITMTSHID |
char(15)
''
|
Item Tax S...(more) Join Now
|
IV00101.ITMTSHID
|
|
|
| IVITMTXB |
smallint
0
|
IV Item Ta...(more) Join Now
|
SOP10200.IVITMTXB
|
|
|
| QUANTITY |
numeric(19,5)
0.00
|
QTY This i...(more) Join Now
|
|
|
|
| QTYINSVC |
numeric(19,5)
0.00
|
QTY In Ser...(more) Join Now
|
IV00102.QTYINSVC
|
|
|
| QTYINUSE |
numeric(19,5)
0.00
|
QTY In Use...(more) Join Now
|
IV00102.QTYINUSE
|
|
|
| QTYDMGED |
numeric(19,5)
0.00
|
QTY Damage...(more) Join Now
|
IV00102.QTYDMGED
|
|
|
| QTYRTRND |
numeric(19,5)
0.00
|
QTY Return...(more) Join Now
|
IV00102.QTYRTRND
|
|
|
| QTYONHND |
numeric(19,5)
0.00
|
QTY On Han...(more) Join Now
|
IV00102.QTYONHND
|
|
|
| EXTQTYSEL |
numeric(19,5)
0.00
|
Existing Q...(more) Join Now
|
SOP10200.EXTQTYSEL
|
|
|
| UOFM |
char(9)
''
|
U Of M: T...(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
|
|
|
|
| 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
|
SOP10200.MRKDNTYP
|
|
|
| MRKDNAMT |
numeric(19,5)
0.00
|
Markdown A...(more) Join Now
|
SOP10100.MRKDNAMT
|
|
|
| MRKDNPCT |
smallint
0
|
Markdown P...(more) Join Now
|
SOP10200.MRKDNPCT
|
|
|
| PRCLEVEL |
char(11)
''
|
Price Leve...(more) Join Now
|
|
|
|
| XTNDPRCE |
numeric(19,5)
0.00
|
Extended P...(more) Join Now
|
SOP10200.XTNDPRCE
|
|
|
| UNITPRCE |
numeric(19,5)
0.00
|
Unit Price...(more) Join Now
|
SOP10200.UNITPRCE
|
|
|
| TAXAMNT |
numeric(19,5)
0.00
|
Tax Amount...(more) Join Now
|
RM20101.TAXAMNT
|
|
|
| BKTSLSAM |
numeric(19,5)
0.00
|
Backout Sa...(more) Join Now
|
RM20101.BKTSLSAM
|
|
|
| TXBTXAMT |
numeric(19,5)
0.00
|
Taxable Ta...(more) Join Now
|
SOP10100.TXBTXAMT
|
|
|
| SLPRSNID |
char(15)
''
|
Salesperso...(more) Join Now
|
RM20101.SLPRSNID
|
|
join ... more text available
|
| SALSTERR |
char(15)
''
|
Sales Terr...(more) Join Now
|
RM10301.SALSTERR
|
|
join ... more text available
|
| DSCRIPTN |
char(31)
''
|
Descriptio...(more) Join Now
|
CM20300.DSCRIPTN
|
|
|
| ITEMDESC |
char(101)
''
|
Item Descr...(more) Join Now
|
IV00101.ITEMDESC
|
|
|
| EXPTSHIP |
datetime
'1/1/1900'
|
|
|
|
|
| ACTLSHIP |
datetime
'1/1/1900'
|
Actual Shi...(more) Join Now
|
POP30300.ACTLSHIP
|
|
|
| ReqShipDate |
datetime
'1/1/1900'
|
Requested ...(more) Join Now
|
SOP10100.ReqShipDate
|
|
|
| COMDLRAM |
numeric(19,5)
0.00
|
Commission...(more) Join Now
|
RM20101.COMDLRAM
|
|
|
| CMPSERNM |
tinyint
0
|
|
|
|
|
| COMMNTID |
char(15)
''
|
Comment ID...(more) Join Now
|
SOP10100.COMMNTID
|
|
join ... more text available
|
| BRKFLD1 |
smallint
0
|
Break Fiel...(more) Join Now
|
SOP10200.BRKFLD1
|
|
|
| BRKFLD2 |
smallint
0
|
Break Fiel...(more) Join Now
|
SOP10200.BRKFLD2
|
|
|
| BRKFLD3 |
smallint
0
|
Break Fiel...(more) Join Now
|
SOP10200.BRKFLD3
|
|
|
| TRXSORCE |
char(13)
''
|
Transactio...(more) Join Now
|
|
|
|
| PRSTADCD |
char(15)
''
|
Primary Sh...(more) Join Now
|
RM00101.PRSTADCD
|
|
join ... more text available
|
| SHIPMTHD |
char(15)
''
|
Shipping M...(more) Join Now
|
RM20101.SHIPMTHD
|
|
join ... more text available
|
| ISLINEINTRA |
tinyint
0
|
SO Fulfill...(more) Join Now
|
SOP10200.ISLINEINTRA
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|