Quote
The corporate trade report is a report which give an high level of details with a lot of information for all billing done by Solvay.
Data flow
The data flow is based on the LSA method. The data visualization is done on the Composite Provider CPSDAE01(SD: Quote) .
Global Sales data layers:
- Propagation Layer
- PC_SD_AE_01Business Layer
- Reporting Layer
- Virtual Layer
Please see the data flow of the Composite Provider CPSDAE01(SD: Quote) generated from Performer Suite.
Propagation layer
The propagation Layer is same than the billing propagation layer of Global sales.
Business layer
List of DSOs used in the business layer:
| DSO tech. name | DSO description | source DSO tech. name | source DSO description |
|---|---|---|---|
| DBSDSO9J | Global sales: Corporate trade (Rhodia) | DBSDSO46 | SO Global: Invoices (Rhodia) |
| DBSDSO67 | PO: Transfers orders Invoices (Rhodia) | ||
| DPSDSO48 | Billing Condition Data (Rhodia) | ||
| DBSDSO9I | Global sales: Corporate trade (Solvay) | DBSDSO06 | SO Global: Invoices (Solvay) |
| DBSDSO27 | PO: Transfers orders Invoices (Solvay) | ||
| DPSDSO08 | Billing Condition Data (Solvay) |
Reporting layer
The reporting layer is the same than the business layer.
Virtual layer
List of infoproviders in the virtual layer:
MP tech. name | MP description | source CUBE tech. name | source CUBE description |
|---|---|---|---|
MVSDSO53 | MP: Corporate trade (Global Sales) | DBSDSO9J DBSDSO9I | Global sales: Corporate trade (Rhodia) Global sales: Corporate trade (Solvay) |
Data update
The data update is done every working day.
Process chain
PC_SD_AE_01, Daily(Not on Sundays or Public Holidays(Calendar ID:14)).
Reporting
Core queries
The core queries are based on the Composite Provider CPSDAE01:
Workbook | Query | ||
|---|---|---|---|
| Quote report | BW_WBK_CPSDAE01_SD001 | BW: Corporate trade by billing date (Core) | BW_QRY_CPSDAE01_SD001 |