CA_PRDSAL_VW

(SQL View)
 Index Back

Product Sales View

Prouduct Sales View

SELECT TBL.CONTRACT_NUM , TBL.CONTRACT_LINE_NUM , HDR.DESCR , TBL.CUR_UNIT_REVENUE , TBL.PRODUCT_ID , TBL.IS_BIL_REV_SEP , TBL.SOLD_TO_CUST_ID , CUST.NAME1 , TBL.STANDALONE_SALE , TBL.PRICING_STRUCTURE , TBL.QTY , TBL.UNIT_OF_MEASURE , TBL.START_DT , TBL.END_DT , TBL.UNIT_BILLING , TBL.UNIT_REVENUE , TBL.GROSS_AMT , TBL.REVISED_REDUCT , TBL.NET_AMOUNT , TBL.LIMIT_AMT_BIL , TBL.NET_AMOUNT_REV , TBL.REVISED_REDUCT_REV , TBL.LIMIT_AMT_REV , TBL.RECURRING_AMOUNT , TBL.GROSS_AMT_REV , TBL.CURRENCY_CD , TBL.BUSINESS_UNIT , TBL.REVENUE_PROFILE , TBL.CONTRACT_TYPE , TBL.REGION_CD , TBL.CA_RQST_SRC , TBL.CONTRACT_ROLE , TBL.CONTR_LEGAL_ENTITY , TBL.BILL_TYPE_ID , TBL.MAST_CONTR_ID , TBL.SUBCUST_QUAL1 , TBL.SUBCUST_QUAL2 , TBL.BUNDLE_OFFERING , TBL.PRODUCT_GROUP , TBL.SEPARATE_BIL_REV , TBL.SEPARATE_BIL_REV_F , TBL.OPRID , TBL.RUN_CNTL_ID , TBL.PROCESS_INSTANCE , TBL.PROCESS_DTTM , TBL.REV_TRANS_IMP , TBL.REV_TRANS_STS , TBL.CONTRACT_TOTAL_REV , TBL.CURR_NET_REVENUE , TBL.REV_RECOG , TBL.CA_PER_COMPLETE , TBL.EXT_CURR_REV , TBL.TOTAL_CURR_REV , TBL.RELATIVE_PERCENT , TBL.REVENUE_SUGGEST , TBL.REVENUE_ADJ , TBL.REVENUE_RECOG_ADJ FROM PS_CA_PRDSAL_TBL TBL , PS_CA_CONTR_HDR HDR , PS_CUSTOMER CUST , PS_SET_CNTRL_REC REC WHERE TBL.CONTRACT_NUM = HDR.CONTRACT_NUM AND HDR.SOLD_TO_CUST_ID = CUST.CUST_ID AND HDR.BUSINESS_UNIT = REC.SETCNTRLVALUE AND REC.RECNAME ='CUSTOMER' AND REC.REC_GROUP_ID='FS_23' AND CUST.SETID = REC.SETID

  • Related Language Record: CA_PRDSAL_LG_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract
    2 CONTRACT_LINE_NUM Number(3,0) SMALLINT NOT NULL Contract Line Num
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 CUR_UNIT_REVENUE Signed Number(28,3) DECIMAL(26,3) NOT NULL Net Revenue Per Unit
    5 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
    6 IS_BIL_REV_SEP Character(1) VARCHAR2(1) NOT NULL Billing and Revenue Separated

    Y/N Table Edit

    7 SOLD_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Sold To Customer
    8 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
    9 STANDALONE_SALE Character(1) VARCHAR2(1) NOT NULL Standalone Sale

    Y/N Table Edit

    10 PRICING_STRUCTURE Character(4) VARCHAR2(4) NOT NULL Price Type
    AMT=Amount
    PCT=Percent
    RATE=Rate
    RCR=Recurring
    11 QTY Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity
    12 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
    MHR=Muti Hourly
    PER=Percentage
    SQF=Square Footage
    13 START_DT Date(10) DATE Start Date
    14 END_DT Date(10) DATE End Date
    15 UNIT_BILLING Signed Number(28,3) DECIMAL(26,3) NOT NULL Net Revenue Per Unit
    16 UNIT_REVENUE Signed Number(28,3) DECIMAL(26,3) NOT NULL Net Revenue Per Unit
    17 GROSS_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Gross Invoice Amount
    18 REVISED_REDUCT Signed Number(28,3) DECIMAL(26,3) NOT NULL Discounts/Surcharges
    19 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.
    20 LIMIT_AMT_BIL Signed Number(28,3) DECIMAL(26,3) NOT NULL Funded/Billing Limit Amount
    21 NET_AMOUNT_REV Signed Number(28,3) DECIMAL(26,3) NOT NULL Revenue Amount
    22 REVISED_REDUCT_REV Signed Number(28,3) DECIMAL(26,3) NOT NULL Total Contract Revenue Discount Amount
    23 LIMIT_AMT_REV Signed Number(28,3) DECIMAL(26,3) NOT NULL Revenue Limit Amount
    24 RECURRING_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Recurring line amount
    25 GROSS_AMT_REV Signed Number(28,3) DECIMAL(26,3) NOT NULL Revenue Amount
    26 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
    27 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    28 REVENUE_PROFILE Character(15) VARCHAR2(15) NOT NULL Contract Revenue Profile
    29 CONTRACT_TYPE Character(15) VARCHAR2(15) NOT NULL Contract Type
    30 REGION_CD Character(10) VARCHAR2(10) NOT NULL Identifies the Sales Region. Populated on the Item Table to identify the Sales Region the Item is applied to.
    31 CA_RQST_SRC Character(3) VARCHAR2(3) NOT NULL Contract Classification
    FED=Federal Reimbursable Agreement
    GEN=Generic Application
    GOV=Government
    INT=Internal
    OND=CRM Field Services On Demand
    STD=Standard
    32 CONTRACT_ROLE Character(15) VARCHAR2(15) NOT NULL Contract Role
    33 CONTR_LEGAL_ENTITY Character(15) VARCHAR2(15) NOT NULL Contract Legal Entity
    34 BILL_TYPE_ID Character(3) VARCHAR2(3) NOT NULL Bill Type Identifier
    35 MAST_CONTR_ID Character(25) VARCHAR2(25) NOT NULL Master Contract #
    36 SUBCUST_QUAL1 Character(15) VARCHAR2(15) NOT NULL Specifies a user-defined grouping of customer receivables activity. A subcustomer qualifier provides the ability to record and report receivables activity across multiple business units and/or multiple customers. For example a subcustomer qualifier could represent a sales region or a geographic area. There are two possible subcustomer qualifiers: SUBCUST_QUAL1 and SUBCUST_QUAL2.
    37 SUBCUST_QUAL2 Character(15) VARCHAR2(15) NOT NULL Specifies a user-defined grouping of customer receivables activity. A subcustomer qualifier provides the ability to record and report receivables activity across multiple business units and/or multiple customers. For example a subcustomer qualifier could represent a sales region or a geographic area. There are two possible subcustomer qualifiers: SUBCUST_QUAL1 and SUBCUST_QUAL2.
    38 BUNDLE_OFFERING Character(20) VARCHAR2(20) NOT NULL Bundle
    39 PRODUCT_GROUP Character(10) VARCHAR2(10) NOT NULL Product Group
    40 SEPARATE_BIL_REV Character(1) VARCHAR2(1) NOT NULL Flag used by Governement Contracts to separate Billing and Revenue transactions
    41 SEPARATE_BIL_REV_F Character(1) VARCHAR2(1) NOT NULL Flag used to separate Billing and Revenue for Amount based contract lines.
    42 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    43 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
    44 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
    45 PROCESS_DTTM DateTime(26) TIMESTAMP Process Date Time
    46 REV_TRANS_IMP Character(1) VARCHAR2(1) NOT NULL Revenue Transition Impact
    1=Materially Impacted
    2=Not Materially Impacted
    3=Not Yet Determined
    4=Post Transition
    47 REV_TRANS_STS Character(1) VARCHAR2(1) NOT NULL Revenue Transition Status
    1=Not Initiated
    2=In Preliminary Review
    3=Review Complete
    4=Contract Updated
    5=Post Transition
    48 CONTRACT_TOTAL_REV Signed Number(28,3) DECIMAL(26,3) NOT NULL Total Revenue Amount
    49 CURR_NET_REVENUE Signed Number(28,3) DECIMAL(26,3) NOT NULL Current Revenue Amount
    50 REV_RECOG Signed Number(28,3) DECIMAL(26,3) NOT NULL Revenue Recognized
    51 CA_PER_COMPLETE Number(12,8) DECIMAL(11,8) NOT NULL Percent Complete
    52 EXT_CURR_REV Signed Number(28,3) DECIMAL(26,3) NOT NULL Current Revenue Price
    53 TOTAL_CURR_REV Signed Number(28,3) DECIMAL(26,3) NOT NULL Total Current Revenue Amount
    54 RELATIVE_PERCENT Signed Number(13,8) DECIMAL(11,8) NOT NULL Allocation Percent
    55 REVENUE_SUGGEST Signed Number(28,3) DECIMAL(26,3) NOT NULL Suggested Revenue
    56 REVENUE_ADJ Signed Number(28,3) DECIMAL(26,3) NOT NULL Adjustment to Revenue Amount
    57 REVENUE_RECOG_ADJ Signed Number(28,3) DECIMAL(26,3) NOT NULL Adjustment to Revenue Recognized