| SOPTYPE |
smallint
0
|
Values sto...(more) Join Now
|
|
|
| SOPNUMBE |
char(21)
''
|
The number...(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
|
| ITEMDESC |
char(101)
''
|
Item Descr...(more) Join Now
|
|
|
| NONINVEN |
smallint
0
|
Non-IV: Th...(more) Join Now
|
|
|
| DROPSHIP |
smallint
0
|
Drop Ship:...(more) Join Now
|
|
|
| UOFM |
char(9)
''
|
U of M The...(more) Join Now
|
|
See I... more text available
|
| LOCNCODE |
char(11)
''
|
Location C...(more) Join Now
|
|
join ... more text available
|
| UNITCOST |
numeric(19,5)
0.00
|
Unit Cost:...(more) Join Now
|
|
|
| ORUNTCST |
numeric(19,5)
0.00
|
Originatin...(more) Join Now
|
|
|
| UNITPRCE |
numeric(19,5)
0.00
|
Unit Price...(more) Join Now
|
|
|
| ORUNTPRC |
numeric(19,5)
0.00
|
Originatin...(more) Join Now
|
|
|
| XTNDPRCE |
numeric(19,5)
0.00
|
Extended P...(more) Join Now
|
|
|
| OXTNDPRC |
numeric(19,5)
0.00
|
Originatin...(more) Join Now
|
|
|
| REMPRICE |
numeric(19,5)
0.00
|
Remaining ...(more) Join Now
|
|
|
| OREPRICE |
numeric(19,5)
0.00
|
Originatin...(more) Join Now
|
|
|
| EXTDCOST |
numeric(19,5)
0.00
|
Extended C...(more) Join Now
|
|
|
| OREXTCST |
numeric(19,5)
0.00
|
Originatin...(more) Join Now
|
|
|
| MRKDNAMT |
numeric(19,5)
0.00
|
Markdown A...(more) Join Now
|
|
|
| ORMRKDAM |
numeric(19,5)
0.00
|
Orig Markd...(more) Join Now
|
|
|
| MRKDNPCT |
smallint
0
|
Markdown P...(more) Join Now
|
|
|
| MRKDNTYP |
smallint
0
|
Markdown T...(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
|
|
|
| BKTSLSAM |
numeric(19,5)
0.00
|
Backout Sa...(more) Join Now
|
|
|
| ORBKTSLS |
numeric(19,5)
0.00
|
Originatin...(more) Join Now
|
|
|
| TAXAMNT |
numeric(19,5)
0.00
|
Tax Amount...(more) Join Now
|
|
|
| ORTAXAMT |
numeric(19,5)
0.00
|
Originatin...(more) Join Now
|
|
|
| TXBTXAMT |
numeric(19,5)
0.00
|
Taxable Ta...(more) Join Now
|
|
|
| OTAXTAMT |
numeric(19,5)
0.00
|
Orig Taxab...(more) Join Now
|
|
|
| BSIVCTTL |
tinyint
0
|
Based On I...(more) Join Now
|
|
|
| TRDISAMT |
numeric(19,5)
0.00
|
Trade Disc...(more) Join Now
|
|
|
| ORTDISAM |
numeric(19,5)
0.00
|
Orig Trade...(more) Join Now
|
|
|
| DISCSALE |
numeric(19,5)
0.00
|
Discount A...(more) Join Now
|
|
|
| ORDAVSLS |
numeric(19,5)
0.00
|
Originatin...(more) Join Now
|
|
|
| QUANTITY |
numeric(19,5)
0.00
|
QTY: The n...(more) Join Now
|
|
|
| ATYALLOC |
numeric(19,5)
0.00
|
QTY Alloca...(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
|
|
|
| QTYCANCE |
numeric(19,5)
0.00
|
QTY Cancel...(more) Join Now
|
|
|
| QTYCANOT |
numeric(19,5)
0.00
|
QTY Cancel...(more) Join Now
|
|
|
| QTYONPO |
numeric(19,5)
0.00
|
QTY On PO:...(more) Join Now
|
|
|
| QTYORDER |
numeric(19,5)
0.00
|
QTY Ordere...(more) Join Now
|
|
|
| QTYPRBAC |
numeric(19,5)
0.00
|
QTY Prev B...(more) Join Now
|
|
|
| QTYPRBOO |
numeric(19,5)
0.00
|
QTY Prev B...(more) Join Now
|
|
|
| QTYPRINV |
numeric(19,5)
0.00
|
QTY Prev I...(more) Join Now
|
|
|
| QTYPRORD |
numeric(19,5)
0.00
|
QTY Prev O...(more) Join Now
|
|
|
| QTYPRVRECVD |
numeric(19,5)
0.00
|
QTY Prev R...(more) Join Now
|
|
|
| QTYRECVD |
numeric(19,5)
0.00
|
QTY Receiv...(more) Join Now
|
|
|
| QTYREMAI |
numeric(19,5)
0.00
|
QTY Remain...(more) Join Now
|
|
|
| QTYREMBO |
numeric(19,5)
0.00
|
QTY Remain...(more) Join Now
|
|
|
| QTYTBAOR |
numeric(19,5)
0.00
|
QTY To Bac...(more) Join Now
|
|
|
| QTYTOINV |
numeric(19,5)
0.00
|
QTY To Inv...(more) Join Now
|
|
|
| QTYTORDR |
numeric(19,5)
0.00
|
QTY To Ord...(more) Join Now
|
|
|
| QTYFULFI |
numeric(19,5)
0.00
|
QTY Fulfil...(more) Join Now
|
|
|
| QTYSLCTD |
numeric(19,5)
0.00
|
QTY Select...(more) Join Now
|
|
|
| QTYBSUOM |
numeric(19,5)
0.00
|
QTY In Bas...(more) Join Now
|
|
|
| EXTQTYAL |
numeric(19,5)
0.00
|
Existing Q...(more) Join Now
|
|
|
| EXTQTYSEL |
numeric(19,5)
0.00
|
Existing Q...(more) Join Now
|
|
|
| ReqShipDate |
datetime
'1/1/1900'
|
Requested ...(more) Join Now
|
|
|
| FUFILDAT |
datetime
'1/1/1900'
|
Fulfillmen...(more) Join Now
|
|
|
| ACTLSHIP |
datetime
'1/1/1900'
|
Actual Shi...(more) Join Now
|
|
|
| SHIPMTHD |
char(15)
''
|
Shipping M...(more) Join Now
|
|
join ... more text available
|
| SALSTERR |
char(15)
''
|
Sales Terr...(more) Join Now
|
|
join ... more text available
|
| SLPRSNID |
char(15)
''
|
Salesperso...(more) Join Now
|
|
join ... more text available
|
| PRCLEVEL |
char(11)
''
|
PriceLevel...(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
|
|
|
| CURRNIDX |
smallint
0
|
Currency I...(more) Join Now
|
|
join ... more text available
|
| TRXSORCE |
char(13)
''
|
Transactio...(more) Join Now
|
|
|
| SOPLNERR |
binary(4)
0
|
SOP LINE E...(more) Join Now
|
|
|
| ORGSEQNM |
int
0
|
Original S...(more) Join Now
|
|
|
| ITEMCODE |
char(15)
''
|
Item Code:...(more) Join Now
|
|
|
| PURCHSTAT |
smallint
0
|
Purchasing...(more) Join Now
|
|
|
| DECPLQTY |
smallint
0
|
Decimal Pl...(more) Join Now
|
|
|
| DECPLCUR |
smallint
0
|
Number of ...(more) Join Now
|
|
|
| ODECPLCU |
smallint
0
|
Originatin...(more) Join Now
|
|
|
| QTYTOSHP |
numeric(19,5)
0.00
|
QTY to Shi...(more) Join Now
|
|
|
| XFRSHDOC |
tinyint
0
|
Transferre...(more) Join Now
|
|
|
| EXCEPTIONALDEMAND |
tinyint
0
|
Exceptiona...(more) Join Now
|
|
|
| TAXSCHID |
char(15)
''
|
Tax Schedu...(more) Join Now
|
|
join ... more text available
|
| TXSCHSRC |
smallint
0
|
Tax Schedu...(more) Join Now
|
|
|
| PRSTADCD |
char(15)
''
|
Primary Sh...(more) Join Now
|
|
join ... more text available
|
| ShipToName |
char(65)
''
|
ShipToName...(more) Join Now
|
|
|
| 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: City...(more) Join Now
|
|
|
| STATE |
char(29)
''
|
State: Sta...(more) Join Now
|
|
|
| ZIPCODE |
char(11)
''
|
Zip Code: ...(more) Join Now
|
|
|
| CCode |
char(7)
''
|
Country Co...(more) Join Now
|
|
|
| COUNTRY |
char(61)
''
|
Country: C...(more) Join Now
|
|
|
| PHONE1 |
char(21)
''
|
Phone 1: F...(more) Join Now
|
|
|
| PHONE2 |
char(21)
''
|
Phone 2: S...(more) Join Now
|
|
|
| PHONE3 |
char(21)
''
|
Phone 3: T...(more) Join Now
|
|
|
| FAXNUMBR |
char(21)
''
|
Fax Number...(more) Join Now
|
|
|
| Flags |
smallint
0
|
Flags: The...(more) Join Now
|
|
|
| BackoutTradeDisc |
numeric(19,5)
0.00
|
Backout Tr...(more) Join Now
|
|
|
| OrigBackoutTradeDisc |
numeric(19,5)
0.00
|
Originatin...(more) Join Now
|
|
|
| GPSFOINTEGRATIONID |
char(31)
''
|
GPSFO Inte...(more) Join Now
|
|
|
| INTEGRATIONSOURCE |
smallint
0
|
Integratio...(more) Join Now
|
|
|
| INTEGRATIONID |
char(31)
''
|
Integratio...(more) Join Now
|
|
|
| CONTNBR |
char(11)
''
|
Contract N...(more) Join Now
|
|
|
| CONTLNSEQNBR |
numeric(19,5)
0.00
|
Contract L...(more) Join Now
|
|
|
| CONTSTARTDTE |
datetime
'1/1/1900'
|
Contract S...(more) Join Now
|
|
|
| CONTENDDTE |
datetime
'1/1/1900'
|
Contract E...(more) Join Now
|
|
|
| CONTITEMNBR |
char(31)
''
|
Contract I...(more) Join Now
|
|
|
| CONTSERIALNBR |
char(21)
''
|
Contract S...(more) Join Now
|
|
|
| BULKPICKPRNT |
tinyint
0
|
Bulk Pick ...(more) Join Now
|
|
|
| INDPICKPRNT |
tinyint
0
|
Individual...(more) Join Now
|
|
|
| ISLINEINTRA |
tinyint
0
|
IsLineInst...(more) Join Now
|
|
|
| SOFULFILLMENTBIN |
char(15)
''
|
SO Fulfill...(more) Join Now
|
|
|
| MULTIPLEBINS |
tinyint
0
|
Multiple B...(more) Join Now
|
|
|
| DEX_ROW_TS |
datetime
(getutcdate())
|
Time Stamp...(more) Join Now
|
|
|
| Print_Phone_NumberGB |
smallint
0
|
Print_Phon...(more) Join Now
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|