Billing to Project Costing Process (PC_BI_TO_PC)

Run the Billing to Project Costing process for rate-based contract lines to update the Project Transaction table with results from PeopleSoft Contracts and PeopleSoft Billing processes, including adjustments, discounts, retainages, withholdings, and so forth.

PeopleSoft Billing processes write bill rows to the Project Transaction Temporary Billing table. The Billing to Project Costing process moves the rows from the Project Transaction Temporary Billing table to the Project Transaction table, either in the form of updates to existing rows or as new inserted rows. The process uses the PSBLD (Billing to Projects) analysis group to determine which rows to process and how to process the rows coming from PeopleSoft Billing.

This table lists how transactions are handled:

Description	Analysis Type of Source Transaction Row	Analysis Type of New or Updated Transaction Row	Billing Distribution Status After Billing to Project Costing Process
Bill row	BIL (billable amount)	BLD (billed amount)	D (distributed)
Write off	WTO (see note)	WTO	I (ignore)
Deferral	DEF (see note)	DEF	P (priced)
Over limit	OLT (see note)	OLT	P
Billing retainage	BRT	BRT (multiplier of –1)	P
Billing adjustment	BAJ	BAJ	D
Released billing retainage	RRT	RRT	D
Released retainage adjustment	RAJ	RAJ	D
Billing discount	DSC	DSC (multiplier of –1)	D
Prepaid bill row	BIL - with source type of CBI (Contracts to Billing Interface)	BLD	D
Prepaid utilization for billing	UTL	UTL (multiplier of –1)	I
Prepaid utilization adjustment	UAJ	UAJ (multiplier of –1)	I
Prepaid utilization adjustment	UTL	UAJ (multiplier of –1)	I
Fixed fee	BIL - with source type of CBI	BLD	D
Withholding	WTH	WTH (multiplier of –1)	D
Withholding adjustment	WAJ	WAJ (multiplier of –1)	D
Withholding release	WRL	WRL	D
Withholding release adjustment	WRJ	WRJ	D
Withholding write-off	WWO	WWO	D
Sales/use tax	SUT	SUT	D
Nonrecoverable VAT	VIN	VIN	D

Note:

If the source of a WTO, DEF, or OLT row is a retainage (BRT in the Project Transaction table, or RRT in the billing worksheet) rather than a BIL, the system does not follow the preceding logic. Instead, the system updates the Billing Distribution Status field for the BRT row to D (distributed) and inserts three new rows: RRT row with billing distribution status of I (ignore), RAJ row with billing distribution status of I, and either a WTO row with billing distribution status of I, a DEF row with billing distribution status of P (priced), or an OLT row with billing distribution status of P.

You can determine billed and unbilled amounts by appropriately grouping analysis types within the Project Transaction table. Analysis types and analysis groups can be user-defined. PeopleSoft delivers these sample analysis groups that contain analysis types for billed and unbilled amounts:

Analysis Group	Analysis Types
BLD (billed transactions)	BAJ (billing adjustment) BLD (billed amount) BRT (billing retainage) DSC (billing discount) FBD (fixed cost billed amount) RAJ (released retainage adjustment) RRT (released billing retainage) SUT (sales/use tax) UTL (prepaid utilization for billing)
UNBLD (unbilled transactions)	BIL (billable amount) BRT (billing retainage) DEF (deferred amount) OLT (over limit amount) RRT (released billing retainage)
PSBLD (Billing to Projects)	BAJ (billing adjustment) BIL (billable amount) BRT (billing retainage) DEF (billing deferral) DSC (billing discount) FBD (fixed cost billed amount) OLT (over limit) PMR (proposal management reversal) RAJ (released retainage adjustment) RRT (released billing retainage) SUT (sales/use tax) UAJ (prepaid utilization adjustment) UTL (prepaid utilization billing) WAJ (withholding adjustment) WRJ (withholding release adjustment) WRL (withholding release) WTH (withholding) WTO (write off) WWO (withholding write off)

On the source transaction row, the system updates the billing distribution status to:

• P (priced) when the row is priced.

• D (distributed) when the row is successfully billed.

On the target row, the system updates the billing distribution status to:

• W (billing worksheet) while the row is in the billing process or in the worksheet.

• P when it is created from the Pricing Engine.

• W when PeopleSoft Contracts selects it for billing.

• D when the row is successfully billed.

Note:

After the Billing to Project Costing process finishes, run the Refresh Summary Tables Application Engine process (PC_SUM_RFSH) to synchronize the PC_SUMMARY_TBL and CA_PR_SUMM summary tables with new data in the Project Transaction table.