PC_RPO_CAL_VW

(SQL View)
 Index Back

PC_RPO

View bringing back accounting and fiscal period of PC_RPO rows.

SELECT DISTINCT A.BUSINESS_UNIT ,A.PROJECT_ID ,A.ACTIVITY_ID ,A.KEY_CHAR_40_01 ,A.RESOURCE_ID_FROM ,A.BUSINESS_UNIT_GL ,A.JOURNAL_ID ,A.JOURNAL_DATE ,B.FISCAL_YEAR ,B.ACCOUNTING_PERIOD ,A.ACCOUNT ,A.ALTACCT , A.DEPTID ,%subrec(CF16_AN_SBR, A) ,A.BUS_UNIT_GL_FROM ,A.CURRENCY_CD ,A.STATISTICS_CODE ,A.LEDGER_GROUP ,A.ANALYSIS_TYPE ,A.RESOURCE_TYPE ,A.RESOURCE_CATEGORY ,A.RESOURCE_SUB_CAT ,A.RES_USER1 ,A.RES_USER2 ,A.RES_USER3 ,A.RES_USER4 ,A.RES_USER5 ,A.TRANS_DT ,A.ACCOUNTING_DT ,A.OPRID ,A.DTTM_STAMP ,A.FOREIGN_CURRENCY ,A.RT_TYPE ,A.FOREIGN_AMOUNT ,A.RATE_MULT ,A.RATE_DIV ,A.CUR_EFFDT ,A.PROCESS_INSTANCE ,A.PC_DISTRIB_STATUS ,A.GL_DISTRIB_STATUS ,A.PROJ_TRANS_TYPE ,A.PROJ_TRANS_CODE ,A.RESOURCE_STATUS ,A.DESCR ,A.SYSTEM_SOURCE ,A.UNIT_OF_MEASURE ,A.EMPLID ,A.TIME_RPTG_CD ,A.JOBCODE ,A.COMPANY ,A.BUSINESS_UNIT_AP ,A.VENDOR_ID ,A.VOUCHER_ID ,A.BUSINESS_UNIT_PO ,A.REQ_ID ,A.PO_ID ,A.AM_DISTRIB_STATUS ,A.BUSINESS_UNIT_AM ,A.ASSET_ID ,A.PROFILE_ID ,A.COST_TYPE ,A.BOOK ,A.INCENTIVE_ID ,A.CONTRACT_NUM ,A.BUSINESS_UNIT_BI ,A.BILLING_DATE ,A.INVOICE ,A.REV_DISTRIB_STATUS ,A.BUSINESS_UNIT_AR ,A.CUST_ID ,A.ITEM ,A.BUSINESS_UNIT_IN ,A.INV_ITEM_ID ,A.BUSINESS_UNIT_OM ,A.ORDER_NO ,A.RESOURCE_QUANTITY ,A.RESOURCE_AMOUNT ,A.BUDGET_HDR_STATUS ,A.BUDGET_DT ,A.LEDGER ,A.BUSINESS_UNIT_BD FROM PS_PC_RPO A , PS_CAL_DETP_TBL B , PS_BUS_UNIT_TBL_PC C , PS_SET_CNTRL_REC D WHERE A.ACCOUNTING_DT BETWEEN B.BEGIN_DT AND B.END_DT AND A.BUSINESS_UNIT = C.BUSINESS_UNIT AND C.CALENDAR_ID = B.CALENDAR_ID AND A.BUSINESS_UNIT = D.SETCNTRLVALUE AND D.RECNAME = 'CAL_DEFN_TBL' AND B.SETID = D.SETID

  • Parent record: PROJ_ACTIVITY

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Default Value: PROJ_ACTIVITY.BUSINESS_UNIT

    Prompt Table: SP_BU_PC_NONVW

    2 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField

    Default Value: PROJ_ACTIVITY.PROJECT_ID

    Prompt Table: PROJ_SCRTY_SRCH

    3 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID

    Default Value: PROJ_ACTIVITY.ACTIVITY_ID

    Prompt Table: PROJ_ACT_SRCH

    4 KEY_CHAR_40_01 Character(40) VARCHAR2(40) NOT NULL Key Char 40/01
    5 RESOURCE_ID_FROM Character(40) VARCHAR2(40) NOT NULL Original Transaction ID
    6 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit

    Prompt Table: PC_INT_TMPL_GL

    7 JOURNAL_ID Character(10) VARCHAR2(10) NOT NULL Identifies a journal entry, consisting of a header and one or more lines. The Journal ID itself does not have to be unique, but together with the journal business unit and journal date, it forms a unique journal identifier.

    Prompt Table: PC_GL_JRNL_VW

    8 JOURNAL_DATE Date(10) DATE Specifies the date the journal was created.

    Default Value: %date

    9 FISCAL_YEAR Number(4,0) SMALLINT NOT NULL Fiscal Year
    10 ACCOUNTING_PERIOD Number(3,0) SMALLINT NOT NULL Identifies a time period to which you post transactions. Typically, an accounting period represents a month, but it can also represent a week, a day, or any user-defined interval. An accounting period has a beginning date and an ending date, and is defined in the calendar table.
    11 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account

    Prompt Table: GL_ACCT_BUGL_VW

    12 ALTACCT Character(10) VARCHAR2(10) NOT NULL Alternate Account

    Prompt Table: ALT_BUGL_VW

    13 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

    Prompt Table: DEPTID_BUGL_VW

    14 OPERATING_UNIT Character(8) VARCHAR2(8) NOT NULL Operating Unit ChartField

    Prompt Table: OPERUNT_BUGL_VW

    15 PRODUCT Character(6) VARCHAR2(6) NOT NULL Product ChartField

    Prompt Table: PRODUCT_BUGL_VW

    16 FUND_CODE Character(5) VARCHAR2(5) NOT NULL Fund Code

    Prompt Table: FUND_BUGL_VW

    17 CLASS_FLD Character(5) VARCHAR2(5) NOT NULL Class Field

    Prompt Table: CLASSCF_BUGL_VW

    18 PROGRAM_CODE Character(5) VARCHAR2(5) NOT NULL Program Code ChartField

    Prompt Table: PROGRAM_BUGL_VW

    19 BUDGET_REF Character(8) VARCHAR2(8) NOT NULL Budget Reference

    Prompt Table: BUD_REF_BUGL_VW

    20 AFFILIATE Character(5) VARCHAR2(5) NOT NULL Affiliate

    Prompt Table: AFFILIATE_VW

    21 AFFILIATE_INTRA1 Character(10) VARCHAR2(10) NOT NULL IntraUnit Affiliate1

    Prompt Table: %EDIT_INTRA01

    22 AFFILIATE_INTRA2 Character(10) VARCHAR2(10) NOT NULL Operating Unit Affiliate

    Prompt Table: %EDIT_INTRA02

    23 CHARTFIELD1 Character(10) VARCHAR2(10) NOT NULL Expansion chartfield 1

    Prompt Table: CF1_BUGL_VW

    24 CHARTFIELD2 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 2

    Prompt Table: CF2_BUGL_VW

    25 CHARTFIELD3 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 3

    Prompt Table: CF3_BUGL_VW

    26 BUS_UNIT_GL_FROM Character(5) VARCHAR2(5) NOT NULL From Business Unit GL

    Prompt Table: PC_INT_TMPL_GL

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

    Default Value: BUS_UNIT_TBL_PC.CURRENCY_CD

    Prompt Table: CURRENCY_CD_TBL

    28 STATISTICS_CODE Character(3) VARCHAR2(3) NOT NULL Statistics Code

    Prompt Table: STAT_BUGL_VW

    29 LEDGER_GROUP Character(10) VARCHAR2(10) NOT NULL Ledger Group

    Prompt Table: BU_LED_GRP_VW2

    30 ANALYSIS_TYPE Character(3) VARCHAR2(3) NOT NULL Analysis Type

    Prompt Table: PROJ_AN_GRP_VW

    31 RESOURCE_TYPE Character(5) VARCHAR2(5) NOT NULL Source Type

    Prompt Table: PROJ_RES_TYPE

    32 RESOURCE_CATEGORY Character(5) VARCHAR2(5) NOT NULL Category

    Prompt Table: %EDITTABLE

    33 RESOURCE_SUB_CAT Character(5) VARCHAR2(5) NOT NULL Subcategory

    Prompt Table: %EDITTABLE2

    34 RES_USER1 Character(10) VARCHAR2(10) NOT NULL Transaction User 1
    35 RES_USER2 Character(10) VARCHAR2(10) NOT NULL Transaction User 2
    36 RES_USER3 Character(10) VARCHAR2(10) NOT NULL Transaction User 3
    37 RES_USER4 Character(10) VARCHAR2(10) NOT NULL Transaction User 4
    38 RES_USER5 Character(10) VARCHAR2(10) NOT NULL Transaction User 5
    39 TRANS_DT Date(10) DATE Transaction Date

    Default Value: %date

    40 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple

    Default Value: %date

    41 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

    Prompt Table: OPRID_VW

    42 DTTM_STAMP 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.
    43 FOREIGN_CURRENCY Character(3) VARCHAR2(3) NOT NULL Foreign Currency Code

    Default Value: OPR_DEF_TBL_PC.CURRENCY_CD

    Prompt Table: FRGN_CURR_VW

    44 RT_TYPE Character(5) VARCHAR2(5) NOT NULL Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.

    Default Value: OPR_DEF_TBL_PC.RT_TYPE

    Prompt Table: RT_TYPE_TBL

    45 FOREIGN_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Specifies the monetary amount of a debit or credit (accounting entry line) in the entry currency of the item. The sum of FOREIGN_AMOUNT values on AR lines should equal the ENTRY_AMT on the pending item.
    46 RATE_MULT Signed Number(17,8) DECIMAL(15,8) NOT NULL Rate Multiplier
    47 RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL Rate Divisor
    48 CUR_EFFDT Date(10) DATE Specifies the effective date associated with the currency used as the base currency for the Business Unit on the Journal Entry Header.
    49 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
    50 PC_DISTRIB_STATUS Character(1) VARCHAR2(1) NOT NULL PC Distribution Status
    B=Budget Check
    D=Distributed
    G=Generated
    H=Hold
    I=Ignore
    M=Modified
    N=Not Distributed
    S=Staged

    Default Value: N

    51 GL_DISTRIB_STATUS Character(1) VARCHAR2(1) NOT NULL Distribution Status
    C=Available to Contracts
    D=Distributed
    G=Generated
    H=Hold
    I=Ignored
    J=Creating Journals
    M=Modified
    N=None
    P=To be processed
    X=Waiting for Reversal

    Default Value: I

    52 PROJ_TRANS_TYPE Character(3) VARCHAR2(3) NOT NULL Project Transaction Type

    Prompt Table: PROJ_TRANS_TYPE

    53 PROJ_TRANS_CODE Character(5) VARCHAR2(5) NOT NULL Project Transaction Code

    Prompt Table: PROJ_TRANS_CODE

    54 RESOURCE_STATUS Character(1) VARCHAR2(1) NOT NULL Transaction Status
    A=Resource Approved
    U=Unapproved Resource

    Default Value: A

    55 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    56 SYSTEM_SOURCE Character(3) VARCHAR2(3) NOT NULL Identifies the application or source system that generated a journal entry. Release 8.80 - 11/14/2002 - RVlasic - Removed GDM (JrnlGen - Deduction Management) from Translate Values. SUJ---Included a label as Product. Release 8.9 - 05/11/2005 - RVlasic - Added PRV (Variance Pricing) and PKK (KK Budget Journal) and deleted GLK for Project Costing per Brian Cohen.
    57 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

    58 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PROJ_TEAM_VW

    59 TIME_RPTG_CD Character(5) VARCHAR2(5) NOT NULL Time Reporting Code
    60 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code
    61 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

    Default Value: PC_INT_TMPL.BUSINESS_UNIT_HR

    62 BUSINESS_UNIT_AP Character(5) VARCHAR2(5) NOT NULL AP Business Unit

    Default Value: PC_INT_TMPL.BUSINESS_UNIT_AP

    Prompt Table: SP_BU_AP_NONVW

    63 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

    Prompt Table: PROJ_VENDOR_VW

    64 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID

    Prompt Table: PC_AP_VCHR_VW

    65 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit

    Default Value: PC_INT_TMPL.BUSINESS_UNIT_PO

    Prompt Table: SP_BU_PM_NONVW

    66 REQ_ID Character(10) VARCHAR2(10) NOT NULL Requisition ID
    67 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order

    Prompt Table: PC_PO_HDR_VW

    68 AM_DISTRIB_STATUS Character(1) VARCHAR2(1) NOT NULL AM Distribution Status
    D=Distributed
    I=Ignore
    M=Modified
    N=Not Distributed
    P=Pending
    V=Reversed
    69 BUSINESS_UNIT_AM Character(5) VARCHAR2(5) NOT NULL AM Business Unit

    Default Value: PC_INT_TMPL.BUSINESS_UNIT_AM

    Prompt Table: SP_BU_AM_NONVW

    70 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification

    Prompt Table: PROJ_ASSET_VW

    71 PROFILE_ID Character(10) VARCHAR2(10) NOT NULL Asset Profile ID

    Prompt Table: PROFILE_PCAM_VW

    72 COST_TYPE Character(1) VARCHAR2(1) NOT NULL Cost Type
    73 BOOK Character(10) VARCHAR2(10) NOT NULL Asset Book Name
    74 INCENTIVE_ID Character(10) VARCHAR2(10) NOT NULL Investment Incentive ID

    Prompt Table: PC_PROJ_GNT_VW

    75 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract
    76 BUSINESS_UNIT_BI Character(5) VARCHAR2(5) NOT NULL Billing Business Unit

    Default Value: PC_INT_TMPL.BUSINESS_UNIT_BI

    Prompt Table: SP_BU_BI_NONVW

    77 BILLING_DATE Date(10) DATE Billing Date
    78 INVOICE Character(22) VARCHAR2(22) NOT NULL Invoice
    79 REV_DISTRIB_STATUS Character(1) VARCHAR2(1) NOT NULL Revenue Distribution Status
    C=Created
    D=Distributed
    G=Generated
    I=Ignore
    N=Not Distributed
    80 BUSINESS_UNIT_AR Character(5) VARCHAR2(5) NOT NULL AR Business Unit

    Default Value: PC_INT_TMPL.BUSINESS_UNIT_AR

    Prompt Table: SP_BUARED_NONVW

    81 CUST_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.

    Prompt Table: PROJ_CUST_VW

    82 ITEM Character(30) VARCHAR2(30) NOT NULL Uniquely identifies an invoice credit memo or debit memo. The item ID is also called the invoice number.

    Prompt Table: ITEM_OPEN_PC_VW

    83 BUSINESS_UNIT_IN Character(5) VARCHAR2(5) NOT NULL Inventory Unit

    Default Value: PC_INT_TMPL.BUSINESS_UNIT_IN

    Prompt Table: SP_BUIN_NONVW

    84 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

    Prompt Table: PROJ_ITEM_VW

    85 BUSINESS_UNIT_OM Character(5) VARCHAR2(5) NOT NULL Order Management Business Unit

    Default Value: PC_INT_TMPL.BUSINESS_UNIT_OM

    Prompt Table: SP_BUPCOM_NONVW

    86 ORDER_NO Character(10) VARCHAR2(10) NOT NULL Identifies a customer order number that appears as a reference on a receivables pending item. Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop
    87 RESOURCE_QUANTITY Signed Number(16,2) DECIMAL(14,2) NOT NULL Quantity
    88 RESOURCE_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Transaction Amount
    89 BUDGET_HDR_STATUS Character(1) VARCHAR2(1) NOT NULL Budget Checking Header Status
    E=Error in Budget Check
    I=Document In Processing
    N=Not Budget Checked
    P=Provisionally Valid
    V=Valid
    90 BUDGET_DT Date(10) DATE Budget Date
    91 LEDGER Character(10) VARCHAR2(10) NOT NULL Ledger
    92 BUSINESS_UNIT_BD Character(5) VARCHAR2(5) NOT NULL Budgeting Business Unit

    Prompt Table: SP_BU_BD_NONVW