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_APV_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_APV_VW, A) FROM PS_KK_SHDR_APVCHR 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 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 10 | VOUCHER_ID | Character(8) | VARCHAR2(8) NOT NULL | Voucher ID |
| 11 | KK_ROLLED_SEQ | Number(3,0) | SMALLINT NOT NULL | PO Rolled Sequence |