PO_CLMRECON1_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	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
6	TMP_FLD	Character(1)	VARCHAR2(1) NOT NULL	Field for holding temp data
7	STTL_FROM_AR_FLG	Character(1)	VARCHAR2(1) NOT NULL	Indicator for identifying claim settlements generated as a result of a receivables payment transaction.
8	ACCOUNTING_DT	Date(10)	DATE	The accounting entry construction date for a given transaction (a generic field that crosses multiple
9	AMT_CLAIM	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Claim Amount
10	AMT_COLLECTED	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Amount Collected
11	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
12	TAX_CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Tax Currency
13	TOL_AMT_OVER	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Over Tolerance Amount
14	TOL_AMT_UNDER	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Under Tolerance Amount
15	TOL_PCT_OVER	Number(6,2)	DECIMAL(5,2) NOT NULL	Over Tolerance Percent
16	TOL_PCT_UNDER	Number(6,2)	DECIMAL(5,2) NOT NULL	Under Tolerance Percent
17	TOT_CLAIM_COLLECT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Total Claim Collected
18	TOTAL_CLAIM_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Total Claim Amount
19	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.
20	AMT_VAT_COLLECTED	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	VAT Collected Amount
21	TOT_CLAIM_VAT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Total Claim VAT Amount
22	TOT_VAT_COLLECT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Total VAT Claim Collected
23	VRBT_ID	Character(25)	VARCHAR2(25) NOT NULL	Vendor Rebate ID
24	VALID_ACCT_DT	Character(1)	VARCHAR2(1) NOT NULL	Valid accounting date