KK_TRAN_IDKK_TRAN_DTE=Errors Exist
I=Document in process
N=Process Unsuccessful
P=Provisionally Valid
V=No Errors or Warnings
W=Only Warnings Exist
X=Unrecorded Errors Exist
KK_SHDR_PCJ_VW(SQL View) |
Index Back |
|---|---|
Comm. Cntrl. Source Hdr TableThe following view is used in BTF. This view needs to be keyed by kk_tran_id and kk_tran_dt. |
| SELECT %subrec(KK_SHDR_PCJ_VW, A) FROM PS_KK_SHDR_PCJRNL A |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | KK_TRAN_ID |
Character(10) | VARCHAR2(10) NOT NULL | Commitment Control Foreign Key for Transaction Identification. |
| 2 | KK_TRAN_DT |
Date(10) | DATE NOT NULL | Commitment Control Transaction Original processing date. Primary key with KK_TRAN_ID. |
| 3 | SEQUENCE_NBR_9 | Number(9,0) | DECIMAL(9) NOT NULL | Sequence |
| 4 | KK_PROCESS_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Process Status
E=Errors Exist I=Document in process N=Process Unsuccessful P=Provisionally Valid V=No Errors or Warnings W=Only Warnings Exist X=Unrecorded Errors Exist |
| 5 | KK_PROC_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 6 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 7 | KK_DATETIME_STAMP | DateTime(26) | TIMESTAMP | DateTime Stamp |
| 8 | KK_SOURCE_TRAN | Character(10) | VARCHAR2(10) NOT NULL | Source Transaction Type |
| 9 | 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. |
| 10 | BUSINESS_UNIT_PC | Character(5) | VARCHAR2(5) NOT NULL | PC Business Unit |
| 11 | PROJECT_ID | Character(15) | VARCHAR2(15) NOT NULL | Project Id ChartField |
| 12 | ACTIVITY_ID | Character(15) | VARCHAR2(15) NOT NULL | Activity ID |
| 13 | KK_ROLLED_SEQ | Number(3,0) | SMALLINT NOT NULL | PO Rolled Sequence |