CONTRACT
Columns
Key Column name Domain Data type Not null Unique Check Default
PK Contract_No U_GENERAL_ID Varchar (15) YES NO
Customer U_GENERAL_ID Varchar (15) NO NO
ORIGINAL_DATE U_DATE Datetime NO NO
Start_Date U_DATE Datetime NO NO
End_Date U_DATE Datetime NO NO
Cycle_Qty U_INTEGER Numeric (7,0) NO NO
Cycle_Unit U_FLAG Char (1) NO NO
Last_Invoice_Date U_DATE Datetime NO NO
Next_Invoice_Date U_DATE Datetime NO NO
Renewal_Type U_FLAG Char (1) NO NO
Category U_CODE Varchar (10) NO NO
SALES_ACCOUNT_NUMBER U_GL_ACCT_NO Varchar (20) NO NO
PO_NO U_LONG_CODE Varchar (25) NO NO
Sel_For_Billing_Flg U_FLAG Char (1) NO NO
TAX_CODE U_GENERAL_ID Varchar (15) NO NO
INVOICE_NO U_INTEGER Numeric (7,0) NO NO
INVOICE_DATE U_DATE Datetime NO NO
Invoice_Print_Stat U_FLAG Char (1) NO NO
INVOICE_POST_STAT U_FLAG Char (1) NO NO
DISC_PCT U_QTY Numeric (7,2) NO NO
TOTAL_SALES U_PRICE Decimal (15,4) NO NO
TOTAL_TXBL_SALES U_PRICE Decimal (15,4) NO NO
TOT_PAYMENTS U_PRICE Decimal (15,4) NO NO
PAID_IN_FULL_FLG U_FLAG Char (1) NO NO
TOT_TAX_AMT U_PRICE Decimal (15,4) NO NO
PREV_START_DATE U_DATE Datetime NO NO
PREV_END_DATE U_DATE Datetime NO NO
POST_TO_CUSTOMER U_GENERAL_ID Varchar (15) NO NO
SALES_REP U_GENERAL_ID Varchar (15) NO NO
COMMISSION_AMT U_PRICE Decimal (15,4) NO NO
LAST_RU_USAGE_BILL_AMT U_PRICE Decimal (15,4) NO NO
PRORATE_1ST_BILL_FLG U_FLAG Char (1) NO NO
Relationships
Constraint (relationship) name Relationship type Parent table Child table Card.
Contract Equipment (Contract Equipment) Informative CONTRACT CUST_EQUIPMENT 1:N
Contract Tax (Contract Tax) Identifying CONTRACT CONTRACT_TAX 1:N
Contract Notes (Contract Notes) Informative CONTRACT CONTRACT_NOTES 1:N
Indexes
Index name Columns Unique Descending Clustered
CONTRACT_X1 Contract_No YES NO NO
CONTRACT_X2 Customer, Contract_No YES 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)


CONTRACT_CAT
Columns
Key Column name Domain Data type Not null Unique Check Default
PK Code U_CODE Varchar (10) YES YES
Description U_DESC Varchar (30) 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)


CONTRACT_NOTES
Columns
Key Column name Domain Data type Not null Unique Check Default
PK Contract_No U_GENERAL_ID Varchar (15) YES NO
PK Note_ID U_NOTE_ID Varchar (20) YES NO
Description U_DESC Varchar (30) NO NO
NOTE_TEXT U_NOTE Text NO NO
RAW_TEXT U_NOTE Text NO NO
LAST_MAINT_DATE U_DATE Datetime NO NO
PRT_ON_WO U_FLAG Char (1) NO NO
PRT_ON_INVOICE U_FLAG Char (1) NO NO
Relationships
Constraint (relationship) name Relationship type Parent table Child table Card.
Contract Notes (Contract Notes) Informative CONTRACT CONTRACT_NOTES 1:N
Indexes
Index name Columns Unique Descending Clustered
CONTRACT_NOTES_X1 Contract_No, Note_ID NO 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)


CONTRACT_TAX
Columns
Key Column name Domain Data type Not null Unique Check Default
PFK Contract_No U_GENERAL_ID Varchar (15) YES NO
PK Customer U_GENERAL_ID Varchar (15) YES NO
PK Address_ID U_GENERAL_ID Varchar (15) YES NO
PK Model_ID U_LONG_CODE Varchar (25) YES NO
PK Serial_No U_DESC Varchar (30) YES NO
PK Seq_No U_INTEGER Numeric (7,0) YES NO
TAX_CODE U_GENERAL_ID Varchar (15) NO NO
AUTH_CODE U_GENERAL_ID Varchar (15) NO NO
AUTH_RULE_CODE U_GENERAL_ID Varchar (15) NO NO
Amount U_PRICE Decimal (15,4) NO NO
TAX_ACCOUNT_NO U_GL_ACCT_NO Varchar (20) NO NO
Relationships
Constraint (relationship) name Relationship type Parent table Child table Card.
Contract Tax (Contract Tax) Identifying CONTRACT CONTRACT_TAX 1:N
Cust Equip tax (Cust Equip tax) Informative CUST_EQUIPMENT CONTRACT_TAX 1:N
Indexes
Index name Columns Unique Descending Clustered
CONTRACT_TAX_X1 Contract_No, Customer, Address_ID, Model_ID, Serial_No, Seq_No NO 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)


CONTROL_INFO
Columns
Key Column name Domain Data type Not null Unique Check Default
PK CTL_KEY U_CODE Varchar (10) YES YES
NXT_CALL_NO U_GENERAL_ID Varchar (15) NO NO
NXT_CONTR_NO U_GENERAL_ID Varchar (15) NO NO
NXT_INVOICE_NO U_INTEGER Numeric (7,0) NO NO
DFLT_INVC_CODE U_CODE Varchar (10) NO NO
DFLT_LOGGED_STATUS U_CODE Varchar (10) NO NO
DFLT_SCHED_STATUS U_CODE Varchar (10) NO NO
DFLT_DISP_STATUS U_CODE Varchar (10) NO NO
DFLT_COMPL_STATUS U_CODE Varchar (10) NO NO
DFLT_CALL_INVC_FORM U_DESC Varchar (30) NO NO
DFLT_CONTR_INVC_FORM U_DESC Varchar (30) NO NO
DFLT_WO_FORM U_DESC Varchar (30) NO NO
DFLT_WO_CR_MEMO_FORM U_DESC Varchar (30) NO NO
UDEF_1_TYPE U_FLAG Char (1) NO NO
UDEF_1_LEN U_QTY Numeric (7,2) NO NO
UDEF_1_DESC U_DESC Varchar (30) NO NO
UDEF_2_TYPE U_FLAG Char (1) NO NO
UDEF_2_LEN U_QTY Numeric (7,2) NO NO
UDEF_2_DESC U_DESC Varchar (30) NO NO
UDEF_3_TYPE U_FLAG Char (1) NO NO
UDEF_3_LEN U_QTY Numeric (7,2) NO NO
UDEF_3_DESC U_DESC Varchar (30) NO NO
UDEF_4_TYPE U_FLAG Char (1) NO NO
UDEF_4_LEN U_QTY Numeric (7,2) NO NO
UDEF_4_DESC U_DESC Varchar (30) NO NO
CUST_CONTS_FOR_MAIN U_FLAG Char (1) NO NO
ALLOW_POST_TO U_FLAG Char (1) NO NO
CALL_DEL_PWD_FLG U_FLAG Char (1) NO NO
CALL_DEL_PWD U_GENERAL_ID Varchar (15) NO NO
CRED_OVRD_PWD_FLG U_FLAG Char (1) NO NO
CRED_OVRD_PWD U_GENERAL_ID Varchar (15) NO NO
POS_STORE U_CODE Varchar (10) NO NO
POS_DRAWER U_CODE Varchar (10) NO NO
NOTE_ID_FOR_ATTACH U_NOTE_ID Varchar (20) NO NO
NOTE_ID_FOR_POP U_NOTE_ID Varchar (20) NO NO
LAST_WO_INVC_COMMENT U_NOTE Text NO NO
LAST_CONT_INVC_COMMENT U_NOTE Text NO NO
LAST_WO_CR_MEMO_COMMENT U_NOTE Text NO NO
NOTE_DFLT_PRINT_ON_WO U_FLAG Char (1) NO NO
NOTE_DFLT_PRINT_ON_INVOICE U_FLAG Char (1) NO NO
ALLOW_POS_XFER U_FLAG Char (1) NO NO
UPDATE_SYS_HIST U_FLAG Char (1) NO NO
SP_DB_VERSION U_CODE Varchar (10) NO NO
CONTRACT_EQP_COST_OFFSET_ACCT U_GL_ACCT_NO Varchar (20) NO NO
METERS_IN_USE_FLG U_FLAG Char (1) NO NO
SPLIT_BILLING_IN_USE_FLG U_FLAG Char (1) NO NO
DIST_DTL_FLG U_FLAG Char (1) NO NO
SUPPRESS_AUTO_ITEM_LOOKUP_FLG U_FLAG Char (1) NO NO
AUTO_SEL_TEXT_FLG U_FLAG Char (1) NO NO
DFLT_PROBLEM_CODE U_CODE Varchar (10) NO NO
SCHED_CONFLICT_CHECK_FLG U_FLAG Char (1) NO NO
GP_TRX_TYPE_FLG U_FLAG Char (1) NO NO
ORDER_SCHED_IN_USE_FLG U_FLAG Char (1) NO NO
REQUESTED_SCHED_DATE U_DATE Datetime NO NO
INVENTORY_OVRD_FLG U_FLAG Char (1) 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)


CUST_EQUIPMENT
Columns
Key Column name Domain Data type Not null Unique Check Default
PK Customer U_GENERAL_ID Varchar (15) YES NO
PK Address_ID U_GENERAL_ID Varchar (15) YES NO
PK Model_ID U_LONG_CODE Varchar (25) YES NO
PK Serial_No U_DESC Varchar (30) YES NO
CONTRACT_NO U_GENERAL_ID Varchar (15) NO NO
Description U_DESC Varchar (30) NO NO
Description_2 U_DESC Varchar (30) NO NO
Tag_ID U_DESC Varchar (30) NO NO
WARRANTY U_CODE Varchar (10) NO NO
PM_SCHEDULE U_CODE Varchar (10) NO NO
WORK_CAT U_CODE Varchar (10) NO NO
CATEGORY U_GENERAL_ID Varchar (15) NO NO
SUB_CATEGORY U_GENERAL_ID Varchar (15) NO NO
MANUFACTURER U_DESC Varchar (30) NO NO
LOCATION U_UDEF Varchar (100) NO NO
INSTALL_DATE U_DATE Datetime NO NO
WARRANTY_START U_DATE Datetime NO NO
LAST_REPAIR U_DATE Datetime NO NO
LAST_PM U_DATE Datetime NO NO
NEXT_PM U_DATE Datetime NO NO
CONTRACT_BILL_AMT U_PRICE Decimal (15,4) NO NO
CONTRACT_TAXABLE U_FLAG Char (1) NO NO
WO_INVC_CODE U_CODE Varchar (10) NO NO
QUANTITY U_QTY Numeric (7,2) NO NO
BILL_AMT_EACH_OR_TOTAL U_FLAG Char (1) NO NO
LAST_AUTO_PM_DATE U_DATE Datetime NO NO
CONTRACT_COST_AMT U_COST Decimal (15,4) NO NO
CONTRACT_SALES_ACCT U_GL_ACCT_NO Varchar (20) NO NO
CONTRACT_COST_ACCT U_GL_ACCT_NO Varchar (20) NO NO
IMPORTED_FROM_TKT_NO U_GENERAL_ID Varchar (15) NO NO
USER_DEFINED_1 U_UDEF Varchar (100) NO NO
USER_DEFINED_2 U_UDEF Varchar (100) NO NO
USER_DEFINED_3 U_UDEF Varchar (100) NO NO
USER_DEFINED_4 U_UDEF Varchar (100) NO NO
USER_DEFINED_5 U_UDEF Varchar (100) NO NO
USER_DEFINED_6 U_UDEF Varchar (100) NO NO
USER_DEFINED_7 U_UDEF Varchar (100) NO NO
USER_DEFINED_8 U_UDEF Varchar (100) NO NO
USER_DEFINED_9 U_UDEF Varchar (100) NO NO
USER_DEFINED_10 U_UDEF Varchar (100) NO NO
LAST_USAGE_BILL_AMT U_PRICE Decimal (15,4) NO NO
PM_DUE_RPT_NEXT_DATE U_DATE Datetime NO NO
PM_DUE_RPT_EARLY_DATE U_DATE Datetime NO NO
PM_DUE_RPT_LATE_DATE U_DATE Datetime NO NO
PM_DUE_RPT_INCL_FLG U_FLAG Char (1) NO NO
REMOVAL_DATE U_DATE Datetime NO NO
Relationships
Constraint (relationship) name Relationship type Parent table Child table Card.
Cust Equip Notes (Cust Equip Notes) Informative CUST_EQUIPMENT CUST_EQUIPMENT_NOTES 1:N
Contract Equipment (Contract Equipment) Informative CONTRACT CUST_EQUIPMENT 1:N
Equipment Meters (Equipment Meters) Informative CUST_EQUIPMENT CUST_EQUIPMENT_METERS 1:N
Cust Equip tax (Cust Equip tax) Informative CUST_EQUIPMENT CONTRACT_TAX 1:N
Indexes
Index name Columns Unique Descending Clustered
CUST_EQUIPMENT_X1 Customer, Address_ID, Model_ID, Serial_No YES NO NO
CUST_EQUIPMENT_X2 Tag_ID, Customer, Address_ID NO NO NO
CUST_EQUIPMENT_X3 CONTRACT_NO, Customer, Address_ID, Model_ID, Serial_No NO 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)


