CS_CT_LINE_OB

(SQL Table)
 Index Back

Contract Line Item

3/3/08 RMK F-AHAYT-S60K7 Version control enhancement to contract entry - added version_nbr field; record is used for syndication for current contract

  • Parent record: CNTRCT_HDR

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SUBNODE Character(30) VARCHAR2(30) NOT NULL Subscribing Node
    2 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    3 CNTRCT_ID Character(25) VARCHAR2(25) NOT NULL Buying Agreement ID
    4 CNTRCT_LINE_NBR Number(5,0) INTEGER NOT NULL Buying Agreement Line Nbr

    Default Value: 1

    5 VERSION_NBR Number(5,0) INTEGER NOT NULL Contract Version number
    6 LINE_STATUS Character(1) VARCHAR2(1) NOT NULL Line Status
    A=Active
    C=Cancelled
    I=Inactive
    O=Open
    P=Pending

    Default Value: O

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

    Prompt Table: %EDITTABLE13

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

    Prompt Table: MANUFACTURER

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

    Prompt Table: %EDIT_MFGITM_ID

    15 QTY_LINE_MIN Number(15,2) DECIMAL(14,2) NOT NULL Min Line Qty Per Order
    16 QTY_LINE_MAX Number(15,2) DECIMAL(14,2) NOT NULL Max Line Qty Per Contract
    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 INCLUDE_FOR_RELS Character(1) VARCHAR2(1) NOT NULL Include for Release
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: Y

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

    Default Value: C

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

    Y/N Table Edit

    Default Value: N

    22 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

    23 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

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

    Default Value: Y

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

    Default Value: L

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

    Default Value: D

    27 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

    28 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

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

    Prompt Table: CNTRCT_TAX_VW

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

    Y/N Table Edit

    Default Value: Y

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

    Default Value: N

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

    Default Value: CNTRCT_HDR.CURRENCY_CD

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

    Y/N Table Edit

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

    Prompt Table: WTHD_CD_HDR

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

    Prompt Table: SHIPTO_TBL

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

    Prompt Table: SHIPTO_TBL

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

    Prompt Table: TAX_SALE_VW

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

    Y/N Table Edit

    Default Value: N

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

    Prompt Table: SUT_USETRN_VW

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

    Default Value: I

    57 CNTR_LN_TYPE_ID Character(30) VARCHAR2(30) NOT NULL Contract Line Type ID
    58 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence
    59 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
    60 USER_LINE_CHAR1 Character(1) VARCHAR2(1) NOT NULL Custom Character 1
    61 CUSTOM_C100_B1 Character(100) VARCHAR2(100) NOT NULL Custom Field 1
    62 CUSTOM_C100_B2 Character(100) VARCHAR2(100) NOT NULL Custom Field 2
    63 CUSTOM_C100_B3 Character(100) VARCHAR2(100) NOT NULL Custom Field 3
    64 CUSTOM_C100_B4 Character(100) VARCHAR2(100) NOT NULL Custom Field 4
    65 CUSTOM_DATE_B Date(10) DATE Custom Date
    66 CUSTOM_C1_B Character(1) VARCHAR2(1) NOT NULL Custom Character 2