Entity 'CONTRACT'
General info
Entity type: independent
Attributes
Key Attribute/role name Data type Not null Unique
PK Contract_No U_GENERAL_ID YES NO
Customer U_GENERAL_ID NO NO
ORIGINAL_DATE U_DATE NO NO
Start_Date U_DATE NO NO
End_Date U_DATE NO NO
Cycle_Qty U_INTEGER NO NO
Cycle_Unit U_FLAG NO NO
Last_Invoice_Date U_DATE NO NO
Next_Invoice_Date U_DATE NO NO
Renewal_Type U_FLAG NO NO
Category U_CODE NO NO
SALES_ACCOUNT_NUMBER U_GL_ACCT_NO NO NO
PO_NO U_LONG_CODE NO NO
Sel_For_Billing_Flg U_FLAG NO NO
TAX_CODE U_GENERAL_ID NO NO
INVOICE_NO U_INTEGER NO NO
INVOICE_DATE U_DATE NO NO
Invoice_Print_Stat U_FLAG NO NO
INVOICE_POST_STAT U_FLAG NO NO
DISC_PCT U_QTY NO NO
TOTAL_SALES U_PRICE NO NO
TOTAL_TXBL_SALES U_PRICE NO NO
TOT_PAYMENTS U_PRICE NO NO
PAID_IN_FULL_FLG U_FLAG NO NO
TOT_TAX_AMT U_PRICE NO NO
PREV_START_DATE U_DATE NO NO
PREV_END_DATE U_DATE NO NO
POST_TO_CUSTOMER U_GENERAL_ID NO NO
SALES_REP U_GENERAL_ID NO NO
COMMISSION_AMT U_PRICE NO NO
Relationships
Relationship name Type Parent entity Child entity Card.
Contract Equipment Informative CONTRACT CUST_EQUIPMENT 1:N
Contract Tax Identifying CONTRACT CONTRACT_TAX 1:N
Contract Notes Informative CONTRACT CONTRACT_NOTES 1:N
User-defined variables
Name Value
Owner
Non clustered primary key No
Primary key fill factor
Filegroup for Table
Filegroup for Primary key
Text Filegroup for Table (TEXTIMAGE_ON)


Entity 'CONTRACT_CAT'
General info
Entity type: independent
Attributes
Key Attribute/role name Data type Not null Unique
PK Code U_CODE YES YES
Description U_DESC NO NO
User-defined variables
Name Value
Owner
Non clustered primary key No
Primary key fill factor
Filegroup for Table
Filegroup for Primary key
Text Filegroup for Table (TEXTIMAGE_ON)


Entity 'CONTRACT_NOTES'
General info
Entity type: independent
Attributes
Key Attribute/role name Data type Not null Unique
PK Contract_No U_GENERAL_ID YES NO
PK Note_ID U_NOTE_ID YES NO
Description U_DESC NO NO
NOTE_TEXT U_NOTE NO NO
RAW_TEXT U_NOTE NO NO
LAST_MAINT_DATE U_DATE NO NO
PRT_ON_WO U_FLAG NO NO
PRT_ON_INVOICE U_FLAG NO NO
Relationships
Relationship name Type Parent entity Child entity Card.
Contract Notes Informative CONTRACT CONTRACT_NOTES 1:N
User-defined variables
Name Value
Owner
Non clustered primary key No
Primary key fill factor
Filegroup for Table
Filegroup for Primary key
Text Filegroup for Table (TEXTIMAGE_ON)


Entity 'CONTRACT_TAX'
General info
Entity type: dependent
Attributes
Key Attribute/role name Data type Not null Unique
PFK Contract_No U_GENERAL_ID YES NO
PK Seq_No U_INTEGER YES NO
TAX_CODE U_GENERAL_ID NO NO
AUTH_CODE U_GENERAL_ID NO NO
AUTH_RULE_CODE U_GENERAL_ID NO NO
Amount U_PRICE NO NO
TAX_ACCOUNT_NO U_GL_ACCT_NO NO NO
Relationships
Relationship name Type Parent entity Child entity Card.
Contract Tax Identifying CONTRACT CONTRACT_TAX 1:N
User-defined variables
Name Value
Owner
Non clustered primary key No
Primary key fill factor
Filegroup for Table
Filegroup for Primary key
Text Filegroup for Table (TEXTIMAGE_ON)


Entity 'CONTROL_INFO'
General info
Entity type: independent
Attributes
Key Attribute/role name Data type Not null Unique
PK CTL_KEY U_CODE YES YES
NXT_CALL_NO U_GENERAL_ID NO NO
NXT_CONTR_NO U_GENERAL_ID NO NO
NXT_INVOICE_NO U_INTEGER NO NO
DFLT_INVC_CODE U_CODE NO NO
DFLT_LOGGED_STATUS U_CODE NO NO
DFLT_SCHED_STATUS U_CODE NO NO
DFLT_DISP_STATUS U_CODE NO NO
DFLT_COMPL_STATUS U_CODE NO NO
DFLT_CALL_INVC_FORM U_DESC NO NO
DFLT_CONTR_INVC_FORM U_DESC NO NO
DFLT_WO_FORM U_DESC NO NO
DFLT_WO_CR_MEMO_FORM U_DESC NO NO
UDEF_1_TYPE U_FLAG NO NO
UDEF_1_LEN U_QTY NO NO
UDEF_1_DESC U_DESC NO NO
UDEF_2_TYPE U_FLAG NO NO
UDEF_2_LEN U_QTY NO NO
UDEF_2_DESC U_DESC NO NO
UDEF_3_TYPE U_FLAG NO NO
UDEF_3_LEN U_QTY NO NO
UDEF_3_DESC U_DESC NO NO
UDEF_4_TYPE U_FLAG NO NO
UDEF_4_LEN U_QTY NO NO
UDEF_4_DESC U_DESC NO NO
CUST_CONTS_FOR_MAIN U_FLAG NO NO
ALLOW_POST_TO U_FLAG NO NO
CALL_DEL_PWD_FLG U_FLAG NO NO
CALL_DEL_PWD U_GENERAL_ID NO NO
CRED_OVRD_PWD_FLG U_FLAG NO NO
CRED_OVRD_PWD U_GENERAL_ID NO NO
POS_STORE U_CODE NO NO
POS_DRAWER U_CODE NO NO
NOTE_ID_FOR_ATTACH U_NOTE_ID NO NO
NOTE_ID_FOR_POP U_NOTE_ID NO NO
LAST_WO_INVC_COMMENT U_NOTE NO NO
LAST_CONT_INVC_COMMENT U_NOTE NO NO
LAST_WO_CR_MEMO_COMMENT U_NOTE NO NO
NOTE_DFLT_PRINT_ON_WO U_FLAG NO NO
NOTE_DFLT_PRINT_ON_INVOICE U_FLAG NO NO
ALLOW_POS_XFER U_FLAG NO NO
UPDATE_SYS_HIST U_FLAG NO NO
SP_DB_VERSION U_CODE NO NO
CONTRACT_EQP_COST_OFFSET_ACCT U_GL_ACCT_NO NO NO
METERS_IN_USE_FLG U_FLAG NO NO
SPLIT_BILLING_IN_USE U_FLAG NO NO
User-defined variables
Name Value
Owner
Non clustered primary key No
Primary key fill factor
Filegroup for Table
Filegroup for Primary key
Text Filegroup for Table (TEXTIMAGE_ON)


Entity 'CUST_EQUIPMENT'
General info
Entity type: independent
Attributes
Key Attribute/role name Data type Not null Unique
PK Customer U_GENERAL_ID YES NO
PK Address_ID U_GENERAL_ID YES NO
PK Model_ID U_LONG_CODE YES NO
PK Serial_No U_DESC YES NO
CONTRACT_NO U_GENERAL_ID NO NO
Description U_DESC NO NO
Description_2 U_DESC NO NO
Tag_ID U_DESC NO NO
WARRANTY U_CODE NO NO
PM_SCHEDULE U_CODE NO NO
WORK_CAT U_CODE NO NO
CATEGORY U_GENERAL_ID NO NO
SUB_CATEGORY U_GENERAL_ID NO NO
MANUFACTURER U_DESC NO NO
LOCATION U_UDEF NO NO
INSTALL_DATE U_DATE NO NO
WARRANTY_START U_DATE NO NO
LAST_REPAIR U_DATE NO NO
LAST_PM U_DATE NO NO
NEXT_PM U_DATE NO NO
CONTRACT_BILL_AMT U_PRICE NO NO
CONTRACT_TAXABLE U_FLAG NO NO
WO_INVC_CODE U_CODE NO NO
QUANTITY U_QTY NO NO
BILL_AMT_EACH_OR_TOTAL U_FLAG NO NO
LAST_AUTO_PM_DATE U_DATE NO NO
CONTRACT_COST_AMT U_COST NO NO
CONTRACT_SALES_ACCT U_GL_ACCT_NO NO NO
CONTRACT_COST_ACCT U_GL_ACCT_NO NO NO
IMPORTED_FROM_TKT_NO U_GENERAL_ID NO NO
USER_DEFINED_1 U_UDEF NO NO
USER_DEFINED_2 U_UDEF NO NO
USER_DEFINED_3 U_UDEF NO NO
USER_DEFINED_4 U_UDEF NO NO
USER_DEFINED_5 U_UDEF NO NO
USER_DEFINED_6 U_UDEF NO NO
USER_DEFINED_7 U_UDEF NO NO
USER_DEFINED_8 U_UDEF NO NO
USER_DEFINED_9 U_UDEF NO NO
USER_DEFINED_10 U_UDEF NO NO
Relationships
Relationship name Type Parent entity Child entity Card.
Cust Equip Notes Informative CUST_EQUIPMENT CUST_EQUIPMENT_NOTES 1:N
Contract Equipment Informative CONTRACT CUST_EQUIPMENT 1:N
Equipment Meters Informative CUST_EQUIPMENT CUST_EQUIPMENT_METERS 1:N
User-defined variables
Name Value
Owner
Non clustered primary key No
Primary key fill factor
Filegroup for Table
Filegroup for Primary key
Text Filegroup for Table (TEXTIMAGE_ON)


