PO_LINE

(SQL Table)
Index Back

Purchase Order Line Item

Purchase Order Line Item 06/25/2008 PKL F-AHAYT-S60K7 Contract Enhancements

  • 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 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
    3 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]

    Default Value: 1

    4 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

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

    Default Value: U

    6 ITM_SETID Character(5) VARCHAR2(5) NOT NULL Item SetID
    7 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

    Prompt Table: %EDIT_ITEM_ID

    8 ITM_ID_VNDR Character(50) VARCHAR2(50) NOT NULL Vendor Item ID
    9 VNDR_CATALOG_ID Character(20) VARCHAR2(20) NOT NULL Vendor's Catalog Number
    10 CATEGORY_ID Character(5) VARCHAR2(5) NOT NULL Category ID

    Prompt Table: ITM_CAT_VW

    11 CHNG_ORD_SEQ Number(3,0) SMALLINT NOT NULL Change Order Sequence Number
    12 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
    MHR=Muti Hourly
    PER=Percentage
    SQF=Square Footage

    Prompt Table: %EDIT_UOM

    13 QTY_TYPE Character(1) VARCHAR2(1) NOT NULL Quantity to Use for Prices
    L=Line Quantity
    S=Schedule Quantity

    Default Value: S

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

    Default Value: P

    15 MFG_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer ID

    Prompt Table: MANUFACTURER

    16 MFG_ITM_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer's Item ID

    Prompt Table: %EDIT_MFGITM_ID

    17 CNTRCT_SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Prompt Table: PO_CNTRCT_SET

    18 CNTRCT_ID Character(25) VARCHAR2(25) NOT NULL Buying Agreement ID

    Prompt Table: %EDITTABLE6

    19 VERSION_NBR Number(5,0) INTEGER NOT NULL Contract Version number

    Prompt Table: PO_CNTRCT_VER

    20 CNTRCT_LINE_NBR Number(5,0) INTEGER NOT NULL Buying Agreement Line Nbr

    Prompt Table: %EDIT_CNTRCT_LN

    21 CAT_LINE_NBR Number(5,0) INTEGER NOT NULL Contract Category Line Number

    Prompt Table: %EDITTABLE4

    22 RELEASE_NBR Number(5,0) INTEGER NOT NULL Release Number
    23 MILESTONE_NBR Number(5,0) INTEGER NOT NULL Milestone Line Number
    24 CNTRCT_RATE_MULT Number(16,8) DECIMAL(15,8) NOT NULL Contract Rate Multiplier

    Default Value: 1

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

    Default Value: 1

    26 VRBT_ID Character(25) VARCHAR2(25) NOT NULL Vendor Rebate ID
    27 RFQ_ID Character(10) VARCHAR2(10) NOT NULL RFQ ID
    28 RFQ_LINE_NBR Number(5,0) INTEGER NOT NULL RFQ Line
    29 INSPECT_CD Character(1) VARCHAR2(1) NOT NULL Inspection Required
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N

    30 ROUTING_ID Character(10) VARCHAR2(10) NOT NULL Inspection Routing ID

    Prompt Table: ROUTING_HDR

    31 RECV_REQ Character(1) VARCHAR2(1) NOT NULL Receiving Required
    N=Optional
    X=Do Not
    Y=Required

    Default Value: N

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

    Y/N Table Edit

    Default Value: Y

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

    Y/N Table Edit

    Default Value: N

    34 WTHD_CD Character(5) VARCHAR2(5) NOT NULL Withholding Code

    Prompt Table: WTHD_CD_HDR

    35 CONFIG_CODE Character(50) VARCHAR2(50) NOT NULL Product Configurator

    Prompt Table: CP_CONFIG_PO_VW

    36 CP_TEMPLATE_ID Character(10) VARCHAR2(10) NOT NULL Template ID Field
    37 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description
    38 ORIG_INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Used to identify the original item ordered, in case an item substitution has taken place.
    39 DESCR254_MIXED2 Character(254) VARCHAR2(254) NOT NULL Long Description
    40 PACKING_WEIGHT Signed Number(17,4) DECIMAL(15,4) NOT NULL Packing Weight
    41 PACKING_VOLUME Signed Number(17,4) DECIMAL(15,4) NOT NULL Packing Volume
    42 UNIT_MEASURE_WT Character(3) VARCHAR2(3) NOT NULL Weight UOM
    43 UNIT_MEASURE_VOL Character(3) VARCHAR2(3) NOT NULL Volume UOM
    44 REPLEN_OPT Character(2) VARCHAR2(2) NOT NULL Replenish Code
    01=Standard
    02=Stockless
    45 AMT_ONLY_FLG Character(1) VARCHAR2(1) NOT NULL Amount Only
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N

    46 PHYSICAL_NATURE Character(1) VARCHAR2(1) NOT NULL Physical Nature
    G=Goods
    S=Services
    47 USER_LINE_CHAR1 Character(1) VARCHAR2(1) NOT NULL Custom Character 1
    48 CUSTOM_C100_B1 Character(100) VARCHAR2(100) NOT NULL Custom Field 1
    49 CUSTOM_C100_B2 Character(100) VARCHAR2(100) NOT NULL Custom Field 2
    50 CUSTOM_C100_B3 Character(100) VARCHAR2(100) NOT NULL Custom Field 3
    51 CUSTOM_C100_B4 Character(100) VARCHAR2(100) NOT NULL Custom Field 4
    52 CUSTOM_DATE_B Date(10) DATE Custom Date
    53 CUSTOM_C1_B Character(1) VARCHAR2(1) NOT NULL Custom Character 2
    54 GPO_ID Character(18) VARCHAR2(18) NOT NULL GPO ID
    55 GPO_CNTRCT_NBR Character(25) VARCHAR2(25) NOT NULL GPO Contract Number
    56 BENEFIT_ID Character(10) VARCHAR2(10) NOT NULL Benefit Identification

    Prompt Table: CSD_BENEFIT_VW

    57 CNTRCT_CF_LOCK Character(1) VARCHAR2(1) NOT NULL Lock Chartfields
    N=No
    Y=Yes

    Default Value: N

    58 CLOSE_SHORT_FLG Character(1) VARCHAR2(1) NOT NULL Close Short Flag

    Y/N Table Edit

    Default Value: N

    59 AUC_GROUP_ID Character(18) VARCHAR2(18) NOT NULL GroupID
    60 APPR_REQD Character(1) VARCHAR2(1) NOT NULL Field to indicate if approvals are required

    Default Value: Y

    61 PO_GROUP_ID Character(18) VARCHAR2(18) NOT NULL GroupID

    Prompt Table: PO_GROUP_VW

    62 PRIMARY_UNIT Character(1) VARCHAR2(1) NOT NULL Primary Unit
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N

    63 UNIT_ALLOC_QTY Number(16,4) DECIMAL(15,4) NOT NULL Unit Allocation Qty
    64 UNIT_ALLOC_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Unit Allocation Amt
    65 UPN_TYPE_CD Character(4) VARCHAR2(4) NOT NULL Universal Product Number Format Type

    Prompt Table: %EDITTABLE39

    66 UPN_ID Character(20) VARCHAR2(20) NOT NULL Universal Product Number

    Prompt Table: %EDIT_FIELD

    67 LN_TYPE Character(4) VARCHAR2(4) NOT NULL Line Type
    CAT=Catalog Item
    CUST=Custom Item
    DC=Direct Connect Item
    DCEX=Exchange Item
    DCPO=Punchout Item
    DCRT=Round Trip
    DCTP=Transparent Punchout Item
    DESR=Ad-hoc Item
    EF=Express Form Item
    OS=Order Sheet
    SDF=Supplemental Data Form
    SPRO=Service
    SR=ePro Special Request Item
    SRFC=Fixed Cost Service Item
    SRTM=Time and Material Service Item
    SRVC=Variable Cost Service Item
    68 GNV_ORDER_LINE_NBR Number(5,0) INTEGER NOT NULL Identifier of a specific Line Item within the Order. G_INVOICING MANINSRI 17/06/2021