U_CODE
General info
Data type VarChar (10)
User-defined variables
Name Value
Null type 'NULL' No
Owner
Default object
Rule object
Used in
Table name Column name
TECH_CAT Code
CONTRACT_CAT Code
REFERRAL_SOURCE Code
WORK_CAT Code
PM_SCHED Schedule_ID
WARRANTY Warranty_ID
WARRANTY INVC_CODE_1
WARRANTY INVC_CODE_2
WARRANTY INVC_CODE_3
WARRANTY INVC_CODE_4
WARRANTY INVC_CODE_5
WARRANTY INVC_CODE_6
PRIORITY_CODE Code
PRIORITY_CODE FORE_COLOR
PRIORITY_CODE BACK_COLOR
WO_PMNT Pay_Code
HISTORY_WO_PMNT Pay_Code
EQP_MODEL CATEGORY
EQP_MODEL SUB_CATEGORY
EQP_MODEL DFLT_WARR
EQP_MODEL DFLT_PM_SCHED
EQP_MODEL DFLT_WORK_CAT
EQP_MODEL METER1_DFLT_UCODE
EQP_MODEL METER2_DFLT_UCODE
EQP_MODEL METER3_DFLT_UCODE
EQP_MODEL METER4_DFLT_UCODE
EQP_MODEL METER5_DFLT_UCODE
PREDEF_JOB_LABOR Tech_ID
PREDEF_JOB_TASK WORK_CAT
PREDEF_JOB_TASK INVOICING_CODE
PREDEF_JOB_TASK PROBLEM
PREDEF_JOB_PARTS Inv_Loc
CUST_EQUIPMENT_METERS METER1_USAGE_CODE
CUST_EQUIPMENT_METERS METER2_USAGE_CODE
CUST_EQUIPMENT_METERS METER3_USAGE_CODE
CUST_EQUIPMENT_METERS METER4_USAGE_CODE
CUST_EQUIPMENT_METERS METER5_USAGE_CODE
WORK_ORDER Status
WORK_ORDER SVC_STATE
WORK_ORDER PRIORITY
WORK_ORDER BILL_GROUP
WORK_ORDER ZONE
WORK_ORDER POS_STORE
WORK_ORDER POS_DRAWER
WORK_ORDER ENTRY_USER
WORK_ORDER LAST_MAINT_USER
HISTORY_WORK_ORDER Status
HISTORY_WORK_ORDER SVC_STATE
HISTORY_WORK_ORDER PRIORITY
HISTORY_WORK_ORDER BILL_GROUP
HISTORY_WORK_ORDER ZONE
HISTORY_WORK_ORDER POS_STORE
HISTORY_WORK_ORDER POS_DRAWER
HISTORY_WORK_ORDER ENTRY_USER
HISTORY_WORK_ORDER LAST_MAINT_USER
WO_PARTS Inv_Loc
HISTORY_WO_LABOR Tech_ID
HISTORY_WO_PARTS_SERIALS Inv_Loc
HISTORY_WO_PARTS Inv_Loc
WO_PARTS_SERIALS Inv_Loc
SVC_ADDRESS STATE
SVC_ADDRESS REFERRAL_SOURCE
SVC_ADDRESS ZONE
SVC_ADDRESS SVC_TECH
SVC_ADDRESS INVOICING_CODE
SVC_TECH Tech_ID
SVC_TECH DFLT_PTS_LOC
SVC_TECH CATEGORY_1
SVC_TECH CATEGORY_2
SVC_TECH CATEGORY_3
SVC_TECH CATEGORY_4
SVC_TECH CATEGORY_5
PROBLEM_CODE Code
PROBLEM_CODE DFLT_TECH
USAGE_CODE Code
SP_USER User_ID
INVOICING_CODE Code
INVOICING_CODE PARTS_PRICING_GROUP
HISTORY_WO_PARTS_GRID_CELL Inv_Loc
WO_PARTS_GRID_CELL Inv_Loc
STATUS_CODE Code
WO_TASK WORK_CAT
WO_TASK INVOICING_CODE
WO_TASK PROBLEM
HISTORY_WO_TASK WORK_CAT
HISTORY_WO_TASK INVOICING_CODE
HISTORY_WO_TASK PROBLEM
CONTROL_INFO CTL_KEY
CONTROL_INFO DFLT_INVC_CODE
CONTROL_INFO DFLT_LOGGED_STATUS
CONTROL_INFO DFLT_SCHED_STATUS
CONTROL_INFO DFLT_DISP_STATUS
CONTROL_INFO DFLT_COMPL_STATUS
CONTROL_INFO POS_STORE
CONTROL_INFO POS_DRAWER
CONTROL_INFO SP_DB_VERSION
CONTROL_INFO DFLT_PROBLEM_CODE
WO_LABOR Tech_ID
CUST_EQUIPMENT WARRANTY
CUST_EQUIPMENT PM_SCHEDULE
CUST_EQUIPMENT WORK_CAT
CUST_EQUIPMENT WO_INVC_CODE
HISTORY_CUST_EQUIPMENT WARRANTY
HISTORY_CUST_EQUIPMENT PM_SCHEDULE
HISTORY_CUST_EQUIPMENT WORK_CAT
HISTORY_CUST_EQUIPMENT WO_INVC_CODE
CONTRACT Category
HISTORY_CONTRACT Category


U_COST
General info
Data type Decimal (15,4)
User-defined variables
Name Value
Null type 'NULL' No
Owner
Default object
Rule object
Used in
Table name Column name
WO_ADDL_CHG Cost
PREDEF_JOB_ADDL_CHG Cost
PREDEF_JOB_PARTS Unit_Cost
WO_PARTS Unit_Cost
HISTORY_WO_LABOR HOURLY_COST
HISTORY_WO_PARTS Unit_Cost
HISTORY_WO_ADDL_CHG Cost
SVC_TECH STD_COST
SVC_TECH OT_COST
SVC_TECH SPEC_COST
WO_LABOR HOURLY_COST
CUST_EQUIPMENT CONTRACT_COST_AMT
HISTORY_CUST_EQUIPMENT CONTRACT_COST_AMT


