WennSoft Job Cost
211 tables in this module
| Table | Description |
|---|---|
| JC00102 | JC_Job_MSTR |
| JC00103 | JC_Prior_Year_MSTR |
| JC00104 | JC_Job_Contract_Max_MSTR |
| JC00105 | JC_Job_Architect_MSTR |
| JC00106 | JC_Job_Address_MSTR |
| JC00107 | Job User Defined Master |
| JC00114 | JC_Job_Contract_Amount_Audit |
| JC00115 | JC_Job_Change_Order_Amount_Audit |
| JC00201 | JC_Forecast_Cost_Revision_MSTR |
| JC00203 | JC_Forecast_Total_MSTR |
| JC00301 | JC_Keys_MSTR |
| JC00401 | JC_Estimate_Cost_Revision_MSTR |
| JC00501 | JC_Notes_MSTR |
| JC00502 | JC_Contract_Notes_MSTR |
| JC00503 | JC_CO_Contract_Notes_MSTR |
| JC00600 | JC_Project_Master_Bill_Codes |
| JC00601 | JC_Billing_Codes_MSTR |
| JC00701 | JC_Job_Detail_MSTR |
| JC00702 | JC_Estimate_Detail_TEMP |
| JC00801 | JC_Employee_Union_Code_MSTR |
| JC00802 | JC_Employee_Fringe_Master |
| JC00901 | JC_Job_Index_MSTR |
| JC01001 | JC_Change_Orders_MSTR |
| JC01002 | JC_Chg_Ord_Detail_MSTR |
| JC01003 | JC_Chg_Ord_Est_Revision_MSTR |
| JC01101 | JC_File_Maint_MSTR |
| JC01102 | JC_File_Maint_Error_Log |
| JC01201 | JC_Cost_Code_Description_MSTR |
| JC01301 | JC_Production_Batch_Headers |
| JC01401 | JC_Conversion_MSTR |
| JC01501 | JC_Vendor_MSTR |
| JC01502 | JC_Vendor_Contact_MSTR |
| JC01503 | JC_Vendor_Detail_MSTR |
| JC01504 | JC_Vendor_Dates_MSTR |
| JC01505 | JC_Vendor_Master_Dates |
| JC01511 | JC_Master_Subcontractor_MSTR |
| JC01513 | JC_Master_Vendor_Detail_MSTR |
| JC01514 | JC_Master_Vendor_Dates_MSTR |
| JC001520 | JC_Master_Subcontractor_Contact_MSTR |
| JC01519 | JC_UK_Correlation_ID |
| JC01520 | JC_Contract_MSTR |
| JC01521 | JC_Contract_Cost_Code_DTL |
| JC01525 | JC_Contract_Payment_Transaction_WORK |
| JC01530 | JC_CO_Contract_MSTR |
| JC01531 | JC_CO_Contract_Cost_Code_DTL |
| JC01601 | JC_Initialization_Master |
| JC01701 | JC_Project_Number_MSTR |
| JC01801 | Job Cost Rate Classes |
| JC01802 | JC_Rate_Class_DTL |
| JC01803 | JC_Union_Code_Federal_Classification_Code_Link |
| JC10201 | JC_Inventory_Transaction_WORK |
| JC10301 | JC_Job_TRX_HDR_WORK |
| JC10302 | JC_Job_TRX_LINE_WORK |
| JC10400 | JC_Job_Close_Audit |
| JC10500 | JC_RFP_Tax_Work_File |
| JC10501 | JC_Invoice_WORK |
| JC10503 | JC_Invoice_Schedule_WORK |
| JC10504 | JC_Invoice_TRX_WORK |
| JC10506 | JC_CO_Bill_Codes_WORK |
| JC10511 | JC_Invoice_Project_WORK |
| JC10512 | JC_Project_TRX_Level_Bill_Code |
| JC10513 | JC_Project_TRX_Level_Move |
| JC10514 | JC_Project_TRX_Level_Transfer |
| JC10523 | JC_Invoice_Schedule_Bill_Codes_WORK |
| JC10601 | JC_Chg_Ord_Detail_WORK |
| JC10701 | JC_Payroll_Transaction_WORK |
| JC10702 | JC_Time_Sheet_TRX_WORK |
| JC10703 | JC_Payroll_Post_WORK |
| JC10704 | JC_Payroll_Detail_For_Summary |
| JC10801 | JC_Unit_TRX_HDR_WORK |
| JC10802 | JC_Unit_TRX_LINE_WORK |
| JC10901 | JC_Prod_Units_LINE_WORK |
| JC10902 | JC_Prod_Units_HDR_WORK |
| JC11525 | JC_Contract_Payment_Transaction_WORK |
| JC11526 | JC_Contract_Payment_Distribution_WORK_OPEN |
| JC20001 | JC_Job_Transaction_OPEN |
| JC20002 | JC_Job_Detail_Summary |
| JC20003 | JC_Job_MSTR_Summary |
| JC20004 | JC_Vendor_TRX_OPEN |
| JC20005 | JC_Estimate_Cost_Summary |
| JC20014 | JC_Vendor_RetentionApply |
| JC20020 | JC_Transferred_Service_Calls |
| JC20101 | JC_POC_WORK_OPEN |
| JC20301 | JC_Job_TRX_HDR_OPEN |
| JC20401 | JC_Job_Transaction_Entry_POST |
| JC20501 | JC_Invoice_OPEN |
| JC20502 | JC_Cash_Receipts_OPEN |
| JC20503 | JC_Invoice_Schedule_OPEN |
| JC20504 | JC_Invoice_TRX_OPEN |
| JC20511 | JC_Invoice_Project_OPEN |
| JC20523 | JC_Invoice_Schedule_Bill_Codes_OPEN |
| JC20601 | JC_Union_Transaction_OPEN |
| JC20705 | JC_Lien_Waivers_OPEN |
| JC20801 | JC_Unit_TRX_HDR_OPEN |
| JC20902 | JC_Prod_Units_HDR_OPEN |
| JC21525 | JC_Contract_Payment_Transaction_OPEN |
| JC30001 | JC_Job_MSTR_HIST |
| JC30001L | JC_RFP_Transaction_HIST_LINES |
| JC30002 | JC_Job_Index_MSTR_HIST |
| JC30003 | JC_Job_MSTR_Summary_HIST |
| JC30004 | JC_Job_Architect_HIST |
| JC30006 | JC_Job_Address_HIST |
| JC30101 | JC_Job_Detail_MSTR_HIST |
| JC30102 | JC_Job_Detail_Summary_HIST |
| JC30107 | Job User Defined Master History |
| JC30201 | JC_Job_Transaction_OPEN_HIST |
| JC30202 | JC_Job_TRX_HDR_HIST |
| JC30301 | JC_Notes_HIST |
| JC30401 | JC_Est_Cost_Rev_MSTR_HIST |
| JC30501 | JC_Invoice_HIST |
| JC30502 | JC_Cash_Receipts_HIST |
| JC30503 | JC_Invoice_Schedule_HIST |
| JC30504 | JC_Invoice_TRX_HIST |
| JC30511 | JC_Invoice_Project_HIST |
| JC30523 | JC_Invoice_Schedule_Bill_Codes_HIST |
| JC30601 | JC_Billing_Codes_HIST |
| JC30701 | JC_SOP_Jobs_WORK_HIST |
| JC30210 | JC_SOP_LINE_HIST |
| JC30801 | JC_Unit_TRX_HDR_HIST |
| JC31001 | JC_Change_Orders_MSTR_HIST |
| JC31002 | JC_Chg_Ord_Detail_MSTR_HIST |
| JC31003 | JC_Chg_Ord_Est_Revision_MSTR_HIST |
| JC31201 | JC_Forecast_Cost_Rev_MSTR_HIST |
| JC40101 | JC_User_Defined_SETP |
| JC40102 | JC_Production_Measure_SETP |
| JC40103 | JC_Cost_Code_Format_SETP |
| JC40104 | JC_Cost_Code_Segments_SETP |
| JC40105 | JC_Version_SETP |
| JC40106 | JC_Fed_Class_SETP |
| JC40107 | Job Type Setup |
| JC40201 | JC_Union_SETP |
| JC40202 | JC_Cost_Codes_MSTR_SETP |
| JC40203 | JC_Union_Pay_Code_SETP |
| JC40204 | JC_Benefit_Categories_SETP |
| JC40205 | JC_Chg_Ord_Status_SETP |
| JC40206 | JC_Invoice_Styles_SETP |
| JC40207 | JC_Password_SETP |
| JC40208 | JC_Profit_Type_SETP |
| JC40209 | JC_Cost_Element_SETP |
| JC40301 | JC_Division_SETP |
| JC40302 | JC_Division_Accounts_SETP |
| JC40303 | JC_Revenue_Acct_SETP |
| JC40304 | JC_Default_Cost_Codes_SETP |
| JC40305 | JC_Posting_Option_SETP |
| JC40306 | JC_Invoice_Accounts_SETP |
| JC40307 | JC_Closed_Jobs_Acct_SETP |
| JC40308 | JC_Offset_Accounts_SETP |
| JC40401 | JC_Document_SETP |
| JC40501 | JC_Overhead_Detail_Codes |
| JC40502 | JC_Overhead_Group_SETP |
| JC40503 | JC_Overhead_Group_Total_SETP |
| JC40601 | JC_Period_Header |
| JC40602 | JC_Period_Setup |
| JC40603 | JC_CIS_Tax_Years |
| JC40701 | JC_Subs_Option_SETP |
| JC40702 | JC_Subs_Dates_SETP |
| JC40703 | JC_Subs_Dates_Type_SETP |
| JC40711 | JC_CIS_Export_SETP |
| JC40750 | JC_Service_Cost_Code_Mapping_SETP |
| JC40801 | JC_Project_Number_SETP |
| JC40901 | JC_Tax_Schedule_SETP |
| JC41101 | JC_Setup_Options_SETP |
| JC41102 | JC_Setup_Custom_Options |
| JC41103 | JC_Setup_Custom_Options_Labels |
| JC41201 | JC_Architect_SETP |
| JC50101 | JC_Job_TRX_Number_TEMP |
| JC50201 | JC_Application_Payment_TEMP |
| JC70001 | JC_Labor_Summary_ROPT |
| JC90000 | JC_Project_Status_View |
| JC90001 | JC_Project_Job_Invoice_VIEW |
| JC90002 | JC_Project_Invoice_ADDR_VIEW |
| JC90100 | JC_Labor_Summary_VIEW |
| JC90101 | JC_Labor_Breakdown_VIEW |
| JC90102 | JC_Job_MSTR_VIEW |
| JC90200 | JC_Certified_Payroll_VIEW |
| JC90300 | JC_Overhead_Group_VIEW |
| JC90400 | JC_Estimate_Period_VIEW |
| JC90500 | JC_Subs_Status_VIEW |
| JC90700 | JC_Inv_TRX_Level_Batch_VIEW |
| JC90701 | JC_Inv_TRX_Level_Labor_Batch_VIEW |
| JC92001 | JC_Job_Transaction_VIEW |
| JC92601 | JC_Union_Trx_OPEN_Summary_VIEW |
| JC99701 | JC_Cost_Code_Segment_View |
| JC0CHECK | JC_File_Maint_Check_Links |
| JC10001L | JC_RFP_Transaction_WORK_LINES |
| JC10211 | JC_SOP_LINE_WORK |
| JC_NotGL | JC_JCTransactionNotInGL |
| JC_NotJC | JC_GLTransactionNotInJC |
| JC_WIP | JC_WIPReconciliation |
| JCCIS150 | JC_Sub_CIS24_Reconcile |
| JCCIS200 | JC_CIS25_Voucher |
| JCCIS201 | JC_CIS23_Voucher |
| JCERRBTR | JC_Error_Messages_Btrieve |
| JCERRCT | JC_Error_Messages_Ctree |
| JCERRORS | JC_Error_Messages_MSTR |
| JCPAY01 | JC_Payroll_Union_TEMP |
| JCPCHECK | JC_Period_Check_Status |
| JCRFP100 | JC_RFP_Transaction_WORK_File |
| JCRFP300 | JC_RFP_Transaction_HIST_File |
| JCUNION1 | JC_Monthly_Union_Report_TEMP |
| JCUPAY1 | JC_Union_Monthly_Payroll_TEMP |
| JCVAT150 | JC_Sub_VAT_Reconcile |
| TSACTIVE | JC_Time_Sheet_Activity |
| wsVenLU | JC_Vendor_LookupFilterTmp |
| DummyCO | Dummy JC ChangeOrder |
| DummyCC | Dummy JC CostCode |
| DummyF | Dummy JC Forecast |
| DummyJ | Dummy JC Job |
| DummyP | Dummy JC Project |
| DummyS | Dummy JC Subcontractor |
| DummySD | Dummy JC SubcontractorDate |