CUST_EQUIPMENT_METERS
Columns
Key Column name Domain Data type Not null Unique Check Default
PK Customer U_GENERAL_ID Varchar (15) YES NO
PK Address_ID U_GENERAL_ID Varchar (15) YES NO
PK Model_ID U_LONG_CODE Varchar (25) YES NO
PK Serial_No U_DESC Varchar (30) YES NO
METER1_USAGE_CODE U_CODE Varchar (10) NO NO
METER1_START_READING U_PRICE Decimal (15,4) NO NO
METER1_END_READING U_PRICE Decimal (15,4) NO NO
METER1_UNBILLED_USAGE U_PRICE Decimal (15,4) NO NO
METER1_USAGE_CREDIT U_PRICE Decimal (15,4) NO NO
METER1_LAST_READ_DATE U_DATE Datetime NO NO
METER1_PM_DUE_USAGE U_PRICE Decimal (15,4) NO NO
METER1_LAST_PM_READING U_PRICE Decimal (15,4) NO NO
METER1_NEXT_PM_READING U_PRICE Decimal (15,4) NO NO
METER1_CONTRACT_USAGE U_PRICE Decimal (15,4) NO NO
METER2_USAGE_CODE U_CODE Varchar (10) NO NO
METER2_START_READING U_PRICE Decimal (15,4) NO NO
METER2_END_READING U_PRICE Decimal (15,4) NO NO
METER2_UNBILLED_USAGE U_PRICE Decimal (15,4) NO NO
METER2_USAGE_CREDIT U_PRICE Decimal (15,4) NO NO
METER2_LAST_READ_DATE U_DATE Datetime NO NO
METER2_PM_DUE_USAGE U_PRICE Decimal (15,4) NO NO
METER2_LAST_PM_READING U_PRICE Decimal (15,4) NO NO
METER2_NEXT_PM_READING U_PRICE Decimal (15,4) NO NO
METER2_CONTRACT_USAGE U_PRICE Decimal (15,4) NO NO
METER3_USAGE_CODE U_CODE Varchar (10) NO NO
METER3_START_READING U_PRICE Decimal (15,4) NO NO
METER3_END_READING U_PRICE Decimal (15,4) NO NO
METER3_UNBILLED_USAGE U_PRICE Decimal (15,4) NO NO
METER3_USAGE_CREDIT U_PRICE Decimal (15,4) NO NO
METER3_LAST_READ_DATE U_DATE Datetime NO NO
METER3_PM_DUE_USAGE U_PRICE Decimal (15,4) NO NO
METER3_LAST_PM_READING U_PRICE Decimal (15,4) NO NO
METER3_NEXT_PM_READING U_PRICE Decimal (15,4) NO NO
METER3_CONTRACT_USAGE U_PRICE Decimal (15,4) NO NO
METER4_USAGE_CODE U_CODE Varchar (10) NO NO
METER4_START_READING U_PRICE Decimal (15,4) NO NO
METER4_END_READING U_PRICE Decimal (15,4) NO NO
METER4_UNBILLED_USAGE U_PRICE Decimal (15,4) NO NO
METER4_USAGE_CREDIT U_PRICE Decimal (15,4) NO NO
METER4_LAST_READ_DATE U_DATE Datetime NO NO
METER4_PM_DUE_USAGE U_PRICE Decimal (15,4) NO NO
METER4_LAST_PM_READING U_PRICE Decimal (15,4) NO NO
METER4_NEXT_PM_READING U_PRICE Decimal (15,4) NO NO
METER4_CONTRACT_USAGE U_PRICE Decimal (15,4) NO NO
METER5_USAGE_CODE U_CODE Varchar (10) NO NO
METER5_START_READING U_PRICE Decimal (15,4) NO NO
METER5_END_READING U_PRICE Decimal (15,4) NO NO
METER5_UNBILLED_USAGE U_PRICE Decimal (15,4) NO NO
METER5_USAGE_CREDIT U_PRICE Decimal (15,4) NO NO
METER5_LAST_READ_DATE U_DATE Datetime NO NO
METER5_PM_DUE_USAGE U_PRICE Decimal (15,4) NO NO
METER5_LAST_PM_READING U_PRICE Decimal (15,4) NO NO
METER5_NEXT_PM_READING U_PRICE Decimal (15,4) NO NO
METER5_CONTRACT_USAGE U_PRICE Decimal (15,4) NO NO
Relationships
Constraint (relationship) name Relationship type Parent table Child table Card.
Equipment Meters (Equipment Meters) Informative CUST_EQUIPMENT CUST_EQUIPMENT_METERS 1:N
Indexes
Index name Columns Unique Descending Clustered
EQUIPMENT_METERS_X1 Customer, Address_ID, Model_ID, Serial_No NO 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)


CUST_EQUIPMENT_NOTES
Columns
Key Column name Domain Data type Not null Unique Check Default
PK Customer U_GENERAL_ID Varchar (15) YES NO
PK Address_ID U_GENERAL_ID Varchar (15) YES NO
PK Model_ID U_LONG_CODE Varchar (25) YES NO
PK Serial_No U_DESC Varchar (30) YES NO
PK Note_ID U_NOTE_ID Varchar (20) YES NO
Description U_DESC Varchar (30) NO NO
NOTE_TEXT U_NOTE Text NO NO
RAW_TEXT U_NOTE Text NO NO
LAST_MAINT_DATE U_DATE Datetime NO NO
Relationships
Constraint (relationship) name Relationship type Parent table Child table Card.
Cust Equip Notes (Cust Equip Notes) Informative CUST_EQUIPMENT CUST_EQUIPMENT_NOTES 1:N
Indexes
Index name Columns Unique Descending Clustered
CUST_EQUIPMENT_NOTES_X1 Customer, Address_ID, Model_ID, Serial_No, Note_ID NO 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)


EQP_MODEL
Columns
Key Column name Domain Data type Not null Unique Check Default
PK Model_ID U_LONG_CODE Varchar (25) YES YES
Description U_DESC Varchar (30) YES NO
Description_2 U_DESC Varchar (30) NO NO
CATEGORY U_CODE Varchar (10) NO NO
SUB_CATEGORY U_CODE Varchar (10) NO NO
MANUFACTURER U_DESC Varchar (30) NO NO
DFLT_WARR U_CODE Varchar (10) NO NO
DFLT_PM_SCHED U_CODE Varchar (10) NO NO
DFLT_WORK_CAT U_CODE Varchar (10) NO NO
METER1_NAME U_DESC Varchar (30) NO NO
METER1_DFLT_UCODE U_CODE Varchar (10) NO NO
METER2_NAME U_DESC Varchar (30) NO NO
METER2_DFLT_UCODE U_CODE Varchar (10) NO NO
METER3_NAME U_DESC Varchar (30) NO NO
METER3_DFLT_UCODE U_CODE Varchar (10) NO NO
METER4_NAME U_DESC Varchar (30) NO NO
METER4_DFLT_UCODE U_CODE Varchar (10) NO NO
METER5_NAME U_DESC Varchar (30) NO NO
METER5_DFLT_UCODE U_CODE Varchar (10) NO NO
PROFILE1_USE_FLG U_FLAG Char (1) NO NO
PROFILE1_DESC U_DESC Varchar (30) NO NO
PROFILE2_USE_FLG U_FLAG Char (1) NO NO
PROFILE2_DESC U_DESC Varchar (30) NO NO
PROFILE3_USE_FLG U_FLAG Char (1) NO NO
PROFILE3_DESC U_DESC Varchar (30) NO NO
PROFILE4_USE_FLG U_FLAG Char (1) NO NO
PROFILE4_DESC U_DESC Varchar (30) NO NO
PROFILE5_USE_FLG U_FLAG Char (1) NO NO
PROFILE5_DESC U_DESC Varchar (30) NO NO
PROFILE6_USE_FLG U_FLAG Char (1) NO NO
PROFILE6_DESC U_DESC Varchar (30) NO NO
PROFILE7_USE_FLG U_FLAG Char (1) NO NO
PROFILE7_DESC U_DESC Varchar (30) NO NO
PROFILE8_USE_FLG U_FLAG Char (1) NO NO
PROFILE8_DESC U_DESC Varchar (30) NO NO
PROFILE9_USE_FLG U_FLAG Char (1) NO NO
PROFILE9_DESC U_DESC Varchar (30) NO NO
PROFILE10_USE_FLG U_FLAG Char (1) NO NO
PROFILE10_DESC U_DESC Varchar (30) NO NO
Relationships
Constraint (relationship) name Relationship type Parent table Child table Card.
Model Notes (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)


HISTORY_CONTRACT
Columns
Key Column name Domain Data type Not null Unique Check Default
PK Contract_No U_GENERAL_ID Varchar (15) YES NO
PK Contract_Seq_No U_INTEGER Numeric (7,0) YES NO
Customer U_GENERAL_ID Varchar (15) NO NO
ORIGINAL_DATE U_DATE Datetime NO NO
Start_Date U_DATE Datetime NO NO
End_Date U_DATE Datetime NO NO
Cycle_Qty U_INTEGER Numeric (7,0) NO NO
Cycle_Unit U_FLAG Char (1) NO NO
Last_Invoice_Date U_DATE Datetime NO NO
Next_Invoice_Date U_DATE Datetime NO NO
Renewal_Type U_FLAG Char (1) NO NO
Category U_CODE Varchar (10) NO NO
SALES_ACCOUNT_NUMBER U_GL_ACCT_NO Varchar (20) NO NO
PO_NO U_LONG_CODE Varchar (25) NO NO
Sel_For_Billing_Flg U_FLAG Char (1) NO NO
TAX_CODE U_GENERAL_ID Varchar (15) NO NO
INVOICE_NO U_INTEGER Numeric (7,0) NO NO
INVOICE_DATE U_DATE Datetime NO NO
Invoice_Print_Stat U_FLAG Char (1) NO NO
INVOICE_POST_STAT U_FLAG Char (1) NO NO
DISC_PCT U_QTY Numeric (7,2) NO NO
TOTAL_SALES U_PRICE Decimal (15,4) NO NO
TOTAL_TXBL_SALES U_PRICE Decimal (15,4) NO NO
TOT_PAYMENTS U_PRICE Decimal (15,4) NO NO
PAID_IN_FULL_FLG U_FLAG Char (1) NO NO
TOT_TAX_AMT U_PRICE Decimal (15,4) NO NO
PREV_START_DATE U_DATE Datetime NO NO
PREV_END_DATE U_DATE Datetime NO NO
POST_TO_CUSTOMER U_GENERAL_ID Varchar (15) NO NO
SALES_REP U_GENERAL_ID Varchar (15) NO NO
COMMISSION_AMT U_PRICE Decimal (15,4) NO NO
POSTING_EVENT_NO U_GENERAL_ID Varchar (15) NO NO
LAST_RU_USAGE_BILL_AMT U_PRICE Decimal (15,4) NO NO
PRORATE_1ST_BILL_FLG U_FLAG Char (1) NO NO
Relationships
Constraint (relationship) name Relationship type Parent table Child table Card.
History Contract Equipment (History Contract Equipment) Identifying HISTORY_CONTRACT HISTORY_CUST_EQUIPMENT 1:N
History Contract Notes (History Contract Notes) Identifying HISTORY_CONTRACT HISTORY_CONTRACT_NOTES 1:N
History Contract Tax (History Contract Tax) Identifying HISTORY_CONTRACT HISTORY_CONTRACT_TAX 1:N
Indexes
Index name Columns Unique Descending Clustered
HISTORY_CONTRACT_X1 Contract_No, Contract_Seq_No YES NO NO
HISTORY_CONTRACT_X2 Customer, Contract_Seq_No, Contract_No YES 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)


HISTORY_CONTRACT_NOTES
Columns
Key Column name Domain Data type Not null Unique Check Default
PFK Contract_No U_GENERAL_ID Varchar (15) YES NO
PFK Contract_Seq_No U_INTEGER Numeric (7,0) YES NO
PK Note_ID U_NOTE_ID Varchar (20) YES NO
Description U_DESC Varchar (30) NO NO
NOTE_TEXT U_NOTE Text NO NO
RAW_TEXT U_NOTE Text NO NO
LAST_MAINT_DATE U_DATE Datetime NO NO
PRT_ON_WO U_FLAG Char (1) NO NO
PRT_ON_INVOICE U_FLAG Char (1) NO NO
Relationships
Constraint (relationship) name Relationship type Parent table Child table Card.
History Contract Notes (History Contract Notes) Identifying HISTORY_CONTRACT HISTORY_CONTRACT_NOTES 1:N
Indexes
Index name Columns Unique Descending Clustered
HISTORY_CONTRACT_NOTES_X1 Contract_No, Contract_Seq_No, Note_ID NO 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)


