DynDeveloper.com

DynDeveloper.com
Table Edits Forum Articles
Table Edits 0 Table Edits 0 Table Edits 0
Sign Up Now! Log In
Search the GP Tables
Search by TABLE NAME
Search by FIELD NAME
These are our SOP scripts. All of our scripts for Dynamics GP can be found here
Module List > Module SVC tables SVC05200
You are currently viewing the COMPANY database.
Change

COMPANY..SVC05200 Table Definition

(COMPANY..Returns Line Master)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value		 Source
RETDOCID char(15)
''
Field Type...(more) Join Now
Return_Record_Type smallint
0

LNSEQNBR numeric(19,5)
0
 Line SEQ N...(more) Join Now
SVC_Next_Line_SEQ_Number numeric(19,5)
0.00

SVC_Prev_Line_SEQ_Number numeric(19,5)
0.00

RETTYPE char(11)
''
Field Type...(more) Join Now
RMA_Status smallint
0

RETSTAT char(3)
''

Received tinyint
0

Traveler_Printed tinyint
0

SVC_Ready_To_Close tinyint
0

SVC_RMA_Reason_Code char(3)
''

SVC_RMA_Reason_Code_Desc char(31)
''

NOTEINDX numeric(19,5)
0.00
Note Index...(more) Join Now
join ... more text available
RETORIG smallint
0

RETREF char(31)
''

SRVRECTYPE smallint
0
Field Type...(more) Join Now
CALLNBR char(11)
''
Field Type...(more) Join Now
EQPLINE int
0
Field Type...(more) Join Now
LNITMSEQ int
0
Field Type...(more) Join Now
SVC_RMA_From_Service tinyint
0

SOPTYPE smallint
0
Field Type...(more) Join Now
SOPNUMBE char(21)
''
Field Type...(more) Join Now
CMPNTSEQ int
0
Component ...(more) Join Now
SOP_Line_Item_Sequence int
0

ENTDTE datetime
'1/1/1900'
Field Type...(more) Join Now
ENTTME datetime
'1/1/1900'
Field Type...(more) Join Now
ETADTE datetime
'1/1/1900'
Field Type...(more) Join Now
ETATME datetime
'1/1/1900'
Field Type...(more) Join Now
Commit_Date datetime
'1/1/1900'

Commit_Time datetime
'1/1/1900'

RETUDATE datetime
'1/1/1900'

Return_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
PRMDATE datetime
'1/1/1900'
Promised D...(more) Join Now POP10100.PRMDATE
REFRENCE char(31)
''
Reference:...(more) Join Now POP30300.REFRENCE
USERID char(15)
''
The user t...(more) Join Now
join ... more text available
OFFID char(11)
''
Field Type...(more) Join Now
LOCNCODE char(11)
''
Field Type...(more) Join Now
join ... more text available
RTRNNAME char(45)
''

RETADDR1 char(61)
''

RETADDR2 char(61)
''

RETADDR3 char(61)
''

RTRNCITY char(21)
''

SVC_Return_State char(29)
''

RTRNZIP char(11)
''

Return_Country char(61)
''

CUSTNMBR char(15)
''
Field Type...(more) Join Now
join ... more text available
CUSTNAME char(65)
''
Field Type...(more) Join Now
ADRSCODE char(15)
''
Field Type...(more) Join Now
CONTACT char(61)
''
Field Type...(more) Join Now
ADDRESS1 char(61)
''
Field Type...(more) Join Now
ADDRESS2 char(61)
''
Field Type...(more) Join Now
ADDRESS3 char(61)
''
Field Type...(more) Join Now
CITY char(35)
''
Field Type...(more) Join Now
STATE char(29)
''
Field Type...(more) Join Now
ZIPCODE char(11)
''
Field Type...(more) Join Now
COUNTRY char(61)
''
Field Type...(more) Join Now
Bill_To_Customer char(15)
''
Field Type...(more) Join Now
SVC_Bill_To_Address_Code char(15)
''
Field Type...(more) Join Now
CSTPONBR char(21)
''
Tax Schedu...(more) Join Now RM10301.CSTPONBR
QUANTITY numeric(19,5)
0.00
Field Type...(more) Join Now
DECPLQTY smallint
0
 Decimal Pl...(more) Join Now