Entity 'CUST_EQUIPMENT_METERS'
General info
Entity type: independent
Attributes
Key Attribute/role name Data type Not null Unique
PK Customer U_GENERAL_ID YES NO
PK Address_ID U_GENERAL_ID YES NO
PK Model_ID U_LONG_CODE YES NO
PK Serial_No U_DESC YES NO
METER1_USAGE_CODE U_CODE NO NO
METER1_START_READING U_PRICE NO NO
METER1_END_READING U_PRICE NO NO
METER1_UNBILLED_USAGE U_PRICE NO NO
METER1_USAGE_CREDIT U_PRICE NO NO
METER1_LAST_READ_DATE U_DATE NO NO
METER1_PM_DUE_USAGE U_PRICE NO NO
METER1_LAST_PM_READING U_PRICE NO NO
METER1_NEXT_PM_READING U_PRICE NO NO
METER1_CONTRACT_USAGE U_PRICE NO NO
METER2_USAGE_CODE U_CODE NO NO
METER2_START_READING U_PRICE NO NO
METER2_END_READING U_PRICE NO NO
METER2_UNBILLED_USAGE U_PRICE NO NO
METER2_USAGE_CREDIT U_PRICE NO NO
METER2_LAST_READ_DATE U_DATE NO NO
METER2_PM_DUE_USAGE U_PRICE NO NO
METER2_LAST_PM_READING U_PRICE NO NO
METER2_NEXT_PM_READING U_PRICE NO NO
METER2_CONTRACT_USAGE U_PRICE NO NO
METER3_USAGE_CODE U_CODE NO NO
METER3_START_READING U_PRICE NO NO
METER3_END_READING U_PRICE NO NO
METER3_UNBILLED_USAGE U_PRICE NO NO
METER3_USAGE_CREDIT U_PRICE NO NO
METER3_LAST_READ_DATE U_DATE NO NO
METER3_PM_DUE_USAGE U_PRICE NO NO
METER3_LAST_PM_READING U_PRICE NO NO
METER3_NEXT_PM_READING U_PRICE NO NO
METER3_CONTRACT_USAGE U_PRICE NO NO
METER4_USAGE_CODE U_CODE NO NO
METER4_START_READING U_PRICE NO NO
METER4_END_READING U_PRICE NO NO
METER4_UNBILLED_USAGE U_PRICE NO NO
METER4_USAGE_CREDIT U_PRICE NO NO
METER4_LAST_READ_DATE U_DATE NO NO
METER4_PM_DUE_USAGE U_PRICE NO NO
METER4_LAST_PM_READING U_PRICE NO NO
METER4_NEXT_PM_READING U_PRICE NO NO
METER4_CONTRACT_USAGE U_PRICE NO NO
METER5_USAGE_CODE U_CODE NO NO
METER5_START_READING U_PRICE NO NO
METER5_END_READING U_PRICE NO NO
METER5_UNBILLED_USAGE U_PRICE NO NO
METER5_USAGE_CREDIT U_PRICE NO NO
METER5_LAST_READ_DATE U_DATE NO NO
METER5_PM_DUE_USAGE U_PRICE NO NO
METER5_LAST_PM_READING U_PRICE NO NO
METER5_NEXT_PM_READING U_PRICE NO NO
METER5_CONTRACT_USAGE U_PRICE NO NO
Relationships
Relationship name Type Parent entity Child entity Card.
Equipment Meters Informative CUST_EQUIPMENT CUST_EQUIPMENT_METERS 1:N
User-defined variables
Name Value
Owner
Non clustered primary key No
Primary key fill factor
Filegroup for Table
Filegroup for Primary key
Text Filegroup for Table (TEXTIMAGE_ON)


Entity 'CUST_EQUIPMENT_NOTES'
General info
Entity type: independent
Attributes
Key Attribute/role name Data type Not null Unique
PK Customer U_GENERAL_ID YES NO
PK Address_ID U_GENERAL_ID YES NO
PK Model_ID U_LONG_CODE YES NO
PK Serial_No U_DESC YES NO
PK Note_ID U_NOTE_ID YES NO
Description U_DESC NO NO
NOTE_TEXT U_NOTE NO NO
RAW_TEXT U_NOTE NO NO
LAST_MAINT_DATE U_DATE NO NO
Relationships
Relationship name Type Parent entity Child entity Card.
Cust Equip Notes Informative CUST_EQUIPMENT CUST_EQUIPMENT_NOTES 1:N
User-defined variables
Name Value
Owner
Non clustered primary key No
Primary key fill factor
Filegroup for Table
Filegroup for Primary key
Text Filegroup for Table (TEXTIMAGE_ON)


Entity 'EQP_MODEL'
General info
Entity type: independent
Attributes
Key Attribute/role name Data type Not null Unique
PK Model ID U_LONG_CODE YES YES
Description U_DESC YES NO
Description_2 U_DESC NO NO
CATEGORY U_CODE NO NO
SUB_CATEGORY U_CODE NO NO
MANUFACTURER U_DESC NO NO
DFLT_WARR U_CODE NO NO
DFLT_PM_SCHED U_CODE NO NO
DFLT_WORK_CAT U_CODE NO NO
METER1_NAME U_DESC NO NO
METER1_DFLT_UCODE U_CODE NO NO
METER2_NAME U_DESC NO NO
METER2_DFLT_UCODE U_CODE NO NO
METER3_NAME U_DESC NO NO
METER3_DFLT_UCODE U_CODE NO NO
METER4_NAME U_DESC NO NO
METER4_DFLT_UCODE U_CODE NO NO
METER5_NAME U_DESC NO NO
METER5_DFLT_UCODE U_CODE NO NO
PROFILE1_USE_FLG U_FLAG NO NO
PROFILE1_DESC U_DESC NO NO
PROFILE2_USE_FLG U_FLAG NO NO
PROFILE2_DESC U_DESC NO NO
PROFILE3_USE_FLG U_FLAG NO NO
PROFILE3_DESC U_DESC NO NO
PROFILE4_USE_FLG U_FLAG NO NO
PROFILE4_DESC U_DESC NO NO
PROFILE5_USE_FLG U_FLAG NO NO
PROFILE5_DESC U_DESC NO NO
PROFILE6_USE_FLG U_FLAG NO NO
PROFILE6_DESC U_DESC NO NO
PROFILE7_USE_FLG U_FLAG NO NO
PROFILE7_DESC U_DESC NO NO
PROFILE8_USE_FLG U_FLAG NO NO
PROFILE8_DESC U_DESC NO NO
PROFILE9_USE_FLG U_FLAG NO NO
PROFILE9_DESC U_DESC NO NO
PROFILE10_USE_FLG U_FLAG NO NO
PROFILE10_DESC U_DESC NO NO
Relationships
Relationship name Type Parent entity Child entity Card.
Model Notes Informative EQP_MODEL SETUP_NOTES 1:N
User-defined variables
Name Value
Owner
Non clustered primary key No
Primary key fill factor
Filegroup for Table
Filegroup for Primary key
Text Filegroup for Table (TEXTIMAGE_ON)


Entity 'HISTORY_CONTRACT'
General info
Entity type: independent
Attributes
Key Attribute/role name Data type Not null Unique
PK Contract_No U_GENERAL_ID YES NO
PK Contract_Seq_No U_INTEGER YES NO
Customer U_GENERAL_ID NO NO
ORIGINAL_DATE U_DATE NO NO
Start_Date U_DATE NO NO
End_Date U_DATE NO NO
Cycle_Qty U_INTEGER NO NO
Cycle_Unit U_FLAG NO NO
Last_Invoice_Date U_DATE NO NO
Next_Invoice_Date U_DATE NO NO
Renewal_Type U_FLAG NO NO
Category U_CODE NO NO
SALES_ACCOUNT_NUMBER U_GL_ACCT_NO NO NO
PO_NO U_LONG_CODE NO NO
Sel_For_Billing_Flg U_FLAG NO NO
TAX_CODE U_GENERAL_ID NO NO
INVOICE_NO U_INTEGER NO NO
INVOICE_DATE U_DATE NO NO
Invoice_Print_Stat U_FLAG NO NO
INVOICE_POST_STAT U_FLAG NO NO
DISC_PCT U_QTY NO NO
TOTAL_SALES U_PRICE NO NO
TOTAL_TXBL_SALES U_PRICE NO NO
TOT_PAYMENTS U_PRICE NO NO
PAID_IN_FULL_FLG U_FLAG NO NO
TOT_TAX_AMT U_PRICE NO NO
PREV_START_DATE U_DATE NO NO
PREV_END_DATE U_DATE NO NO
POST_TO_CUSTOMER U_GENERAL_ID NO NO
SALES_REP U_GENERAL_ID NO NO
COMMISSION_AMT U_PRICE NO NO
POSTING_EVENT_NO U_GENERAL_ID NO NO
Relationships
Relationship name Type Parent entity Child entity Card.
History Contract Equipment Identifying HISTORY_CONTRACT HISTORY_CUST_EQUIPMENT 1:N
History Contract Notes Identifying HISTORY_CONTRACT HISTORY_CONTRACT_NOTES 1:N
History Contract Tax Identifying HISTORY_CONTRACT HISTORY_CONTRACT_TAX 1:N
User-defined variables
Name Value
Owner
Non clustered primary key No
Primary key fill factor
Filegroup for Table
Filegroup for Primary key
Text Filegroup for Table (TEXTIMAGE_ON)


Entity 'HISTORY_CONTRACT_NOTES'
General info
Entity type: dependent
Attributes
Key Attribute/role name Data type Not null Unique
PFK Contract_No U_GENERAL_ID YES NO
PFK Contract_Seq_No U_INTEGER YES NO
PK Note_ID U_NOTE_ID YES NO
Description U_DESC NO NO
NOTE_TEXT U_NOTE NO NO
RAW_TEXT U_NOTE NO NO
LAST_MAINT_DATE U_DATE NO NO
PRT_ON_WO U_FLAG NO NO
PRT_ON_INVOICE U_FLAG NO NO
Relationships
Relationship name Type Parent entity Child entity Card.
History Contract Notes Identifying HISTORY_CONTRACT HISTORY_CONTRACT_NOTES 1:N
User-defined variables
Name Value
Owner
Non clustered primary key No
Primary key fill factor
Filegroup for Table
Filegroup for Primary key
Text Filegroup for Table (TEXTIMAGE_ON)