HISTORY_CONTRACT_TAX
Columns
Key Column name Domain Data type Not null Unique Check Default
PFK Contract_No U_GENERAL_ID Varchar (15) YES NO
PFK Contract_Seq_No U_INTEGER Numeric (7,0) YES NO
PK Customer U_GENERAL_ID Varchar (15) YES NO
PK Address_ID U_GENERAL_ID Varchar (15) YES NO
PK Model_ID U_LONG_CODE Varchar (25) YES NO
PK Serial_No U_DESC Varchar (30) YES NO
PK Seq_No U_INTEGER Numeric (7,0) YES NO
TAX_CODE U_GENERAL_ID Varchar (15) NO NO
AUTH_CODE U_GENERAL_ID Varchar (15) NO NO
AUTH_RULE_CODE U_GENERAL_ID Varchar (15) NO NO
Amount U_PRICE Decimal (15,4) NO NO
TAX_ACCOUNT_NO U_GL_ACCT_NO Varchar (20) NO NO
Relationships
Constraint (relationship) name Relationship type Parent table Child table Card.
History Contract Tax (History Contract Tax) Identifying HISTORY_CONTRACT HISTORY_CONTRACT_TAX 1:N
History Cust Eqip Tax (History Cust Eqip Tax) Informative HISTORY_CUST_EQUIPMENT HISTORY_CONTRACT_TAX 1:N
Indexes
Index name Columns Unique Descending Clustered
HISTORY_CONTRACT_TAX_X1 Contract_No, Contract_Seq_No, Customer, Address_ID, Model_ID, Serial_No, Seq_No NO 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)


HISTORY_CUST_EQUIPMENT
Columns
Key Column name Domain Data type Not null Unique Check Default
PK Customer U_GENERAL_ID Varchar (15) YES NO
PFK Contract_No U_GENERAL_ID Varchar (15) YES NO
PFK Contract_Seq_No U_INTEGER Numeric (7,0) YES NO
PK Address_ID U_GENERAL_ID Varchar (15) YES NO
PK Model_ID U_LONG_CODE Varchar (25) YES NO
PK Serial_No U_DESC Varchar (30) YES NO
Description U_DESC Varchar (30) NO NO
Description_2 U_DESC Varchar (30) NO NO
Tag_ID U_DESC Varchar (30) NO NO
WARRANTY U_CODE Varchar (10) NO NO
PM_SCHEDULE U_CODE Varchar (10) NO NO
WORK_CAT U_CODE Varchar (10) NO NO
CATEGORY U_GENERAL_ID Varchar (15) NO NO
SUB_CATEGORY U_GENERAL_ID Varchar (15) NO NO
MANUFACTURER U_DESC Varchar (30) NO NO
LOCATION U_UDEF Varchar (100) NO NO
INSTALL_DATE U_DATE Datetime NO NO
WARRANTY_START U_DATE Datetime NO NO
LAST_REPAIR U_DATE Datetime NO NO
LAST_PM U_DATE Datetime NO NO
NEXT_PM U_DATE Datetime NO NO
CONTRACT_BILL_AMT U_PRICE Decimal (15,4) NO NO
CONTRACT_TAXABLE U_FLAG Char (1) NO NO
WO_INVC_CODE U_CODE Varchar (10) NO NO
QUANTITY U_QTY Numeric (7,2) NO NO
BILL_AMT_EACH_OR_TOTAL U_FLAG Char (1) NO NO
LAST_AUTO_PM_DATE U_DATE Datetime NO NO
CONTRACT_COST_AMT U_COST Decimal (15,4) NO NO
CONTRACT_SALES_ACCT U_GL_ACCT_NO Varchar (20) NO NO
CONTRACT_COST_ACCT U_GL_ACCT_NO Varchar (20) NO NO
IMPORTED_FROM_TKT_NO U_GENERAL_ID Varchar (15) NO NO
LAST_USAGE_BILL_AMT U_PRICE Decimal (15,4) NO NO
REMOVAL_DATE U_DATE Datetime NO NO
Relationships
Constraint (relationship) name Relationship type Parent table Child table Card.
History Contract Equipment (History Contract Equipment) Identifying HISTORY_CONTRACT HISTORY_CUST_EQUIPMENT 1:N
History Cust Eqip Tax (History Cust Eqip Tax) Informative HISTORY_CUST_EQUIPMENT HISTORY_CONTRACT_TAX 1:N
Indexes
Index name Columns Unique Descending Clustered
HISTORY_CUST_EQUIPMENT_X1 Customer, Contract_No, Contract_Seq_No, Address_ID, Model_ID, Serial_No YES NO NO
HISTORY_CUST_EQUIPMENT_X2 Tag_ID, Customer, Address_ID NO NO NO
HISTORY_CUST_EQUIPMENT_X3 Contract_No, Contract_Seq_No, Customer, Address_ID, Model_ID, Serial_No NO 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)


HISTORY_METER_READINGS
Columns
Key Column name Domain Data type Not null Unique Check Default
PK Customer U_GENERAL_ID Varchar (15) YES NO
PK Address_ID U_GENERAL_ID Varchar (15) YES NO
PK Model_ID U_LONG_CODE Varchar (25) YES NO
PK Serial_No U_DESC Varchar (30) YES NO
PK READING_DATE U_DATE Datetime YES NO
PK SEQ_NO U_INTEGER Numeric (7,0) YES NO
WORK_ORDER_NO U_GENERAL_ID Varchar (15) NO NO
METER1_READING_TYPE U_FLAG Char (1) NO NO
METER1_READING_AMT U_PRICE Decimal (15,4) NO NO
METER1_READING_CREDIT U_PRICE Decimal (15,4) NO NO
METER2_READING_TYPE U_FLAG Char (1) NO NO
METER2_READING_AMT U_PRICE Decimal (15,4) NO NO
METER2_READING_CREDIT U_PRICE Decimal (15,4) NO NO
METER3_READING_TYPE U_FLAG Char (1) NO NO
METER3_READING_AMT U_PRICE Decimal (15,4) NO NO
METER3_READING_CREDIT U_PRICE Decimal (15,4) NO NO
METER4_READING_TYPE U_FLAG Char (1) NO NO
METER4_READING_AMT U_PRICE Decimal (15,4) NO NO
METER4_READING_CREDIT U_PRICE Decimal (15,4) NO NO
METER5_READING_TYPE U_FLAG Char (1) NO NO
METER5_READING_AMT U_PRICE Decimal (15,4) NO NO
METER5_READING_CREDIT U_PRICE Decimal (15,4) NO NO
Indexes
Index name Columns Unique Descending Clustered
HISTORY_METER_READINGS_X1 Customer, Address_ID, Model_ID, Serial_No, READING_DATE, SEQ_NO NO 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)


HISTORY_WO_ADDL_CHG
Columns
Key Column name Domain Data type Not null Unique Check Default
PFK Work_Order_No U_GENERAL_ID Varchar (15) YES NO
PFK Work_Order_Seq_No U_INTEGER Numeric (7,0) YES NO
PFK Task_Seq_No U_INTEGER Numeric (7,0) YES NO
PK Addl_Chg_Seq_No U_INTEGER Numeric (7,0) YES NO
Description U_UDEF Varchar (100) NO NO
Amount U_PRICE Decimal (15,4) NO NO
Cost U_COST Decimal (15,4) NO NO
IS_TAXABLE U_FLAG Char (1) NO NO
Sales_Acct_No U_GL_ACCT_NO Varchar (20) NO NO
Cost_Acct_No U_GL_ACCT_NO Varchar (20) NO NO
SPLIT_BILL_SEL_FLG U_FLAG Char (1) NO NO
Relationships
Constraint (relationship) name Relationship type Parent table Child table Card.
History WO Task Addl Chg (History WO Task Addl Chg) Identifying HISTORY_WO_TASK HISTORY_WO_ADDL_CHG 1:N
Indexes
Index name Columns Unique Descending Clustered
HISTORY_WO_ADDL_CHG_X1 Work_Order_No, Work_Order_Seq_No, Task_Seq_No, Addl_Chg_Seq_No NO 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)


HISTORY_WO_LABOR
Columns
Key Column name Domain Data type Not null Unique Check Default
PFK Work_Order_No U_GENERAL_ID Varchar (15) YES NO
PFK Work_Order_Seq_No U_INTEGER Numeric (7,0) YES NO
PFK Task_Seq_No U_INTEGER Numeric (7,0) YES NO
PK Lbr_Seq_No U_INTEGER Numeric (7,0) YES NO
Tech_ID U_CODE Varchar (10) NO NO
Work_Description U_UDEF Varchar (100) NO NO
TYPE_FLG U_FLAG Char (1) NO NO
SCHED_DATE U_DATE Datetime NO NO
SCHED_TIME U_DATE Datetime NO NO
DISP_DATE U_DATE Datetime NO NO
DISP_TIME U_DATE Datetime NO NO
START_DATE U_DATE Datetime NO NO
START_TIME U_DATE Datetime NO NO
STOP_DATE U_DATE Datetime NO NO
STOP_TIME U_DATE Datetime NO NO
RETURN_DATE U_DATE Datetime NO NO
RETURN_TIME U_DATE Datetime NO NO
HOURLY_COST U_COST Decimal (15,4) NO NO
Hourly_Price U_PRICE Decimal (15,4) NO NO
Hours_To_Bill U_QTY Numeric (7,2) NO NO
HRS_ADJ_FOR_FLAT U_QTY Numeric (7,2) NO NO
HRS_ADJ_UP_FOR_INCR U_QTY Numeric (7,2) NO NO
Date_For_Sched U_DATE Datetime NO NO
Time_For_Sched U_DATE Datetime NO NO
IS_TAXABLE U_FLAG Char (1) NO NO
SALES_ACCT_NO U_GL_ACCT_NO Varchar (20) NO NO
SPLIT_BILL_SEL_FLG U_FLAG Char (1) NO NO
Relationships
Constraint (relationship) name Relationship type Parent table Child table Card.
History WO Task Labor (History WO Task Labor) Identifying HISTORY_WO_TASK HISTORY_WO_LABOR 1:N
History WO Labor Notes (History WO Labor Notes) Identifying HISTORY_WO_LABOR HISTORY_WO_LABOR_NOTES 1:N
Indexes
Index name Columns Unique Descending Clustered
HISTORY_WO_LABOR_X1 Work_Order_No, Work_Order_Seq_No, Task_Seq_No, Lbr_Seq_No NO 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)


HISTORY_WO_LABOR_NOTES
Columns
Key Column name Domain Data type Not null Unique Check Default
PFK Work_Order_No U_GENERAL_ID Varchar (15) YES NO
PFK Work_Order_Seq_No U_INTEGER Numeric (7,0) YES NO
PFK Task_Seq_No U_INTEGER Numeric (7,0) YES NO
PFK Lbr_Seq_No U_INTEGER Numeric (7,0) YES NO
PK Note_ID U_NOTE_ID Varchar (20) YES NO
Description U_DESC Varchar (30) NO NO
NOTE_TEXT U_NOTE Text NO NO
RAW_TEXT U_NOTE Text NO NO
LAST_MAINT_DATE U_DATE Datetime NO NO
PRT_ON_WO U_FLAG Char (1) NO NO
PRT_ON_INVOICE U_FLAG Char (1) NO NO
Relationships
Constraint (relationship) name Relationship type Parent table Child table Card.
History WO Labor Notes (History WO Labor Notes) Identifying HISTORY_WO_LABOR HISTORY_WO_LABOR_NOTES 1:N
Indexes
Index name Columns Unique Descending Clustered
HISTORY_WO_LABOR_NOTES_X1 Work_Order_No, Work_Order_Seq_No, Task_Seq_No, Lbr_Seq_No, Note_ID NO 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)


HISTORY_WO_NOTES
Columns
Key Column name Domain Data type Not null Unique Check Default
PFK Work_Order_No U_GENERAL_ID Varchar (15) YES NO
PFK Work_Order_Seq_No U_INTEGER Numeric (7,0) YES NO
PK Note_ID U_NOTE_ID Varchar (20) YES NO
Description U_DESC Varchar (30) NO NO
NOTE_TEXT U_NOTE Text NO NO
RAW_TEXT U_NOTE Text NO NO
LAST_MAINT_DATE U_DATE Datetime NO NO
PRT_ON_WO U_FLAG Char (1) NO NO
PRT_ON_INVOICE U_FLAG Char (1) NO NO
Relationships
Constraint (relationship) name Relationship type Parent table Child table Card.
WO History Notes (WO History Notes) Identifying HISTORY_WORK_ORDER HISTORY_WO_NOTES 1:N
Indexes
Index name Columns Unique Descending Clustered
HISTORY_WO_NOTES_X1 Work_Order_No, Work_Order_Seq_No, Note_ID NO 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)