UOFM char(9)
''
Field Type...(more) Join Now
See I... more text available
ITEMNMBR char(31)
''
Field Type...(more) Join Now
join ... more text available
ITEMDESC char(101)
''
Field Type...(more) Join Now
UNITCOST numeric(19,5)
0.00
Field Type...(more) Join Now
ORUNTCST numeric(19,5)
0.00
Field Type...(more) Join Now
EXTDCOST numeric(19,5)
0.00
Field Type...(more) Join Now
OREXTCST numeric(19,5)
0.00
Field Type...(more) Join Now
UNITPRCE numeric(19,5)
0.00
Field Type...(more) Join Now
ORUNTPRC numeric(19,5)
0.00
Field Type...(more) Join Now
XTNDPRCE numeric(19,5)
0.00
Field Type...(more) Join Now
OXTNDPRC numeric(19,5)
0.00
Field Type...(more) Join Now
CUSTOWN tinyint
0

FACTSEAL tinyint
0

ORDDOCID char(15)
''
Field Type...(more) Join Now
TRANSLINESEQ int
0
Field Type...(more) Join Now
STATUS smallint
0
p>Field Ty...(more) Join Now
Flat_Rate_Repair_Price numeric(19,5)
0.00

Orig_Flat_RepairPrice numeric(19,5)
0.00

Repair_Price numeric(19,5)
0.00

Originating_Repair_Price numeric(19,5)
0.00

NTE_Price numeric(19,5)
0.00

Originating_NTE_Price numeric(19,5)
0.00

Repair_Cost numeric(19,5)
0.00

Originating_Repair_Cost numeric(19,5)
0.00

Bill_of_Lading char(31)
''

SHIPMTHD char(15)
''
Shipping M...(more) Join Now RM20101.SHIPMTHD
join ... more text available
Credit_SOP_Type smallint
0

Credit_SOP_Number char(21)
''

Credit_SOP_Line_Item_Seq int
0

Replace_SOP_Type smallint
0

Replace_SOP_Number char(21)
''

Replace_SOP_Line_Item_Se int
0

Location_Code_Replacemen char(11)
''

Replace_Item_Number char(31)
''

Replace_U_Of_M char(9)
''

Replace_Price_Level char(11)
''

Replace_QTY numeric(19,5)
0.00

Replace_Cost numeric(19,5)
0.00

Originating_Replace_Cost numeric(19,5)
0.00

Replace_Price numeric(19,5)
0.00

Originating_Replace_Pric numeric(19,5)
0.00

SOP_Number_Invoice char(21)
''

Item_Number_Invoice char(31)
''

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
CURRNIDX smallint
0
Field Type...(more) Join Now
join ... more text available
DECPLCUR smallint
0
 Number of ...(more) Join Now
ODECPLCU smallint
0
Originatin...(more) Join Now SOP10200.ODECPLCU
Return_Item_Number char(31)
''

Return_Item_Description char(51)
''

Return_Location_Code char(11)
''

Return_QTY numeric(19,5)
0.00

Return_U_Of_M char(9)
''

RETCOST numeric(19,5)
0.00

Originating_Return_Cost numeric(19,5)
0.00

SVC_Extended_Return_Cost numeric(19,5)
0.00

SVC_Orig_Ext_Return_Cost numeric(19,5)
0.00

SVC_Return_Price_Level char(11)
''

SVC_Return_Price numeric(19,5)
0.00

Originating_Return_Price numeric(19,5)
0.00

SVC_Extended_Return_Pric numeric(19,5)
0.00

SVC_Orig_Ext_Return_Pric numeric(19,5)
0.00

SVC_FO_ID char(51)
''
Field Type...(more) Join Now
SVC_SCM_Complete smallint
0

svcRMAKitComponentFrom smallint
0

svcRMAComponentSeq int
0

CMPITQTY numeric(19,5)
0.00
N/A...(more) Join Now
DEX_ROW_ID int
auto number (1,1)
 Unique ide...(more) Join Now
QTYONHND numeric
0.00

QTYRTRND numeric
0.00

QTYINUSE numeric
0.00

QTYINSVC numeric
0.00

QTYDMGED numeric
0.00

svcReverseFlag tinyint
0

svcRMAallocated 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
Archives | Table Listing | eConnect Error Database | eConnect Schema | Gold Star Locksmith
3