...

Le lien suivant contient plus d'informations quant au périmètre de données de ce domaine: D_SALES_LIST_SALES_V1_0.pdf

Sample queries:

1. Query to fetch all operations of a given order ID

     select T_OPERATION_ID,ORDER_QUANTITY, ITEM, TOTAL_UNIT_AMT_ITX from D_SALES_LIST_SALES_V1_0 where ORDER_NUMBER= '1234';

    

2. Query to find the current state of content of sales / reservations of items in given file ID:

     select  ITEM, OPERATION_TYPE, SUM(CURRENT_QUANTITY), SUM(UNIT_AMT_ITX * CURRENT_QUANTITY) as Total_Amount from D_SALES_LIST_SALES_V1_0 where FILE_NUMBER= '1234'  AND T_OPERATION_TYPE IN ('RESERVATION','SALE') GROUP BY T_ITEM_ID, ITEM, T_OPERATION_TYPE ,OPERATION_TYPE;

Domaine - Listes des ventes et règlements associés

...