Aurelie Mazerot
Process Expert
Miriam Luttrin
General Description
List of customers with customer codes indicating their payment behaviors (Notes) according to each Legal Entity. Payment behaviors can be referred under indicator "Payment Behaviors". The result extracted is for M-1 (previous month) based on rolling 6 months' data.
A shortcut search available on the top of the table facilitates the search of a specific customer by name or code:


 Indicator details results can be analyzed by :
PRS Code
PRS Customer Label
ERP Customer Code

 

  Refresh Frequency:
Monthly (1st Sunday of the month)

 

KPI Name
Calculation
Rating
Payment Period
Early Payment
At the due date
Late 1 - 4
Late 5 - 10
Late 11 - 30
Late > 30
Source Information:
Core Query:
BW_QRY_MVFIAR01_0010
QV Query:
QVSBS_BW_QRY_MVFIAR01_0010
BW Filters
 Company Code <> ZUS4
GL Acct Sub Type = PRODUCT AND SERVICE
GL Acct Type = RECEIVABLES
PRS Comp. Interco Flag = YES
PRS Comp. Merging Date = # 
PRS Cust. Interco Flag = No
ERP GBU <> Eco Service
Control  Credit Area = "SOLV"
Specific Dimensions
Customer Country
Country of the PRS Customer
Customer Group
Customer Group of the PRS Customer
Credit. Mgr.