Updating the Cross-Reference Table: Projects/Billing Interface Process

The system inserts PBI rows into the CA_BP_XREF table after the invoices represented by those rows have been finalized in PeopleSoft Billing. The system inserts one row for each combination of CONTRACT_NUM, BILL_PLAN_ID, EVENT_OCCURRENCE, CONTRACT_LINE_NUM, BUSINESS_UNIT_PC, PROJECT, BI_CURRENCY_CD, and INVOICE.

Note:

Although only certain project activities pertain to particular contract lines, the system does not store the activity in CA_BP_XREF. Activities are summarized by project and billing currency.

This table shows which fields are updated at each stage:

Field	NEW	RCV	ACP	DEL	FIN
CONTRACT_NUM					X
BILL_PLAN_ID					X
XREF_SEQ_NUM					X
XREF_STATUS					X
SYSTEM_SOURCE					X
EVENT_OCCURRENCE					Maybe
BPLAN_LN_NBR
CONTRACT_LINE_NUM					X
NET_AMOUNT
GROSS_AMOUNT
BI_CURRENCY_CD					X
BUSINESS_UNIT_BI					X
PROCESS_INSTANCE
TEMP_INVOICE
INVOICE					X
INVOICE_TYPE					X
INVOICE_DT					X
NET_EXTENDED_AMT					X
GROSS_EXTENDED_AMT					X
CONTRACT_PPD_SEQ
BUSINESS_UNIT_PC					X
PROJECT					X
LASTUPDDTTM					X
LASTUPDOPRID					X