Import effective dates for customer prices at item level

In M3, it is possible to specify effective dates for sales/customer price lists at header level and line level (that is item level). However, SCV PRICE_LIST* entities, previously supported effective date only at header level. Effective date is now added to price list lines in SCV.

This staging table is updated to add new column VFDT:

• ST_M3_IN_OIS017MI_LstBasePrice

This view is updated to map VFDT to line_effective_date:

• ST_V_M3_PRICE_LIST_LINE

This mapping is updated to change mapping source of effective_from_date to line_effective_from_date:

• BASE_ST_V_M3_PRICE_LIST_LINE-SI_PRICE_LIST_LINE

These constraints are updated to include line_effective_from_date:

• BASE_SI_PRICE_LIST_LINE_BK
• BASE_SI_PRICE_LIST_LINE_PK

The PRICE_LIST_LINE_BREAK child entity and all related configuration (such as constraints, mappings, and datasheets) is updated to include the same new column line_effective_from_date.

This feature is enabled after appending the base for m3 template (base for m3.zip) for this version. No additional role or privilege is required to access this feature.