Staging tables are available which hold the data that is to be posted from Smart Materials to EcoSys.
M_ECO_REQ_HEADER_STAGINGS: This table holds the data related to Requisition Headers loaded using the view MVW_ECO_REQ_HEADERS. Any additional column added in the view MVW_ECO_REQ_HEADERS will be added as additional column to the staging table.
M_ECO_REQ_LI_STAGINGS: This table holds the data related to Requisition Line Items loaded using the view MVW_ECO_REQ_ LINE_ITEMS. Any additional column added in the view MVW_ECO_REQ_ LINE_ITEMS will be added as additional column to the staging table.