RO_GENERATOR_IDPRODUCT_IDPrompt Table: PROD_ITEM
CS=Case
EA=Each
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
Prompt Table: PROD_UOM
C=C
N=N
Y=Y
Y/N Table Edit
Default Value: Y
RO_GEN_PRODUCTS(SQL Table) |
Index Back |
|---|---|
Order Generator ProductsLists the available products for the order generator |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | RO_GENERATOR_ID |
Character(20) | VARCHAR2(20) NOT NULL | Unique key used by the Order Generator. |
| 2 | PRODUCT_ID |
Character(18) | VARCHAR2(18) NOT NULL |
Product ID
Prompt Table: PROD_ITEM |
| 3 | 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: PROD_UOM |
| 4 | QTY_ORDERED | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | Order Qty |
| 5 | SELECT_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Selection Flag
C=C N=N Y=Y Y/N Table Edit Default Value: Y |