U_DATE
General info
Data type DateTime
User-defined variables
Name Value
Null type 'NULL' No
Owner
Default object
Rule object
Used in
Table name Column name
PM_SCHED DATE_01
PM_SCHED DATE_02
PM_SCHED DATE_03
PM_SCHED DATE_04
PM_SCHED DATE_05
PM_SCHED DATE_06
PM_SCHED DATE_07
PM_SCHED DATE_08
PM_SCHED DATE_09
PM_SCHED DATE_10
PM_SCHED DATE_11
PM_SCHED DATE_12
PM_SCHED DATE_13
PM_SCHED DATE_14
PM_SCHED DATE_15
PM_SCHED DATE_16
PM_SCHED DATE_17
PM_SCHED DATE_18
PM_SCHED DATE_19
PM_SCHED DATE_20
PM_SCHED DATE_21
PM_SCHED DATE_22
PM_SCHED DATE_23
PM_SCHED DATE_24
PM_SCHED DATE_25
PM_SCHED DATE_26
PM_SCHED DATE_27
PM_SCHED DATE_28
PM_SCHED DATE_29
PM_SCHED DATE_30
CONTRACT_NOTES LAST_MAINT_DATE
HISTORY_CONTRACT_NOTES LAST_MAINT_DATE
SVC_ADDRESS_NOTES LAST_MAINT_DATE
WO_NOTES LAST_MAINT_DATE
WO_LABOR_NOTES LAST_MAINT_DATE
HISTORY_WO_NOTES LAST_MAINT_DATE
SETUP_NOTES LAST_MAINT_DATE
CUST_EQUIPMENT_NOTES LAST_MAINT_DATE
WO_TASK_NOTES LAST_MAINT_DATE
PREDEF_JOB_LABOR Date_For_Sched
PREDEF_JOB_LABOR Time_For_Sched
PREDEF_JOB_LABOR_NOTES LAST_MAINT_DATE
PREDEF_JOB_NOTES LAST_MAINT_DATE
PREDEF_JOB_TASK_NOTES LAST_MAINT_DATE
CUST_EQUIPMENT_METERS METER1_LAST_READ_DATE
CUST_EQUIPMENT_METERS METER2_LAST_READ_DATE
CUST_EQUIPMENT_METERS METER3_LAST_READ_DATE
CUST_EQUIPMENT_METERS METER4_LAST_READ_DATE
CUST_EQUIPMENT_METERS METER5_LAST_READ_DATE
WORK_ORDER OPEN_DATE
WORK_ORDER OPEN_TIME
WORK_ORDER INVOICE_DATE
WORK_ORDER ENTRY_DATE
WORK_ORDER LAST_MAINT_DATE
HISTORY_METER_READINGS READING_DATE
METER_READINGS READING_DATE
HISTORY_WORK_ORDER OPEN_DATE
HISTORY_WORK_ORDER OPEN_TIME
HISTORY_WORK_ORDER INVOICE_DATE
HISTORY_WORK_ORDER ENTRY_DATE
HISTORY_WORK_ORDER LAST_MAINT_DATE
HISTORY_WORK_ORDER CR_MEMO_DATE
PREDEF_NOTES LAST_MAINT_DATE
HISTORY_WO_LABOR_NOTES LAST_MAINT_DATE
HISTORY_WO_LABOR SCHED_DATE
HISTORY_WO_LABOR SCHED_TIME
HISTORY_WO_LABOR DISP_DATE
HISTORY_WO_LABOR DISP_TIME
HISTORY_WO_LABOR START_DATE
HISTORY_WO_LABOR START_TIME
HISTORY_WO_LABOR STOP_DATE
HISTORY_WO_LABOR STOP_TIME
HISTORY_WO_LABOR RETURN_DATE
HISTORY_WO_LABOR RETURN_TIME
HISTORY_WO_LABOR Date_For_Sched
HISTORY_WO_LABOR Time_For_Sched
HISTORY_WO_TASK_NOTES LAST_MAINT_DATE
SP_USER DATE_PWD_CHGD
WO_TASK ESTIMATED_COMPL_DATE
HISTORY_WO_TASK ESTIMATED_COMPL_DATE
CONTROL_INFO REQUESTED_SCHED_DATE
WO_LABOR SCHED_DATE
WO_LABOR SCHED_TIME
WO_LABOR DISP_DATE
WO_LABOR DISP_TIME
WO_LABOR START_DATE
WO_LABOR START_TIME
WO_LABOR STOP_DATE
WO_LABOR STOP_TIME
WO_LABOR RETURN_DATE
WO_LABOR RETURN_TIME
WO_LABOR Date_For_Sched
WO_LABOR Time_For_Sched
CUST_EQUIPMENT INSTALL_DATE
CUST_EQUIPMENT WARRANTY_START
CUST_EQUIPMENT LAST_REPAIR
CUST_EQUIPMENT LAST_PM
CUST_EQUIPMENT NEXT_PM
CUST_EQUIPMENT LAST_AUTO_PM_DATE
CUST_EQUIPMENT PM_DUE_RPT_NEXT_DATE
CUST_EQUIPMENT PM_DUE_RPT_EARLY_DATE
CUST_EQUIPMENT PM_DUE_RPT_LATE_DATE
CUST_EQUIPMENT REMOVAL_DATE
HISTORY_CUST_EQUIPMENT INSTALL_DATE
HISTORY_CUST_EQUIPMENT WARRANTY_START
HISTORY_CUST_EQUIPMENT LAST_REPAIR
HISTORY_CUST_EQUIPMENT LAST_PM
HISTORY_CUST_EQUIPMENT NEXT_PM
HISTORY_CUST_EQUIPMENT LAST_AUTO_PM_DATE
HISTORY_CUST_EQUIPMENT REMOVAL_DATE
CONTRACT ORIGINAL_DATE
CONTRACT Start_Date
CONTRACT End_Date
CONTRACT Last_Invoice_Date
CONTRACT Next_Invoice_Date
CONTRACT INVOICE_DATE
CONTRACT PREV_START_DATE
CONTRACT PREV_END_DATE
HISTORY_CONTRACT ORIGINAL_DATE
HISTORY_CONTRACT Start_Date
HISTORY_CONTRACT End_Date
HISTORY_CONTRACT Last_Invoice_Date
HISTORY_CONTRACT Next_Invoice_Date
HISTORY_CONTRACT INVOICE_DATE
HISTORY_CONTRACT PREV_START_DATE
HISTORY_CONTRACT PREV_END_DATE


U_DESC
General info
Data type VarChar (30)
User-defined variables
Name Value
Null type 'NULL' No
Owner
Default object
Rule object
Used in
Table name Column name
TECH_CAT Description
CONTRACT_CAT Description
REFERRAL_SOURCE Description
WORK_CAT Description
PM_SCHED Description
WARRANTY Description
PRIORITY_CODE Description
WO_PMNT Description
HISTORY_WO_PMNT Description
CONTRACT_NOTES Description
HISTORY_CONTRACT_NOTES Description
SVC_ADDRESS_NOTES Description
WO_NOTES Description
WO_LABOR_NOTES Description
HISTORY_WO_NOTES Description
SETUP_NOTES Description
CUST_EQUIPMENT_NOTES Serial_No
CUST_EQUIPMENT_NOTES Description
EQP_MODEL Description
EQP_MODEL Description_2
EQP_MODEL MANUFACTURER
EQP_MODEL METER1_NAME
EQP_MODEL METER2_NAME
EQP_MODEL METER3_NAME
EQP_MODEL METER4_NAME
EQP_MODEL METER5_NAME
EQP_MODEL PROFILE1_DESC
EQP_MODEL PROFILE2_DESC
EQP_MODEL PROFILE3_DESC
EQP_MODEL PROFILE4_DESC
EQP_MODEL PROFILE5_DESC
EQP_MODEL PROFILE6_DESC
EQP_MODEL PROFILE7_DESC
EQP_MODEL PROFILE8_DESC
EQP_MODEL PROFILE9_DESC
EQP_MODEL PROFILE10_DESC
WO_TASK_NOTES Description
PREDEF_JOB_LABOR_NOTES Description
PREDEF_JOB_NOTES Description
PREDEF_JOB_TASK Model
PREDEF_JOB_TASK Serial_No
PREDEF_JOB_TASK Description
PREDEF_JOB_TASK Description_2
PREDEF_JOB_TASK_NOTES Description
CUST_EQUIPMENT_METERS Serial_No
WORK_ORDER SVC_CITY
WORK_ORDER SVC_COUNTRY
WORK_ORDER MAP_GRID
HISTORY_METER_READINGS Serial_No
METER_READINGS Serial_No
HISTORY_WORK_ORDER SVC_CITY
HISTORY_WORK_ORDER SVC_COUNTRY
HISTORY_WORK_ORDER MAP_GRID
HISTORY_CONTRACT_TAX Serial_No
CONTRACT_TAX Serial_No
PREDEF_NOTES NOTE_SAMPLE
HISTORY_WO_LABOR_NOTES Description
HISTORY_WO_TASK_NOTES Description
SVC_ADDRESS CITY
SVC_ADDRESS COUNTRY
SVC_ADDRESS MAP_GRID
SVC_TECH Name
PROBLEM_CODE Description
USAGE_CODE Description
SP_USER Name
INVOICING_CODE Description
INVOICING_CODE FLAT_CHG_DESC
INVOICING_CODE TVL_CHG_DESC
INVOICING_CODE ZONE_CHG_DESC
INVOICING_CODE ADDL_CHG_4_DESC
INVOICING_CODE ADDL_CHG_5_DESC
HISTORY_WO_PARTS_GRID_CELL DIM_1_UPPER
HISTORY_WO_PARTS_GRID_CELL DIM_2_UPPER
HISTORY_WO_PARTS_GRID_CELL DIM_3_UPPER
WO_PARTS_GRID_CELL DIM_1_UPPER
WO_PARTS_GRID_CELL DIM_2_UPPER
WO_PARTS_GRID_CELL DIM_3_UPPER
STATUS_CODE Description
STATUS_CODE DFLT_INVC_FORM
STATUS_CODE DFLT_WO_FORM
STATUS_CODE EMAIL_CUST_FORM
STATUS_CODE EMAIL_TECH_FORM
STATUS_CODE EMAIL_THIS_FORM
WO_TASK Model
WO_TASK Serial_No
WO_TASK Description
WO_TASK Description_2
HISTORY_WO_TASK Model
HISTORY_WO_TASK Serial_No
HISTORY_WO_TASK Description
HISTORY_WO_TASK Description_2
CONTROL_INFO DFLT_CALL_INVC_FORM
CONTROL_INFO DFLT_CONTR_INVC_FORM
CONTROL_INFO DFLT_WO_FORM
CONTROL_INFO DFLT_WO_CR_MEMO_FORM
CONTROL_INFO UDEF_1_DESC
CONTROL_INFO UDEF_2_DESC
CONTROL_INFO UDEF_3_DESC
CONTROL_INFO UDEF_4_DESC
PREDEF_JOB Description
CUST_EQUIPMENT Serial_No
CUST_EQUIPMENT Description
CUST_EQUIPMENT Description_2
CUST_EQUIPMENT Tag_ID
CUST_EQUIPMENT MANUFACTURER
HISTORY_CUST_EQUIPMENT Serial_No
HISTORY_CUST_EQUIPMENT Description
HISTORY_CUST_EQUIPMENT Description_2
HISTORY_CUST_EQUIPMENT Tag_ID
HISTORY_CUST_EQUIPMENT MANUFACTURER


