IU_ACCT_CUR_VW(SQL View) |
Index Back |
|---|---|
Current Accounts For IU |
| SELECT A.SETID , A.ACCOUNT , A.EFFDT , A.EFF_STATUS , A.DESCR , A.DESCRSHORT , 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 , A.BAL_SHEET_IND , A.BOOK_CODE FROM PS_GL_ACCOUNT_TBL A WHERE A.BUDGETARY_ONLY = 'N' AND A.EFF_STATUS = 'A' AND A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_GL_ACCOUNT_TBL B WHERE A.SETID = B.SETID AND A.ACCOUNT = B.ACCOUNT AND B.EFFDT <= %CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW |
| 2 | ACCOUNT |
Character(10) | VARCHAR2(10) NOT NULL | Account |
| 3 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 4 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 6 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
| 7 | ACCOUNTING_OWNER | Character(30) | VARCHAR2(30) NOT NULL | Accounting Owner |
| 8 | 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 |
| 9 | 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 |
| 10 | 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 |
| 11 | 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. |
| 12 | 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 |
| 13 | 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 |
| 14 | 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 |
| 15 | BAL_SHEET_IND | Character(2) | VARCHAR2(2) NOT NULL |
Balance Sheet Indicator
BS=Balance Sheet OB=Off Balance Sheet |
| 16 | BOOK_CODE | Character(4) | VARCHAR2(4) NOT NULL | Book Code |