|
SELECT DISTINCT C.ROLEUSER , B.PRODSRCID , A.SETID , A.ALTACCT , 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 FROM PS_ALTACCT_TBL A , PS_SEC_ALTACT_ROLE B , PSROLEUSER C WHERE %Join(COMMON_KEYS, ALTACCT_TBL A, ALTACCT_TBL B, EFFDT) AND C.ROLENAME = B.ROLENAME AND A.EFF_STATUS = 'A' AND A.EFFDT = ( SELECT MAX(X.EFFDT) FROM PS_ALTACCT_TBL X WHERE A.SETID = X.SETID AND A.ALTACCT = X.ALTACCT)
|
| # |
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 |
ALTACCT |
Character(10) |
VARCHAR2(10) NOT NULL |
Alternate Account
|
| 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 |
ACCOUNTING_OWNER |
Character(30) |
VARCHAR2(30) NOT NULL |
Accounting Owner
|
| 10 |
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
|
| 11 |
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
|
| 12 |
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
|
| 13 |
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.
|
| 14 |
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
|
| 15 |
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
|
| 16 |
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
|