IDENTIFIER and IDENTIFIER_TBL Field Requirements

This table demonstrates how systems that import data into PeopleSoft Billing through the Billing interface must populate the IDENTIFIER and IDENTIFIER_TBL fields:

Feeder System	Interface Process	IDENTIFIER Value	PRODUCT_ID Value	IDENTIFIER_TBL Value
PeopleSoft Order Management	OM_BILL	A product code from the PROD_ITEM table	A product code from the PROD_ITEM table	PRD (all bills)
PeopleSoft Order Management	OM_BILL	A customer's product code (product alias to system product code)	A product code from the PROD_ITEM table	PDA (all bills)
PeopleSoft Contracts	CA_BI_INTFC	Any non-blank value	A product code from the PROD_ITEM table, if available	CON (all bills)
PeopleSoft Project Costing	CA_BI_INTFC	Any non-blank value	A product code from the PROD_ITEM table, if available	CON (all bills)
PeopleSoft CRM (using Contracts)	CA_BI_INTFC	COST_CAT_CD from the RF_COST_CAT table		LAB
PeopleSoft CRM (using Contracts)	CA_BI_INTFC	SERVICE_ID from the RF_SERVICE table		SVC
PeopleSoft Inventory	INBILL	INV_ITEM_ID from the MASTER_ITEM_TBL table		ITM
PeopleSoft Asset Management	AM_BI_INTFC	ASSET_ID from the AMBI_INTFC_BILL table		A

Note:

If the IDENTIFIER field is populated and the IDENTIFIER_TBL field is blank, the Billing Interface process populates the IDENTIFIER_TBL field with G. If the IDENTIFIER field is blank and the IDENTIFIER_TBL field is populated, the Billing Interface process leaves the IDENTIFIER_TBL blank.