KK_DISTRIB_STATUSB=Budget Check
C=Budget Create
D=Distributed
E=Posting Error
K=Post to Commitment control
N=None
S=Security Error
KK_ALOG_PC_VW_1(SQL View) |
Index Back |
|---|---|
Projects-KK Dist Status Prompt |
| SELECT DISTINCT A.KK_DISTRIB_STATUS FROM PS_KK_SOURCE_HDR A , PS_KK_ACTIVITY_LOG B WHERE A.KK_TRAN_ID = B.KK_TRAN_ID AND A.KK_TRAN_DT = B.KK_TRAN_DT AND A.KK_SOURCE_TRAN IN ('PC_COLL' ,'PC_ENC' ,'PC_JOURNAL' ,'PC_PREENC' ) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | KK_DISTRIB_STATUS |
Character(1) | VARCHAR2(1) NOT NULL |
Commitment Control
B=Budget Check C=Budget Create D=Distributed E=Posting Error K=Post to Commitment control N=None S=Security Error |