CA_DETAIL

(SQL Table)
 Index Back

Contract Line

  • Related Language Record: CA_DETAIL_LANG

  • Parent Record Of CA_LMT_FEE_DTL CA_LMT_FEE_DT_H CA_LMT_TXN CA_LMT_TXN_H CA_LMT_TXN_LG CA_LMT_TXN_LG_H

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract

    Prompt Table: CA_CNTR_SRCH_VW

    2 CONTRACT_LINE_NUM Number(3,0) SMALLINT NOT NULL Contract Line Num

    Prompt Table: CA_DETAIL

    3 PRICING_STRUCTURE Character(4) VARCHAR2(4) NOT NULL Price Type
    AMT=Amount
    PCT=Percent
    RATE=Rate
    RCR=Recurring
    4 CHG_ID Character(10) VARCHAR2(10) NOT NULL Change Package Identifier. This is sequenced from 1 to N for each contract.
    5 CHG_STATUS Character(1) VARCHAR2(1) NOT NULL Change Status indicates if this change package is open for further edit: pending, ready for processing by the app. engine component of contract change management (ready) or complete, meaning that no further edit is possible and all changes have been aplied.
    C=Complete
    P=Pending
    R=Ready
    X=Cancelled
    6 ACCT_PLAN_ID Character(10) VARCHAR2(10) NOT NULL Revenue Recognition Plan

    Prompt Table: CA_ACCTPLAN

    7 APPLIES_TO Character(4) VARCHAR2(4) NOT NULL PSIRS-KK
    HDR=% of Total Contract Amount
    LINE=% of Contract Lines
    8 BILL_PLAN_ID Character(10) VARCHAR2(10) NOT NULL Billing Plan ID
    9 BPLAN_LN_NBR Number(3,0) SMALLINT NOT NULL Bill Plan Line Number
    10 BOOK_CA_TO_DFR Character(1) VARCHAR2(1) NOT NULL Deferred revenue accounting

    Y/N Table Edit

    Default Value: N

    11 ADDR_SEQ_NUM_SHIP Number(5,0) INTEGER NOT NULL Address Sequence Number

    Prompt Table: CA_CUST_SHIP_VW

    12 ALLOC_IN_PROGRESS Character(1) VARCHAR2(1) NOT NULL Allocation In Progress

    Y/N Table Edit

    13 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit

    Prompt Table: SP_BU_PC_NONVW

    14 CNTCT_SEQ_SHIP Number(5,0) INTEGER NOT NULL Primary Contact - Ship To

    Prompt Table: CUST_CNCT_SH_VW

    15 DST_ID Character(10) VARCHAR2(10) NOT NULL Distribution Code
    16 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Prompt Table: BUS_UNIT_TBL_CA

    17 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    18 BUNDLE_OFFERING Character(20) VARCHAR2(20) NOT NULL Offering ID

    Prompt Table: CA_BUNDLE_VW

    19 PRODUCT_KIT_ID Character(18) VARCHAR2(18) NOT NULL Product Kit Number
    20 DISCOUNT_ID Character(15) VARCHAR2(15) NOT NULL Discount ID

    Prompt Table: CA_DISC_SUR_VW1

    21 END_DT Date(10) DATE End Date
    22 GROSS_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Gross Invoice Amount
    23 GROSS_AMT_REV Signed Number(28,3) DECIMAL(26,3) NOT NULL Revenue Amount
    24 LASTUPDDTTM 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.

    Default Value: %DATE

    25 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    26 CA_LINE_STATUS Character(1) VARCHAR2(1) NOT NULL Obligation status
    A=Active
    C=Cancelled
    P=Pending
    R=Renewed

    Default Value: A

    27 LIST_PRICE Signed Number(17,4) DECIMAL(15,4) NOT NULL List Price
    28 LIST_PRICE_REV Signed Number(17,4) DECIMAL(15,4) NOT NULL Revenue Price
    29 NET_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL The resulting net amount related to settlement cash flows subject to counterparty netting agreements.
    30 UNIT_BILLING Signed Number(28,3) DECIMAL(26,3) NOT NULL Net Revenue Per Unit
    31 NET_AMOUNT_REV Signed Number(28,3) DECIMAL(26,3) NOT NULL Revenue Amount
    32 UNIT_REVENUE Signed Number(28,3) DECIMAL(26,3) NOT NULL Net Revenue Per Unit
    33 RECURRING_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Recurring line amount
    34 ADHOC_OFFERING Character(1) VARCHAR2(1) NOT NULL Ad hoc Product
    C=Converted from Ad Hoc
    D=Non-unique Ad Hoc Line
    N=Product
    Y=Ad Hoc Product

    Default Value: N

    35 PHYSICAL_NATURE Character(1) VARCHAR2(1) NOT NULL Physical Nature
    G=Goods
    S=Services

    Default Value: G

    36 PERCENTAGE Signed Number(7,2) DECIMAL(5,2) NOT NULL Percentage
    37 PERCENTAGE1 Signed Number(7,2) DECIMAL(5,2) NOT NULL Percentage
    38 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
    39 PRODUCT_GROUP Character(10) VARCHAR2(10) NOT NULL Product Group
    40 QTY Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity

    Default Value: 1

    41 RENEWABLE Character(1) VARCHAR2(1) NOT NULL Renewable

    Y/N Table Edit

    Default Value: N

    42 RETAINAGE_ID Character(15) VARCHAR2(15) NOT NULL Retainage ID

    Prompt Table: CA_DISC_SUR_VW2

    43 REV_RECOG_METHOD Character(4) VARCHAR2(4) NOT NULL Revenue Recognition Method
    1=As Incurred
    2=Apportionment
    3=Percent Complete
    4=Milestone
    5=Billing Manages Revenue
    44 RNW_TEMPLATE_ID Character(10) VARCHAR2(10) NOT NULL Renewal Plan Template

    Y/N Table Edit

    45 START_DT Date(10) DATE Start Date
    46 SHIP_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Ship To Customer

    Prompt Table: %EDITTABLE2

    47 SHIP_FROM_LOC Character(10) VARCHAR2(10) NOT NULL Ship From Location

    Default Value: BUS_UNIT_TBL_CA.SHIP_FROM_LOC

    48 TAX_CD Character(8) VARCHAR2(8) NOT NULL Tax Code

    Prompt Table: CA_TAX_CD_VW

    49 TAX_EXEMPT_FLG Character(1) VARCHAR2(1) NOT NULL Tax Exempt Flag

    Y/N Table Edit

    Default Value: N

    50 TAX_EXEMPT_CERT Character(30) VARCHAR2(30) NOT NULL Exemption Certificate
    51 TAX_GROUP Character(10) VARCHAR2(10) NOT NULL Tax Group

    Prompt Table: CA_TAX_GROUP_VW

    52 TAX_TRANS_TYPE Character(1) VARCHAR2(1) NOT NULL Transaction Type
    1=Sale
    2=Rental
    3=Service
    4=Purchase
    5=Lease
    B=Return
    53 TAX_TRANS_SUB_TYPE Character(1) VARCHAR2(1) NOT NULL Transaction Sub Type
    1=Property
    2=Freight
    3=Service
    4=Rental or Lease
    5=Expense
    6=Misc
    N=None
    54 THIRD_PARTY_FLG Character(1) VARCHAR2(1) NOT NULL Third Party Flag

    Y/N Table Edit

    55 TIER_PRICE_SW Character(1) VARCHAR2(1) NOT NULL Tiered Pricing Switch

    Y/N Table Edit

    Default Value: N

    56 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: UNITS_TBL

    57 PREPAID_FLAG Character(1) VARCHAR2(1) NOT NULL Prepaid offering
    N=Exclude Prepaid
    Y=Include Prepaid

    Y/N Table Edit

    Default Value: N

    58 BILLED_PREPAID_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount Billed for PPD Balance
    59 DFR_REV_PROCESSED Character(1) VARCHAR2(1) NOT NULL Contract Liability Status
    A=Amendment
    I=Reversal Initiated
    N=Ready
    R=Reversed
    Y=Completed

    Default Value: N

    60 DFR_REV_ACCT_DT Date(10) DATE Deferred Revenue Acctg Date
    61 DFRREV_REVERSAL_DT Date(10) DATE Deferred Revenue Reversal Accounting Date
    62 RNW_LINKED Character(1) VARCHAR2(1) NOT NULL PSIRS-KK

    Default Value: N

    63 RNW_PKG_ID Character(10) VARCHAR2(10) NOT NULL PSIRS-KK

    Prompt Table: CA_RNW_TEMPLATE

    64 RNW_CYCLE_NBR Number(6,0) INTEGER NOT NULL PSIRS-KK
    65 SOURCE_RNW_PKG_ID Character(10) VARCHAR2(10) NOT NULL PSIRS-KK
    66 SOURCE_RNW_CYCLE Number(6,0) INTEGER NOT NULL PSIRS-KK
    67 LOC_DOC_ID Character(30) VARCHAR2(30) NOT NULL Letter of Credit Document ID
    68 ESTIMATED_START_DT Date(10) DATE Estimated Start Date
    69 ESTIMATED_COMP_DT Date(10) DATE Estimated Completion Date
    70 ESTIMATED_AMOUNT Number(27,3) DECIMAL(26,3) NOT NULL Estimated Amount SCP - Added new label - Estimated Cost
    71 CA_PROBABILITY Number(3,0) SMALLINT NOT NULL Probability

    Default Value: 100

    72 LAST_DTTIME DateTime(26) TIMESTAMP Last Forecast Run
    73 CA_TXN_SOURCE Character(3) VARCHAR2(3) NOT NULL Contracts Transaction Source
    CRM=CRM Transaction
    FPC=Projects Transaction
    FRE=Lease Administration Trans.

    Default Value: FPC

    74 SETID_AGR Character(5) VARCHAR2(5) NOT NULL Agreement SetID
    75 AGREEMENT_CODE Character(30) VARCHAR2(30) NOT NULL This field represents the agreement code (name) for an agreement
    76 AGR_RENEWAL_NUM Number(4,0) SMALLINT NOT NULL This field represents the agreement renewal number (agreements begin at a value of one and the number is incremented with every renewal)
    77 REVIEW_TIMING Number(3,0) SMALLINT NOT NULL Review Timing
    78 RENEWAL_ACTION Character(4) VARCHAR2(4) NOT NULL Renewal Action
    AUTO=Automatic
    MANL=Manual
    79 NOT_TO_BE_RENEWED Character(1) VARCHAR2(1) NOT NULL Not To Be Renewed

    Y/N Table Edit

    Default Value: N

    80 LIMIT_BI_CNTRL_FLG Character(1) VARCHAR2(1) NOT NULL Control Limits and Billing

    Y/N Table Edit

    Default Value: N

    81 CA_FEE_TYPE Character(2) VARCHAR2(2) NOT NULL Cost Plus Fee Type
    01=None
    02=Fixed Fee
    03=Award Fee
    04=Incentive Fee
    05=Other Fee

    Default Value: 01

    82 CA_PGP_SEQ Number(3,0) SMALLINT NOT NULL Progress Payment Sequence
    83 CA_DELIVERY_STATUS Character(1) VARCHAR2(1) NOT NULL Contracts Delivery Status
    F=Final Delivery
    P=Partial Delivery
    U=Undelivered

    Default Value: U

    84 IPAC_PYMNT_METHOD Character(1) VARCHAR2(1) NOT NULL IPAC Payment Method
    B=Buyer IPAC
    O=Other
    S=Seller IPAC
    85 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

    Default Value: 0

    86 SUB_ACCOUNT_NUM Character(50) VARCHAR2(50) NOT NULL Subaccount ID
    87 LOC_DOC_INACTIVE Character(1) VARCHAR2(1) NOT NULL Inactive Doc ID

    Y/N Table Edit

    Default Value: N

    88 LOC_DOC_ID_END_DT Date(10) DATE LOC Doc ID End Date
    89 STANDALONE_SALE Character(1) VARCHAR2(1) NOT NULL Standalone Sale

    Y/N Table Edit

    Default Value: N

    90 OVERRIDE_REVENUE Character(1) VARCHAR2(1) NOT NULL Override Revenue

    Y/N Table Edit

    Default Value: Y

    91 HOLD_UNPAID_BI Character(1) VARCHAR2(1) NOT NULL Hold Billing on Unpaid Cost

    Y/N Table Edit

    92 HOLD_UNPAID_REV Character(1) VARCHAR2(1) NOT NULL Hold Revenue on Unpaid Cost

    Y/N Table Edit