Converting Existing Ledgers - Order Processing - Database Changes

New items are required on both the order header and detail files. In addition it has to be assumed that all existing accounts and transactions are held in the base currency and these additional currency fields need to be updated from the existing (base currency) equivalent using the DataFiler Global Update procedures.

Order Header File

Item Name Type Description / Update From

FC-CODE X (3) Holds the currency code for the order. Update with the base currency.

FC-RATE M Holds the exchange rate for the order. Update with 1.0000

FC-FIXED ? Identifies whether the order was entered with a fixed exchange rate (i.e. excluded from revaluation).

FC-ORD-VAL L Holds the value of the order in the currency of the account.Update from ORDER-VALUE.

FC-INV-VAL L Holds the value of invoices against this order, exclusive of VAT, in the currency of the account. Update from INVOICE-VALUE.

FC-INV-INCVAT L Optional. Holds the value of invoices against this order inclusive of VAT. Update from INV-INC-VAT.

FC-ORIG-RATE M Optional. Holds the original rate of the order before revaluation. Update with 1.0000

Order Detail File

Item Name Type Description / Update From

FC-CODE X (3) Holds the currency code for the order. Update with the base currency.

FC-RATE M Holds the exchange rate for the order. Update with 1.0000

FC-PRICE L, M Holds the unit price of the stock item in the currency of the account.Update from existing PRICE field (SOP) or COST field (POP).

FC-ORD-VAL L Holds the value of the order in the currency of the account.Update from DETAIL-VALUE.

FC-INV-VAL L Holds the value of invoices against this order, exclusive of VAT, in the currency of the account. Update from INVOICE-VALUE.

FC-INV-INCVAT L Optional. Holds the value of invoices against this order inclusive of VAT. Update from INV-INC-VAT.

FC-ORIG-RATE M Optional. Holds the original rate of the order before revaluation. Update with 1.0000