BU_LED_GRP_TEO3(SQL Table) |
Index Back |
|---|---|
CCU TEO temp tableCCU temporary table for BU_LED_GRP_TBL |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EO_PROCESS_INST | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 3 | LEDGER_GROUP | Character(10) | VARCHAR2(10) NOT NULL | Ledger Group |
| 4 | LEDGER | Character(10) | VARCHAR2(10) NOT NULL | Ledger |
| 5 | LEDGER_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Ledger Type
D=Detail Ledger K=Commitment Control Ledger S=Summary Ledger |
| 6 | BALANCED_LEDGER | Character(1) | VARCHAR2(1) NOT NULL | Balanced Ledger |
| 7 | JRNL_BALANCE_OPTN | Character(1) | VARCHAR2(1) NOT NULL |
Journal Balance Option
D=Default to Higher Level Value R=Recycle S=Suspend |
| 8 | JRNL_EDIT_ERR_OPTN | Character(1) | VARCHAR2(1) NOT NULL |
Journal Edit Errors Option
D=Default to Higher Level Value R=Recycle S=Suspend |
| 9 | 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 |
| 10 | 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 |
| 11 | 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 |
| 12 | CONTROL_TOTAL_OPTN | Character(1) | VARCHAR2(1) NOT NULL |
Control Total Option
D=Default to Higher Level Value N=N/A R=Recycle |
| 13 | CALENDAR_ID | Character(2) | VARCHAR2(2) NOT NULL | Calendar ID |
| 14 | 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 |
| 15 | ASSOCIATED_LED_GRP | Character(10) | VARCHAR2(10) NOT NULL | Associated Actual Ledger Group |
| 16 | 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. |
| 17 | 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) |
| 18 | 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 |
| 19 | ADB_REPORTING | Character(1) | VARCHAR2(1) NOT NULL | Report Average Balances |
| 20 | ADB_STATUTORY_RPT | Character(1) | VARCHAR2(1) NOT NULL | Maintain Balances by Date Code |
| 21 | ADB_FILTER_ACCNTS | Character(1) | VARCHAR2(1) NOT NULL | ADB Filter indicator |
| 22 | CALENDAR_ID_ADB | Character(2) | VARCHAR2(2) NOT NULL | ADB Calendar |
| 23 | 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 |
| 24 | 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 |
| 25 | 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 |
| 26 | 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 |
| 27 | ALLOW_LEDG_LOAD_SW | Character(1) | VARCHAR2(1) NOT NULL | Yes/No indicator - Allow Ledger Load Updates |
| 28 | ALLOW_WF_UPDATE | Character(1) | VARCHAR2(1) NOT NULL | Direct Budgets Ledger Updates |
| 29 | 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. " |
| 30 | DEFAULT_LEDGER_GRP | Character(1) | VARCHAR2(1) NOT NULL | Jrnl Generator Dflt Ledger Grp |
| 31 | SEPARATE_DRCR | Character(1) | VARCHAR2(1) NOT NULL | Enable Separate Debit/Credit |
| 32 | SEPARATE_DRCR_AMT | Character(1) | VARCHAR2(1) NOT NULL | Separate DR/CR Amount Fields |
| 33 | ALTACCT_OPTN | Character(1) | VARCHAR2(1) NOT NULL | Enable Alternate Account |
| 34 | ACCT_ALT_SUSPENSE | Character(10) | VARCHAR2(10) NOT NULL | Acct->Alt Suspense |
| 35 | ALT_ACCT_SUSPENSE | Character(10) | VARCHAR2(10) NOT NULL | Alt->Acct Suspense |
| 36 | UPDATE_CLOSING_SW | Character(1) | VARCHAR2(1) NOT NULL | Yes/No Indicator |
| 37 | JRNL_APPRVL_OPTN | Character(1) | VARCHAR2(1) NOT NULL |
Journal Approval Option
D=Default to Higher Level P=Pre-Approved S=Require Approval |
| 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 |
| 39 | BUSPROCNAME | Character(30) | VARCHAR2(30) NOT NULL | Business Process Name (see PSBUSPROCDEFN). |
| 40 | APPR_RULE_SET | Character(30) | VARCHAR2(30) NOT NULL | Approval Rule Set |
| 41 | BUSPROCNAME_BD | Character(30) | VARCHAR2(30) NOT NULL | Business Process Name - Budget |
| 42 | APPR_RULE_SET_BD | Character(30) | VARCHAR2(30) NOT NULL | Approval Rule Set - Budgets |
| 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. |
| 44 | DOC_TYPE_UNPOST | Character(8) | VARCHAR2(8) NOT NULL | Document Type for Unposted Journals |
| 45 | COMMITMENT_CNTL | Character(1) | VARCHAR2(1) NOT NULL | Enable Commitment Control |
| 46 | KK_REVERSAL_OPTN | Character(1) | VARCHAR2(1) NOT NULL |
Referenced Reversal Option
A=Amount Q=Quantity |
| 47 | KK_ERR_OPTN | Character(1) | VARCHAR2(1) NOT NULL | Stop Budget Check at 1st Error |
| 48 | KK_INCLUDE_PRE_ENC | Character(1) | VARCHAR2(1) NOT NULL |
Indicator - Include Pre-Encumbrance in RSA
1=Include 2=Exclude 3=Default |
| 49 | KK_ALLOW_INC_SA | Character(1) | VARCHAR2(1) NOT NULL | Yes/No Indicator - Allow Increase Spending Authority |
| 50 | POSITION_ACCOUNT | Character(8) | VARCHAR2(8) NOT NULL | Position Accounting |
| 51 | NO_POST_FUTURE_DT | Character(1) | VARCHAR2(1) NOT NULL | Yes/No Indicator |
| 52 | POST_REVERSAL_SW | Character(1) | VARCHAR2(1) NOT NULL | Indicator - Automatic Post Reversals |
| 53 | POST_SUMLED_SW | Character(1) | VARCHAR2(1) NOT NULL | Yes/No Indicator |
| 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 |
| 55 | UNPOST_INTERUNIT | Character(1) | VARCHAR2(1) NOT NULL | Yes/No Indicator |
| 56 | UNPOST_REVERSALS | Character(1) | VARCHAR2(1) NOT NULL | Yes/No Indicator |
| 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 |
| 59 | ENABLE_INC_LLOAD | Character(1) | VARCHAR2(1) NOT NULL | Enable Incremental Ledger Load |
| 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 | EO_FROM_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |