PL_PLN_PO

(SQL Table)
Index Back

PL Opt Load: Planned PO's

10/30/01 PCL: (CN#PL900-1.0): Added

  • Parent Record Of PL_PLN_PO_VW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PROBINST Character(20) VARCHAR2(20) NOT NULL Optimization Problem Instance

    Prompt Table: SP_PRBINS_NONVW

    2 PL_SEQ_NBR Number(9,0) DECIMAL(9) NOT NULL 01/09/02 EGS (CN#PL900-1): Added
    3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Prompt Table: PL_PLNPOBU_VW

    4 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
    5 PL_PLAN_STATUS Character(2) VARCHAR2(2) NOT NULL 11/01/01 PCL (CN#PL900-1): Added
    05=Planned
    15=Firmed
    90=Canceled
    6 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

    Prompt Table: PL_PLNPOITEM_VW

    7 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID

    Prompt Table: PL_PURCHOPT1_VW

    8 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

    Prompt Table: PL_PLNPOVDR_VW

    9 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location

    Prompt Table: PL_PURCHOPT3_VW

    10 BUYER_ID Character(30) VARCHAR2(30) NOT NULL Buyer
    11 CONFIG_CODE Character(50) VARCHAR2(50) NOT NULL Product Configurator

    Prompt Table: PL_BU_CFG_VW

    12 PLAN_RELEASE_DTTM DateTime(26) TIMESTAMP Plan Release Date Time
    13 DUE_DTTM DateTime(26) TIMESTAMP NOT NULL Due Datetime
    14 PL_PO_LEAD_TIME Number(10,0) DECIMAL(10) NOT NULL 11/01/01 PCL (CN#PL900-1): Added
    15 QTY_PO Number(16,4) DECIMAL(15,4) NOT NULL Purchase Order Quantity
    16 REMAINING_QTY Signed Number(17,4) DECIMAL(15,4) NOT NULL 08/16/01 JNW (CN#PL900-1.0): Added
    17 PLAN_FROZEN_FLG Character(1) VARCHAR2(1) NOT NULL 11/01/01 PCL (CN#PL900-1): Updated
    N=No
    Y=Yes

    Y/N Table Edit

    18 INCL_QTY_FLG Character(1) VARCHAR2(1) NOT NULL Include Quantity
    B=Both
    N=No
    Y=Yes

    Y/N Table Edit

    19 APPROVED_FLG Character(1) VARCHAR2(1) NOT NULL Approved by Auditor
    D=Denied
    N=Not Approved
    Y=Approved

    Y/N Table Edit

    Default Value: N

    20 SPOT_BUY_FLG Character(1) VARCHAR2(1) NOT NULL 10/24/02 EGS (CN#PL880-1): Added

    Y/N Table Edit

    21 PL_AUC_SOURCING_BU Character(5) VARCHAR2(5) NOT NULL Sourcing Business Unit
    22 AUC_ID Character(10) VARCHAR2(10) NOT NULL Event ID
    23 AUC_ROUND Number(5,0) INTEGER NOT NULL Event Round
    24 AUC_VERSION Number(5,0) INTEGER NOT NULL Event Version
    25 PL_ORDER_TYPE Character(3) VARCHAR2(3) NOT NULL RAG# Added filed for Planning Phoneix.
    BA=Buying Agreement
    NFC=Net Forecast
    PDN=Production Order
    PLN=Planned Order
    PPO=Planned Purchase Order
    PPR=Planned Production
    PSS=Strategic Sourcing Event
    PTR=Planned Transfer
    PUR=Purchase Order
    SO=Sales Order
    SOH=Starting On Hand Qty
    SR=Material Stock Request
    TFR=Transfer
    XD=Extra Demand
    26 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

    Default Value: 0

    27 LOAD_FLAG Character(1) VARCHAR2(1) NOT NULL Load Flag

    Default Value: Y

    28 VERSION Number(10,0) DECIMAL(10) NOT NULL Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference