When Sage 100 upgrades a module to the new file formats (Job Cost, Payroll, and Time Card recently) it is always a challenge to figure out the new table names to use. In your MAS90\Home directory, there is a file called mascrcw.ini that shows you the old table name and new table name. If you scroll further down in the file, it will show you the old field name and the new field name.
Here are the table cross references for the Job Cost, Payroll, and Time Card Modules:
JC_01JobBillingTaxDetail=JC_JobBillingTaxDetail
JC_02JobBillingTaxSummary=JC_JobBillingTaxSummary
JC_03JobCostRetentionDetail=JC_CostRetentionDetail
JC_04OverheadAllocationWork=JC_OverheadAllocationWork
JC_H1_JobHistoryMasterfile=JC_JobHistory
JC_H2_JobCostHistoryDetail=JC_JobHistoryCostCodeDtl
JC_H3_TransactionDetailHistory=JC_JobHistoryTransDetail
JC0_Parameters=JC_Options
JC1_JobMaster=JC_Job
JC2_JobCostDetail=JC_JobCostCodeDetail
JC3_TransactionDetail=JC_JobTransactionDetail
JC4_JobFieldRptEntry=JC_JobFieldReportHeader
JC5_JobFieldRptEntry=JC_JobFieldReportDetail
JC6_TransactionDataEntry=JC_JobPostingHeader
JC7_TransactionDataEntry=JC_JobPostingDetail
JC8_DailyJobTransaction=JC_JobDailyTransactions
JC9_OverheadAllocation=JC_OverheadAllocation
JCA_JobTypMasterfile=JC_JobType
JCB_BurdenRate=JC_BurdenRate
JCC_CostCodeMaster=JC_CostCodeDetail
JCD_JobBillingsDataEntry=JC_JobBillingHeader
JCE_JobBillingsDataEntry=JC_JobBillingDetail
JCG_JobEstimateMasterfile=JC_JobEstimate
JCI_EstimateDetailLine=JC_JobEstimateDetail
JCJ_EstimateItemPrice=JC_JobEstimateItemPrice
JCK_UMConversionTable=JC_UnitOfMeasure
JCM_EstimateDetailItemPrice=JC_JobEstimateDetailAssy
JCP_JobEstimateMemo=JC_JobEstimateMemo
PR_01EmployeeDirectDeposit=PR_EmployeeDirectDeposit
PR_02DirectDepDataEntry=PR_PayrollDirectDeposit
PR_03DirectDepTransaction=PR_DirectDepositTransDetail
PR_04DirectDepBankCode=PR_DirectDepositBank
PR_05DirectDepositExtendedData=PR_DirectDepositBank
PR_15_AutoEarnings=PR_EmployeeAutoEarnings
PR_20DeptSecurity=PR_DepartmentSecurity
PR_21PayRateChgLog=PR_Audit
PR_22PerpetChkHistoryHeader=PR_PayrollHistoryHeader
PR_23PerptHistoryDetail=PR_PayrollHistoryDetail
PR_25BenfitSchedII=PR_TimeOffRateTable
PR_26EmployeeBnfitAccruals=PR_EmployeeTimeOffAccruals
PR_40FederalStateEFiling=PR_PayrollHistoryTaxReporting
PR_41FederalW2EFilingSummary=PR_EmployeeHistory
PR_90_UDF_PayrollEmployee=PR_Employee
PR_99EmployeeMasterAudit=PR_Audit
PR_ACAAleWrk=PR_ACAAleWrk
PR_ACAEmployee=PR_ACAEmployee
PR_ACAEmployeeCoveredInd=PR_ACAEmployeeCoveredInd
PR_ACAEmployer=PR_ACAEmployer
PR_ACAEmployerMonthlyDtl=PR_ACAEmployerMonthlyDtl
PR_ACAEmployerOtherMembers=PR_ACAEmployerOtherMembers
PR_ACAOfferOfCoverage=PR_ACAOfferOfCoverage
PR_ACAPolicyOrigin=PR_ACAPolicyOrigin
PR_ACASafeHarbor=PR_ACASafeHarbor
PR_ACATransitionRelief=PR_ACATransitionRelief
PR_DC_DedPostByDept=PR_DepartmentDeduction
PR_DirectDepositSvcReference=PR_DirectDepositSvcReference
PR_EC_EarnCodePostByDept=PR_DepartmentEarnings
PR_WCWorkersCompCostCode=PR_WorkersCompCostCode
PR0_Parameters=PR_Options
PR1_EmployeeMaster=PR_Employee
PR3_EmployeeTaxSummary=PR_TaxFilingStatus
PR4_EmployeeEarningDeduction=PR_EmployeeDeduction
PR6_PayrollDataEntryHeader=PR_PayrollHeader
PR7_PayrollDataEntryLine=PR_PayrollDetail
PR8_PayrollDataEntryTax=PR_PayrollTaxDetail
PRB_EarningsRegister=PR_PayrollEarningsRegister
PRC_DepartmentMaster=PR_Department
PRD_EarningsDeductionMaster=PR_DeductionCode
PRE_TaxTableGLAccounts=PR_CompanyTaxGroup
PRF_BenefitSchedule=PR_TimeOff
PRG_LaborDistributionMaster=PR_LaborCode
PRH_WorkersCompMaster=PR_WorkersComp
PRI_DeductionRegister=PR_PayrollDeductionRegister
PRJ_LaborDistributionReport=PR_PayrollLaborDistribution
PRK_EmployersTaxExpenseRpt=PR_PayrollEmployersExpenseTax
PRN_BurdenAllocationRegister=PR_PayrollBurdenAllocationReg
PRP_EmployeeMemo=PR_EmployeeMemo
TC_PNBurdenAllocationReg=JC_TimeTrackBurdenAllocReg
TC_PJLaborDistribution=JC_TimeTrackLaborDistribution
TC0_TCParameters=PR_TImeTrackOptions
TC1_TimecardMastefile=PR_TimeTrack
TC3_TimecardMastefile=PR_TimeTrackHistory
TC6_EarningsCostCode=JC_CostCodeEarningsCode
TCG_ShiftMasterfile=PR_TimeTrackShift
TCN_EmployeeMemoHistFile=PR_TimeTrackHistoryMemo
TCP_TimecardEmployeeMemo=PR_TimeTrackMemo
Comments