Ordloc Exp

This field contains the order number that the expense is attached to.

This field contains a sequence number which, when combined with the order number will make the row unique.

Unique alphanumeric value that identifies the item.

Alphanumeric value that uniquely identifies the pack.

This field contains the location that item will be ordered to. This field may contain a store or a warehouse.

This field contains the type of location in the location field. Valid values are: S - Store W - Warehouse

Contains a user specified code representing a specific expense found on the ELC_COMP table.

Contains a code representing the base value for calculating an expense.

Contains the basis the expense will be calculated against if there is no CVB code attached to the expense. Valid values are S (Supplier) or O (Order). If the Cost Basis is S then when calculating the expense, the items supplier cost will be used. If the Cost Basis is O then the order unit cost of the item on the order will be used to calculate the expense. The code type for this field is EXCB.

Contains the rate to be charged against the calculation base of the component (either value or specific).

Contains the currency the expense or assessment is to be entered in. If the Calculation Basis is V (Value), then comp_currency will be NULL.

Contains the exchange rate of the individual expense.

Contains a count indicating the amount of the Per Count Unit of Measure to which the rate applies. When creating an expense that is defined as $.20 for every 10 kilograms of an item ordered, the Per Count would be 10.

Contains the unit of measure in which the Per Count is specified. When creating an expense that is defined as $.20 for every 10 kilograms of an item ordered, the Per Count UOM would be the Unit of Measure code for Kilograms.

Contains the estimated value of the expense in the expenses component currency.

Contains a flag that is used to indicate the status of this particular nomination flag for a given expense. Nomination flags are used in the subsequent formation of Computation Value Bases (CVBs). Valid values are: N (N/A) (this expense will not be included in CVBs which look at User Defined Nomination Flag 1), Add (+) (this expense will be added to the CVBs which look at User Defined Nomination Flag 1), and Subtract (-) (this expense will be deducted from the CVBs which look at User Defined Nomination Flag 1). For example, if expense ABC has a + in Nomination Flag 1, then all CVBs (Computation Value Bases) that include Nomination Flag 1 will add this expense in their calculation basis.

See description for nom_flag_1. If ALC is turned on (i.e. system_options.import_ind = Y), nom_flag_2 is used to indicate the status of a component in duty calculation nom_flag_4 is used to indicate the status of a component in ELC calculation nom_flag_5 is used to indicate the status of a component in ALC calculation i.e. these 3 flags can not be used for any other purposes if ALC is turned on.

See description for nom_flag_1.

See description for nom_flag_1. If ALC is turned on (i.e. system_options.import_ind = Y), nom_flag_2 is used to indicate the status of a component in duty calculation nom_flag_4 is used to indicate the status of a component in ELC calculation nom_flag_5 is used to indicate the status of a component in ALC calculation i.e. these 3 flags can not be used for any other purposes if ALC is turned on.

See description for nom_flag_1. If ALC is turned on (i.e. system_options.import_ind = Y), nom_flag_2 is used to indicate the status of a component in duty calculation nom_flag_4 is used to indicate the status of a component in ELC calculation nom_flag_5 is used to indicate the status of a component in ALC calculation i.e. these 3 flags can not be used for any other purposes if ALC is turned on.

Indicates how any given expense record was inserted into the table. Valid values are (S)ystem generated, (M)anual input or (D)Deals.

Contains a numeric value that determines the display order of the expense or assessment when used in other modules.

This field specifies the source from which the expense is defaulted to the item. Valid values are, P - defaulted from a partner expense profile S - defaulted from a supplier expense profile C - defaulted from a country expense profile E - defaulted due to an always default expense D- defaulted from Allowance Deals M - manually added expenses I - defaulted from Invoice.

This will hold the supplier value or the origin country id or the partner type or the deal_id or the invoice document id, depending on the value of the defaulted_from column. If the defaulted_from is Invoice, then this column holds the DOC_ID from the IM_DOC_HEAD table.

When the expense is defaulted from a partner, this column will hold the value of the partner id.

Indicates the currency against which the exchange rate has been captured on the entity. Valid values are: P (Primary) or L (Local) currency.