SETIDDefault Value: OPR_DEF_TBL_FS.SETID
Prompt Table: SETID_TBL
ACCOUNTEFFDTDefault Value: %date
A=Active
I=Inactive
Default Value: A
Prompt Table: ACCT_TYPE_TBL
GLACCT_OPN_VW(SQL View) |
Index Back |
|---|---|
Open Item Accounts |
| select setid, account, effdt, eff_status, open_item_descr, descr, descrshort, account_type from PS_GL_ACCOUNT_TBL where open_item = 'Y' |
| # | 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: SETID_TBL |
| 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 | 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. |
| 6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 7 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
| 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 |