Exp Prof Head

Contains the unique sequence number that is used to distinguish between the different profiles.

Contains the type of Profile. Valid values are Z (Zone), or C (Country). Zone profiles consist of expenses that are incurred from the movement of goods between a particular discharge port to a zone within the discharge ports country. Country profiles consist of the expense incurred when moving goods from a particular origin country/lading port to a given discharge port. The code type for this field is EXPT.

This field holds the code for the module that the Landed Cost Profile is associated with. Valid values are SUPP (Supplier), PTNR (Partner), and CTRY (Country).

This field will hold the specific id that the profile is attached to, e.g. for Supplier the key_value_1 would be the supplier identification number. However if the module is Partner then this field will hold the Partner Type (e.g. Bank, Freight Forwarder, Importer, etc).

This field will contain the specific id that the profile is attached to if key_value_1 is being used to hold a type, i.e. if the module is Partner then this field will hold the Partner Identification number.

This field contains the zone group ID for which the profile belongs to. This field will only have a value if the Profile Type is Zone.

Contains the zone identification number which uniquely identifies the zone. If the level of the zone group is store, then the zone will be the store number. This field will only contain a value if the Profile Type is Zone.

Contains the code of the origin country the Landed Cost Country Profile is associated with. This field will only contain a value if the Profile Type is Country.

Contains the identification of the Landed Cost Country Profiles lading port. This field will only contain a value if the Profile Type is Country.

Contains the identification of the Landed Cost Profiles discharge port.

Indicates whether or not the unit cost for the Expense Profile is also the base profile. Valid values are Y or N. For any given Supplier or Partner there can only be one base profile for each type, Zone and Country. For any given Country there can only be only base profile of type Country.

This field specifies how the item update will be cascaded for the expense profile. Valid values are based on the codes from code_detail where code_type = EPPM.