Data elemets required for food cost import

#Data elements needed in PMIDescriptionMandatory / optionalComment
1DateThe date on which the goods are expected to be delivered (good receipt at customer siteMPreferably date format yyyy-MM-dd hh:mm:ss
2PropertyIDA unique ID identifying a hotel within a chainM
3Property nameName of the hotelO
4DepartmentIDA unique ID identifying a Kitchen within at a hotel M
5Department nameName of the hotel, e.g. KitchenO
6AccountAccount number (part of a chart of accounts)M
7Account descriptionShort or long description of the accountO
8Product category IDUniquely referring to a given breakdown of discrete groups of similar or related productsO
9Product category nameName of a categoryO
10Order amountA lump sum amount (excl. VAT) reflecting the total value of a given delivery. MOnly where Status = 3
11Order confirmation A lump sum amount (excl. VAT) reflecting the total value of a given delivery. This amount can include credit note amounts relating to previous invoicesMNot itemized. 
12e-InvoiceA lump sum amount (excl. VAT) reflecting the total value of a given delivery. This amount can include credit note amounts relating to previous invoicesMAggregated sum

Was this article helpful?

Related Articles