GL_ACCOUNT_TBL

#	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	ACCOUNT	Character(10)	VARCHAR2(10) NOT NULL	Account Prompt Table: GL_ACCOUNT_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	DESCRLONG	Long Character	CLOB	Long Description
8	BUDG_OVERRIDE_ACCT	Character(1)	VARCHAR2(1) NOT NULL	Budget Override Account Y/N Table Edit Default Value: N
9	ACCOUNTING_OWNER	Character(30)	VARCHAR2(30) NOT NULL	Accounting Owner
10	AB_ACCOUNT_SW	Character(1)	VARCHAR2(1) NOT NULL	ABM Account Y/N Table Edit Default Value: N
11	GL_ACCOUNT_SW	Character(1)	VARCHAR2(1) NOT NULL	General Ledger Account Y/N Table Edit Default Value: Y
12	PF_ACCOUNT_SW	Character(1)	VARCHAR2(1) NOT NULL	Performance Measurement Y/N Table Edit Default Value: N
13	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
14	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
15	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
16	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.
17	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
18	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
19	OPEN_ITEM_PROMPT	Character(15)	VARCHAR2(15) NOT NULL	Open Item Prompt Table Prompt Table: RECDEFN_OI_VW
20	OPEN_ITEM_TOL_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Specifies the limit amount that determines when OpenItem entries can be closed. You can manually close (delete) OpenItem rows if the balance of the OpenItem account is less than or equal to the specified tolerance.
21	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Reconcile Currency Prompt Table: CURRENCY_CD_TBL
22	OI_RECON_BASE	Character(1)	VARCHAR2(1) NOT NULL	Specifies that open items should get closed only when the sum total for base amount is zero. Y/N Table Edit Default Value: N
23	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
24	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
25	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
26	BOOK_CODE	Character(4)	VARCHAR2(4) NOT NULL	Book Code Prompt Table: BOOK_CODE_TBL
27	BOOK_CODE_OVERRIDE	Character(1)	VARCHAR2(1) NOT NULL	Allow specifying of the Book Code value that is different from the default value as defined in the GL Account table. Y/N Table Edit Default Value: Y
28	BAL_SHEET_IND	Character(2)	VARCHAR2(2) NOT NULL	Balance Sheet Indicator BS=Balance Sheet OB=Off Balance Sheet
29	VAT_ACCOUNT_FLG	Character(1)	VARCHAR2(1) NOT NULL	A flag that indicates the relationship of a general ledger account to VAT processing. An account can be non-VAT, VAT or VAT Applicable. A=VAT Applicable Account N=Non-VAT Related V=VAT Account Default Value: N
30	PHYSICAL_NATURE	Character(1)	VARCHAR2(1) NOT NULL	Physical Nature G=Goods S=Services
31	BUDGETARY_ONLY	Character(1)	VARCHAR2(1) NOT NULL	Budgetary Only Y/N Table Edit Default Value: N
32	KK_OVERRIDE_ACCT	Character(1)	VARCHAR2(1) NOT NULL	Override Commitment Control Budget Editting. Y/N Table Edit Default Value: N
33	RTBL_DATA	Character(1)	VARCHAR2(1) NOT NULL	RTBL Data
34	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.
35	SYNCDTTM	DateTime(26)	TIMESTAMP	Synchronization Last Update Date Time Default Value: %datetime