DynDeveloper.com

DynDeveloper.com
Table Edits Forum Articles
Table Edits 0 Table Edits 0 Table Edits 0
Sign Up Now! Log In
Search the GP Tables
Search by TABLE NAME
Search by FIELD NAME
These are our SOP scripts. All of our scripts for Dynamics GP can be found here
Module List > Module SOP tables SOP30300
You are currently viewing the COMPANY database.
Change

COMPANY..SOP30300 Table Definition

(COMPANY..Sales Transaction Amounts 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
LNITMSEQ int
0
Line Item ...(more) Join Now PA01301.LNITMSEQ
CMPNTSEQ int
0
Component ...(more) Join Now SOP10200.CMPNTSEQ
ITEMNMBR char(31)
''
span style...(more) Join Now IV00103.ITEMNMBR
join ... more text available
ITEMDESC char(101)
''
Item Descr...(more) Join Now IV00101.ITEMDESC
NONINVEN smallint
0
Non-IV: Th...(more) Join Now SOP10200.NONINVEN
DROPSHIP smallint
0
Drop Ship:...(more) Join Now SOP10200.DROPSHIP
UOFM char(9)
''
U of M The...(more) Join Now
See I... more text available
LOCNCODE char(11)
''
Location C...(more) Join Now RM00102.LOCNCODE
join ... more text available
UNITCOST numeric(19,5)
0.00
Unit Cost:...(more) Join Now SOP10200.UNITCOST
ORUNTCST numeric(19,5)
0.00
Unit Price...(more) Join Now SOP10200.ORUNTCST
UNITPRCE numeric(19,5)
0.00
Unit Price...(more) Join Now SOP10200.UNITPRCE
ORUNTPRC numeric(19,5)
0.00
Originatin...(more) Join Now SOP10200.ORUNTPRC
XTNDPRCE numeric(19,5)
0.00
Extended P...(more) Join Now SOP10200.XTNDPRCE
OXTNDPRC numeric(19,5)
0.00
Originatin...(more) Join Now SOP10200.OXTNDPRC
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 SOP10100.EXTDCOST
OREXTCST numeric(19,5)
0.00
Orig Exten...(more) Join Now SOP10100.OREXTCST
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 SOP10200.MRKDNPCT
MRKDNTYP smallint
0
Markdown T...(more) Join Now SOP10200.MRKDNTYP
INVINDX int
0
Inventory ...(more) Join Now SOP10200.INVINDX
CSLSINDX int
0
Cost Of Sa...(more) Join Now SOP10200.CSLSINDX
SLSINDX int
0
Sales Inde...(more) Join Now SOP10200.SLSINDX
MKDNINDX int
0
Markdown I...(more) Join Now SOP10200.MKDNINDX
RTNSINDX int
0
Returns In...(more) Join Now SOP10200.RTNSINDX
INUSINDX int
0
In Use Ind...(more) Join Now SOP10200.INUSINDX
INSRINDX int
0
In Service...(more) Join Now SOP10200.INSRINDX
DMGDINDX int
0
Damaged In...(more) Join Now SOP10200.DMGDINDX
ITMTSHID char(15)
''
Item Tax S...(more) Join Now IV00101.ITMTSHID
IVITMTXB smallint
0
IV Item Ta...(more) Join Now SOP10200.IVITMTXB
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 RM20101.TAXAMNT
ORTAXAMT numeric(19,5)
0.00
Orig Tax A...(more) Join Now POP30300.ORTAXAMT
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 POP10300.BSIVCTTL
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 SOP10200.QUANTITY
ATYALLOC numeric(19,5)
0.00
QTY Alloca...(more) Join Now IV00102.ATYALLOC
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 IV00102.QTYONHND
QTYCANCE numeric(19,5)
0.00
QTY Cancel...(more) Join Now SOP10200.QTYCANCE
QTYCANOT numeric(19,5)
0.00
QTY Cancel...(more) Join Now
QTYORDER numeric(19,5)
0.00
QTY Ordere...(more) Join Now SOP10200.QTYORDER
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 SOP10200.QTYRECVD
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 SOP10200.QTYFULFI
QTYSLCTD numeric(19,5)
0.00
QTY Select...(more) Join Now SOP10200.QTYSLCTD
QTYBSUOM numeric(19,5)
0.00
QTY In Bas...(more) Join Now SOP10200.QTYBSUOM
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 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
SHIPMTHD char(15)
''
Shipping M...(more) Join Now RM20101.SHIPMTHD
join ... more text available
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
PRCLEVEL char(11)
''
Price Leve...(more) Join Now RM00101.PRCLEVEL
COMMNTID char(15)
''
Comment ID...(more) Join Now SOP10100.COMMNTID
join ... more text available
BRKFLD1 smallint
0
Break Fiel...(more) Join Now SOP10200.BRKFLD1
BRKFLD2 smallint
0
Break Fiel...(more) Join Now SOP10200.BRKFLD2
BRKFLD3 smallint
0
Break Fiel...(more) Join Now SOP10200.BRKFLD3
CURRNIDX smallint
0
Currency I...(more) Join Now CM20200.CURRNIDX
join ... more text available
TRXSORCE char(13)
''
Transactio...(more) Join Now
SOPLNERR binary(4)
0
SOP LINE E...(more) Join Now SOP10100.SOPLNERR
DOCNCORR char(21)
''
Document N...(more) Join Now RM10301.DOCNCORR
ORGSEQNM int
0
Original S...(more) Join Now SOP10200.ORGSEQNM
ITEMCODE char(15)
''
Item Code:...(more) Join Now IV00101.ITEMCODE
PURCHSTAT smallint
0
Purchasing...(more) Join Now SOP10200.PURCHSTAT
DECPLQTY smallint
0
 Decimal Pl...(more) Join Now
DECPLCUR smallint
0
 Number of ...(more) Join Now
ODECPLCU smallint
0
Originatin...(more) Join Now SOP10200.ODECPLCU
EXCEPTIONALDEMAND tinyint
0
Exceptiona...(more) Join Now SOP10100.EXCEPTIONALDEMAND
TAXSCHID char(15)
''
Tax Schedu...(more) Join Now PM10000.TAXSCHID
join ... more text available
TXSCHSRC smallint
0
Tax Schedu...(more) Join Now SOP10100.TXSCHSRC
PRSTADCD char(15)
''
Primary Sh...(more) Join Now RM00101.PRSTADCD
join ... more text available
ShipToName char(65)
''
ShipToName...(more) Join Now SOP10100.ShipToName
CNTCPRSN char(61)
''
Contact Pe...(more) Join Now RM00101.CNTCPRSN
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
PHONE1 char(21)
''
Phone 1: ...(more) Join Now
PHONE2 char(21)
''
Phone 2: ...(more) Join Now
PHONE3 char(21)
''
Phone 3: ...(more) Join Now
FAXNUMBR char(21)
''
Fax Number...(more) Join Now
Flags smallint
0
Flags: The...(more) Join Now POP10100.Flags
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)
''
Bulk Pick ...(more) Join Now SOP10200.CONTSERIALNBR
ISLINEINTRA tinyint
0
SO Fulfill...(more) Join Now SOP10200.ISLINEINTRA
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
Archives | Table Listing | eConnect Error Database | eConnect Schema | Gold Star Locksmith
3