OI_ALTACCT_VW

(SQL View)
 Index Back

Alternate Account

Primary record for Alternate Account ChartField

SELECT AA.SETID , AA.ALTACCT , AA.EFFDT , ALE.INEFFDT , AA.EFF_STATUS , AA.DESCR , AA.DESCRSHORT , AA.DESCR254 , AA.SYSTEM_MAINT_ACCT , AA.PAYROLL_ACCOUNT , AA.ACCOUNT_TYPE , AA.UNIT_OF_MEASURE , UOM.DESCR UOM_DESCR , UOM.DESCRSHORT UOM_DESCRSHORT , AA.STATISTICS_ACCOUNT , AA.BALANCE_FWD_SW , AA.CONTROL_FLAG , AA.BAL_SHEET_IND , AA.OPEN_ITEM , AA.OPEN_ITEM_DESCR , AA.OPEN_ITEM_EDIT_FLD , AA.OPEN_ITEM_EDIT_REC , AA.BOOK_CODE , BC.DESCR BOOK_DESCR , BC.DESCRSHORT BOOK_DESCRSHORT , AA.ACCOUNTING_OWNER FROM PS_ALTACCT_TBL AA INNER JOIN PS_ALTACCT_EDR ALE ON AA.SETID = ALE.SETID AND AA.ALTACCT=ALE.ALTACCT AND AA.EFFDT =ALE.EFFDT LEFT OUTER JOIN PS_UNITS_TBL UOM ON AA.UNIT_OF_MEASURE=UOM.UNIT_OF_MEASURE LEFT OUTER JOIN PS_BOOK_CODE_TBL BC ON AA.BOOK_CODE= BC.BOOK_CODE AND AA.SETID = BC.SETID WHERE (BC.EFFDT = ( SELECT MAX(BC1.EFFDT) FROM PS_BOOK_CODE_TBL BC1 WHERE BC1.SETID =AA.SETID AND BC1.BOOK_CODE=BC.BOOK_CODE AND BC1.EFFDT <= AA.EFFDT ) OR BC.BOOK_CODE IS NULL) UNION SELECT DISTINCT SETID , ' ' , %DateIn('1900-01-01') , %DateIn('9999-12-31') , 'A' , 'Not Available' , 'NA' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' FROM PS_SETID_TBL UNION SELECT ' ' , ' ' , %DateIn('1900-01-01') , %DateIn('9999-12-31') , 'A' , 'Not Available' , 'NA' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' FROM PS_INSTALLATION

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 ALTACCT Character(10) VARCHAR2(10) NOT NULL Alternate Account
3 EFF_ST_DT Date(10) DATE Effective Start Date
4 EFF_END_DT Date(10) DATE Effective End Date
5 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
6 DESCR Character(30) VARCHAR2(30) NOT NULL Description
7 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
8 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
9 SYSTEM_MAINT_ACCT Character(1) VARCHAR2(1) NOT NULL System Maintained Account
10 PAYROLL_ACCOUNT Character(1) VARCHAR2(1) NOT NULL Budget Override Account
11 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.
12 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
13 UOM_DESCR Character(30) VARCHAR2(30) NOT NULL Unit of measure description
14 UOM_DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Unit of measure description
15 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.
16 BALANCE_FWD_SW Character(1) VARCHAR2(1) NOT NULL A flag that indicates (Y or N) whether or not the YTD balance for an account type or for a statistical account will be rolled forward to Period 0 of the next year.
N=Not Carry Forward
O=Other
Y=Carry Forward
17 CONTROL_FLAG Character(1) VARCHAR2(1) NOT NULL This flag in used to desginate an Account or Alternate Account as Control Accounts and Control Alternate Accounts, respectively.
18 BAL_SHEET_IND Character(2) VARCHAR2(2) NOT NULL Balance Sheet Indicator
BS=Balance Sheet
OB=Off Balance Sheet
19 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.
20 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.
21 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.
22 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.
23 BOOK_CODE Character(4) VARCHAR2(4) NOT NULL Book Code
24 BOOK_DESCR Character(30) VARCHAR2(30) NOT NULL Book Description
25 BOOK_DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Book Description
26 ACCOUNTING_OWNER Character(30) VARCHAR2(30) NOT NULL Accounting Owner