Updating the Cross-Reference Table: Contracts Billing Interface Process
PeopleSoft Contracts billing (CBI) rows are initially inserted in the CA_BP_XREF table by the Contracts Billing Interface process. The system then updates these rows at various stages in the billing process. 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 |
X |
X |
X |
X |
|
SYSTEM_SOURCE |
X |
|
|
|
|
|
EVENT_OCCURRENCE |
X |
|
|
|
|
|
BPLAN_LN_NBR |
X |
|
|
|
|
|
CONTRACT_LINE_NUM |
|
|
|
|
|
|
NET_AMOUNT |
X |
|
|
|
|
|
GROSS_AMOUNT |
X |
|
|
|
|
|
BI_CURRENCY_CD |
X |
|
|
|
|
|
BUSINESS_UNIT_BI |
X |
|
|
|
|
|
PROCESS_INSTANCE |
X |
|
|
|
|
|
TEMP_INVOICE |
|
X |
X |
|
|
|
INVOICE |
|
|
X |
|
|
|
INVOICE_TYPE |
|
|
|
|
X |
|
INVOICE_DT |
|
|
|
|
X |
|
NET_EXTENDED_AMT |
|
|
|
|
X |
|
GROSS_EXTENDED_AMT |
|
|
|
|
X |
|
CONTRACT_PPD_SEQ |
Maybe |
|
|
|
|
|
BUSINESS_UNIT_PC |
|
|
|
|
|
|
PROJECT |
|
|
|
|
|
|
LASTUPDDTTM |
X |
X |
X |
X |
X |
|
LASTUPDOPRID |
X |
X |
X |
X |
X |
|
CHG_ID |
X |
|
|
|
|