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.