Unit Of Measure Settings tab
These settings configure the database lookup parameters that are used for unit of measure conversion that may occur during line pairing.
- Database Connection Name
-
The database connection that specifies the database connection string for the unit of measure conversion table database.
This setting is available only when Validate From DB is selected above.
- DB Schema
-
Enter the name of a schema to filter the list of database tables available for the selected Database Connection Name.
If this field is left blank, all database tables that you have permission to access, are displayed.
-
This setting is available only when Validate From DB is selected above.
- DB Table Name
-
The name of the unit of measure conversion database table. This setting is mandatory for unit of measure conversion database lookups.
- Use PO Partition
-
If selected, the unit of measure conversion database lookup uses a purchase order partition. Purchase order partitions are set against the organization listed in .
This option is cleared by default.
- PO Partition Column
-
Enter the unit of measure database column name that holds the PO partition ID. The PO partition ID is set in PO Number Partition tab.
This setting is mandatory if the Use PO Partition setting is selected.
- DB Material No
-
The technical name of the column in the unit of measure conversion table that represents the item material number.
- DB Base UOM
-
The technical name of the column in the unit of measure conversion table that represents the material base unit of measure, such as the destination unit of measure.
- DB Numerator
-
The technical name of the column in the unit of measure conversion table that represents the numerator component of the unit of measure conversion ratio.
- DB Denominator
-
The technical name of the column in the unit of measure conversion table that represents the numerator component of the unit of measure conversion ratio.
- DB External UOM
-
The technical name of the column in the unit of measure conversion table that represents the external unit of measure read from the invoice where the conversion takes place.
The following buttons are available at the bottom of the window.
- Save
-
Saves your changes and the window is closed.
- Reload
-
Deletes any unsaved changes and resets the field values back to the last saved settings.