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

COMPANY..SVC05015 Table Definition

(COMPANY..SVC_RMA_Receiving_WORK)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
USERID char(15)
''
The user t...(more) Join Now
join ... more text available
RETDOCID char(15)
''
Field Type...(more) Join Now
LNSEQNBR numeric(19,5)
0
Line SEQ N...(more) Join Now
RMA_Status smallint
0

TECHID char(11)
''
Field Type...(more) Join Now
RETTYPE char(11)
''
Field Type...(more) Join Now
OFFID char(11)
''
Field Type...(more) Join Now
CUSTNMBR char(15)
''
Field Type...(more) Join Now
join ... more text available
ADRSCODE char(15)
''
Field Type...(more) Join Now
CUSTNAME char(65)
''
Field Type...(more) Join Now
QUANTITY numeric(19,5)
0.00
Field Type...(more) Join Now
ITEMNMBR char(31)
''
Field Type...(more) Join Now
join ... more text available
Return_Item_Number char(31)
''

Return_QTY numeric(19,5)
0.00

LOCNCODE char(11)
''
Field Type...(more) Join Now
join ... more text available
BINNMBR char(21)
''
Bin Number...(more) Join Now IV00102.BINNMBR
ORDDOCID char(15)
''
Field Type...(more) Join Now
CALLNBR char(11)
''
Field Type...(more) Join Now
RETREF char(31)
''

CB_Packing_Slip tinyint
0

CHDFLAG tinyint
0

MKDTOPST tinyint
0
Field Type...(more) Join Now
POSTED tinyint
0
Field Type...(more) Join Now
ERMSGNBR smallint
0
Field Type...(more) Join Now
ERMSGTXT char(255)
''
Field Type...(more) Join Now
ERMSGTX2 char(255)
''
Field Type...(more) Join Now
SOPTYPE smallint
0
Field Type...(more) Join Now
SOPNUMBE char(21)
''
Field Type...(more) Join Now
UOFM char(9)
''
Field Type...(more) Join Now
See I... more text available
Return_U_Of_M char(9)
''

DECPLQTY smallint
0
Decimal Pl...(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