VR_CLAIM_WB_VW1

(SQL View)
 Index Back

Supplier Rebate WB Claim Scrol

Supplier Rebate Workbench Claim Work Scroll transaction

SELECT A.OPRID , A.SETID , A.WORKBENCH_ID , B.CLAIM_ID , B.CLAIM_TYPE , A.CLAIM_ACTION , A.CLAIM_PROCESS_ACT , B.CLAIM_STATUS , B.CLAIM_RECON_STAT , A.IN_PROCESS_FLG , B.OVERDUE_FLG , B.OVERDUE_DEDUCT , B.CLAIM_DT , B.CLAIM_DUE_DT , B.ACCOUNTING_DT , B.VRBT_ID , B.VENDOR_SETID , B.VENDOR_ID , B.VNDR_LOC , B.CB_CONTRACT_SETID , B.CB_CONTRACT_ID , B.TOTAL_CLAIM_AMT , B.TOT_CLAIM_VAT , B.CURRENCY_CD , B.TOT_CLAIM_AMT_BSE , B.CURRENCY_CD_BASE , B.TOT_CLAIM_AMT_ORG , B.TOT_CLAIM_COLLECT , B.TOT_VAT_COLLECT , B.SETTLEMENT_METHOD , B.NOTIFY_REBATE_MGR , B.REBATE_MGR , B.NOTIFY_STLMENT_MGR , B.SETTLEMENT_MGR , B.CLAIM_ID_DEFER FROM PS_VRBT_CLAIM_WBWD A , PS_VRBT_CLAIM_HDR B WHERE A.SETID = B.SETID AND A.CLAIM_ID = B.CLAIM_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

Default Value: OPR_DEF_TBL_FS.OPRID

2 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Default Value: OPR_DEF_TBL_FS.SETID

Prompt Table: OPR_DEF_TBL_FS

3 WORKBENCH_ID Character(10) VARCHAR2(10) NOT NULL WorkBench ID
4 CLAIM_ID Character(15) VARCHAR2(15) NOT NULL Claim ID
5 CLAIM_TYPE Character(1) VARCHAR2(1) NOT NULL Claim Type
C=Claimbacks
R=Vendor Rebate
6 CLAIM_ACTION Character(1) VARCHAR2(1) NOT NULL Claim Status Action
A=Approve
C=Cancel
D=Defer
U=Return To Open
7 CLAIM_PROCESS_ACT Character(1) VARCHAR2(1) NOT NULL Claim Processing Action
1=Claim Settlement
2=Print for Dispatch
3=Payment Reconciliation
4=Overdue
5=Cancel Deduction
8 CLAIM_STATUS Character(1) VARCHAR2(1) NOT NULL Claim Status
1=Open
3=Approved
5=Deferred
6=Cancelled
7=Pending Payment
8=Partially Paid
9=Paid
9 CLAIM_RECON_STAT Character(1) VARCHAR2(1) NOT NULL Reconciliation Status
0=Not Reconciled
1=To be Reconciled
3=Exception
9=Reconciled
10 IN_PROCESS_FLG Character(1) VARCHAR2(1) NOT NULL In process flag
11 OVERDUE_FLG Character(1) VARCHAR2(1) NOT NULL Overdue Status
C=Current
O=Overdue

Y/N Table Edit

Default Value: N

12 OVERDUE_DEDUCT Character(1) VARCHAR2(1) NOT NULL Overdue Deduction
1=None
2=Adjustment Voucher
13 CLAIM_DT Date(10) DATE Claim Date
14 CLAIM_DUE_DT Date(10) DATE Claim Due Date
15 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple
16 VRBT_ID Character(25) VARCHAR2(25) NOT NULL Vendor Rebate ID

Prompt Table: VRBT_HDR

17 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
18 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

Prompt Table: VENDOR_PO_VW
Set Control Field: VENDOR_SETID

19 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
20 CB_CONTRACT_SETID Character(5) VARCHAR2(5) NOT NULL Claimback Contract Setid
21 CB_CONTRACT_ID Character(25) VARCHAR2(25) NOT NULL Claimback Contract ID
22 TOTAL_CLAIM_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Total Claim Amount
23 TOT_CLAIM_VAT Signed Number(28,3) DECIMAL(26,3) NOT NULL Total Claim VAT Amount
24 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Prompt Table: CURRENCY_CD_TBL

25 TOT_CLAIM_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Total Claim Amount Base
26 CURRENCY_CD_BASE Character(3) VARCHAR2(3) NOT NULL Business Unit Base Currency

Prompt Table: CURRENCY_CD_TBL

27 TOT_CLAIM_AMT_ORG Signed Number(28,3) DECIMAL(26,3) NOT NULL Original Total Claim Amount
28 TOT_CLAIM_COLLECT Signed Number(28,3) DECIMAL(26,3) NOT NULL Total Claim Collected
29 TOT_VAT_COLLECT Signed Number(28,3) DECIMAL(26,3) NOT NULL Total VAT Claim Collected
30 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
31 NOTIFY_REBATE_MGR Character(1) VARCHAR2(1) NOT NULL Notify Rebate Manager
32 REBATE_MGR Character(30) VARCHAR2(30) NOT NULL Rebate Manager

Prompt Table: PO_OPRDEFN_VW

33 NOTIFY_STLMENT_MGR Character(1) VARCHAR2(1) NOT NULL Notify Settlement Manager
34 SETTLEMENT_MGR Character(30) VARCHAR2(30) NOT NULL Settlement Manager

Prompt Table: PO_OPRDEFN_VW

35 CLAIM_ID_DEFER Character(15) VARCHAR2(15) NOT NULL Deferred To Claim ID