Spectrum Crystal-Link Reports Files

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 will be stored in F:\SPECTRUM\REPORTS. Note that, 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.

All Crystal-Link reports available in version 11 are listed in a table shown below.

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

A/P Aged Payables Report

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