CB_CLM_H_WBVW

(SQL View)
 Index Back

Claimback Claim Header VW

Claimback Claim Header view which eliminates those claims already assigned to a claims workbench.

SELECT SETID , CLAIM_ID , CLAIM_STATUS , CLAIM_TYPE , CLAIM_RECON_STAT , MESSAGE_NBR , OVERDUE_FLG , OVERDUE_DEDUCT , CLAIM_DT , CLAIM_DUE_DT , ACCOUNTING_DT , VRBT_ID , VENDOR_SETID , VENDOR_ID , VNDR_LOC , CUST_SETID , CUST_ID , CB_CONTRACT_SETID , CB_CONTRACT_ID , REMIT_FROM_SETID , REMIT_FROM_CUST_ID , TOTAL_CLAIM_AMT , CURRENCY_CD , TOT_CLAIM_AMT_BSE , CURRENCY_CD_BASE , TOT_CLAIM_AMT_ORG , TOT_CLAIM_COLLECT , TOT_VAT_COLLECT , RT_TYPE , RATE_DATE , RATE_DIV , RATE_MULT , TOL_AMT_OVER ,TOL_AMT_UNDER , TOL_PCT_OVER , TOL_PCT_UNDER , DESCR , PYMNT_TERMS_CD , PYMNT_TERMS_CD2 , SETTLEMENT_METHOD , NOTIFY_REBATE_MGR , REBATE_MGR , NOTIFY_CLMMGR_STAT , NOTIFY_STLMENT_MGR , SETTLEMENT_MGR , CLAIM_ID_DEFER , BUSINESS_UNIT_AP , BUSINESS_UNIT_AR , BUSINESS_UNIT_GL , TOT_CLAIM_VAT , TOT_CLAIM_VAT_BSE , VAT_ENTITY , PHYSICAL_NATURE , COUNTRY_VAT_PERFRM , STATE_VAT_PERFRM , VAT_NRCVR_CHRG_CD , VAT_NRCVR_PRO_FLG , VAT_NRCVR_ALL_FLG , VAT_DCLRTN_DT , VAT_RPT_CNTRY_SRC , COUNTRY_LOC_BUYER , COUNTRY_LOC_SELLER , STATE_LOC_BUYER , STATE_LOC_SELLER , COUNTRY_SHIP_FROM , COUNTRY_SHIP_TO , STATE_SHIP_FROM , STATE_SHIP_TO , VAT_SVC_SUPPLY_FLG , VAT_SERVICE_TYPE , COUNTRY_VAT_BILLFR , COUNTRY_VAT_BILLTO , STATE_VAT_DEFAULT , VAT_EXCPTN_TYPE , VAT_EXCPTN_CERTIF , VAT_RGSTRN_BUYER , VAT_RGSTRN_SELLER , VAT_DCLRTN_POINT , VAT_CALC_GROSS_NET , VAT_RECALC_FLG , VAT_ROUND_RULE , VAT_CALC_FRGHT_FLG , VAT_CALC_MISC_FLG , VAT_CALC_TYPE , COUNTRY_VAT_SUPPLY , VAT_TREATMENT_GRP , VAT_BASIS_AMT , VAT_BASIS_AMT_BASE , VAT_TRANS_AMT , VAT_TRANS_AMT_BSE , VAT_CALC_AMT , VAT_CALC_AMT_BSE , COMMENTS_LONG FROM PS_VRBT_CLAIM_HDR WHERE CLAIM_TYPE = 'C' AND NOT EXISTS ( SELECT 'X' FROM PS_VRBT_CLAIM_WBWD WHERE PS_VRBT_CLAIM_WBWD.SETID = PS_VRBT_CLAIM_HDR.SETID AND PS_VRBT_CLAIM_WBWD.CLAIM_ID = PS_VRBT_CLAIM_HDR.CLAIM_ID)

# 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

Prompt Table: VRBT_CLAIM_SRCH

