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

COMPANY..SOP40100 Table Definition

(COMPANY..Sales Setup)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
COMMNTID char(15)
''
Comment ID...(more) Join Now SOP10100.COMMNTID
join ... more text available
SETUPKEY smallint
0
Setup Key...(more) Join Now IV40100.SETUPKEY
DPYITMCS tinyint
0

DQTYSWAR tinyint
0

TRKVDTRX tinyint
0

CALCKITC tinyint
0

NEWRATES tinyint
0

TRMSTNUM tinyint
0
Indicates ...(more) Join Now
NXTMSTNO int
0

QUOTE tinyint
0

PRDER tinyint
0

INVORETU tinyint
0

ACDSTRBN tinyint
0

LOCNCODE char(11)
''
Location C...(more) Join Now RM00102.LOCNCODE
join ... more text available
CHEKBKID char(15)
''
Checkbook ID Checkbook this transaction affects SY30500.CHEKBKID
join ... more text available
DFQTYSOP smallint
0
Default Qt...(more) Join Now
QUODOCID char(15)
''

ORDDOCID char(15)
''
Field Type...(more) Join Now SVC00203.ORDDOCID
BACDOCID char(15)
''

INVDOCID char(15)
''

RETDOCID char(15)
''
Field Type...(more) Join Now SVC00203.RETDOCID
DECPLQTY smallint
0
Decimal Pl...(more) Join Now
DECPLCUR smallint
0
Number of ...(more) Join Now
USEACFRM smallint
0
Use Postin...(more) Join Now
USEADVTX smallint
0
Use Advanc...(more) Join Now
TAXSCHID char(15)
''
Tax Schedu...(more) Join Now
join ... more text available
NONIVTXB smallint
0

NONIVSCH char(15)
''
Non IV Ite...(more) Join Now
FRGTTXBL smallint
0
Freight Ta...(more) Join Now
FRTSCHID char(15)
''
Freight Sc...(more) Join Now
join ... more text available
MISCTXBL smallint
0
Misc Taxab...(more) Join Now
MSCSCHID char(15)
''
Misc Sched...(more) Join Now
join ... more text available
MPACKSLP smallint
0

MPICKTIC smallint
0

PriceLevelWarning smallint
0

SOPALLOW_1 tinyint
0

SOPALLOW_2 tinyint
0

SOPALLOW_3 tinyint
0

SOPALLOW_4 tinyint
0

SOPALLOW_5 tinyint
0

SOPALLOW_6 tinyint
0

SOPALLOW_7 tinyint
0

SOPALLOW_8 tinyint
0

SOPALLOW_9 tinyint
0

SOPALLOW_10 tinyint
0

SOPPSSWD_1 char(11)
''

SOPPSSWD_2 char(11)
''

SOPPSSWD_3 char(11)
''

SOPPSSWD_4 char(11)
''

SOPPSSWD_5 char(11)
''

SOPPSSWD_6 char(11)
''

SOPPSSWD_7 char(11)
''

SOPPSSWD_8 char(11)
''

SOPPSSWD_9 char(11)
''

SOPPSSWD_10 char(11)
''

IVCDSTCK binary(4)
0

NUMOFTRX int
0
Number Of ...(more) Join Now
USRDFPR1 char(15)
''

USRDRPR2 char(15)
''

USRDRPR3 char(15)
''

USRDRPR4 char(15)
''

USRDRPR5 char(15)
''

USRDRPR6 char(15)
''

USRDRPR7 char(15)
''

USRDRPR8 char(15)
''

USRDRPR9 char(15)
''

USRDRP10 char(15)
''

USRDRP11 char(15)
''

USRDRP12 char(15)
''

USRDFPR13 char(15)
''

USRDFPR14 char(15)
''

USRDFPR15 char(15)
''

USRDFPR16 char(15)
''

USRDFPR17 char(15)
''

CREATDDT datetime
'1/1/1900'
Created Da...(more) Join Now RM00101.CREATDDT
MODIFDT datetime
'1/1/1900'
Date the r...(more) Join Now
REQSHIP smallint
0

REQDAYS smallint
0

SITEPREF smallint
0

PREFSITE char(11)
''

REQDATEPO smallint
0

Required_Days smallint
0

UMDEFAULT smallint
0

COMBONPO tinyint
0

TXBASECS tinyint
0

USEORGUC tinyint
0

Prices_Not_Required_In_Pr tinyint
0

PasswordUpper char(11)
''

Convert_Functional_Price tinyint
0

INDVPICKTICKETSORT smallint
0

PRINTAVAILABLEBINS smallint
0

FODOCID char(15)
''

CombineDropshipSOLines tinyint
0

DEX_ROW_ID int
auto number (1,1)
Unique ide...(more) Join Now
CombineDropshipSODocs tinyint
0

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