Contract Num is selected twice because we need it as a non-key too in CA_AP_MANAGE1.

CA_AP_VW

(SQL View)
 Index Back

SELECT DISTINCT A.CONTRACT_NUM , A.ACCT_PLAN_ID ,A.DESCR ,A.AP_STATUS ,B.CA_RQST_SRC ,A.CUST_ID ,A.HOLD_FLAG ,A.HOLD_DATE ,A.REV_RECOG_METHOD ,A.START_DT ,A.END_DT ,A.SCHEDULE ,A.CA_PER_COMPLETE ,A.LAST_REV_REC_DT ,A.LAST_MAINT_DTTM ,A.LAST_MAINT_OPRID ,A.PROJECT_ID ,A.REGION_CD ,A.CONTR_LEGAL_ENTITY ,B.BUSINESS_UNIT ,B.CA_PROC_STATUS ,C.BUSINESS_UNIT_GL ,A.CONTRACT_NUM , DET.CA_FEE_TYPE FROM PS_CA_ACCTPLAN A , PS_CA_CONTR_HDR B , PS_BUS_UNIT_TBL_CA C , PS_CA_DETAIL DET WHERE A.CONTRACT_NUM = B.CONTRACT_NUM AND B.BUSINESS_UNIT = C.BUSINESS_UNIT AND DET.CONTRACT_NUM = A.CONTRACT_NUM AND DET.ACCT_PLAN_ID = A.ACCT_PLAN_ID AND NOT EXISTS ( SELECT 'X' FROM PS_CA_STATUS_TBL STS , PS_SET_CNTRL_REC ST WHERE ST.SETCNTRLVALUE = B.BUSINESS_UNIT AND ST.RECNAME = 'CA_STATUS_TBL' AND STS.SETID = ST.SETID AND STS.CA_STATUS = B.CA_STATUS AND STS.CA_PROC_STATUS = 'C')

  • Related Language Record: CA_AP_LVW

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

    Prompt Table: CA_CONTR_HDR

    2 ACCT_PLAN_ID Character(10) VARCHAR2(10) NOT NULL Revenue Recognition Plan

    Default Value: NEXT

    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 AP_STATUS Character(3) VARCHAR2(3) NOT NULL Rev Rec Plan Status
    CAN=Cancelled
    DON=Completed
    NEW=Pending
    PRG=In Progress
    RDY=Ready
    RIP=Reversal in Progress
    RQD=Action Required
    RVS=Reversed
    5 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
    6 SOLD_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Sold To Customer
    7 HOLD_FLAG Character(1) VARCHAR2(1) NOT NULL Hold
    N=Hold
    Y=Hold

    Y/N Table Edit

    Default Value: N

    8 HOLD_DATE Date(10) DATE Put On Hold Date
    9 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
    10 START_DT Date(10) DATE Start Date
    11 END_DT Date(10) DATE End Date
    12 SCHEDULE Character(10) VARCHAR2(10) NOT NULL Schedule ID

    Prompt Table: SCHEDULE_TBL

    13 CA_PER_COMPLETE Number(12,8) DECIMAL(11,8) NOT NULL Percent Complete
    14 LAST_REV_REC_DT Date(10) DATE Processed On
    15 LAST_MAINT_DTTM DateTime(26) TIMESTAMP A system generated value that reflects the date and time a transaction was last modified
    16 LAST_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Maintained By Operator ID
    17 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
    18 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.
    19 CONTR_LEGAL_ENTITY Character(15) VARCHAR2(15) NOT NULL Contract Legal Entity
    20 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    21 CA_PROC_STATUS Character(1) VARCHAR2(1) NOT NULL CA_STATUS is a user defined status field that maps (many to 1) to the contract Processing Status field. Process Status indicates what change processing is available.
    A=Active
    C=Closed
    P=Pending
    22 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit
    23 CONTRACT_NUM_CA Character(25) VARCHAR2(25) NOT NULL Contract Number
    24 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