Search the GP Tables
Search by TABLE NAME
Search by FIELD NAME
These are our JC scripts. All of our scripts for Dynamics GP can be found here
JC Scripts
 
No records to display.
Module List > Module COMPANY..JC tables
DynDeveloper Table Reference is in Wiki format! Registered users have the ability to improve the table reference, add comments, and generally make the world a better place.
You are currently viewing the COMPANY database.
Change


ClearPixel
Freq
Used
 Display Name
 JC00102JC_Job_MSTR
 JC00103JC_Prior_Year_MSTR
 JC00104JC_Job_Contract_Max_MSTR
 JC00105JC_Job_Architect_MSTR
 JC00106JC_Job_Address_MSTR
 JC00107JC_UDF_MSTR
 JC001520JC_Master_Subcontractor_Contact_MSTR
 JC00201JC_Forecast_Cost_Revision_MSTR
 JC00203JC_Forecast_Total_MSTR
 JC00301JC_Keys_MSTR
 JC00401JC_Estimate_Cost_Revision_MSTR
 JC00501JC_Notes_MSTR
 JC00600JC_Project_Master_Bill_Codes
 JC00601JC_Billing_Codes_MSTR
 JC00701JC_Job_Detail_MSTR
 JC00702JC_Estimate_Detail_TEMP
 JC00801JC_Employee_Union_Code_MSTR
 JC00901JC_Job_Index_MSTR
 JC01001JC_Change_Orders_MSTR
 JC01002JC_Chg_Ord_Detail_MSTR
 JC01003JC_Chg_Ord_Est_Revision_MSTR
 JC01101JC_File_Maint_MSTR
 JC01102JC_File_Maint_Error_Log
 JC01201JC_Cost_Code_Description_MSTR
 JC01301JC_Production_Batch_Headers
 JC01401JC_Conversion_MSTR
 JC01501JC_Vendor_MSTR
 JC01502JC_Vendor_Contact_MSTR
 JC01503JC_Vendor_Detail_MSTR
 JC01504JC_Vendor_Dates_MSTR
 JC01505JC_Vendor_Master_Dates
 JC01511JC_Master_Subcontractor_MSTR
 JC01513JC_Master_Vendor_Detail_MSTR
 JC01514JC_Master_Vendor_Dates_MSTR
 JC01519JC_UK_Correlation_ID
 JC01601JC_Initialization_MSTR
 JC01701JC_Project_Number_MSTR
 JC01801JC_Rate_Class_MSTR
 JC01802JC_Rate_Class_DTL
 JC0CHECKJC_File_Maint_Check_Links
Freq
Used
 Display Name
 JC10001LJC_RFP_Transaction_WORK_LINES
 JC10201JC_Inventory_Transaction_WORK
 JC10211JC_SOP_LINE_WORK
 JC10301JC_Job_TRX_HDR_WORK
 JC10302JC_Job_TRX_LINE_WORK
 JC10500JC_RFP_Tax_WORK
 JC10501JC_Invoice_WORK
 JC10503JC_Invoice_Schedule_WORK
 JC10504JC_Invoice_TRX_WORK
 JC10506JC_CO_Bill_Codes_WORK
 JC10511JC_Invoice_Project_WORK
 JC10512JC_Project_TRX_Level_Bill_Code
 JC10513JC_Project_TRX_Level_Move
 JC10514JC_Project_TRX_Level_Transfer
 JC10701JC_Payroll_Transaction_WORK
 JC10703JC_Payroll_Post_WORK
 JC10801JC_Unit_TRX_HDR_WORK
 JC10802JC_Unit_TRX_LINE_WORK
 JC10901JC_Prod_Units_LINE_WORK
 JC10902JC_Prod_Units_HDR_WORK
Freq
Used
 Display Name
 JC20001JC_Job_Transaction_OPEN
 JC20002JC_Job_Detail_Summary
 JC20003JC_Job_MSTR_Summary
 JC20004JC_Vendor_TRX_OPEN
 JC20005JC_Estimate_Cost_Summary
 JC200102 
 JC200701 
 JC20101JC_POC_WORK_OPEN
 JC20301JC_Job_TRX_HDR_OPEN
 JC20401JC_Job_Transaction_Entry_POST
 JC20501JC_Invoice_OPEN
 JC20502JC_Cash_Receipts_OPEN
 JC20503JC_Invoice_Schedule_OPEN
 JC20504JC_Invoice_TRX_OPEN
 JC20511JC_Invoice_Project_OPEN
 JC20601JC_Union_Transaction_OPEN
 JC20705JC_Lien_Waivers_OPEN
 JC20801JC_Unit_TRX_HDR_OPEN
 JC20902JC_Prod_Units_HDR_OPEN
Work Tables
Freq
Used
 Display Name
 JC30001JC_Job_MSTR_HIST
 JC30001LJC_RFP_Transaction_HIST_LINES
 JC30002JC_Job_Index_MSTR_HIST
 JC30003JC_Job_MSTR_Summary_HIST
 JC30004JC_Job_Architect_HIST
 JC30006JC_Job_Address_HIST
 JC30101JC_Job_Detail_MSTR_HIST
 JC30102JC_Job_Detail_Summary_HIST
 JC30107JC_UDF_MSTR_HIST
 JC30201JC_Job_Transaction_OPEN_HIST
 JC30202JC_Job_TRX_HDR_HIST
 JC30210JC_SOP_LINE_HIST
 JC30301JC_Notes_HIST
 JC30401JC_Est_Cost_Rev_MSTR_HIST
 JC30501JC_Invoice_HIST
 JC30502JC_Cash_Receipts_HIST
 JC30503JC_Invoice_Schedule_HIST
 JC30504JC_Invoice_TRX_HIST
 JC30511JC_Invoice_Project_HIST
 JC30601JC_Billing_Codes_HIST
 JC30701JC_SOP_Jobs_WORK_HIST
 JC30801JC_Unit_TRX_HDR_HIST
 JC31001JC_Change_Orders_MSTR_HIST
 JC31002JC_Chg_Ord_Detail_MSTR_HIST
 JC31201JC_Forecast_Cost_Rev_MSTR_HIST
Freq
Used
 Display Name
 JC_Add_Resource 
 JC_APTRXLineNotes 
 JC_JobTRXLineNotes 
 JC_WSCmtLne 
 JC40101JC_User_Defined_SETP
 JC40102JC_Production_Measure_SETP
 JC40103JC_Cost_Code_Format_SETP
 JC40104JC_Cost_Code_Segments_SETP
 JC40105JC_Version_SETP
 JC40106JC_Fed_Class_SETP
 JC40107JC_Job_Type_SETP
 JC40201JC_Union_SETP
 JC40202JC_Cost_Codes_MSTR_SETP
 JC40203JC_Union_Pay_Code_SETP
 JC40204JC_Benefit_Categories_SETP
 JC40205JC_Chg_Ord_Status_SETP
 JC40206JC_Invoice_Styles_SETP
 JC40207JC_Password_SETP
 JC40208JC_Profit_Type_SETP
 JC40209JC_Cost_Element_SETP
 JC40301JC_Division_SETP
 JC40302JC_Division_Accounts_SETP
 JC40303JC_Revenue_Acct_SETP
 JC40304JC_Default_Cost_Codes_SETP
 JC40305JC_Posting_Option_SETP
 JC40306JC_Invoice_Accounts_SETP
 JC40307JC_Closed_Jobs_Acct_SETP
 JC40308JC_Offset_Accounts_SETP
 JC40309 
 JC40401JC_Document_SETP
 JC40501JC_Overhead_Detail_Codes
 JC40502JC_Overhead_Group_SETP
 JC40503JC_Overhead_Group_Total_SETP
 JC40601JC_Period_HDR
 JC40602JC_Period_SETP
 JC40603JC_CIS_Tax_Years
 JC40701JC_Subs_Option_SETP
 JC40702JC_Subs_Dates_SETP
 JC40703JC_Subs_Dates_Type_SETP
 JC40711JC_CIS_Export_SETP
 JC40801JC_Project_Number_SETP
 JC40901JC_Tax_Schedule_SETP
 JC41001JC_User_Profile_SETP
 JC41101JC_Setup_Options_SETP
 JC41102JC_Setup_Custom_Options
 JC41103JC_Setup_Custom_Options_Labels
 JC41201JC_Architect_SETP
 JC50101JC_Job_TRX_Number_TEMP
 JC50201JC_Application_Payment_TEMP
 JC70001JC_Labor_Summary_ROPT
 JCCIS150JC_Sub_CIS24_Reconcile
 JCCIS200JC_CIS25_Voucher
 JCCIS201JC_CIS23_Voucher
 JCERRORSJC_Error_Messages_MSTR
 JCPCHECKJC_Period_Check_Status
 JCRFP100JC_RFP_Transaction_WORK
 JCRFP300JC_RFP_Transaction_HIST
 JCVAT150JC_Sub_VAT_Reconcile
Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3