RO_GEN_HEADER(SQL Table) |
Index Back |
|---|---|
Order Generator HeaderHeader level fields 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 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_RB.BUSINESS_UNIT Prompt Table: SP_BU_RO_NONVW |
| 3 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
This field stores the Currency Code value.
Default Value: USD Prompt Table: CURRENCY_CD_TBL |
| 4 | RO_GEN_PROD_SELECT | Character(1) | VARCHAR2(1) NOT NULL |
Option to select the list of products to be added to the auto-generated orders
A=Add all selected products R=Add random products Default Value: R |
| 5 | MIN_QTY | Number(10,4) | DECIMAL(9,4) NOT NULL |
Minimum Quantity
Default Value: 1 |
| 6 | MAX_QTY | Number(10,4) | DECIMAL(9,4) NOT NULL |
Maximum Quantity
Default Value: 1 |
| 7 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 8 | CAPTURE_DATE | Date(10) | DATE NOT NULL | Order capture date used for orders and quotes |
| 9 | SUBMIT_PB2 | Character(1) | VARCHAR2(1) NOT NULL |
Submit push button used to submit an order or quote
Y/N Table Edit Default Value: Y |