Module List > Module SOP tables SOP30200
You are currently viewing the COMPANY database.
Change

COMPANY..SOP30200 Table Definition

(COMPANY..Sales Transaction History)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
SOPTYPE smallint
0
Values sto...(more) Join Now
SOPNUMBE char(21)
''
The number...(more) Join Now
ORIGTYPE smallint
0
span style...(more) Join Now
ORIGNUMB char(21)
''

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'

QUOEXPDA datetime
'1/1/1900'
Field Type...(more) Join Now SVC00600.QUOEXPDA
ORDRDATE datetime
'1/1/1900'

INVODATE datetime
'1/1/1900'
Field Type...(more) Join Now SVC00605.INVODATE
BACKDATE datetime
'1/1/1900'

RETUDATE datetime
'1/1/1900'

ReqShipDate datetime
'1/1/1900'
Requested ...(more) Join Now SOP10100.ReqShipDate
FUFILDAT datetime
'1/1/1900'
Fulfillmen...(more) Join Now SOP10100.FUFILDAT
ACTLSHIP datetime
'1/1/1900'
Actual Shi...(more) Join Now POP30300.ACTLSHIP
DISCDATE datetime
'1/1/1900'
Discount D...(more) Join Now PM10000.DISCDATE
DUEDATE datetime
'1/1/1900'
Due Date: ...(more) Join Now PM10000.DUEDATE
REPTING tinyint
0
Repeating:...(more) Join Now SOP10100.REPTING
TRXFREQU smallint
0
TRX Freque...(more) Join Now SOP10100.TRXFREQU
TIMEREPD smallint
0
Times Repe...(more) Join Now SOP10100.TIMEREPD
TIMETREP smallint
0
Times To R...(more) Join Now SOP10100.TIMETREP
DYSTINCR smallint
0
Days to In...(more) Join Now SOP10100.DYSTINCR
DTLSTREP datetime
'1/1/1900'
Date Last ...(more) Join Now SOP10100.DTLSTREP
DSTBTCH1 char(15)
''
Dest Batch...(more) Join Now SOP10100.DSTBTCH1
DSTBTCH2 char(15)
''
Dest Batch...(more) Join Now SOP10100.DSTBTCH2
USDOCID1 char(15)
''
Use Docume...(more) Join Now SOP10100.USDOCID1
USDOCID2 char(15)
''
Freight: T...(more) Join Now SOP10100.USDOCID2
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 RM20101.DSCPCTAM
DSCDLRAM numeric(19,5)
0.00
Discount D...(more) Join Now PM10000.DSCDLRAM
ORDDLRAT numeric(19,5)
0.00
Orig Disco...(more) Join Now POP10300.ORDDLRAT
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 PM10000.PYMTRMID
SY033... more text available
PRCLEVEL char(11)
''
Price Leve...(more) Join Now RM00101.PRCLEVEL
LOCNCODE char(11)
''
Location C...(more) Join Now RM00102.LOCNCODE
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 RM20101.CUSTNMBR
join ... more text available
CUSTNAME char(65)
''
Customer N...(more) Join Now RM10301.CUSTNAME
CSTPONBR char(21)
''
Tax Schedu...(more) Join Now RM10301.CSTPONBR
PROSPECT smallint
0
Prospect:b...(more) Join Now SOP10100.PROSPECT
MSTRNUMB int
0
Master Num...(more) Join Now SOP10100.MSTRNUMB
PCKSLPNO char(21)
''
Packing Sl...(more) Join Now SOP10100.PCKSLPNO
PICTICNU char(21)
''
Picking Ti...(more) Join Now SOP10100.PICTICNU
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 RM00101.PRBTADCD
join ... more text available
PRSTADCD char(15)
''
Primary Sh...(more) Join Now RM00101.PRSTADCD
join ... more text available
CNTCPRSN char(61)
''
Contact Pe...(more) Join Now RM00101.CNTCPRSN
ShipToName char(65)
''
ShipToName...(more) Join Now SOP10100.ShipToName
ADDRESS1 char(61)
''
Address 1:...(more) Join Now RM00101.ADDRESS1
ADDRESS2 char(61)
''
Address 2:...(more) Join Now RM00101.ADDRESS2
ADDRESS3 char(61)
''
Address 3:...(more) Join Now RM00101.ADDRESS3
CITY char(35)
''
City: City...(more) Join Now RM00101.CITY
STATE char(29)
''
State: Up...(more) Join Now RM00101.STATE
ZIPCODE char(11)
''
Zip Code: ...(more) Join Now SOP10100.ZIPCODE
CCode char(7)
''
Country Co...(more) Join Now RM00101.CCode
COUNTRY char(61)
''
Country: C...(more) Join Now RM00101.COUNTRY
PHNUMBR1 char(21)
''
Phone Numb...(more) Join Now SOP10100.PHNUMBR1
PHNUMBR2 char(21)
''
Phone Numb...(more) Join Now SOP10100.PHNUMBR2
PHONE3 char(21)
''
Phone 3: ...(more) Join Now RM00101.PHONE3
FAXNUMBR char(21)
''
Fax Number...(more) Join Now SOP10100.FAXNUMBR
COMAPPTO smallint
0
Commission...(more) Join Now RM10301.COMAPPTO
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 RM20101.SHIPMTHD
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

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 SOP10100.EXTDCOST
OREXTCST numeric(19,5)
0.00
Orig Exten...(more) Join Now SOP10100.OREXTCST
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 RM10301.TXENGCLD
TAXEXMT1 char(25)
''
Tax Exempt...(more) Join Now RM00101.TAXEXMT1
TAXEXMT2 char(25)
''
Tax Exempt...(more) Join Now RM00101.TAXEXMT2
TXRGNNUM char(25)
''
Tax Regist...(more) Join Now RM00101.TXRGNNUM
TAXSCHID char(15)
''
Tax Schedu...(more) Join Now PM10000.TAXSCHID
join ... more text available
TXSCHSRC smallint
0
Tax Schedu...(more) Join Now SOP10100.TXSCHSRC
BSIVCTTL tinyint
0
Based On I...(more) Join Now POP10300.BSIVCTTL
FRTSCHID char(15)
''
Freight Sc...(more) Join Now RM20101.FRTSCHID
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 SOP10100.FRGTTXBL
MSCSCHID char(15)
''
Misc Sched...(more) Join Now RM20101.MSCSCHID
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 SOP10100.MISCTXBL
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 RM20101.TAXAMNT
ORTAXAMT numeric(19,5)
0.00
Orig Tax A...(more) Join Now POP10300.ORTAXAMT
ECTRX tinyint
0
EC Transac...(more) Join Now RM20101.ECTRX
DOCAMNT numeric(19,5)
0.00
Source Doc...(more) Join Now PM10000.DOCAMNT
ORDOCAMT numeric(19,5)
0.00
Orig Docum...(more) Join Now SOP10100.ORDOCAMT
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 RM10301.SALSTERR
join ... more text available
SLPRSNID char(15)
''
Salesperso...(more) Join Now RM20101.SLPRSNID
join ... more text available
UPSZONE char(3)
''
UPS Zone: ...(more) Join Now RM00101.UPSZONE
TIMESPRT smallint
0
Times Prin...(more) Join Now SOP10100.TIMESPRT
PSTGSTUS smallint
0
Posting St...(more) Join Now
VOIDSTTS smallint
0
Void Statu...(more) Join Now POP30300.VOIDSTTS
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 CM20000
join ... more text available
CURRNIDX smallint
0
Currency I...(more) Join Now CM20200.CURRNIDX
join ... more text available
RATETPID char(15)
''
A valid Ra...(more) Join Now
EXGTBLID char(15)
''
Exchange T...(more) Join Now CM20200.EXGTBLID
XCHGRATE numeric(19,7)
0.00
Exchange R...(more) Join Now CM20200.XCHGRATE
DENXRATE numeric(19,7)
0.00
Denominati...(more) Join Now CM20200.DENXRATE
EXCHDATE datetime
'1/1/1900'
Exchange D...(more) Join Now CM20200.EXCHDATE
TIME1 datetime
'1/1/1900'
Time see ...(more) Join Now CM20200.TIME1
RTCLCMTD smallint
0
Rate Calcu...(more) Join Now CM20200.RTCLCMTD
MCTRXSTT smallint
0
MC Transac...(more) Join Now CM20200.MCTRXSTT
TRXSORCE char(13)
''
Transactio...(more) Join Now
SOPHDRE1 binary(4)
0
SOP HDR Er...(more) Join Now SOP10100.SOPHDRE1
SOPHDRE2 binary(4)
0
SOP HDR Er...(more) Join Now SOP10100.SOPHDRE2
SOPLNERR binary(4)
0
SOP LINE E...(more) Join Now SOP10100.SOPLNERR
SOPHDRFL binary(4)
0
SOP HDR Fl...(more) Join Now SOP10100.SOPHDRFL
COMMNTID char(15)
''
Comment ID...(more) Join Now SOP10100.COMMNTID
join ... more text available
REFRENCE char(31)
''
Reference:...(more) Join Now POP10300.REFRENCE
POSTEDDT datetime
'1/1/1900'
Posted Dat...(more) Join Now RM10301.POSTEDDT
PTDUSRID char(15)
''
Posted Use...(more) Join Now RM10301.PTDUSRID
USER2ENT char(15)
''
User To En...(more) Join Now POP30300.USER2ENT
CREATDDT datetime
'1/1/1900'
Created Da...(more) Join Now RM00101.CREATDDT
MODIFDT datetime
'1/1/1900'
Date the r...(more) Join Now
Tax_Date datetime
'1/1/1900'
Tax Date: ...(more) Join Now RM20101.Tax_Date
APLYWITH tinyint
0
Apply With...(more) Join Now RM20101.APLYWITH
WITHHAMT numeric(19,5)
0.00
Withholdin...(more) Join Now
SHPPGDOC tinyint
0
Shipping D...(more) Join Now SOP10100.SHPPGDOC
CORRCTN tinyint
0
Correction...(more) Join Now
SIMPLIFD tinyint
0
Simplified...(more) Join Now RM20101.SIMPLIFD
DOCNCORR char(21)
''
Document N...(more) Join Now RM10301.DOCNCORR
SEQNCORR smallint
0
Sequence N...(more) Join Now SOP10100.SEQNCORR
SALEDATE datetime
'1/1/1900'
Sale Date:...(more) Join Now RM20101.SALEDATE
EXCEPTIONALDEMAND tinyint
0
Exceptiona...(more) Join Now SOP10100.EXCEPTIONALDEMAND
Flags smallint
0
Flags: The...(more) Join Now POP10100.Flags
SOPSTATUS smallint
0
SOP Status...(more) Join Now SOP10100.SOPSTATUS
SHIPCOMPLETE tinyint
0
Ship Compl...(more) Join Now RM00101.SHIPCOMPLETE
DIRECTDEBIT tinyint
0
Direct Deb...(more) Join Now SOP10100.DIRECTDEBIT
WorkflowApprStatCreditLm smallint
0
Workflow A...(more) Join Now SOP10100.WorkflowApprStatCreditLm
WorkflowPriorityCreditLm smallint
0
Workflow P...(more) Join Now SOP10100.WorkflowPriorityCreditLm
WorkflowApprStatusQuote smallint
0
Workflow A...(more) Join Now SOP10100.WorkflowApprStatusQuote
WorkflowPriorityQuote smallint
0
Workflow P...(more) Join Now SOP10100.WorkflowPriorityQuote
Workflow_Status smallint
0

ContractExchangeRateStat 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
Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3