U_EMAIL_ADRS
General info
Data type VarChar (50)
User-defined variables
Name Value
Null type 'NULL' No
Owner
Default object
Rule object
Used in
Table name Column name
WO_PMNT Reference_1
WO_PMNT Reference_2
WO_PMNT Reference_3
HISTORY_WO_PMNT Reference_1
HISTORY_WO_PMNT Reference_2
HISTORY_WO_PMNT Reference_3
PREDEF_NOTES Description
SVC_ADDRESS EMAIL_1
SVC_ADDRESS EMAIL_2
SVC_TECH EMAIL_ADRS
STATUS_CODE EMAIL_THIS_ADDR


U_FLAG
General info
Data type Char (1)
User-defined variables
Name Value
Null type 'NULL' No
Owner
Default object
Rule object
Used in
Table name Column name
PM_SCHED TYPE
PM_SCHED INTERVAL_UNIT
PM_SCHED EARLY_WIN_UNIT
PM_SCHED LATE_WIN_UNIT
WARRANTY INTERVAL_UNIT_1
WARRANTY INTERVAL_UNIT_2
WARRANTY INTERVAL_UNIT_3
WARRANTY INTERVAL_UNIT_4
WARRANTY INTERVAL_UNIT_5
WARRANTY INTERVAL_UNIT_6
WO_ADDL_CHG IS_TAXABLE
WO_ADDL_CHG SPLIT_BILL_SEL_FLG
TAX_DEFAULT TAX_PARTS
TAX_DEFAULT TAX_LABOR
TAX_DEFAULT TAX_FLAT_CHG
TAX_DEFAULT TAX_TRAVEL_CHG
TAX_DEFAULT TAX_ZONE_CHG
TAX_DEFAULT TAX_OTHER_ADDL_CHG
TAX_DEFAULT TAX_CONTRACT_CHGS
CONTRACT_NOTES PRT_ON_WO
CONTRACT_NOTES PRT_ON_INVOICE
HISTORY_CONTRACT_NOTES PRT_ON_WO
HISTORY_CONTRACT_NOTES PRT_ON_INVOICE
WO_NOTES PRT_ON_WO
WO_NOTES PRT_ON_INVOICE
WO_LABOR_NOTES PRT_ON_WO
WO_LABOR_NOTES PRT_ON_INVOICE
HISTORY_WO_NOTES PRT_ON_WO
HISTORY_WO_NOTES PRT_ON_INVOICE
SETUP_NOTES CODE_TYPE
EQP_MODEL PROFILE1_USE_FLG
EQP_MODEL PROFILE2_USE_FLG
EQP_MODEL PROFILE3_USE_FLG
EQP_MODEL PROFILE4_USE_FLG
EQP_MODEL PROFILE5_USE_FLG
EQP_MODEL PROFILE6_USE_FLG
EQP_MODEL PROFILE7_USE_FLG
EQP_MODEL PROFILE8_USE_FLG
EQP_MODEL PROFILE9_USE_FLG
EQP_MODEL PROFILE10_USE_FLG
WO_TASK_NOTES PRT_ON_WO
WO_TASK_NOTES PRT_ON_INVOICE
PREDEF_JOB_LABOR TYPE_FLG
PREDEF_JOB_LABOR IS_TAXABLE
PREDEF_JOB_LABOR_NOTES PRT_ON_WO
PREDEF_JOB_LABOR_NOTES PRT_ON_INVOICE
PREDEF_JOB_NOTES PRT_ON_WO
PREDEF_JOB_NOTES PRT_ON_INVOICE
PREDEF_JOB_TASK IS_REPAIR
PREDEF_JOB_TASK IS_PM
PREDEF_JOB_TASK TASK_STATUS
PREDEF_JOB_ADDL_CHG IS_TAXABLE
PREDEF_JOB_PARTS IS_TAXABLE
PREDEF_JOB_TASK_NOTES PRT_ON_WO
PREDEF_JOB_TASK_NOTES PRT_ON_INVOICE
WORK_ORDER INVOICE_PRINT_STAT
WORK_ORDER INVOICE_POST_STAT
WORK_ORDER SEL_FOR_BILLING_FLG
WORK_ORDER SPLIT_BILL_SEL_FLG
HISTORY_METER_READINGS METER1_READING_TYPE
HISTORY_METER_READINGS METER2_READING_TYPE
HISTORY_METER_READINGS METER3_READING_TYPE
HISTORY_METER_READINGS METER4_READING_TYPE
HISTORY_METER_READINGS METER5_READING_TYPE
METER_READINGS METER1_READING_TYPE
METER_READINGS METER2_READING_TYPE
METER_READINGS METER3_READING_TYPE
METER_READINGS METER4_READING_TYPE
METER_READINGS METER5_READING_TYPE
HISTORY_WORK_ORDER INVOICE_PRINT_STAT
HISTORY_WORK_ORDER INVOICE_POST_STAT
HISTORY_WORK_ORDER SEL_FOR_BILLING_FLG
HISTORY_WORK_ORDER SPLIT_BILL_SEL_FLG
HISTORY_WORK_ORDER CR_MEMO_FLG
WO_PARTS IS_TAXABLE
WO_PARTS SPLIT_BILL_SEL_FLG
WO_PARTS PRICING_TYPE_FLG
WO_PARTS XFERRED_FROM_POS
HISTORY_WO_LABOR_NOTES PRT_ON_WO
HISTORY_WO_LABOR_NOTES PRT_ON_INVOICE
HISTORY_WO_LABOR TYPE_FLG
HISTORY_WO_LABOR IS_TAXABLE
HISTORY_WO_LABOR SPLIT_BILL_SEL_FLG
HISTORY_WO_TASK_NOTES PRT_ON_WO
HISTORY_WO_TASK_NOTES PRT_ON_INVOICE
HISTORY_WO_PARTS_SERIALS XFERRED_FROM_POS
HISTORY_WO_PARTS IS_TAXABLE
HISTORY_WO_PARTS SPLIT_BILL_SEL_FLG
HISTORY_WO_PARTS PRICING_TYPE_FLG
HISTORY_WO_PARTS XFERRED_FROM_POS
HISTORY_WO_ADDL_CHG IS_TAXABLE
HISTORY_WO_ADDL_CHG SPLIT_BILL_SEL_FLG
WO_PARTS_SERIALS XFERRED_FROM_POS
SVC_ADDRESS SVC_HOLD_FLG
SVC_TECH TYPE
SVC_TECH INACTIVE_FLG
PROBLEM_CODE PERFORM_PM
PROBLEM_CODE PERFORM_REPAIR
USAGE_CODE Type
SP_USER VIEW_COSTS
SP_USER USER_TYPE
INVOICING_CODE PTS_ACCT_PFT_CTR_SOURCE
INVOICING_CODE LBR_ACCT_PFT_CTR_FROM_ITEM
INVOICING_CODE MISC_ACCT_PFT_CTR_FROM_ITEM
HISTORY_WO_PARTS_GRID_CELL XFERRED_FROM_POS
WO_PARTS_GRID_CELL XFERRED_FROM_POS
STATUS_CODE IS_FROZEN
STATUS_CODE COMMIT_PTS
STATUS_CODE ALLOW_LBR
STATUS_CODE ALLOW_PTS
STATUS_CODE ALLOW_BILL
STATUS_CODE INVOICE_TYPE
STATUS_CODE EMAIL_CHNG_TO_FLG
STATUS_CODE EMAIL_CHNG_FROM_FLG
STATUS_CODE EMAIL_CUST_FLG
STATUS_CODE EMAIL_TECH_FLG
WO_TASK IS_REPAIR
WO_TASK IS_PM
WO_TASK TASK_STATUS
WO_TASK SPLIT_BILL_SEL_FLG
HISTORY_WO_TASK IS_REPAIR
HISTORY_WO_TASK IS_PM
HISTORY_WO_TASK TASK_STATUS
HISTORY_WO_TASK SPLIT_BILL_SEL_FLG
CONTROL_INFO UDEF_1_TYPE
CONTROL_INFO UDEF_2_TYPE
CONTROL_INFO UDEF_3_TYPE
CONTROL_INFO UDEF_4_TYPE
CONTROL_INFO CUST_CONTS_FOR_MAIN
CONTROL_INFO ALLOW_POST_TO
CONTROL_INFO CALL_DEL_PWD_FLG
CONTROL_INFO CRED_OVRD_PWD_FLG
CONTROL_INFO NOTE_DFLT_PRINT_ON_WO
CONTROL_INFO NOTE_DFLT_PRINT_ON_INVOICE
CONTROL_INFO ALLOW_POS_XFER
CONTROL_INFO UPDATE_SYS_HIST
CONTROL_INFO METERS_IN_USE_FLG
CONTROL_INFO SPLIT_BILLING_IN_USE_FLG
CONTROL_INFO DIST_DTL_FLG
CONTROL_INFO SUPPRESS_AUTO_ITEM_LOOKUP_FLG
CONTROL_INFO AUTO_SEL_TEXT_FLG
CONTROL_INFO SCHED_CONFLICT_CHECK_FLG
CONTROL_INFO GP_TRX_TYPE_FLG
CONTROL_INFO ORDER_SCHED_IN_USE_FLG
CONTROL_INFO INVENTORY_OVRD_FLG
WO_LABOR TYPE_FLG
WO_LABOR IS_TAXABLE
WO_LABOR SPLIT_BILL_SEL_FLG
CUST_EQUIPMENT CONTRACT_TAXABLE
CUST_EQUIPMENT BILL_AMT_EACH_OR_TOTAL
CUST_EQUIPMENT PM_DUE_RPT_INCL_FLG
HISTORY_CUST_EQUIPMENT CONTRACT_TAXABLE
HISTORY_CUST_EQUIPMENT BILL_AMT_EACH_OR_TOTAL
CONTRACT Cycle_Unit
CONTRACT Renewal_Type
CONTRACT Sel_For_Billing_Flg
CONTRACT Invoice_Print_Stat
CONTRACT INVOICE_POST_STAT
CONTRACT PAID_IN_FULL_FLG
CONTRACT PRORATE_1ST_BILL_FLG
HISTORY_CONTRACT Cycle_Unit
HISTORY_CONTRACT Renewal_Type
HISTORY_CONTRACT Sel_For_Billing_Flg
HISTORY_CONTRACT Invoice_Print_Stat
HISTORY_CONTRACT INVOICE_POST_STAT
HISTORY_CONTRACT PAID_IN_FULL_FLG
HISTORY_CONTRACT PRORATE_1ST_BILL_FLG