3 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
4 CLAIM_TYPE Character(1) VARCHAR2(1) NOT NULL Claim Type
C=Claimbacks
R=Vendor Rebate
5 CLAIM_RECON_STAT Character(1) VARCHAR2(1) NOT NULL Reconciliation Status
0=Not Reconciled
1=To be Reconciled
3=Exception
9=Reconciled
6 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.
7 OVERDUE_FLG Character(1) VARCHAR2(1) NOT NULL Overdue Status
C=Current
O=Overdue

Y/N Table Edit

Default Value: N

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

Prompt Table: VRBT_HDR

13 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
14 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

Prompt Table: VENDOR_PO_VW
Set Control Field: VENDOR_SETID

15 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
16 CUST_SETID Character(5) VARCHAR2(5) NOT NULL Customer SetID

Default Value: VENDOR.SETID

Prompt Table: SETID_TBL

17 CUST_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.

Prompt Table: CUSTOMER_FS

18 CB_CONTRACT_SETID Character(5) VARCHAR2(5) NOT NULL Claimback Contract Setid

Prompt Table: CB_SETID_VW

19 CB_CONTRACT_ID Character(25) VARCHAR2(25) NOT NULL Claimback Contract ID

Prompt Table: CB_CON_VW

20 REMIT_FROM_SETID Character(5) VARCHAR2(5) NOT NULL SetID

Prompt Table: SP_SETID_NONVW

21 REMIT_FROM_CUST_ID Character(15) VARCHAR2(15) NOT NULL Remit From Customer

Prompt Table: CUST_REM_A1S_VW

22 TOTAL_CLAIM_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Total Claim Amount
23 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Prompt Table: CURRENCY_CD_TBL

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

Prompt Table: CURRENCY_CD_TBL

26 TOT_CLAIM_AMT_ORG Signed Number(28,3) DECIMAL(26,3) NOT NULL Original Total Claim Amount
27 TOT_CLAIM_COLLECT Signed Number(28,3) DECIMAL(26,3) NOT NULL Total Claim Collected
28 TOT_VAT_COLLECT Signed Number(28,3) DECIMAL(26,3) NOT NULL Total VAT Claim Collected
29 RT_TYPE Character(5) VARCHAR2(5) NOT NULL Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.

Prompt Table: RT_TYPE_TBL

30 RATE_DATE Date(10) DATE Exchange Rate Date
31 RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL Rate Divisor

Default Value: 1

32 RATE_MULT Signed Number(17,8) DECIMAL(15,8) NOT NULL Rate Multiplier

Default Value: 1

33 TOL_AMT_OVER Signed Number(28,3) DECIMAL(26,3) NOT NULL Over Tolerance Amount
34 TOL_AMT_UNDER Signed Number(28,3) DECIMAL(26,3) NOT NULL Under Tolerance Amount
35 TOL_PCT_OVER Number(6,2) DECIMAL(5,2) NOT NULL Over Tolerance Percent
36 TOL_PCT_UNDER Number(6,2) DECIMAL(5,2) NOT NULL Under Tolerance Percent
37 DESCR Character(30) VARCHAR2(30) NOT NULL Description
38 PYMNT_TERMS_CD Character(5) VARCHAR2(5) NOT NULL Specifies how the payment due date and discount due date are calculated. A payment terms code is associated with various business units bill-to customers vendors as well as sales orders purchase orders and vouchers.

Prompt Table: AR_TRMS_VW

39 PYMNT_TERMS_CD2 Character(5) VARCHAR2(5) NOT NULL Settlement Terms Code used in Vendor Rebate Agreement (For AR)

Prompt Table: PYMT_TRMS_VW

40 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
41 NOTIFY_REBATE_MGR Character(1) VARCHAR2(1) NOT NULL Notify Rebate Manager

Y/N Table Edit

42 REBATE_MGR Character(30) VARCHAR2(30) NOT NULL Rebate Manager

Prompt Table: PO_OPRDEFN_VW

43 NOTIFY_CLMMGR_STAT Character(1) VARCHAR2(1) NOT NULL Notify Claims Manager Status
N=No Notification
P=Pending Notification
Y=Notified
44 NOTIFY_STLMENT_MGR Character(1) VARCHAR2(1) NOT NULL Notify Settlement Manager
45 SETTLEMENT_MGR Character(30) VARCHAR2(30) NOT NULL Settlement Manager

