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

COMPANY..SVC05115 Table Definition

(COMPANY..SVC_RMA_Closing_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
RETTYPE char(11)
''
Field Type...(more) Join Now
OFFID char(11)
''
Field Type...(more) Join Now
TECHID 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
Return_Item_Number char(31)
''

Return_QTY numeric(19,5)
0.00

Repair_Cost numeric(19,5)
0.00

Repair_Price numeric(19,5)
0.00

Originating_Repair_Cost numeric(19,5)
0.00

Originating_Repair_Price numeric(19,5)
0.00

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
PRNTDTLD tinyint
0

SVC_Bill_To_Address_Code char
''

DEX_ROW_ID int
auto number (1,1)
Unique ide...(more) Join Now
CSTPONBR char
''

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