Module List > Module SVC tables SVC00710
You are currently viewing the COMPANY database.
Change

COMPANY..SVC00710 Table Definition

(COMPANY..SVC_Inventory_Requirements_Work)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
SRCDOCNUM char(21)
''
Source Doc...(more) Join Now CM20300.SRCDOCNUM
SRCDOCTYP smallint
0
Source Doc...(more) Join Now CM20300.SRCDOCTYP
ITEMNMBR char(31)
''
Field Type...(more) Join Now
join ... more text available
LNITMSEQ int
0
Field Type...(more) Join Now
ITEMDESC char(101)
''
Field Type...(more) Join Now
LOCNCODE char(11)
''
Field Type...(more) Join Now
join ... more text available
QTYORDER numeric(19,5)
0.00
Field Type...(more) Join Now
TRNSFLOC char(11)
''
Field Type...(more) Join Now
TECHID char(11)
''
Field Type...(more) Join Now
QTYBACKO numeric(19,5)
0.00
Field Type...(more) Join Now
UOFM char(9)
''
Field Type...(more) Join Now
See I... more text available
ATYALLOC numeric(19,5)
0.00
Field Type...(more) Join Now
TRNSFQTY numeric(19,5)
0.00
Field Type...(more) Join Now
STATIONID char(11)
''

OFFID char(11)
''
Field Type...(more) Join Now
TRNFLAG tinyint
0
Field Type...(more) Join Now
SVC_Disable_XFR_Grouping tinyint
0
Field Type...(more) Join Now
USERID char(15)
''
The user t...(more) Join Now
join ... more text available
ERMSGNBR smallint
0
Field Type...(more) Join Now
ERMSGTXT char(255)
''
Field Type...(more) Join Now
ERMSGTX2 char(255)
''
Field Type...(more) Join Now
VENDORID char(15)
''
Field Type...(more) Join Now
join ... more text available
SVC_Address_Option smallint
0
Field Type...(more) Join Now
SVC_Misc_Address_Code char(15)
''
Field Type...(more) Join Now
PRMDATE datetime
'1/1/1900'
Promised D...(more) Join Now POP10100.PRMDATE
MKDTOPST tinyint
0
Field Type...(more) Join Now
LINITMTYP char(3)
''
Field Type...(more) Join Now
CMPNTSEQ int
0
Component ...(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