SEC_ACCT_BU_RVW

(SQL View)
 Index Back

CFS: Accounts Bu GL View

ChartField Security: Accounts Bu GL View

SELECT DISTINCT C.ROLEUSER , B.PRODSRCID , A.SETID , A.ACCOUNT , A.EFFDT , A.EFF_STATUS , A.DESCR , A.DESCRSHORT , A.BUDGETARY_ONLY , A.BUDG_OVERRIDE_ACCT , A.ACCOUNTING_OWNER , A.ACCOUNT_TYPE , A.UNIT_OF_MEASURE , A.OPEN_ITEM , A.OPEN_ITEM_DESCR , A.OPEN_ITEM_EDIT_REC , A.OPEN_ITEM_EDIT_FLD , A.STATISTICS_ACCOUNT FROM PS_GL_ACCOUNT_TBL A , PS_SEC_ACCT_ROLE B , PSROLEUSER C WHERE %Join(COMMON_KEYS,GL_ACCOUNT_TBL A, GL_ACCOUNT_TBL B, EFFDT) AND C.ROLENAME = B.ROLENAME AND A.CONTROL_FLAG = 'N' AND A.BUDGETARY_ONLY = 'N'

  • Related Language Record: SEC_ACCT_RLANG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    2 PRODSRCID Character(4) VARCHAR2(4) NOT NULL Chartfield Security: Source Product
    DBI=Billing
    DCM=Cost Management
    DIN=Inventory
    DMI=Mobile Inventory
    DOM=Order Management
    DPO=Purchasing
    DPV=eProcurement
    DSP=Service Procurement
    FAM=Asset Management
    FAP=Payables
    FAR=Receivables
    FCA=Contracts
    FEX=Expenses
    FGL=General Ledger
    FGM=Grants Management
    FPC=Project Costing
    FTR=Treasury
    KK=Commitment Control
    3 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPR_DEF_TBL_FS.SETID

    Prompt Table: SP_SETID_NONVW

    4 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account

    Prompt Table: GL_ACCOUNT_TBL

    5 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    6 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    7 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    8 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    9 BUDGETARY_ONLY Character(1) VARCHAR2(1) NOT NULL Budgetary Only
    10 BUDG_OVERRIDE_ACCT Character(1) VARCHAR2(1) NOT NULL Budget Override Account

    Y/N Table Edit

    Default Value: N

    11 ACCOUNTING_OWNER Character(30) VARCHAR2(30) NOT NULL Accounting Owner
    12 ACCOUNT_TYPE Character(1) VARCHAR2(1) NOT NULL Identifies a category of accounts that appears on the balance sheet or income statement of the enterprise. Each general ledger account (ACCOUNT) is associated with an account type (also called a ""monetary account type""). PeopleSoft delivers standard account types such as asset, liability, expense, and revenue.

    Prompt Table: ACCT_TYPE_TBL

    13 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

    14 OPEN_ITEM Character(1) VARCHAR2(1) NOT NULL A flag that indicates whether or not (Y or N) to activate processing for tracking debits and credits that post to a general ledger account. Accounts that are not OpenItem track only net posted amounts.

    Y/N Table Edit

    Default Value: N

    15 OPEN_ITEM_DESCR Character(10) VARCHAR2(10) NOT NULL Describes the OpenItem key that must be specified in the reference field on journal entry panels when an open item account number is used. It appears on prompt lists, reports, and online inquiries related to an open item account in the general ledger.
    16 OPEN_ITEM_EDIT_REC Character(15) VARCHAR2(15) NOT NULL Specifies the name of the prompt table you want to use to validate the OpenItem search key, and applies only to OpenItem accounts in the general ledger.

    Prompt Table: RECDEFN_VW

    17 OPEN_ITEM_EDIT_FLD Character(18) VARCHAR2(18) NOT NULL Specifies the name of the field in the OpenItem Edit Record (OPEN_ITEM_EDIT_REC) to use for validating the OpenItem search key, and applies only to OpenItem accounts in the general ledger.

    Prompt Table: RECFLD_ACCT_VW

    18 STATISTICS_ACCOUNT Character(1) VARCHAR2(1) NOT NULL A flag that indicates whether or not (Y or N) a general ledger account is used to track statistical amounts rather than monetary amounts. Statistical amounts represent information such as square footage, head count, or number of units. A unit of measure (UNIT_OF_MEASURE) must be specified with a statistical account.

    Y/N Table Edit

    Default Value: N