RF_PROD_REG_TMP

(SQL Table)
Index Back

Prod Register temp table

Used to process the product catalog data while registering products. The information is toggled back and forth from here and RF_PROD_REG_TM2.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.
2 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
3 CATALOG_ID_NUM Number(5,0) INTEGER NOT NULL Catalog ID
4 NEST_CAT_ID Number(5,0) INTEGER NOT NULL Catalog Identification Number
5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
6 DESCR_EXT Character(50) VARCHAR2(50) NOT NULL External Description
7 REGISTER_PB Character(1) VARCHAR2(1) NOT NULL Register Push Button is used to register a Consumer, Trigger Logic to register Consumer etc.