FS_MC_LEDTO_AET(SQL Table) |
Index Back |
|---|---|
FS MC - led group to record |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | LEDGER | Character(10) | VARCHAR2(10) NOT NULL | Ledger |
| 3 | INHERIT_BASE_CUR | Character(1) | VARCHAR2(1) NOT NULL | Inherit Base Currency |
| 4 | 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. " |
| 5 | RT_TYPE | Character(5) | VARCHAR2(5) NOT NULL | Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical. |
| 6 | TRANSL_LEDGER | Character(1) | VARCHAR2(1) NOT NULL |
Currency Translation Ledger
Y/N Table Edit |
| 7 | BALANCED_LEDGER | Character(1) | VARCHAR2(1) NOT NULL | Balanced Ledger |
| 8 | SEPARATE_DRCR | Character(1) | VARCHAR2(1) NOT NULL | Enable Separate Debit/Credit |
| 9 | CALENDAR_ID | Character(2) | VARCHAR2(2) NOT NULL | Calendar ID |
| 10 | CALENDAR_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Type of Calendar
B=Budget Calendar D=Detail Calendar I=Summary Budget Period Calendar P=Budget Period Calendar S=Summary Calendar T=Promo Mgmt Sales Calendar |
| 11 | DETAIL_CALENDAR | Character(2) | VARCHAR2(2) NOT NULL | Detail Calendar |
| 12 | ALTACCT_OPTN | Character(1) | VARCHAR2(1) NOT NULL | Enable Alternate Account |
| 13 | LEDGER_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Ledger Type
D=Detail Ledger K=Commitment Control Ledger S=Summary Ledger |
| 14 | ACCT_ALT_SUSPENSE | Character(10) | VARCHAR2(10) NOT NULL | Acct->Alt Suspense |
| 15 | ALT_ACCT_SUSPENSE | Character(10) | VARCHAR2(10) NOT NULL | Alt->Acct Suspense |
| 16 | COMMITMENT_CNTL | Character(1) | VARCHAR2(1) NOT NULL | Enable Commitment Control |
| 17 | ENABLE_INC_SLED | Character(1) | VARCHAR2(1) NOT NULL | Yes/No Indicator - Enable Incremental Summary Ledger update |
| 18 | LEDGER_GROUP_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Ledger Group Type
A=Average Daily Balance B=Budget E=Commitment Control Expense R=Commitment Control Revenue S=Standard T=Translation |
| 19 | LEDGERS_SYNC | Character(1) | VARCHAR2(1) NOT NULL | Keep Ledgers in Sync |
| 20 | SECOND_LEDGERS | Character(1) | VARCHAR2(1) NOT NULL | Secondary Ledgers Exist |
| 21 | LEDGER_TEMPLATE | Character(10) | VARCHAR2(10) NOT NULL | Ledger Template |
| 22 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). |
| 23 | RECNAME_CURR_WRK | Character(15) | VARCHAR2(15) NOT NULL | MultiCurrency Tmp |
| 24 | RECNAME_CUR_WRK1 | Character(15) | VARCHAR2(15) NOT NULL | MultiCurrency Tmp1 |
| 25 | RECNAME_CURR_LOG | Character(15) | VARCHAR2(15) NOT NULL | MultiCurrency Log |
| 26 | RECNAME_JRNL_HDR | Character(15) | VARCHAR2(15) NOT NULL | Journal Header |
| 27 | RECNAME_JRNL_LN | Character(15) | VARCHAR2(15) NOT NULL | Journal Line |
| 28 | RECNAME_ACCOUNT | Character(15) | VARCHAR2(15) NOT NULL | Account ChartField |
| 29 | RECNAME_JRNL_TMP | Character(15) | VARCHAR2(15) NOT NULL | Journal Line Tmp |
| 30 | FIELDNAME_TOTAL_CR | Character(18) | VARCHAR2(18) NOT NULL | Posted Total Credits |
| 31 | FIELDNAME_TOTAL_DR | Character(18) | VARCHAR2(18) NOT NULL | Posted Total Debits |
| 32 | FIELDNAME_TOTAL_NT | Character(18) | VARCHAR2(18) NOT NULL | Posted Total Amount |
| 33 | FIELDNAME_MON_AMT | Character(18) | VARCHAR2(18) NOT NULL | Monetary Amount |
| 34 | FISCAL_YEAR | Number(4,0) | SMALLINT NOT NULL | Fiscal Year |
| 35 | FISCAL_YEAR2 | Number(4,0) | SMALLINT NOT NULL | Fiscal Year |
| 36 | ACCOUNTING_PERIOD | Number(3,0) | SMALLINT NOT NULL | Identifies a time period to which you post transactions. Typically, an accounting period represents a month, but it can also represent a week, a day, or any user-defined interval. An accounting period has a beginning date and an ending date, and is defined in the calendar table. |
| 37 | ACCOUNTING_PERIOD2 | Number(3,0) | SMALLINT NOT NULL | Accounting Period |