UPG_EE_TMP2(SQL Table) |
Index Back |
---|---|
UPG_EE_TMP2Upgrade Temp record |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
2 | ENTRY_EVENT | Character(10) | VARCHAR2(10) NOT NULL | Entry Event |
3 | EE_PROCESS | Character(10) | VARCHAR2(10) NOT NULL | Entry Event Process |
4 | EFFDT | Date(10) | DATE |
Effective Date
Default Value: %date |
5 | EE_EVENT_STEP | Character(10) | VARCHAR2(10) NOT NULL | Entry Event Step |
6 | EVENT_LINE | Number(5,0) | INTEGER NOT NULL | Entry Event Line Number |
7 | ACCOUNT2 | Character(10) | VARCHAR2(10) NOT NULL | Account |
8 | DFLT_JRNL_FLG | Character(1) | VARCHAR2(1) NOT NULL | Default Journal Flag |
9 | APPL_JRNL_ID | Character(10) | VARCHAR2(10) NOT NULL | Journal Template |
10 | DEBIT_CREDIT | Character(2) | VARCHAR2(2) NOT NULL |
Debit / Credit Indicator
CR=Credit DR=Debit |
11 | ACCOUNT | Character(10) | VARCHAR2(10) NOT NULL | Account |
12 | ALTACCT | Character(10) | VARCHAR2(10) NOT NULL | Alternate Account |
13 | PROCESS_GROUP | Character(10) | VARCHAR2(10) NOT NULL | Process Group |
14 | PROCESS_STEP | Character(10) | VARCHAR2(10) NOT NULL | Process Step |