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

COMPANY..SOP10100 Table Definition

(COMPANY..Sales Transaction Work)

This file stores all unpostede transaction information until it is posted. Records in this file relate to a specific record in the Batch_Headers file.
This table contains the identifying document information for all sales documents entered using the Sales Transaction Entry window (and also the Quotes, Orders, Invoices, and Returns windows). Transaction line item-related records are stored in the SOP_LINE_WORK table. Each record represents a document that has been entered using the Sales Transaction Entry window or created through the transfer process using the Sales Transfer Documents window.
SOP and MC

The following describes changes made as a result of SOP MC. The focus of this discussion is on a non-MC SOP transaction. In SBF, multiple currencies are not supported.
Currency ID-This should be blank for non-MC SOP transactions.
Currency Index-This should be the 'Functional Currency Index' of globals for non-MC SOP transactions.
Rate Type ID-This should be blank for non-MC SOP transactions.
Exchange Table ID-This should be blank for non-MC SOP transactions.
Exchange Rate-This should be blank for non-MC SOP transactions.
Exchange Date-This should be blank for non-MC SOP transactions.
Time-This should be blank for non-MC SOP transactions.
Rate Calculation Method-This should be blank for non-MC SOP transactions.

"Originating" values-The originating currency values (typically in the format "Originating ") are the primary currency values used for a SOP transaction. The corresponding functional currency values (typically in the format "") are calculated from the corresponding originating currency value. For a non-MC SOP transaction, the originating and functional currency values will be the same. Leaving either the originating currency value or the functional currency value blank for a non-MC SOP transaction is not allowed. If the value is not being used, both the originating and functional currency values should be blank.

Optional:
Tax Date - Required for VAT.
Denomination Exchange Rate - Required for Euro Triangulation.
MC Transaction State - Required for Euro.
Display Name Sales Transaction Work


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
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
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