Entity 'HISTORY_CONTRACT_TAX'
General info
Entity type: dependent
Attributes
Key Attribute/role name Data type Not null Unique
PFK Contract_No U_GENERAL_ID YES NO
PFK Contract_Seq_No U_INTEGER YES NO
PK Seq_No U_INTEGER YES NO
TAX_CODE U_GENERAL_ID NO NO
AUTH_CODE U_GENERAL_ID NO NO
AUTH_RULE_CODE U_GENERAL_ID NO NO
Amount U_PRICE NO NO
TAX_ACCOUNT_NO U_GL_ACCT_NO NO NO
Relationships
Relationship name Type Parent entity Child entity Card.
History Contract Tax Identifying HISTORY_CONTRACT HISTORY_CONTRACT_TAX 1:N
User-defined variables
Name Value
Owner
Non clustered primary key No
Primary key fill factor
Filegroup for Table
Filegroup for Primary key
Text Filegroup for Table (TEXTIMAGE_ON)


Entity 'HISTORY_CUST_EQUIPMENT'
General info
Entity type: dependent
Attributes
Key Attribute/role name Data type Not null Unique
PK Customer U_GENERAL_ID YES NO
PFK Contract_No U_GENERAL_ID YES NO
PFK Contract_Seq_No U_INTEGER YES NO
PK Address_ID U_GENERAL_ID YES NO
PK Model_ID U_LONG_CODE YES NO
PK Serial_No U_DESC YES NO
Description U_DESC NO NO
Description_2 U_DESC NO NO
Tag_ID U_DESC NO NO
WARRANTY U_CODE NO NO
PM_SCHEDULE U_CODE NO NO
WORK_CAT U_CODE NO NO
CATEGORY U_GENERAL_ID NO NO
SUB_CATEGORY U_GENERAL_ID NO NO
MANUFACTURER U_DESC NO NO
LOCATION U_UDEF NO NO
INSTALL_DATE U_DATE NO NO
WARRANTY_START U_DATE NO NO
LAST_REPAIR U_DATE NO NO
LAST_PM U_DATE NO NO
NEXT_PM U_DATE NO NO
CONTRACT_BILL_AMT U_PRICE NO NO
CONTRACT_TAXABLE U_FLAG NO NO
WO_INVC_CODE U_CODE NO NO
QUANTITY U_QTY NO NO
BILL_AMT_EACH_OR_TOTAL U_FLAG NO NO
LAST_AUTO_PM_DATE U_DATE NO NO
CONTRACT_COST_AMT U_COST NO NO
CONTRACT_SALES_ACCT U_GL_ACCT_NO NO NO
CONTRACT_COST_ACCT U_GL_ACCT_NO NO NO
IMPORTED_FROM_TKT_NO U_GENERAL_ID NO NO
Relationships
Relationship name Type Parent entity Child entity Card.
History Contract Equipment Identifying HISTORY_CONTRACT HISTORY_CUST_EQUIPMENT 1:N
User-defined variables
Name Value
Owner
Non clustered primary key No
Primary key fill factor
Filegroup for Table
Filegroup for Primary key
Text Filegroup for Table (TEXTIMAGE_ON)


Entity 'HISTORY_METER_READINGS'
General info
Entity type: independent
Attributes
Key Attribute/role name Data type Not null Unique
PK Customer U_GENERAL_ID YES NO
PK Address_ID U_GENERAL_ID YES NO
PK Model_ID U_LONG_CODE YES NO
PK Serial_No U_DESC YES NO
PK READING_DATE U_DATE YES NO
PK SEQ_NO U_INTEGER YES NO
WORK_ORDER_NO U_GENERAL_ID NO NO
METER1_READING_TYPE U_FLAG NO NO
METER1_READING_AMT U_PRICE NO NO
METER1_READING_CREDIT U_PRICE NO NO
METER2_READING_TYPE U_FLAG NO NO
METER2_READING_AMT U_PRICE NO NO
METER2_READING_CREDIT U_PRICE NO NO
METER3_READING_TYPE U_FLAG NO NO
METER3_READING_AMT U_PRICE NO NO
METER3_READING_CREDIT U_PRICE NO NO
METER4_READING_TYPE U_FLAG NO NO
METER4_READING_AMT U_PRICE NO NO
METER4_READING_CREDIT U_PRICE NO NO
METER5_READING_TYPE U_FLAG NO NO
METER5_READING_AMT U_PRICE NO NO
METER5_READING_CREDIT U_PRICE NO NO
User-defined variables
Name Value
Owner
Non clustered primary key No
Primary key fill factor
Filegroup for Table
Filegroup for Primary key
Text Filegroup for Table (TEXTIMAGE_ON)


Entity 'HISTORY_WO_ADDL_CHG'
General info
Entity type: dependent
Attributes
Key Attribute/role name Data type Not null Unique
PFK Task_Seq_No U_INTEGER YES NO
PK Addl_Chg_Seq_No U_INTEGER YES NO
Description U_UDEF NO NO
Amount U_PRICE NO NO
Cost U_COST NO NO
IS_TAXABLE U_FLAG NO NO
Sales_Acct_No U_GL_ACCT_NO NO NO
Cost_Acct_No U_GL_ACCT_NO NO NO
SPLIT_BILL_SEL_FLG U_FLAG NO NO
PFK Work_Order_No U_GENERAL_ID YES NO
PFK Work_Order_Seq_No U_INTEGER YES NO
Relationships
Relationship name Type Parent entity Child entity Card.
History WO Task Addl Chg Identifying HISTORY_WO_TASK HISTORY_WO_ADDL_CHG 1:N
User-defined variables
Name Value
Owner
Non clustered primary key No
Primary key fill factor
Filegroup for Table
Filegroup for Primary key
Text Filegroup for Table (TEXTIMAGE_ON)


Entity 'HISTORY_WO_LABOR'
General info
Entity type: dependent
Attributes
Key Attribute/role name Data type Not null Unique
PFK Task_Seq_No U_INTEGER YES NO
PK Lbr_Seq_No U_INTEGER YES NO
Tech_ID U_CODE NO NO
Work_Description U_UDEF NO NO
TYPE_FLG U_FLAG NO NO
SCHED_DATE U_DATE NO NO
SCHED_TIME U_DATE NO NO
DISP_DATE U_DATE NO NO
DISP_TIME U_DATE NO NO
START_DATE U_DATE NO NO
START_TIME U_DATE NO NO
STOP_DATE U_DATE NO NO
STOP_TIME U_DATE NO NO
RETURN_DATE U_DATE NO NO
RETURN_TIME U_DATE NO NO
HOURLY_COST U_COST NO NO
Hourly_Price U_PRICE NO NO
Hours_To_Bill U_QTY NO NO
HRS_ADJ_FOR_FLAT U_QTY NO NO
HRS_ADJ_UP_FOR_INCR U_QTY NO NO
Date_For_Sched U_DATE NO NO
Time_For_Sched U_DATE NO NO
IS_TAXABLE U_FLAG NO NO
SALES_ACCT_NO U_GL_ACCT_NO NO NO
SPLIT_BILL_SEL_FLG U_FLAG NO NO
PFK Work_Order_No U_GENERAL_ID YES NO
PFK Work_Order_Seq_No U_INTEGER YES NO
Relationships
Relationship name Type Parent entity Child entity Card.
History WO Task Labor Identifying HISTORY_WO_TASK HISTORY_WO_LABOR 1:N
History WO Labor Notes Identifying HISTORY_WO_LABOR HISTORY_WO_LABOR_NOTES 1:N
User-defined variables
Name Value
Owner
Non clustered primary key No
Primary key fill factor
Filegroup for Table
Filegroup for Primary key
Text Filegroup for Table (TEXTIMAGE_ON)


Entity 'HISTORY_WO_LABOR_NOTES'
General info
Entity type: dependent
Attributes
Key Attribute/role name Data type Not null Unique
PFK Task_Seq_No U_INTEGER YES NO
PFK Lbr_Seq_No U_INTEGER YES NO
PK Note_ID U_NOTE_ID YES NO
Description U_DESC NO NO
NOTE_TEXT U_NOTE NO NO
RAW_TEXT U_NOTE NO NO
LAST_MAINT_DATE U_DATE NO NO
PRT_ON_WO U_FLAG NO NO
PRT_ON_INVOICE U_FLAG NO NO
PFK Work_Order_No U_GENERAL_ID YES NO
PFK Work_Order_Seq_No U_INTEGER YES NO
Relationships
Relationship name Type Parent entity Child entity Card.
History WO Labor Notes Identifying HISTORY_WO_LABOR HISTORY_WO_LABOR_NOTES 1:N
User-defined variables
Name Value
Owner
Non clustered primary key No
Primary key fill factor
Filegroup for Table
Filegroup for Primary key
Text Filegroup for Table (TEXTIMAGE_ON)


Entity 'HISTORY_WO_NOTES'
General info
Entity type: dependent
Attributes
Key Attribute/role name Data type Not null Unique
PFK Work_Order_No U_GENERAL_ID YES NO
PFK Work_Order_Seq_No U_INTEGER YES NO
PK Note_ID U_NOTE_ID YES NO
Description U_DESC NO NO
NOTE_TEXT U_NOTE NO NO
RAW_TEXT U_NOTE NO NO
LAST_MAINT_DATE U_DATE NO NO
PRT_ON_WO U_FLAG NO NO
PRT_ON_INVOICE U_FLAG NO NO
Relationships
Relationship name Type Parent entity Child entity Card.
WO History Notes Identifying HISTORY_WORK_ORDER HISTORY_WO_NOTES 1:N
User-defined variables
Name Value
Owner
Non clustered primary key No
Primary key fill factor
Filegroup for Table
Filegroup for Primary key
Text Filegroup for Table (TEXTIMAGE_ON)


Entity 'HISTORY_WO_PARTS'
General info
Entity type: dependent
Attributes
Key Attribute/role name Data type Not null Unique
PFK Task_Seq_No U_INTEGER YES NO
PK Pts_Seq_No U_INTEGER YES NO
Item_No U_ITEM_NO NO NO
Inv_Loc U_CODE NO NO
Description U_UDEF NO NO
Qty_Used U_QTY NO NO
Unit_Cost U_COST NO NO
Unit_Price U_PRICE NO NO
DISCOUNT_PCT U_QTY NO NO
IS_TAXABLE U_FLAG NO NO
SALES_ACCT_NO U_GL_ACCT_NO NO NO
SPLIT_BILL_SEL_FLG U_FLAG NO NO
PRICING_TYPE_FLG U_FLAG NO NO
PFK Work_Order_No U_GENERAL_ID YES NO
PFK Work_Order_Seq_No U_INTEGER YES NO
Relationships
Relationship name Type Parent entity Child entity Card.
History WO Task Parts Identifying HISTORY_WO_TASK HISTORY_WO_PARTS 1:N
History WO Parts Serials Informative HISTORY_WO_PARTS HISTORY_WO_PARTS_SERIALS 1:N
User-defined variables
Name Value
Owner
Non clustered primary key No
Primary key fill factor
Filegroup for Table
Filegroup for Primary key
Text Filegroup for Table (TEXTIMAGE_ON)


