Valid IDENTIFIER and IDENTIFIER_TBL Field Combinations

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.