String, max 255 characters, cannot be null

The type of Edge category this item is in.

String, max 255 characters, cannot be null

The generic description for items in this category.

Integer, max 3 digits, cannot be null

The Edge category number this item is in.

String, max 255 characters, cannot be null

The name of the Edge category this item is in.

Boolean, True/False, cannot be null

No longer used (legacy)

Boolean, True/False, cannot be null

String, max 63,999 characters, can be null

The full description from the item's pre-appraisal tab.

String, max 255 characters, can be null

The short description from the item's pre-appraisal tab.

Decimal, max 8 digits, can be null

The appraised value entered on the item's pre-appraisal tab.

Integer, max 3 digits, can be null

The associate number for the person that entered pre-appraisal.

Decimal, max 18 digits, can be null

The spiff assigned to this item.

Integer, max 3 digits, cannot be null

The Edge category number this item is in.

Decimal, max 18 digits, cannot be null

The cost of the item.

Decimal, max 18 digits, cannot be null

The replacement cost of this item.

Date/Time, mm/dd/yyyy hh:mm:ss, cannot be null

The date itCostReplacement was calculated.

Integer, max 3 digit, cannot be null

The associate that entered this item.

Decimal, max 18 digits, cannot be null

The current selling price for this item. This may differ from itRetailPrice if the item has been marked down.

Date/Time, mm/dd/yyyy hh:mm:ss, cannot be null

The date & time this item record was created (system defined).

Date/Time, mm/dd/yyyy hh:mm:ss, cannot be null

The date & time this item was entered into inventory (user specified).

Date/Time, mm/dd/yyyy hh:mm:ss, cannot be null

The date & time this item became current status.

String, max 255 characters, cannot be null

The item's description. If an item's description is longer than 255 characters the overflow goes into itDescMemo. There is an optional secondary web-only description found in imDescription.

String, max 63,999 characters, can be null

The first 255 characters of an item's description are stored in itDesc. If the description exceeds this the additional characters are stored here.

Data type varies, user defined, can be null (user can force validation)

Custom detail fields defined by the user. See Item Details for mapping information.

Date/Time, mm/dd/yyyy hh:mm:ss, can be null

For assembly or build items, the original estimated completion date.

Date/Time, mm/dd/yyyy hh:mm:ss, can be null

For assembly or build items, the revised estimated completion date.

Boolean, True/False, cannot be null

String, max 63,999 characters, can be null

The image file linked to this item. If there are multiple images each file name delineated by a vertical bar.

String, max 255 characters, cannot be null where itPricingMethod="1", "2", "3", or "4" and itStatus="S"

References itKey for bulk master record for this sold bulk instance.

String, max 255 characters, cannot be null where itPricingMethod="1", "2", "3", or "4" and itStatus="S"

Quantity sold on this bulk instance.

For itPricingMethod="1" this is always "1"

For itPricingMethod="2" this is always "0"

For itPricingMethod="3" this is always "1"

For itPricingMethod="4" this is always "1"

String, max 255 characters, cannot be null where itPricingMethod="1", "2", "3", or "4" and itStatus="S"

Amount of unit of measure sold on this bulk instance.

For itPricingMethod="1" this is always "0"

For itPricingMethod="2" or "3" this is the amount of measure sold.

For itPricingMethod="4" this is always "1"

String, max 1 character, cannot be null

The type of item.

String, max 255 characters, cannot be null

The full item number in format [itStoreId] - [CatId] - [itStockNo] e.g. 001-100-00001.

Integer, max 2 digits, can be null

Number of days lead time for built or assembled items.

Decimal, max 18 digits, can be null (user can force validation)

The length of this item (typically chain).

String, max 255 characters, can be null (user can force validation)

The location of the item. This is a key that is defined in the Location table.

Decimal, max 18 digits, cannot be null

The lowest price this item can be sold for without requiring system override.

Date/Time, mm/dd/yyyy hh:mm:ss, can be null

For itInventoryType="M", the date the memo item expires.

String, max 255 characters, can be null

The web category for this item.

String, max 63,999 characters, can be null

