GL_FAIJEDIT_AET(SQL Table) |
Index Back |
|---|---|
GL Journal Edit 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_HEADER | Character(15) | VARCHAR2(15) NOT NULL |
Header Record
Prompt Table: PSRECDEFN |
| 3 | RECNAME_LINE | Character(15) | VARCHAR2(15) NOT NULL |
Line Record
Prompt Table: PSRECDEFN |
| 4 | HDR_KEYS_SQL | Character(254) | VARCHAR2(254) NOT NULL | Header Keys SQL |
| 5 | HDR_GENKEYS_SQL | Character(254) | VARCHAR2(254) NOT NULL | Header Generic Keys SQL |
| 6 | HDR_GENKEYS_VAL | Character(254) | VARCHAR2(254) NOT NULL | Header Generic Keys Value |
| 7 | HDR_GENKEYS_WPRFX | Character(254) | VARCHAR2(254) NOT NULL | Header Generic Keys SQL Prefix |
| 8 | HDR_KEYS_WPRFX_SQL | Character(254) | VARCHAR2(254) NOT NULL | Header Keys with Prefix SQL |
| 9 | HDR_KEYS_VL_CONCAT | Character(254) | VARCHAR2(254) NOT NULL | Header Keys Values Concatenate |
| 10 | HDR_LINE_JOIN_SQL | Character(254) | VARCHAR2(254) NOT NULL | Header and Line Join SQL |
| 11 | GENHDR_LINE_JOIN | Character(254) | VARCHAR2(254) NOT NULL | Generic Hdr and Line Join SQL |
| 12 | WHERE_CLAUSE | Character(254) | VARCHAR2(254) NOT NULL | Where Clause |
| 13 | WHERE_CLAUSE1 | Character(254) | VARCHAR2(254) NOT NULL | Where Clause |
| 14 | WHERE_CLAUSE2 | Character(254) | VARCHAR2(254) NOT NULL | Where Clause |
| 15 | WHERE_CLAUSE3 | Character(254) | VARCHAR2(254) NOT NULL | Where Clause |
| 16 | DYNAMIC_JOIN_SQL | Character(254) | VARCHAR2(254) NOT NULL | Dynamic Join SQL |
| 17 | HDR_KEYS_CNT | Number(3,0) | SMALLINT NOT NULL | Header Keys Count |
| 18 | LINE_KEYS_CNT | Number(3,0) | SMALLINT NOT NULL | Line Keys Count |
| 19 | LINE_KEYS_SQL | Character(254) | VARCHAR2(254) NOT NULL | Line Keys SQL |
| 20 | LINE_GENKEYS_SQL | Character(254) | VARCHAR2(254) NOT NULL | Line Generic Keys SQL |
| 21 | LN_KEYS_WPRFX_SQL | Character(254) | VARCHAR2(254) NOT NULL | Line Keys with Prefix SQL |
| 22 | BU_FIELD | Character(18) | VARCHAR2(18) NOT NULL | Business Unit Field Name |
| 23 | ACCTG_DT_FIELD | Character(18) | VARCHAR2(18) NOT NULL | Accounting Date Fieldname |
| 24 | EXIST | Character(1) | VARCHAR2(1) NOT NULL | Exist |
| 25 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 26 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 27 | REQUEST_NBR | Number(4,0) | SMALLINT NOT NULL | Request Number |
| 28 | SOURCE_INSTANCE | Number(15,4) | DECIMAL(14,4) NOT NULL | Identifies a Process Instance (PROCESS_INSTANCE), and is used by the PeopleSoft Process Scheduler to save this identifier. |
| 29 | BUSINESS_UNIT_IU | Character(5) | VARCHAR2(5) NOT NULL | Specifies the Business Unit for which InterUnit activity is being generated. |
| 30 | BUSINESS_UNIT_CHRG | Character(5) | VARCHAR2(5) NOT NULL | Charged Business Unit |
| 31 | EXT_SYSTEM_ID | Character(10) | VARCHAR2(10) NOT NULL | External System ID |
| 32 | COMBO_EDIT_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Edit Combinations
Y/N Table Edit |
| 33 | CF_MCHG_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Enable Chartfield Mass Change
Y/N Table Edit |
| 34 | PROCESS_IU_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Create Inter/IntraUnit Entries
Y/N Table Edit |
| 35 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 36 | LEDGER_GROUP | Character(10) | VARCHAR2(10) NOT NULL | Ledger Group |
| 37 | FAI_TRANSACTION_ID | Character(10) | VARCHAR2(10) NOT NULL | FAI Transaction ID |
| 38 | FAI_TRANS_NEXTNUM | Character(10) | VARCHAR2(10) NOT NULL | FAI Transaction ID |
| 39 | FAI_LINE_NBR | Number(9,0) | DECIMAL(9) NOT NULL | FAI Line Number |
| 40 | IU_BAL_LINE_NBR | Number(10,0) | DECIMAL(10) NOT NULL | Inter/Intra Unit Balancing Lin |
| 41 | LEDGER | Character(10) | VARCHAR2(10) NOT NULL | Ledger |
| 42 | COMBO_EDIT_STATUS | Character(2) | VARCHAR2(2) NOT NULL |
Combination Edit Status
E=Error I=Ignore V=Valid |
| 43 | CF_MCHG_GROUP | Character(10) | VARCHAR2(10) NOT NULL | Chartfield Mass Change Group |
| 44 | CF_MCHG_RULE | Character(10) | VARCHAR2(10) NOT NULL | Chartfield Mass Change Rule |
| 45 | LINE_COUNT | Number(5,0) | INTEGER NOT NULL | Line Count |
| 46 | APPL_JRNL_ID | Character(10) | VARCHAR2(10) NOT NULL | Journal Template |
| 47 | LAST_SEQ_NBR | Number(15,0) | DECIMAL(15) NOT NULL | Last Sequence number in list |
| 48 | ACCT_FROM_DT | Date(10) | DATE | Accounting Date From |
| 49 | ACCT_TO_DT | Date(10) | DATE | Acctg To Date |
| 50 | FAI_POST_OPTN | Character(1) | VARCHAR2(1) NOT NULL | Post Option |
| 51 | COMBO_EDIT_TMPL | Character(10) | VARCHAR2(10) NOT NULL | Record Template |
| 52 | TOTAL_CNT_SUMM | Number(8,0) | INTEGER NOT NULL | Total Count |
| 53 | PROC_PART_ID | Character(10) | VARCHAR2(10) NOT NULL | Process Partition ID |
| 54 | JOURNAL_ID_FROM | Character(10) | VARCHAR2(10) NOT NULL | Range From Journal ID |
| 55 | JOURNAL_ID_TO | Character(10) | VARCHAR2(10) NOT NULL | Range to Journal ID |
| 56 | JOURNAL_DATE_FROM | Date(10) | DATE | Journal Date From |
| 57 | JOURNAL_DATE_TO | Date(10) | DATE | To Journal Date |
| 58 | PROCESS_FREQUENCY | Character(1) | VARCHAR2(1) NOT NULL |
Process Frequency
A=Always Process N=Don't Run O=Process Once |
| 59 | PROCESS_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Process Status
A=Active C=Successfully Completed E=Completed With Errors N=Not Yet Processed P=Processing Now X=No Success |
| 60 | PROCESS_ORIG | Character(1) | VARCHAR2(1) NOT NULL |
Process Origin
N=Other Source P=Process Scheduler |
| 61 | 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. |
| 62 | KEY_CHAR_25_01 | Character(25) | VARCHAR2(25) NOT NULL | Key Char(25) 01 |
| 63 | KEY_CHAR_25_02 | Character(25) | VARCHAR2(25) NOT NULL | Key Char(25) 02 |
| 64 | KEY_CHAR_25_03 | Character(25) | VARCHAR2(25) NOT NULL | Key Char(25) 03 |
| 65 | KEY_CHAR_25_04 | Character(25) | VARCHAR2(25) NOT NULL | Key Char(25) 04 |
| 66 | KEY_CHAR_25_05 | Character(25) | VARCHAR2(25) NOT NULL | Key Char(25) 05 |
| 67 | KEY_CHAR_25_06 | Character(25) | VARCHAR2(25) NOT NULL | Key Char(25) 06 |
| 68 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 69 | SQL_STMT | Long Character(8192) | CLOB | An internal work field that contains SQL text that is to be utilized in treasury application processing. |
| 70 | OPERATING_UNIT | Character(8) | VARCHAR2(8) NOT NULL | Operating Unit ChartField |
| 71 | PRODUCT | Character(6) | VARCHAR2(6) NOT NULL | Product ChartField |
| 72 | FUND_CODE | Character(5) | VARCHAR2(5) NOT NULL | Fund Code |
| 73 | CLASS_FLD | Character(5) | VARCHAR2(5) NOT NULL | Class Field |
| 74 | PROGRAM_CODE | Character(5) | VARCHAR2(5) NOT NULL | Program Code ChartField |
| 75 | BUDGET_REF | Character(8) | VARCHAR2(8) NOT NULL | Budget Reference |
| 76 | AFFILIATE | Character(5) | VARCHAR2(5) NOT NULL | Affiliate |
| 77 | AFFILIATE_INTRA1 | Character(10) | VARCHAR2(10) NOT NULL | IntraUnit Affiliate1 |
| 78 | AFFILIATE_INTRA2 | Character(10) | VARCHAR2(10) NOT NULL | Operating Unit Affiliate |
| 79 | CHARTFIELD1 | Character(10) | VARCHAR2(10) NOT NULL | Expansion chartfield 1 |
| 80 | CHARTFIELD2 | Character(10) | VARCHAR2(10) NOT NULL | Expansion Chartfield 2 |
| 81 | CHARTFIELD3 | Character(10) | VARCHAR2(10) NOT NULL | Expansion Chartfield 3 |
| 82 | ALTACCT | Character(10) | VARCHAR2(10) NOT NULL | Alternate Account |
| 83 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL | Department |
| 84 | PROJECT_ID | Character(15) | VARCHAR2(15) NOT NULL | Project Id ChartField |
| 85 | ACCOUNT | Character(10) | VARCHAR2(10) NOT NULL | Account |
| 86 | COUNTER1 | Number(16,2) | DECIMAL(15,2) NOT NULL | Counter 1 |
| 87 | COUNTER2 | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Counter 2 |
| 88 | 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. |
| 89 | ORDERBY | Character(254) | VARCHAR2(254) NOT NULL | ORDER BY |