OPRIDPrompt Table: OPERATOR_VW
RUN_CNTL_IDPNLGRPNAMEACCOUNT_TYPEPrompt Table:
ACCT_TYPE_TBL
Set Control Field: BUSINESS_UNIT
GL_SQR_ACCTYPE(SQL Table) |
Index Back |
|---|---|
Account types for GL SQRHolding account types for GL SQR report requests. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Prompt Table: OPERATOR_VW |
| 2 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | PNLGRPNAME |
Character(18) | VARCHAR2(18) NOT NULL | Component Name |
| 4 | 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
|