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 |