UPG_POSTRC_AET(SQL Table) |
Index Back |
|---|---|
Control Budget Posting Request |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 3 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 4 | REQUEST_NBR | Number(4,0) | SMALLINT NOT NULL | Request Number |
| 5 | KK_PROCESS_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Comm Cntrl Process Type
C=Check Budget D=Delete Previous Activity P=Provisional check Only |
| 6 | KK_SOURCE_TRAN | Character(10) | VARCHAR2(10) NOT NULL | Source Transaction Type |
| 7 | BUSINESS_UNIT_OPTN | Character(1) | VARCHAR2(1) NOT NULL |
Business Unit Option
A=All Business Units V=Specific Business Unit |
| 8 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 9 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 10 | LEDGER_GROUP_OPTN | Character(1) | VARCHAR2(1) NOT NULL |
Ledger Group Option
A=All Ledger Group Values V=Single Ledger Group Value |
| 11 | LEDGER_GROUP | Character(10) | VARCHAR2(10) NOT NULL | Ledger Group |
| 12 | ENTRY_TYPE_OPTN | Character(1) | VARCHAR2(1) NOT NULL |
Entry Type Option
A=All Entry Types V=Single Entry Type |
| 13 | KK_BUDG_TRANS_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Budget Entry Type
0=Original 1=Adjustment 2=Transfer Adjustment 3=Transfer Original 4=Closing 5=Roll Forward |
| 14 | SYSTEM_SOURCE_OPTN | Character(1) | VARCHAR2(1) NOT NULL |
System Source Option
A=All System Sources V=Single System Source Value |
| 15 | SYSTEM_SOURCE | Character(3) | VARCHAR2(3) NOT NULL | Identifies the application or source system that generated a journal entry. Release 8.80 - 11/14/2002 - RVlasic - Removed GDM (JrnlGen - Deduction Management) from Translate Values. SUJ---Included a label as Product. Release 8.9 - 05/11/2005 - RVlasic - Added PRV (Variance Pricing) and PKK (KK Budget Journal) and deleted GLK for Project Costing per Brian Cohen. |
| 16 | JOURNAL_ID_OPTN | Character(1) | VARCHAR2(1) NOT NULL |
Journal ID Option
A=All Journal IDs S=Some Journal ID Values |
| 17 | JOURNAL_ID_FROM | Character(10) | VARCHAR2(10) NOT NULL | Range From Journal ID |
| 18 | JOURNAL_ID_TO | Character(10) | VARCHAR2(10) NOT NULL | Range to Journal ID |
| 19 | JOURNAL_ID_R | Character(10) | VARCHAR2(10) NOT NULL | Journal ID to Replace |
| 20 | JOURNAL_DATE_OPTN | Character(1) | VARCHAR2(1) NOT NULL |
Journal Date Option
A=All Journal Dates S=Some Journal Date Values |
| 21 | JOURNAL_DATE_FROM | Date(10) | DATE | Journal Date From |
| 22 | JOURNAL_DATE_TO | Date(10) | DATE | To Journal Date |
| 23 | JOURNAL_DATE_R | Date(10) | DATE | Journal Date to Replace |
| 24 | KK_POST_ACTION | Character(1) | VARCHAR2(1) NOT NULL |
Posting Request Action
B=Post & Unpost P=Post R=Replace U=Unpost |
| 25 | EE_SKIP | Character(1) | VARCHAR2(1) NOT NULL | Yes/No Indicator - Skip Entry Event processing |
| 26 | PROCESS_FREQUENCY | Character(1) | VARCHAR2(1) NOT NULL |
Process Frequency
A=Always Process N=Don't Run O=Process Once |
| 27 | 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 |
| 28 | PROCESS_ORIG | Character(1) | VARCHAR2(1) NOT NULL |
Process Origin
N=Other Source P=Process Scheduler |
| 29 | 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. |
| 30 | RESTART_PI | Number(10,0) | DECIMAL(10) NOT NULL | Restart Process Instance |
| 31 | SELECT_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Selection Flag
N=No Y=Yes |
| 32 | SEQUENCE_NBR | Number(2,0) | SMALLINT NOT NULL | Sequence Number |
| 33 | NULL_DATE | Date(10) | DATE | Date field with NULL value |