1. Tables and Views for SCM
  2. RCS_PACKAGING_STRINGS

RCS_PACKAGING_STRINGS

This table contains the packaging strings which have been created and associated to one or more items. A packaging string shows the hierarchy of units which represent how an item is packaged when shipped and/or used by an enterprise. For example, the string "EA 10/BX 25/CS 40/PLT" would mean 10 each in a box, 25 boxes in a case, 40 cases in a pallet. It is possible for one or more items to share the same packaging string

Details

  • Schema: FUSION

  • Object owner: RCS

  • Object type: TABLE

  • Tablespace: FUSION_TS_TX_DATA

Primary Key

Name Columns

RCS_PACKAGING_STRINGS_PK

PACKAGING_STRING_ID

Columns

Name Datatype Length Precision Not-null Comments
PACKAGING_STRING_ID NUMBER 18 Yes Unique identifier of the Packaging String.
PS_ASCENDING VARCHAR2 100 Yes The left to right representation of the packaging string using the code. An example is "EA 10/BX 25/CS 40/PLT". The ascending representation of the packaging string is also an alternate key for the row.
PS_DESCENDING VARCHAR2 100 Yes The right to left representation of the packaging string using the code. An example is "PLT/40 CS/25 BX/10 EA".
PS_BASE_NAME_ASCENDING VARCHAR2 1000 The left to right representation of the packaging string using the base language name of the UOM. An example is "Each 10/Box 25/Case 40/Pallet".
PS_BASE_NAME_DESCENDING VARCHAR2 1000 The right to left representation of the packaging string using the base language name of the UOM. An example is "Pallet/40 Case/25 Box/10 Each".
UOM_ELEMENT_1 VARCHAR2 3 The first unit in the packaging string. This is always the base unit.
UOM_ELEMENT_2 VARCHAR2 3 The second unit in the packaging string. This is a multiple of the base unit.
UOM_MULTIPLIER_2 NUMBER 18 The multiplier between the base unit and the second unit. Indicates how many of the base unit are in the second unit.
UOM_ELEMENT_3 VARCHAR2 3 The third unit in the packaging string. This is a multiple of the second unit.
UOM_MULTIPLIER_3 NUMBER 18 The multiplier between the second unit and the third unit. Indicates how many of the second unit are in the third unit.
UOM_ELEMENT_4 VARCHAR2 3 The fourth unit in the packaging string. This is a multiple of the third unit.
UOM_MULTIPLIER_4 NUMBER 18 The multiplier between the third unit and the fourth unit. Indicates how many of the third unit are in the fourth unit.
UOM_ELEMENT_5 VARCHAR2 3 The fifth unit in the packaging string. This is a multiple of the fourth unit.
UOM_MULTIPLIER_5 NUMBER 18 The multiplier between the fourth unit and the fifth unit. Indicates how many of the fourth unit are in the fifth unit.
UOM_ELEMENT_6 VARCHAR2 3 The sixth unit in the packaging string. This is a multiple of the fifth unit.
UOM_MULTIPLIER_6 NUMBER 18 The multiplier between the fifth unit and the sixth unit. Indicates how many of the fifth unit are in the sixth unit.
UOM_ELEMENT_7 VARCHAR2 3 The seventh unit in the packaging string. This is a multiple of the sixth unit.
UOM_MULTIPLIER_7 NUMBER 18 The multiplier between the sixth unit and the seventh unit. Indicates how many of the sixth unit are in the seventh unit.
UOM_ELEMENT_8 VARCHAR2 3 The eighth unit in the packaging string. This is a multiple of the seventh unit.
UOM_MULTIPLIER_8 NUMBER 18 The multiplier between the seventh unit and the eighth unit. Indicates how many of the seventh unit are in the eighth unit.
UOM_ELEMENT_9 VARCHAR2 3 The ninth unit in the packaging string. This is a multiple of the eighth unit.
UOM_MULTIPLIER_9 NUMBER 18 The multiplier between the eighth unit and the ninth unit. Indicates how many of the eighth unit are in the ninth unit.
UOM_ELEMENT_10 VARCHAR2 3 The tenth unit in the packaging string. This is a multiple of the ninth unit.
UOM_MULTIPLIER_10 NUMBER 18 The multiplier between the ninth unit and the tenth unit. Indicates how many of the ninth unit are in the tenth unit.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
OBJECT_VERSION_NUMBER NUMBER 9 Yes Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.

Indexes

Index Uniqueness Tablespace Columns
rcs_packaging_strings_U1 Unique FUSION_TS_TX_IDX PACKAGING_STRING_ID
rcs_packaging_strings_U2 Unique FUSION_TS_TX_IDX PS_ASCENDING
rcs_packaging_strings_U3 Unique FUSION_TS_TX_IDX PS_DESCENDING