The web description for this item.

String, max 255 characters, cannot be null

The full item number in format [itStoreId] - [CatId] - [itStockNo] e.g. 001-100-00001.

String, max 255 characters, can be null (user can force validation)

The metal color of this item.

String, max 255 characters, can be null (user can force validation)

The metal finish of this item.

String, max 255 characters, can be null (user can force validation)

The metal type of this item.

Decimal, max 18 digits, can be null (user can force validation)

The weight of this item's metal.

String, max 63,999 characters, can be null

The meta description for this item.

String, max 63,999 characters, can be null

Meta keywords for this item.

String, max 255 characters, can be null

The meta title for this item.

String, max 255 characters, can be null

The web title for this item.

Date/Time, mm/dd/yyyy hh:mm:ss, cannot be null

The date/time category record was last modified.

Integer, max 7 digits, cannot be null

This number is incremented by one each time the item's website tab is updated.

Integer, max 3 digits, can be null

The workstation number that last updated this item's website tab.

Integer, max 3 digits, can be null

The store number that last updated this item's website tab.

Integer, max 3 digits, can be null

The associate number that last updated this item's website tab.

Date/Time, mm/dd/yyyy hh:mm:ss, can be null

The date the item's meta data was deleted.

Boolean, True/False, cannot be null

String, max 255 characters, can be null (user can force validation)

The manufacturer of this item.

Boolean, True/False, cannot be null

String, max 255 characters, can be null

For items moved between categories and/or stores, this references the new item record's itKey.

String, max 63,999 characters, can be null

Notes on the item stored in RTF format.

String, max 255 characters, can be null

For itInventoryType="P" (takeoff), the itKey of the item this was assembled or built into.

String, max 255 characters, if itStatus="U" cannot be null

The type of job this item was used as a part on.

String, max 255 characters, can be null

For items converted from another software system, this is the barcode number in the previous software.

String, max 255 characters, can be null

For items converted from another software system, this is the item number in the previous software.

String, max 255 characters, can be null

For sold items converted from another software system, this is the sale number in the previous software.

String, max 63,999 characters, can be null

The style notes for this item.

Date/Time, mm/dd/yyyy hh:mm:ss, can be null

For sold items converted from another software system, this is the date the item was sold.

String, max 255 characters, can be null

For sold items converted from another software system, this is the sale number in the previous software.

String, max 255 characters, cannot be null if itInventoryType="C"

For consignment items, the customer number of the owner.

Date/Time, mm/dd/yyyy hh:mm:ss, if itItemType ="C" or "M" and itStatus="S" cannot be null

The date/time this consignment or memo item became payable, i.e. was sold.

String, max 255 characters, can be null

References purchase order line in the POLine table that this item was ordered or added on.

Integer, max 1 digit, cannot be null

The software features 5 pricing methods. The majority of items are 0 (fine jewelry, individual item pricing) which assigns each item a unique item number (ItemKey) even if that style of item has been in inventory before. Each item number represents one physical item. For smaller items carried in quantity, such as Pandora, we offer bulk pricing methods that allow a single number to be assigned quantity and re-used indefinitely.

Boolean, True/False, cannot be null

The in-case sign template is specified in itSignage.

Boolean, True/False, cannot be null

Decimal, max 18 digits, cannot be null

The retail price of the item. This may differ from itCurrentPrice if the item has been marked down.

Decimal, 18 digits, can be null

Bonus rewards factor for purchasing this item.

Date/Time, mm/dd/yyyy hh:mm:ss, can be null

End date for this item's purchase to earn bonus rewards.

Date/Time, mm/dd/yyyy hh:mm:ss, can be null

Start date for this item's purchase to earn bonus rewards.

String, max 255 characters, can be null

The RFID code for this item.

String, max 255 characters, cannot be null if itStatus="S"

For sold items (itStatus="S"), the primary customer's number. Can differ from itSaleCustKey if item sold to a linked customer record i.e. spouse.

String, max 255 characters, cannot be null if itStatus="S"

For sold items (itStatus="S"), the customer number of the purchaser.

