Columns Added
A list of all columns added to Spectrum database tables since v13.19, sorted by Table.
| Table | Columns Added |
|---|---|
| BR_BANK_ACCOUNT_MC | Web_Site |
| Currency_Code | |
| Check_Report_File | |
| Currency_Gain_Loss_GL | |
| BR_CHECK_RECON_HISTORY_MC | Exchange_Rate |
| Comdata_Virtual_Card | |
| BR_CHECK_RECON_MC | Comdata_Virtual_Card |
| Exchange_Rate | |
| BR_DEPOSIT_RECON_HISTORY_MC | Exchange_Rate |
| BR_DEPOSIT_RECON_MC | Exchange_Rate |
| BR_DIRECT_CHECK_HEADER_MC | Exchange_Rate |
| BR_DIRECT_CHECK_HISTORY_MC | Exchange_Rate |
| BR_DIRECT_CHK_DET_HISTORY_MC | MC_Amount |
| BR_TEMP_DIRECT_CHECK_UPD_MC | Exchange_Rate |
| MC_Transaction_Amount | |
| BR_TEMP_TRANSACTION_HIST_MC | Outstanding_Flag |
| BR_TEMP_TRANSACTION_UPD_MC | Tran_Source_Type |
| Exchange_Rate | |
| MC_Transaction_Amount | |
| BR_TEMP_WIRE_TRANSFER_UPD_MC | Exchange_Rate |
| MC_Amount | |
| BR_WIRE_TRANSFER_DET_HIST_MC | Currency_Code |
| Exchange_Rate | |
| MC_Transaction_Amount | |
| MC_Transaction_Amount_Cur_Comp | |
| BR_WIRE_TRANSFER_DETAIL_MC | Currency_Code |
| BR_WIRE_TRANSFER_HEADER_MC | Exchange_Rate |
| BR_WIRE_TRANSFER_HISTORY_MC | Exchange_Rate |
| CP_TEMP_FRINGE_DETAIL_MC | Deduct_Type |
| CP_TEMP_FRINGE_SUMMARY_MC | Fringe_Key |
| Formula_Code | |
| Fringe_Rate | |
| Base_Type | |
| Benefit_Tier_Code | |
| CP_TEMP_W2_UPDATE_MC | Entity_Code |
| CP_TEMP_WORK_COMP_REP_2_MC | Subject_To_Earnings |
| CR_ALTERNATE_BILLTO_ADDR_MC | Address_ID |
| Phone_ID | |
| Fax_ID | |
| Remark | |
| Status | |
| CR_BILLING_HEADER_MC | VAT_Code |
| VAT_Tax_Percent | |
| Total_VAT_Amt | |
| Retention_VAT_Amt | |
| CR_CASH_RECEIPT_GL_HIST_MC | Batch_Code |
| Payer_Name | |
| Misc_Cash_Remark | |
| CR_CASH_RECEIPT_TRAN_MC | Batch_Code |
| Payer_Name | |
| Misc_Cash_Remark | |
| Pre_Pay | |
| CR_CHANGE_ORDER_HEADER_MC | Billing_Adjustment |
| Fee_Percent | |
| Fee_Amount | |
| CR_CHNG_REQ_CON_DET_MC | Subcontractor_Code |
| Subcontract_Number | |
| Bid_Item_Code | |
| Sub_Amount | |
| Add_On_Flag | |
| Comments | |
| CR_CHNG_REQ_HDR_MC | Billing_Adjustment |
| Fee_Percent | |
| Fee_Amount | |
| TransactionId | |
| CR_CONTRACT_MASTER_MC | Terms_Override |
| Terms_Override_Code | |
| Status | |
| Pricing_Fee | |
| id | |
| CR_CUSTOMER_MASTER_MC | Address_ID |
| Phone_ID | |
| Fax_ID | |
| Primary_Contact | |
| Web_Site | |
| id | |
| CR_DRAW_REQUEST_DETAIL_MC | Online_Tax_Code |
| CR_DRAW_UNIT_PRICE_BILL_MC | Online_Tax_Code |
| CR_INVOICE_DETAIL_MC | Detail_Line_Type |
| Use_Tax_Code | |
| Use_Tax_Amount | |
| Online_Tax_Code | |
| CR_INVOICE_HEADER_MC | Sales_Tax_Override |
| Retention_Override | |
| VAT_Code | |
| VAT_Tax_Percent | |
| Total_VAT_Amt | |
| Retention_VAT_Amt | |
| Currency_Code | |
| Exchange_Rate | |
| CR_INVOICE_TEMP_MC | VAT_Code |
| Invoice_VAT_Text | |
| VAT_Tax_Percent | |
| Total_VAT_Amt | |
| Retention_VAT_Amt | |
| CR_OPEN_ITEM_MC | Total_VAT_Amt |
| Retention_VAT_Amt | |
| Total_VAT_Paid | |
| Retention_VAT_Paid | |
| CR_RECURRING_INVOICE_DET_MC | Detail_Line_Type |
| CR_RECURRING_INVOICE_HDR_MC | Retention_Override |
| Area_Code | |
| VAT_Code | |
| Total_VAT_Amt | |
| Retention_VAT_Amt | |
| CR_SALES_TAX_MASTER_MC | id |
| Online_Tax_Code_Flag | |
| CR_TEMP_BILL_HEADER_MC | VAT_Code |
| VAT_Tax_Percent | |
| Total_VAT_Amt | |
| Retention_VAT_Amt | |
| CR_TEMP_BILLING_HEADER_MC | VAT_Code |
| VAT_Tax_Percent | |
| Total_VAT_Amt | |
| Retention_VAT_Amt | |
| CR_TEMP_CASH_GL_HIST_MC | Batch_Code |
| CR_TEMP_CASH_RECEIPT_TRAN_MC | Batch_Code |
| Payer_Name | |
| Misc_Cash_Remark | |
| CR_TEMP_DRAW_HEADER_MC | VAT_Code |
| VAT_Tax_Percent | |
| Total_VAT_Amt | |
| Retention_VAT_Amt | |
| CR_TEMP_GL_MC | Customer_Code |
| Customer_Invoice_Number | |
| Customer_Invoice_Type | |
| CR_TEMP_INVOICE_DETAIL_MC | Detail_Line_Type |
| CR_TEMP_INVOICE_HEADER_MC | Sales_Tax_Override |
| Retention_Override | |
| VAT_Code | |
| VAT_Tax_Percent | |
| Total_VAT_Amt | |
| Retention_VAT_Amt | |
| CR_TEMP_RECUR_INV_HDR_MC | VAT_Code |
| VAT_Tax_Percent | |
| Total_VAT_Amt | |
| Retention_VAT_Amt | |
| VAT_GL_Account | |
| Lock_Revenue_Entry | |
| CR_TMP_CHNG_REQ_COST_DET_MC | Comments |
| DI_MASTER_MC | Transaction_Description |
| Transaction_ID | |
| DI_TEMP_SEARCH_RESULTS_MC | Create_Date |
| Change_Date | |
| EC_EQUIPMENT_MASTER_MC | Market_Value |
| id | |
| EC_EQUIPMENT_TYPE_MC | Hilti_OnTrack |
| EC_FIELD_EVENT_MC | Event_Type |
| Mechanic_ID | |
| Job_Company | |
| Yard_Code | |
| EC_FUEL_OIL_MC | id |
| EC_REVENUE_HISTORY_MC | TM_Equipment_Billing_Code |
| TM_Equipment_Billing_Level | |
| EC_TEMP_FUEL_TRUCK_MC | Mechanic_ID |
| EC_TEMP_TRANS_UPDATE_MC | GL_Display_Mask |
| EC_TRAN_GL_WORK_MC | DI_Reference |
| EC_YARD_MAINTENANCE_MC | Latitude |
| Longitude | |
| EL_TEMP_AP_SUB_DETAIL_MC | Hours |
| EM_COST_CENTERS_MC | Entity_Code |
| id | |
| ET_DATA_ENTRY_REQ_HEADER_MC | Contact_ID |
| Site_ID | |
| ET_REQ_HISTORY_HEADER_MC | Contact_ID |
| Site_ID | |
| GL_DETAIL_MC | Control_Code |
| Source_Description | |
| Job_Company | |
| Equipment_Company | |
| Vendor_Code | |
| Vendor_Invoice_Number | |
| Vendor_Invoice_Type | |
| Cash_Management_Company | |
| Cash_Management_Account | |
| Check_Number | |
| Cash_Management_Wire_Number | |
| Cash_Management_Wire_Type | |
| Customer_Code | |
| Customer_Invoice_Number | |
| Customer_Invoice_Type | |
| Cash_Receipt_Transaction_Code | |
| Cash_Receipt_Check_Number | |
| GL_Journal_Entry_Company | |
| GL_Journal_Entry_Number | |
| Inventory_Company | |
| Inventory_Transaction_Reference | |
| DI_Company | |
| DI_Cabinet | |
| DI_Drawer | |
| DI_Folder | |
| DI_Reference | |
| Source_Transaction_Type | |
| GL_FISCAL_CALENDAR_DETAIL | id |
| GL_MASTER_MC | id |
| HR_ACCRUAL_HISTORY_MC | Entity_Code |
| HR_APPLICANT_MASTER_1_MC | Encrypted_Social_Security |
| HR_EMP_DEPENDENTS_MC | Encrypted_Employee_Dependent_SSN |
| HR_EMPLOYEE_FORMS_MC | Employee_Form_Description |
| Employee_Form_Classification | |
| Employee_Form_Comment | |
| HR_INCIDENTS_PEOPLE_MC | Encrypted_Incident_Pple_SSN |
| Encrypted_Incident_Pple_Lic_Num | |
| HR_LOCATIONS_MC | Establishment_Code |
| Location_Headquarters | |
| Location_HDQ_Add1 | |
| Location_HDQ_Add2 | |
| Location_HDQ_City | |
| Location_HDQ_County | |
| Location_HDQ_State | |
| Location_HDQ_Postal | |
| HR_OPENINGS_MC | Cost_Center |
| HR_TEMP_VET100_DET_MC | Location |
| HR_TEMP_VET100_HDR_MC | Location |
| Entity_Code | |
| IM_GL_DEPARTMENT_MC | Cost_Adj_GL_Account |
| Job_Sale_GL_Account | |
| IM_GL_POST_MC | Transaction_Reference |
| Batch_Code | |
| IM_ITEM_TRANSACTION_MC | Batch_Code |
| IM_ITEM_WHSE_MC | Whs_Std_Cost |
| IM_REQUISITION_HEADER_MC | Batch_Code |
| IM_REQUISITION_HEADER_TMP_MC | Batch_Code |
| IM_TEMP_GL_POST_MC | Transaction_Reference |
| Post_Flag | |
| Batch_Code | |
| IM_TEMP_HIST_J_TYPE_MC | Batch_Code |
| IM_TEMP_HISTORY_MC | Batch_Code |
| IM_TEMP_REQ_HEADER_MC | Batch_Code |
| IM_TMP_GL_DEPARTMENT_MC | Cost_Adjustment_GL_Account |
| Cost_Adjustment_GL_AccountD | |
| Job_Sales_GL_Account | |
| Job_Sales_GL_AccountD | |
| IM_TRANSACTION_HISTORY_MC | Batch_Code |
| IN_INVOICE_TOTALS_MC | VAT_Code |
| VAT_Tax_Percent | |
| Total_VAT_Amt | |
| IN_TEMP_GL_UPDATE_MC | Invoice_Number |
| IN_TEMP_INVOICE_DETAIL_MC | Line_Extension |
| IN_TEMP_INVOICE_HEADER_MC | VAT_Code |
| Total_VAT_Amt | |
| JC_GL_WORK_MC | DI_Reference |
| JC_JOB_BATCH_PROJ_COST_MC | Quantity_Cost_Type |
| Quantity_Auto_Cost_Type | |
| JC_JOB_GROUP_MC | Copy_WO_Site |
| Copy_Inv_Approval | |
| Copy_Earn_Rev_Calc | |
| Copy_Job_Comment | |
| Copy_Est_Unit_Cost | |
| Copy_Proj_Hrs | |
| Copy_Phase_PR_Tax | |
| Copy_Est_Type | |
| Copy_Phase_Comment | |
| Copy_Track_Item | |
| Copy_Pay_When_Paid | |
| JC_JOB_LEGAL_DESCRIPTION_MC | Owner_Name |
| Legal_Desc | |
| JC_JOB_MASTER_MC | Comment |
| Certified_Project_ID | |
| Certified_Week_Type | |
| Lock_Revenue_Entry | |
| id | |
| JC_JOB_WAGE_CODE_MC | Post_With_Std_Rates |
| JC_PHASE_MASTER_MC | Comment |
| id | |
| JC_PHASE_SUMMARY_MC | id |
| JC_PROJECTED_TRANSACTION_MC | Additional_Quantity |
| JC_TAX_CLASS_MC | Override_VAT_Flag |
| Override_VAT_Code | |
| JC_TEMP_ANALYSIS_COST_MC | Sub_Job |
| JC_TEMP_ANALYSIS_MATERIALS_MC | Job_Number |
| Job_Description | |
| Currency_Code | |
| JC_TEMP_JC_HIST_RECLASS_1_MC | Pr_Company_Code |
| AP_Company_Code | |
| Equip_Company_Code | |
| Inventory_Company_Code | |
| History_Cost_Center_Debit | |
| JC_TEMP_JC_HIST_REP_MC | Subjob_Number |
| Cost_Center | |
| JC_TEMP_JOB_STATUS_MAINT_MC | New_Complete_Date |
| Lock_Revenue_Entry | |
| New_Lock_Revenue_Entry | |
| JC_TEMP_PRE_TC_DET_MC | Period_Quantity |
| JTD_Quantity | |
| JC_TEMP_UNAPP_AP_INV_MC | JTD_Quantity |
| OE_ORDER_HEADER_MC | Record_Type |
| OE_ORDER_TOTALS_MC | VAT_Code |
| Total_VAT_Amt | |
| OE_TEMP_INVREGISTER_MC | Total_VAT_Amt |
| OE_TMP_CRYSTAL_HDR_MC | Record_Type |
| PA_COMPANY_CODE | Thread_Id |
| PA_COMPANY_INFORMATION | id |
| PA_DATA_FUNCTION_ABSTRACTION | Link_Type |
| Url | |
| Task_Parameter1 | |
| Task_Parameter2 | |
| Task_Parameter3 | |
| Task_Parameter4 | |
| Task_Parameter5 | |
| PA_OPERATOR_MASTER | Profile_ID |
| PA_TRASER_LINK_UPD_CONTROL | Read_List_Price_From |
| Read_Standard_Cost_From | |
| PJ_SUBMITTAL_STATUS_MC | Status_Type |
| PJ_TEMP_SUBMITTAL_STATUS_MC | Status_Type |
| PM_MAINT_WO_HEADER_MC | Routing_Code |
| PM_TEMP_EWO_COST_REPORT_DETAIL_MC | System_Key_2 |
| PO_CUST_PO_IMPORT_HEADER_MC | PO_Method |
| PO_PACK_LIST_DETAIL_MC | Accrued_Cost |
| Exchange_Rate | |
| PO_PURCHASE_ORDER_DETAIL_MC | Line_Type |
| PO_PURCHASE_ORDER_HEADER_MC | Currency_Code |
| PO_Method | |
| Comment | |
| VAT_Code | |
| Total_VAT_Amt | |
| Purch_Loc_Code | |
| Pay_Loc_Code | |
| Accrue_PO_Costs | |
| PO_RECEIVING_HISTORY_MC | Sequence |
| PO_TEMP_DETAIL_BLANKET_MC | Original_Quantity |
| Original_Amount | |
| Original_Tax | |
| PO_TEMP_PO_DETAIL_MC | Line_Type |
| PO_TEMP_PO_HEADER_MC | VAT_Code |
| Total_VAT_Amt | |
| Purch_Loc_Code | |
| Pay_Loc_Code | |
| PO_TEMP_STATUS_REPORT_MC | Line_Extension_List1 |
| Received_Extension | |
| PR_CERTIFIED_COVER_SHEET | Contractor_ID |
| License_Type | |
| License_Number | |
| Insurance_Number | |
| Contracting_Agency | |
| Contact_Email | |
| PR_CHECK_HISTORY_MC | Entity_Code |
| Pay_Cycle_Message | |
| PR_CHECK_VOL_DED_HISTORY_MC | Vol_Deduct_Accumulation |
| PR_CHECK_VOL_DED_TEMP_MC | Entity_Code |
| PR_CHECKS_IN_PROGRESS_MC | Pay_Cycle_Message |
| PR_CYCLE_SETTINGS_MC | Period_Start_Date |
| Entity_Code | |
| Cycle_Autodeposit_Status | |
| PR_DEDUCTIONS_MC | GL_Account_Override |
| PR_DEPARTMENT_MC | Addon_Allocation_GL_Account |
| Std_Cost_Variance_GL_Account | |
| Dir_Cost_Adjustment_GL_Account | |
| Post_With_Standard_Rates | |
| PR_DEPT_COST_CENTER_OVER_MC | Addon_Allocation_GL_Account |
| Std_Cost_Variance_GL_Account | |
| Dir_Cost_Adjustment_GL_Account | |
| PR_ELECTRONIC_W2 | Entity_Code |
| PR_EMPL_STATE_TAX_HIST_MC | CPP_Second_Contribution_List1 |
| CPP_Second_Contribution_List2 | |
| PR_EMPL_TO_DATE_INFO_MC | SUTA_Excess |
| PR_EMPL_VOL_DEDUCT_MC | Shared_Code |
| PR_EMPLOYEE_1095C_DEP_MC | Encrypted_Social_Security |
| PR_EMPLOYEE_ENTITY_VOL_DED_MC | Shared_Code |
| PR_EMPLOYEE_MASTER_1_MC | Contact_ID |
| Permanent_Unemployment_State | |
| Wrk_Mobile_ID | |
| Wrk_Ext_ID | |
| Encrypted_Social_Security | |
| Encrypted_Driver_License | |
| Encrypted_Bank_Account_Number | |
| Encrypted_Bank_Account_Number_2 | |
| Encrypted_Bank_Account_Number_3 | |
| Encrypted_Bank_Account_Number_4 | |
| Encrypted_Bank_Account_Number_5 | |
| id | |
| PR_EMPLOYEE_MASTER_2_MC | Total_State_SUTA_Excess |
| Total_County_SUTA_Excess | |
| Total_Local_SUTA_Excess | |
| PR_EMPLOYEE_MASTER_3_MC | Apprentice_Flag |
| Apprentice_ID | |
| Apprentice_Wage_Percent | |
| Benefit_Code | |
| Employee_Personal_Email | |
| Summary_Post_Flag | |
| PR_INCOME_TAX_TABLE_MC | CPP_Second_Contribution_Rate1 |
| CPP_Second_Contribution_Rate2 | |
| CPP_Second_Contribution_Limit1 | |
| CPP_Second_Contribution_Limit2 | |
| Tax_GL_Account | |
| Unemployment_GL_Account | |
| FICA_GL_Account_List1 | |
| FICA_GL_Account_List2 | |
| SDI_Dollars_Per_Hour_List1 | |
| SDI_Dollars_Per_Hour_List2 | |
| Work_Limit_Type | |
| Work_Limit | |
| Unemployment_Calc_Method | |
| Basic_Exemption | |
| Tax_Type | |
| Country | |
| Abbrev_W2_State_Code | |
| PR_LAYOFF_CHECK_EDIT_MC | Union_Fringe_Addon_Amount |
| PR_LAYOFF_CHECK_TC_DETAIL_MC | WO_Labor_Bill_Code |
| TM_Labor_Billing_Code | |
| TM_Labor_Billing_Level | |
| TM_Equipment_Billing_Code | |
| TM_Equipment_Billing_Level | |
| PR_LAYOFF_CHECKS_MC | Period_Start_Date |
| PR_LAYOFF_PAY_DAY_HOLDING_MC | Union_Fringe_Addon_Amount |
| PR_LAYOFF_STATE_TAX_HOLD_MC | CPP_Second_Contribution_List1 |
| CPP_Second_Contribution_List2 | |
| PR_NACHA_HDR_REC_DEFAULT | File_ID_Modifier |
| PR_PAY_DAY_EDIT_MC | Union_Fringe_Addon_Amount |
| Standard_Labor_Cost | |
| PR_PRE_TC_HOLD_MC | WO_Labor_Bill_Code |
| TM_Labor_Billing_Code | |
| TM_Labor_Billing_Level | |
| TM_Equipment_Billing_Code | |
| TM_Equipment_Billing_Level | |
| PR_PRE_TC_IMPORT_ERR_MC | WO_Labor_Bill_Code |
| TM_Labor_Billing_Code | |
| TM_Labor_Billing_Level | |
| TM_Equipment_Billing_Code | |
| TM_Equipment_Billing_Level | |
| PR_PRE_TIME_CARD_MC | WO_Labor_Bill_Code |
| TM_Labor_Billing_Code | |
| TM_Labor_Billing_Level | |
| TM_Equipment_Billing_Code | |
| TM_Equipment_Billing_Level | |
| PR_RETRO_PAY_DETAILS_MC | TM_Labor_Billing_Code |
| TM_Labor_Billing_Level | |
| TM_Equipment_Billing_Code | |
| TM_Equipment_Billing_Level | |
| PR_RETRO_PAY_SUMMARY_MC | TM_Labor_Billing_Code |
| TM_Labor_Billing_Level | |
| TM_Equipment_Billing_Code | |
| TM_Equipment_Billing_Level | |
| PR_T4_EMPLOYEE_MC | Dental_Benefit_Code |
| CPP_Amount2 | |
| Employer_CPP2 | |
| QPP_Amount2 | |
| PR_T4_HISTORY_MC | Dental_Benefit_Code |
| CPP_Amount2 | |
| Employer_CPP2 | |
| QPP_Amount2 | |
| PR_TAX_HIST_RECALC_DETAIL_MC | TM_Labor_Billing_Code |
| TM_Labor_Billing_Level | |
| TM_Equipment_Billing_Code | |
| TM_Equipment_Billing_Level | |
| PR_TAX_TABLE | Tax_Base_Type |
| Tax_Deduct_List1 | |
| Tax_Deduct_List2 | |
| Tax_Deduct_List3 | |
| Tax_Deduct_List4 | |
| Tax_Deduct_List5 | |
| Rate_Type | |
| Rate_Percent | |
| Minimum_Amount | |
| Maximum_Amount | |
| STD_Deduct_Type | |
| STD_Deduct_Apply_Flag | |
| STD_Deduct_Annual | |
| STD_Deduct_Percent | |
| STD_Deduct_Min | |
| STD_Deduct_Max | |
| Standard_Deduct_Adjust | |
| STD_Deduct_Adjust_Flag | |
| Credit_Type | |
| Tax_Credit_Method | |
| Credit_Percent | |
| Minimum_Credit | |
| Maximum_Credit | |
| Tax_Credit_Exempt_List1 | |
| Tax_Credit_Exempt_List2 | |
| Tax_Credit_Exempt_List3 | |
| Tax_Credit_Exempt_List4 | |
| Tax_Credit_Exempt_List5 | |
| Tax_Credit_Exempt_List6 | |
| Tax_Credit_Exempt_List7 | |
| Tax_Credit_Exempt_List8 | |
| Tax_Credit_Exempt_List9 | |
| Tax_Credit_Exempt_List10 | |
| Exemption_Flag | |
| Personal_Exempt_Flag | |
| Exempt_Amount | |
| Dependent_Exempt_Amount | |
| Max_Deduct_List1 | |
| Max_Deduct_List2 | |
| Max_Deduct_List3 | |
| Max_Deduct_List4 | |
| Max_Deduct_List5 | |
| Non_Resident_Flag | |
| Round_Withholding_Flag | |
| Table_Low_Limit17 | |
| Table_Low_Limit18 | |
| Table_Low_Limit19 | |
| Table_Low_Limit20 | |
| Table_Low_Limit21 | |
| Table_Low_Limit22 | |
| Table_Low_Limit23 | |
| Table_Low_Limit24 | |
| Table_Low_Limit25 | |
| Table_Low_Limit26 | |
| Table_Low_Limit27 | |
| Table_Low_Limit28 | |
| Table_Low_Limit29 | |
| Table_Low_Limit30 | |
| Table_Low_Limit31 | |
| Table_Low_Limit32 | |
| Table_Low_Limit33 | |
| Table_Low_Limit34 | |
| Table_Low_Limit35 | |
| Table_Low_Limit36 | |
| Table_Low_Limit37 | |
| Table_Low_Limit38 | |
| Table_Low_Limit39 | |
| Table_Low_Limit40 | |
| Table_Low_Limit41 | |
| Table_Low_Limit42 | |
| Table_Low_Limit43 | |
| Table_Low_Limit44 | |
| Table_Low_Limit45 | |
| Table_Low_Limit46 | |
| Table_Low_Limit47 | |
| Table_Low_Limit48 | |
| Table_Low_Limit49 | |
| Table_Low_Limit50 | |
| Table_Bracket_Amount17 | |
| Table_Bracket_Amount18 | |
| Table_Bracket_Amount19 | |
| Table_Bracket_Amount20 | |
| Table_Bracket_Amount21 | |
| Table_Bracket_Amount22 | |
| Table_Bracket_Amount23 | |
| Table_Bracket_Amount24 | |
| Table_Bracket_Amount25 | |
| Table_Bracket_Amount26 | |
| Table_Bracket_Amount27 | |
| Table_Bracket_Amount28 | |
| Table_Bracket_Amount29 | |
| Table_Bracket_Amount30 | |
| Table_Bracket_Amount31 | |
| Table_Bracket_Amount32 | |
| Table_Bracket_Amount33 | |
| Table_Bracket_Amount34 | |
| Table_Bracket_Amount35 | |
| Table_Bracket_Amount36 | |
| Table_Bracket_Amount37 | |
| Table_Bracket_Amount38 | |
| Table_Bracket_Amount39 | |
| Table_Bracket_Amount40 | |
| Table_Bracket_Amount41 | |
| Table_Bracket_Amount42 | |
| Table_Bracket_Amount43 | |
| Table_Bracket_Amount44 | |
| Table_Bracket_Amount45 | |
| Table_Bracket_Amount46 | |
| Table_Bracket_Amount47 | |
| Table_Bracket_Amount48 | |
| Table_Bracket_Amount49 | |
| Table_Bracket_Amount50 | |
| Table_Percent_Over_Limit17 | |
| Table_Percent_Over_Limit18 | |
| Table_Percent_Over_Limit19 | |
| Table_Percent_Over_Limit20 | |
| Table_Percent_Over_Limit21 | |
| Table_Percent_Over_Limit22 | |
| Table_Percent_Over_Limit23 | |
| Table_Percent_Over_Limit24 | |
| Table_Percent_Over_Limit25 | |
| Table_Percent_Over_Limit26 | |
| Table_Percent_Over_Limit27 | |
| Table_Percent_Over_Limit28 | |
| Table_Percent_Over_Limit29 | |
| Table_Percent_Over_Limit30 | |
| Table_Percent_Over_Limit31 | |
| Table_Percent_Over_Limit32 | |
| Table_Percent_Over_Limit33 | |
| Table_Percent_Over_Limit34 | |
| Table_Percent_Over_Limit35 | |
| Table_Percent_Over_Limit36 | |
| Table_Percent_Over_Limit37 | |
| Table_Percent_Over_Limit38 | |
| Table_Percent_Over_Limit39 | |
| Table_Percent_Over_Limit40 | |
| Table_Percent_Over_Limit41 | |
| Table_Percent_Over_Limit42 | |
| Table_Percent_Over_Limit43 | |
| Table_Percent_Over_Limit44 | |
| Table_Percent_Over_Limit45 | |
| Table_Percent_Over_Limit46 | |
| Table_Percent_Over_Limit47 | |
| Table_Percent_Over_Limit48 | |
| Table_Percent_Over_Limit49 | |
| Table_Percent_Over_Limit50 | |
| PR_TEMP_1095C_FORM_MC | Dependent_Seq19 |
| Dependent_Seq20 | |
| Dependent_Seq21 | |
| Dependent_Seq22 | |
| Dependent_Seq23 | |
| Dependent_Seq24 | |
| Dependent_Seq25 | |
| Dependent_Seq26 | |
| Dependent_Seq27 | |
| Dependent_Seq28 | |
| Dependent_Seq29 | |
| Dependent_Seq30 | |
| Dependent_Birth19 | |
| Dependent_Birth20 | |
| Dependent_Birth21 | |
| Dependent_Birth22 | |
| Dependent_Birth23 | |
| Dependent_Birth24 | |
| Dependent_Birth25 | |
| Dependent_Birth26 | |
| Dependent_Birth27 | |
| Dependent_Birth28 | |
| Dependent_Birth29 | |
| Dependent_Birth30 | |
| Dependent_CoverAllMonths19 | |
| Dependent_CoverAllMonths20 | |
| Dependent_CoverAllMonths21 | |
| Dependent_CoverAllMonths22 | |
| Dependent_CoverAllMonths23 | |
| Dependent_CoverAllMonths24 | |
| Dependent_CoverAllMonths25 | |
| Dependent_CoverAllMonths26 | |
| Dependent_CoverAllMonths27 | |
| Dependent_CoverAllMonths28 | |
| Dependent_CoverAllMonths29 | |
| Dependent_CoverAllMonths30 | |
| PR_TEMP_AFFIDAVIT_MC | Wage_Code |
| Union_Code | |
| Full_Description | |
| PR_TEMP_CERTIFIED_1_MC | Other_Hours |
| Check_Date | |
| PR_TEMP_CERTIFIED_2_MC | Apprenticeship_Fund |
| Dues | |
| Fund_Administration | |
| Health_Welfare | |
| Other1 | |
| Other2 | |
| Pension | |
| Savings | |
| Training | |
| Travel_Subsistence | |
| Vacation_Holiday | |
| Apprenticeship_Fund_Rate | |
| Health_Welfare_Rate | |
| Other1_Rate | |
| Other2_Rate | |
| Pension_Rate | |
| Vacation_Holiday_Rate | |
| Cash_Fringe_Rate | |
| First_Name | |
| Middle_Name | |
| Last_Name | |
| Non_Cash_Fixed | |
| Non_Cash_Gross | |
| Non_Cash_All_Hours | |
| Non_Cash_Reg_Hours | |
| Non_Cash_OT_Hours | |
| Hours_List1 | |
| Hours_List2 | |
| Hours_List3 | |
| Hours_List4 | |
| Hours_List5 | |
| Hours_List6 | |
| Hours_List7 | |
| PR_TEMP_CERTIFIED_3_MC | Cost_Center |
| Certified_Project_ID | |
| Work_State_Tax_Code | |
| PR_TEMP_CHECK_PRINT_MC | Period_Start_Date |
| Pay_Cycle_Message | |
| Pay_Check_Label1 | |
| Pay_Check_Label2 | |
| Pay_Check_Label3 | |
| PR_TEMP_DEDUCT_LIST_HDR_MC | TCGross_Nondirect_Debit |
| TCGross_Job_Debit | |
| TCGross_Equipment_Debit | |
| TCGross_WorkOrder_Debit | |
| Payout_Accrual_Code | |
| Union_Benefits | |
| Allocate_Across_Time_Cards | |
| Post_As_Union_Fringe | |
| PR_TEMP_DEDUCTIONS_MC | GL_Account_Override |
| PR_TEMP_DEPT_LIST_MC | Description_36 |
| PR_TEMP_EMPL_STATE_TAX_MC | CPP_Second_Contribution_List1 |
| CPP_Second_Contribution_List2 | |
| PR_TEMP_EMPL_VOL_DEDUCT_MC | Other_Shared_Amount |
| PR_TEMP_FRINGE_DETAIL_MC | Deduct_Type |
| PR_TEMP_FRINGE_SUMMARY_MC | Fringe_Key |
| Formula_Code | |
| Fringe_Rate | |
| Base_Type | |
| Benefit_Tier_Code | |
| PR_TEMP_GL_DISTRIBUTION_MC | Currency_Code |
| PR_TEMP_GL_UPDATE_MC | Currency_Code |
| PR_TEMP_JOB_DIST_REP_MC | Phase_Description |
| PR_TEMP_LAYOFF_EMPL_DED | Other_Shared_Amount |
| PR_TEMP_LAYOFF_RETRO_MC | TM_Labor_Billing_Code |
| TM_Labor_Billing_Level | |
| TM_Equipment_Billing_Code | |
| TM_Equipment_Billing_Level | |
| PR_TEMP_LAYOFF_STATE_TAX_MC | CPP_Second_Contribution_List1 |
| CPP_Second_Contribution_List2 | |
| PR_TEMP_LAYOFF_UNION_DED_MC | Work_Date |
| PR_TEMP_LAYOFF_UNION_FRI_MC | Work_Date |
| PR_TEMP_LAYOFF_UNION_RTE_MC | Work_Date |
| PR_TEMP_LAYOFF_UNION_WGR_MC | Work_Date |
| PR_TEMP_PRE_TC_IMPORT_MC | WO_Labor_Bill_Code |
| TM_Labor_Billing_Code | |
| TM_Labor_Billing_Level | |
| TM_Equipment_Billing_Code | |
| TM_Equipment_Billing_Level | |
| PR_TEMP_PRE_TC_RETRO_MC | TM_Labor_Billing_Code |
| TM_Labor_Billing_Level | |
| TM_Equipment_Billing_Code | |
| TM_Equipment_Billing_Level | |
| PR_TEMP_TC_UNION_DED_MC | Work_Date |
| PR_TEMP_TC_UNION_FRI_MC | Work_Date |
| PR_TEMP_TC_UNION_RTE_MC | Work_Date |
| PR_TEMP_TC_UNION_WGR_MC | Work_Date |
| PR_TEMP_UNION_MASTER_1_MC | Craft_Code |
| RPP_Number | |
| PR_TEMP_W2_FORMS_TOT_REC_MC | Box_12_Code_FF |
| PR_TEMP_W2_UPD_EMP_STATE_MC | Entity_Code |
| PR_TEMP_WORK_COMP_REP_MC | Subject_To_Earnings |
| PR_TIME_CARD_DETAIL_MC | WO_Labor_Bill_Code |
| TM_Labor_Billing_Code | |
| TM_Labor_Billing_Level | |
| TM_Equipment_Billing_Code | |
| TM_Equipment_Billing_Level | |
| PR_TIME_CARD_FIELDS_MC | Skip_Labor_Bill_Code |
| Skip_Equipment_Bill_Code | |
| PR_TIME_CARD_HISTORY_MC | WO_Labor_Bill_Code |
| TM_Labor_Billing_Code | |
| TM_Labor_Billing_Level | |
| TM_Equipment_Billing_Code | |
| TM_Equipment_Billing_Level | |
| PR_TIME_CARD_RETRO_HIST_MC | TM_Labor_Billing_Code |
| TM_Labor_Billing_Level | |
| TM_Equipment_Billing_Code | |
| TM_Equipment_Billing_Level | |
| PR_TIME_CARD_RETRO_TEMP_MC | TM_Labor_Billing_Code |
| TM_Labor_Billing_Level | |
| TM_Equipment_Billing_Code | |
| TM_Equipment_Billing_Level | |
| PR_TMP_LAYOFF_ACROSS_CALC_MC | Total_Suta_Excess1 |
| Total_Suta_Excess2 | |
| Total_Suta_Excess3 | |
| PR_UNION_MASTER_1_MC | Craft_Code |
| RPP_Number | |
| PR_VAC_HOL_SICK_MASTER_MC | Use_Or_Lose_Flag |
| Pay_Check_Label | |
| Balance_Limit | |
| PR_VOL_DEDUCT_MASTER_MC | TCGross_Nondirect_Debit |
| TCGross_Job_Debit | |
| TCGross_Equipment_Debit | |
| TCGross_WorkOrder_Debit | |
| Payout_Accrual_Code | |
| Union_Benefits | |
| Shared_Code | |
| Display_Accumulated_Balance | |
| Union_Limit_Flag | |
| Allocate_Across_Time_Cards | |
| Post_As_Union_Fringe | |
| PR_W2_FORM_PRINT_MC | Entity_Code |
| Encrypted_Social_Security | |
| Verification_Code | |
| PR_WAGE_CLASS_MASTER_MC | Status |
| Labor_Class | |
| Benefit_Tier_Code | |
| Regular_Std_Job_Rate | |
| Overtime_Std_Job_Rate | |
| Doubletime_Std_Job_Rate | |
| PR_WORK_CLASS_MC | Override_Limit |
| Limit_Type | |
| Limit | |
| Policy_Start_Date | |
| SC_CONTRACT_MC | Proposal_Flag |
| Proposal_Date | |
| Proposal_Days_Honored | |
| SC_CONTRACT_TYPE_MC | Billing_Source |
| SC_CONTRACT_VISIT_EQUIP_MC | Task_Unit_Price |
| SC_TEMP_WO_REVENUE_HIST_MC | WO_Date |
| SI_DATA_FORMAT | Field_Number31 |
| Field_Start_Position31 | |
| Field_Stop_Position31 | |
| Validate_Flag31 | |
| Field_Number32 | |
| Field_Start_Position32 | |
| Field_Stop_Position32 | |
| Validate_Flag32 | |
| Field_Number33 | |
| Field_Start_Position33 | |
| Field_Stop_Position33 | |
| Validate_Flag33 | |
| SI_PLANT_PIT_MC | VAT_Code |
| SI_TEMP_TICKET_SUMMARY_MC | VAT_Code |
| Total_VAT_Amt | |
| SI_TICKET_ENTRY_MC | VAT_Code |
| Total_VAT_Amt | |
| Import_Freight_Flag | |
| SI_TICKET_HISTORY_MC | VAT_Code |
| VAT_Tax_Percent | |
| Total_VAT_Amt | |
| Import_Freight_Flag | |
| SI_TICKET_IMPORT_ERROR_MC | Import_Freight_Flag |
| Import_Freight_Cost | |
| SI_TICKET_IMPORT_ERROR_TEMP_MC | Import_Freight_Flag |
| Import_Freight_Cost | |
| ST_IMAGE_XREF | IS_FORM_TEMPLATE |
| TM_BILL_TOTAL_MC | VAT_Code |
| VAT_Tax_Percent | |
| Total_VAT_Amt | |
| Retention_VAT_Amt | |
| TM_BILLING_DETAIL_MC | Original_Subjob |
| TM_BILLING_HISTORY_DETAIL_MC | Original_Subjob |
| TM_BILLING_TRANSACTION_MC | Batch_Code |
| TM_HISTORY_BILLING_TOTAL_MC | VAT_Code |
| VAT_Tax_Percent | |
| Total_VAT_Amt | |
| Retention_VAT_Amt | |
| Change_Request_Number | |
| Customer_Code | |
| TM_JOB_BILLING_MC | Bill_From_Master |
| Bill_To_Change_Request | |
| TM_TEMP_BILLING_TRANS_MC | Batch_Code |
| TM_TEMP_JOB_BILLING_MC | Current_Billing |
| TM_TEMP_JOB_DELETE_MC | Terminal_ID |
| TM_TEMP_TRANSFER_TO_AR_MC | Terminal |
| Change_Request_Number | |
| Invoice_Or_Transaction | |
| Transaction_Type | |
| VN_1099_MC | Entity_Code |
| Encrypted_Federal_ID | |
| Payer_State_Code | |
| VN_CURRENT_ROUT_PROCESS_MC | Approval_Limit |
| VN_DOCUMENT_TRACK_ITEM_MC | Subtier_Vendor_Flag |
| Track_Item_Period | |
| Track_Item_Interval | |
| VN_ELECTRONIC_1099 | Entity_Code |
| VN_GL_DISTRIBUTION_DETAIL_MC | Unit_Price |
| Current_Bill_Quantity | |
| Current_Bill_Amount | |
| Quantity_Billed_To_Date | |
| Amount_Billed_To_Date | |
| Estimated_Quantity | |
| Estimated_Bid | |
| Retention_Flag | |
| Currency_Code | |
| Exchange_Rate | |
| PO_Line_Sequence | |
| Accrued_Cost | |
| VN_GL_DISTRIBUTION_HEADER_MC | Back_Charge_Subcontract |
| Entered_By | |
| Payment_Number | |
| Currency_Code | |
| Exchange_Rate | |
| VAT_Code | |
| VAT_Tax_Percent | |
| Total_VAT_Amt | |
| Retention_VAT_Amt | |
| VAT_Override | |
| Pay_Loc_Code | |
| VN_INVOICE_APPROVAL_DET_MC | Unit_Price |
| Current_Bill_Quantity | |
| Current_Bill_Amount | |
| Quantity_Billed_To_Date | |
| Amount_Billed_To_Date | |
| Estimated_Quantity | |
| Estimated_Bid | |
| Retention_Flag | |
| PO_Line_Sequence | |
| Accrued_Cost | |
| VN_INVOICE_APPROVAL_HDR_MC | Back_Charge_Subcontract |
| Payment_Number | |
| Currency_Code | |
| Exchange_Rate | |
| VAT_Code | |
| VAT_Tax_Percent | |
| Total_VAT_Amt | |
| Retention_VAT_Amt | |
| VAT_Override | |
| Pay_Loc_Code | |
| VN_INVOICE_TRAN_DETAIL_MC | Unit_Price |
| Current_Bill_Quantity | |
| Current_Bill_Amount | |
| Quantity_Billed_To_Date | |
| Amount_Billed_To_Date | |
| Estimated_Quantity | |
| Estimated_Bid | |
| Retention_Flag | |
| PO_Line_Sequence | |
| Accrued_Cost | |
| VN_INVOICE_TRAN_HEADER_MC | Back_Charge_Subcontract |
| Entered_By | |
| Payment_Number | |
| Currency_Code | |
| Exchange_Rate | |
| VAT_Code | |
| VAT_Tax_Percent | |
| Total_VAT_Amt | |
| Retention_VAT_Amt | |
| VAT_Override | |
| Pay_Loc_Code | |
| VN_MANUAL_CHECK_WORK_MC | Batch_Code |
| VN_OPEN_ITEMS_MC | Currency_Code |
| Exchange_Rate | |
| VAT_Code | |
| Total_VAT_Amt | |
| Retention_VAT_Amt | |
| Total_VAT_Paid | |
| Retention_VAT_Paid | |
| Pay_Loc_Code | |
| VN_PAY_PROCESSING_CONTROL_MC | Cost_Center |
| Prepare_To_Pay_As_Of | |
| Days_Due_Within | |
| Include_Retention | |
| Comdata_Bank_Account | |
| Credit_Card_Account | |
| VN_PAYMENT_HISTORY_MC | Subcontract_Payment_Number |
| Back_Charge_Subcontract | |
| Pay_Loc_Code | |
| Payment_Type | |
| VN_RECUR_INVOICE_HEADER_MC | Pay_Loc_Code |
| Currency_Code | |
| VN_ROUTING_HISTORY_MC | Approval_Limit |
| VN_ROUTING_MASTER_DETAIL_MC | Approval_Limit |
| VN_SUBCONTRACT_MC | Pay_Override |
| Pay_Terms | |
| Pay_Days | |
| Disc_Override | |
| Disc_Terms | |
| Disc_Days | |
| Disc_Perc | |
| Currency_Code | |
| Pay_When_Paid | |
| id | |
| VN_SUBCONTRACT_PHASE_MC | Qty_Upd_Over |
| id | |
| VN_TEMP_1099_MC | Entity_Code |
| Payer_State_Code | |
| VN_TEMP_CASH_REQUIREMENT_MC | Pay_When_Paid |
| VN_TEMP_CHECK_WORK_MC | Payment_Type |
| Bank_Account | |
| VN_TEMP_CHK_REGISTER_MC | Pay_Loc_Code |
| Pay_Loc_Name | |
| VN_TEMP_ELECTRONIC_1099_MC | Entity_Code |
| VN_TEMP_GL_DIST_REP_MC | Currency_Code |
| Accrued_Cost | |
| VN_TEMP_INVOICE_TRAN_DETAIL_MC | Currency_Code |
| Exchange_Rate | |
| PO_Line_Sequence | |
| Accrued_Cost | |
| VN_TEMP_INVOICE_TRAN_HEADER_MC | CM_Check_Number |
| VAT_Code | |
| VAT_Tax_Percent | |
| Total_VAT_Amt | |
| Retention_VAT_Amt | |
| VAT_Override | |
| Pay_Loc_Code | |
| Currency_Code | |
| VN_TEMP_LIEN_CRYSTAL_MC | Legal_Desc |
| VN_TEMP_PAYMENT_GL_MC | Currency_Code |
| Exchange_Rate | |
| VN_TEMP_PAYMENTS_GL_MC | Currency_Code |
| Exchange_Rate | |
| VN_TEMP_PAYMENTS_GL2_MC | Currency_Code |
| Exchange_Rate | |
| VN_TEMP_PRE_CHECK_REG_MC | Pay_Loc_Code |
| Pay_Loc_Name | |
| Payment_Type | |
| VN_TEMP_RECUR_INV_HDR_MC | GL_Account |
| VN_TEMP_SUB_BILLING_DET_MC | Invoice_Number |
| Invoice_Type_Code | |
| Tax_Amount | |
| Subcontract_Number | |
| Formatted_Phase | |
| VN_TEMP_SUB_BILLING_HDR_MC | Back_Charge_Subcontract |
| VAT_Code | |
| Current_VAT_Amt | |
| VN_TEMP_SUB_BILLING_OTH_MC | GL_Distribution_Account |
| VAT_Code | |
| Current_VAT_Amt | |
| Back_Charge_Subcontract | |
| VN_TEMP_SUBCONTRACT_MC | Pay_When_Paid |
| VN_TEMP_TRAN_REGISTER_MC | Currency_Code |
| Exchange_Rate | |
| Accrued_Cost | |
| VN_TEMP_USE_TAX_REP_MC | WO_Number |
| VN_TEMP_VEND_SUB_TRACK_MC | Subtier_Vendor_Code |
| Log_ID | |
| Subtier_Vendor_Name | |
| Relationship | |
| VN_TEMP_VOID_CHECK_WORK_MC | Retention_Account |
| VN_TMP_DAILY_ACTIVITY_UPD_MC | Currency_Code |
| Exchange_Rate | |
| VN_USE_TAX_MASTER_MC | id |
| VN_VEND_SUB_DOC_TRACK_MC | First_Recur_Date |
| Last_Recur_Date | |
| Final_Renewal | |
| VN_VENDOR_MASTER_MC | Address_ID |
| Phone_ID | |
| Fax_ID | |
| Primary_Contact | |
| Web_Site | |
| Small_Business | |
| Minority_Business | |
| Woman_Business | |
| Veteran_Business | |
| PO_Method | |
| Pay_When_Paid | |
| Encrypted_Social_Sec_Number | |
| Encrypted_Checking_Account_Code | |
| id | |
| VN_VOID_CHECK_WORK_FILE_MC | Exchange_Rate |
| WO_ADDRESS_MC | id |
| Use_Tax_Code | |
| Mat_Use_Tax | |
| WO_COST_HISTORY_MC | Labor_Billing_Code |
| WO_EMPL_HOURS_HIST_DETAIL_MC | Labor_Billing_Code |
| WO_EMPL_LABOR_HOURS_DET_MC | Labor_Billing_Code |
| WO_EMPLOYEE_ASSIGNMENT_MC | System_Key |
| WO_EMPLOYEE_CATEGORY_MC | Warehouse |
| All_Warehouses | |
| WO_EQUIPMENT_MC | Contract_Equipment_Comment |
| WO_HEADER_MC | id |
| WO_MATERIAL_DETAIL_HIST_MC | Transaction_Create_Date |
| Use_Tax_Code | |
| Use_Tax_Amount | |
| WO_MATERIAL_DETAIL_MC | Transaction_Create_Date |
| Accrue_Use_Tax | |
| Use_Tax_Code | |
| Use_Tax_Amount | |
| WO_NONSTOCK_MARKUP_MC | Nonstock_Markup_Flag |
| Stock_Markup_Flag | |
| Stock_Markup_Value1 | |
| Stock_Markup_Value2 | |
| Stock_Markup_Value3 | |
| Stock_Markup_Value4 | |
| Stock_Markup_Value5 | |
| Stock_Markup_Value6 | |
| Stock_Markup_Value7 | |
| Stock_Markup_Value8 | |
| Stock_Markup_Value9 | |
| Stock_Markup_Value10 | |
| WO_TEMP_COMP_HEADER_MC | Cust_VAT_Code |
| Cust_VAT_Amt | |
| Warr_VAT_Code | |
| Warr_VAT_Amt | |
| WO_TEMP_UPDATE_TO_AR_MC | Update_Now |
| AR_Terms_Code | |
| Sales_Tax_Code | |
| WO_TMP_EMPL_HRS_EDIT_LIST_MC | Labor_Billing_Code |
| WO_TYPE_MC | Cash_Check_Tran_Code |
| Credit_Card_Tran_Code | |
| WS_TEMP_PO_HEADER_MC | Accrue_PO_Costs |