HISTORY_WO_PARTS
Columns
Key Column name Domain Data type Not null Unique Check Default
PFK Work_Order_No U_GENERAL_ID Varchar (15) YES NO
PFK Work_Order_Seq_No U_INTEGER Numeric (7,0) YES NO
PFK Task_Seq_No U_INTEGER Numeric (7,0) YES NO
PK Pts_Seq_No U_INTEGER Numeric (7,0) YES NO
Item_No U_ITEM_NO Varchar (30) NO NO
Inv_Loc U_CODE Varchar (10) NO NO
Description U_UDEF Varchar (100) NO NO
Qty_Used U_QTY Numeric (7,2) NO NO
Unit_Cost U_COST Decimal (15,4) NO NO
Unit_Price U_PRICE Decimal (15,4) NO NO
DISCOUNT_PCT U_QTY Numeric (7,2) NO NO
IS_TAXABLE U_FLAG Char (1) NO NO
SALES_ACCT_NO U_GL_ACCT_NO Varchar (20) NO NO
SPLIT_BILL_SEL_FLG U_FLAG Char (1) NO NO
PRICING_TYPE_FLG U_FLAG Char (1) NO NO
XFERRED_FROM_POS U_FLAG Char (1) NO NO
Relationships
Constraint (relationship) name Relationship type Parent table Child table Card.
History WO Task Parts (History WO Task Parts) Identifying HISTORY_WO_TASK HISTORY_WO_PARTS 1:N
History WO Parts Serials (History WO Parts Serials) Informative HISTORY_WO_PARTS HISTORY_WO_PARTS_SERIALS 1:N
History WO Parts Grid (History WO Parts Grid) Informative HISTORY_WO_PARTS_GRID_CELL HISTORY_WO_PARTS 1:N
Indexes
Index name Columns Unique Descending Clustered
HISTORY_WO_PARTS_X1 Work_Order_No, Work_Order_Seq_No, Task_Seq_No, Pts_Seq_No NO 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)


HISTORY_WO_PARTS_GRID_CELL
Columns
Key Column name Domain Data type Not null Unique Check Default
PK Work_Order_No U_GENERAL_ID Varchar (15) YES NO
PK Work_Order_Seq_No U_INTEGER Numeric (7,0) YES NO
PK Task_Seq_No U_INTEGER Numeric (7,0) YES NO
PK Pts_Seq_No U_INTEGER Numeric (7,0) YES NO
Item_No U_ITEM_NO Varchar (30) NO NO
Inv_Loc U_CODE Varchar (10) NO NO
DIM_1_UPPER U_DESC Varchar (30) NO NO
DIM_2_UPPER U_DESC Varchar (30) NO NO
DIM_3_UPPER U_DESC Varchar (30) NO NO
QTY U_QTY Numeric (7,2) NO NO
XFERRED_FROM_POS U_FLAG Char (1) NO NO
Relationships
Constraint (relationship) name Relationship type Parent table Child table Card.
History WO Parts Grid (History WO Parts Grid) Informative HISTORY_WO_PARTS_GRID_CELL HISTORY_WO_PARTS 1:N
Indexes
Index name Columns Unique Descending Clustered
HISTORY_WO_PARTS_GRID_CELL_X1 Work_Order_No, Work_Order_Seq_No, Task_Seq_No, Pts_Seq_No NO 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)


HISTORY_WO_PARTS_SERIALS
Columns
Key Column name Domain Data type Not null Unique Check Default
PK Work_Order_No U_GENERAL_ID Varchar (15) YES NO
PK Work_Order_Seq_No U_INTEGER Numeric (7,0) YES NO
PK Task_Seq_No U_INTEGER Numeric (7,0) YES NO
PK Pts_Seq_No U_INTEGER Numeric (7,0) YES NO
PK Serial_No U_ITEM_NO Varchar (30) YES NO
Item_No U_ITEM_NO Varchar (30) NO NO
Inv_Loc U_CODE Varchar (10) NO NO
XFERRED_FROM_POS U_FLAG Char (1) NO NO
Relationships
Constraint (relationship) name Relationship type Parent table Child table Card.
History WO Parts Serials (History WO Parts Serials) Informative HISTORY_WO_PARTS HISTORY_WO_PARTS_SERIALS 1:N
Indexes
Index name Columns Unique Descending Clustered
HISTORY_WO_PARTS_SERIALS_X1 Work_Order_No, Work_Order_Seq_No, Task_Seq_No, Pts_Seq_No, Serial_No NO 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)


HISTORY_WO_PMNT
Columns
Key Column name Domain Data type Not null Unique Check Default
PFK Work_Order_No U_GENERAL_ID Varchar (15) YES NO
PFK Work_Order_Seq_No U_INTEGER Numeric (7,0) YES NO
PK Seq_No U_INTEGER Numeric (7,0) YES NO
Pay_Code U_CODE Varchar (10) NO NO
Amount U_PRICE Decimal (15,4) NO NO
Description U_DESC Varchar (30) NO NO
Reference_1 U_EMAIL_ADRS Varchar (50) NO NO
Reference_2 U_EMAIL_ADRS Varchar (50) NO NO
Reference_3 U_EMAIL_ADRS Varchar (50) NO NO
Relationships
Constraint (relationship) name Relationship type Parent table Child table Card.
WO History Payment (WO History Payment) Identifying HISTORY_WORK_ORDER HISTORY_WO_PMNT 1:N
Indexes
Index name Columns Unique Descending Clustered
HISTORY_WO_PMNT_X1 Work_Order_No, Work_Order_Seq_No, Seq_No NO 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)


HISTORY_WO_TASK
Columns
Key Column name Domain Data type Not null Unique Check Default
PK Work_Order_No U_GENERAL_ID Varchar (15) YES NO
PK Work_Order_Seq_No U_INTEGER Numeric (7,0) YES NO
PK Task_Seq_No U_INTEGER Numeric (7,0) YES NO
Name U_NAME Varchar (40) NO NO
Model U_DESC Varchar (30) NO NO
Serial_No U_DESC Varchar (30) NO NO
Description U_DESC Varchar (30) NO NO
Description_2 U_DESC Varchar (30) NO NO
WORK_CAT U_CODE Varchar (10) NO NO
LOCATION U_UDEF Varchar (100) NO NO
INVOICING_CODE U_CODE Varchar (10) NO NO
CONTRACT_NO U_GENERAL_ID Varchar (15) NO NO
PROBLEM U_CODE Varchar (10) NO NO
IS_REPAIR U_FLAG Char (1) NO NO
IS_PM U_FLAG Char (1) NO NO
ESTIMATED_TTR U_QTY Numeric (7,2) NO NO
TASK_STATUS U_FLAG Char (1) NO NO
SPLIT_BILL_SEL_FLG U_FLAG Char (1) NO NO
ESTIMATED_COMPL_DATE U_DATE Datetime NO NO
Relationships
Constraint (relationship) name Relationship type Parent table Child table Card.
History WO Task Addl Chg (History WO Task Addl Chg) Identifying HISTORY_WO_TASK HISTORY_WO_ADDL_CHG 1:N
History WO Task Parts (History WO Task Parts) Identifying HISTORY_WO_TASK HISTORY_WO_PARTS 1:N
History WO Task Labor (History WO Task Labor) Identifying HISTORY_WO_TASK HISTORY_WO_LABOR 1:N
History Work Order Task (History Work Order Task) Informative HISTORY_WORK_ORDER HISTORY_WO_TASK 1:N
History WO Task Notes (History WO Task Notes) Identifying HISTORY_WO_TASK HISTORY_WO_TASK_NOTES 1:N
Indexes
Index name Columns Unique Descending Clustered
HISTORY_WO_TASK_X1 Work_Order_No, Work_Order_Seq_No, Task_Seq_No NO 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)


HISTORY_WO_TASK_NOTES
Columns
Key Column name Domain Data type Not null Unique Check Default
PFK Work_Order_No U_GENERAL_ID Varchar (15) YES NO
PFK Work_Order_Seq_No U_INTEGER Numeric (7,0) YES NO
PFK Task_Seq_No U_INTEGER Numeric (7,0) YES NO
PK Note_ID U_NOTE_ID Varchar (20) YES NO
Description U_DESC Varchar (30) NO NO
NOTE_TEXT U_NOTE Text NO NO
RAW_TEXT U_NOTE Text NO NO
LAST_MAINT_DATE U_DATE Datetime NO NO
PRT_ON_WO U_FLAG Char (1) NO NO
PRT_ON_INVOICE U_FLAG Char (1) NO NO
Relationships
Constraint (relationship) name Relationship type Parent table Child table Card.
History WO Task Notes (History WO Task Notes) Identifying HISTORY_WO_TASK HISTORY_WO_TASK_NOTES 1:N
Indexes
Index name Columns Unique Descending Clustered
HISTORY_WO_TASK_NOTES_X1 Work_Order_No, Work_Order_Seq_No, Task_Seq_No, Note_ID NO 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)


HISTORY_WO_TAX
Columns
Key Column name Domain Data type Not null Unique Check Default
PFK Work_Order_No U_GENERAL_ID Varchar (15) YES NO
PFK Work_Order_Seq_No U_INTEGER Numeric (7,0) YES NO
PK Seq_No U_INTEGER Numeric (7,0) YES NO
TAX_CODE U_GENERAL_ID Varchar (15) NO NO
AUTH_CODE U_GENERAL_ID Varchar (15) NO NO
AUTH_RULE_CODE U_GENERAL_ID Varchar (15) NO NO
Amount U_PRICE Decimal (15,4) NO NO
TAX_ACCOUNT_NO U_GL_ACCT_NO Varchar (20) NO NO
Relationships
Constraint (relationship) name Relationship type Parent table Child table Card.
WO History Tax (WO History Tax) Identifying HISTORY_WORK_ORDER HISTORY_WO_TAX 1:N
Indexes
Index name Columns Unique Descending Clustered
HISTORY_WO_TAX_X1 Work_Order_No, Work_Order_Seq_No, Seq_No NO 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)


HISTORY_WORK_ORDER
Columns
Key Column name Domain Data type Not null Unique Check Default
PK Work_Order_No U_GENERAL_ID Varchar (15) YES NO
PK Work_Order_Seq_No U_INTEGER Numeric (7,0) YES NO
Customer U_GENERAL_ID Varchar (15) NO NO
Address_ID U_GENERAL_ID Varchar (15) NO NO
Status U_CODE Varchar (10) NO NO
OPEN_DATE U_DATE Datetime NO NO
OPEN_TIME U_DATE Datetime NO NO
SVC_SITE_NAME U_NAME Varchar (40) NO NO
SVC_ADDR_1 U_NAME Varchar (40) NO NO
SVC_ADDR_2 U_NAME Varchar (40) NO NO
SVC_CITY U_DESC Varchar (30) NO NO
SVC_STATE U_CODE Varchar (10) NO NO
SVC_ZIP_CODE U_GENERAL_ID Varchar (15) NO NO
SVC_COUNTRY U_DESC Varchar (30) NO NO
CONTACT_1_NAME U_NAME Varchar (40) NO NO
CONTACT_1_PHONE U_LONG_CODE Varchar (25) NO NO
PO_NO U_LONG_CODE Varchar (25) NO NO
MAP_GRID U_DESC Varchar (30) NO NO
PRIORITY U_CODE Varchar (10) NO NO
DISPATCH_NOTE U_UDEF Varchar (100) NO NO
USR_DEFINED_1 U_UDEF Varchar (100) NO NO
USR_DEFINED_2 U_UDEF Varchar (100) NO NO
USR_DEFINED_3 U_UDEF Varchar (100) NO NO
USR_DEFINED_4 U_UDEF Varchar (100) NO NO
TAX_CODE U_GENERAL_ID Varchar (15) NO NO
INVOICE_NO U_INTEGER Numeric (7,0) NO NO
INVOICE_DATE U_DATE Datetime NO NO
INVOICE_PRINT_STAT U_FLAG Char (1) NO NO
INVOICE_POST_STAT U_FLAG Char (1) NO NO
DISC_PCT U_QTY Numeric (7,2) NO NO
TOTAL_SALES U_PRICE Decimal (15,4) NO NO
TOTAL_TXBL_SALES U_PRICE Decimal (15,4) NO NO
FLAT_CHG_HOURS U_QTY Numeric (7,2) NO NO
BILL_GROUP U_CODE Varchar (10) NO NO
POST_TO_CUSTOMER U_GENERAL_ID Varchar (15) NO NO
ZONE U_CODE Varchar (10) NO NO
SALES_REP U_GENERAL_ID Varchar (15) NO NO
COMMISSION_AMT U_PRICE Decimal (15,4) NO NO
TERMS_CODE U_LONG_CODE Varchar (25) NO NO
SEL_FOR_BILLING_FLG U_FLAG Char (1) NO NO
SPLIT_BILL_SEQ_NO U_INTEGER Numeric (7,0) NO NO
SPLIT_BILL_SEL_FLG U_FLAG Char (1) NO NO
TOT_TAX_AMT U_PRICE Decimal (15,4) NO NO
TOT_PAYMENTS U_PRICE Decimal (15,4) NO NO
XFER_TO_TKT_NO U_GENERAL_ID Varchar (15) NO NO
POS_STORE U_CODE Varchar (10) NO NO
POS_DRAWER U_CODE Varchar (10) NO NO
ENTRY_USER U_CODE Varchar (10) NO NO
ENTRY_DATE U_DATE Datetime NO NO
LAST_MAINT_USER U_CODE Varchar (10) NO NO
LAST_MAINT_DATE U_DATE Datetime NO NO
CR_MEMO_NO U_INTEGER Numeric (7,0) NO NO
CR_MEMO_DATE U_DATE Datetime NO NO
CR_MEMO_FLG U_FLAG Char (1) NO NO
POSTING_EVENT_NO U_GENERAL_ID Varchar (15) NO NO
Relationships
Constraint (relationship) name Relationship type Parent table Child table Card.
WO History Notes (WO History Notes) Identifying HISTORY_WORK_ORDER HISTORY_WO_NOTES 1:N
WO History Tax (WO History Tax) Identifying HISTORY_WORK_ORDER HISTORY_WO_TAX 1:N
WO History Payment (WO History Payment) Identifying HISTORY_WORK_ORDER HISTORY_WO_PMNT 1:N
History Work Order Task (History Work Order Task) Informative HISTORY_WORK_ORDER HISTORY_WO_TASK 1:N
Indexes
Index name Columns Unique Descending Clustered
HISTORY_WORK_ORDER_X1 Work_Order_No, Work_Order_Seq_No NO NO NO
HISTORY_WORK_ORDER_X2 Customer, Work_Order_No, Work_Order_Seq_No NO 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)