U_GENERAL_ID
General info
Data type VarChar (15)
User-defined variables
Name Value
Null type 'NULL' No
Owner
Default object
Rule object
Used in
Table name Column name
WO_PMNT Work_Order_No
WO_ADDL_CHG Work_Order_No
HISTORY_WO_PMNT Work_Order_No
TAX_DEFAULT Tax_Code
WO_TAX Work_Order_No
WO_TAX TAX_CODE
WO_TAX AUTH_CODE
WO_TAX AUTH_RULE_CODE
HISTORY_WO_TAX Work_Order_No
HISTORY_WO_TAX TAX_CODE
HISTORY_WO_TAX AUTH_CODE
HISTORY_WO_TAX AUTH_RULE_CODE
CONTRACT_NOTES Contract_No
HISTORY_CONTRACT_NOTES Contract_No
SVC_ADDRESS_NOTES Customer
SVC_ADDRESS_NOTES Address_ID
WO_NOTES Work_Order_No
WO_LABOR_NOTES Work_Order_No
HISTORY_WO_NOTES Work_Order_No
CUST_EQUIPMENT_NOTES Customer
CUST_EQUIPMENT_NOTES Address_ID
WO_TASK_NOTES Work_Order_No
PREDEF_JOB_LABOR Job_ID
PREDEF_JOB_LABOR_NOTES Job_ID
PREDEF_JOB_NOTES Job_ID
PREDEF_JOB_TASK Job_ID
PREDEF_JOB_TASK CONTRACT_NO
PREDEF_JOB_ADDL_CHG Job_ID
PREDEF_JOB_PARTS Job_ID
PREDEF_JOB_TASK_NOTES Job_ID
CUST_EQUIPMENT_METERS Customer
CUST_EQUIPMENT_METERS Address_ID
WORK_ORDER Work_Order_No
WORK_ORDER Customer
WORK_ORDER Address_ID
WORK_ORDER SVC_ZIP_CODE
WORK_ORDER TAX_CODE
WORK_ORDER POST_TO_CUSTOMER
WORK_ORDER SALES_REP
WORK_ORDER XFER_TO_TKT_NO
HISTORY_METER_READINGS Customer
HISTORY_METER_READINGS Address_ID
HISTORY_METER_READINGS WORK_ORDER_NO
METER_READINGS Customer
METER_READINGS Address_ID
METER_READINGS WORK_ORDER_NO
HISTORY_WORK_ORDER Work_Order_No
HISTORY_WORK_ORDER Customer
HISTORY_WORK_ORDER Address_ID
HISTORY_WORK_ORDER SVC_ZIP_CODE
HISTORY_WORK_ORDER TAX_CODE
HISTORY_WORK_ORDER POST_TO_CUSTOMER
HISTORY_WORK_ORDER SALES_REP
HISTORY_WORK_ORDER XFER_TO_TKT_NO
HISTORY_WORK_ORDER POSTING_EVENT_NO
HISTORY_CONTRACT_TAX Contract_No
HISTORY_CONTRACT_TAX Customer
HISTORY_CONTRACT_TAX Address_ID
HISTORY_CONTRACT_TAX TAX_CODE
HISTORY_CONTRACT_TAX AUTH_CODE
HISTORY_CONTRACT_TAX AUTH_RULE_CODE
CONTRACT_TAX Contract_No
CONTRACT_TAX Customer
CONTRACT_TAX Address_ID
CONTRACT_TAX TAX_CODE
CONTRACT_TAX AUTH_CODE
CONTRACT_TAX AUTH_RULE_CODE
WO_PARTS Work_Order_No
HISTORY_WO_LABOR_NOTES Work_Order_No
HISTORY_WO_LABOR Work_Order_No
HISTORY_WO_TASK_NOTES Work_Order_No
HISTORY_WO_PARTS_SERIALS Work_Order_No
HISTORY_WO_PARTS Work_Order_No
HISTORY_WO_ADDL_CHG Work_Order_No
WO_PARTS_SERIALS Work_Order_No
SVC_ADDRESS Customer
SVC_ADDRESS Address_ID
SVC_ADDRESS ZIP_CODE
SVC_ADDRESS MAIL_TO_CUST
SVC_ADDRESS TAX_CODE
HISTORY_WO_PARTS_GRID_CELL Work_Order_No
WO_PARTS_GRID_CELL Work_Order_No
WO_TASK Work_Order_No
WO_TASK CONTRACT_NO
HISTORY_WO_TASK Work_Order_No
HISTORY_WO_TASK CONTRACT_NO
CONTROL_INFO NXT_CALL_NO
CONTROL_INFO NXT_CONTR_NO
CONTROL_INFO CALL_DEL_PWD
CONTROL_INFO CRED_OVRD_PWD
WO_LABOR Work_Order_No
PREDEF_JOB Job_ID
CUST_EQUIPMENT Customer
CUST_EQUIPMENT Address_ID
CUST_EQUIPMENT CONTRACT_NO
CUST_EQUIPMENT CATEGORY
CUST_EQUIPMENT SUB_CATEGORY
CUST_EQUIPMENT IMPORTED_FROM_TKT_NO
HISTORY_CUST_EQUIPMENT Customer
HISTORY_CUST_EQUIPMENT Contract_No
HISTORY_CUST_EQUIPMENT Address_ID
HISTORY_CUST_EQUIPMENT CATEGORY
HISTORY_CUST_EQUIPMENT SUB_CATEGORY
HISTORY_CUST_EQUIPMENT IMPORTED_FROM_TKT_NO
CONTRACT Contract_No
CONTRACT Customer
CONTRACT TAX_CODE
CONTRACT POST_TO_CUSTOMER
CONTRACT SALES_REP
HISTORY_CONTRACT Contract_No
HISTORY_CONTRACT Customer
HISTORY_CONTRACT TAX_CODE
HISTORY_CONTRACT POST_TO_CUSTOMER
HISTORY_CONTRACT SALES_REP
HISTORY_CONTRACT POSTING_EVENT_NO


