Invoice Report Data Sources

During the process to create invoice reports, the first part of the process is to extract the data.

The reportable data comprises:

Data sources created by a DSC zipped with the report template.

The following section contains details on the data sources for invoice reports.

Invoice Export to Report Data Sources

The data sources are dependent upon whether the returned records are to display invoice currency or laboratory currency.

Invoice Report Data Sources

The data sources are dependent upon the type of invoice (estimate, work-in-progress, preliminary/final) and the invoice's Status.

Invoice Search

Type of Currency	View
Invoice currency	CCINVOICEALLVIEW
Laboratory currency	CCINVOICEALLLABVIEW

Invoice Detail

Where ORG_CODE=<organisationCode> Or ORG_CODE=<orgCode>
And LAB_CODE=<laboratoryCode> Or LAB_CODE=<jobLabCode>
And INVOICE_NO=<invoiceNo>

Status	Table	View
	All Invoice Types	All Invoice Types
Initial	CCINVOICE	CCINVOICEVIEW
Draft	CCINVOICE	CCINVOICEVIEW
Edited	CCINVOICE	CCINVOICEVIEW
Released	CCINVOICE	CCINVOICEVIEW
Credited	CCINVOICE	CCINVOICEVIEW

Job Invoice

Where ORG_CODE=<organisationCode> Or ORG_CODE=<orgCode>
And LAB_CODE=<laboratoryCode> Or LAB_CODE=<jobLabCode>
And JOB_CODE=<jobCode>
And INVOICE_NO=<invoiceNo>

Status	Table
	All Invoice Types
Initial	CCJOBINVOICE
Draft	CCJOBINVOICE
Edited	CCJOBINVOICE
Released	CCJOBINVOICE
Credited	CCJOBINVOICE

Job Invoice Sample

Where ORG_CODE=<organisationCode> Or ORG_CODE=<orgCode>
And LAB_CODE=<laboratoryCode> Or LAB_CODE=<jobLabCode>
And JOB_CODE=<jobCode>
And INVOICE_NO=<invoiceNo>

Status	Table
	All Invoice Types
Initial	CCJOBINVOICESAMPLE
Draft	CCJOBINVOICESAMPLE
Edited	CCJOBINVOICESAMPLE
Released	CCJOBINVOICESAMPLE
Credited	CCJOBINVOICESAMPLE

Job Invoice Scheme

Where ORG_CODE=<organisationCode> Or ORG_CODE=<orgCode>
And LAB_CODE=<laboratoryCode> Or LAB_CODE=<jobLabCode>
And JOB_CODE=<jobCode>
And INVOICE_NO=<invoiceNo>

Status	Table
	All Invoice Types
Initial	CCJOBINVOICESCHEME
Draft	CCJOBINVOICESCHEME
Edited	CCJOBINVOICESCHEME
Released	CCJOBINVOICESCHEME
Credited	CCJOBINVOICESCHEME

Job Invoice Scheme Analyte

Where ORG_CODE=<organisationCode> Or ORG_CODE=<orgCode>
And LAB_CODE=<laboratoryCode> Or LAB_CODE=<jobLabCode>
And JOB_CODE=<jobCode>
And INVOICE_NO=<invoiceNo>

Status	Table
	All Invoice Types
Initial	CCJOBINVOICESCHEMEANALYTE
Draft	CCJOBINVOICESCHEMEANALYTE
Edited	CCJOBINVOICESCHEMEANALYTE
Released	CCJOBINVOICESCHEMEANALYTE
Credited	CCJOBINVOICESCHEMEANALYTE

Job Invoice Excluded SS

Where ORG_CODE=<organisationCode> Or ORG_CODE=<orgCode>
And LAB_CODE=<laboratoryCode> Or LAB_CODE=<jobLabCode>
And JOB_CODE=<jobCode>
And INVOICE_NO=<invoiceNo>

Status	Table
	All Invoice Types
Initial	CCJOBINVOICEEXCLUDEDSS
Draft	CCJOBINVOICEEXCLUDEDSS
Edited	CCJOBINVOICEEXCLUDEDSS
Released	CCJOBINVOICEEXCLUDEDSS
Credited	CCJOBINVOICEEXCLUDEDSS

Job Invoice Excluded SSA

Where ORG_CODE=<organisationCode> Or ORG_CODE=<orgCode>
And LAB_CODE=<laboratoryCode> Or LAB_CODE=<jobLabCode>
And JOB_CODE=<jobCode>
And INVOICE_NO=<invoiceNo>

Status	Table
	All Invoice Types
Initial	CCJOBINVOICEEXCLUDEDSSA
Draft	CCJOBINVOICEEXCLUDEDSSA
Edited	CCJOBINVOICEEXCLUDEDSSA
Released	CCJOBINVOICEEXCLUDEDSSA
Credited	CCJOBINVOICEEXCLUDEDSSA

Job Invoice Price Adjustment

Where ORG_CODE=<organisationCode> Or ORG_CODE=<orgCode>
And LAB_CODE=<laboratoryCode> Or LAB_CODE=<jobLabCode>
And JOB_CODE=<jobCode>
And INVOICE_NO=<invoiceNo>

Status	Table
	All Invoice Types
