PL_PRIO_DEMAND(SQL Table) |
Index Back |
|---|---|
planning dmd priorities - PPjnw 8/1/99 (cn#sf800-7) created record |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BUIN_NONVW |
| 2 | PL_PRIO_DMD_SRC |
Character(2) | VARCHAR2(2) NOT NULL |
jnw 8/1/99 (cn#sf800-7.0) added field
BA=Buying Agreements FC=Forecasts IT=Inter-Unit Transfers QO=Quotations SO=Sales Orders SR=Stock Requests SS=Safety Stock Prompt Table: PL_PRIO_SRC_VW |
| 3 | PL_PRIO_FAMILY |
Character(10) | VARCHAR2(10) NOT NULL |
Demand Priority Family
Prompt Table: PL_PRIO_FAMILY |
| 4 | PL_PRIO_RES |
Character(2) | VARCHAR2(2) NOT NULL |
jnw 8/1/99 (cn#sf800-7.0) added field
N=Unreserved Y=Reserved |
| 5 | CUSTOMER_GROUP |
Character(10) | VARCHAR2(10) NOT NULL |
Customer Group
Prompt Table: CUSTGP_NGALC_VW |
| 6 | PRIORITY_NBR |
Number(3,0) | SMALLINT NOT NULL | Priority |
| 7 | DESTIN_BU |
Character(5) | VARCHAR2(5) NOT NULL |
Destination Unit
Prompt Table: SP_BUIN_NONVW |
| 8 | PRIORITY_RANK | Number(3,0) | SMALLINT NOT NULL | Priority rank value of demand prioritization rule |