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

COMPANY..SV30301 Table Definition

(COMPANY..SV_Appointment_History_MSTR)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value		 Source
WS_Appointment_ID int
Appointment_Action char(17)
Service_Call_ID char(17)
Appointment char(25)
Appointment_Type smallint
Technician char(11)
Skill_Level char(15)
Task_Date datetime
STRTTIME datetime

 Field Type...(more) Join Now
ENDTIME datetime

 Field Type...(more) Join Now
Estimate_Hours int
Actual_Hours int
Technician_Status char(17)
Appointment_Status char(11)
Status_Date datetime
Status_Time datetime
Completion_Date datetime

 Completion...(more) Join Now BM10200.Completion_Date
Time_Entered_CB tinyint
CREATDDT datetime

 Field Type...(more) Join Now
CRUSRID char(15)
MODIFDT datetime

 Date the r...(more) Join Now
MDFUSRID char(15)

 User that ...(more) Join Now
join ... more text available
Modified_Time datetime
USERDEF1 char(21)

 Field Type...(more) Join Now
USERDEF2 char(21)

 Field Type...(more) Join Now
UDCB1 tinyint
UDCB2 tinyint
USRDAT01 datetime
USRDAT02 datetime
UserDD1 numeric(19,5)
UserDD2 numeric(19,5)
SV_Tool_ID int
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