INVOICING_CODE
Columns
Key Column name Domain Data type Not null Unique Check Default
PK Code U_CODE Varchar (10) YES YES
Description U_DESC Varchar (30) NO NO
FLAT_CHG U_PRICE Decimal (15,4) NO NO
TIME_FOR_FLAT_CHG U_QTY Numeric (7,2) NO NO
ZONE_CHG U_PRICE Decimal (15,4) NO NO
TECH_RATE_REG U_PRICE Decimal (15,4) NO NO
TECH_RATE_OT U_PRICE Decimal (15,4) NO NO
TECH_RATE_SPEC U_PRICE Decimal (15,4) NO NO
HELP_RATE_REG U_PRICE Decimal (15,4) NO NO
HELP_RATE_OT U_PRICE Decimal (15,4) NO NO
HELP_RATE_SPEC U_PRICE Decimal (15,4) NO NO
MIN_LBR_TIME_REG U_QTY Numeric (7,2) NO NO
MIN_LBR_TIME_OT U_QTY Numeric (7,2) NO NO
MIN_LBR_TIME_SPEC U_QTY Numeric (7,2) NO NO
LBR_TIME_INCR_REG U_QTY Numeric (7,2) NO NO
LBR_TIME_INCR_OT U_QTY Numeric (7,2) NO NO
LBR_TIME_INCR_SPEC U_QTY Numeric (7,2) NO NO
TECH_TVL_RATE_REG U_PRICE Decimal (15,4) NO NO
TECH_TVL_RATE_OT U_PRICE Decimal (15,4) NO NO
TECH_TVL_RATE_SPEC U_PRICE Decimal (15,4) NO NO
HELP_TVL_RATE_REG U_PRICE Decimal (15,4) NO NO
HELP_TVL_RATE_OT U_PRICE Decimal (15,4) NO NO
HELP_TVL_RATE_SPEC U_PRICE Decimal (15,4) NO NO
MIN_TVL_CHG_REG U_PRICE Decimal (15,4) NO NO
MIN_TVL_CHG_OT U_PRICE Decimal (15,4) NO NO
MIN_TVL_CHG_SPEC U_PRICE Decimal (15,4) NO NO
MAX_TVL_CHG_REG U_PRICE Decimal (15,4) NO NO
MAX_TVL_CHG_OT U_PRICE Decimal (15,4) NO NO
MAX_TVL_CHG_SPEC U_PRICE Decimal (15,4) NO NO
TVL_TIME_INCR_REG U_QTY Numeric (7,2) NO NO
TVL_TIME_INCR_OT U_QTY Numeric (7,2) NO NO
TVL_TIME_INCR_SPEC U_QTY Numeric (7,2) NO NO
CHG_PER_MILE_REG U_PRICE Decimal (15,4) NO NO
CHG_PER_MILE_OT U_PRICE Decimal (15,4) NO NO
CHG_PER_MILE_SPEC U_PRICE Decimal (15,4) NO NO
PARTS_PRICING_GROUP U_CODE Varchar (10) NO NO
FLAT_CHG_DESC U_DESC Varchar (30) NO NO
TVL_CHG_DESC U_DESC Varchar (30) NO NO
ZONE_CHG_DESC U_DESC Varchar (30) NO NO
ADDL_CHG_4_DESC U_DESC Varchar (30) NO NO
ADDL_CHG_5_DESC U_DESC Varchar (30) NO NO
ACCT_LBR_REG U_GL_ACCT_NO Varchar (20) NO NO
ACCT_LBR_OT U_GL_ACCT_NO Varchar (20) NO NO
ACCT_LBR_SPEC U_GL_ACCT_NO Varchar (20) NO NO
ACCT_PTS_REG U_GL_ACCT_NO Varchar (20) NO NO
ACCT_PTS_OT U_GL_ACCT_NO Varchar (20) NO NO
ACCT_PTS_SPEC U_GL_ACCT_NO Varchar (20) NO NO
ACCT_FLAT_REG U_GL_ACCT_NO Varchar (20) NO NO
ACCT_FLAT_OT U_GL_ACCT_NO Varchar (20) NO NO
ACCT_FLAT_SPEC U_GL_ACCT_NO Varchar (20) NO NO
ACCT_TVL_REG U_GL_ACCT_NO Varchar (20) NO NO
ACCT_TVL_OT U_GL_ACCT_NO Varchar (20) NO NO
ACCT_TVL_SPEC U_GL_ACCT_NO Varchar (20) NO NO
ACCT_ZONE_REG U_GL_ACCT_NO Varchar (20) NO NO
ACCT_ZONE_OT U_GL_ACCT_NO Varchar (20) NO NO
ACCT_ZONE_SPEC U_GL_ACCT_NO Varchar (20) NO NO
ACCT_ADDL_4_REG U_GL_ACCT_NO Varchar (20) NO NO
ACCT_ADDL_4_OT U_GL_ACCT_NO Varchar (20) NO NO
ACCT_ADDL_4_SPEC U_GL_ACCT_NO Varchar (20) NO NO
ACCT_ADDL_5_REG U_GL_ACCT_NO Varchar (20) NO NO
ACCT_ADDL_5_OT U_GL_ACCT_NO Varchar (20) NO NO
ACCT_ADDL_5_SPEC U_GL_ACCT_NO Varchar (20) NO NO
ACCT_DISC_REG U_GL_ACCT_NO Varchar (20) NO NO
ACCT_DISC_OT U_GL_ACCT_NO Varchar (20) NO NO
ACCT_DISC_SPEC U_GL_ACCT_NO Varchar (20) NO NO
PTS_ACCT_PFT_CTR_SOURCE U_FLAG Char (1) NO NO
PTS_ACCT_INVC_CODE_PFT_CTR U_GL_ACCT_NO Varchar (20) NO NO
PTS_ACCT_PFT_CTR_SEGMENT U_INTEGER Numeric (7,0) NO NO
LBR_ACCT_PFT_CTR_FROM_ITEM U_FLAG Char (1) NO NO
MISC_ACCT_PFT_CTR_FROM_ITEM U_FLAG Char (1) 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)


METER_READINGS
Columns
Key Column name Domain Data type Not null Unique Check Default
PK Customer U_GENERAL_ID Varchar (15) YES NO
PK Address_ID U_GENERAL_ID Varchar (15) YES NO
PK Model_ID U_LONG_CODE Varchar (25) YES NO
PK Serial_No U_DESC Varchar (30) YES NO
WORK_ORDER_NO U_GENERAL_ID Varchar (15) NO NO
READING_DATE U_DATE Datetime NO NO
METER1_READING_TYPE U_FLAG Char (1) NO NO
METER1_READING_AMT U_PRICE Decimal (15,4) NO NO
METER1_READING_CREDIT U_PRICE Decimal (15,4) NO NO
METER2_READING_TYPE U_FLAG Char (1) NO NO
METER2_READING_AMT U_PRICE Decimal (15,4) NO NO
METER2_READING_CREDIT U_PRICE Decimal (15,4) NO NO
METER3_READING_TYPE U_FLAG Char (1) NO NO
METER3_READING_AMT U_PRICE Decimal (15,4) NO NO
METER3_READING_CREDIT U_PRICE Decimal (15,4) NO NO
METER4_READING_TYPE U_FLAG Char (1) NO NO
METER4_READING_AMT U_PRICE Decimal (15,4) NO NO
METER4_READING_CREDIT U_PRICE Decimal (15,4) NO NO
METER5_READING_TYPE U_FLAG Char (1) NO NO
METER5_READING_AMT U_PRICE Decimal (15,4) NO NO
METER5_READING_CREDIT U_PRICE Decimal (15,4) NO NO
Indexes
Index name Columns Unique Descending Clustered
METER_READINGS_X1 Customer, Address_ID, Model_ID, Serial_No NO 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)


PM_SCHED
Columns
Key Column name Domain Data type Not null Unique Check Default
PK Schedule_ID U_CODE Varchar (10) YES YES
Description U_DESC Varchar (30) NO NO
TYPE U_FLAG Char (1) NO NO
INTERVAL_QTY U_INTEGER Numeric (7,0) NO NO
INTERVAL_UNIT U_FLAG Char (1) NO NO
EARLY_WIN_QTY U_INTEGER Numeric (7,0) NO NO
EARLY_WIN_UNIT U_FLAG Char (1) NO NO
LATE_WIN_QTY U_INTEGER Numeric (7,0) NO NO
LATE_WIN_UNIT U_FLAG Char (1) NO NO
DATE_01 U_DATE Datetime NO NO
DATE_02 U_DATE Datetime NO NO
DATE_03 U_DATE Datetime NO NO
DATE_04 U_DATE Datetime NO NO
DATE_05 U_DATE Datetime NO NO
DATE_06 U_DATE Datetime NO NO
DATE_07 U_DATE Datetime NO NO
DATE_08 U_DATE Datetime NO NO
DATE_09 U_DATE Datetime NO NO
DATE_10 U_DATE Datetime NO NO
DATE_11 U_DATE Datetime NO NO
DATE_12 U_DATE Datetime NO NO
DATE_13 U_DATE Datetime NO NO
DATE_14 U_DATE Datetime NO NO
DATE_15 U_DATE Datetime NO NO
DATE_16 U_DATE Datetime NO NO
DATE_17 U_DATE Datetime NO NO
DATE_18 U_DATE Datetime NO NO
DATE_19 U_DATE Datetime NO NO
DATE_20 U_DATE Datetime NO NO
DATE_21 U_DATE Datetime NO NO
DATE_22 U_DATE Datetime NO NO
DATE_23 U_DATE Datetime NO NO
DATE_24 U_DATE Datetime NO NO
DATE_25 U_DATE Datetime NO NO
DATE_26 U_DATE Datetime NO NO
DATE_27 U_DATE Datetime NO NO
DATE_28 U_DATE Datetime NO NO
DATE_29 U_DATE Datetime NO NO
DATE_30 U_DATE Datetime 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)


PREDEF_JOB
Columns
Key Column name Domain Data type Not null Unique Check Default
PK Job_ID U_GENERAL_ID Varchar (15) YES NO
Description U_DESC Varchar (30) NO NO
Relationships
Constraint (relationship) name Relationship type Parent table Child table Card.
Predef Job Notes (Predef Job Notes) Informative PREDEF_JOB PREDEF_JOB_NOTES 1:N
Predef Job Task (Predef Job Task) Informative PREDEF_JOB PREDEF_JOB_TASK 1:N
Indexes
Index name Columns Unique Descending Clustered
PREDEF_JOB_X1 Job_ID YES NO NO
PREDEF_JOB_X2 Description, Job_ID YES 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)


