KK_REFERENCED_H

(SQL Table)
Index Back

Archived KK_REFERENCED Data

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PSARCH_ID Character(8) VARCHAR2(8) NOT NULL Archive ID (see PSARCHTEMPLATE).
2 PSARCH_BATCHNUM Number(30,0) DECIMAL(30) NOT NULL Archive Batch Number
3 KK_TRAN_ID Character(10) VARCHAR2(10) NOT NULL Commitment Control Foreign Key for Transaction Identification.
4 KK_TRAN_DT Date(10) DATE Commitment Control Transaction Original processing date. Primary key with KK_TRAN_ID.
5 KK_TRAN_LN Number(9,0) DECIMAL(9) NOT NULL Commitment Control Transaction Line number.
6 KK_REFD_ID Character(10) VARCHAR2(10) NOT NULL Comm Cntrl Referenced Tran ID
7 KK_REFD_DT Date(10) DATE Comm Cntrl Referenced Tran Dt
8 KK_REFD_LN Number(9,0) DECIMAL(9) NOT NULL Comm Cntrl Referenced Tran Ln