U_GL_ACCT_NO
General info
Data type VarChar (20)
User-defined variables
Name Value
Null type 'NULL' No
Owner
Default object
Rule object
Used in
Table name Column name
WO_ADDL_CHG Sales_Acct_No
WO_ADDL_CHG Cost_Acct_No
WO_TAX TAX_ACCOUNT_NO
HISTORY_WO_TAX TAX_ACCOUNT_NO
PREDEF_JOB_ADDL_CHG Sales_Acct_No
PREDEF_JOB_ADDL_CHG Cost_Acct_No
PREDEF_JOB_PARTS SALES_ACCT_NO
HISTORY_CONTRACT_TAX TAX_ACCOUNT_NO
CONTRACT_TAX TAX_ACCOUNT_NO
WO_PARTS SALES_ACCT_NO
HISTORY_WO_LABOR SALES_ACCT_NO
HISTORY_WO_PARTS SALES_ACCT_NO
HISTORY_WO_ADDL_CHG Sales_Acct_No
HISTORY_WO_ADDL_CHG Cost_Acct_No
INVOICING_CODE ACCT_LBR_REG
INVOICING_CODE ACCT_LBR_OT
INVOICING_CODE ACCT_LBR_SPEC
INVOICING_CODE ACCT_PTS_REG
INVOICING_CODE ACCT_PTS_OT
INVOICING_CODE ACCT_PTS_SPEC
INVOICING_CODE ACCT_FLAT_REG
INVOICING_CODE ACCT_FLAT_OT
INVOICING_CODE ACCT_FLAT_SPEC
INVOICING_CODE ACCT_TVL_REG
INVOICING_CODE ACCT_TVL_OT
INVOICING_CODE ACCT_TVL_SPEC
INVOICING_CODE ACCT_ZONE_REG
INVOICING_CODE ACCT_ZONE_OT
INVOICING_CODE ACCT_ZONE_SPEC
INVOICING_CODE ACCT_ADDL_4_REG
INVOICING_CODE ACCT_ADDL_4_OT
INVOICING_CODE ACCT_ADDL_4_SPEC
INVOICING_CODE ACCT_ADDL_5_REG
INVOICING_CODE ACCT_ADDL_5_OT
INVOICING_CODE ACCT_ADDL_5_SPEC
INVOICING_CODE ACCT_DISC_REG
INVOICING_CODE ACCT_DISC_OT
INVOICING_CODE ACCT_DISC_SPEC
INVOICING_CODE PTS_ACCT_INVC_CODE_PFT_CTR
CONTROL_INFO CONTRACT_EQP_COST_OFFSET_ACCT
WO_LABOR SALES_ACCT_NO
CUST_EQUIPMENT CONTRACT_SALES_ACCT
CUST_EQUIPMENT CONTRACT_COST_ACCT
HISTORY_CUST_EQUIPMENT CONTRACT_SALES_ACCT
HISTORY_CUST_EQUIPMENT CONTRACT_COST_ACCT
CONTRACT SALES_ACCOUNT_NUMBER
HISTORY_CONTRACT SALES_ACCOUNT_NUMBER