PREDEF_JOB_ADDL_CHG
Columns
Key Column name Domain Data type Not null Unique Check Default
PFK Job_ID U_GENERAL_ID Varchar (15) YES NO
PFK Task_Seq_No U_INTEGER Numeric (7,0) YES NO
PK Addl_Chg_Seq_No U_INTEGER Numeric (7,0) YES NO
Description U_UDEF Varchar (100) NO NO
Amount U_PRICE Decimal (15,4) NO NO
Cost U_COST Decimal (15,4) NO NO
IS_TAXABLE U_FLAG Char (1) NO NO
Sales_Acct_No U_GL_ACCT_NO Varchar (20) NO NO
Cost_Acct_No U_GL_ACCT_NO Varchar (20) NO NO
Relationships
Constraint (relationship) name Relationship type Parent table Child table Card.
PJ Task Addl Chg (PJ Task Addl Chg) Identifying PREDEF_JOB_TASK PREDEF_JOB_ADDL_CHG 1:N
Indexes
Index name Columns Unique Descending Clustered
JOB_ADDL_CHG_X1 Job_ID, Task_Seq_No, Addl_Chg_Seq_No NO 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)


PREDEF_JOB_LABOR
Columns
Key Column name Domain Data type Not null Unique Check Default
PFK Job_ID U_GENERAL_ID Varchar (15) YES NO
PFK Task_Seq_No U_INTEGER Numeric (7,0) YES NO
PK Lbr_Seq_No U_INTEGER Numeric (7,0) YES NO
Tech_ID U_CODE Varchar (10) NO NO
Work_Description U_UDEF Varchar (100) NO NO
TYPE_FLG U_FLAG Char (1) NO NO
Hourly_Price U_PRICE Decimal (15,4) NO NO
Hours_To_Bill U_QTY Numeric (7,2) NO NO
HRS_ADJ_FOR_FLAT U_QTY Numeric (7,2) NO NO
HRS_ADJ_UP_FOR_INCR U_QTY Numeric (7,2) NO NO
Date_For_Sched U_DATE Datetime NO NO
Time_For_Sched U_DATE Datetime NO NO
IS_TAXABLE U_FLAG Char (1) NO NO
Relationships
Constraint (relationship) name Relationship type Parent table Child table Card.
PJ Task Labor (PJ Task Labor) Identifying PREDEF_JOB_TASK PREDEF_JOB_LABOR 1:N
PJ Labor Notes (PJ Labor Notes) Informative PREDEF_JOB_LABOR PREDEF_JOB_LABOR_NOTES 1:N
Indexes
Index name Columns Unique Descending Clustered
JOB_LABOR_X1 Job_ID, Task_Seq_No, Lbr_Seq_No NO 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)


PREDEF_JOB_LABOR_NOTES
Columns
Key Column name Domain Data type Not null Unique Check Default
PK Job_ID U_GENERAL_ID Varchar (15) YES NO
PK Task_Seq_No U_INTEGER Numeric (7,0) YES NO
PK Lbr_Seq_No U_INTEGER Numeric (7,0) YES NO
PK Note_ID U_NOTE_ID Varchar (20) YES NO
Description U_DESC Varchar (30) NO NO
NOTE_TEXT U_NOTE Text NO NO
RAW_TEXT U_NOTE Text NO NO
LAST_MAINT_DATE U_DATE Datetime NO NO
PRT_ON_WO U_FLAG Char (1) NO NO
PRT_ON_INVOICE U_FLAG Char (1) NO NO
Relationships
Constraint (relationship) name Relationship type Parent table Child table Card.
PJ Labor Notes (PJ Labor Notes) Informative PREDEF_JOB_LABOR PREDEF_JOB_LABOR_NOTES 1:N
Indexes
Index name Columns Unique Descending Clustered
JOB_LABOR_NOTES_X1 Job_ID, Task_Seq_No, Lbr_Seq_No, Note_ID NO 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)


PREDEF_JOB_NOTES
Columns
Key Column name Domain Data type Not null Unique Check Default
PK Job_ID U_GENERAL_ID Varchar (15) YES NO
PK Note_ID U_NOTE_ID Varchar (20) YES NO
Description U_DESC Varchar (30) NO NO
NOTE_TEXT U_NOTE Text NO NO
RAW_TEXT U_NOTE Text NO NO
LAST_MAINT_DATE U_DATE Datetime NO NO
PRT_ON_WO U_FLAG Char (1) NO NO
PRT_ON_INVOICE U_FLAG Char (1) NO NO
Relationships
Constraint (relationship) name Relationship type Parent table Child table Card.
Predef Job Notes (Predef Job Notes) Informative PREDEF_JOB PREDEF_JOB_NOTES 1:N
Indexes
Index name Columns Unique Descending Clustered
JOB_NOTES_X1 Job_ID, Note_ID NO 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)


PREDEF_JOB_PARTS
Columns
Key Column name Domain Data type Not null Unique Check Default
PFK Job_ID U_GENERAL_ID Varchar (15) YES NO
PFK Task_Seq_No U_INTEGER Numeric (7,0) YES NO
PK Pts_Seq_No U_INTEGER Numeric (7,0) YES NO
Item_No U_ITEM_NO Varchar (30) NO NO
Inv_Loc U_CODE Varchar (10) NO NO
Description U_UDEF Varchar (100) NO NO
Qty_Used U_QTY Numeric (7,2) NO NO
Unit_Cost U_COST Decimal (15,4) NO NO
Unit_Price U_PRICE Decimal (15,4) NO NO
DISCOUNT_PCT U_QTY Numeric (7,2) NO NO
IS_TAXABLE U_FLAG Char (1) NO NO
SALES_ACCT_NO U_GL_ACCT_NO Varchar (20) NO NO
Relationships
Constraint (relationship) name Relationship type Parent table Child table Card.
PJ Task Parts (PJ Task Parts) Identifying PREDEF_JOB_TASK PREDEF_JOB_PARTS 1:N
Indexes
Index name Columns Unique Descending Clustered
JOB_PARTS_X1 Job_ID, Task_Seq_No, Pts_Seq_No NO 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)


PREDEF_JOB_TASK
Columns
Key Column name Domain Data type Not null Unique Check Default
PK Job_ID U_GENERAL_ID Varchar (15) YES NO
PK Task_Seq_No U_INTEGER Numeric (7,0) YES NO
Name U_NAME Varchar (40) NO NO
Model U_DESC Varchar (30) NO NO
Serial_No U_DESC Varchar (30) NO NO
Description U_DESC Varchar (30) NO NO
Description_2 U_DESC Varchar (30) NO NO
WORK_CAT U_CODE Varchar (10) NO NO
LOCATION U_UDEF Varchar (100) NO NO
INVOICING_CODE U_CODE Varchar (10) NO NO
CONTRACT_NO U_GENERAL_ID Varchar (15) NO NO
PROBLEM U_CODE Varchar (10) NO NO
IS_REPAIR U_FLAG Char (1) NO NO
IS_PM U_FLAG Char (1) NO NO
ESTIMATED_TTR U_QTY Numeric (7,2) NO NO
TASK_STATUS U_FLAG Char (1) NO NO
Relationships
Constraint (relationship) name Relationship type Parent table Child table Card.
Predef Job Task (Predef Job Task) Informative PREDEF_JOB PREDEF_JOB_TASK 1:N
PJ Task Addl Chg (PJ Task Addl Chg) Identifying PREDEF_JOB_TASK PREDEF_JOB_ADDL_CHG 1:N
PJ Task Parts (PJ Task Parts) Identifying PREDEF_JOB_TASK PREDEF_JOB_PARTS 1:N
PJ Task Labor (PJ Task Labor) Identifying PREDEF_JOB_TASK PREDEF_JOB_LABOR 1:N
PJ Task Notes (PJ Task Notes) Informative PREDEF_JOB_TASK PREDEF_JOB_TASK_NOTES 1:N
Indexes
Index name Columns Unique Descending Clustered
JOB_TASK_X1 Job_ID, Task_Seq_No NO 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)


PREDEF_JOB_TASK_NOTES
Columns
Key Column name Domain Data type Not null Unique Check Default
PK Job_ID U_GENERAL_ID Varchar (15) YES NO
PK Task_Seq_No U_INTEGER Numeric (7,0) YES NO
PK Note_ID U_NOTE_ID Varchar (20) YES NO
Description U_DESC Varchar (30) NO NO
NOTE_TEXT U_NOTE Text NO NO
RAW_TEXT U_NOTE Text NO NO
LAST_MAINT_DATE U_DATE Datetime NO NO
PRT_ON_WO U_FLAG Char (1) NO NO
PRT_ON_INVOICE U_FLAG Char (1) NO NO
Relationships
Constraint (relationship) name Relationship type Parent table Child table Card.
PJ Task Notes (PJ Task Notes) Informative PREDEF_JOB_TASK PREDEF_JOB_TASK_NOTES 1:N
Indexes
Index name Columns Unique Descending Clustered
JOB_TASK_NOTES_X1 Job_ID, Task_Seq_No, Note_ID NO 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)


PREDEF_NOTES
Columns
Key Column name Domain Data type Not null Unique Check Default
PK Note_ID U_NOTE_ID Varchar (20) YES NO
Description U_EMAIL_ADRS Varchar (50) NO NO
NOTE_SAMPLE U_DESC Varchar (30) NO NO
NOTE_TEXT U_NOTE Text NO NO
RAW_TEXT U_NOTE Text NO NO
LAST_MAINT_DATE U_DATE Datetime NO NO
Indexes
Index name Columns Unique Descending Clustered
PREDEF_NOTE_X1 Note_ID NO 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)


PRIORITY_CODE
Columns
Key Column name Domain Data type Not null Unique Check Default
PK Code U_CODE Varchar (10) YES YES
Description U_DESC Varchar (30) NO NO
RESPONSE_TIME U_QTY Numeric (7,2) NO NO
FORE_COLOR U_CODE Varchar (10) NO NO
BACK_COLOR U_CODE Varchar (10) 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)


PROBLEM_CODE
Columns
Key Column name Domain Data type Not null Unique Check Default
PK Code U_CODE Varchar (10) YES YES
Description U_DESC Varchar (30) NO NO
PERFORM_PM U_FLAG Char (1) NO NO
PERFORM_REPAIR U_FLAG Char (1) NO NO
EST_TTR U_QTY Numeric (7,2) NO NO
DFLT_TECH U_CODE Varchar (10) 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)


REFERRAL_SOURCE
Columns
Key Column name Domain Data type Not null Unique Check Default
PK Code U_CODE Varchar (10) YES YES
Description U_DESC Varchar (30) 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)


SETUP_NOTES
Columns
Key Column name Domain Data type Not null Unique Check Default
PK CODE_TYPE U_FLAG Char (1) YES NO
PK CODE U_LONG_CODE Varchar (25) YES NO
PK Note_ID U_NOTE_ID Varchar (20) YES NO
Description U_DESC Varchar (30) NO NO
NOTE_TEXT U_NOTE Text NO NO
RAW_TEXT U_NOTE Text NO NO
LAST_MAINT_DATE U_DATE Datetime NO NO
Relationships
Constraint (relationship) name Relationship type Parent table Child table Card.
Tech notes (Tech notes) Informative SVC_TECH SETUP_NOTES 1:N
Model Notes (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)


SP_USER
Columns
Key Column name Domain Data type Not null Unique Check Default
PK User_ID U_CODE Varchar (10) YES YES
Name U_DESC Varchar (30) NO NO
PASSWORD U_UDEF Varchar (100) NO NO
DATE_PWD_CHGD U_DATE Datetime NO NO
MENU U_NOTE Text NO NO
VIEW_COSTS U_FLAG Char (1) NO NO
DEPARTMENT U_LONG_CODE Varchar (25) NO NO
USER_TYPE U_FLAG Char (1) NO NO
Indexes
Index name Columns Unique Descending Clustered
SP_USER_X1 User_ID YES 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)


STATUS_CODE
Columns
Key Column name Domain Data type Not null Unique Check Default
PK Code U_CODE Varchar (10) YES YES
Description U_DESC Varchar (30) NO NO
IS_FROZEN U_FLAG Char (1) NO NO
COMMIT_PTS U_FLAG Char (1) NO NO
ALLOW_LBR U_FLAG Char (1) NO NO
ALLOW_PTS U_FLAG Char (1) NO NO
ALLOW_BILL U_FLAG Char (1) NO NO
INVOICE_TYPE U_FLAG Char (1) NO NO
DFLT_INVC_FORM U_DESC Varchar (30) NO NO
DFLT_WO_FORM U_DESC Varchar (30) NO NO
EMAIL_CHNG_TO_FLG U_FLAG Char (1) NO NO
EMAIL_CHNG_FROM_FLG U_FLAG Char (1) NO NO
EMAIL_CUST_FLG U_FLAG Char (1) NO NO
EMAIL_CUST_FORM U_DESC Varchar (30) NO NO
EMAIL_TECH_FLG U_FLAG Char (1) NO NO
EMAIL_TECH_FORM U_DESC Varchar (30) NO NO
EMAIL_THIS_ADDR U_EMAIL_ADRS Varchar (50) NO NO
EMAIL_THIS_FORM U_DESC Varchar (30) 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)


SVC_ADDRESS
Columns
Key Column name Domain Data type Not null Unique Check Default
PK Customer U_GENERAL_ID Varchar (15) YES NO
PK Address_ID U_GENERAL_ID Varchar (15) YES NO
Name U_NAME Varchar (40) NO NO
ADDRESS_1 U_NAME Varchar (40) NO NO
ADDRESS_2 U_NAME Varchar (40) NO NO
CITY U_DESC Varchar (30) NO NO
STATE U_CODE Varchar (10) NO NO
ZIP_CODE U_GENERAL_ID Varchar (15) NO NO
COUNTRY U_DESC Varchar (30) NO NO
CONTACT_1 U_NAME Varchar (40) NO NO
PHONE_1 U_PHONE Varchar (25) NO NO
FAX_1 U_PHONE Varchar (25) NO NO
EMAIL_1 U_EMAIL_ADRS Varchar (50) NO NO
CONTACT_2 U_NAME Varchar (40) NO NO
PHONE_2 U_PHONE Varchar (25) NO NO
FAX_2 U_PHONE Varchar (25) NO NO
EMAIL_2 U_EMAIL_ADRS Varchar (50) NO NO
REFERRAL_SOURCE U_CODE Varchar (10) NO NO
MAIL_TO_CUST U_GENERAL_ID Varchar (15) NO NO
ZONE U_CODE Varchar (10) NO NO
TAX_CODE U_GENERAL_ID Varchar (15) NO NO
SVC_TECH U_CODE Varchar (10) NO NO
INVOICING_CODE U_CODE Varchar (10) NO NO
PO_NUMBER U_LONG_CODE Varchar (25) NO NO
MAP_GRID U_DESC Varchar (30) NO NO
SVC_HOLD_FLG U_FLAG Char (1) NO NO
Relationships
Constraint (relationship) name Relationship type Parent table Child table Card.
Svc Address Notes (Svc Address Notes) Informative SVC_ADDRESS SVC_ADDRESS_NOTES 1:N
Indexes
Index name Columns Unique Descending Clustered
SVC_ADDRESS_X1 Customer, Address_ID YES NO NO
SVC_ADDRESS_X2 Name NO 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)


SVC_ADDRESS_NOTES
Columns
Key Column name Domain Data type Not null Unique Check Default
PK Customer U_GENERAL_ID Varchar (15) YES NO
PK Address_ID U_GENERAL_ID Varchar (15) YES NO
PK Note_ID U_NOTE_ID Varchar (20) YES NO
Description U_DESC Varchar (30) NO NO
NOTE_TEXT U_NOTE Text NO NO
RAW_TEXT U_NOTE Text NO NO
LAST_MAINT_DATE U_DATE Datetime NO NO
Relationships
Constraint (relationship) name Relationship type Parent table Child table Card.
Svc Address Notes (Svc Address Notes) Informative SVC_ADDRESS SVC_ADDRESS_NOTES 1:N
Indexes
Index name Columns Unique Descending Clustered
SVC_ADDRESS_NOTES_X1 Customer, Address_ID, Note_ID NO 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)


SVC_TECH
Columns
Key Column name Domain Data type Not null Unique Check Default
PK Tech_ID U_CODE Varchar (10) YES YES
Name U_DESC Varchar (30) YES NO
PHONE_1 U_PHONE Varchar (25) NO NO
PHONE_2 U_PHONE Varchar (25) NO NO
EMAIL_ADRS U_EMAIL_ADRS Varchar (50) NO NO
STD_COST U_COST Decimal (15,4) NO NO
OT_COST U_COST Decimal (15,4) NO NO
SPEC_COST U_COST Decimal (15,4) NO NO
TYPE U_FLAG Char (1) NO NO
DFLT_PTS_LOC U_CODE Varchar (10) NO NO
CATEGORY_1 U_CODE Varchar (10) NO NO
CATEGORY_2 U_CODE Varchar (10) NO NO
CATEGORY_3 U_CODE Varchar (10) NO NO
CATEGORY_4 U_CODE Varchar (10) NO NO
CATEGORY_5 U_CODE Varchar (10) NO NO
DEPARTMENT U_LONG_CODE Varchar (25) NO NO
INACTIVE_FLG U_FLAG Char (1) NO NO
Relationships
Constraint (relationship) name Relationship type Parent table Child table Card.
Tech notes (Tech notes) Informative SVC_TECH SETUP_NOTES 1:N
Indexes
Index name Columns Unique Descending Clustered
SVC_TECH_X1 Tech_ID YES NO NO
SVC_TECH_X2 Name NO 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)


TAX_DEFAULT
Columns
Key Column name Domain Data type Not null Unique Check Default
PK Tax_Code U_GENERAL_ID Varchar (15) YES YES
TAX_PARTS U_FLAG Char (1) NO NO
TAX_LABOR U_FLAG Char (1) NO NO
TAX_FLAT_CHG U_FLAG Char (1) NO NO
TAX_TRAVEL_CHG U_FLAG Char (1) NO NO
TAX_ZONE_CHG U_FLAG Char (1) NO NO
TAX_OTHER_ADDL_CHG U_FLAG Char (1) NO NO
TAX_CONTRACT_CHGS U_FLAG Char (1) 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)


TECH_CAT
Columns
Key Column name Domain Data type Not null Unique Check Default
PK Code U_CODE Varchar (10) YES YES
Description U_DESC Varchar (30) 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)


USAGE_CODE
Columns
Key Column name Domain Data type Not null Unique Check Default
PK Code U_CODE Varchar (10) YES YES
Description U_DESC Varchar (30) NO NO
Type U_FLAG Char (1) NO NO
LEVEL_1 U_PRICE Decimal (15,4) NO NO
CHG_PER_USE_1 U_USAGE_PRICE Decimal (15,5) NO NO
LEVEL_2 U_PRICE Decimal (15,4) NO NO
CHG_PER_USE_2 U_USAGE_PRICE Decimal (15,5) NO NO
LEVEL_3 U_PRICE Decimal (15,4) NO NO
CHG_PER_USE_3 U_USAGE_PRICE Decimal (15,5) NO NO
LEVEL_4 U_PRICE Decimal (15,4) NO NO
CHG_PER_USE_4 U_USAGE_PRICE Decimal (15,5) NO NO
LEVEL_5 U_PRICE Decimal (15,4) NO NO
CHG_PER_USE_5 U_USAGE_PRICE Decimal (15,5) NO NO
LEVEL_6 U_PRICE Decimal (15,4) NO NO
CHG_PER_USE_6 U_USAGE_PRICE Decimal (15,5) 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)


WARRANTY
Columns
Key Column name Domain Data type Not null Unique Check Default
PK Warranty_ID U_CODE Varchar (10) YES NO
Description U_DESC Varchar (30) NO NO
INVC_CODE_1 U_CODE Varchar (10) NO NO
INTERVAL_QTY_1 U_INTEGER Numeric (7,0) NO NO
INTERVAL_UNIT_1 U_FLAG Char (1) NO NO
INVC_CODE_2 U_CODE Varchar (10) NO NO
INTERVAL_QTY_2 U_INTEGER Numeric (7,0) NO NO
INTERVAL_UNIT_2 U_FLAG Char (1) NO NO
INVC_CODE_3 U_CODE Varchar (10) NO NO
INTERVAL_QTY_3 U_INTEGER Numeric (7,0) NO NO
INTERVAL_UNIT_3 U_FLAG Char (1) NO NO
INVC_CODE_4 U_CODE Varchar (10) NO NO
INTERVAL_QTY_4 U_INTEGER Numeric (7,0) NO NO
INTERVAL_UNIT_4 U_FLAG Char (1) NO NO
INVC_CODE_5 U_CODE Varchar (10) NO NO
INTERVAL_QTY_5 U_INTEGER Numeric (7,0) NO NO
INTERVAL_UNIT_5 U_FLAG Char (1) NO NO
INVC_CODE_6 U_CODE Varchar (10) NO NO
INTERVAL_QTY_6 U_INTEGER Numeric (7,0) NO NO
INTERVAL_UNIT_6 U_FLAG Char (1) 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)


WO_ADDL_CHG
Columns
Key Column name Domain Data type Not null Unique Check Default
PFK Work_Order_No U_GENERAL_ID Varchar (15) YES NO
PFK Task_Seq_No U_INTEGER Numeric (7,0) YES NO
PK Addl_Chg_Seq_No U_INTEGER Numeric (7,0) YES NO
Description U_UDEF Varchar (100) NO NO
Amount U_PRICE Decimal (15,4) NO NO
Cost U_COST Decimal (15,4) NO NO
IS_TAXABLE U_FLAG Char (1) NO NO
Sales_Acct_No U_GL_ACCT_NO Varchar (20) NO NO
Cost_Acct_No U_GL_ACCT_NO Varchar (20) NO NO
SPLIT_BILL_SEL_FLG U_FLAG Char (1) NO NO
Relationships
Constraint (relationship) name Relationship type Parent table Child table Card.
WO Task Addl Chg (WO Task Addl Chg) Identifying WO_TASK WO_ADDL_CHG 1:N
Indexes
Index name Columns Unique Descending Clustered
WO_ADDL_CHG_X1 Work_Order_No, Task_Seq_No, Addl_Chg_Seq_No NO 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)


WO_LABOR
Columns
Key Column name Domain Data type Not null Unique Check Default
PFK Work_Order_No U_GENERAL_ID Varchar (15) YES NO
PFK Task_Seq_No U_INTEGER Numeric (7,0) YES NO
PK Lbr_Seq_No U_INTEGER Numeric (7,0) YES NO
Tech_ID U_CODE Varchar (10) NO NO
Work_Description U_UDEF Varchar (100) NO NO
TYPE_FLG U_FLAG Char (1) NO NO
SCHED_DATE U_DATE Datetime NO NO
SCHED_TIME U_DATE Datetime NO NO
DISP_DATE U_DATE Datetime NO NO
DISP_TIME U_DATE Datetime NO NO
START_DATE U_DATE Datetime NO NO
START_TIME U_DATE Datetime NO NO
STOP_DATE U_DATE Datetime NO NO
STOP_TIME U_DATE Datetime NO NO
RETURN_DATE U_DATE Datetime NO NO
RETURN_TIME U_DATE Datetime NO NO
HOURLY_COST U_COST Decimal (15,4) NO NO
Hourly_Price U_PRICE Decimal (15,4) NO NO
Hours_To_Bill U_QTY Numeric (7,2) NO NO
HRS_ADJ_FOR_FLAT U_QTY Numeric (7,2) NO NO
HRS_ADJ_UP_FOR_INCR U_QTY Numeric (7,2) NO NO
Date_For_Sched U_DATE Datetime NO NO
Time_For_Sched U_DATE Datetime NO NO
IS_TAXABLE U_FLAG Char (1) NO NO
SALES_ACCT_NO U_GL_ACCT_NO Varchar (20) NO NO
SPLIT_BILL_SEL_FLG U_FLAG Char (1) NO NO
Relationships
Constraint (relationship) name Relationship type Parent table Child table Card.
WO Task Labor (WO Task Labor) Identifying WO_TASK WO_LABOR 1:N
WO_LABOR_NOTES_FK (WO Labor Notes) Informative WO_LABOR WO_LABOR_NOTES 1:N
Indexes
Index name Columns Unique Descending Clustered
WO_LABOR_X1 Work_Order_No, Task_Seq_No, Lbr_Seq_No NO 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)


WO_LABOR_NOTES
Columns
Key Column name Domain Data type Not null Unique Check Default
PK Work_Order_No U_GENERAL_ID Varchar (15) YES NO
PK Task_Seq_No U_INTEGER Numeric (7,0) YES NO
PK Lbr_Seq_No U_INTEGER Numeric (7,0) YES NO
PK Note_ID U_NOTE_ID Varchar (20) YES NO
Description U_DESC Varchar (30) NO NO
NOTE_TEXT U_NOTE Text NO NO
RAW_TEXT U_NOTE Text NO NO
LAST_MAINT_DATE U_DATE Datetime NO NO
PRT_ON_WO U_FLAG Char (1) NO NO
PRT_ON_INVOICE U_FLAG Char (1) NO NO
Relationships
Constraint (relationship) name Relationship type Parent table Child table Card.
WO_LABOR_NOTES_FK (WO Labor Notes) Informative WO_LABOR WO_LABOR_NOTES 1:N
Indexes
Index name Columns Unique Descending Clustered
WO_LABOR_NOTES_X1 Work_Order_No, Task_Seq_No, Lbr_Seq_No, Note_ID NO 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)


WO_NOTES
Columns
Key Column name Domain Data type Not null Unique Check Default
PK Work_Order_No U_GENERAL_ID Varchar (15) YES NO
PK Note_ID U_NOTE_ID Varchar (20) YES NO
Description U_DESC Varchar (30) NO NO
NOTE_TEXT U_NOTE Text NO NO
RAW_TEXT U_NOTE Text NO NO
LAST_MAINT_DATE U_DATE Datetime NO NO
PRT_ON_WO U_FLAG Char (1) NO NO
PRT_ON_INVOICE U_FLAG Char (1) NO NO
Relationships
Constraint (relationship) name Relationship type Parent table Child table Card.
WO_NOTES_FK (WO Notes) Informative WORK_ORDER WO_NOTES 1:N
Indexes
Index name Columns Unique Descending Clustered
WO_NOTES_X1 Work_Order_No, Note_ID NO 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)


