PO_CLMDED_T1

#	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 Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: OPR_DEF_TBL_FS
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	DATETIME_STAMP	DateTime(26)	TIMESTAMP	DateTime Stamp
6	ACCOUNTING_DT	Date(10)	DATE	The accounting entry construction date for a given transaction (a generic field that crosses multiple
7	STATUS	Character(1)	VARCHAR2(1) NOT NULL	Status Indicator A=Active I=Inactive
8	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
9	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
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	NOTIFY_STLMNT_STAT	Character(1)	VARCHAR2(1) NOT NULL	Settlement Mgr Notify Status N=No Notification P=Pending Notification Y=Notified
13	OVERDUE_FLG	Character(1)	VARCHAR2(1) NOT NULL	Overdue Status C=Current O=Overdue Y/N Table Edit Default Value: N
14	HOLD_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Hold From Further Processing Y/N Table Edit Default Value: N
15	REASON_CD	Character(10)	VARCHAR2(10) NOT NULL	Reason Code
16	TAX_CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Tax Currency
17	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.
18	AMT_VAT_COLLECTED	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	VAT Collected Amount