RBF_PRODCOMP_VW(SQL View) |
Index Back |
|---|---|
Product Kit Components TableThis record stores all the individual components and their attributes that make up a Product Kit. |
| SELECT SETID , PRODUCT_ID , PROD_COMPONENT_ID , DATE_IN_EFFECT , DATE_OBSOLETE , DTTM_IN_EFFECT , DTTM_OBSOLETE , MIN_QTY , MAX_QTY , QTY_PER , QTY_CODE , OPTIONAL_SHIP , UNIT_OF_MEASURE , SEQ_NUM , VAT_KIT_PCT , TEXT254 , PACKAGE_FLAG , PROD_DISPLAY_ORDER , ROW_ADDED_DTTM , ROW_ADDED_OPRID , ROW_LASTMANT_DTTM , ROW_LASTMANT_OPRID , SYNCID , SYNCDTTM FROM PS_PRODKIT_COMPS |
| # | 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.
Prompt Table: SP_SETID_NONVW |
| 2 | PRODUCT_ID |
Character(18) | VARCHAR2(18) NOT NULL |
Product ID
Prompt Table: PROD_KIT_VW |
| 3 | PROD_COMPONENT_ID |
Character(18) | VARCHAR2(18) NOT NULL |
Field is used to store components of a product
Prompt Table: RBF_ARRA_PRD_VW |
| 4 | DATE_IN_EFFECT |
Date(10) | DATE | 01/27/2000 RML Added "As of date" label |
| 5 | DATE_OBSOLETE | Date(10) | DATE | Obsolete Date |
| 6 | DTTM_IN_EFFECT | DateTime(26) | TIMESTAMP | Effective Date-Time |
| 7 | DTTM_OBSOLETE | DateTime(26) | TIMESTAMP | Obsolete Date-Time |
| 8 | MIN_QTY | Number(10,4) | DECIMAL(9,4) NOT NULL |
Minimum Quantity
Default Value: 0 |
| 9 | MAX_QTY | Number(10,4) | DECIMAL(9,4) NOT NULL |
Maximum Quantity
Default Value: 0 |
| 10 | QTY_PER | Number(10,4) | DECIMAL(9,4) NOT NULL |
Quantity
Default Value: 1 |
| 11 | QTY_CODE | Character(3) | VARCHAR2(3) NOT NULL |
Per
ASY=Assembly ORD=Order Default Value: ASY |
| 12 | OPTIONAL_SHIP | Character(1) | VARCHAR2(1) NOT NULL |
OK to Ship Without
Y/N Table Edit Default Value: N |
| 13 | 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 Prompt Table: PRODKIT_UOM_VW |
| 14 | SEQ_NUM | Number(3,0) | SMALLINT NOT NULL |
Sequence
Default Value: 1 |
| 15 | VAT_KIT_PCT | Number(3,0) | SMALLINT NOT NULL | This field is used for the percentage of kit value for VAT. |
| 16 | TEXT254 | Character(254) | VARCHAR2(254) NOT NULL | Text |
| 17 | PACKAGE_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Package flag
Y/N Table Edit Default Value: N |
| 18 | PROD_DISPLAY_ORDER | Number(2,0) | SMALLINT NOT NULL | We (PeopleSoft) plan on setting a 'Display Order' on the service features in a product. That is how we would decide the order to show the service features. Instead of just doing it alphabetically. |
| 19 | ROW_ADDED_DTTM | DateTime(26) | TIMESTAMP | This is a datetime field for record creation. |
| 20 | ROW_ADDED_OPRID | Character(30) | VARCHAR2(30) NOT NULL | ID of user who added the row. |
| 21 | ROW_LASTMANT_DTTM | DateTime(26) | TIMESTAMP | The date and time that the row was last updated. |
| 22 | ROW_LASTMANT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | ID of user who last modified the row. |
| 23 | SYNCID | Number(10,0) | DECIMAL(10) NOT NULL | The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle. |
| 24 | SYNCDTTM | DateTime(26) | TIMESTAMP | Synchronization Last Update Date Time |