Prompt Table: PO_OPRDEFN_VW

46 CLAIM_ID_DEFER Character(15) VARCHAR2(15) NOT NULL Deferred To Claim ID
47 BUSINESS_UNIT_AP Character(5) VARCHAR2(5) NOT NULL AP Business Unit
48 BUSINESS_UNIT_AR Character(5) VARCHAR2(5) NOT NULL AR Business Unit
49 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit
50 TOT_CLAIM_VAT Signed Number(28,3) DECIMAL(26,3) NOT NULL Total Claim VAT Amount
51 TOT_CLAIM_VAT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Total Claim VAT Base Amount
52 VAT_ENTITY Character(20) VARCHAR2(20) NOT NULL Specifies an organizational entity that is responsible for VAT reporting and that is registered in one or more countries that require VAT reporting. A single VAT entity is linked to one or more General Ledger Business Units depending on the reporting requirements.
53 PHYSICAL_NATURE Character(1) VARCHAR2(1) NOT NULL Physical Nature
G=Goods
S=Services
54 COUNTRY_VAT_PERFRM Character(3) VARCHAR2(3) NOT NULL Country Where Service Physically Performed
55 STATE_VAT_PERFRM Character(6) VARCHAR2(6) NOT NULL State Where Service Physically Performed
56 VAT_NRCVR_CHRG_CD Character(10) VARCHAR2(10) NOT NULL ProrateVAT Non-Recovery
57 VAT_NRCVR_PRO_FLG Character(1) VARCHAR2(1) NOT NULL Prorate Non-Recoverable VAT
58 VAT_NRCVR_ALL_FLG Character(1) VARCHAR2(1) NOT NULL Allocate Non-Recoverable VAT
59 VAT_DCLRTN_DT Date(10) DATE "Specifies the date of the invoice when the VAT declaration point (VAT_DCLRTN_POINT) is ""Invoice"". The VAT declaration date is automatically set to the invoice date by the system. This field does not apply when the declaration point is ""payment"". "
60 VAT_RPT_CNTRY_SRC Character(1) VARCHAR2(1) NOT NULL VAT Reporting Country Source
1=Ship From
2=Ship To
3=VAT Entity
4=Service Performed Country
5=Supplier Location Country
6=Buyer Location Country
7=Buyer VAT Registration Country
61 COUNTRY_LOC_BUYER Character(3) VARCHAR2(3) NOT NULL Buyer's Location Country - May be either the VAT Entity or the Trading Partner
62 COUNTRY_LOC_SELLER Character(3) VARCHAR2(3) NOT NULL Seller's Location Country - May be either the VAT Entity or the Trading Partner
63 STATE_LOC_BUYER Character(6) VARCHAR2(6) NOT NULL Buyer's Location State - May be either the VAT Entity or the Trading Partner
64 STATE_LOC_SELLER Character(6) VARCHAR2(6) NOT NULL Seller's Location State - May be either the VAT Entity or the Trading Partner
65 COUNTRY_SHIP_FROM Character(3) VARCHAR2(3) NOT NULL Specifies the country from which the invoice contents were shipped (for VAT processing only).
66 COUNTRY_SHIP_TO Character(3) VARCHAR2(3) NOT NULL Specifies the country to which the invoice contents were shipped (for VAT processing only).
67 STATE_SHIP_FROM Character(6) VARCHAR2(6) NOT NULL Ship From State
68 STATE_SHIP_TO Character(6) VARCHAR2(6) NOT NULL Ship To State
69 VAT_SVC_SUPPLY_FLG Character(1) VARCHAR2(1) NOT NULL VAT Services Place of Supply Flag
1=Supplier's Countries
2=Buyer's Countries
3=Where Physically Performed
70 VAT_SERVICE_TYPE Character(1) VARCHAR2(1) NOT NULL VAT Service Type
1=Freight Transport
2=Other
3=Electronics/Communication
71 COUNTRY_VAT_BILLFR Character(3) VARCHAR2(3) NOT NULL Specifies the country where an invoice is generated (for VAT processing only).
72 COUNTRY_VAT_BILLTO Character(3) VARCHAR2(3) NOT NULL Specifies the country where an invoice is sent (for VAT processing only).
73 STATE_VAT_DEFAULT Character(6) VARCHAR2(6) NOT NULL VAT Defaulting State
74 VAT_EXCPTN_TYPE Character(1) VARCHAR2(1) NOT NULL A flag that specifies the reason for a VAT exemption for a customer. Suspension (S) and Exoneration (X) are examples of Exception Type.
N=None
S=Suspended
X=Exonerated
75 VAT_EXCPTN_CERTIF Character(20) VARCHAR2(20) NOT NULL Specifies the VAT exception certificate number. This identifier serves as proof of customer's exemption from VAT.
76 VAT_RGSTRN_BUYER Character(20) VARCHAR2(20) NOT NULL Specifies a customers VAT Registration ID for a particular country.
77 VAT_RGSTRN_SELLER Character(20) VARCHAR2(20) NOT NULL Seller's VAT Registration
78 VAT_DCLRTN_POINT Character(1) VARCHAR2(1) NOT NULL A flag that specifies when VAT information for sales or purchase transaction is recognized for reporting to the appropriate VAT authority. VAT is declared at invoice time, delivery time, accounting date or the time of payment.
A=At Accounting Date
D=At Delivery Time
I=At Invoice Time
P=At Payment Time
79 VAT_CALC_GROSS_NET Character(1) VARCHAR2(1) NOT NULL A flag that indicates whether VAT calculation should be done on the Gross (G) amount or on the Net (N) amount of sales or purchase transaction. When calculating VAT at net the early payment discount is applied to the goods amount before calculating the VAT. When calculating VAT at gross the VAT is initially calculated based on the gross transaction amount.
G=Calculate at Gross
N=Calculate at Net
80 VAT_RECALC_FLG Character(1) VARCHAR2(1) NOT NULL A flag that indicates whether or not the VAT discount amount is recalculated at payment time. This field is only used if the VAT Calculation Type (VAT_CAL_GROSS_NET) is gross.
81 VAT_ROUND_RULE Character(1) VARCHAR2(1) NOT NULL " Rounding rule to be applied to VAT calculations. Options are 'Natural'
D=Round Down
N=Natural Round
U=Round Up
82 VAT_CALC_FRGHT_FLG Character(1) VARCHAR2(1) NOT NULL Include Freight
83 VAT_CALC_MISC_FLG Character(1) VARCHAR2(1) NOT NULL Include Miscellaneous
84 VAT_CALC_TYPE Character(1) VARCHAR2(1) NOT NULL "A flag that indicates how VAT is stated and determines how the system performs the relevant VAT calculations. If ""Exclusive"", the VAT amount is stated separately from the merchandise amount. If ""Inclusive"", the VAT is not stated separately but is included with the merchandise amount."
E=Exclusive
I=Inclusive
85 COUNTRY_VAT_SUPPLY Character(3) VARCHAR2(3) NOT NULL VAT Place of Supply Country
86 VAT_TREATMENT_GRP Character(4) VARCHAR2(4) NOT NULL VAT Treatment Group
87 VAT_BASIS_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Specifies the amount on a sale (receivables item) or purchase (Payables voucher) transaction that is subject to VAT taxation. Depending on other parameters this amount may represent the gross or net amount of the transaction and may or may not include freight charges.
88 VAT_BASIS_AMT_BASE Signed Number(28,3) DECIMAL(26,3) NOT NULL Specifies the amount on a sale (receivables item) or purchase (Payables voucher) transaction that is subject to VAT taxation. It is specified in the base currency of the General Ledger business unit associated with the transaction. Refer to the definition of VAT_BASIS_AMT.
89 VAT_TRANS_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Represents the sale or purchase amount against which the VAT is applicable.
90 VAT_TRANS_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Represents the sale or purchase amount in base currency against which the VAT is applicable
91 VAT_CALC_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Calculated Amount
92 VAT_CALC_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Calculated Amount Base Cur
93 COMMENTS_LONG Long Character CLOB Comment Text