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.