BU_LED_GRP_TBL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	LEDGER_GROUP	Character(10)	VARCHAR2(10) NOT NULL	Ledger Group Prompt Table: SP_LGNOKK_NONVW
3	LEDGER	Character(10)	VARCHAR2(10) NOT NULL	Ledger Prompt Table: SP_LEDG_S_NONVW
4	LEDGER_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Ledger Type D=Detail Ledger K=Commitment Control Ledger S=Summary Ledger Default Value: D
5	BALANCED_LEDGER	Character(1)	VARCHAR2(1) NOT NULL	Balanced Ledger Y/N Table Edit Default Value: Y
6	JRNL_BALANCE_OPTN	Character(1)	VARCHAR2(1) NOT NULL	Journal Balance Option D=Default to Higher Level Value R=Recycle S=Suspend Default Value: D
7	JRNL_EDIT_ERR_OPTN	Character(1)	VARCHAR2(1) NOT NULL	Journal Edit Errors Option D=Default to Higher Level Value R=Recycle S=Suspend Default Value: D
8	JRNL_AMT_ERR_OPTN	Character(1)	VARCHAR2(1) NOT NULL	A Journal Edit option to decide if accept, error or suspense a journal line when foreign amount and monetary amount are different sign (i.e. one positive and the other negative). A=Accept D=Default to Higher Level Value R=Recycle S=Suspend Default Value: D
9	JRNL_DT_ERR_OPTN	Character(1)	VARCHAR2(1) NOT NULL	Journal Date < Open From Date C=Change to Open From Date D=Default to Higher Level Value R=Recycle Default Value: D
10	JRNL_DT_ERR_OPTN2	Character(1)	VARCHAR2(1) NOT NULL	Journal Date > Open To Date C=Change To Open To Date D=Default to Higher Level Value R=Recycle Default Value: D
11	CONTROL_TOTAL_OPTN	Character(1)	VARCHAR2(1) NOT NULL	Control Total Option D=Default to Higher Level Value N=N/A R=Recycle Default Value: D
12	CALENDAR_ID	Character(2)	VARCHAR2(2) NOT NULL	Calendar ID Prompt Table: %EDITTABLE
13	UPD_OPENPER	Character(1)	VARCHAR2(1) NOT NULL	Update Open Periods options - By Ledger Group or By Ledger Code C=By Ledger Code G=By Ledger Group Default Value: G
14	ASSOCIATED_LED_GRP	Character(10)	VARCHAR2(10) NOT NULL	Associated Actual Ledger Group
15	DTTM_STAMP_SEC	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
16	UPDATE_TIMING	Character(1)	VARCHAR2(1) NOT NULL	Summary Ledger Update Timing B=Batch Process (After Posting) N=Never Posted (Virtual Ledger) R=Realtime (When Post Detail) Default Value: B
17	ROUND_ADJ_OPTN	Character(1)	VARCHAR2(1) NOT NULL	Rounding Adjustment Option A=Add Adjusting Journal Line D=Default to Higher Level Value L=Adjust Last Journal Line S=Skip Rounding Adjustment Default Value: L
18	ADB_REPORTING	Character(1)	VARCHAR2(1) NOT NULL	Report Average Balances Y/N Table Edit Default Value: N
19	ADB_STATUTORY_RPT	Character(1)	VARCHAR2(1) NOT NULL	Maintain Balances by Date Code Y/N Table Edit Default Value: N
20	ADB_FILTER_ACCNTS	Character(1)	VARCHAR2(1) NOT NULL	ADB Filter indicator Y/N Table Edit Default Value: N
21	CALENDAR_ID_ADB	Character(2)	VARCHAR2(2) NOT NULL	ADB Calendar Prompt Table: CAL_DAILY_VW
22	CURRENCY_BAL_OPTN	Character(1)	VARCHAR2(1) NOT NULL	Currency Balancing Option A=Balance by All Currencies B=Balance by Base Currency Only D=Default to Higher Level Value Default Value: D
23	EXCHANGE_RATE_OPTN	Character(1)	VARCHAR2(1) NOT NULL	Translate Ledger Exchange Rate D=Default to Higher Level Value N=Retain Exchange Rate Y=Inherit from Primary Ledger Default Value: D
24	BASE_CUR_ADJ_OPTN	Character(1)	VARCHAR2(1) NOT NULL	Base Currency Adjust Option D=Default to Higher Level Value N=Disallow Base Curr Adjustments Y=Allow Base Curr Adjustments Default Value: D
25	JRNL_FOREIGN_OPTN	Character(1)	VARCHAR2(1) NOT NULL	Foreign Currencies per Journal D=Default to Higher Level Value M=Multiple Foreign Currencies N=No Foreign Currencies O=Only One Foreign Currency Default Value: D
26	ALLOW_LEDG_LOAD_SW	Character(1)	VARCHAR2(1) NOT NULL	Yes/No indicator - Allow Ledger Load Updates Y/N Table Edit Default Value: N
27	ALLOW_WF_UPDATE	Character(1)	VARCHAR2(1) NOT NULL	Direct Budgets Ledger Updates Y/N Table Edit Default Value: N
28	BASE_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	"Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. " Default Value: BUS_UNIT_TBL_GL.BASE_CURRENCY
29	DEFAULT_LEDGER_GRP	Character(1)	VARCHAR2(1) NOT NULL	Jrnl Generator Dflt Ledger Grp Y/N Table Edit Default Value: N
30	SEPARATE_DRCR	Character(1)	VARCHAR2(1) NOT NULL	Enable Separate Debit/Credit Y/N Table Edit Default Value: N
31	SEPARATE_DRCR_AMT	Character(1)	VARCHAR2(1) NOT NULL	Separate DR/CR Amount Fields Y/N Table Edit Default Value: N
32	ALTACCT_OPTN	Character(1)	VARCHAR2(1) NOT NULL	Enable Alternate Account Y/N Table Edit Default Value: N
33	ACCT_ALT_SUSPENSE	Character(10)	VARCHAR2(10) NOT NULL	Acct->Alt Suspense Prompt Table: ALT_MON_VW Set Control Field: BUSINESS_UNIT
34	ALT_ACCT_SUSPENSE	Character(10)	VARCHAR2(10) NOT NULL	Alt->Acct Suspense Prompt Table: GL_ACCT_MON_VW Set Control Field: BUSINESS_UNIT
35	UPDATE_CLOSING_SW	Character(1)	VARCHAR2(1) NOT NULL	Yes/No Indicator Y/N Table Edit Default Value: N
36	JRNL_APPRVL_OPTN	Character(1)	VARCHAR2(1) NOT NULL	Journal Approval Option D=Default to Higher Level P=Pre-Approved S=Require Approval Default Value: D
37	JRNL_APP_UP_OPTN	Character(1)	VARCHAR2(1) NOT NULL	Journal Unpost Approval Option Y/N Table Edit Default Value: N
38	BD_JRNL_APPR_OPTN	Character(1)	VARCHAR2(1) NOT NULL	Budget Journal Approval Optn D=Default to Higher Level P=Pre-Approved S=Require Approval Default Value: D
39	BUSPROCNAME	Character(30)	VARCHAR2(30) NOT NULL	Business Process Name (see PSBUSPROCDEFN). Prompt Table: BUSPROCNAME_VW
40	APPR_RULE_SET	Character(30)	VARCHAR2(30) NOT NULL	Approval Rule Set Prompt Table: APPR_RULE_BP_VW
41	BUSPROCNAME_BD	Character(30)	VARCHAR2(30) NOT NULL	Business Process Name - Budget Prompt Table: BUSPROC_BD_VW
42	APPR_RULE_SET_BD	Character(30)	VARCHAR2(30) NOT NULL	Approval Rule Set - Budgets Prompt Table: APPR_RULE_BD_VW
43	DOC_TYPE	Character(8)	VARCHAR2(8) NOT NULL	Specifies the business purpose of a financial transaction in countries that require all financial transactions to be tracked as "documents". A Document Type is associated with one and only one Journal Code. Prompt Table: DOC_TYPE_TBL
44	DOC_TYPE_UNPOST	Character(8)	VARCHAR2(8) NOT NULL	Document Type for Unposted Journals Prompt Table: DOC_TYPE_TBL
45	COMMITMENT_CNTL	Character(1)	VARCHAR2(1) NOT NULL	Enable Commitment Control Y/N Table Edit Default Value: N
46	KK_REVERSAL_OPTN	Character(1)	VARCHAR2(1) NOT NULL	Referenced Reversal Option A=Amount Q=Quantity Default Value: A
47	KK_ERR_OPTN	Character(1)	VARCHAR2(1) NOT NULL	Stop Budget Check at 1st Error Y/N Table Edit Default Value: Y
48	KK_INCLUDE_PRE_ENC	Character(1)	VARCHAR2(1) NOT NULL	Indicator - Include Pre-Encumbrance in RSA 1=Include 2=Exclude 3=Default Default Value: 3
49	KK_ALLOW_INC_SA	Character(1)	VARCHAR2(1) NOT NULL	Yes/No Indicator - Allow Increase Spending Authority Y/N Table Edit Default Value: N
50	POSITION_ACCOUNT	Character(8)	VARCHAR2(8) NOT NULL	Position Accounting Prompt Table: GL_POS_ACT_DEF
51	NO_POST_FUTURE_DT	Character(1)	VARCHAR2(1) NOT NULL	Yes/No Indicator Y/N Table Edit Default Value: N
52	POST_REVERSAL_SW	Character(1)	VARCHAR2(1) NOT NULL	Indicator - Automatic Post Reversals Y/N Table Edit Default Value: N
53	POST_SUMLED_SW	Character(1)	VARCHAR2(1) NOT NULL	Yes/No Indicator Y/N Table Edit Default Value: N
54	UNPOST_DOCTYPE_OPT	Character(1)	VARCHAR2(1) NOT NULL	Indicator - Option for unposting journal's document type N=Specify a New Document Type S=Same as the Original Journal Default Value: S
55	UNPOST_INTERUNIT	Character(1)	VARCHAR2(1) NOT NULL	Yes/No Indicator Y/N Table Edit Default Value: Y
56	UNPOST_REVERSALS	Character(1)	VARCHAR2(1) NOT NULL	Yes/No Indicator Y/N Table Edit Default Value: Y
57	ENABLE_DATE_CODE	Character(1)	VARCHAR2(1) NOT NULL	Yes/No Indicator - Enable Incremental Summary Ledger update Y/N Table Edit Default Value: N
58	ENABLE_INC_SLED	Character(1)	VARCHAR2(1) NOT NULL	Yes/No Indicator - Enable Incremental Summary Ledger update Y/N Table Edit Default Value: N
59	ENABLE_INC_LLOAD	Character(1)	VARCHAR2(1) NOT NULL	Enable Incremental Ledger Load Y/N Table Edit Default Value: N
60	DETAIL_LEDGER	Character(10)	VARCHAR2(10) NOT NULL	Detail Ledger ID
61	ADB_POSTADJ_OPTN	Character(1)	VARCHAR2(1) NOT NULL	ADB Post Adjustment Period Option: this option determines whether to post the adjustment accouting period or the regular ADB accouting period to the ADB Ledger. Y/N Table Edit Default Value: Y
62	KK_AF_APPR_OPTION	Character(1)	VARCHAR2(1) NOT NULL	Budget Journal Approval Optn 0=Not Required 1=Required 2=Default to Higher Level Default Value: 0
63	AMR_CAL_ID_QT	Character(2)	VARCHAR2(2) NOT NULL	Amortization qaurterly summary calendar Prompt Table: CAL_SUMM_DVW Set Control Field: BUSINESS_UNIT
64	AMR_CAL_ID_YR	Character(2)	VARCHAR2(2) NOT NULL	Amortization annual summary calendar Prompt Table: CAL_SUMY_DVW Set Control Field: BUSINESS_UNIT
65	DST_CNTRL_ID	Character(10)	VARCHAR2(10) NOT NULL	Accounting Template Prompt Table: AMR_CNTRL_TBL
66	SOURCE	Character(3)	VARCHAR2(3) NOT NULL	Identifies the origin of a journal entry and defines journal entry error handling options. The journal source provides a means of selectively tracking, reporting, and inquiring on journal entries. It can be almost anything within the enterprise - a subsystem that generates transactions, a department, or even an individual. Prompt Table: SOURCE_TBL
67	DOC_TYPE_GL	Character(8)	VARCHAR2(8) NOT NULL	GL Document Type Prompt Table: DOC_TYPE_A_VW