U_INTEGER
General info
Data type Numeric (7,0)
User-defined variables
Name Value
Null type 'NULL' No
Owner
Default object
Rule object
Used in
Table name Column name
PM_SCHED INTERVAL_QTY
PM_SCHED EARLY_WIN_QTY
PM_SCHED LATE_WIN_QTY
WARRANTY INTERVAL_QTY_1
WARRANTY INTERVAL_QTY_2
WARRANTY INTERVAL_QTY_3
WARRANTY INTERVAL_QTY_4
WARRANTY INTERVAL_QTY_5
WARRANTY INTERVAL_QTY_6
WO_PMNT Seq_No
WO_ADDL_CHG Task_Seq_No
WO_ADDL_CHG Addl_Chg_Seq_No
HISTORY_WO_PMNT Work_Order_Seq_No
HISTORY_WO_PMNT Seq_No
WO_TAX Seq_No
HISTORY_WO_TAX Work_Order_Seq_No
HISTORY_WO_TAX Seq_No
HISTORY_CONTRACT_NOTES Contract_Seq_No
WO_LABOR_NOTES Task_Seq_No
WO_LABOR_NOTES Lbr_Seq_No
HISTORY_WO_NOTES Work_Order_Seq_No
WO_TASK_NOTES Task_Seq_No
PREDEF_JOB_LABOR Task_Seq_No
PREDEF_JOB_LABOR Lbr_Seq_No
PREDEF_JOB_LABOR_NOTES Task_Seq_No
PREDEF_JOB_LABOR_NOTES Lbr_Seq_No
PREDEF_JOB_TASK Task_Seq_No
PREDEF_JOB_ADDL_CHG Task_Seq_No
PREDEF_JOB_ADDL_CHG Addl_Chg_Seq_No
PREDEF_JOB_PARTS Task_Seq_No
PREDEF_JOB_PARTS Pts_Seq_No
PREDEF_JOB_TASK_NOTES Task_Seq_No
WORK_ORDER INVOICE_NO
WORK_ORDER SPLIT_BILL_SEQ_NO
HISTORY_METER_READINGS SEQ_NO
HISTORY_WORK_ORDER Work_Order_Seq_No
HISTORY_WORK_ORDER INVOICE_NO
HISTORY_WORK_ORDER SPLIT_BILL_SEQ_NO
HISTORY_WORK_ORDER CR_MEMO_NO
HISTORY_CONTRACT_TAX Contract_Seq_No
HISTORY_CONTRACT_TAX Seq_No
CONTRACT_TAX Seq_No
WO_PARTS Task_Seq_No
WO_PARTS Pts_Seq_No
HISTORY_WO_LABOR_NOTES Work_Order_Seq_No
HISTORY_WO_LABOR_NOTES Task_Seq_No
HISTORY_WO_LABOR_NOTES Lbr_Seq_No
HISTORY_WO_LABOR Work_Order_Seq_No
HISTORY_WO_LABOR Task_Seq_No
HISTORY_WO_LABOR Lbr_Seq_No
HISTORY_WO_TASK_NOTES Work_Order_Seq_No
HISTORY_WO_TASK_NOTES Task_Seq_No
HISTORY_WO_PARTS_SERIALS Work_Order_Seq_No
HISTORY_WO_PARTS_SERIALS Task_Seq_No
HISTORY_WO_PARTS_SERIALS Pts_Seq_No
HISTORY_WO_PARTS Work_Order_Seq_No
HISTORY_WO_PARTS Task_Seq_No
HISTORY_WO_PARTS Pts_Seq_No
HISTORY_WO_ADDL_CHG Work_Order_Seq_No
HISTORY_WO_ADDL_CHG Task_Seq_No
HISTORY_WO_ADDL_CHG Addl_Chg_Seq_No
WO_PARTS_SERIALS Task_Seq_No
WO_PARTS_SERIALS Pts_Seq_No
INVOICING_CODE PTS_ACCT_PFT_CTR_SEGMENT
HISTORY_WO_PARTS_GRID_CELL Work_Order_Seq_No
HISTORY_WO_PARTS_GRID_CELL Task_Seq_No
HISTORY_WO_PARTS_GRID_CELL Pts_Seq_No
WO_PARTS_GRID_CELL Task_Seq_No
WO_PARTS_GRID_CELL Pts_Seq_No
WO_TASK Task_Seq_No
HISTORY_WO_TASK Work_Order_Seq_No
HISTORY_WO_TASK Task_Seq_No
CONTROL_INFO NXT_INVOICE_NO
WO_LABOR Task_Seq_No
WO_LABOR Lbr_Seq_No
HISTORY_CUST_EQUIPMENT Contract_Seq_No
CONTRACT Cycle_Qty
CONTRACT INVOICE_NO
HISTORY_CONTRACT Contract_Seq_No
HISTORY_CONTRACT Cycle_Qty
HISTORY_CONTRACT INVOICE_NO


U_ITEM_NO
General info
Data type VarChar (30)
Comments
20, CP SQL
30, Dynamics
User-defined variables
Name Value
Null type 'NULL' No
Owner
Default object
Rule object
Used in
Table name Column name
PREDEF_JOB_PARTS Item_No
WO_PARTS Item_No
HISTORY_WO_PARTS_SERIALS Serial_No
HISTORY_WO_PARTS_SERIALS Item_No
HISTORY_WO_PARTS Item_No
WO_PARTS_SERIALS Serial_No
WO_PARTS_SERIALS Item_No
HISTORY_WO_PARTS_GRID_CELL Item_No
WO_PARTS_GRID_CELL Item_No


U_LONG_CODE
General info
Data type VarChar (25)
User-defined variables
Name Value
Null type 'NULL' No
Owner
Default object
Rule object
Used in
Table name Column name
SETUP_NOTES CODE
CUST_EQUIPMENT_NOTES Model_ID
EQP_MODEL Model_ID
CUST_EQUIPMENT_METERS Model_ID
WORK_ORDER CONTACT_1_PHONE
WORK_ORDER PO_NO
WORK_ORDER TERMS_CODE
WORK_ORDER DEPARTMENT
HISTORY_METER_READINGS Model_ID
METER_READINGS Model_ID
HISTORY_WORK_ORDER CONTACT_1_PHONE
HISTORY_WORK_ORDER PO_NO
HISTORY_WORK_ORDER TERMS_CODE
HISTORY_CONTRACT_TAX Model_ID
CONTRACT_TAX Model_ID
SVC_ADDRESS PO_NUMBER
SVC_TECH DEPARTMENT
SP_USER DEPARTMENT
CUST_EQUIPMENT Model_ID
HISTORY_CUST_EQUIPMENT Model_ID
CONTRACT PO_NO
HISTORY_CONTRACT PO_NO


U_NAME
General info
Data type VarChar (40)
User-defined variables
Name Value
Null type 'NULL' No
Owner
Default object
Rule object
Used in
Table name Column name
PREDEF_JOB_TASK Name
WORK_ORDER SVC_SITE_NAME
WORK_ORDER SVC_ADDR_1
WORK_ORDER SVC_ADDR_2
WORK_ORDER CONTACT_1_NAME
HISTORY_WORK_ORDER SVC_SITE_NAME
HISTORY_WORK_ORDER SVC_ADDR_1
HISTORY_WORK_ORDER SVC_ADDR_2
HISTORY_WORK_ORDER CONTACT_1_NAME
SVC_ADDRESS Name
SVC_ADDRESS ADDRESS_1
SVC_ADDRESS ADDRESS_2
SVC_ADDRESS CONTACT_1
SVC_ADDRESS CONTACT_2
WO_TASK Name
HISTORY_WO_TASK Name


U_NOTE
General info
Data type Text
User-defined variables
Name Value
Null type 'NULL' No
Owner
Default object
Rule object
Used in
Table name Column name
CONTRACT_NOTES NOTE_TEXT
CONTRACT_NOTES RAW_TEXT
HISTORY_CONTRACT_NOTES NOTE_TEXT
HISTORY_CONTRACT_NOTES RAW_TEXT
SVC_ADDRESS_NOTES NOTE_TEXT
SVC_ADDRESS_NOTES RAW_TEXT
WO_NOTES NOTE_TEXT
WO_NOTES RAW_TEXT
WO_LABOR_NOTES NOTE_TEXT
WO_LABOR_NOTES RAW_TEXT
HISTORY_WO_NOTES NOTE_TEXT
HISTORY_WO_NOTES RAW_TEXT
SETUP_NOTES NOTE_TEXT
SETUP_NOTES RAW_TEXT
CUST_EQUIPMENT_NOTES NOTE_TEXT
CUST_EQUIPMENT_NOTES RAW_TEXT
WO_TASK_NOTES NOTE_TEXT
WO_TASK_NOTES RAW_TEXT
PREDEF_JOB_LABOR_NOTES NOTE_TEXT
PREDEF_JOB_LABOR_NOTES RAW_TEXT
PREDEF_JOB_NOTES NOTE_TEXT
PREDEF_JOB_NOTES RAW_TEXT
PREDEF_JOB_TASK_NOTES NOTE_TEXT
PREDEF_JOB_TASK_NOTES RAW_TEXT
PREDEF_NOTES NOTE_TEXT
PREDEF_NOTES RAW_TEXT
HISTORY_WO_LABOR_NOTES NOTE_TEXT
HISTORY_WO_LABOR_NOTES RAW_TEXT
HISTORY_WO_TASK_NOTES NOTE_TEXT
HISTORY_WO_TASK_NOTES RAW_TEXT
SP_USER MENU
CONTROL_INFO LAST_WO_INVC_COMMENT
CONTROL_INFO LAST_CONT_INVC_COMMENT
CONTROL_INFO LAST_WO_CR_MEMO_COMMENT