Date/Time, mm/dd/yyyy hh:mm:ss, cannot be null if itStatus="S"

For sold items (itStatus="S"), the date the item was sold.

String, max 255 characters, cannot be null if itStatus="S"

For sold items (itStatus="S"), the sale number item was sold on.

Decimal, max 18 digits, cannot be null if itStatus="S"

For sold items (itStatus="S"), the price the item was sold for excluding tax.

Decimal, max 18 digits, cannot be null if itStatus="S"

For sold items (itStatus="S"), the amount of tax paid on this item.

String, max 255 characters, can be null

The serial number for this item.

String, max 255 characters, can be null

The in-case sign template to use when this item is on sale.

Decimal, max 18 digits, can be null (user can force validation)

The size of this item (typically ring).

String, max 255 characters, can be null

For special order items, the special order it is matched to.

Decimal, max 8 digits, can be null

The sale price for this item. This overrides all other pricing fields during sale period. Sale period defined by itSpecialPriceDateStart and itSpecialPriceDateEnd.

Date/Time, mm/dd/yyyy hh:mm:ss, can be null

The sale end date.

Date/Time, mm/dd/yyyy hh:mm:ss, can be null

The sale start date.

String, max 1 character, cannot be null

The current status of this item.

Integer, max 7 digits, cannot be null

The sequential stock number for this item. The third component of itKey, i.e. the item number.

Integer, max 2 digits, cannot be null

The store the item is in. The first component of itKey, i.e. the item number.

String, max 255 characters, can be null (user can force validation)

The style of the item.

String, max 255 characters, can be null

For itPricingMethod="2" or "3" (bulk), the unit of measure for this item.

Date/Time, mm/dd/yyyy hh:mm:ss, cannot be null

The date/time item record was last modified.

Integer, max 7 digits, cannot be null

This number is incremented by one each time the item is updated.

Integer, max 3 digits, can be null

The workstation number that last updated this item.

Integer, max 2 digits, cannot be null

The store number that last updated this item.

Integer, max 3 digits, can be null

The associate number that last updated this item.

String, 255 characters max, can be null

The vendor's barcode for this item.

String, max 255 characters, cannot be null

The vendor's ID (internal abbreviation).

String, 255 characters max, can be null

The invoice number item was received on.

String, max 255 characters, cannot be null

The vendor's style number.

String, max 255 characters, can be null

For itInventoryType="P" (takeoff), the itKey of the item this was disassembled from.

Date/Time, mm/dd/yyyy hh:mm:ss, can be null

The date/time the item was last scanned as part of physical inventory.

Date/Time, mm/dd/yyyy hh:mm:ss, can be null

The date/time the item was last scanned prior to the itWhenInventory date.

Integer, max 3 digits, can be null

For assembly or built items, the original ID of the associate completing the work.

String, max 3 characters, can be null

Corresponds with itWhenInventory, the associate number that scanned the item.

String, max 3 characters, can be null

Corresponds with itWhenPrevInventory, the associate number that scanned the item.

Integer, max 3 digits, can be null

For assembly or built items, the revised ID of the associate completing the work.

Boolean, True/False, cannot be null

Boolean, True/False, cannot be null

The number of stone rows on this item. A stone row contains information about a type of stone and may represent more than one physical stone. There is one stone row per type. There is no corresponding data field or object in the database.

String, 50 characters max, cannot be null

Internal key that references a stone row in the Stones table for this item.

String, 2 characters max, cannot be null

This stone's position starting at 00 for the first stone type(typically primary), then 01 for the second stone type, and so on.

String, 50 characters max, cannot be null

References the item number (ItemKey) that this stone row belongs to. If the item was consumed in an assembly or build, this will reference the original consumed item and StoneAssyKey references the completed item.

String, 50 characters max, can be null

For items that were assembled or built, this references the completed item number (ItemKey) .

String, 2 characters max, can be null

For items that were assembled or built, the stone's position on the completed item starting at 00 for the first stone type, then 01 for the second stone type, and so on.

String, 32 characters max, cannot be null

