| SOPTYPE |
smallint
0
|
Values sto...(more) Join Now
|
|
|
| SOPNUMBE |
char(21)
''
|
The number...(more) Join Now
|
|
|
| ORIGTYPE |
smallint
0
|
Blank if t...(more) Join Now
|
|
join ... more text available
|
| ORIGNUMB |
char(21)
''
|
If the doc...(more) Join Now
|
|
join ... more text available
|
| DOCID |
char(15)
''
|
Indicates ...(more) Join Now
|
|
join ... more text available
|
| DOCDATE |
datetime
'1/1/1900'
|
The date a...(more) Join Now
|
|
|
| GLPOSTDT |
datetime
'1/1/1900'
|
Date that ...(more) Join Now
|
|
|
| QUOTEDAT |
datetime
'1/1/1900'
|
Quote Date...(more) Join Now
|
|
|
| QUOEXPDA |
datetime
'1/1/1900'
|
Quote Expi...(more) Join Now
|
|
|
| ORDRDATE |
datetime
'1/1/1900'
|
Order Date...(more) Join Now
|
|
|
| INVODATE |
datetime
'1/1/1900'
|
Invoice Da...(more) Join Now
|
|
|
| BACKDATE |
datetime
'1/1/1900'
|
Back Order...(more) Join Now
|
|
|
| RETUDATE |
datetime
'1/1/1900'
|
Return Dat...(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
|
|
|
| DISCDATE |
datetime
'1/1/1900'
|
Discount D...(more) Join Now
|
|
|
| DUEDATE |
datetime
'1/1/1900'
|
Due Date: ...(more) Join Now
|
|
|
| REPTING |
tinyint
0
|
Repeating:...(more) Join Now
|
|
|
| TRXFREQU |
smallint
0
|
TRX Freque...(more) Join Now
|
|
|
| TIMEREPD |
smallint
0
|
Times Repe...(more) Join Now
|
|
|
| TIMETREP |
smallint
0
|
Times To R...(more) Join Now
|
|
|
| DYSTINCR |
smallint
0
|
Days to In...(more) Join Now
|
|
|
| DTLSTREP |
datetime
'1/1/1900'
|
Date Last ...(more) Join Now
|
|
|
| DSTBTCH1 |
char(15)
''
|
Dest Batch...(more) Join Now
|
|
|
| DSTBTCH2 |
char(15)
''
|
Dest Batch...(more) Join Now
|
|
|
| USDOCID1 |
char(15)
''
|
Use Docume...(more) Join Now
|
|
|
| USDOCID2 |
char(15)
''
|
Use Docume...(more) Join Now
|
|
|
| DISCFRGT |
numeric(19,5)
0.00
|
Freight: T...(more) Join Now
|
|
|
| ORDAVFRT |
numeric(19,5)
0.00
|
Orig Disco...(more) Join Now
|
|
|
| DISCMISC |
numeric(19,5)
0.00
|
Misc: The ...(more) Join Now
|
|
|
| ORDAVMSC |
numeric(19,5)
0.00
|
Orig Disco...(more) Join Now
|
|
|
| DISAVAMT |
numeric(19,5)
0.00
|
Discount A...(more) Join Now
|
|
|
| ORDAVAMT |
numeric(19,5)
0.00
|
Orig Disco...(more) Join Now
|
|
|
| DISCRTND |
numeric(19,5)
0.00
|
Discount R...(more) Join Now
|
|
|
| ORDISRTD |
numeric(19,5)
0.00
|
Orig Disco...(more) Join Now
|
|
|
| DISTKNAM |
numeric(19,5)
0.00
|
Discount T...(more) Join Now
|
|
|
| ORDISTKN |
numeric(19,5)
0.00
|
Orig Disco...(more) Join Now
|
|
|
| DSCPCTAM |
smallint
0
|
Discount P...(more) Join Now
|
|
|
| DSCDLRAM |
numeric(19,5)
0.00
|
Discount D...(more) Join Now
|
|
|
| ORDDLRAT |
numeric(19,5)
0.00
|
Orig Disco...(more) Join Now
|
|
|
| DISAVTKN |
numeric(19,5)
0.00
|
Discount A...(more) Join Now
|
|
|
| ORDATKN |
numeric(19,5)
0.00
|
Orig Disco...(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
|
| BCHSOURC |
char(15)
''
|
Batch Sour...(more) Join Now
|
|
|
| BACHNUMB |
char(15)
''
|
Batch Numb...(more) Join Now
|
|
join ... more text available
|
| 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
|
|
|
| PROSPECT |
smallint
0
|
Prospect:b...(more) Join Now
|
|
|
| MSTRNUMB |
int
0
|
Master Num...(more) Join Now
|
|
|
| PCKSLPNO |
char(21)
''
|
Packing Sl...(more) Join Now
|
|
|
| PICTICNU |
char(21)
''
|
Picking Ti...(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
|
|
|
| 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
|
|
|
| ShipToName |
char(65)
''
|
ShipToName...(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
|
|
|
| PHNUMBR1 |
char(21)
''
|
Phone Numb...(more) Join Now
|
|
|
| PHNUMBR2 |
char(21)
''
|
Phone Numb...(more) Join Now
|
|
|
| PHONE3 |
char(21)
''
|
Phone 3: P...(more) Join Now
|
|
|
| FAXNUMBR |
char(21)
''
|
Fax Number...(more) Join Now
|
|
|
| COMAPPTO |
smallint
0
|
Commission...(more) Join Now
|
|
|
| COMMAMNT |
numeric(19,5)
0.00
|
Commission...(more) Join Now
|
|
|
| OCOMMAMT |
numeric(19,5)
0.00
|
Orig Commi...(more) Join Now
|
|
|
| CMMSLAMT |
numeric(19,5)
0.00
|
Commission...(more) Join Now
|
|
|
| ORCOSAMT |
numeric(19,5)
0.00
|
Orig Commi...(more) Join Now
|
|
|
| NCOMAMNT |
numeric(19,5)
0.00
|
Non-Commis...(more) Join Now
|
|
|
| ORNCMAMT |
numeric(19,5)
0.00
|
Orig Non-C...(more) Join Now
|
|
|
| SHIPMTHD |
char(15)
''
|
Shipping M...(more) Join Now
|
|
join ... more text available
|
| TRDISAMT |
numeric(19,5)
0.00
|
Trade Disc...(more) Join Now
|
|
|
| ORTDISAM |
numeric(19,5)
0.00
|
Orig Trade...(more) Join Now
|
|
|
| TRDISPCT |
smallint
0
|
span style...(more) Join Now
|
|
|
| SUBTOTAL |
numeric(19,5)
0.00
|
Subtotal: ...(more) Join Now
|
|
|
| ORSUBTOT |
numeric(19,5)
0.00
|
Orig Subto...(more) Join Now
|
|
|
| REMSUBTO |
numeric(19,5)
0.00
|
Remaining ...(more) Join Now
|
|
|
| OREMSUBT |
numeric(19,5)
0.00
|
Orig Remai...(more) Join Now
|
|
|
| EXTDCOST |
numeric(19,5)
0.00
|
Extended C...(more) Join Now
|
|
|
| OREXTCST |
numeric(19,5)
0.00
|
Orig Exten...(more) Join Now
|
|
|
| FRTAMNT |
numeric(19,5)
0.00
|
Freight Am...(more) Join Now
|
|
|
| ORFRTAMT |
numeric(19,5)
0.00
|
Orig Freig...(more) Join Now
|
|
|
| MISCAMNT |
numeric(19,5)
0.00
|
Misc Amoun...(more) Join Now
|
|
|
| ORMISCAMT |
numeric(19,5)
0.00
|
Orig Misc ...(more) Join Now
|
|
|
| TXENGCLD |
tinyint
0
|
Tax Engine...(more) Join Now
|
|
|
| TAXEXMT1 |
char(25)
''
|
Tax Exempt...(more) Join Now
|
|
|
| TAXEXMT2 |
char(25)
''
|
Tax Exempt...(more) Join Now
|
|
|
| TXRGNNUM |
char(25)
''
|
Tax Regist...(more) Join Now
|
|
|
| TAXSCHID |
char(15)
''
|
Tax Schedu...(more) Join Now
|
|
join ... more text available
|
| TXSCHSRC |
smallint
0
|
Tax Schedu...(more) Join Now
|
|
|
| BSIVCTTL |
tinyint
0
|
Based On I...(more) Join Now
|
|
|
| FRTSCHID |
char(15)
''
|
Freight Sc...(more) Join Now
|
|
join ... more text available
|
| FRTTXAMT |
numeric(19,5)
0.00
|
Freight Ta...(more) Join Now
|
|
|
| ORFRTTAX |
numeric(19,5)
0.00
|
Orig Freig...(more) Join Now
|
|
|
| FRGTTXBL |
smallint
0
|
Freight Ta...(more) Join Now
|
|
|
| MSCSCHID |
char(15)
''
|
Misc Sched...(more) Join Now
|
|
join ... more text available
|
| MSCTXAMT |
numeric(19,5)
0.00
|
Misc Tax A...(more) Join Now
|
|
|
| ORMSCTAX |
numeric(19,5)
0.00
|
Orig Misc ...(more) Join Now
|
|
|
| MISCTXBL |
smallint
0
|
Misc Taxab...(more) Join Now
|
|
|
| BKTFRTAM |
numeric(19,5)
0.00
|
Backout Fr...(more) Join Now
|
|
|
| ORBKTFRT |
numeric(19,5)
0.00
|
Orig Backo...(more) Join Now
|
|
|
| BKTMSCAM |
numeric(19,5)
0.00
|
Backout Mi...(more) Join Now
|
|
|
| ORBKTMSC |
numeric(19,5)
0.00
|
Orig Backo...(more) Join Now
|
|
|
| BCKTXAMT |
numeric(19,5)
0.00
|
Backout Ta...(more) Join Now
|
|
|
| OBTAXAMT |
numeric(19,5)
0.00
|
Orig Backo...(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
|
|
|
| TAXAMNT |
numeric(19,5)
0.00
|
Tax Amount...(more) Join Now
|
|
|
| ORTAXAMT |
numeric(19,5)
0.00
|
Orig Tax A...(more) Join Now
|
|
|
| ECTRX |
tinyint
0
|
EC Transac...(more) Join Now
|
|
|
| DOCAMNT |
numeric(19,5)
0.00
|
Document A...(more) Join Now
|
|
|
| ORDOCAMT |
numeric(19,5)
0.00
|
Orig Docum...(more) Join Now
|
|
|
| PYMTRCVD |
numeric(19,5)
0.00
|
Payment Re...(more) Join Now
|
|
|
| ORPMTRVD |
numeric(19,5)
0.00
|
Orig Payme...(more) Join Now
|
|
|
| DEPRECVD |
numeric(19,5)
0.00
|
Deposit Re...(more) Join Now
|
|
|
| ORDEPRVD |
numeric(19,5)
0.00
|
Orig Depos...(more) Join Now
|
|
|
| CODAMNT |
numeric(19,5)
0.00
|
COD Amount...(more) Join Now
|
|
|
| ORCODAMT |
numeric(19,5)
0.00
|
Orig COD A...(more) Join Now
|
|
|
| ACCTAMNT |
numeric(19,5)
0.00
|
Account Am...(more) Join Now
|
|
|
| ORACTAMT |
numeric(19,5)
0.00
|
Orig Accou...(more) Join Now
|
|
|
| SALSTERR |
char(15)
''
|
Sales Terr...(more) Join Now
|
|
join ... more text available
|
| SLPRSNID |
char(15)
''
|
Salesperso...(more) Join Now
|
|
join ... more text available
|
| UPSZONE |
char(3)
''
|
UPS Zone: ...(more) Join Now
|
|
|
| TIMESPRT |
smallint
0
|
Times Prin...(more) Join Now
|
|
|
| PSTGSTUS |
smallint
0
|
Posting St...(more) Join Now
|
|
|
| VOIDSTTS |
smallint
0
|
Void Statu...(more) Join Now
|
|
|
| ALLOCABY |
smallint
0
|
Allocate B...(more) Join Now
|
|
|
| NOTEINDX |
numeric(19,5)
0.00
|
Note Index...(more) Join Now
|
|
join ... more text available
|
| CURNCYID |
char(15)
''
|
Currency I...(more) Join Now
|
|
join ... more text available
|
| CURRNIDX |
smallint
0
|
Currency I...(more) Join Now
|
|
join ... more text available
|
| RATETPID |
char(15)
''
|
Rate Type ...(more) Join Now
|
|
|
| EXGTBLID |
char(15)
''
|
Exchange T...(more) Join Now
|
|
|
| XCHGRATE |
numeric(19,7)
0.00
|
Exchange R...(more) Join Now
|
|
|
| DENXRATE |
numeric(19,7)
0.00
|
Denominati...(more) Join Now
|
|
|
| EXCHDATE |
datetime
'1/1/1900'
|
Exchange D...(more) Join Now
|
|
|
| TIME1 |
datetime
'1/1/1900'
|
Time: The ...(more) Join Now
|
|
|
| RTCLCMTD |
smallint
0
|
Rate Calcu...(more) Join Now
|
|
|
| MCTRXSTT |
smallint
0
|
MC Transac...(more) Join Now
|
|
|
| TRXSORCE |
char(13)
''
|
Transactio...(more) Join Now
|
|
|
| SOPHDRE1 |
binary(4)
0
|
SOP HDR Er...(more) Join Now
|
|
|
| SOPHDRE2 |
binary(4)
0
|
SOP HDR Er...(more) Join Now
|
|
|
| SOPLNERR |
binary(4)
0
|
SOP LINE E...(more) Join Now
|
|
|
| SOPHDRFL |
binary(4)
0
|
SOP HDR Fl...(more) Join Now
|
|
|
| SOPMCERR |
binary(4)
0
|
SOP MC Pos...(more) Join Now
|
|
|
| COMMNTID |
char(15)
''
|
Comment ID...(more) Join Now
|
|
join ... more text available
|
| REFRENCE |
char(31)
''
|
Reference:...(more) Join Now
|
|
|
| POSTEDDT |
datetime
'1/1/1900'
|
Posted Dat...(more) Join Now
|
|
|
| PTDUSRID |
char(15)
''
|
Posted Use...(more) Join Now
|
|
|
| USER2ENT |
char(15)
''
|
User To En...(more) Join Now
|
|
|
| CREATDDT |
datetime
'1/1/1900'
|
Created Da...(more) Join Now
|
|
|
| MODIFDT |
datetime
'1/1/1900'
|
Date the r...(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
|
|
|
| SHPPGDOC |
tinyint
0
|
Shipping D...(more) Join Now
|
|
|
| CORRCTN |
tinyint
0
|
Correction...(more) Join Now
|
|
|
| SIMPLIFD |
tinyint
0
|
Simplified...(more) Join Now
|
|
|
| CORRNXST |
tinyint
0
|
Correction...(more) Join Now
|
|
|
| DOCNCORR |
char(21)
''
|
Document N...(more) Join Now
|
|
|
| SEQNCORR |
smallint
0
|
Sequence N...(more) Join Now
|
|
|
| SALEDATE |
datetime
'1/1/1900'
|
Sale Date:...(more) Join Now
|
|
|
| SOPHDRE3 |
binary(4)
0
|
SOP HDR Er...(more) Join Now
|
|
|
| EXCEPTIONALDEMAND |
tinyint
0
|
Exceptiona...(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
|
|
|
| SOPSTATUS |
smallint
0
|
SOP Status...(more) Join Now
|
|
|
| SHIPCOMPLETE |
tinyint
0
|
Ship Compl...(more) Join Now
|
|
|
| DIRECTDEBIT |
tinyint
0
|
Direct Deb...(more) Join Now
|
|
|
| WorkflowApprStatCreditLm |
smallint
0
|
Workflow A...(more) Join Now
|
|
|
| WorkflowPriorityCreditLm |
smallint
0
|
Workflow P...(more) Join Now
|
|
|
| WorkflowApprStatusQuote |
smallint
0
|
Workflow A...(more) Join Now
|
|
|
| WorkflowPriorityQuote |
smallint
0
|
Workflow P...(more) Join Now
|
|
|
| ContractExchangeRateStat |
smallint
0
|
|
|
|
| Workflow_Status |
smallint
0
|
|
|
|
| DEX_ROW_TS |
datetime
(getutcdate())
|
Time Stamp...(more) Join Now
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
| Print_Phone_NumberGB |
smallint
0
|
Print_Phon...(more) Join Now
|
|
|