PO_CLMSTLSL_AET

(SQL Table)
Index Back

AET record for PO_CLMSTLSEL

AET record for PO_CLMSTLSEL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 AMT_CLAIM Signed Number(28,3) DECIMAL(26,3) NOT NULL Claim Amount
3 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
4 SETID Character(5) VARCHAR2(5) NOT NULL SetID
5 CLAIM_ID Character(15) VARCHAR2(15) NOT NULL Claim ID
6 CLAIM_SETTLE_SEQ Number(5,0) INTEGER NOT NULL Claim Settlement Sequence
7 CALLING_SRC Character(1) VARCHAR2(1) NOT NULL
8 DISTRIB_LINE_NUM Number(5,0) INTEGER NOT NULL Distribution Line
9 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
10 TEMP_FLD Character(1) VARCHAR2(1) NOT NULL Temporary Field for App Engine
11 TOTAL_CLAIM_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Total Claim Amount
12 TOT_CLAIM_VAT Signed Number(28,3) DECIMAL(26,3) NOT NULL Total Claim VAT Amount
13 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.