PL_BUS_UNIT_IN(SQL Table) |
Index Back |
|---|---|
Planning Business Units08/16/01 EGS (CN#PL900-1.0): Added |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROBINST |
Character(20) | VARCHAR2(20) NOT NULL | Optimization Problem Instance |
| 2 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 3 | CALENDAR_CODE | Character(10) | VARCHAR2(10) NOT NULL | This code is for a group of dates associated with exchange (stock, money, commodity) traded future or option contracts. |
| 4 | PL_SUB_OPTIONS | Character(1) | VARCHAR2(1) NOT NULL |
Substitute Options
A=Active Substitution G=Aggressive Substitution O=Turn Off Substitution Default Value: O |
| 5 | COMPONENT_DEMAND | Character(1) | VARCHAR2(1) NOT NULL |
Round Component Demand
Y/N Table Edit Default Value: N |
| 6 | INCL_AVL_INV_BAL | Character(1) | VARCHAR2(1) NOT NULL |
03/10/98 SCC CN# PL750-SCHEW-JV26Y: Changed long/short descr.
Y/N Table Edit |
| 7 | INCL_QUAR_AVAIL | Character(1) | VARCHAR2(1) NOT NULL |
Reverse Quarantine Quantity
Y/N Table Edit |
| 8 | OPEN_RECV_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Open for Receiving
Y/N Table Edit Default Value: N |
| 9 | OPEN_SHIP_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
09/25/01 EGS (CN#PL900-1): Added.
Y/N Table Edit Default Value: N |
| 10 | PRIMARY_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Primary
N=No Y=Yes Y/N Table Edit Default Value: Y |
| 11 | SHIP_PREP | Number(6,0) | INTEGER NOT NULL | KPN 08/21/02: Changed long name of SHIP_PREP from Ship Preparation Time [Min] to Ship Preparation Time (Min) |
| 12 | MFG_BU | Character(1) | VARCHAR2(1) NOT NULL |
Manufacturing Business Unit
Y/N Table Edit Default Value: N |
| 13 | PL_SUB_OPT | Character(1) | VARCHAR2(1) NOT NULL |
06/28/02 EGS (CN#PL900-1): Added.
Y/N Table Edit Default Value: N |
| 14 | PL_SUPPLY_SUB | Character(1) | VARCHAR2(1) NOT NULL |
06/28/02 EGS (CN#PL900-1): Added.
Y/N Table Edit Default Value: N |
| 15 | PL_SUB_FIRST | Character(1) | VARCHAR2(1) NOT NULL |
06/28/02 EGS (CN#PL900-1): Added.
Y/N Table Edit Default Value: N |
| 16 | BOM_EXP_DT_FLG | Character(1) | VARCHAR2(1) NOT NULL |
BOM Explosion By Date
0=By Start Date 1=By End Date Default Value: 0 |
| 17 | VERSION | Number(10,0) | DECIMAL(10) NOT NULL | Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference |