VCHR_BLD_PO

(SQL Table)
 Index Back

Voucher Build PO Criteria

  • Parent record: VCHR_BLD_CODE

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    2 VCHR_BLD_CODE Character(6) VARCHAR2(6) NOT NULL Voucher Build Code
    3 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
    4 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence
    5 VENDOR_FLG Character(1) VARCHAR2(1) NOT NULL Supplier

    Y/N Table Edit

    Default Value: N

    6 PO_BU_FLG Character(1) VARCHAR2(1) NOT NULL PO Business Unit

    Y/N Table Edit

    Default Value: N

    7 PO_LINE_OPT Character(1) VARCHAR2(1) NOT NULL PO Line Criteria
    B=PO Business Unit
    L=PO Line
    N=None
    P=PO ID
    S=PO Schedule

    Default Value: N

    8 ITEM_OPT Character(1) VARCHAR2(1) NOT NULL Item Option
    I=Item Id
    N=None

    Default Value: N

    9 PO_QTY_OPT Character(1) VARCHAR2(1) NOT NULL Quantity Option
    N=None
    P=PO Quantity

    Default Value: N

    10 QTY_TOL_OPT Character(1) VARCHAR2(1) NOT NULL Quantity Tolerances
    N=None
    P=PO Quanity Tolerances
    V=Voucher Quantity Tolerances

    Default Value: N

    11 USER_BLD_OPT Character(1) VARCHAR2(1) NOT NULL User Defined
    N=None
    U=User Defined
    V=View Only

    Default Value: N

    12 USER_BLD_CLAUSE Character(254) VARCHAR2(254) NOT NULL User Clause
    13 BLD_CLAUSE1 Character(254) VARCHAR2(254) NOT NULL Bld Clause1
    14 BLD_CLAUSE2 Character(254) VARCHAR2(254) NOT NULL Bld Clause2
    15 BLD_CLAUSE3 Character(254) VARCHAR2(254) NOT NULL Bld Clause3
    16 BLD_CLAUSE4 Character(254) VARCHAR2(254) NOT NULL Bld Clause4
    17 FRM_CLAUSE1 Character(254) VARCHAR2(254) NOT NULL From Clause 1
    18 BLD_CLAUSE_PB Character(1) VARCHAR2(1) NOT NULL Build Clause
    19 USER_CLAUSE_PB Character(5) VARCHAR2(5) NOT NULL User Clause
    20 BLD_CLAUSE_LONG Long Character(1024) VARCHAR2(1024) Concatenate Build Clause