Understanding Data Originating from PeopleSoft Project Costing (PBI System Source)
This table shows the life cycle of project transaction rows that are eligible for billing. This table starts after the transaction is priced:
Process |
Billing Distribution Status |
Cross-reference Status |
Analysis Type Rows Inserted into the Project Transaction Temporary Billing Table |
---|---|---|---|
Start |
P (priced) |
NA (not applicable) |
NA |
Contracts-Billing Interface (Billing Engine) |
W, if action finishes S, if action ends abnormally |
NA |
NA |
Billing Interface |
NA |
NA |
NA |
Accept Worksheet |
NA |
NA |
OLT (over the limit) DEF (defer) WTO (write off) WWO (withholding write-off) |
Delete Worksheet |
P |
NA |
NA |
Billing Finalization |
NA |
NA |
NA |
Project Costing-Contracts Interface (see note) |
D (distributed) |
FIN (finalized) |
BAJ (billing adjustment) BRT (billing retainage) DSC (billing discount) |
Note: The Project Costing-Contracts Interface process calls the Contracts Billing Update Application Engine process (CA_BI_UPD), which updates the Billing Plan Event Status field to DON (completed) if all rows for the event have a Cross-reference Status field value of FIN in the Contracts-Billing Cross-reference table. The system updates the Billing Plan Status field to DON if all events are completed.