FS_JGEN_JR_AET(SQL Table) |
Index Back |
|---|---|
FS JGEN - journal 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 | EXIST | Character(1) | VARCHAR2(1) NOT NULL | Exist |
| 3 | AE_SECTION | Character(8) | VARCHAR2(8) NOT NULL | Section |
| 4 | JOURNAL_NUM_ASSIGN | Number(10,0) | DECIMAL(10) NOT NULL | Journal Number - Auto Assigned |
| 5 | JOURNAL_LINE | Number(9,0) | DECIMAL(9) NOT NULL | Uniquely identifies a journal line with a sequence number. Within a single journal entry, the line sequence begins with 1 and automatically increments by 1 for each succeeding journal line. There can be any number of lines associated with a journal header. |
| 6 | JOURNAL_LINE_ADD | Number(9,0) | DECIMAL(9) NOT NULL | Journal Lines to add |
| 7 | JOURNAL_ID | Character(10) | VARCHAR2(10) NOT NULL | Identifies a journal entry, consisting of a header and one or more lines. The Journal ID itself does not have to be unique, but together with the journal business unit and journal date, it forms a unique journal identifier. |
| 8 | JOURNAL_DATE | Date(10) | DATE | Specifies the date the journal was created. |
| 9 | FISCAL_YEAR | Number(4,0) | SMALLINT NOT NULL | Fiscal Year |
| 10 | 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. |
| 11 | ACCTG_FROM_DT | Date(10) | DATE | Accounting Date From |
| 12 | ACCTG_TO_DT | Date(10) | DATE | Accounting Date To |
| 13 | WHERE_CLAUSE | Character(254) | VARCHAR2(254) NOT NULL | Where Clause |
| 14 | 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 |
| 15 | FOREIGN_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | Foreign Currency Code |
| 16 | KK_AMOUNT_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Commitment Control Amount Type
0=Budget 1=Actuals and Recognized 2=Encumbrance 3=Pre-Encumbrance 4=Collected Revenue 5=Planned 7=Actuals, Recognize and Collect 9=Dynamic |
| 17 | ADJUSTING_ENTRY | Character(1) | VARCHAR2(1) NOT NULL |
Adjusting Entry
C=Fiscal Year Close N=Non-Adjusting Entry Y=Adjusting Entry |
| 18 | ADB_DATE | Date(10) | DATE | Specifies the daily date to use when Average Daily Balancing is activated. The date is determined by the daily calendar associated with the General Ledger Business Unit to which the journal is posted. When ADB processing is not activated, the ADB_Date defaults to the date on the Journal Header (JOURNAL_DATE). |
| 19 | AUTO_GEN_LINES | Character(1) | VARCHAR2(1) NOT NULL | A flag that indicates whether or not (Y or N) journal lines should be automatically generated for other ledgers in a ledger group. This option is automatically on if the Keep Ledgers in Sync option is on for the specified ledger group. You can select the Auto Generate Lines option for a multibook ledger group specified on a journal header. |
| 20 | RECNAME_TREESEL | Character(15) | VARCHAR2(15) NOT NULL | Tree Selector Record Name |
| 21 | FIELD_LENGTH | Number(3,0) | SMALLINT NOT NULL | Field Length |
| 22 | FIELDNAME_FROM | Character(18) | VARCHAR2(18) NOT NULL | This fieldname from field is used to by the power pricer reports so that it could be used to filter the reporting criteria. |
| 23 | FIELDNAME_TO | Character(18) | VARCHAR2(18) NOT NULL | Destination Field |
| 24 | TREE_SETID | Character(5) | VARCHAR2(5) NOT NULL | Tree SetID |
| 25 | TREE_EFFDT | Date(10) | DATE | Effective date of the Tree |
| 26 | DTL_FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL | Tree Structure Detail Record name |
| 27 | TREE_HAS_RANGES | Character(1) | VARCHAR2(1) NOT NULL | Tree Has Ranges |
| 28 | CONTN_SUM_LOOP | Character(1) | VARCHAR2(1) NOT NULL | Continue Summarization Loop in Journal Generator. |
| 29 | CONTN_DRCR_LOOP | Character(1) | VARCHAR2(1) NOT NULL | Continue Debit/Credit Loop in Journal Generator. |
| 30 | CONTN_TLED_LOOP | Character(1) | VARCHAR2(1) NOT NULL | Continue Translation Ledger Loop in Journal Generator. |
| 31 | FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Flag
N=No Y=Yes |
| 32 | DRILL_DOWN_OPTN | Character(1) | VARCHAR2(1) NOT NULL |
Cross Product Drill Down
N=No Drill Down Y=Drill Down |
| 33 | LEDGER | Character(10) | VARCHAR2(10) NOT NULL | Ledger |
| 34 | DOC_SEQ | Character(1) | VARCHAR2(1) NOT NULL | Enable Document Sequencing |