JDBC Driver for Oracle SCM

Build 22.0.8462

PackagingStrings

The Packaging Strings resource manages the packaging strings that are associated with one or more items for use during transactions.

Columns

Name Type Description
PackagingStringId [KEY] String The value that uniquely identifies the packaging string. It is a primary key that the application generates when it creates a packaging string.
PackagingString String The packaging string. It is a unique value created with the UOM elements and multipliers. The setting of the SCM Common: Display Order of Packaging String Units profile option determines if the string reads as ascending or descending.
UOMCode1 String The unique code of the first unit in the packaging string. This is always the base unit; for example, in the string EA 10/BX 25/CS, the first unit code is EA.
UOMName1 String The name of the first unit in the packaging string. This is always the base unit; for example, in the string EA 10/BX 25/CS, the first unit name is Each.
UOMCode2 String The unique code of the second unit in the packaging string. This is a multiple of the base unit; for example, in the string EA 10/BX 25/CS, the second unit code is BX. It is a multiple of EA.
UOMName2 String The name of the second unit in the packaging string. This is a multiple of the base unit; for example, in the string EA 10/BX 25/CS, the second unit name is Box.
UOMMultiplier2 String The value used as the multiplier between the base unit and the second unit. This attribute indicates how many base units are in the second unit; for example, in the string EA 10/BX 25/CS, the value of UOMMultiplier2 is 10. This means, there are 10 Each to a Box.
UOMCode3 String The unique code of the third unit in the packaging string. This is a multiple of the second unit; for example, in the string EA 10/BX 25/CS, the third unit code is CS. It is a multiple of BX.
UOMName3 String The name of the third unit in the packaging string. This is a multiple of the second unit; for example, in the string EA 10/BX 25/CS, the third unit name is Case.
UOMMultiplier3 String The value used as the multiplier between second unit and the third unit. This attribute indicates how many second units are in the third unit; for example, in the string EA 10/BX 25/CS, the value of UOMMultiplier3 is 25. It is a multiple of BX, or Box. This means, there are 25 Boxes to a Case.
UOMCode4 String The unique code of the fourth unit in the packaging string. This is a multiple of the third unit.
UOMName4 String The name of the fourth unit in the packaging string. This is a multiple of the third unit.
UOMMultiplier4 String The value used as the multiplier between the third unit and the fourth unit. This attribute indicates how many third units are in the fourth unit.
UOMCode5 String The unique code of the fifth unit in the packaging string. This is a multiple of the fourth unit.
UOMName5 String The name of the fifth unit in the packaging string. This is a multiple of the fourth unit.
UOMMultiplier5 String The value used as the multiplier between the fourth unit and the fifth unit. This attribute indicates how many fourth units are in the fifth unit.
UOMCode6 String The unique code of the sixth unit in the packaging string. This is a multiple of the fifth unit.
UOMName6 String The name of the sixth unit in the packaging string. This is a multiple of the fifth unit.
UOMMultiplier6 String The value used as the multiplier between the fifth unit and the sixth unit. This attribute indicates how many fifth units are in the sixth unit.
UOMCode7 String The unique code of the seventh unit in the packaging string. This is a multiple of the sixth unit.
UOMName7 String The name of the seventh unit in the packaging string. This is a multiple of the sixth unit.
UOMMultiplier7 String The value used as the multiplier between the sixth unit and the seventh unit. This attribute indicates how many sixth units are in the seventh unit.
UOMCode8 String The unique code of the eighth unit in the packaging string. This is a multiple of the seventh unit.
UOMName8 String The name of the eighth unit in the packaging string. This is a multiple of the seventh unit.
UOMMultiplier8 String The value used as the multiplier between the seventh unit and the eighth unit. This attribute indicates how many seventh units are in the eighth unit.
UOMCode9 String The unique code of the ninth unit in the packaging string. This is a multiple of the eighth unit.
UOMName9 String The name of the ninth unit in the packaging string. This is a multiple of the eighth unit.
UOMMultiplier9 String The value used as the multiplier between the eighth unit and the ninth unit. This attribute indicates how many eighth units are in the ninth unit.
UOMCode10 String The unique code of the tenth unit in the packaging string. This is a multiple of the ninth unit.
UOMName10 String The name of the tenth unit in the packaging string. This is a multiple of the ninth unit.
UOMMultiplier10 String The value used as the multiplier between the ninth unit and the tenth unit. This attribute indicates how many ninth units are in the tenth unit.
CreatedBy String CreatedBy of PackagingStrings
CreationDate Datetime CreationDate of PackagingStrings
LastUpdateDate Datetime LastUpdateDate of PackagingStrings
LastUpdatedBy String LastUpdatedBy of PackagingStrings

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462