Description
Conversion factor between two UoMs
Parameters
| icDomain | character | |
| icItemId | character | |
| icFromUoMId | character | |
| icToUoMId | character | |
query condition
each um_mstr where
um_mstr.um_domain = icDomain AND
um_mstr.um_part = icItemId AND
um_mstr.um_alt_um = icFromUoMId AND
um_mstr.um_um = icToUoMId
query resultset tqUoMConvByItemFromTo
| field name | data type | db field | description |
|---|
| tcum_alt_um | character | um_mstr.um_alt_um | Alternate UM |
| tdum_conv | decimal | um_mstr.um_conv | UM Conversion |
| tcum_domain | character | um_mstr.um_domain | Domain |
| tcum_part | character | um_mstr.um_part | Item Number |
| tcum_um | character | um_mstr.um_um | Unit of Measure |
| ti_sequence | integer | calculated | primary index |
| tc_rowid | character | calculated | = rowid(um_mstr) |
Internal usage
QadFinancials