CNTRCT_LIN_RLVW

(SQL View)
 Index Back

Contract Line Item


SELECT A.SETID ,A.CNTRCT_ID ,A.VERSION_NBR ,A.CNTRCT_LINE_NBR ,A.LINE_STATUS ,A.ITM_SETID ,A.INV_ITEM_ID ,A.DESCR254_MIXED ,A.ITM_ID_VNDR ,A.VNDR_CATALOG_ID ,A.CATEGORY_ID ,A.MFG_ID ,A.QTY_LINE_MIN ,A.QTY_LINE_MAX ,B.QTY_LINE_RELEASED ,A.QTY_LINE_RELSD_CUM ,A.AMT_LINE_MIN ,A.AMT_LINE_MAX ,B.AMT_LINE_RELEASED ,A.AMT_LINE_RELSD_CUM ,A.INCLUDE_FOR_RELS ,A.LINE_PRICE_TYPE ,A.USE_CNTRCT_BASE ,A.PRICE_UOM_ADJ ,A.PRICE_SHIPTO_ADJ ,A.ADJ_BEFORE ,A.QTY_TYPE ,A.PRICE_DT_TYPE ,A.PRICE_CAN_CHANGE ,A.UNIT_OF_MEASURE ,A.MERCHANDISE_AMT ,A.TOTAL_DISTRIBS ,A.MAX_DISTRIB_LINE ,A.STATISTIC_AMOUNT ,A.UNIT_PRICE ,A.TAX_CD ,A.DSCNT_APPL_FLG ,A.FRGHT_PRORATE_FLG ,A.CURRENCY_CD ,A.RFQ_ID ,A.RFQ_LINE_NBR ,A.PHYSICAL_NATURE ,A.VAT_RECOVERY_PCT ,A.WTHD_SETID ,A.WTHD_SW ,A.WTHD_CD ,A.SHIPTO_ID ,A.SUT_BASE_ID ,A.TAX_CD_SUT ,A.SUT_EXCPTN_TYPE ,A.SUT_EXCPTN_CERTIF ,A.SUT_APPLICABILITY ,A.AMT_ONLY_FLG ,A.RETENTION_CD ,A.RETENTION_PCT ,A.RETENTION_AMT ,A.MFG_ITM_ID ,A.ULTIMATE_USE_CD ,A.CNTRCT_LN_TYPE ,A.CNTR_LN_TYPE_ID ,A.AUC_GROUP_ID ,A.DESCR254_MIXED2 ,%subrec(PUR_USR_LIN_SBR, A) ,%subrec(LAST_UPDATE_SBR, A) FROM PS_CNTRCT_LINE A , PS_CNTRCT_LIN_RLS B WHERE B.SETID = A.SETID AND B.CNTRCT_ID = A.CNTRCT_ID AND B.CNTRCT_LINE_NBR = A.CNTRCT_LINE_NBR

  • Parent record: CNTRCT_HDR

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    2 CNTRCT_ID Character(25) VARCHAR2(25) NOT NULL Buying Agreement ID
    3 VERSION_NBR Number(5,0) INTEGER NOT NULL Contract Version number

    Default Value: 1

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

    Default Value: 1

    5 LINE_STATUS Character(1) VARCHAR2(1) NOT NULL Line Status
    A=Active
    C=Cancelled
    I=Inactive
    O=Open
    P=Pending

    Default Value: O

    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: %EDITTABLE13

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

    Prompt Table: %EDITTABLE14
    Set Control Field: SETID

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

    Prompt Table: MANUFACTURER

    13 QTY_LINE_MIN Number(15,2) DECIMAL(14,2) NOT NULL Min Line Qty Per Order
    14 QTY_LINE_MAX Number(15,2) DECIMAL(14,2) NOT NULL Max Line Qty Per Contract
    15 QTY_LINE_RELEASED Number(15,2) DECIMAL(14,2) NOT NULL Total Line Qty Released
    16 QTY_LINE_RELSD_CUM Number(15,2) DECIMAL(14,2) NOT NULL Cumulative Line Qty Released
    17 AMT_LINE_MIN Number(27,3) DECIMAL(26,3) NOT NULL Min Line Amt Per Order
    18 AMT_LINE_MAX Number(27,3) DECIMAL(26,3) NOT NULL Max Line Amt Per Contract
    19 AMT_LINE_RELEASED Signed Number(28,3) DECIMAL(26,3) NOT NULL Total Line Amt Released
    20 AMT_LINE_RELSD_CUM Signed Number(28,3) DECIMAL(26,3) NOT NULL Cumulative Line Amt Released
    21 INCLUDE_FOR_RELS Character(1) VARCHAR2(1) NOT NULL Include for Release
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: Y

    22 LINE_PRICE_TYPE Character(1) VARCHAR2(1) NOT NULL Line Qty/Price Type
    C=Current Order Quantity
    Q=Quantity To Date

    Default Value: C

    23 USE_CNTRCT_BASE Character(1) VARCHAR2(1) NOT NULL Use Contract Base Price
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N

    24 PRICE_UOM_ADJ Character(1) VARCHAR2(1) NOT NULL Use Supp Price UOM Adjustments
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N

    25 PRICE_SHIPTO_ADJ Character(1) VARCHAR2(1) NOT NULL Use Supplier Price Shipto Adj
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N

    26 ADJ_BEFORE Character(1) VARCHAR2(1) NOT NULL Adjust Supplier Pricing First
    N=After Contract Adjustments
    Y=Before Contract Adjustments

    Default Value: Y

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

    Default Value: L

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

    Default Value: D

    29 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: N

    30 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: %EDITTABLE6

    31 MERCHANDISE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label
    32 TOTAL_DISTRIBS Number(5,0) INTEGER NOT NULL Total Number of Distributions
    33 MAX_DISTRIB_LINE Number(5,0) INTEGER NOT NULL Highest Distribution Line
    34 STATISTIC_AMOUNT Signed Number(17,2) DECIMAL(15,2) NOT NULL Specifies the amount associated with a statistical account on a journal line or a distribution line. It represents a quantity rather than a monetary amount and is qualified by the Unit of Measure associated with the STATISTICS_CODE or statistics ACCOUNT.
    35 UNIT_PRICE Signed Number(17,5) DECIMAL(15,5) NOT NULL Unit Price
    36 TAX_CD Character(8) VARCHAR2(8) NOT NULL Tax Code

    Prompt Table: CNTRCT_TAX_VW

    37 DSCNT_APPL_FLG Character(1) VARCHAR2(1) NOT NULL Apply Discount

    Y/N Table Edit

    Default Value: Y

    38 FRGHT_PRORATE_FLG Character(1) VARCHAR2(1) NOT NULL Prorate Freight Charges

    Default Value: N

    39 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Default Value: CNTRCT_HDR.CURRENCY_CD

    40 RFQ_ID Character(10) VARCHAR2(10) NOT NULL RFQ ID
    41 RFQ_LINE_NBR Number(5,0) INTEGER NOT NULL RFQ Line
    42 PHYSICAL_NATURE Character(1) VARCHAR2(1) NOT NULL Physical Nature
    G=Goods
    S=Services
    43 VAT_RECOVERY_PCT Signed Number(7,2) DECIMAL(5,2) NOT NULL VAT Recovery Percent
    44 WTHD_SETID Character(5) VARCHAR2(5) NOT NULL Setid for the Withholding Code
    45 WTHD_SW Character(1) VARCHAR2(1) NOT NULL Withholding Applicable Flag
    B=Global and 1099
    G=Global
    T=1099

    Y/N Table Edit

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

    Prompt Table: WTHD_CD_HDR

    47 SHIPTO_ID Character(10) VARCHAR2(10) NOT NULL Ship To Location

    Prompt Table: SHIPTO_TBL

    48 SUT_BASE_ID Character(10) VARCHAR2(10) NOT NULL Sales/Use Tax Destination

    Prompt Table: SHIPTO_TBL

    49 TAX_CD_SUT Character(8) VARCHAR2(8) NOT NULL Tax Code - Sales and Use Tax

    Prompt Table: TAX_SALE_VW

    50 SUT_EXCPTN_TYPE Character(1) VARCHAR2(1) NOT NULL Sales/Use Tax Exception Type
    D=Direct Pay
    E=Exempt/Exonerated
    N=None
    51 SUT_EXCPTN_CERTIF Character(20) VARCHAR2(20) NOT NULL Sales/Use Tax Exception Certif
    52 SUT_APPLICABILITY Character(1) VARCHAR2(1) NOT NULL Sales/Use Tax Applicability
    D=Direct Pay
    E=Item is Exempt
    S=Sales Tax Applicable
    U=Use Tax Applicable
    X=Purchaser Is Exonerated
    53 AMT_ONLY_FLG Character(1) VARCHAR2(1) NOT NULL Amount Only
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N

    54 RETENTION_CD Character(1) VARCHAR2(1) NOT NULL Retention
    E=Retain on Each Payment
    F=Retain on First Payment
    L=Retain on Last Payment
    N=No Retention
    55 RETENTION_PCT Number(7,3) DECIMAL(6,3) NOT NULL Retention Percentage
    56 RETENTION_AMT Number(27,3) DECIMAL(26,3) NOT NULL Retention Amount
    57 MFG_ITM_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer's Item ID
    58 ULTIMATE_USE_CD Character(8) VARCHAR2(8) NOT NULL Ultimate Use Code
    59 CNTRCT_LN_TYPE Character(1) VARCHAR2(1) NOT NULL Contract Line Type
    I=Item
    R=Role

    Default Value: I

    60 CNTR_LN_TYPE_ID Character(30) VARCHAR2(30) NOT NULL Contract Line Type ID
    61 AUC_GROUP_ID Character(18) VARCHAR2(18) NOT NULL GroupID
    62 DESCR254_MIXED2 Character(254) VARCHAR2(254) NOT NULL Long Description
    63 USER_LINE_CHAR1 Character(1) VARCHAR2(1) NOT NULL Custom Character 1
    64 CUSTOM_C100_B1 Character(100) VARCHAR2(100) NOT NULL Custom Field 1
    65 CUSTOM_C100_B2 Character(100) VARCHAR2(100) NOT NULL Custom Field 2
    66 CUSTOM_C100_B3 Character(100) VARCHAR2(100) NOT NULL Custom Field 3
    67 CUSTOM_C100_B4 Character(100) VARCHAR2(100) NOT NULL Custom Field 4
    68 CUSTOM_DATE_B Date(10) DATE Custom Date
    69 CUSTOM_C1_B Character(1) VARCHAR2(1) NOT NULL Custom Character 2
    70 OPRID_MODIFIED_BY Character(30) VARCHAR2(30) NOT NULL Last User to Modify Entered By 07/25/2011:Ensured that OPRID_MODIFIED_BY is set with format type of MixedCase.
    71 LAST_DTTM_UPDATE DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.