Entity 'HISTORY_WO_PARTS_SERIALS'
General info
Entity type: independent
Attributes
Key Attribute/role name Data type Not null Unique
PK Work_Order_No U_GENERAL_ID YES NO
PK Work_Order_Seq_No U_INTEGER YES NO
PK Task_Seq_No U_INTEGER YES NO
PK Pts_Seq_No U_INTEGER YES NO
PK Serial_No U_ITEM_NO YES NO
Item_No U_ITEM_NO NO NO
Inv_Loc U_CODE NO NO
Relationships
Relationship name Type Parent entity Child entity Card.
History WO Parts Serials Informative HISTORY_WO_PARTS HISTORY_WO_PARTS_SERIALS 1:N
User-defined variables
Name Value
Owner
Non clustered primary key No
Primary key fill factor
Filegroup for Table
Filegroup for Primary key
Text Filegroup for Table (TEXTIMAGE_ON)


Entity 'HISTORY_WO_PMNT'
General info
Entity type: dependent
Attributes
Key Attribute/role name Data type Not null Unique
PFK Work_Order_No U_GENERAL_ID YES NO
PFK Work_Order_Seq_No U_INTEGER YES NO
PK Seq_No U_INTEGER YES NO
Pay_Code U_CODE NO NO
Amount U_PRICE NO NO
Description U_DESC NO NO
Reference_1 U_EMAIL_ADRS NO NO
Reference_2 U_EMAIL_ADRS NO NO
Reference_3 U_EMAIL_ADRS NO NO
Relationships
Relationship name Type Parent entity Child entity Card.
WO History Payment Identifying HISTORY_WORK_ORDER HISTORY_WO_PMNT 1:N
User-defined variables
Name Value
Owner
Non clustered primary key No
Primary key fill factor
Filegroup for Table
Filegroup for Primary key
Text Filegroup for Table (TEXTIMAGE_ON)


Entity 'HISTORY_WO_TASK'
General info
Entity type: independent
Attributes
Key Attribute/role name Data type Not null Unique
PK Work_Order_No U_GENERAL_ID YES NO
PK Work_Order_Seq_No U_INTEGER YES NO
PK Task_Seq_No U_INTEGER YES NO
Name U_NAME NO NO
Model U_DESC NO NO
Serial_No U_DESC NO NO
Description U_DESC NO NO
Description_2 U_DESC NO NO
WORK_CAT U_CODE NO NO
LOCATION U_UDEF NO NO
INVOICING_CODE U_CODE NO NO
CONTRACT_NO U_GENERAL_ID NO NO
PROBLEM U_CODE NO NO
IS_REPAIR U_FLAG NO NO
IS_PM U_FLAG NO NO
ESTIMATED_TTR U_QTY NO NO
TASK_STATUS U_FLAG NO NO
SPLIT_BILL_SEL_FLG U_FLAG NO NO
Relationships
Relationship name Type Parent entity Child entity Card.
History WO Task Addl Chg Identifying HISTORY_WO_TASK HISTORY_WO_ADDL_CHG 1:N
History WO Task Parts Identifying HISTORY_WO_TASK HISTORY_WO_PARTS 1:N
History WO Task Labor Identifying HISTORY_WO_TASK HISTORY_WO_LABOR 1:N
History Work Order Task Informative HISTORY_WORK_ORDER HISTORY_WO_TASK 1:N
History WO Task Notes Identifying HISTORY_WO_TASK HISTORY_WO_TASK_NOTES 1:N
User-defined variables
Name Value
Owner
Non clustered primary key No
Primary key fill factor
Filegroup for Table
Filegroup for Primary key
Text Filegroup for Table (TEXTIMAGE_ON)


Entity 'HISTORY_WO_TASK_NOTES'
General info
Entity type: dependent
Attributes
Key Attribute/role name Data type Not null Unique
PFK Task_Seq_No U_INTEGER YES NO
PK Note_ID U_NOTE_ID YES NO
Description U_DESC NO NO
NOTE_TEXT U_NOTE NO NO
RAW_TEXT U_NOTE NO NO
LAST_MAINT_DATE U_DATE NO NO
PRT_ON_WO U_FLAG NO NO
PRT_ON_INVOICE U_FLAG NO NO
PFK Work_Order_No U_GENERAL_ID YES NO
PFK Work_Order_Seq_No U_INTEGER YES NO
Relationships
Relationship name Type Parent entity Child entity Card.
History WO Task Notes Identifying HISTORY_WO_TASK HISTORY_WO_TASK_NOTES 1:N
User-defined variables
Name Value
Owner
Non clustered primary key No
Primary key fill factor
Filegroup for Table
Filegroup for Primary key
Text Filegroup for Table (TEXTIMAGE_ON)


Entity 'HISTORY_WO_TAX'
General info
Entity type: dependent
Attributes
Key Attribute/role name Data type Not null Unique
PFK Work_Order_No U_GENERAL_ID YES NO
PFK Work_Order_Seq_No U_INTEGER YES NO
PK Seq_No U_INTEGER YES NO
TAX_CODE U_GENERAL_ID NO NO
AUTH_CODE U_GENERAL_ID NO NO
AUTH_RULE_CODE U_GENERAL_ID NO NO
Amount U_PRICE NO NO
TAX_ACCOUNT_NO U_GL_ACCT_NO NO NO
Relationships
Relationship name Type Parent entity Child entity Card.
WO History Tax Identifying HISTORY_WORK_ORDER HISTORY_WO_TAX 1:N
User-defined variables
Name Value
Owner
Non clustered primary key No
Primary key fill factor
Filegroup for Table
Filegroup for Primary key
Text Filegroup for Table (TEXTIMAGE_ON)


Entity 'HISTORY_WORK_ORDER'
General info
Entity type: independent
Attributes
Key Attribute/role name Data type Not null Unique
PK Work_Order_No U_GENERAL_ID YES NO
PK Work_Order_Seq_No U_INTEGER YES NO
Customer U_GENERAL_ID NO NO
Address_ID U_GENERAL_ID NO NO
Status U_CODE NO NO
OPEN_DATE U_DATE NO NO
OPEN_TIME U_DATE NO NO
SVC_SITE_NAME U_NAME NO NO
SVC_ADDR_1 U_NAME NO NO
SVC_ADDR_2 U_NAME NO NO
SVC_CITY U_DESC NO NO
SVC_STATE U_CODE NO NO
SVC_ZIP_CODE U_GENERAL_ID NO NO
SVC_COUNTRY U_DESC NO NO
CONTACT_1_NAME U_NAME NO NO
CONTACT_1_PHONE U_LONG_CODE NO NO
PO_NO U_LONG_CODE NO NO
MAP_GRID U_DESC NO NO
PRIORITY U_CODE NO NO
DISPATCH_NOTE U_UDEF NO NO
USR_DEFINED_1 U_UDEF NO NO
USR_DEFINED_2 U_UDEF NO NO
USR_DEFINED_3 U_UDEF NO NO
USR_DEFINED_4 U_UDEF NO NO
TAX_CODE U_GENERAL_ID NO NO
INVOICE_NO U_INTEGER NO NO
INVOICE_DATE U_DATE NO NO
INVOICE_PRINT_STAT U_FLAG NO NO
INVOICE_POST_STAT U_FLAG NO NO
DISC_PCT U_QTY NO NO
TOTAL_SALES U_PRICE NO NO
TOTAL_TXBL_SALES U_PRICE NO NO
FLAT_CHG_HOURS U_QTY NO NO
BILL_GROUP U_CODE NO NO
POST_TO_CUSTOMER U_GENERAL_ID NO NO
ZONE U_CODE NO NO
SALES_REP U_GENERAL_ID NO NO
COMMISSION_AMT U_PRICE NO NO
TERMS_CODE U_LONG_CODE NO NO
SEL_FOR_BILLING_FLG U_FLAG NO NO
SPLIT_BILL_SEQ_NO U_INTEGER NO NO
SPLIT_BILL_SEL_FLG U_FLAG NO NO
TOT_TAX_AMT U_PRICE NO NO
TOT_PAYMENTS U_PRICE NO NO
XFER_TO_TKT_NO U_GENERAL_ID NO NO
POS_STORE U_CODE NO NO
POS_DRAWER U_CODE NO NO
ENTRY_USER U_CODE NO NO
ENTRY_DATE U_DATE NO NO
LAST_MAINT_USER U_CODE NO NO
LAST_MAINT_DATE U_DATE NO NO
CR_MEMO_NO U_INTEGER NO NO
CR_MEMO_DATE U_DATE NO NO
CR_MEMO_FLG U_FLAG NO NO
POSTING_EVENT_NO U_GENERAL_ID NO NO
Relationships
Relationship name Type Parent entity Child entity Card.
WO History Notes Identifying HISTORY_WORK_ORDER HISTORY_WO_NOTES 1:N
WO History Tax Identifying HISTORY_WORK_ORDER HISTORY_WO_TAX 1:N
WO History Payment Identifying HISTORY_WORK_ORDER HISTORY_WO_PMNT 1:N
History Work Order Task Informative HISTORY_WORK_ORDER HISTORY_WO_TASK 1:N
User-defined variables
Name Value
Owner
Non clustered primary key No
Primary key fill factor
Filegroup for Table
Filegroup for Primary key
Text Filegroup for Table (TEXTIMAGE_ON)