Abbreviation for the type of stone in this stone row. Chosen from predefined customizable pick list. Defaults include:

String, 32 characters max, can be null

Abbreviation for the shape of the stone in this stone row. Chosen from predefined customizable pick list. Defaults include:

Integer, max 3 digits, can be null

The number of stones of this type.

Decimal, max 18 digits, can be null

The minimum possible weight for a stone in this row. If StoneWeightMax not specified, then this is the absolute weight for stones in this row.

Decimal, max 18 digits, can be null

The minimum possible length for a stone in this row. If StoneLengthMaxnot specified, then this is the absolute length for stones in this row.

Decimal, max 18 digits, can be null

The minimum possible width for a stone in this row. If StoneWidthMaxnot specified, then this is the absolute width for stones in this row.

Decimal, max 18 digits, can be null

The minimum possible depth for a stone in this row. If StoneDepthMaxnot specified, then this is the absolute depth for stones in this row.

Decimal, max 18 digits, can be null

The maximum possible weight for a stone in this row.

Decimal, max 18 digits, can be null

The maximum possible length for a stone in this row.

Decimal, max 18 digits, can be null

The maximum possible width for a stone in this row.

Decimal, max 18 digits, can be null

The maximum possible depth for a stone in this row.

Boolean, True/False, cannot be null

Decimal, max 18 digits, can be null

The table size for this stone in MM.

Decimal, max 18 digits, can be null

The table size for this stone as a percentage of diameter.

Decimal, max 18 digits, can be null

The crown size for this stone in MM.

String, max 32 characters, can be null

The smallest girdle measurement. Chosen from predefined pick list:

String, max 32 characters, can be null

The largest girdle measurement. Chosen from predefined customizable pick list. Defaults include:

Decimal, max 18 digits, can be null

The pavillion size for this stone in MM.

Decimal, max 18 digits, can be null

Percentage of diameter represented by the depth of the pavillion.

String, max 32 characters, can be null

Size of stone culet.

String, max 32 characters, can be null

The stone's major symmetry rating.

String, max 32 characters, can be null

The stone's minor symmetry rating.

No longer used (legacy)

No longer used (legacy)

String, max 32 characters, can be null

The stone's clarity.

String, max 32 characters, can be null

The stone's hue.

String, max 32 characters, can be null

The stone's saturation.

String, max 32 characters, can be null

The stone's tone.

String, max 32 characters, can be null

The direction of the stone.

String, max 32 characters, can be null

The pattern of the stone.

String, max 32 characters, can be null

The degree of florescence in the stone.

String, max 32 characters, can be null

The type of polish on the stone.

String, max 32 characters, can be null

The type of finish on this stone.

String, max 32 characters, can be null

The texture of this stone.

String, max 32 characters, can be null

For pearls, the nacre thickness.

String, max 32 characters, can be null

The uniformity of the stone.

String, max 32 characters, can be null

The cut of the stone.

Decimal, max 18 digits, can be null

The cost per carat for this stone.

String, max 32 characters, can be null

The ID of the lab that certified the stone.

String, max 50 characters, can be null

The certificate number associated with the stone.

Decimal, max 18 digits, can be null

The total weight of this stone.

String, max 32 characters, can be null

The vendor for this stone. Corresponds to the Supplier field in The Edge. For value to be valid must match to a vendorId in the Vendor table.

String, max 32 characters, can be null

The invoice number this stone was received on.

Date/Time, mm/dd/yyyy hh:mm:ss, can be null

The date/time the stone was received.

Decimal, max 18 digits, can be null

The cost of the stone.

Decimal, max 18 digits, can be null

The replacement cost of the stone.

Decimal, max 18 digits, can be null

The retail price of the stone.

Date/Time, mm/dd/yyyy hh:mm:ss, can be null

If populated stone was deleted. This is the date/time stone deleted.

Integer, max 7 digits, cannot be null

This number is incremented by one each time the stone row is updated.

Date/Time, mm/dd/yyyy hh:mm:ss, cannot be null

The date/time stone record was last modified.

Integer, max 2 digits, cannot be null

