PO_CLMRECON2_T

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
3	CLAIM_ID	Character(15)	VARCHAR2(15) NOT NULL	Claim ID
4	CLAIM_SETTLE_SEQ	Number(5,0)	INTEGER NOT NULL	Claim Settlement Sequence
5	TMP_FLD	Character(1)	VARCHAR2(1) NOT NULL	Field for holding temp data
6	SETTLEMENT_METHOD	Character(3)	VARCHAR2(3) NOT NULL	Vendor Rebate Settlement Method (Payment Method) ACH=Automated Clearing House AV=Adjustment Voucher CHK=Check CM=Credit Memo DD=Direct Debit DR=Draft EFT=Electronic Funds Transfer
7	VALID_ACCT_DT	Character(1)	VARCHAR2(1) NOT NULL	Valid accounting date
8	STTL_FROM_AR_FLG	Character(1)	VARCHAR2(1) NOT NULL	Indicator for identifying claim settlements generated as a result of a receivables payment transaction.
9	ACCOUNTING_DT	Date(10)	DATE	The accounting entry construction date for a given transaction (a generic field that crosses multiple
10	AMT_CLAIM	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Claim Amount
11	AMT_COLLECTED	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Amount Collected
12	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
13	TAX_CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Tax Currency
14	TOL_AMT_OVER	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Over Tolerance Amount
15	TOL_AMT_UNDER	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Under Tolerance Amount
16	TOL_PCT_OVER	Number(6,2)	DECIMAL(5,2) NOT NULL	Over Tolerance Percent
17	TOL_PCT_UNDER	Number(6,2)	DECIMAL(5,2) NOT NULL	Under Tolerance Percent
18	TOT_CLAIM_COLLECT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Total Claim Collected
19	TOTAL_CLAIM_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Total Claim Amount
20	VAT_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Specifies the amount of VAT associated with a transaction such as an invoice or a purchase order. In PeopleSoft Receivables this field is populated when the VAT declaration point is set to Invoice.
21	AMT_VAT_COLLECTED	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	VAT Collected Amount
22	TOT_CLAIM_VAT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Total Claim VAT Amount
23	TOT_VAT_COLLECT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Total VAT Claim Collected
24	VRBT_ID	Character(25)	VARCHAR2(25) NOT NULL	Vendor Rebate ID