EP_GROUP_CODEPL_PRIO_DMD_SRCBA=Buying Agreements
FC=Forecasts
IT=Inter-Unit Transfers
QO=Quotations
SO=Sales Orders
SR=Stock Requests
SS=Safety Stock
PL_PRIO_FAMILYPL_PRIO_RESN=Unreserved
Y=Reserved
CUSTOMER_GROUPPRIORITY_NBRDESTIN_BUPL_PRIO_DMD_EP(SQL Table) |
Index Back |
|---|---|
planning dmd priorities - EPjnw 8/1/99 (cn#sf800-7) created record |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EP_GROUP_CODE |
Character(6) | VARCHAR2(6) NOT NULL | Group Code |
| 2 | PRIORITY_RANK | Number(3,0) | SMALLINT NOT NULL | Priority rank value of demand prioritization rule |
| 3 | 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 |
| 4 | PL_PRIO_FAMILY |
Character(10) | VARCHAR2(10) NOT NULL | Demand Priority Family |
| 5 | PL_PRIO_RES |
Character(2) | VARCHAR2(2) NOT NULL |
jnw 8/1/99 (cn#sf800-7.0) added field
N=Unreserved Y=Reserved |
| 6 | CUSTOMER_GROUP |
Character(10) | VARCHAR2(10) NOT NULL | Customer Group |
| 7 | PRIORITY_NBR |
Number(3,0) | SMALLINT NOT NULL | Priority |
| 8 | DESTIN_BU |
Character(5) | VARCHAR2(5) NOT NULL | Destination Unit |