MiscellaneousFee

Entity Definition

Logical Name : MiscellaneousFee
Physical Name : TR_FE_MSC

A fee paid by the CUSTOMER for a service, normally associated with the purchase of a STOCK ITEM. An example would be delivery charge, gift wrapping service, etc.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
ItemID (FK)(PK) A unique system assigned identifier for the retailer's SKU. ID_ITM IdentityUUID char(32)
FinancialLedgerAccountID (FK) The reference for the FinancialLedgeraAccount ID_ACNT_LDG Identity integer FinancialLedgerAccount(CO_LE_ACNT_FN)
CustomerPaysForDispositionFlag Flag that determines whether the customer is charged for this misc. fee or the store absorbs it as an expense. FL_DPSN_CT_PY_FR Code4 char(4)

Relationships

Parent Entity Verb Phrase Child Entity
FinancialLedgerAccount defines accounting disposition of MiscellaneousFee
MiscellaneousFee defines CustomerOrderCharge
MiscellaneousFee is ordered via CustomerOrderChargeLineItem
MiscellaneousFee validates MiscellaneousFeeLineItem
ServiceItem can be a MiscellaneousFee

Logical Views containing MiscellaneousFee

Logical View
Logical 01000 - Item Description - Macro View
Logical 01004 - Item Description - Branding
Logical 01010 - Item Description - Subtype View
Logical 02315 - Retail Transaction - Customer Order
Logical 02316 - Distributed Order Management View
Logical 04100 - Financial Ledger - Retail Transaction View
Logical 07600 - Customer Order - Macro View
Logical 07610 - Customer Order - Maintenance View
Logical 07620 - Customer Order - Inventory Control View