SAC_SS_LINE_VW

(SQL View)
 Index Back

Purchase Order Line Item

Purchase Order Line Item

SELECT A.BUSINESS_UNIT ,A.AUC_ID , A.AUC_ROUND , A.AUC_VERSION , A.BIDNUM , A.BIDDER_SETID , A.BIDDER_ID , A.BIDDER_TYPE , A.BIDDER_LOC , A.AUC_AWARD_NBR ,A.LINE_NBR ,'A' ,'U' ,A.ITM_SETID ,A.INV_ITEM_ID ,' ' ,' ' ,B.CATEGORY_ID ,0 ,A.UNIT_OF_MEASURE ,'S' ,'P' ,B.MFG_ID ,B.MFG_ITM_ID ,' ' ,' ' ,0 ,0 ,0 ,1 ,1 ,A.AUC_ID ,A.LINE_NBR ,'N' ,' ' ,'N' ,'N' ,'N' ,' ' ,' ' ,' ' ,A.DESCR254_MIXED ,B.AUC_ITEM_WEIGHT ,B.AUC_ITEM_VOLUME ,B.AUC_WEIGHT_UOM ,B.AUC_VOLUME_UOM ,'01' ,A.AMT_ONLY_FLG ,A.PHYSICAL_NATURE ,' ' ,' ' ,' ' ,'N' FROM PS_AUC_AWARD_LN A , PS_AUC_LINE B WHERE B.BUSINESS_UNIT = A.BUSINESS_UNIT AND B.AUC_ID = A.AUC_ID AND B.AUC_ROUND = A.AUC_ROUND AND B.AUC_VERSION = A.AUC_VERSION AND B.LINE_NBR = A.LINE_NBR AND A.QTY_AUC > 0

  • Parent record: PO_HDR

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 AUC_ID Character(10) VARCHAR2(10) NOT NULL Event ID
    3 AUC_ROUND Number(5,0) INTEGER NOT NULL Event Round
    4 AUC_VERSION Number(5,0) INTEGER NOT NULL Event Version
    5 BIDNUM Signed Number(6,0) DECIMAL(5) NOT NULL Bid ID
    6 BIDDER_SETID Character(5) VARCHAR2(5) NOT NULL Bidder Setid
    7 BIDDER_ID Character(15) VARCHAR2(15) NOT NULL Bidder ID
    8 BIDDER_TYPE Character(1) VARCHAR2(1) NOT NULL Bidder Type
    B=Bidder
    C=Customer
    P=Public
    U=Uploaded
    V=Supplier
    9 BIDDER_LOC Character(10) VARCHAR2(10) NOT NULL Bidder Location
    10 AUC_AWARD_NBR Number(3,0) SMALLINT NOT NULL Award Number
    11 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]

    Default Value: 1

    12 CANCEL_STATUS Character(1) VARCHAR2(1) NOT NULL Cancel Status
    A=Active
    C=Closed
    D=Denied
    H=Hold
    O=Open
    P=Pending Approval
    X=Canceled

    Default Value: A

    13 CHANGE_STATUS Character(1) VARCHAR2(1) NOT NULL Change Order Status
    C=Changed
    U=Unchanged

    Default Value: U

    14 ITM_SETID Character(5) VARCHAR2(5) NOT NULL Item SetID
    15 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
    16 ITM_ID_VNDR Character(50) VARCHAR2(50) NOT NULL Vendor Item ID
    17 VNDR_CATALOG_ID Character(20) VARCHAR2(20) NOT NULL Vendor's Catalog Number
    18 CATEGORY_ID Character(5) VARCHAR2(5) NOT NULL Category ID
    19 CHNG_ORD_SEQ Number(3,0) SMALLINT NOT NULL Change Order Sequence Number
    20 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
    MHR=Muti Hourly
    PER=Percentage
    SQF=Square Footage
    21 QTY_TYPE Character(1) VARCHAR2(1) NOT NULL Quantity to Use for Prices
    L=Line Quantity
    S=Schedule Quantity

    Default Value: S

    22 PRICE_DT_TYPE Character(1) VARCHAR2(1) NOT NULL Date to Use for Prices
    D=Due Date
    P=PO Date

    Default Value: P

    23 MFG_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer ID
    24 MFG_ITM_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer's Item ID
    25 CNTRCT_SETID Character(5) VARCHAR2(5) NOT NULL SetID
    26 CNTRCT_ID Character(25) VARCHAR2(25) NOT NULL Buying Agreement ID
    27 CNTRCT_LINE_NBR Number(5,0) INTEGER NOT NULL Buying Agreement Line Nbr
    28 RELEASE_NBR Number(5,0) INTEGER NOT NULL Release Number
    29 MILESTONE_NBR Number(5,0) INTEGER NOT NULL Milestone Line Number
    30 CNTRCT_RATE_MULT Number(16,8) DECIMAL(15,8) NOT NULL Contract Rate Multiplier

    Default Value: 1

    31 CNTRCT_RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL Contract Rate Divider

    Default Value: 1

    32 RFQ_ID Character(10) VARCHAR2(10) NOT NULL RFQ ID
    33 RFQ_LINE_NBR Number(5,0) INTEGER NOT NULL RFQ Line
    34 INSPECT_CD Character(1) VARCHAR2(1) NOT NULL Inspection Required
    N=No
    Y=Yes

    Default Value: N

    35 ROUTING_ID Character(10) VARCHAR2(10) NOT NULL Inspection Routing ID
    36 RECV_REQ Character(1) VARCHAR2(1) NOT NULL Receiving Required
    N=Optional
    X=Do Not
    Y=Required

    Default Value: N

    37 PRICE_CAN_CHANGE Character(1) VARCHAR2(1) NOT NULL Price Can Be Changed on Order
    N=No
    Y=Yes

    Default Value: Y

    38 WTHD_SW Character(1) VARCHAR2(1) NOT NULL Withholding Applicable Flag
    B=Global and 1099
    G=Global
    T=1099

    Default Value: N

    39 WTHD_CD Character(5) VARCHAR2(5) NOT NULL Withholding Code
    40 CONFIG_CODE Character(50) VARCHAR2(50) NOT NULL Product Configurator
    41 CP_TEMPLATE_ID Character(10) VARCHAR2(10) NOT NULL Template ID Field
    42 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description
    43 PACKING_WEIGHT Signed Number(17,4) DECIMAL(15,4) NOT NULL Packing Weight
    44 PACKING_VOLUME Signed Number(17,4) DECIMAL(15,4) NOT NULL Packing Volume
    45 UNIT_MEASURE_WT Character(3) VARCHAR2(3) NOT NULL Weight UOM
    46 UNIT_MEASURE_VOL Character(3) VARCHAR2(3) NOT NULL Volume UOM
    47 REPLEN_OPT Character(2) VARCHAR2(2) NOT NULL Replenish Code
    01=Standard
    02=Stockless
    48 AMT_ONLY_FLG Character(1) VARCHAR2(1) NOT NULL Amount Only
    N=No
    Y=Yes

    Default Value: N

    49 PHYSICAL_NATURE Character(1) VARCHAR2(1) NOT NULL Physical Nature
    G=Goods
    S=Services
    50 GPO_ID Character(18) VARCHAR2(18) NOT NULL GPO ID
    51 GPO_CNTRCT_NBR Character(25) VARCHAR2(25) NOT NULL GPO Contract Number
    52 BENEFIT_ID Character(10) VARCHAR2(10) NOT NULL Benefit Identification
    53 CNTRCT_CF_LOCK Character(1) VARCHAR2(1) NOT NULL Lock Chartfields
    N=No
    Y=Yes

    Default Value: N