Entity 'INVOICING_CODE'
General info
Entity type: independent
Attributes
Key Attribute/role name Data type Not null Unique
PK Code U_CODE YES YES
Description U_DESC NO NO
FLAT_CHG U_PRICE NO NO
TIME_FOR_FLAT_CHG U_QTY NO NO
ZONE_CHG U_PRICE NO NO
TECH_RATE_REG U_PRICE NO NO
TECH_RATE_OT U_PRICE NO NO
TECH_RATE_SPEC U_PRICE NO NO
HELP_RATE_REG U_PRICE NO NO
HELP_RATE_OT U_PRICE NO NO
HELP_RATE_SPEC U_PRICE NO NO
MIN_LBR_TIME_REG U_QTY NO NO
MIN_LBR_TIME_OT U_QTY NO NO
MIN_LBR_TIME_SPEC U_QTY NO NO
LBR_TIME_INCR_REG U_QTY NO NO
LBR_TIME_INCR_OT U_QTY NO NO
LBR_TIME_INCR_SPEC U_QTY NO NO
TECH_TVL_RATE_REG U_PRICE NO NO
TECH_TVL_RATE_OT U_PRICE NO NO
TECH_TVL_RATE_SPEC U_PRICE NO NO
HELP_TVL_RATE_REG U_PRICE NO NO
HELP_TVL_RATE_OT U_PRICE NO NO
HELP_TVL_RATE_SPEC U_PRICE NO NO
MIN_TVL_CHG_REG U_PRICE NO NO
MIN_TVL_CHG_OT U_PRICE NO NO
MIN_TVL_CHG_SPEC U_PRICE NO NO
MAX_TVL_CHG_REG U_PRICE NO NO
MAX_TVL_CHG_OT U_PRICE NO NO
MAX_TVL_CHG_SPEC U_PRICE NO NO
TVL_TIME_INCR_REG U_QTY NO NO
TVL_TIME_INCR_OT U_QTY NO NO
TVL_TIME_INCR_SPEC U_QTY NO NO
CHG_PER_MILE_REG U_PRICE NO NO
CHG_PER_MILE_OT U_PRICE NO NO
CHG_PER_MILE_SPEC U_PRICE NO NO
PARTS_PRICING_GROUP U_CODE NO NO
FLAT_CHG_DESC U_DESC NO NO
TVL_CHG_DESC U_DESC NO NO
ZONE_CHG_DESC U_DESC NO NO
ADDL_CHG_4_DESC U_DESC NO NO
ADDL_CHG_5_DESC U_DESC NO NO
ACCT_LBR_REG U_GL_ACCT_NO NO NO
ACCT_LBR_OT U_GL_ACCT_NO NO NO
ACCT_LBR_SPEC U_GL_ACCT_NO NO NO
ACCT_PTS_REG U_GL_ACCT_NO NO NO
ACCT_PTS_OT U_GL_ACCT_NO NO NO
ACCT_PTS_SPEC U_GL_ACCT_NO NO NO
ACCT_FLAT_REG U_GL_ACCT_NO NO NO
ACCT_FLAT_OT U_GL_ACCT_NO NO NO
ACCT_FLAT_SPEC U_GL_ACCT_NO NO NO
ACCT_TVL_REG U_GL_ACCT_NO NO NO
ACCT_TVL_OT U_GL_ACCT_NO NO NO
ACCT_TVL_SPEC U_GL_ACCT_NO NO NO
ACCT_ZONE_REG U_GL_ACCT_NO NO NO
ACCT_ZONE_OT U_GL_ACCT_NO NO NO
ACCT_ZONE_SPEC U_GL_ACCT_NO NO NO
ACCT_ADDL_4_REG U_GL_ACCT_NO NO NO
ACCT_ADDL_4_OT U_GL_ACCT_NO NO NO
ACCT_ADDL_4_SPEC U_GL_ACCT_NO NO NO
ACCT_ADDL_5_REG U_GL_ACCT_NO NO NO
ACCT_ADDL_5_OT U_GL_ACCT_NO NO NO
ACCT_ADDL_5_SPEC U_GL_ACCT_NO NO NO
ACCT_DISC_REG U_GL_ACCT_NO NO NO
ACCT_DISC_OT U_GL_ACCT_NO NO NO
ACCT_DISC_SPEC U_GL_ACCT_NO NO NO
PTS_ACCT_PFT_CTR_SOURCE U_FLAG NO NO
PTS_ACCT_INVC_CODE_PFT_CTR U_GL_ACCT_NO NO NO
PTS_ACCT_PFT_CTR_SEGMENT U_INTEGER NO NO
User-defined variables
Name Value
Owner
Non clustered primary key No
Primary key fill factor
Filegroup for Table
Filegroup for Primary key
Text Filegroup for Table (TEXTIMAGE_ON)


Entity 'METER_READINGS'
General info
Entity type: independent
Attributes
Key Attribute/role name Data type Not null Unique
PK Customer U_GENERAL_ID YES NO
PK Address_ID U_GENERAL_ID YES NO
PK Model_ID U_LONG_CODE YES NO
PK Serial_No U_DESC YES NO
WORK_ORDER_NO U_GENERAL_ID NO NO
READING_DATE U_DATE NO NO
METER1_READING_TYPE U_FLAG NO NO
METER1_READING_AMT U_PRICE NO NO
METER1_READING_CREDIT U_PRICE NO NO
METER2_READING_TYPE U_FLAG NO NO
METER2_READING_AMT U_PRICE NO NO
METER2_READING_CREDIT U_PRICE NO NO
METER3_READING_TYPE U_FLAG NO NO
METER3_READING_AMT U_PRICE NO NO
METER3_READING_CREDIT U_PRICE NO NO
METER4_READING_TYPE U_FLAG NO NO
METER4_READING_AMT U_PRICE NO NO
METER4_READING_CREDIT U_PRICE NO NO
METER5_READING_TYPE U_FLAG NO NO
METER5_READING_AMT U_PRICE NO NO
METER5_READING_CREDIT U_PRICE NO NO
User-defined variables
Name Value
Owner
Non clustered primary key No
Primary key fill factor
Filegroup for Table
Filegroup for Primary key
Text Filegroup for Table (TEXTIMAGE_ON)


Entity 'PM_SCHED'
General info
Entity type: independent
Attributes
Key Attribute/role name Data type Not null Unique
PK Schedule_ID U_CODE YES YES
Description U_DESC NO NO
TYPE U_FLAG NO NO
INTERVAL_QTY U_INTEGER NO NO
INTERVAL_UNIT U_FLAG NO NO
EARLY_WIN_QTY U_INTEGER NO NO
EARLY_WIN_UNIT U_FLAG NO NO
LATE_WIN_QTY U_INTEGER NO NO
LATE_WIN_UNIT U_FLAG NO NO
DATE_01 U_DATE NO NO
DATE_02 U_DATE NO NO
DATE_03 U_DATE NO NO
DATE_04 U_DATE NO NO
DATE_05 U_DATE NO NO
DATE_06 U_DATE NO NO
DATE_07 U_DATE NO NO
DATE_08 U_DATE NO NO
DATE_09 U_DATE NO NO
DATE_10 U_DATE NO NO
DATE_11 U_DATE NO NO
DATE_12 U_DATE NO NO
DATE_13 U_DATE NO NO
DATE_14 U_DATE NO NO
DATE_15 U_DATE NO NO
DATE_16 U_DATE NO NO
DATE_17 U_DATE NO NO
DATE_18 U_DATE NO NO
DATE_19 U_DATE NO NO
DATE_20 U_DATE NO NO
DATE_21 U_DATE NO NO
DATE_22 U_DATE NO NO
DATE_23 U_DATE NO NO
DATE_24 U_DATE NO NO
DATE_25 U_DATE NO NO
DATE_26 U_DATE NO NO
DATE_27 U_DATE NO NO
DATE_28 U_DATE NO NO
DATE_29 U_DATE NO NO
DATE_30 U_DATE NO NO
User-defined variables
Name Value
Owner
Non clustered primary key No
Primary key fill factor
Filegroup for Table
Filegroup for Primary key
Text Filegroup for Table (TEXTIMAGE_ON)


Entity 'PREDEF_JOB'
General info
Entity type: independent
Attributes
Key Attribute/role name Data type Not null Unique
PK Job_ID U_GENERAL_ID YES NO
Description U_DESC NO NO
Relationships
Relationship name Type Parent entity Child entity Card.
Predef Job Notes Informative PREDEF_JOB PREDEF_JOB_NOTES 1:N
Predef Job Task Informative PREDEF_JOB PREDEF_JOB_TASK 1:N
User-defined variables
Name Value
Owner
Non clustered primary key No
Primary key fill factor
Filegroup for Table
Filegroup for Primary key
Text Filegroup for Table (TEXTIMAGE_ON)


Entity 'PREDEF_JOB_ADDL_CHG'
General info
Entity type: dependent
Attributes
Key Attribute/role name Data type Not null Unique
PFK Job_ID U_GENERAL_ID YES NO
PFK Task_Seq_No U_INTEGER YES NO
PK Addl_Chg_Seq_No U_INTEGER YES NO
Description U_UDEF NO NO
Amount U_PRICE NO NO
Cost U_COST NO NO
IS_TAXABLE U_FLAG NO NO
Sales_Acct_No U_GL_ACCT_NO NO NO
Cost_Acct_No U_GL_ACCT_NO NO NO
Relationships
Relationship name Type Parent entity Child entity Card.
PJ Task Addl Chg Identifying PREDEF_JOB_TASK PREDEF_JOB_ADDL_CHG 1:N
User-defined variables
Name Value
Owner
Non clustered primary key No
Primary key fill factor
Filegroup for Table
Filegroup for Primary key
Text Filegroup for Table (TEXTIMAGE_ON)


Entity 'PREDEF_JOB_LABOR'
General info
Entity type: dependent
Attributes
Key Attribute/role name Data type Not null Unique
PFK Job_ID U_GENERAL_ID YES NO
PFK Task_Seq_No U_INTEGER YES NO
PK Lbr_Seq_No U_INTEGER YES NO
Tech_ID U_CODE NO NO
Work_Description U_UDEF NO NO
TYPE_FLG U_FLAG NO NO
Hourly_Price U_PRICE NO NO
Hours_To_Bill U_QTY NO NO
HRS_ADJ_FOR_FLAT U_QTY NO NO
HRS_ADJ_UP_FOR_INCR U_QTY NO NO
Date_For_Sched U_DATE NO NO
Time_For_Sched U_DATE NO NO
IS_TAXABLE U_FLAG NO NO
Relationships
Relationship name Type Parent entity Child entity Card.
PJ Task Labor Identifying PREDEF_JOB_TASK PREDEF_JOB_LABOR 1:N
PJ Labor Notes Informative PREDEF_JOB_LABOR PREDEF_JOB_LABOR_NOTES 1:N
User-defined variables
Name Value
Owner
Non clustered primary key No
Primary key fill factor
Filegroup for Table
Filegroup for Primary key
Text Filegroup for Table (TEXTIMAGE_ON)


Entity 'PREDEF_JOB_LABOR_NOTES'
General info
Entity type: independent
Attributes
Key Attribute/role name Data type Not null Unique
PK Job_ID U_GENERAL_ID YES NO
PK Task_Seq_No U_INTEGER YES NO
PK Lbr_Seq_No U_INTEGER YES NO
PK Note_ID U_NOTE_ID YES NO
Description U_DESC NO NO
NOTE_TEXT U_NOTE NO NO
RAW_TEXT U_NOTE NO NO
LAST_MAINT_DATE U_DATE NO NO
PRT_ON_WO U_FLAG NO NO
PRT_ON_INVOICE U_FLAG NO NO
Relationships
Relationship name Type Parent entity Child entity Card.
PJ Labor Notes Informative PREDEF_JOB_LABOR PREDEF_JOB_LABOR_NOTES 1:N
User-defined variables
Name Value
Owner
Non clustered primary key No
Primary key fill factor
Filegroup for Table
Filegroup for Primary key
Text Filegroup for Table (TEXTIMAGE_ON)


Entity 'PREDEF_JOB_NOTES'
General info
Entity type: independent
Attributes
Key Attribute/role name Data type Not null Unique
PK Job_ID U_GENERAL_ID YES NO
PK Note_ID U_NOTE_ID YES NO
Description U_DESC NO NO
NOTE_TEXT U_NOTE NO NO
RAW_TEXT U_NOTE NO NO
LAST_MAINT_DATE U_DATE NO NO
PRT_ON_WO U_FLAG NO NO
PRT_ON_INVOICE U_FLAG NO NO
Relationships
Relationship name Type Parent entity Child entity Card.
Predef Job Notes Informative PREDEF_JOB PREDEF_JOB_NOTES 1:N
User-defined variables
Name Value
Owner
Non clustered primary key No
Primary key fill factor
Filegroup for Table
Filegroup for Primary key
Text Filegroup for Table (TEXTIMAGE_ON)


Entity 'PREDEF_JOB_PARTS'
General info
Entity type: dependent
Attributes
Key Attribute/role name Data type Not null Unique
PFK Job_ID U_GENERAL_ID YES NO
PFK Task_Seq_No U_INTEGER YES NO
PK Pts_Seq_No U_INTEGER YES NO
Item_No U_ITEM_NO NO NO
Inv_Loc U_CODE NO NO
Description U_UDEF NO NO
Qty_Used U_QTY NO NO
Unit_Cost U_COST NO NO
Unit_Price U_PRICE NO NO
DISCOUNT_PCT U_QTY NO NO
IS_TAXABLE U_FLAG NO NO
SALES_ACCT_NO U_GL_ACCT_NO NO NO
Relationships
Relationship name Type Parent entity Child entity Card.
PJ Task Parts Identifying PREDEF_JOB_TASK PREDEF_JOB_PARTS 1:N
User-defined variables
Name Value
Owner
Non clustered primary key No
Primary key fill factor
Filegroup for Table
Filegroup for Primary key
Text Filegroup for Table (TEXTIMAGE_ON)


Entity 'PREDEF_JOB_TASK'
General info
Entity type: independent
Attributes
Key Attribute/role name Data type Not null Unique
PK Job_ID U_GENERAL_ID YES NO
PK Task_Seq_No U_INTEGER YES NO
Name U_NAME NO NO
Model U_DESC NO NO
Serial_No U_DESC NO NO
Description U_DESC NO NO
Description_2 U_DESC NO NO
WORK_CAT U_CODE NO NO
LOCATION U_UDEF NO NO
INVOICING_CODE U_CODE NO NO
CONTRACT_NO U_GENERAL_ID NO NO
PROBLEM U_CODE NO NO
IS_REPAIR U_FLAG NO NO
IS_PM U_FLAG NO NO
ESTIMATED_TTR U_QTY NO NO
TASK_STATUS U_FLAG NO NO
Relationships
Relationship name Type Parent entity Child entity Card.
Predef Job Task Informative PREDEF_JOB PREDEF_JOB_TASK 1:N
PJ Task Addl Chg Identifying PREDEF_JOB_TASK PREDEF_JOB_ADDL_CHG 1:N
PJ Task Parts Identifying PREDEF_JOB_TASK PREDEF_JOB_PARTS 1:N
PJ Task Labor Identifying PREDEF_JOB_TASK PREDEF_JOB_LABOR 1:N
PJ Task Notes Informative PREDEF_JOB_TASK PREDEF_JOB_TASK_NOTES 1:N
User-defined variables
Name Value
Owner
Non clustered primary key No
Primary key fill factor
Filegroup for Table
Filegroup for Primary key
Text Filegroup for Table (TEXTIMAGE_ON)


Entity 'PREDEF_JOB_TASK_NOTES'
General info
Entity type: independent
Attributes
Key Attribute/role name Data type Not null Unique
PK Job_ID U_GENERAL_ID YES NO
PK Task_Seq_No U_INTEGER YES NO
PK Note_ID U_NOTE_ID YES NO
Description U_DESC NO NO
NOTE_TEXT U_NOTE NO NO
RAW_TEXT U_NOTE NO NO
LAST_MAINT_DATE U_DATE NO NO
PRT_ON_WO U_FLAG NO NO
PRT_ON_INVOICE U_FLAG NO NO
Relationships
Relationship name Type Parent entity Child entity Card.
PJ Task Notes Informative PREDEF_JOB_TASK PREDEF_JOB_TASK_NOTES 1:N
User-defined variables
Name Value
Owner
Non clustered primary key No
Primary key fill factor
Filegroup for Table
Filegroup for Primary key
Text Filegroup for Table (TEXTIMAGE_ON)


Entity 'PREDEF_NOTES'
General info
Entity type: independent
Attributes
Key Attribute/role name Data type Not null Unique
PK Note_ID U_NOTE_ID YES NO
Description U_DESC NO NO
NOTE_SAMPLE U_DESC NO NO
NOTE_TEXT U_NOTE NO NO
RAW_TEXT U_NOTE NO NO
LAST_MAINT_DATE U_DATE NO NO
User-defined variables
Name Value
Owner
Non clustered primary key No
Primary key fill factor
Filegroup for Table
Filegroup for Primary key
Text Filegroup for Table (TEXTIMAGE_ON)


Entity 'PRIORITY_CODE'
General info
Entity type: independent
Attributes
Key Attribute/role name Data type Not null Unique
PK Code U_CODE YES YES
Description U_DESC NO NO
RESPONSE_TIME U_QTY NO NO
FORE_COLOR U_CODE NO NO
BACK_COLOR U_CODE NO NO
User-defined variables
Name Value
Owner
Non clustered primary key No
Primary key fill factor
Filegroup for Table
Filegroup for Primary key
Text Filegroup for Table (TEXTIMAGE_ON)


Entity 'PROBLEM_CODE'
General info
Entity type: independent
Attributes
Key Attribute/role name Data type Not null Unique
PK Code U_CODE YES YES
Description U_DESC NO NO
PERFORM_PM U_FLAG NO NO
PERFORM_REPAIR U_FLAG NO NO
EST_TTR U_QTY NO NO
User-defined variables
Name Value
Owner
Non clustered primary key No
Primary key fill factor
Filegroup for Table
Filegroup for Primary key
Text Filegroup for Table (TEXTIMAGE_ON)


Entity 'REFERRAL_SOURCE'
General info
Entity type: independent
Attributes
Key Attribute/role name Data type Not null Unique
PK Code U_CODE YES YES
Description U_DESC NO NO
User-defined variables
Name Value
Owner
Non clustered primary key No
Primary key fill factor
Filegroup for Table
Filegroup for Primary key
Text Filegroup for Table (TEXTIMAGE_ON)


Entity 'SETUP_NOTES'
General info
Entity type: independent
Attributes
Key Attribute/role name Data type Not null Unique
PK CODE_TYPE U_FLAG YES NO
PK CODE U_LONG_CODE YES NO
PK Note_ID U_NOTE_ID YES NO
Description U_DESC NO NO
NOTE_TEXT U_NOTE NO NO
RAW_TEXT U_NOTE NO NO
LAST_MAINT_DATE U_DATE NO NO
Relationships
Relationship name Type Parent entity Child entity Card.
Tech notes Informative SVC_TECH SETUP_NOTES 1:N
Model Notes Informative EQP_MODEL SETUP_NOTES 1:N
User-defined variables
Name Value
Owner
Non clustered primary key No
Primary key fill factor
Filegroup for Table
Filegroup for Primary key
Text Filegroup for Table (TEXTIMAGE_ON)


Entity 'SP_USER'
General info
Entity type: independent
Attributes
Key Attribute/role name Data type Not null Unique
PK User_ID U_CODE YES YES
Name U_DESC NO NO
PASSWORD U_UDEF NO NO
DATE_PWD_CHGD U_DATE NO NO
MENU U_NOTE NO NO
VIEW_COSTS U_FLAG NO NO
DEPARTMENT U_LONG_CODE NO NO
User-defined variables
Name Value
Owner
Non clustered primary key No
Primary key fill factor
Filegroup for Table
Filegroup for Primary key
Text Filegroup for Table (TEXTIMAGE_ON)


Entity 'STATUS_CODE'
General info
Entity type: independent
Attributes
Key Attribute/role name Data type Not null Unique
PK Code U_CODE YES YES
Description U_DESC NO NO
IS_FROZEN U_FLAG NO NO
COMMIT_PTS U_FLAG NO NO
ALLOW_LBR U_FLAG NO NO
ALLOW_PTS U_FLAG NO NO
ALLOW_BILL U_FLAG NO NO
INVOICE_TYPE U_FLAG NO NO
DFLT_INVC_FORM U_DESC NO NO
DFLT_WO_FORM U_DESC NO NO
User-defined variables
Name Value
Owner
Non clustered primary key No
Primary key fill factor
Filegroup for Table
Filegroup for Primary key
Text Filegroup for Table (TEXTIMAGE_ON)


Entity 'SVC_ADDRESS'
General info
Entity type: independent
Attributes
Key Attribute/role name Data type Not null Unique
PK Customer U_GENERAL_ID YES NO
PK Address_ID U_GENERAL_ID YES NO
Name U_NAME NO NO
ADDRESS_1 U_NAME NO NO
ADDRESS_2 U_NAME NO NO
CITY U_DESC NO NO
STATE U_CODE NO NO
ZIP_CODE U_GENERAL_ID NO NO
COUNTRY U_DESC NO NO
CONTACT_1 U_NAME NO NO
PHONE_1 U_PHONE NO NO
FAX_1 U_PHONE NO NO
EMAIL_1 U_EMAIL_ADRS NO NO
CONTACT_2 U_NAME NO NO
PHONE_2 U_PHONE NO NO
FAX_2 U_PHONE NO NO
EMAIL_2 U_EMAIL_ADRS NO NO
REFERRAL_SOURCE U_CODE NO NO
MAIL_TO_CUST U_GENERAL_ID NO NO
ZONE U_CODE NO NO
TAX_CODE U_GENERAL_ID NO NO
SVC_TECH U_CODE NO NO
INVOICING_CODE U_CODE NO NO
PO_NUMBER U_LONG_CODE NO NO
MAP_GRID U_DESC NO NO
Relationships
Relationship name Type Parent entity Child entity Card.
Svc Address Notes Informative SVC_ADDRESS SVC_ADDRESS_NOTES 1:N
User-defined variables
Name Value
Owner
Non clustered primary key No
Primary key fill factor
Filegroup for Table
Filegroup for Primary key
Text Filegroup for Table (TEXTIMAGE_ON)


Entity 'SVC_ADDRESS_NOTES'
General info
Entity type: independent
Attributes
Key Attribute/role name Data type Not null Unique
PK Customer U_GENERAL_ID YES NO
PK Address_ID U_GENERAL_ID YES NO
PK Note_ID U_NOTE_ID YES NO
Description U_DESC NO NO
NOTE_TEXT U_NOTE NO NO
RAW_TEXT U_NOTE NO NO
LAST_MAINT_DATE U_DATE NO NO
Relationships
Relationship name Type Parent entity Child entity Card.
Svc Address Notes Informative SVC_ADDRESS SVC_ADDRESS_NOTES 1:N
User-defined variables
Name Value
Owner
Non clustered primary key No
Primary key fill factor
Filegroup for Table
Filegroup for Primary key
Text Filegroup for Table (TEXTIMAGE_ON)


Entity 'SVC_TECH'
General info
Entity type: independent
Attributes
Key Attribute/role name Data type Not null Unique
PK Tech ID U_CODE YES YES
Name U_DESC YES NO
PHONE_1 U_PHONE NO NO
PHONE_2 U_PHONE NO NO
EMAIL_ADRS U_EMAIL_ADRS NO NO
STD_COST U_COST NO NO
OT_COST U_COST NO NO
SPEC_COST U_COST NO NO
TYPE U_FLAG NO NO
DFLT_PTS_LOC U_CODE NO NO
CATEGORY_1 U_CODE NO NO
CATEGORY_2 U_CODE NO NO
CATEGORY_3 U_CODE NO NO
CATEGORY_4 U_CODE NO NO
CATEGORY_5 U_CODE NO NO
DEPARTMENT U_LONG_CODE NO NO
Relationships
Relationship name Type Parent entity Child entity Card.
Tech notes Informative SVC_TECH SETUP_NOTES 1:N
User-defined variables
Name Value
Owner
Non clustered primary key No
Primary key fill factor
Filegroup for Table
Filegroup for Primary key
Text Filegroup for Table (TEXTIMAGE_ON)


Entity 'TAX_DEFAULT'
General info
Entity type: independent
Attributes
Key Attribute/role name Data type Not null Unique
PK Tax_Code U_GENERAL_ID YES YES
TAX_PARTS U_FLAG NO NO
TAX_LABOR U_FLAG NO NO
TAX_FLAT_CHG U_FLAG NO NO
TAX_TRAVEL_CHG U_FLAG NO NO
TAX_ZONE_CHG U_FLAG NO NO
TAX_OTHER_ADDL_CHG U_FLAG NO NO
TAX_CONTRACT_CHGS U_FLAG NO NO
User-defined variables
Name Value
Owner
Non clustered primary key No
Primary key fill factor
Filegroup for Table
Filegroup for Primary key
Text Filegroup for Table (TEXTIMAGE_ON)


Entity 'TECH_CAT'
General info
Entity type: independent
Attributes
Key Attribute/role name Data type Not null Unique
PK Code U_CODE YES YES
Description U_DESC NO NO
User-defined variables
Name Value
Owner
Non clustered primary key No
Primary key fill factor
Filegroup for Table
Filegroup for Primary key
Text Filegroup for Table (TEXTIMAGE_ON)


Entity 'USAGE_CODE'
General info
Entity type: independent
Attributes
Key Attribute/role name Data type Not null Unique
PK Code U_CODE YES YES
Description U_DESC NO NO
Type U_FLAG NO NO
LEVEL_1 U_PRICE NO NO
CHG_PER_USE_1 U_PRICE NO NO
LEVEL_2 U_PRICE NO NO
CHG_PER_USE_2 U_PRICE NO NO
LEVEL_3 U_PRICE NO NO
CHG_PER_USE_3 U_PRICE NO NO
LEVEL_4 U_PRICE NO NO
CHG_PER_USE_4 U_PRICE NO NO
LEVEL_5 U_PRICE NO NO
CHG_PER_USE_5 U_PRICE NO NO
LEVEL_6 U_PRICE NO NO
CHG_PER_USE_6 U_PRICE NO NO
User-defined variables
Name Value
Owner
Non clustered primary key No
Primary key fill factor
Filegroup for Table
Filegroup for Primary key
Text Filegroup for Table (TEXTIMAGE_ON)


Entity 'WARRANTY'
General info
Entity type: independent
Attributes
Key Attribute/role name Data type Not null Unique
PK Warranty_ID U_CODE YES NO
Description U_DESC NO NO
INVC_CODE_1 U_CODE NO NO
INTERVAL_QTY_1 U_INTEGER NO NO
INTERVAL_UNIT_1 U_FLAG NO NO
INVC_CODE_2 U_CODE NO NO
INTERVAL_QTY_2 U_INTEGER NO NO
INTERVAL_UNIT_2 U_FLAG NO NO
INVC_CODE_3 U_CODE NO NO
INTERVAL_QTY_3 U_INTEGER NO NO
INTERVAL_UNIT_3 U_FLAG NO NO
INVC_CODE_4 U_CODE NO NO
INTERVAL_QTY_4 U_INTEGER NO NO
INTERVAL_UNIT_4 U_FLAG NO NO
INVC_CODE_5 U_CODE NO NO
INTERVAL_QTY_5 U_INTEGER NO NO
INTERVAL_UNIT_5 U_FLAG NO NO
INVC_CODE_6 U_CODE NO NO
INTERVAL_QTY_6 U_INTEGER NO NO
INTERVAL_UNIT_6 U_FLAG NO NO
User-defined variables
Name Value
Owner
Non clustered primary key No
Primary key fill factor
Filegroup for Table
Filegroup for Primary key
Text Filegroup for Table (TEXTIMAGE_ON)


Entity 'WO_ADDL_CHG'
General info
Entity type: dependent
Attributes
Key Attribute/role name Data type Not null Unique
PFK Work_Order_No U_GENERAL_ID YES NO
PFK Task_Seq_No U_INTEGER YES NO
PK Addl_Chg_Seq_No U_INTEGER YES NO
Description U_UDEF NO NO
Amount U_PRICE NO NO
Cost U_COST NO NO
IS_TAXABLE U_FLAG NO NO
Sales_Acct_No U_GL_ACCT_NO NO NO
Cost_Acct_No U_GL_ACCT_NO NO NO
SPLIT_BILL_SEL_FLG U_FLAG NO NO
Relationships
Relationship name Type Parent entity Child entity Card.
WO Task Addl Chg Identifying WO_TASK WO_ADDL_CHG 1:N
User-defined variables
Name Value
Owner
Non clustered primary key No
Primary key fill factor
Filegroup for Table
Filegroup for Primary key
Text Filegroup for Table (TEXTIMAGE_ON)


Entity 'WO_LABOR'
General info
Entity type: dependent
Attributes
Key Attribute/role name Data type Not null Unique
PFK Work_Order_No U_GENERAL_ID YES NO
PFK Task_Seq_No U_INTEGER YES NO
PK Lbr_Seq_No U_INTEGER YES NO
Tech_ID U_CODE NO NO
Work_Description U_UDEF NO NO
TYPE_FLG U_FLAG NO NO
SCHED_DATE U_DATE NO NO
SCHED_TIME U_DATE NO NO
DISP_DATE U_DATE NO NO
DISP_TIME U_DATE NO NO
START_DATE U_DATE NO NO
START_TIME U_DATE NO NO
STOP_DATE U_DATE NO NO
STOP_TIME U_DATE NO NO
RETURN_DATE U_DATE NO NO
RETURN_TIME U_DATE NO NO
HOURLY_COST U_COST NO NO
Hourly_Price U_PRICE NO NO
Hours_To_Bill U_QTY NO NO
HRS_ADJ_FOR_FLAT U_QTY NO NO
HRS_ADJ_UP_FOR_INCR U_QTY NO NO
Date_For_Sched U_DATE NO NO
Time_For_Sched U_DATE NO NO
IS_TAXABLE U_FLAG NO NO
SALES_ACCT_NO U_GL_ACCT_NO NO NO
SPLIT_BILL_SEL_FLG U_FLAG NO NO
Relationships
Relationship name Type Parent entity Child entity Card.
WO Task Labor Identifying WO_TASK WO_LABOR 1:N
WO Labor Notes Informative WO_LABOR WO_LABOR_NOTES 1:N
User-defined variables
Name Value
Owner
Non clustered primary key No
Primary key fill factor
Filegroup for Table
Filegroup for Primary key
Text Filegroup for Table (TEXTIMAGE_ON)


Entity 'WO_LABOR_NOTES'
General info
Entity type: independent
Attributes
Key Attribute/role name Data type Not null Unique
PK Work_Order_No U_GENERAL_ID YES NO
PK Task_Seq_No U_INTEGER YES NO
PK Lbr_Seq_No U_INTEGER YES NO
PK Note_ID U_NOTE_ID YES NO
Description U_DESC NO NO
NOTE_TEXT U_NOTE NO NO
RAW_TEXT U_NOTE NO NO
LAST_MAINT_DATE U_DATE NO NO
PRT_ON_WO U_FLAG NO NO
PRT_ON_INVOICE U_FLAG NO NO
Relationships
Relationship name Type Parent entity Child entity Card.
WO Labor Notes Informative WO_LABOR WO_LABOR_NOTES 1:N
User-defined variables
Name Value
Owner
Non clustered primary key No
Primary key fill factor
Filegroup for Table
Filegroup for Primary key
Text Filegroup for Table (TEXTIMAGE_ON)


Entity 'WO_NOTES'
General info
Entity type: independent
Attributes
Key Attribute/role name Data type Not null Unique
PK Work_Order_No U_GENERAL_ID YES NO
PK Note_ID U_NOTE_ID YES NO
Description U_DESC NO NO
NOTE_TEXT U_NOTE NO NO
RAW_TEXT U_NOTE NO NO
LAST_MAINT_DATE U_DATE NO NO
PRT_ON_WO U_FLAG NO NO
PRT_ON_INVOICE U_FLAG NO NO
Relationships
Relationship name Type Parent entity Child entity Card.
WO Notes Informative WORK_ORDER WO_NOTES 1:N
User-defined variables
Name Value
Owner
Non clustered primary key No
Primary key fill factor
Filegroup for Table
Filegroup for Primary key
Text Filegroup for Table (TEXTIMAGE_ON)


Entity 'WO_PARTS'
General info
Entity type: dependent
Attributes
Key Attribute/role name Data type Not null Unique
PFK Work_Order_No U_GENERAL_ID YES NO
PFK Task_Seq_No U_INTEGER YES NO
PK Pts_Seq_No U_INTEGER YES NO
Item_No U_ITEM_NO NO NO
Inv_Loc U_CODE NO NO
Description U_UDEF NO NO
Qty_Used U_QTY NO NO
Unit_Cost U_COST NO NO
Unit_Price U_PRICE NO NO
DISCOUNT_PCT U_QTY NO NO
IS_TAXABLE U_FLAG NO NO
SALES_ACCT_NO U_GL_ACCT_NO NO NO
SPLIT_BILL_SEL_FLG U_FLAG NO NO
PRICING_TYPE_FLG U_FLAG NO NO
Relationships
Relationship name Type Parent entity Child entity Card.
WO Task Parts Identifying WO_TASK WO_PARTS 1:N
WO Parts Serials Informative WO_PARTS WO_PARTS_SERIALS 1:N
User-defined variables
Name Value
Owner
Non clustered primary key No
Primary key fill factor
Filegroup for Table
Filegroup for Primary key
Text Filegroup for Table (TEXTIMAGE_ON)


Entity 'WO_PARTS_SERIALS'
General info
Entity type: independent
Attributes
Key Attribute/role name Data type Not null Unique
PK Work_Order_No U_GENERAL_ID YES NO
PK Task_Seq_No U_INTEGER YES NO
PK Pts_Seq_No U_INTEGER YES NO
PK Serial_No U_ITEM_NO YES NO
Item_No U_ITEM_NO NO NO
Inv_Loc U_CODE NO NO
Relationships
Relationship name Type Parent entity Child entity Card.
WO Parts Serials Informative WO_PARTS WO_PARTS_SERIALS 1:N
User-defined variables
Name Value
Owner
Non clustered primary key No
Primary key fill factor
Filegroup for Table
Filegroup for Primary key
Text Filegroup for Table (TEXTIMAGE_ON)


Entity 'WO_PMNT'
General info
Entity type: independent
Attributes
Key Attribute/role name Data type Not null Unique
PK Work_Order_No U_GENERAL_ID YES NO
PK Seq_No U_INTEGER YES NO
Pay_Code U_CODE NO NO
Amount U_PRICE NO NO
Description U_DESC NO NO
Reference_1 U_EMAIL_ADRS NO NO
Reference_2 U_EMAIL_ADRS NO NO
Reference_3 U_EMAIL_ADRS NO NO
Relationships
Relationship name Type Parent entity Child entity Card.
WO Payment Informative WORK_ORDER WO_PMNT 1:N
User-defined variables
Name Value
Owner
Non clustered primary key No
Primary key fill factor
Filegroup for Table
Filegroup for Primary key
Text Filegroup for Table (TEXTIMAGE_ON)


Entity 'WO_TASK'
General info
Entity type: independent
Attributes
Key Attribute/role name Data type Not null Unique
PK Work_Order_No U_GENERAL_ID YES NO
PK Task_Seq_No U_INTEGER YES NO
Name U_NAME NO NO
Model U_DESC NO NO
Serial_No U_DESC NO NO
Description U_DESC NO NO
Description_2 U_DESC NO NO
WORK_CAT U_CODE NO NO
LOCATION U_UDEF NO NO
INVOICING_CODE U_CODE NO NO
CONTRACT_NO U_GENERAL_ID NO NO
PROBLEM U_CODE NO NO
IS_REPAIR U_FLAG NO NO
IS_PM U_FLAG NO NO
ESTIMATED_TTR U_QTY NO NO
TASK_STATUS U_FLAG NO NO
SPLIT_BILL_SEL_FLG U_FLAG NO NO
Relationships
Relationship name Type Parent entity Child entity Card.
WO Task Informative WORK_ORDER WO_TASK 1:N
WO Task Addl Chg Identifying WO_TASK WO_ADDL_CHG 1:N
WO Task Parts Identifying WO_TASK WO_PARTS 1:N
WO Task Labor Identifying WO_TASK WO_LABOR 1:N
WO Task Notes Informative WO_TASK WO_TASK_NOTES 1:N
User-defined variables
Name Value
Owner
Non clustered primary key No
Primary key fill factor
Filegroup for Table
Filegroup for Primary key
Text Filegroup for Table (TEXTIMAGE_ON)


Entity 'WO_TASK_NOTES'
General info
Entity type: independent
Attributes
Key Attribute/role name Data type Not null Unique
PK Work_Order_No U_GENERAL_ID YES NO
PK Task_Seq_No U_INTEGER YES NO
PK Note_ID U_NOTE_ID YES NO
Description U_DESC NO NO
NOTE_TEXT U_NOTE NO NO
RAW_TEXT U_NOTE NO NO
LAST_MAINT_DATE U_DATE NO NO
PRT_ON_WO U_FLAG NO NO
PRT_ON_INVOICE U_FLAG NO NO
Relationships
Relationship name Type Parent entity Child entity Card.
WO Task Notes Informative WO_TASK WO_TASK_NOTES 1:N
User-defined variables
Name Value
Owner
Non clustered primary key No
Primary key fill factor
Filegroup for Table
Filegroup for Primary key
Text Filegroup for Table (TEXTIMAGE_ON)


Entity 'WO_TAX'
General info
Entity type: dependent
Attributes
Key Attribute/role name Data type Not null Unique
PFK Work_Order_No U_GENERAL_ID YES NO
PK Seq_No U_INTEGER YES NO
TAX_CODE U_GENERAL_ID NO NO
AUTH_CODE U_GENERAL_ID NO NO
AUTH_RULE_CODE U_GENERAL_ID NO NO
Amount U_PRICE NO NO
TAX_ACCOUNT_NO U_GL_ACCT_NO NO NO
Relationships
Relationship name Type Parent entity Child entity Card.
WO Tax Identifying WORK_ORDER WO_TAX 1:N
User-defined variables
Name Value
Owner
Non clustered primary key No
Primary key fill factor
Filegroup for Table
Filegroup for Primary key
Text Filegroup for Table (TEXTIMAGE_ON)


Entity 'WORK_CAT'
General info
Entity type: independent
Attributes
Key Attribute/role name Data type Not null Unique
PK Code U_CODE YES YES
Description U_DESC NO NO
User-defined variables
Name Value
Owner
Non clustered primary key No
Primary key fill factor
Filegroup for Table
Filegroup for Primary key
Text Filegroup for Table (TEXTIMAGE_ON)


Entity 'WORK_ORDER'
General info
Entity type: independent
Attributes
Key Attribute/role name Data type Not null Unique
PK Work_Order_No U_GENERAL_ID YES NO
Customer U_GENERAL_ID NO NO
Address_ID U_GENERAL_ID NO NO
Status U_CODE NO NO
OPEN_DATE U_DATE NO NO
OPEN_TIME U_DATE NO NO
SVC_SITE_NAME U_NAME NO NO
SVC_ADDR_1 U_NAME NO NO
SVC_ADDR_2 U_NAME NO NO
SVC_CITY U_DESC NO NO
SVC_STATE U_CODE NO NO
SVC_ZIP_CODE U_GENERAL_ID NO NO
SVC_COUNTRY U_DESC NO NO
CONTACT_1_NAME U_NAME NO NO
CONTACT_1_PHONE U_LONG_CODE NO NO
PO_NO U_LONG_CODE NO NO
MAP_GRID U_DESC NO NO
PRIORITY U_CODE NO NO
DISPATCH_NOTE U_UDEF NO NO
USR_DEFINED_1 U_UDEF NO NO
USR_DEFINED_2 U_UDEF NO NO
USR_DEFINED_3 U_UDEF NO NO
USR_DEFINED_4 U_UDEF NO NO
TAX_CODE U_GENERAL_ID NO NO
INVOICE_NO U_INTEGER NO NO
INVOICE_DATE U_DATE NO NO
INVOICE_PRINT_STAT U_FLAG NO NO
INVOICE_POST_STAT U_FLAG NO NO
DISC_PCT U_QTY NO NO
TOTAL_SALES U_PRICE NO NO
TOTAL_TXBL_SALES U_PRICE NO NO
FLAT_CHG_HOURS U_QTY NO NO
BILL_GROUP U_CODE NO NO
POST_TO_CUSTOMER U_GENERAL_ID NO NO
ZONE U_CODE NO NO
SALES_REP U_GENERAL_ID NO NO
COMMISSION_AMT U_PRICE NO NO
TERMS_CODE U_LONG_CODE NO NO
SEL_FOR_BILLING_FLG U_FLAG NO NO
SPLIT_BILL_SEQ_NO U_INTEGER NO NO
SPLIT_BILL_SEL_FLG U_FLAG NO NO
TOT_TAX_AMT U_PRICE NO NO
TOT_PAYMENTS U_PRICE NO NO
XFER_TO_TKT_NO U_GENERAL_ID NO NO
DEPARTMENT U_LONG_CODE NO NO
POS_STORE U_CODE NO NO
POS_DRAWER U_CODE NO NO
ENTRY_USER U_CODE NO NO
ENTRY_DATE U_DATE NO NO
LAST_MAINT_USER U_CODE NO NO
LAST_MAINT_DATE U_DATE NO NO
Relationships
Relationship name Type Parent entity Child entity Card.
WO Payment Informative WORK_ORDER WO_PMNT 1:N
WO Task Informative WORK_ORDER WO_TASK 1:N
WO Notes Informative WORK_ORDER WO_NOTES 1:N
WO Tax Identifying WORK_ORDER WO_TAX 1:N
User-defined variables
Name Value
Owner
Non clustered primary key No
Primary key fill factor
Filegroup for Table
Filegroup for Primary key
Text Filegroup for Table (TEXTIMAGE_ON)