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 SV tables SV00800
You are currently viewing the COMPANY database.
Change

COMPANY..SV00800 Table Definition

(COMPANY..SV_Labor_Loading_Monthly_TEMP_SQL)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value		 Source
CUSTNMBR char(15)

 Field Type...(more) Join Now
join ... more text available
ADRSCODE char(15)

 Field Type...(more) Join Now
LOCATNNM char(31)
Contract_Number char(11)
WSCONTSQ int
Service_Call_ID char(17)
Status_of_Call char(11)
Completion_Date datetime

 Completion...(more) Join Now BM10200.Completion_Date
TRXHRUNT int
Primary_HoursUnits int
SLPRSNID char(15)

 Field Type...(more) Join Now
join ... more text available
Technician char(11)
Technician_Team char(15)
Technician_Long_Name char(31)
Current_Month smallint
Total_Planned_Hours int
Total_Non_Planned_Hours int
Total_Planned_MCC_Hours int
TotalPlannedBurdenHrs int
TotalPlannedBillableHrs int
Start_Month_Number smallint
End_Month_Number smallint
USERID char(15)

 The user t...(more) Join Now
join ... more text available
CMPNYNAM char(65)

 Company Na...(more) Join Now POP10100.CMPNYNAM
Salesperson_ID_Parm char(15)
Technician_Team_Parm char(15)
Technician_ID_Parm char(15)
Wennsoft_Affiliate char(15)
Wennsoft_Region char(15)
Wennsoft_Branch char(15)
Affiliate_Parm char(15)
Region_Parm char(15)
Branch_Parm char(15)
intComplete smallint
intOpen smallint
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
Archives | Table Listing | eConnect Error Database | eConnect Schema | Gold Star Locksmith
3