U_NOTE_ID
General info
Data type VarChar (20)
User-defined variables
Name Value
Null type 'NULL' No
Owner
Default object
Rule object
Used in
Table name Column name
CONTRACT_NOTES Note_ID
HISTORY_CONTRACT_NOTES Note_ID
SVC_ADDRESS_NOTES Note_ID
WO_NOTES Note_ID
WO_LABOR_NOTES Note_ID
HISTORY_WO_NOTES Note_ID
SETUP_NOTES Note_ID
CUST_EQUIPMENT_NOTES Note_ID
WO_TASK_NOTES Note_ID
PREDEF_JOB_LABOR_NOTES Note_ID
PREDEF_JOB_NOTES Note_ID
PREDEF_JOB_TASK_NOTES Note_ID
PREDEF_NOTES Note_ID
HISTORY_WO_LABOR_NOTES Note_ID
HISTORY_WO_TASK_NOTES Note_ID
CONTROL_INFO NOTE_ID_FOR_ATTACH
CONTROL_INFO NOTE_ID_FOR_POP


U_PHONE
General info
Data type VarChar (25)
User-defined variables
Name Value
Null type 'NULL' No
Owner
Default object
Rule object
Used in
Table name Column name
SVC_ADDRESS PHONE_1
SVC_ADDRESS FAX_1
SVC_ADDRESS PHONE_2
SVC_ADDRESS FAX_2
SVC_TECH PHONE_1
SVC_TECH PHONE_2


U_PRICE
General info
Data type Decimal (15,4)
User-defined variables
Name Value
Null type 'NULL' No
Owner
Default object
Rule object
Used in
Table name Column name
WO_PMNT Amount
WO_ADDL_CHG Amount
HISTORY_WO_PMNT Amount
WO_TAX Amount
HISTORY_WO_TAX Amount
PREDEF_JOB_LABOR Hourly_Price
PREDEF_JOB_ADDL_CHG Amount
PREDEF_JOB_PARTS Unit_Price
CUST_EQUIPMENT_METERS METER1_START_READING
CUST_EQUIPMENT_METERS METER1_END_READING
CUST_EQUIPMENT_METERS METER1_UNBILLED_USAGE
CUST_EQUIPMENT_METERS METER1_USAGE_CREDIT
CUST_EQUIPMENT_METERS METER1_PM_DUE_USAGE
CUST_EQUIPMENT_METERS METER1_LAST_PM_READING
CUST_EQUIPMENT_METERS METER1_NEXT_PM_READING
CUST_EQUIPMENT_METERS METER1_CONTRACT_USAGE
CUST_EQUIPMENT_METERS METER2_START_READING
CUST_EQUIPMENT_METERS METER2_END_READING
CUST_EQUIPMENT_METERS METER2_UNBILLED_USAGE
CUST_EQUIPMENT_METERS METER2_USAGE_CREDIT
CUST_EQUIPMENT_METERS METER2_PM_DUE_USAGE
CUST_EQUIPMENT_METERS METER2_LAST_PM_READING
CUST_EQUIPMENT_METERS METER2_NEXT_PM_READING
CUST_EQUIPMENT_METERS METER2_CONTRACT_USAGE
CUST_EQUIPMENT_METERS METER3_START_READING
CUST_EQUIPMENT_METERS METER3_END_READING
CUST_EQUIPMENT_METERS METER3_UNBILLED_USAGE
CUST_EQUIPMENT_METERS METER3_USAGE_CREDIT
CUST_EQUIPMENT_METERS METER3_PM_DUE_USAGE
CUST_EQUIPMENT_METERS METER3_LAST_PM_READING
CUST_EQUIPMENT_METERS METER3_NEXT_PM_READING
CUST_EQUIPMENT_METERS METER3_CONTRACT_USAGE
CUST_EQUIPMENT_METERS METER4_START_READING
CUST_EQUIPMENT_METERS METER4_END_READING
CUST_EQUIPMENT_METERS METER4_UNBILLED_USAGE
CUST_EQUIPMENT_METERS METER4_USAGE_CREDIT
CUST_EQUIPMENT_METERS METER4_PM_DUE_USAGE
CUST_EQUIPMENT_METERS METER4_LAST_PM_READING
CUST_EQUIPMENT_METERS METER4_NEXT_PM_READING
CUST_EQUIPMENT_METERS METER4_CONTRACT_USAGE
CUST_EQUIPMENT_METERS METER5_START_READING
CUST_EQUIPMENT_METERS METER5_END_READING
CUST_EQUIPMENT_METERS METER5_UNBILLED_USAGE
CUST_EQUIPMENT_METERS METER5_USAGE_CREDIT
CUST_EQUIPMENT_METERS METER5_PM_DUE_USAGE
CUST_EQUIPMENT_METERS METER5_LAST_PM_READING
CUST_EQUIPMENT_METERS METER5_NEXT_PM_READING
CUST_EQUIPMENT_METERS METER5_CONTRACT_USAGE
WORK_ORDER TOTAL_SALES
WORK_ORDER TOTAL_TXBL_SALES
WORK_ORDER COMMISSION_AMT
WORK_ORDER TOT_TAX_AMT
WORK_ORDER TOT_PAYMENTS
HISTORY_METER_READINGS METER1_READING_AMT
HISTORY_METER_READINGS METER1_READING_CREDIT
HISTORY_METER_READINGS METER2_READING_AMT
HISTORY_METER_READINGS METER2_READING_CREDIT
HISTORY_METER_READINGS METER3_READING_AMT
HISTORY_METER_READINGS METER3_READING_CREDIT
HISTORY_METER_READINGS METER4_READING_AMT
HISTORY_METER_READINGS METER4_READING_CREDIT
HISTORY_METER_READINGS METER5_READING_AMT
HISTORY_METER_READINGS METER5_READING_CREDIT
METER_READINGS METER1_READING_AMT
METER_READINGS METER1_READING_CREDIT
METER_READINGS METER2_READING_AMT
METER_READINGS METER2_READING_CREDIT
METER_READINGS METER3_READING_AMT
METER_READINGS METER3_READING_CREDIT
METER_READINGS METER4_READING_AMT
METER_READINGS METER4_READING_CREDIT
METER_READINGS METER5_READING_AMT
METER_READINGS METER5_READING_CREDIT
HISTORY_WORK_ORDER TOTAL_SALES
HISTORY_WORK_ORDER TOTAL_TXBL_SALES
HISTORY_WORK_ORDER COMMISSION_AMT
HISTORY_WORK_ORDER TOT_TAX_AMT
HISTORY_WORK_ORDER TOT_PAYMENTS
HISTORY_CONTRACT_TAX Amount
CONTRACT_TAX Amount
WO_PARTS Unit_Price
HISTORY_WO_LABOR Hourly_Price
HISTORY_WO_PARTS Unit_Price
HISTORY_WO_ADDL_CHG Amount
USAGE_CODE LEVEL_1
USAGE_CODE LEVEL_2
USAGE_CODE LEVEL_3
USAGE_CODE LEVEL_4
USAGE_CODE LEVEL_5
USAGE_CODE LEVEL_6
INVOICING_CODE FLAT_CHG
INVOICING_CODE ZONE_CHG
INVOICING_CODE TECH_RATE_REG
INVOICING_CODE TECH_RATE_OT
INVOICING_CODE TECH_RATE_SPEC
INVOICING_CODE HELP_RATE_REG
INVOICING_CODE HELP_RATE_OT
INVOICING_CODE HELP_RATE_SPEC
INVOICING_CODE TECH_TVL_RATE_REG
INVOICING_CODE TECH_TVL_RATE_OT
INVOICING_CODE TECH_TVL_RATE_SPEC
INVOICING_CODE HELP_TVL_RATE_REG
INVOICING_CODE HELP_TVL_RATE_OT
INVOICING_CODE HELP_TVL_RATE_SPEC
INVOICING_CODE MIN_TVL_CHG_REG
INVOICING_CODE MIN_TVL_CHG_OT
INVOICING_CODE MIN_TVL_CHG_SPEC
INVOICING_CODE MAX_TVL_CHG_REG
INVOICING_CODE MAX_TVL_CHG_OT
INVOICING_CODE MAX_TVL_CHG_SPEC
INVOICING_CODE CHG_PER_MILE_REG
INVOICING_CODE CHG_PER_MILE_OT
INVOICING_CODE CHG_PER_MILE_SPEC
WO_LABOR Hourly_Price
CUST_EQUIPMENT CONTRACT_BILL_AMT
CUST_EQUIPMENT LAST_USAGE_BILL_AMT
HISTORY_CUST_EQUIPMENT CONTRACT_BILL_AMT
HISTORY_CUST_EQUIPMENT LAST_USAGE_BILL_AMT
CONTRACT TOTAL_SALES
CONTRACT TOTAL_TXBL_SALES
CONTRACT TOT_PAYMENTS
CONTRACT TOT_TAX_AMT
CONTRACT COMMISSION_AMT
CONTRACT LAST_RU_USAGE_BILL_AMT
HISTORY_CONTRACT TOTAL_SALES
HISTORY_CONTRACT TOTAL_TXBL_SALES
HISTORY_CONTRACT TOT_PAYMENTS
HISTORY_CONTRACT TOT_TAX_AMT
HISTORY_CONTRACT COMMISSION_AMT
HISTORY_CONTRACT LAST_RU_USAGE_BILL_AMT


