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

COMPANY..SVC35600 Table Definition

(COMPANY..SVC_RTV_MSTR_HIST)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
RTV_Number char(15)
''

RTV_Type char(11)
''

RTV_Return_Status char(3)
''

RTV_Status smallint
0

VRMA_Document_ID char(15)
''

RETDOCID char(15)
''
Field Type...(more) Join Now
LNSEQNBR numeric(19,5)
0
Line SEQ N...(more) Join Now
DSCRIPTN char(31)
''
Field Type...(more) Join Now
VENDORID char(15)
''
Field Type...(more) Join Now
join ... more text available
VENDNAME char(65)
''
Vendor Nam...(more) Join Now POP10100.VENDNAME
ADRSCODE char(15)
''
Field Type...(more) Join Now
Ship_Address_Name char(65)
''

Ship_Address_1 char(61)
''

Ship_Address_2 char(61)
''

Ship_Address_3 char(61)
''

Ship_City char(35)
''

Ship_State char(29)
''

ZIPCODE char(11)
''
Field Type...(more) Join Now
Ship_Country char(61)
''

ENTDTE datetime
'1/1/1900'
Field Type...(more) Join Now
ENTTME datetime
'1/1/1900'
Field Type...(more) Join Now
PRMDATE datetime
'1/1/1900'
Promised D...(more) Join Now POP10100.PRMDATE
Promised_Time datetime
'1/1/1900'

Shipped_Date datetime
'1/1/1900'

Shipped_Time datetime
'1/1/1900'

receiptdate datetime
'1/1/1900'
Receipt Da...(more) Join Now POP10300.receiptdate
Receipt_Time datetime
'1/1/1900'

COMPDTE datetime
'1/1/1900'
Field Type...(more) Join Now
COMPTME datetime
'1/1/1900'
Field Type...(more) Join Now
LOCCODEB char(11)
''
Field Type...(more) Join Now
LOCNCODE char(11)
''
Field Type...(more) Join Now
join ... more text available
Part_Price numeric(19,5)
0.00

Part_Cost numeric(19,5)
0.00

Labor_Price numeric(19,5)
0.00

Labor_Cost numeric(19,5)
0.00

Expense_Price numeric(19,5)
0.00

Expense_Cost numeric(19,5)
0.00

Travel_Price numeric(19,5)
0.00

Travel_Cost numeric(19,5)
0.00

Bill_of_Lading_Out char(31)
''

Shipping_Method_Out char(15)
''

Bill_of_Lading char(31)
''

SHIPMTHD char(15)
''
Shipping M...(more) Join Now RM20101.SHIPMTHD
join ... more text available
OFFID char(11)
''
Field Type...(more) Join Now
NOTEINDX numeric(19,5)
0.00
Note Index...(more) Join Now
join ... more text available
VCHNUMWK char(17)
''
Voucher Nu...(more) Join Now PM10000.VCHNUMWK
Voucher_Number_Invoice char(17)
''

Voucher_Number_Reimburse char(17)
''

CUSTOWN tinyint
0

USERID char(15)
''
The user t...(more) Join Now
join ... more text available
USERDEF1 char(21)
''
Field Type...(more) Join Now
USERDEF2 char(21)
''
Field Type...(more) Join Now
USRDEF03 char(21)
''
Field Type...(more) Join Now
USRDEF04 char(21)
''
Field Type...(more) Join Now
USRDEF05 char(21)
''
Field Type...(more) Join Now
CURNCYID char(15)
''
Field Type...(more) Join Now
join ... more text available
CURRNIDX smallint
0
Field Type...(more) Join Now
join ... more text available
RATETPID char(15)
''
Field Type...(more) Join Now
EXGTBLID char(15)
''
Field Type...(more) Join Now
XCHGRATE numeric(19,7)
0.00
Field Type...(more) Join Now
EXCHDATE datetime
'1/1/1900'
Field Type...(more) Join Now
DECPLACS smallint
0
Field Type...(more) Join Now
TIME1 datetime
'1/1/1900'
Field Type...(more) Join Now
RATECALC smallint
0
Field Type...(more) Join Now
VIEWMODE smallint
0
Field Type...(more) Join Now
ISMCTRX smallint
0
Field Type...(more) Join Now
EXPNDATE datetime
'1/1/1900'
Field Type...(more) Join Now
DENXRATE numeric(19,7)
0.00
Field Type...(more) Join Now
MCTRXSTT smallint
0
Field Type...(more) Join Now
Originating_Part_Price numeric(19,5)
0.00

Originating_Part_Cost numeric(19,5)
0.00

Originating_Labor_Price numeric(19,5)
0.00

Originating_Labor_Cost numeric(19,5)
0.00

Originating_ExpensePrice numeric(19,5)
0.00

Originating_Expense_Cost numeric(19,5)
0.00

Originating_Travel_Price numeric(19,5)
0.00

Originating_Travel_Cost numeric(19,5)
0.00

VOIDSTTS smallint
0
Void Statu...(more) Join Now POP30300.VOIDSTTS
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