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

COMPANY..SOP10200 Table Definition

(COMPANY..Sales Transaction Amounts Work)

Table Description:
This table contains transaction information for each line item on an unposted transaction. Each record in this table represents one line item and is associated with one record in the SOP_HDR_WORK table. If the line item is serial numbered or lot numbered, records for the serial or lot numbers are added to the SOP_Serial_Lot_WORK_HIST table.

Comments:
The TRX Source is an internally assigned audit trail code that will be saved with the record when a transaction is posted.

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.
Currency Index-This should be the 'Functional Currency Index' of globals 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.


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