KK_SHDR_POCRD_H

#	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_SOURCE_TRAN	Character(10)	VARCHAR2(10) NOT NULL	Source Transaction Type
4	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
5	CREDIT_CARD_VENDOR	Character(5)	VARCHAR2(5) NOT NULL	Corporate Card Vendor
6	CRDMEM_ACCT_NBR	Character(44)	VARCHAR2(44) NOT NULL	Cardmember Number
7	TRANS_NBR	Character(24)	VARCHAR2(24) NOT NULL	Transaction Number
8	SEQUENCENO	Number(10,0)	DECIMAL(10) NOT NULL	Sequence Number
9	TRANS_DT	Date(10)	DATE	Transaction Date
10	LINE_NBR	Number(5,0)	INTEGER NOT NULL	Line Number: 11/24/08 - Added TARGET label [PC product]
11	DTTM_STAMP	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.
12	KK_ROLLED_SEQ	Number(3,0)	SMALLINT NOT NULL	PO Rolled Sequence
13	KK_TRAN_ID	Character(10)	VARCHAR2(10) NOT NULL	Commitment Control Foreign Key for Transaction Identification.
14	KK_TRAN_DT	Date(10)	DATE NOT NULL	Commitment Control Transaction Original processing date. Primary key with KK_TRAN_ID.
15	SEQUENCE_NBR_9	Number(9,0)	DECIMAL(9) NOT NULL	Sequence
16	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
17	KK_PROC_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
18	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
19	KK_DATETIME_STAMP	DateTime(26)	TIMESTAMP	DateTime Stamp