Initial	CCJOBINVOICEPRICEADJUSTMENT
Draft	CCJOBINVOICEPRICEADJUSTMENT
Edited	CCJOBINVOICEPRICEADJUSTMENT
Released	CCJOBINVOICEPRICEADJUSTMENT
Credited	CCJOBINVOICEPRICEADJUSTMENT

Job Invoice Tax

Where ORG_CODE=<organisationCode> Or ORG_CODE=<orgCode>
And LAB_CODE=<laboratoryCode> Or LAB_CODE=<jobLabCode>
And JOB_CODE=<jobCode>
And INVOICE_NO=<invoiceNo>

Status	Table
	All Invoice Types
Initial	CCJOBINVOICETAX
Draft	CCJOBINVOICETAX
Edited	CCJOBINVOICETAX
Released	CCJOBINVOICETAX
Credited	CCJOBINVOICETAX

Line Item for Pricing

Where ORG_CODE=<organisationCode> Or ORG_CODE=<orgCode>
And LAB_CODE=<laboratoryCode> Or LAB_CODE=<jobLabCode>
And INVOICE_NO=<invoiceNo>
And IS_BASE_PRICE=B (base price) Or IS_BASE_PRICE=I (interval price)

Status	Table	View
	All Invoice Types	Estimate	Work-in-progress
Initial
Draft	CCINVOICEITEM	CCPEINVESTVIEW	CCPEINVWIPVIEW
Edited	CCINVOICEITEM	CCPEINVESTVIEW	CCPEINVWIPVIEW
Released	CCINVOICEITEM	CCPEINVESTVIEW	CCPEINVWIPVIEW
Credited	CCINVOICEITEM	CCPEINVESTVIEW	CCPEINVWIPVIEW

Note: The PriceCode InvoiceNotes (as .NOTE property) are not populated in this view. The Sequence properties for all of the invoice line items are fixed to be the same sequence in this view.

Line Item for Sample

Where ORG_CODE=<organisationCode> Or ORG_CODE=<orgCode>
And LAB_CODE=<laboratoryCode> Or LAB_CODE=<jobLabCode>
And INVOICE_NO=<invoiceNo>

Status	Table
	All Invoice Types
Initial
Draft	CCINVOICEITEMSAMPLE
Edited	CCINVOICEITEMSAMPLE
Released	CCINVOICEITEMSAMPLE
Credited	CCINVOICEITEMSAMPLE

Line Item for Price Adjustment

Where ORG_CODE=<organisationCode> Or ORG_CODE=<orgCode>
And LAB_CODE=<laboratoryCode> Or LAB_CODE=<jobLabCode>
And INVOICE_NO=<invoiceNo>
And IS_BASE_PRICE=S (surcharge item) Or IS_BASE_PRICE=R (rebate item)

Status	Table	View
	All Invoice Types	Estimate	Work-in-progress	Preliminary/Final
Initial
Draft		CCPEINVREBESTVIEW	CCPEINVREBWIPVIEW	CCPEINVREBINVVIEW
Edited		CCPEINVREBESTVIEW	CCPEINVREBWIPVIEW	CCPEINVREBINVVIEW
Released	CCINVOICEITEM	CCPEINVREBESTVIEW	CCPEINVREBWIPVIEW	CCPEINVREBINVVIEW
Credited	CCINVOICEITEM	CCPEINVREBESTVIEW	CCPEINVREBWIPVIEW	CCPEINVREBINVVIEW

Line Item for Discount

Where ORG_CODE=<organisationCode> Or ORG_CODE=<orgCode>
And LAB_CODE=<laboratoryCode> Or LAB_CODE=<jobLabCode>
And INVOICE_NO=<invoiceNo>
And IS_BASE_PRICE=D (discount item)

Status	Table	View
	All Invoice Types	Estimate	Work-in-progress	Preliminary/Final
Initial
Draft		CCPEINVDISCESTVIEW	CCPEINVDISCWIPVIEW	CCPEINVDISCINVVIEW
Edited		CCPEINVDISCESTVIEW	CCPEINVDISCWIPVIEW	CCPEINVDISCINVVIEW
Released	CCINVOICEITEM	CCPEINVDISCESTVIEW	CCPEINVDISCWIPVIEW	CCPEINVDISCINVVIEW
Credited	CCINVOICEITEM	CCPEINVDISCESTVIEW	CCPEINVDISCWIPVIEW	CCPEINVDISCINVVIEW

Line Item for Tax

Where ORG_CODE=<organisationCode> Or ORG_CODE=<orgCode>
And LAB_CODE=<laboratoryCode> Or LAB_CODE=<jobLabCode>
And INVOICE_NO=<invoiceNo>
And IS_BASE_PRICE=T (tax item)

Status	Table	View
	All Invoice Types	Estimate	Work-in-progress	Preliminary/Final
Initial
Draft		CCPEINVTAXESTVIEW	CCPEINVTAXWIPVIEW	CCPEINVTAXINVVIEW
Edited		CCPEINVTAXESTVIEW	CCPEINVTAXWIPVIEW	CCPEINVTAXINVVIEW
Released	CCINVOICEITEM	CCPEINVTAXESTVIEW	CCPEINVTAXWIPVIEW	CCPEINVTAXINVVIEW
Credited	CCINVOICEITEM	CCPEINVTAXESTVIEW	CCPEINVTAXWIPVIEW	CCPEINVTAXINVVIEW