PO_KK_RACHK_REQ(SQL Table) |
Index Back |
---|---|
Recpt Accrual Budget Ch'k Rqst |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
2 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
3 | REQUEST_NBR | Number(4,0) | SMALLINT NOT NULL |
Request Number
Default Value: 9999 |
4 | KK_PROCESS_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Comm Cntrl Process Type
C=Check Budget D=Delete Previous Activity P=Provisional check Only Default Value: C |
5 | KK_SOURCE_TRAN | Character(10) | VARCHAR2(10) NOT NULL |
Source Transaction Type
Prompt Table: KK_SOURCE_TRAN |
6 | SRCE_INSTANCE_OPTN | Character(1) | VARCHAR2(1) NOT NULL |
Source Instance Option
A=All Source Instances V=Single Source Instance Value Default Value: A |
7 | 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. |
8 | BUSINESS_UNIT_OPTN | Character(1) | VARCHAR2(1) NOT NULL |
Business Unit Option
A=All Business Units V=Specific Business Unit Default Value: A |
9 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BU_PM_NONVW |
10 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
11 | PROCESS_FREQUENCY | Character(1) | VARCHAR2(1) NOT NULL |
Process Frequency
A=Always Process N=Don't Run O=Process Once Default Value: N |
12 | 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 Default Value: N |
13 | PROCESS_ORIG | Character(1) | VARCHAR2(1) NOT NULL |
Process Origin
N=Other Source P=Process Scheduler Default Value: N |
14 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
15 | RESTART_PI | Number(10,0) | DECIMAL(10) NOT NULL | Restart Process Instance |
16 | 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. |
17 | ACCOUNTING_DT_OPTN | Character(1) | VARCHAR2(1) NOT NULL |
Accounting Date Option
A=All S=Some V=Value Default Value: A |
18 | ACCOUNTING_DT_FROM | Date(10) | DATE | The range of the accounting entry construction dates |
19 | ACCOUNTING_DT_TO | Date(10) | DATE | The range of the accounting entry construction dates |
20 | RECEIVER_ID_OPTN | Character(1) | VARCHAR2(1) NOT NULL |
Receiver ID Option
A=All S=Some V=Value Default Value: A |
21 | RECEIVER_ID_FROM | Character(10) | VARCHAR2(10) NOT NULL |
From/To
Prompt Table: RECV_HDR |
22 | RECEIVER_ID_TO | Character(10) | VARCHAR2(10) NOT NULL |
Receiver ID
Prompt Table: RECV_HDR |