VRBT_CLAIM_STWD

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: OPR_DEF_TBL_FS
2	CLAIM_ID	Character(15)	VARCHAR2(15) NOT NULL	Claim ID
3	CLAIM_SETTLE_SEQ	Number(5,0)	INTEGER NOT NULL	Claim Settlement Sequence
4	DATETIME_STAMP	DateTime(26)	TIMESTAMP	DateTime Stamp
5	ACCOUNTING_DT	Date(10)	DATE	The accounting entry construction date for a given transaction (a generic field that crosses multiple
6	STATUS	Character(1)	VARCHAR2(1) NOT NULL	Status Indicator A=Active I=Inactive
7	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
8	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
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	NOTIFY_STLMNT_STAT	Character(1)	VARCHAR2(1) NOT NULL	Settlement Mgr Notify Status N=No Notification P=Pending Notification Y=Notified
12	OVERDUE_FLG	Character(1)	VARCHAR2(1) NOT NULL	Overdue Status C=Current O=Overdue Y/N Table Edit Default Value: N
13	HOLD_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Hold From Further Processing Y/N Table Edit Default Value: N
14	REASON_CD	Character(10)	VARCHAR2(10) NOT NULL	Reason Code
15	TAX_CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Tax Currency
16	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.
17	AMT_VAT_COLLECTED	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	VAT Collected Amount
18	PAYMENT_DT	Date(10)	DATE	Payment Date
19	CLAIM_PYMT_REF_AP	Character(60)	VARCHAR2(60) NOT NULL	AP Payment Reference
20	CLAIM_PYMT_REF_AR	Character(60)	VARCHAR2(60) NOT NULL	AR Payment Reference
21	PROCESS_FLG	Character(1)	VARCHAR2(1) NOT NULL	Processing Flag Y/N Table Edit Default Value: N