| Service_Call_ID |
char(17)
|
|
|
|
|
| Service_Description |
char(31)
|
|
|
|
|
| ADRSCODE |
char(15)
|
Field Type...(more) Join Now
|
|
|
|
| CUSTNMBR |
char(15)
|
Field Type...(more) Join Now
|
|
|
join ... more text available
|
| CPRCSTNM |
char(15)
|
Corporate ...(more) Join Now
|
RM00101.CPRCSTNM
|
|
|
| Wennsoft_Affiliate |
char(15)
|
|
|
|
|
| Wennsoft_Region |
char(15)
|
|
|
|
|
| Wennsoft_Branch |
char(15)
|
|
|
|
|
| USERID |
char(15)
|
The user t...(more) Join Now
|
|
|
join ... more text available
|
| Technician_ID |
char(15)
|
|
|
|
|
| Technician_Team |
char(15)
|
|
|
|
|
| Service_Area |
char(15)
|
|
|
|
|
| Route |
char(15)
|
|
|
|
|
| CUSTNAME |
char(65)
|
Field Type...(more) Join Now
|
|
|
|
| LOCATNNM |
char(31)
|
|
|
|
|
| Technician |
char(11)
|
|
|
|
|
| Technician_ID2 |
char(15)
|
|
|
|
|
| Type_of_Problem_ID |
char(3)
|
|
|
|
|
| Type_of_Problem |
char(31)
|
|
|
|
|
| Resolution_ID |
char(3)
|
|
|
|
|
| Resolution_Description |
char(31)
|
|
|
|
|
| Equipment_Type |
char(31)
|
|
|
|
|
| Type_Call_Short |
char(3)
|
|
|
|
|
| Type_of_Call |
char(15)
|
|
|
|
|
| User_Define_1a |
char(31)
|
|
|
|
|
| User_Define_2a |
char(31)
|
|
|
|
|
| User_Define_3a |
char(31)
|
|
|
|
|
| User_Define_4a |
char(31)
|
|
|
|
|
| Purchase_Order |
char(15)
|
|
|
|
|
| Date_of_Service_Call |
datetime
|
|
|
|
|
| SLPRSNID |
char(15)
|
Field Type...(more) Join Now
|
|
|
join ... more text available
|
| Priority_of_Call |
char(1)
|
|
|
|
|
| Status_of_Call |
char(11)
|
|
|
|
|
| Call_Invoice_Number |
char(17)
|
|
|
|
|
| Invoice_Style |
smallint
|
|
|
|
|
| Completion_Date |
datetime
|
Completion...(more) Join Now
|
BM10200.Completion_Date
|
|
|
| Time_1 |
datetime
|
|
|
|
|
| Time_String_1_1 |
char(11)
|
|
|
|
|
| Time_String_1_2 |
char(11)
|
|
|
|
|
| Time_String_1_3 |
char(11)
|
|
|
|
|
| Time_String_1_4 |
char(11)
|
|
|
|
|
| Time_String_1_5 |
char(11)
|
|
|
|
|
| Time_String_1_6 |
char(11)
|
|
|
|
|
| Service_Date_1 |
datetime
|
|
|
|
|
| Service_Date_2 |
datetime
|
|
|
|
|
| Service_Date_3 |
datetime
|
|
|
|
|
| Service_Date_4 |
datetime
|
|
|
|
|
| Service_Date_5 |
datetime
|
|
|
|
|
| Service_Date_6 |
datetime
|
|
|
|
|
| Service_Time_1 |
datetime
|
|
|
|
|
| Service_Time_2 |
datetime
|
|
|
|
|
| Service_Time_3 |
datetime
|
|
|
|
|
| Service_Time_4 |
datetime
|
|
|
|
|
| Service_Time_5 |
datetime
|
|
|
|
|
| Service_Time_6 |
datetime
|
|
|
|
|
| Time_Zone_Tag |
char(5)
|
|
|
|
|
| DATE1 |
datetime
|
Field Type...(more) Join Now
|
|
|
|
| Division |
smallint
|
|
|
|
|
| Divisions |
char(15)
|
|
|
|
|
| Call_Time |
int
|
|
|
|
|
| Corporate_Contract_Nbr |
char(21)
|
|
|
|
|
| WSMSTRCONTSQ |
int
|
|
|
|
|
| Contract_Number |
char(11)
|
|
|
|
|
| WSCONTSQ |
int
|
|
|
|
|
| Invoice_Type |
smallint
|
img alt=""...(more) Join Now
|
|
|
|
| POSTED |
tinyint
|
Field Type...(more) Join Now
|
|
|
|
| Billing_Amount_Fixed |
numeric(19,5)
|
|
|
|
|
| Billing_Amount_NTE |
numeric(19,5)
|
|
|
|
|
| Billable_All |
numeric(19,5)
|
|
|
|
|
| Cost_All |
numeric(19,5)
|
|
|
|
|
| Tax_Amount1 |
numeric(19,5)
|
|
|
|
|
| Tax_Amount2 |
numeric(19,5)
|
|
|
|
|
| Tax_Amount3 |
numeric(19,5)
|
|
|
|
|
| Labor_Billing_Catagory_1 |
numeric(19,5)
|
|
|
|
|
| Labor_Billing_Catagory_2 |
numeric(19,5)
|
|
|
|
|
| Labor_Billing_Catagory_3 |
numeric(19,5)
|
|
|
|
|
| Labor_Billing_Catagory_4 |
numeric(19,5)
|
|
|
|
|
| Labor_Billing_Catagory_5 |
numeric(19,5)
|
|
|
|
|
| Billable_Equipment |
numeric(19,5)
|
|
|
|
|
| Billable_Labor |
numeric(19,5)
|
|
|
|
|
| Billable_Material |
numeric(19,5)
|
|
|
|
|
| Billable_Other |
numeric(19,5)
|
|
|
|
|
| Billable_Subs |
numeric(19,5)
|
|
|
|
|
| Billable_Tax |
numeric(19,5)
|
|
|
|
|
| Labor_Cost_Catagory_1 |
numeric(19,5)
|
|
|
|
|
| Labor_Cost_Catagory_2 |
numeric(19,5)
|
|
|
|
|
| Labor_Cost_Catagory_3 |
numeric(19,5)
|
|
|
|
|
| Labor_Cost_Catagory_4 |
numeric(19,5)
|
|
|
|
|
| Labor_Cost_Catagory_5 |
numeric(19,5)
|
|
|
|
|
| Cost_Equipment |
numeric(19,5)
|
|
|
|
|
| Cost_Labor |
numeric(19,5)
|
|
|
|
|
| Cost_Material |
numeric(19,5)
|
|
|
|
|
| Cost_Other |
numeric(19,5)
|
|
|
|
|
| Cost_Subs |
numeric(19,5)
|
|
|
|
|
| Cost_Tax |
numeric(19,5)
|
|
|
|
|
| Service_User_Define_1 |
char(21)
|
|
|
|
|
| Service_User_Define_2 |
char(21)
|
|
|
|
|
| Service_User_Define_3 |
char(31)
|
|
|
|
|
| Service_User_Define_4 |
char(31)
|
|
|
|
|
| Service_User_Define_5 |
int
|
|
|
|
|
| Service_User_Define_6 |
int
|
|
|
|
|
| Service_User_Define_7 |
int
|
|
|
|
|
| Service_User_Define_8 |
int
|
|
|
|
|
| Service_User_Define_9 |
datetime
|
|
|
|
|
| Service_User_Define_10 |
datetime
|
|
|
|
|
| Service_User_Define_11 |
datetime
|
|
|
|
|
| Service_User_Define_12 |
datetime
|
|
|
|
|
| Service_User_Define_18 |
tinyint
|
|
|
|
|
| Service_User_Define_19 |
tinyint
|
|
|
|
|
| Service_User_Define_20 |
tinyint
|
|
|
|
|
| Service_User_Define_21 |
tinyint
|
|
|
|
|
| Service_User_Define_22 |
numeric(19,5)
|
|
|
|
|
| Service_User_Define_23 |
numeric(19,5)
|
|
|
|
|
| Service_User_Define_24 |
numeric(19,5)
|
|
|
|
|
| Service_User_Define_25 |
numeric(19,5)
|
|
|
|
|
| MODIFDT |
datetime
|
Date the r...(more) Join Now
|
|
|
|
| Modified_Time |
datetime
|
|
|
|
|
| MDFUSRID |
char(15)
|
User that ...(more) Join Now
|
|
|
join ... more text available
|
| SV_Language_ID |
smallint
|
|
|
|
|
| Base_Currency_ID |
char(15)
|
|
|
|
|
| Base_Curr_Conv_Factor |
numeric(19,7)
|
|
|
|
|
| Billing_Currency_ID |
char(15)
|
|
|
|
|
| Billing_Curr_Conv_Factor |
numeric(19,7)
|
|
|
|
|
| Local_Currency_ID |
char(15)
|
|
|
|
|
| Track_In_Job_Cost |
tinyint
|
|
|
|
|
| WSReserved_CB1 |
tinyint
|
|
|
|
|
| WSReserved_CB2 |
tinyint
|
|
|
|
|
| WSReserved_CB3 |
tinyint
|
|
|
|
|
| WSReserved_CB4 |
tinyint
|
|
|
|
|
| WSReserved_CB5 |
tinyint
|
|
|
|
|
| WSReserved_STR1 |
char(11)
|
|
|
|
|
| WSReserved_STR2 |
char(11)
|
|
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|
|