The store number that last updated this stone row.

Integer, max 3 digits, can be null

The workstation number that last updated this stone row.

Integer, max 3 digits, can be null

The associate number that last updated this stone row.

Boolean, True/False, cannot be null

String, max 50 characters, can be null

If the stone has an enhancement, the type of enhancement.

String, max 50 characters, can be null

If the stone has an enhancement, the nature of the enhancement.

String, max 32 characters, cannot be null

The Edge abbreviation for this vendor.

No longer used (legacy)

String, max 77 characters, cannot be null

The vendor's name.

String, max 77 characters, can be null

The vendor's street address.

String, max 255 characters, can be null

Additional street address information.

String, max 77 characters, can be null

The vendor's city.

String, max 77 characters, can be null

The vendor's state.

String, max 77 characters, can be null

The vendor's ZIP code.

String, max 77 characters, can be null

The vendor's country.

String, max 77 characters, can be null

The vendor's phone number.

String, max 77 characters, can be null

The vendor's fax number.

String, max 77 characters, can be null

The store's account number with this vendor.

String, max 77 characters, can be null

The name of the vendor's salesperson.

String, max 77 characters, can be null

The vendor's salesperson's phone number.

String, max 77 characters, can be null

The name of the vendor's credit manager.

String, max 77 characters, can be null

The vendor's credit manager's phone number.

String, max 77 characters, can be null

The name of the vendor's special order manager.

String, max 77 characters, can be null

The vendor's special order manager's name.

String, max 63,999 characters, can be null

Notes for this vendor in RTF format.

Boolean, True/False, cannot be null

Integer, max 7 digits, cannot be null

This number is incremented by one each time the vendor record is incremented.

Date/Time, mm/dd/yyyy hh:mm:ss, cannot be null

The date/time vendor record was last modified.

Integer, max 3 digits, cannot be null

The store number where the vendor record was last updated.

Integer, max 3 digits, cannot be null

The associate number for the person that last updated vendor record.

Integer, max 3 digits, cannot be null

The workstation number where the vendor record was last updated.

Boolean, True/False, cannot be null

No longer used (legacy)

String, max 255 characters, can be null

The vendor's email address.

String, max 255 characters, can be null

The vendor's sales email.

String, max 255 characters, can be null

The vendor's special order email.

String, max 255 characters, can be null

The vendor's credit email.

String, max 255 characters, can be null

The vendor's website address.

Decimal, max 18 digits, can be null

Commission adjustment percentage for this vendor's sold items. VendorCommissionOvr defines if this adjustment compounds or overrides default commission.

Boolean, True/False, cannot be null

No longer used (legacy)

String, max 255 characters, can be null

Internal vendor ID that links this vendor to an external catalog file for import.

Boolean, True/False, cannot be null

Boolean, True/False, cannot be null

String, max 255 characters, can be null

The vendor's purchase order phone number.

String, max 255 characters, can be null

The vendor's purchase order fax number.

String, max 255 characters, can be null

The name to use in the vendor's return address.

String, max 255 characters, can be null

The street address for the vendor's return address.

String, max 255 characters, can be null

Additional street address information.

String, max 255 characters, can be null

The city for the vendor's return address.

String, max 255 characters, can be null

The state for the vendor's return address.

String, max 255 characters, can be null

The ZIP for the vendor's return adress.

Integer, max 3 digits, cannot be null

The Edge category number this item is in.

Integer, max 2 digits, cannot be null

References the position this appears on the item detail fields 1 - 16 on the General tab of an item. A negative number denotes the detail group name, i.e. Ring Details.

String, max 50 characters, cannot be null

The name of the detail.

String, max 50 characters, cannot be null

The database field that store's this detail.

String, max 50 characters, cannot be null

Defines the type of detail:

String, max 50 characters, can be null

For "DetailType = List", this is the internal list it is linked to. If "=FALSE" user can choose from list or enter any string. If "=TRUE" user can only choose from linked picklist.

Boolean, True/False, cannot be null

String, max 50 characters, can be null

For "DetailType = List", this is the internal list it is linked to.