PV_CC_RECON_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
3	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
4	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: CC_SEC_VW
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	TRANS_DT	Date(10)	DATE NOT NULL	Transaction Date
9	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. Default Value: CC_TRANS_LINE.DTTM_STAMP
10	DST_ACCT_TYPE	Character(4)	VARCHAR2(4) NOT NULL	07/20/04 st: added RCN for Advance Reconciliation 02/16/98 ebn CN#CM800-2.0 : Added for MISC type for Landed Cost Enhancement 11/11/99 llr: Added ADVP for Payables Advance Payment Default Value: DST
11	LINE_NBR	Number(5,0)	INTEGER NOT NULL	Line Number: 11/24/08 - Added TARGET label [PC product]
12	SCHED_NBR	Number(3,0)	SMALLINT NOT NULL	Schedule Number
13	DISTRIB_LINE_NUM	Number(5,0)	INTEGER NOT NULL	Distribution Line Default Value: 1
14	SEQUENCE_5	Number(5,0)	INTEGER NOT NULL	Sequnece Number of Length 5
15	TRANS_NBR_FROM	Character(24)	VARCHAR2(24) NOT NULL	Transaction Number
16	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
17	PO_ID	Character(10)	VARCHAR2(10) NOT NULL	Purchase Order
18	MERCHANDISE_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label
19	ITM_ID_VNDR	Character(50)	VARCHAR2(50) NOT NULL	Vendor Item ID
20	COUNTER1	Number(16,2)	DECIMAL(15,2) NOT NULL	Counter 1