U_QTY
General info
Data type Numeric (7,2)
User-defined variables
Name Value
Null type 'NULL' No
Owner
Default object
Rule object
Used in
Table name Column name
PRIORITY_CODE RESPONSE_TIME
PREDEF_JOB_LABOR Hours_To_Bill
PREDEF_JOB_LABOR HRS_ADJ_FOR_FLAT
PREDEF_JOB_LABOR HRS_ADJ_UP_FOR_INCR
PREDEF_JOB_TASK ESTIMATED_TTR
PREDEF_JOB_PARTS Qty_Used
PREDEF_JOB_PARTS DISCOUNT_PCT
WORK_ORDER DISC_PCT
WORK_ORDER FLAT_CHG_HOURS
HISTORY_WORK_ORDER DISC_PCT
HISTORY_WORK_ORDER FLAT_CHG_HOURS
WO_PARTS Qty_Used
WO_PARTS DISCOUNT_PCT
HISTORY_WO_LABOR Hours_To_Bill
HISTORY_WO_LABOR HRS_ADJ_FOR_FLAT
HISTORY_WO_LABOR HRS_ADJ_UP_FOR_INCR
HISTORY_WO_PARTS Qty_Used
HISTORY_WO_PARTS DISCOUNT_PCT
PROBLEM_CODE EST_TTR
INVOICING_CODE TIME_FOR_FLAT_CHG
INVOICING_CODE MIN_LBR_TIME_REG
INVOICING_CODE MIN_LBR_TIME_OT
INVOICING_CODE MIN_LBR_TIME_SPEC
INVOICING_CODE LBR_TIME_INCR_REG
INVOICING_CODE LBR_TIME_INCR_OT
INVOICING_CODE LBR_TIME_INCR_SPEC
INVOICING_CODE TVL_TIME_INCR_REG
INVOICING_CODE TVL_TIME_INCR_OT
INVOICING_CODE TVL_TIME_INCR_SPEC
HISTORY_WO_PARTS_GRID_CELL QTY
WO_PARTS_GRID_CELL QTY
WO_TASK ESTIMATED_TTR
HISTORY_WO_TASK ESTIMATED_TTR
CONTROL_INFO UDEF_1_LEN
CONTROL_INFO UDEF_2_LEN
CONTROL_INFO UDEF_3_LEN
CONTROL_INFO UDEF_4_LEN
WO_LABOR Hours_To_Bill
WO_LABOR HRS_ADJ_FOR_FLAT
WO_LABOR HRS_ADJ_UP_FOR_INCR
CUST_EQUIPMENT QUANTITY
HISTORY_CUST_EQUIPMENT QUANTITY
CONTRACT DISC_PCT
HISTORY_CONTRACT DISC_PCT


U_UDEF
General info
Data type VarChar (100)
User-defined variables
Name Value
Null type 'NULL' No
Owner
Default object
Rule object
Used in
Table name Column name
WO_ADDL_CHG Description
PREDEF_JOB_LABOR Work_Description
PREDEF_JOB_TASK LOCATION
PREDEF_JOB_ADDL_CHG Description
PREDEF_JOB_PARTS Description
WORK_ORDER DISPATCH_NOTE
WORK_ORDER USR_DEFINED_1
WORK_ORDER USR_DEFINED_2
WORK_ORDER USR_DEFINED_3
WORK_ORDER USR_DEFINED_4
HISTORY_WORK_ORDER DISPATCH_NOTE
HISTORY_WORK_ORDER USR_DEFINED_1
HISTORY_WORK_ORDER USR_DEFINED_2
HISTORY_WORK_ORDER USR_DEFINED_3
HISTORY_WORK_ORDER USR_DEFINED_4
WO_PARTS Description
HISTORY_WO_LABOR Work_Description
HISTORY_WO_PARTS Description
HISTORY_WO_ADDL_CHG Description
SP_USER PASSWORD
WO_TASK LOCATION
HISTORY_WO_TASK LOCATION
WO_LABOR Work_Description
CUST_EQUIPMENT LOCATION
CUST_EQUIPMENT USER_DEFINED_1
CUST_EQUIPMENT USER_DEFINED_2
CUST_EQUIPMENT USER_DEFINED_3
CUST_EQUIPMENT USER_DEFINED_4
CUST_EQUIPMENT USER_DEFINED_5
CUST_EQUIPMENT USER_DEFINED_6
CUST_EQUIPMENT USER_DEFINED_7
CUST_EQUIPMENT USER_DEFINED_8
CUST_EQUIPMENT USER_DEFINED_9
CUST_EQUIPMENT USER_DEFINED_10
HISTORY_CUST_EQUIPMENT LOCATION


U_USAGE_PRICE
General info
Data type Decimal (15,5)
User-defined variables
Name Value
Null type 'NULL' No
Owner
Default object
Rule object
Used in
Table name Column name
USAGE_CODE CHG_PER_USE_1
USAGE_CODE CHG_PER_USE_2
USAGE_CODE CHG_PER_USE_3
USAGE_CODE CHG_PER_USE_4
USAGE_CODE CHG_PER_USE_5
USAGE_CODE CHG_PER_USE_6