PROCESS_INSTANCEA=Average Daily Balance
B=Budget
E=Commitment Control Expense
R=Commitment Control Revenue
S=Standard
T=Translation
FS_ALLC_LED_AET(SQL Table) |
Index Back |
|---|---|
FS ALLC - ledger state recordFS ALLC - ledger state record |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). |
| 3 | RECNAME_JRNL_LN | Character(15) | VARCHAR2(15) NOT NULL | Journal Line |
| 4 | CALENDAR_ID | Character(2) | VARCHAR2(2) NOT NULL | Calendar ID |
| 5 | SECOND_LEDGERS | Character(1) | VARCHAR2(1) NOT NULL | Secondary Ledgers Exist |
| 6 | LEDGERS_SYNC | Character(1) | VARCHAR2(1) NOT NULL | Keep Ledgers in Sync |
| 7 | 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 |
| 8 | SEPARATE_DRCR | Character(1) | VARCHAR2(1) NOT NULL | Enable Separate Debit/Credit |
| 9 | LEDGER | Character(10) | VARCHAR2(10) NOT NULL | Ledger |
| 10 | LEDGER_GROUP | Character(10) | VARCHAR2(10) NOT NULL | Ledger Group |
| 11 | 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. |
| 12 | CUR_RT_TYPE_DFLT | Character(5) | VARCHAR2(5) NOT NULL | Exchange Rate Type Default |