LEAD_IDPrompt Table: PROD_ITEM
CS=Case
EA=Each
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
RSF_LE_DUPP_VW(SQL View) |
Index Back |
|---|---|
Volume Import VerificationThis record is a holding table for Leads being imported. This provides the user with an opportunity to verify the Leads moving to the real table RSF_LEAD. |
| SELECT P.LEAD_ID , P.PRICE_BASE , P.PRODUCT_GROUP , P.PRODUCT_ID , P.COST , P.QTY , P.REVENUE_TYPE , P.UNIT_OF_MEASURE FROM PS_RSF_LE_PRODUCTS P |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | LEAD_ID |
Character(15) | VARCHAR2(15) NOT NULL | Used by Sales Force Automation, this field uniquely identifies a Sales Lead. |
| 2 | PRICE_BASE | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | Net Unit Price (base) |
| 3 | PRODUCT_GROUP | Character(10) | VARCHAR2(10) NOT NULL | PRoduct Group |
| 4 | PRODUCT_ID | Character(18) | VARCHAR2(18) NOT NULL |
Product ID
Prompt Table: PROD_ITEM |
| 5 | COST | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total Cost |
| 6 | QTY | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Quantity |
| 7 | REVENUE_TYPE | Character(15) | VARCHAR2(15) NOT NULL | This field is used to store revenue type related to a product sales and used within forecasting. |
| 8 | UNIT_OF_MEASURE | Character(3) | VARCHAR2(3) NOT NULL |
Used on an approval rule set.
CS=Case EA=Each MHR=Muti Hourly PER=Percentage SQF=Square Footage |