Sizing Impacts on the F0086 Table

Before you run the base currency conversion, you specify whether you want to create an audit record in the F0086 table for a particular table conversion. At a minimum, the conversion creates one record for each record converted.

Important: The ZJDE model plan that you copy and use as the basis for the plan was specifically designed to create audit records for each table converted. Although creating audit records is recommended, you should be aware that doing so can impact processing time greatly and requires additional disk space.

Eight to and from amount fields are in the F0086 table. If the amount fields on a record exceed that number, the conversion creates additional audit records. For example, the F0902 record has 22 amount fields. This means the conversion program creates three F0086 records for each F0902 record that it converts.

The conversion programs create multiple F0086 records, as indicated in this table:

Financial Management	Sales Order Management	Procurement
F03B11: 2 records	F4211: 2 records	F4311: 3 records
F03B14: 2 records	S.O. Detail Ledger File table (F42199): 6 records	F43121: 2 records
F0411: 2 records	Sales Commission File table (F42005): 4 records	EDI Purchase Order Detail - Outbound table (F47017): 3 records
F0902: 3 records	Sales Order History File table (F42119): 2 records	EDI Purchase Order Acknowledgement Detail - Inbound table (F47022): 3 records
Asset Master File table (F1201): 2 records	Sales Summary History File table (F4229): 5 records	EDI Shipping Notice Detail - Inbound table (F47032): 3 records
Asset Account Balances File table (F1202): 3 records	EDI Shipping Notice Detail - Outbound table (F47037): 2 records	EDI Invoice Detail - Inbound table (F47042): 3 records
N/A	EDI Invoice Additional Header - Outbound table (F470461): 3 records	EDI Receiving Advice Detail - Inbound table (F47072): 3 records
N/A	EDI Response to RFQ Detail - Outbound table (F47107): 2 records	EDI Receiving Advice Detail - Outbound table (F47077): 3 records
N/A	EDI Response to RFQ Additional Header - Outbound table (F471061): 2 records	EDI Purchase Order Change Detail - Outbound table (F47137): 3 records
N/A	EDI Purchase Order Change Detail - Inbound table (F47132): 2 records	Purchase Order Detail Ledger File - Flexible Version table (F43199): 3 records
N/A	EDI Change Acknowledgement Detail - Outbound table (F47147): 2 records	EDI Purchase Order Change Acknowledgement Detail - Inbound table (F47142): 3 records
N/A	N/A	EDI Request for Quote Detail - Outbound table (F47097): 3 records
N/A	N/A	EDI Response to RFQ Detail - Inbound table (F47102): 3 records

To calculate the sizing impact on the F0086 table, use this formula: (Sizing impact on F0086 table) = (number of records to be converted for a particular table) Ã [(F0086 table size) Ã (number of F0086 records written per converted record)]