Populating Identifiers

This table lists the value combinations for populating the IDENTIFIER and IDENTIFIER_TBL fields in the Billing interface:

If the Identifier Field Contains:

Populate IDENTIFIER_TBL with:

A charge code from the BI_CHARGE table

ID (charge code)

A discount code from the BI_DISC_SUR table

D (discount)

A surcharge code from the BI_DISC_SUR table, including installment surcharges

S (surcharge)

A product code from the PROD_ITEM table

PRD (product).

In this case, the PRODUCT_ID field should be populated with the same value as IDENTIFIER.

A customer's product code

PDA (product alias)

In this case, PRODUCT_ID field should be populated with the system product code.

An item ID from the MASTER_ITEM_TBL table

ITM (item master)

A promotion code from the PPRC_PROMO_TBL table

PRM (promotion)

An asset ID from the ASSET table

A (asset)

A Labor Type code from the RF_COST_CAT table

LAB (labor)

A Service code from the RF_SERVICE table

SVC (service)

Any free form code not listed in this table

G (generic)

Any other non-blank value passed by PeopleSoft Contracts or Project Costing

CON (contract)

In this case, the PRODUCT_ID field should be populated with the system product code; PRODUCT_ID can be different from the Identifier field.

<blank>

<blank>

Note: No edit check exists in the Billing interface logic to prevent invalid values in the IDENTIFIER_TBL field, nor to ensure that the IDENTIFIER and IDENTIFIER_TBL field combinations are valid.

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.