Spectrum Crystal-Link Reports Files
A table of all Crystal-Link reports.
Each Crystal-Link report program is stored as a file with the extension "RPT". These files are typically stored in the same directory as the Spectrum program and data files.
For example, if your main Spectrum directory on the network is F:\SPECTRUM, the Crystal-Link report files are stored in F:\SPECTRUM\REPORTS.
If you are using Remote-Link, you may store the Crystal RPT files on your local directory to improve performance over the wide-area network. Your system administrator can set this up in the operator security area of Spectrum.
| Crystal Report File | Description | Spectrum File Name / Alternate Name Used in Crystal Reports |
|---|---|---|
| Ap1099.rpt | 1099 laser form | VN.1099C / VN_TEMP_1099 |
| Ap1099mk.rpt | 1099 laser alignment mask | None |
| Apapp.rpt | A/P Invoice Approval Performance Report | VN_TEMP_INVOICE_APPROVAL_HDR |
| Apcheck.rpt | A/P Check Print |
VN.TMPCD / VN_TEMP_CHECK_DETAIL VN.TMPCH / VN_TEMP_CHECK_HEADER |
| Apcheck.rpt | AP Instant Check | |
| Apckmsk.rpt | A/P Check alignment mask | None |
| Apgldis1.rpt | A/P G/L Distribution Report | VN.TDGL / VN_TEMP_GL_DIST_REP |
| Aplien1.rpt | A/P Lien Release | VN.TMPLR / VN_TEMP_LIEN_CRYSTAL |
| Apremit.rpt | A/P Remittance Advice |
VN.TMPCD / VN_TEMP_CHECK_DETAIL VN.TMPCH / VN_TEMP_CHECK_HEADER |
| Apscolg1.rpt | A/P Subcontract Change Order Log |
VN.TMPC2 / VN_TEMP_CO_CR_LIST VN.TMPCO / VN_TEMP_CO_HEADER CR.CRH / CR_CHNG_REQ_HDR VN.CRSH / VN_CHNG_REQ_SUB_HDR VN.SCON / VN_CHNG_REQ_SUB_NOTES |
| Apscolg2.rpt | A/P Sub CO Log – Pricing Detail | |
| Apscrlg1.rpt | A/P Subcontract Detail CR Log | |
| Apsub1.rpt | A/P Subcontract Print |
VN.TMPSH/VN_TEMP_SUBCONTRACT_HEADER VN.TMPSD / VN_TEMP_SUBCONTRACT_DETAIL |
| Apsubco.rpt | A/P subcontract change order print |
VN.TMPCO / VN_TEMP_CO_HEADER VN.CONO / VN_CO_NOTES_HISTORY |
| Aptreg1.rpt | A/P Transaction Register |
VN.TREG / VN_TEMP_TRAN_REGISTER VN.HDR / VN_INVOICE_TRAN_HEADER VN.MSTR / VN_VENDOR_MASTER GL_MSTR / GL_MASTER_MC JC_JOB / JC_JOB_MASTER_MC |
| Aptreg2.rpt | A/P Detail Trans. Reg. By Vendor | |
| Aptreg3.rpt | A/P Summary Trans. Reg by Vendor | |
| Apvlbls.rpt | A/P Vendor Master File Labels | VN.TMPVL / VN_TEMP_VEN_LABELS |
| Arclbls.rpt | A/R Customer Labels | CR.TMPCL / CR_TEMP_CUST_LABELS |
| Arclbls.rpt | A/R Customer Label Mask | CR.TMPCL / CR_TEMP_CUST_LABELS |
| Arco.rpt | A/R change Order Print |
CR.TMPCO / CR_Temp_CO_Header CR.CONO / CR_Change_Order_Notes |
| Arcrp1.rpt | CR Proposal Form |
CR.CRHTM / CR_TMP_CHNG_REQ_HDR CR.CRTCD / CR_TMP_CHNG_REQ_COST_DET CR.CNTR / CR_CONTRACT_MASTER JC.JOB / JC_JOB_MASTER |
| Arcrp2.rpt | CR Proposal Form with Pricing Detail | |
| Arcrp3.rpt | Change Request Proposal Letter |
CR.CRHTM / CR_TMP_CHNG_REQ_HDR CR.PJNTM / CR_TMP_CHNG_REQ_LOG_DET CR.MSTR / CR_CUSTOMER_MASTER CR.CNTR / CR_CONTRACT_MASTER JC.JOB / JC_JOB_MASTER |
| Arco2.rpt | AR CO Print – Unit Price |
CR.TMPCO / CR_Temp_CO_Header CR.CONO / CR_Change_Order_Notes |
| Arage1.rpt | A/R Aged Open Items Report by Date |
CR.TMPC / CR_TEMP_AGING_REP2 CR.MSTR / CR_CUSTOMER_MASTER |
| Arage2.rpt | A/R Aged Open Items Report by Tran. # | |
| Arcolog.rpt | A/R Change Order Log |
CR.MSTR / CR_CONTRACT_MASTER CR.TMPCO / CR_TEMP_CO_HEADER CR.CONO / CR_CHANGE_ORDER_NOTES CR.STAT / CR_CHANGE_ORDER_STATUS |
| Arcopr1.rpt | A/R Change Order Profit Detail |
CR.CNTR / CR_CONTRACT_MASTER CR.TMPCO / CR_TEMP_CO_HEADER CR.COTCD / CR_TMP_CHNG_ORD_COST_DET |
| Arcopr2.rpt | A/R Change Order Profit Summary | |
| Arcrc1.rpt | A/R Change Request With Pricing Detail |
CR.COTCD / CR_TMP_CHNG_ORD_COST_DET CR.CRHTM / CR_TMP_CHNG_REQ_HDR CR.CNTR / CR_CONTRACT_MASTER |
| Arcrc2.rpt | A/R Change Request Profit Detail | |
| Arcrc3.rpt | A/R Change Request Profit Summary | |
| Arcrlog.rpt | A/R Change Request Log |
CR.CRHTM / CR_TMP_CHNG_REQ_HDR CR.PJNTM / CR_TMP_CHNG_REQ_LOG_DET CR.CNTR / CR_CONTRACT_MASTER |
| Arcrlog2.rpt | A/R Change Log Price Summary | |
| Ardrawg1.rpt | Draw request print – general contractor |
CR.TMPDH / CR_Temp_Draw_Header CR.TMPDL / CR_Temp_Draw_Detail |
| Ardrawg2.rpt | Same but with total customer balance | |
| Ardraws1.rpt | Draw request print – sub-contractor | |
| Ardraws2.rpt | Same but with total customer balance | |
| Arinv.rpt | A/R invoice form |
CR.INVTM / CR_Invoice_Temp CR.TMPID / CR_Temp_Invoice_Detail |
| Arinv2.rpt | A/R invoice form – mailer format | |
| Arret.rpt | A/R Retention Invoice |
CR.TMPRH / CR_RET_INVOICE_TEMP CR.TMPRD / CR_TEMP_RET_INVOICE_DETAIL |
| Arstmt1.rpt | A/R statement – standard format |
CR.TMPSH / CR_Temp_Statement_Header CR.TMPSD / CR_Temp_Statement_Detail |
| Arstmt2.rpt | A/R statement – past due format | |
| Arwo.rpt | A/R work order invoice |
CR.TMPWH / CR_Temp_WO_Header CR.TMPWD / CR_Temp_WO_Detail |
| Apcheck.rpt | Direct Check Instant Print |
VN.TMPCH / VN_TEMP_CHECK_HEADER VN.TMPCD / VN_TEMP_CHECK_DETAIL |
| Cpqst_d.rpt | CP Detail State, County, and Local Report |
CP.QSTTP / CP_TEMP_QTR_STATE_TAX_REP PR.INCTX / PR_INCOME_TAX_TABLE |
| Cpqst_s.rpt | CP Summary State, County, and Local Report | |
| Cpunion1.rpt | CP Union Report – Extended Format |
CP.TMPUH / CP_TEMP_UNION_HEADING CP.UNION / CP_TEMP_UNION_SUMMARY |
| Cpunion2.rpt | CP Union Report – Employee Fringe Detail | |
| Cputr_d.rpt | CP Unemployment Tax Report |
CP.ITFL / CP_TEMP_UNEMPLOYEMENT_REP PR.INCTX / PR_INCOME_TAX_TABLE |
| Disrch1.rpt | Document Search Listing |
DI.TMPSH / DI_TEMP_SEARCH_RESULTS DI.MSTR / DI_MASTER |
| Gltb1.rpt | G/L detail trial balance |
GL.TMPTH / GL_Temp_Trial_Bal_Header GL.TMPTD / GL_Temp_TB_Detail |
| Gltb2.rpt | G/L summary trial balance | |
| Pausrfld.rpt | G/L User-Defined Fields Listing | PA.TUDFH / PA_TEMP_USER_DEFINED_HDR |
| Immstlbl.rpt | IM Inventory Master Label Print | IM.TMPFL / IM_TEMP_FILE_LABELS |
| Immstlbl.rpt | Inventory Master Label Print Mask | |
| Imjcent.rpt | Job Requisition Form |
IM.TMPRD / IM_REQUSITION_DETAIL_TMP IM.TMPRH / IM_REQUSITION_HEADER_TMP |
| Imjrpt.rpt | Job Requisition Report | |
| Jcjobl1.rpt | Standard Job File Listing |
JC.TMPJB / JC_TEMP_JOB_LISTING JC.JOB / JC_JOB_MASTER |
| Jcjobl2.rpt | Complete Job File Listing | |
| Jcjobl3.rpt | Job File Listing with Contract Amount | |
| Jcanal.rpt | Job Cost Analysis Report – detail option |
JC.TANLG / JC_TEMP_GROUP JC.JOB / JC_JOB_MASTER JC.PHSE / JC_PHASE_MASTER JC.COST / JC_COST_TYPE_MASTER PA.CLPAR / CL_TEMP_REPORT_PARAMETERS |
| Jcanal2.rpt | Job Cost Analysis Report – summary option | |
| Jcanal3.rpt | Job Cost Analysis Report – labor analysis option (same as Job cost labor analysis report) | |
| Jccstat1.rpt | Job Cost Contract Status Report - expanded, active jobs | JC.TMPCS / JC_TEMP_CON_STATUS |
| Jccstat2.rpt | Job Cost Contract Status Report – expanded, all jobs | |
| Jccstat3.rpt | Job Cost Contract Status Report – expanded, with backlog information | |
| Jccstat4.rpt | Job cost backlog and six month forecast of job revenue and gross profit | |
| Jccstat5.rpt | Monthly Contract Status – Active Jobs | |
| Jccstat6.rpt | Monthly Contract Status – All Jobs | |
| Jchist1.rpt | JC History Report | JC.TMPHS / JC_TEMP_JC_HIST_REP |
| Jchist2.rpt | JC History Report – Recap | |
| Jchist3.rpt | JC History Report – Summary with Recap | |
| Jchist4.rpt | JC History Drill-Down Report |
JC.TMPHS / JC_TEMP_JC_HIST_REP JC.JOB / JC_JOB_MASTER |
| Jcover1.rpt | JC Job Overview Report |
JC.SATMP / JC_JOB_SUM_ANAL_INQ JC.SASTM / JC_TEMP_SUM_ANAL_TOTALS CR.MSTR / CR_CUSTOMER_MASTER JC.JOB / JC_JOB_MASTER |
| Jcover2.rpt | JC Detail Overview by Cost Type | |
| Jcover3.rpt | JC Detail Overview by Phase | |
| Jcover4.rpt | Detail JTD Cost Variance by CT Group |
JC.TMPOV / JC_TEMP_OVERVIEW_2 JC.SASTM / JC_TEMP_SUM_ANAL_TOTALS CR.MSTR / CR_CUSTOMER_MASTER JC.JOB / JC_JOB_MASTER |
| Jcover5.rpt | Detail JTD Hours Variance by CT Group | |
| Jcprof.rpt | JC Job Profitability Report | JC.TMPJP / JC_TEMP_PROF |
| Opinv.rpt | Order Processing Invoice |
IN.TMPIH / IN_Temp_Invoice_Header IN.TMPID / IN_Temp_Invoice_Detail |
| Opshplbl.rpt | Order Entry Shipping Labels | OE.TMPSL / OE_TEMP_SHIP_LABELS |
| Opquote1.rpt | Standard Quote Report |
OE.TMPQH / OE_TEMP_QUOTE_HEADER OE.TMPQD / OE_TEMP_QUOTE_DETAIL |
| Opquote2.rpt | Quote Report with Haulers |
OE.TMPQH / OE_TEMP_QUOTE_HEADER OE.TMPQD / OE_TEMP_QUOTE_DETAIL |
| Oppick.rpt | Picking Sheet Print |
OE.TMSUM / OE_TMP_CRYSTAL_HDR OE.TMDET / OE_TMP_CRYSTAL_DET |
| Opinv1.rpt | OP Invoice Print |
IN.TMPIH / IN_TEMP_INVOICE_HEADER IN.TMPID / IN_TEMP_INVOICE_DETAIL |
| Opinv2.rpt | OP Invoice – Suppress Zero Lines | |
| Pjfldd.rpt | Quick Request for Information Print | PJ.TMPFL / PJ_TEMP_PROJECT_FIELD_QN |
| Pjmemo.rpt | Quick Memo Print |
PJ.TMMED / PJ_TEMP_SPEED_MEMO_DET PJ.TMMEH / PJ_TEMP_SPEED_MEMO_HDR |
| Pjtran.rpt | Quick Transmittal Print |
PJ.TMPTD / PJ_TEMP_PROJ_TRANSMITTL_DET PJ.TMPTH / PJ_TEMP_PROJ_TRANS_HDR |
| Pjsust.rpt | Submittal Status Listing | PJ.TMPST / PJ_TEMP_SUBMITTAL_STATUS |
| Pastdnml.rpt | Standard Message Listing | PA.TNOTS / PA_TEMP_NOTES_STD_TEXT |
| Pjarea.rpt | PJ Area Listing | PJ.TMPAR / PJ_TEMP_PROJECT_AREA |
| Pjbld.rpt | PJ Building Listing | PJ.TMPBL / PJ_TEMP_PROJECT_BUILDING |
| Pjclog.rpt | PJ Custom Issues Log | PJ_TEMP_CUST_ISSUE_HDR |
| Pjdir.rpt | PJ Directory Listing |
PJ.TMPDH / PJ_TEMP_PROJECT_DIR_HDR PJ.TMPDD / PJ_TEMP_PROJECT_DIR_DET |
| Pjemp.rpt | PJ Employee Listing |
PJ.TMPEH / PJ_TEMP_EMPLOYEE_HEADER PJ.YMPED / PJ_TEMP_EMPLOYEE_DETAIL |
| Pjfdis.rpt | PJ Document Change Transmittal |
PJ.TMFDD / PJ_TEMP_PROJ_FQ_DISN_HDR PJ.TMFDH / PJ_TEMP_PROJ_FQ_DISN_DET |
| Pjfldd.rpt | PJ Field Question / RFI Print – 1 per page | PJ.TMPFL / PJ_TEMP_PROJECT_FIELD_QN |
| Pjflds.rpt | PJ Field Question / RFI Print – 1 per line | |
| Pjlogd.rpt | PJ Daily Log Print | PJ.TMPDA / PJ_TEMP_DAILY_REPORT |
| Pjlogs.rpt | PJ Quick Daily Log Print | |
| Pjmemo.rpt | PJ Speed Memo Print |
PJ.TMMED / PJ_TEMP_SPEED_MEMO_HDR PJ.TMMEH / PJ_TEMP_SPEED_MEMO_DET |
| Pjmlog.rpt | PJ Speed Memo Log | PJ.TMMED / PJ_TEMP_SPEED_MEMO_HDR |
| Pjphn.rpt | PJ Phone Listing | PJ.TMPPH / PJ_TEMP_PROJECT_PHONE |
| Pjproj.rpt | PJ Project Listing | PJ.TMPPR / PJ_TEMP_PROJECT_MASTER |
| Pjpurg.rpt | PJ Project Purge Report | PJ.TMPPR / PJ_TEMP_PROJECT_MASTER |
| Pjslet.rpt | PJ Submittal Letter to Subcontractor | PJ.TMLET / PJ_TEMP_PROJ_SUBM_LET |
| Pjslog.rpt | PJ Submittal Log – 1 per line | PJ.TMLOG / PJ_TEMP_PROJ_SUBM_LOG |
| Pjstrn.rpt | PJ Submittal Transmittal | PJ.TMSUT / PJ_TEMP_PROJ_SUBM_TRANSMIT |
| Pjsumd.rpt | PJ Executive Overview Listing – 1 per page |
PJ.TMEXH / PJ_TEMP_PROJ_SUMMARY PJ.TMPTR / PJ_TEMP_PROJECT_TRADE_TOT |
| Pjsums.rpt | PJ Executive Overview Log – 1 per line | |
| Pjtlog.rpt | PJ Transmittal Log | PJ.TMPTO / PJ_TEMP_PROJ_TRANSMITTL_HDR |
| Pjtran.rpt | PJ Transmittal Print |
PJ.TMPTO / PJ_TEMP_PROJ_TRANSMITTL_HDR PJ.TMPTH / PJ_TEMP_PROJ_TRANSMITTL_DET |
| Porhist1.rpt | PO Receiving History |
PO.TMPH / PO_TEMP_REC_HISTORY PO.HDR / PO_PURCHASE_ORDER_HEADER VN.MSTR / VN_VENDOR_MASTER JC.JOB / JC_JOB_MASTER |
| Poprop.rpt | Proposed Purchase Order |
PO.TMPPH / PO_TEMP_PO_HEADER PO.TMPPD / PO_TEMP_PO_DETAIL |
| Po.rpt | Purchase order print |
PO.TMPPH / PO_Temp_PO_Header PO.TMPPD / PO_Temp_PO_Detail |
| Prcert1.rpt | Certified Payroll Report – standard format |
PR.CERT / PR_TEMP_CERTIFIED_1 PR.CERT2 / PR_TEMP_CERTIFIED_2 PR.CERT3 / PR_TEMP_CERTIFIED_3 PR.COVER / PR_CERTIFIED_COVER_SHEET |
| Prcert3.rpt | Certified Payroll Report – expanded format | |
| Prcheck.rpt | Payroll laser check | PR.TMPCH / PR_TEMP_CHECK_PRINT |
| Prcheck1.rpt | Payroll laser check – with multiple auto-deposit information | |
| Prcheck2.rpt | PR Check – Mult. Auto. Dep. - Alternate | |
| Prckmsk.rpt | Payroll laser alignment mask | None |
| Prqst_d.rpt | Payroll detail State, County, and Local Report |
PR.QSTTP / PR_TEMP_QTR_STATE_TAX_REP PR.INCTX / PR_INCOME_TAX_TABLE |
| Prqst_s.rpt | Payroll summary State, County, and Local Report | |
| Prtcedt1.rpt | Payroll timecard and pre-timecard edit list by employee | PR.TMPTC / PR_TEMP_TIME_CARD |
| Prtcedt2.rpt | Payroll timecard and pre-timecard edit list by job | |
| Prtcedt3.rpt | Payroll timecard and pre-timecard edit list by employee with add-ons and deductions | |
| Prunion1.rpt | Union report – standard format |
PR.TMPUH / PR_Temp_Union_Heading PR.UNION / PR_Union_Summary |
| Prunion2.rpt | Union report – with fringe detail by employee | |
| Prutr_d.rpt | Payroll Unemployment Tax Report |
PR.ITFL / PR_TEMP_UNEMPLOYMENT_REP PR.EM1 / PR_EMPLOYEE_MASTER_1 PR.INCTX / PR_INCOME_TAX_TABLE |
| Prw2lst2.rpt | W-2 Listing by Employee Name | PR.W2CTM / PR_TEMP_W2_FORM_PRINT |
| Prw2lst.rpt | W-2 Listing by Control Number | |
| Prw2.rpt | W-2 Laser 4-up | |
| Prw2msk.rpt | W-2 Alignment Mask 4-up | None |
| Prw2pp.rpt | W-2 Plain Paper | PR.W2CTM / PR_TEMP_W2_FORM_PRINT |
| Prw2_2up.rpt | Payroll W2 2-up laser format | PR.W2CTM / PR_TEMP_W2_FORM_PRINT |
| Prw2msk2.rpt | Payroll W2 2-up mask | None |
| Prw3.rpt | Payroll W3 laser format | PR.W2CTM / PR_TEMP_W2_FORM_PRINT |
| Prw3msk.rpt | Payroll W3 laser mask | None |
| Prdal.rpt | Deduction / Add-on Code Listing | PR.TVDD / PR_TEMP_DEDUCT_LIST_HDR |
| Pausrfld.rpt | Employee User – Defined Fields Listing | PA.TUDFH / PA_TEMP_USER_DEFINED_HDR |
| Prcheck.rpt | Payroll Layoff Check Print | PR.TMPCH / PR_TEMP_CHECK_PRINT |
| Prcheck.rpt | Replacement Check Print | PR.TMPCH / PR_TEMP_CHECK_PRINT |
| Scslab.rpt | SC System Labels | SC.TMPSL / SC_TEMP_SYSTEM_LABEL |
| Sistrd.rpt | Detail Scale Ticket Edit Listing |
SI.TTICS / SI_TEMP_TICKET_SUMMARY SI.TTICD / SI_TEMP_TICKET_DETAIL |
| Sistrs.rpt | Summary Scale Ticket Edit Listing | SI.TTICS / SI_TEMP_TICKET_SUMMARY |
| Siticket.rpt | Print Ticket |
SI.TTICS / SI_TEMP_TICKET_SUMMARY SI.TTICD / SI_TEMP_TICKET_DETAIL |
| Sistrs_h.rpt | Summary Scale Ticket Report |
SI.TTICS / SI_TEMP_TICKET_SUMMARY PA.COMM2 / CL_TEMP_VARIABLES_2 |
| Sistrd_h.rpt | Detail Scale Ticket Report |
SI.TTICS / SI_TEMP_TICKET_SUMMARY SI.TTICD / SI_TEMP_TICKET_DETAIL PA.COMM2 / CL_TEMP_VARIABLES_2 |
| Sifrh.rpt | Freight Recon History | SI.TMPFI / SI_TEMP_FRT_INVOICE_HIST |
| Tmbld1nm.rpt | TM Detail Billing – No Markups | TM.TMPBD / TM_TEMP_BILLING |
| Tmbld1_d.rpt | TM Detail Billing – With Markups | |
| Tmhpd1nm.rpt | T+M detail history, no markups |
TM.BILHA / TM_HISTORY_BILLING_ADD_ON TM.BILHF / TM_HISTORY_BILLING_FEES TM.BILTM / TM_HIST_DETAIL_TEMP |
| Tmhpd1_d.rpt | T+M detail history, with markups | |
| Tmhpd1_j.rpt | T+M job-to-date detail history for one job | |
| Wodisp.rpt | Work Order dispatch schedule listing | WO.TMPDR / WO_TEMP_DISPATCH_REPORT |
| Work Order Print with Technicians | ||
| Woprint.rpt | Work Order print |
WO_TEMP_PRINT_HEADER WO_TEMP_PRINT_DETAIL |
| Woprof1.rpt | Work order profitability report |
WO.TMPPH / WO_TEMP_HISTORY_HEADER WO.TMPPD / WO_TEMP_HISTORY_DETAIL |
| Woprof2.rpt | Work order budget variance report (for flat rate work orders) | |
| Woprof3.rpt | Work order detail profitability report | |
| Woprof4.rpt | Work order detail budget variance report (for flat rate work orders) | |
| All RPT files | Common report parameters | PA.COMMN / CL_TEMP_VARIABLES |
