ALTACCT_EFFVW

#	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	ALTACCT	Character(10)	VARCHAR2(10) NOT NULL	Alternate Account Prompt Table: ALTACCT_TBL
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	DESCR254	Character(254)	VARCHAR2(254) NOT NULL	Description of length 254
8	SYSTEM_MAINT_ACCT	Character(1)	VARCHAR2(1) NOT NULL	System Maintained Account Y/N Table Edit Default Value: N
9	PAYROLL_ACCOUNT	Character(1)	VARCHAR2(1) NOT NULL	Budget Override Account Y/N Table Edit Default Value: N
10	ACCOUNTING_OWNER	Character(30)	VARCHAR2(30) NOT NULL	Accounting Owner
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. Prompt Table: ACCT_TYPE_TBL
12	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
13	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
14	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.
15	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
16	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
17	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
18	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 Y/N Table Edit Default Value: Y
19	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. Y/N Table Edit Default Value: N
20	BAL_SHEET_IND	Character(2)	VARCHAR2(2) NOT NULL	Balance Sheet Indicator BS=Balance Sheet OB=Off Balance Sheet
21	BOOK_CODE	Character(4)	VARCHAR2(4) NOT NULL	Book Code Prompt Table: BOOK_CODE_TBL
22	SYNCID	Number(10,0)	DECIMAL(10) NOT NULL	The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
23	SYNCDTTM	DateTime(26)	TIMESTAMP	Synchronization Last Update Date Time Default Value: %datetime