WO_PARTS
Columns
Key Column name Domain Data type Not null Unique Check Default
PFK Work_Order_No U_GENERAL_ID Varchar (15) YES NO
PFK Task_Seq_No U_INTEGER Numeric (7,0) YES NO
PK Pts_Seq_No U_INTEGER Numeric (7,0) YES NO
Item_No U_ITEM_NO Varchar (30) NO NO
Inv_Loc U_CODE Varchar (10) NO NO
Description U_UDEF Varchar (100) NO NO
Qty_Used U_QTY Numeric (7,2) NO NO
Unit_Cost U_COST Decimal (15,4) NO NO
Unit_Price U_PRICE Decimal (15,4) NO NO
DISCOUNT_PCT U_QTY Numeric (7,2) NO NO
IS_TAXABLE U_FLAG Char (1) NO NO
SALES_ACCT_NO U_GL_ACCT_NO Varchar (20) NO NO
SPLIT_BILL_SEL_FLG U_FLAG Char (1) NO NO
PRICING_TYPE_FLG U_FLAG Char (1) NO NO
XFERRED_FROM_POS U_FLAG Char (1) NO NO
Relationships
Constraint (relationship) name Relationship type Parent table Child table Card.
WO Task Parts (WO Task Parts) Identifying WO_TASK WO_PARTS 1:N
WO Parts Serials (WO Parts Serials) Informative WO_PARTS WO_PARTS_SERIALS 1:N
WO Parts Grid (WO Parts Grid) Informative WO_PARTS WO_PARTS_GRID_CELL 1:N
Indexes
Index name Columns Unique Descending Clustered
WO_PARTS_X1 Work_Order_No, Task_Seq_No, Pts_Seq_No NO 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)


WO_PARTS_GRID_CELL
Columns
Key Column name Domain Data type Not null Unique Check Default
PK Work_Order_No U_GENERAL_ID Varchar (15) YES NO
PK Task_Seq_No U_INTEGER Numeric (7,0) YES NO
PK Pts_Seq_No U_INTEGER Numeric (7,0) YES NO
Item_No U_ITEM_NO Varchar (30) NO NO
Inv_Loc U_CODE Varchar (10) NO NO
DIM_1_UPPER U_DESC Varchar (30) NO NO
DIM_2_UPPER U_DESC Varchar (30) NO NO
DIM_3_UPPER U_DESC Varchar (30) NO NO
QTY U_QTY Numeric (7,2) NO NO
XFERRED_FROM_POS U_FLAG Char (1) NO NO
Relationships
Constraint (relationship) name Relationship type Parent table Child table Card.
WO Parts Grid (WO Parts Grid) Informative WO_PARTS WO_PARTS_GRID_CELL 1:N
Indexes
Index name Columns Unique Descending Clustered
WO_PARTS_GRID_CELL_X1 Work_Order_No, Task_Seq_No, Pts_Seq_No NO 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)


WO_PARTS_SERIALS
Columns
Key Column name Domain Data type Not null Unique Check Default
PK Work_Order_No U_GENERAL_ID Varchar (15) YES NO
PK Task_Seq_No U_INTEGER Numeric (7,0) YES NO
PK Pts_Seq_No U_INTEGER Numeric (7,0) YES NO
PK Serial_No U_ITEM_NO Varchar (30) YES NO
Item_No U_ITEM_NO Varchar (30) NO NO
Inv_Loc U_CODE Varchar (10) NO NO
XFERRED_FROM_POS U_FLAG Char (1) NO NO
Relationships
Constraint (relationship) name Relationship type Parent table Child table Card.
WO Parts Serials (WO Parts Serials) Informative WO_PARTS WO_PARTS_SERIALS 1:N
Indexes
Index name Columns Unique Descending Clustered
WO_PARTS_SERIALS_X1 Work_Order_No, Task_Seq_No, Pts_Seq_No, Serial_No NO 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)


WO_PMNT
Columns
Key Column name Domain Data type Not null Unique Check Default
PK Work_Order_No U_GENERAL_ID Varchar (15) YES NO
PK Seq_No U_INTEGER Numeric (7,0) YES NO
Pay_Code U_CODE Varchar (10) NO NO
Amount U_PRICE Decimal (15,4) NO NO
Description U_DESC Varchar (30) NO NO
Reference_1 U_EMAIL_ADRS Varchar (50) NO NO
Reference_2 U_EMAIL_ADRS Varchar (50) NO NO
Reference_3 U_EMAIL_ADRS Varchar (50) NO NO
Relationships
Constraint (relationship) name Relationship type Parent table Child table Card.
WO_PMNT_FK (WO Payment) Informative WORK_ORDER WO_PMNT 1:N
Indexes
Index name Columns Unique Descending Clustered
WO_PMNT_X1 Work_Order_No, Seq_No NO 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)


WO_TASK
Columns
Key Column name Domain Data type Not null Unique Check Default
PK Work_Order_No U_GENERAL_ID Varchar (15) YES NO
PK Task_Seq_No U_INTEGER Numeric (7,0) YES NO
Name U_NAME Varchar (40) NO NO
Model U_DESC Varchar (30) NO NO
Serial_No U_DESC Varchar (30) NO NO
Description U_DESC Varchar (30) NO NO
Description_2 U_DESC Varchar (30) NO NO
WORK_CAT U_CODE Varchar (10) NO NO
LOCATION U_UDEF Varchar (100) NO NO
INVOICING_CODE U_CODE Varchar (10) NO NO
CONTRACT_NO U_GENERAL_ID Varchar (15) NO NO
PROBLEM U_CODE Varchar (10) NO NO
IS_REPAIR U_FLAG Char (1) NO NO
IS_PM U_FLAG Char (1) NO NO
ESTIMATED_TTR U_QTY Numeric (7,2) NO NO
TASK_STATUS U_FLAG Char (1) NO NO
SPLIT_BILL_SEL_FLG U_FLAG Char (1) NO NO
ESTIMATED_COMPL_DATE U_DATE Datetime NO NO
Relationships
Constraint (relationship) name Relationship type Parent table Child table Card.
WO_TASK_FK (WO Task) Informative WORK_ORDER WO_TASK 1:N
WO Task Addl Chg (WO Task Addl Chg) Identifying WO_TASK WO_ADDL_CHG 1:N
WO Task Parts (WO Task Parts) Identifying WO_TASK WO_PARTS 1:N
WO Task Labor (WO Task Labor) Identifying WO_TASK WO_LABOR 1:N
WO Task Notes (WO Task Notes) Informative WO_TASK WO_TASK_NOTES 1:N
Indexes
Index name Columns Unique Descending Clustered
WO_TASK_X1 Work_Order_No, Task_Seq_No NO 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)


WO_TASK_NOTES
Columns
Key Column name Domain Data type Not null Unique Check Default
PK Work_Order_No U_GENERAL_ID Varchar (15) YES NO
PK Task_Seq_No U_INTEGER Numeric (7,0) YES NO
PK Note_ID U_NOTE_ID Varchar (20) YES NO
Description U_DESC Varchar (30) NO NO
NOTE_TEXT U_NOTE Text NO NO
RAW_TEXT U_NOTE Text NO NO
LAST_MAINT_DATE U_DATE Datetime NO NO
PRT_ON_WO U_FLAG Char (1) NO NO
PRT_ON_INVOICE U_FLAG Char (1) NO NO
Relationships
Constraint (relationship) name Relationship type Parent table Child table Card.
WO Task Notes (WO Task Notes) Informative WO_TASK WO_TASK_NOTES 1:N
Indexes
Index name Columns Unique Descending Clustered
WO_TASK_NOTES_X1 Work_Order_No, Task_Seq_No, Note_ID NO 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)


WO_TAX
Columns
Key Column name Domain Data type Not null Unique Check Default
PFK Work_Order_No U_GENERAL_ID Varchar (15) YES NO
PK Seq_No U_INTEGER Numeric (7,0) YES NO
TAX_CODE U_GENERAL_ID Varchar (15) NO NO
AUTH_CODE U_GENERAL_ID Varchar (15) NO NO
AUTH_RULE_CODE U_GENERAL_ID Varchar (15) NO NO
Amount U_PRICE Decimal (15,4) NO NO
TAX_ACCOUNT_NO U_GL_ACCT_NO Varchar (20) NO NO
Relationships
Constraint (relationship) name Relationship type Parent table Child table Card.
WO Tax (WO Tax) Identifying WORK_ORDER WO_TAX 1:N
Indexes
Index name Columns Unique Descending Clustered
WO_TAX_X1 Work_Order_No, Seq_No NO 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)


WORK_CAT
Columns
Key Column name Domain Data type Not null Unique Check Default
PK Code U_CODE Varchar (10) YES YES
Description U_DESC Varchar (30) 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)


WORK_ORDER
Columns
Key Column name Domain Data type Not null Unique Check Default
PK Work_Order_No U_GENERAL_ID Varchar (15) YES NO
Customer U_GENERAL_ID Varchar (15) NO NO
Address_ID U_GENERAL_ID Varchar (15) NO NO
Status U_CODE Varchar (10) NO NO
OPEN_DATE U_DATE Datetime NO NO
OPEN_TIME U_DATE Datetime NO NO
SVC_SITE_NAME U_NAME Varchar (40) NO NO
SVC_ADDR_1 U_NAME Varchar (40) NO NO
SVC_ADDR_2 U_NAME Varchar (40) NO NO
SVC_CITY U_DESC Varchar (30) NO NO
SVC_STATE U_CODE Varchar (10) NO NO
SVC_ZIP_CODE U_GENERAL_ID Varchar (15) NO NO
SVC_COUNTRY U_DESC Varchar (30) NO NO
CONTACT_1_NAME U_NAME Varchar (40) NO NO
CONTACT_1_PHONE U_LONG_CODE Varchar (25) NO NO
PO_NO U_LONG_CODE Varchar (25) NO NO
MAP_GRID U_DESC Varchar (30) NO NO
PRIORITY U_CODE Varchar (10) NO NO
DISPATCH_NOTE U_UDEF Varchar (100) NO NO
USR_DEFINED_1 U_UDEF Varchar (100) NO NO
USR_DEFINED_2 U_UDEF Varchar (100) NO NO
USR_DEFINED_3 U_UDEF Varchar (100) NO NO
USR_DEFINED_4 U_UDEF Varchar (100) NO NO
TAX_CODE U_GENERAL_ID Varchar (15) NO NO
INVOICE_NO U_INTEGER Numeric (7,0) NO NO
INVOICE_DATE U_DATE Datetime NO NO
INVOICE_PRINT_STAT U_FLAG Char (1) NO NO
INVOICE_POST_STAT U_FLAG Char (1) NO NO
DISC_PCT U_QTY Numeric (7,2) NO NO
TOTAL_SALES U_PRICE Decimal (15,4) NO NO
TOTAL_TXBL_SALES U_PRICE Decimal (15,4) NO NO
FLAT_CHG_HOURS U_QTY Numeric (7,2) NO NO
BILL_GROUP U_CODE Varchar (10) NO NO
POST_TO_CUSTOMER U_GENERAL_ID Varchar (15) NO NO
ZONE U_CODE Varchar (10) NO NO
SALES_REP U_GENERAL_ID Varchar (15) NO NO
COMMISSION_AMT U_PRICE Decimal (15,4) NO NO
TERMS_CODE U_LONG_CODE Varchar (25) NO NO
SEL_FOR_BILLING_FLG U_FLAG Char (1) NO NO
SPLIT_BILL_SEQ_NO U_INTEGER Numeric (7,0) NO NO
SPLIT_BILL_SEL_FLG U_FLAG Char (1) NO NO
TOT_TAX_AMT U_PRICE Decimal (15,4) NO NO
TOT_PAYMENTS U_PRICE Decimal (15,4) NO NO
XFER_TO_TKT_NO U_GENERAL_ID Varchar (15) NO NO
DEPARTMENT U_LONG_CODE Varchar (25) NO NO
POS_STORE U_CODE Varchar (10) NO NO
POS_DRAWER U_CODE Varchar (10) NO NO
ENTRY_USER U_CODE Varchar (10) NO NO
ENTRY_DATE U_DATE Datetime NO NO
LAST_MAINT_USER U_CODE Varchar (10) NO NO
LAST_MAINT_DATE U_DATE Datetime NO NO
Relationships
Constraint (relationship) name Relationship type Parent table Child table Card.
WO_PMNT_FK (WO Payment) Informative WORK_ORDER WO_PMNT 1:N
WO_TASK_FK (WO Task) Informative WORK_ORDER WO_TASK 1:N
WO_NOTES_FK (WO Notes) Informative WORK_ORDER WO_NOTES 1:N
WO Tax (WO Tax) Identifying WORK_ORDER WO_TAX 1:N
Indexes
Index name Columns Unique Descending Clustered
WORK_ORDER_X1 Work_Order_No YES NO NO
WORK_ORDER_X2 Customer, Work_Order_No YES 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)