| Table Name: | N_PackageMembers |
| Table Number: | 5415 |
| Group: | Configuration |
| Description: | Contains the membership relations for packages defined in the N_Packages object. This object stores information about options that are members of packages |
| Flags: | |
| Baseline/Custom: | Baseline |
| Field Name | Common Type | Database Type | Generic Field ID | Array Size | Default | Flags | Comment | Field Used in Views |
|---|---|---|---|---|---|---|---|---|
| dev | LONG | int | 151 | 1 | DIRECT, ALLOW_NULL | Row version number for mobile distribution purposes | ||
| N_CreditCostPerItem | DECIMAL | decimal (19,4) | ALLOW_NULL, CURRENCY | Reserved; future | ||||
| N_EffectiveDate | CLK_TIME | datetime | ALLOW_NULL | The first date on which the information should be used | ||||
| N_ExpirationDate | CLK_TIME | datetime | ALLOW_NULL | Last date when the information should be used | ||||
| N_ItemId | LONG | int | DIRECT, ALLOW_NULL | The ID of the item that is a member of the package | ||||
| N_ItemTypeId | LONG | int | DIRECT, ALLOW_NULL | Item type from N_ItemType table. It is used in conjunction with the N_ItemId field to identify to the item to which the package member belongs | ||||
| N_ModificationDate | CLK_TIME | datetime | ALLOW_NULL | Date and time when the information was last modified | ||||
| N_PackageId | LONG | int | DIRECT, ALLOW_NULL | ID of the Package in the N_Packages table. Reserved; obsolete | ||||
| N_Qty | CHAR | varchar | 50 | ALLOW_NULL | The quantity of the package member | |||
| N_Removable | LONG | tinyint | DIRECT, ALLOW_NULL | Denotes whether the item can be removed from a product by a ClearConfigurator user or added a part of the package | ||||
| N_SequenceNumber | LONG | int | DIRECT, ALLOW_NULL | Establishes the order in which members of the package are to be added to a product | ||||
| objid | LONG | int | 3 | DIRECT | Internal record number |
| Relation | Type | Target Object | Inverse Relation | Comment | Flags | MTM Table | Used in Views | Set Name | Type ID Stored in | Objid Stored In |
|---|---|---|---|---|---|---|---|---|---|---|
| Exclusive Set Relations | ||||||||||
| n_pkgmems2N_Option | MTO | N_Option | n_optn2N_PackageMembers | For a package member of an option the option | member_of | N_ItemTypeId | N_ItemId | |||
| n_pkgmems2N_Packages | MTO | N_Packages | n_pkg2N_PackageMembers | The package members' parent package | ||||||
| n_pkgmems2N_Product | MTO | N_Product | n_prod2N_PackageMembers | For a package member of a product the product | member_of | N_ItemTypeId | N_ItemId | |||
| Index Name | Fields | Flags |
|---|---|---|
| I5415 | n_pkgmems2N_Packages:N_ItemId:N_ItemTypeId | UNIQUE |
| Index Name | Fields | Additional Information |
|---|---|---|
| I5415 | n_pkgmems2N_Packages, N_ItemId, N_ItemTypeId | nonclustered, unique located on PRIMARY |
| objindex | objid | clustered, unique located on PRIMARY |
| pm2p | n_pkgmems2N_Packages | nonclustered located on PRIMARY |
| tid | N_ItemTypeId, N_ItemId | nonclustered located on PRIMARY |
| View ID | View Name | Tables |
|---|
| N_PackageMembers | |||