CNTRCT_LINE

(SQL Table)
 Index Back

Contract Line Item

Contract Line Item 06/19/2009 SK 1893227002 Resolved the issue so that voucher tax page fields displays prompt results based on accounts payable business unit.

  • 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
    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
    12 MFG_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer ID

    Prompt Table: MANUFACTURER

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

    Prompt Table: %EDIT_MFGITM_ID

    14 QTY_LINE_MIN Number(15,2) DECIMAL(14,2) NOT NULL Min Line Qty Per Order
    15 QTY_LINE_MAX Number(15,2) DECIMAL(14,2) NOT NULL Max Line Qty Per Contract
    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_RELSD_CUM Signed Number(28,3) DECIMAL(26,3) NOT NULL Cumulative Line Amt Released
    20 INCLUDE_FOR_RELS Character(1) VARCHAR2(1) NOT NULL Include for Release
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: Y

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

    Default Value: C

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

    Y/N Table Edit

    Default Value: N

    23 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

    24 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

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

    Default Value: Y

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

    Default Value: L

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

    Default Value: D

    28 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

    29 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

    30 MERCHANDISE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label
    31 TOTAL_DISTRIBS Number(5,0) INTEGER NOT NULL Total Number of Distributions
    32 MAX_DISTRIB_LINE Number(5,0) INTEGER NOT NULL Highest Distribution Line
    33 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.
    34 UNIT_PRICE Signed Number(17,5) DECIMAL(15,5) NOT NULL Unit Price
    35 TAX_CD Character(8) VARCHAR2(8) NOT NULL Tax Code

    Prompt Table: CNTRCT_TAX_VW

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

    Y/N Table Edit

    Default Value: Y

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

    Default Value: N

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

    Default Value: CNTRCT_HDR.CURRENCY_CD

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

    Y/N Table Edit

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

    Prompt Table: WTHD_CD_HDR

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

    Prompt Table: CNT_SHIPTO_VW

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

    Prompt Table: CNT_SHIPTO_VW

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

    Prompt Table: CNT_TAX_SALE_VW

    49 SUT_EXCPTN_TYPE Character(1) VARCHAR2(1) NOT NULL Sales/Use Tax Exception Type
    D=Direct Pay
    E=Exempt/Exonerated
    N=None
    50 SUT_EXCPTN_CERTIF Character(20) VARCHAR2(20) NOT NULL Sales/Use Tax Exception Certif
    51 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
    52 AMT_ONLY_FLG Character(1) VARCHAR2(1) NOT NULL Amount Only
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N

    53 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
    54 RETENTION_PCT Number(7,3) DECIMAL(6,3) NOT NULL Retention Percentage
    55 RETENTION_AMT Number(27,3) DECIMAL(26,3) NOT NULL Retention Amount
    56 ULTIMATE_USE_CD Character(8) VARCHAR2(8) NOT NULL Ultimate Use Code

    Prompt Table: C_SUT_USETRN_VW

    57 CNTRCT_LN_TYPE Character(1) VARCHAR2(1) NOT NULL Contract Line Type
    I=Item
    R=Role

    Default Value: I

    58 CNTR_LN_TYPE_ID Character(30) VARCHAR2(30) NOT NULL Contract Line Type ID
    59 AUC_GROUP_ID Character(18) VARCHAR2(18) NOT NULL GroupID
    60 DESCR254_MIXED2 Character(254) VARCHAR2(254) NOT NULL Long Description
    61 USER_LINE_CHAR1 Character(1) VARCHAR2(1) NOT NULL Custom Character 1
    62 CUSTOM_C100_B1 Character(100) VARCHAR2(100) NOT NULL Custom Field 1
    63 CUSTOM_C100_B2 Character(100) VARCHAR2(100) NOT NULL Custom Field 2
    64 CUSTOM_C100_B3 Character(100) VARCHAR2(100) NOT NULL Custom Field 3
    65 CUSTOM_C100_B4 Character(100) VARCHAR2(100) NOT NULL Custom Field 4
    66 CUSTOM_DATE_B Date(10) DATE Custom Date
    67 CUSTOM_C1_B Character(1) VARCHAR2(1) NOT NULL Custom Character 2
    68 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.
    69 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.