Three views are available to retrieve required data from invoices of Smart Materials.
-
MVW_ECO_IVC_LINE_ITEMS: Retrieves Invoice Line Items of all invoices. You can add or delete columns from this view. The columns POH_ID, POLI_ID, JS_CODE, IVC_ID must not be removed because the uniqueness of the data is checked based on these columns.
-
MVW_ECO_IVC_OTHER_COSTS: Retrieves Other Costs related to the invoices. You can add or delete columns from this view. The columns POH_ID, UOC_ID, JS_CODE, IVC_ID must not be removed because the uniqueness of the data is checked based on these columns.
-
MVW_ECO_IVC_ADD_COSTS: Retrieves data of additional invoice items related to the invoices. You can add or delete columns from this view. The columns POH_ID, IVCI_ID, JS_CODE, IVC_ID must not be removed because the uniqueness of the data is checked based on these columns.
-
It also retrieves Invoice header details that are created for Schedule of Values.
-