PROCESS_INSTANCEPROBINSTPrompt Table: SP_PRBINS_NONVW
BUSINESS_UNITINV_ITEM_IDCONFIG_CODEPL_COLUMN_NUMBERPL_PLNRPT_D(SQL Table) |
Index Back |
|---|---|
Pln Rpt - Horizontal DetailPln Rpt - Horizontal Detail |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | PROBINST |
Character(20) | VARCHAR2(20) NOT NULL |
Optimization Problem Instance
Prompt Table: SP_PRBINS_NONVW |
| 3 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 4 | INV_ITEM_ID |
Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 5 | CONFIG_CODE |
Character(50) | VARCHAR2(50) NOT NULL | Product Configurator |
| 6 | PL_COLUMN_NUMBER |
Number(2,0) | SMALLINT NOT NULL | PL_COLUMN_NUMBER |
| 7 | START_DATE | Date(10) | DATE | Start Date for Gen Standing PO |
| 8 | END_DATE | Date(10) | DATE | End Date |
| 9 | PL_SC_START_DTTM1 | DateTime(26) | TIMESTAMP | PL_SC_START_DTTM1 |
| 10 | PL_SC_END_DTTM1 | DateTime(26) | TIMESTAMP | PL_SC_END_DTTM1 |
| 11 | NBR_OF_DAYS | Number(5,0) | INTEGER NOT NULL | Number of Days |
| 12 | PL_ACTFRCST | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Used in the Planning Report |
| 13 | PL_ATP | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Used in the Planning Report |
| 14 | PL_BUYAGREE | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Used in the Planning Report |
| 15 | PL_CATP | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Used in the Planning Report |
| 16 | PL_CUSTORD | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Used in the Planning Report |
| 17 | PL_DEPDMD | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Used in the Planning Report |
| 18 | PL_EXCSINV | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Used in the Planning Report |
| 19 | PL_EXTRADMD | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Used in the Planning Report |
| 20 | PL_INDDMD | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Used in the Planning Report |
| 21 | PL_INTRANINV | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Used in the Planning Report |
| 22 | PL_NETFRCST | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Used in the Planning Report |
| 23 | PL_NWPLNORD | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Used in the Planning Report |
| 24 | PL_PLNONHND | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Used in the Planning Report |
| 25 | PL_PLNPO | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Used in the Planning Report |
| 26 | PL_PLNPRDN | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Used in the Planning Report |
| 27 | PL_PLNPRDNDMD | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Used in the Planning Report |
| 28 | PL_PLNTRNS | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Used in the Planning Report |
| 29 | PL_PLNTRNSDMD | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Used in the Planning Report |
| 30 | PL_POSUP | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Used in the Planning Report |
| 31 | PL_PRDNDMND | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Used in the Planning Report |
| 32 | PL_PRDNSUP | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Used in the Planning Report |
| 33 | PL_PRDOFSUP | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Used in the Planning Report |
| 34 | PL_PROJONHND | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Used in the Planning Report |
| 35 | PL_SAFESTK | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Used in the Planning Report |
| 36 | PL_SCHPO | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Used in the Planning Report |
| 37 | PL_SCHPRDN | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Used in the Planning Report |
| 38 | PL_SCHPRDNDMD | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Used in the Planning Report |
| 39 | PL_SCHRCPTS | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Used in the Planning Report |
| 40 | PL_SCHTRNS | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Used in the Planning Report |
| 41 | PL_SCHTRNSDMD | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Used in the Planning Report |
| 42 | PL_SOQUOTE | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Used in the Planning Report |
| 43 | PL_STKRQST | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Used in the Planning Report |
| 44 | PL_STRONHAND | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Used in the Planning Report |
| 45 | PL_TOTALDMD | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Used in the Planning Report |
| 46 | PL_TOTALSUP | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Used in the Planning Report |
| 47 | PL_TRNSDMD | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Used in the Planning Report |
| 48 | PL_TRNSSUP | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Used in the Planning Report |
| 49 | PL_TEMP_NUM_11_4 | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Temp Num |