Domaine - Lien entre opérations et paiements

...

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

     select T_OPERATION_ID,T_OPERATION_TYPE,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 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;

...

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

Sample queries:

...

Domaine - Recettes de frais

...