CA_DETAIL_VW3

(SQL View)
 Index Back

SELECT CONTRACT_NUM , CONTRACT_LINE_NUM , CHG_ID , CHG_STATUS , ACCT_PLAN_ID , APPLIES_TO , BILL_PLAN_ID , BPLAN_LN_NBR , BOOK_CA_TO_DFR , ADDR_SEQ_NUM_SHIP , ALLOC_IN_PROGRESS , BUSINESS_UNIT_PC , CNTCT_SEQ_SHIP , DST_ID , CURRENCY_CD , DESCR , DISCOUNT_ID , END_DT , GROSS_AMT , LASTUPDDTTM , LASTUPDOPRID , CA_LINE_STATUS , LIST_PRICE , NET_AMOUNT , ADHOC_OFFERING , PERCENTAGE , PRICING_STRUCTURE , PRODUCT_ID , PRODUCT_GROUP , QTY , RENEWABLE , RETAINAGE_ID , REV_RECOG_METHOD , RNW_TEMPLATE_ID , START_DT , SHIP_TO_CUST_ID , TAX_CD , TAX_EXEMPT_FLG , TAX_EXEMPT_CERT , TAX_GROUP , TAX_TRANS_TYPE , TAX_TRANS_SUB_TYPE , THIRD_PARTY_FLG , UNIT_OF_MEASURE , PREPAID_FLAG , BILLED_PREPAID_AMT , DFR_REV_PROCESSED , DFR_REV_ACCT_DT , RNW_LINKED , RNW_PKG_ID , RNW_CYCLE_NBR , SOURCE_RNW_PKG_ID , SOURCE_RNW_CYCLE FROM PS_CA_DETAIL

  • Related Language Record: CA_DETAIL_LANG

    • # 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
    3 CHG_ID Character(10) VARCHAR2(10) NOT NULL Change Package Identifier. This is sequenced from 1 to N for each contract.
    4 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
    5 ACCT_PLAN_ID Character(10) VARCHAR2(10) NOT NULL Revenue Recognition Plan

    Prompt Table: CA_ACCTPLAN

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

    Prompt Table: CA_CUST_SHIP_VW

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

    Y/N Table Edit

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

    Prompt Table: SP_BU_PC_NONVW

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

    Prompt Table: CA_CUST_CNCT_VW

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

    Prompt Table: BUS_UNIT_TBL_CA

    16 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    17 DISCOUNT_ID Character(15) VARCHAR2(15) NOT NULL Discount ID

    Prompt Table: CA_DISC_SUR_VW1

    18 END_DT Date(10) DATE End Date
    19 GROSS_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Gross Invoice Amount
    20 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

    21 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.
    22 CA_LINE_STATUS Character(1) VARCHAR2(1) NOT NULL Obligation status
    A=Active
    C=Cancelled
    P=Pending
    R=Renewed
    23 LIST_PRICE Signed Number(17,4) DECIMAL(15,4) NOT NULL List Price
    24 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.
    25 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
    26 PERCENTAGE Signed Number(7,2) DECIMAL(5,2) NOT NULL Percentage
    27 PRICING_STRUCTURE Character(4) VARCHAR2(4) NOT NULL Price Type
    AMT=Amount
    PCT=Percent
    RATE=Rate
    RCR=Recurring
    28 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
    29 PRODUCT_GROUP Character(10) VARCHAR2(10) NOT NULL Product Group
    30 QTY Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity

    Default Value: 1

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

    Y/N Table Edit

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

    Prompt Table: CA_DISC_SUR_VW2

    33 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
    34 RNW_TEMPLATE_ID Character(10) VARCHAR2(10) NOT NULL Renewal Plan Template
    35 START_DT Date(10) DATE Start Date
    36 SHIP_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Ship To Customer

    Prompt Table: BI_SHIP_TO_VW

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

    Prompt Table: CA_TAX_CD_VW

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

    Y/N Table Edit

    Default Value: N

    39 TAX_EXEMPT_CERT Character(30) VARCHAR2(30) NOT NULL Exemption Certificate
    40 TAX_GROUP Character(10) VARCHAR2(10) NOT NULL Tax Group

    Prompt Table: CA_TAX_GROUP_VW

    41 TAX_TRANS_TYPE Character(1) VARCHAR2(1) NOT NULL Transaction Type
    1=Sale
    2=Rental
    3=Service
    4=Purchase
    5=Lease
    B=Return
    42 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
    43 THIRD_PARTY_FLG Character(1) VARCHAR2(1) NOT NULL Third Party Flag

    Y/N Table Edit

    44 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

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

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

    48 DFR_REV_ACCT_DT Date(10) DATE Deferred Revenue Acctg Date
    49 RNW_LINKED Character(1) VARCHAR2(1) NOT NULL PSIRS-KK

    Default Value: N

    50 RNW_PKG_ID Character(10) VARCHAR2(10) NOT NULL PSIRS-KK
    51 RNW_CYCLE_NBR Number(6,0) INTEGER NOT NULL PSIRS-KK
    52 SOURCE_RNW_PKG_ID Character(10) VARCHAR2(10) NOT NULL PSIRS-KK
    53 SOURCE_RNW_CYCLE Number(6,0) INTEGER NOT NULL PSIRS-KK