Pro Forma Table Viewer


ProForma Tables are used by the system to automatically convert US weights, measures and currency into those used in the Client Site's country.


For conversion to Canadian units, a conversion from gallons to liters and pounds to kilograms would be specified.


Referenced in the Client Site record and during ProForma Client Order Processing.

Important Fields: Upper Section

Note: this Help Topic lists the standard configuration of all fields that may be included in this record. If you are using a customized system, the fields displayed on your screen may not exactly match the order or status (required, optional, default, display-only, hidden, etc.) of the fields described in this Topic.

This screen is divided into two sections. The upper section of the screen consists of the data-entry fields that identify this table and the currency conversion information.

ProForma Table Id: (10 character, only - and . special characters)
A unique Id (e.g., England, Canada, etc.). This field is required.

Repack Table Name: (20 character)
A brief description of this Table.

Security Id:
If multiple location security is implemented on your centralized database system, this informational field displays the Security Id of the local user that created this record. If multiple location security is not implemented on your system, or if this record was created by a global user, this field will be blank.

Currency Symbol (2 character)
The currency symbol to be used in the commercial invoice.

Currency Conversion Factor
The conversion from the base currency to the client's currency. For example, if your base currency is U.S. Dollars, and this is a ProForma table for Canada, a typical conversion factor might be 1.45. Be sure to update this field frequently to account for international market conditions.

Advice Lines(60 character x 6)
Comments on the use of this table.

Important Fields: Lower Section

The Base Unit of Measure exactly as listed in the Inventory Item record (e.g., ga, lb, etc.).

The Converted Unit of Measure as it should appear on the commercial invoice sent to the client (e.g., Ltr, Kg, etc.).

The conversion factor required to go from the Base to the Converted Unit of measure. For example, if the BUOM is ga (gallons) and the CUOM is Ltr (liters), the Factor would be entered as 3.7853.