Skip to main content

Extended Fields

Owner: Distributor · 42 fields

Everything that describes how to order it — ordering, returns, and distribution logistics.

See the full Data Dictionary for a searchable table across all tiers.

NETPrice​

Machine name: NETPrice · Position: 8 · Type: Decimal · Length: 10,2 · Owner: Distributor · Required: No

If an Item is flagged as NET Priced, it defaults to the USD item price. Use this field to override that default. (Example: 5.06 for an item that is net priced at $5.06)

Example: 5.06

NETPriced​

Machine name: NETPriced · Position: 9 · Type: Y/N · Length: 1 · Owner: Distributor · Required: No

Indicates a product is NET priced

Example: N

InitialOrderDate​

Machine name: InitialOrderDate · Position: 20 · Type: Date · Length: 10 · Owner: Distributor · Required: No

Identifies when the initial orders are due on a product (YYYY-MM-DD)

Example: 2021-02-02

FOCDate​

Machine name: FOCDate · Position: 21 · Type: Date · Length: 10 · Owner: Distributor · Required: No

The FOCDate field provides the Final Order Cutoff date for the item, expressed in YYYY-MM-DD. Example 2023-10-13 (may be different than publisher FOC)

Example: 2021-03-26

OriginalCatalogDate​

Machine name: OriginalCatalogDate · Position: 23 · Type: Date · Length: 10 · Owner: Distributor · Required: No

The OriginalCatalogDate field corresponds to the date when the item was originally listed, expressed in YYYY-MM-DD. (for Offered again and Resolicited Items)

Example: 2021-01-26

Case Weight​

Machine name: CaseWeight · Position: 79 · Type: Decimal · Length: 10,4 · Owner: Distributor · Required: No

The weight of a case pounds (Imperial) or grams (Metric), rounded to the fourth decimal place.

Example: 8.1673

Case Length​

Machine name: CaseLength · Position: 80 · Type: Decimal · Length: 10,4 · Owner: Distributor · Required: No

The length of a case inches (Imperial), or cm (Metric), rounded to the fourth decimal place.

Example: 14.25

Case Width​

Machine name: CaseWidth · Position: 81 · Type: Decimal · Length: 10,4 · Owner: Distributor · Required: No

The width of a case inches (Imperial), or cm (Metric), rounded to the fourth decimal place.

Example: 36.616

Case Height​

Machine name: CaseHeight · Position: 82 · Type: Decimal · Length: 10,4 · Owner: Distributor · Required: No

The height of the case inches (Imperial), or cm (Metric), rounded to the fourth decimal place.

Example: 5.24

StockCode​

Machine name: StockCode · Position: 83 · Type: Text · Length: 36 · Owner: Distributor · Required: Yes

The Primary ID of the item that can be tracked month-to-month

Example: ID11031989

Notes: If the PrimaryID is UPC/ISBN or EAN, it should be repeated in this field. Note that ISBN is not 1-to-1, EAN is 1-to-1.

MonthCode​

Machine name: MonthCode · Position: 84 · Type: Text · Length: 10 · Owner: Distributor · Required: No

The ID of the item for a specific catalogue month (traditionally MMMYY#### format)

Example: SEP081984

AlternateCode​

Machine name: AlternateCode · Position: 85 · Type: Text · Length: 36 · Owner: Distributor · Required: No

Any alternate codes for other distribution arms.

Example: SBAPR0550

OfferedAgain​

Machine name: OfferedAgain · Position: 86 · Type: Y/N · Length: 1 · Owner: Distributor · Required: No

Sometimes, items are solicited more than once in subsequent catalogues. This field denotes if an item is being Offered Again.

Example: N

Resolicited​

Machine name: Resolicited · Position: 87 · Type: Y/N · Length: 1 · Owner: Distributor · Required: No

A re-issued item was previously listed, but was cancelled before shipping and is being listed again. No previous orders were committed, and this re-issue will be the first time this product is being ordered.

Example: N

FOCItem​

Machine name: FOCItem · Position: 88 · Type: Y/N · Length: 1 · Owner: Distributor · Required: No

This field denotes whether a title is eligible for order adjustments by the Final Order Cutoff.

Example: Y

DemandCheck​

Machine name: DemandCheck · Position: 89 · Type: Y/N · Length: 1 · Owner: Distributor · Required: No

After the Final Order Cut-off deadline, the publisher will evaluate the orders and determine if the product will be reprinted. If the orders do not justify a reprint, all orders will be canceled, and retailers will be notified via the Order Cancellation section of their invoices.

Example: N

InitialOrderIncrement​

Machine name: InitialOrderIncrement · Position: 90 · Type: Number · Length: 10 · Owner: Distributor · Required: No

Minimum quantity required to order, similar to a case quantity.

Example: 12

Notes: This field serves a different purpose than the pre-existing Diamond field named OrderIncrement.

ReOrderIncrement​

Machine name: ReOrderIncrement · Position: 91 · Type: Number · Length: 10 · Owner: Distributor · Required: No

Minimum quantity required to re-order, similar to a case quantity.

Example: 6

BundleQuantity​

Machine name: BundleQuantity · Position: 92 · Type: Number · Length: 10 · Owner: Distributor · Required: No

Quantity of breakable units in a bundle.

Example: 12

BundleUPCs​

Machine name: BundleUPCs · Position: 93 · Type: Composite · Length: 2048 · Owner: Distributor · Required: No

What UPCs are within this bundle of items?

Example: 72513032443605151, 72513032443605161

SalesRestrictions​

Machine name: SalesRestrictions · Position: 94 · Type: Pick List · Length: 2048 · Owner: Distributor · Required: No

The SalesRestrictions field displays the geographic territories where the item may not be sold, in a comma separated list. See list of country codes (based on 2 character ISO 3166 country codes).

Example: CA, UK

Picklist: controlled vocabulary not yet published

Notes: Using the standard ISO 3166-1 Alpha-2 Codes

OrderFormNotes​

Machine name: OrderFormNotes · Position: 95 · Type: Text · Length: 1024 · Owner: Distributor · Required: No

Order Form Notes are parenthetical descriptions, added below catalogue line items, offering additional ordering information on solicited merchandise.

Example: 50/50 Covers Distributed in Equal Ratio

CatalogPage​

Machine name: CatalogPage · Position: 96 · Type: Number · Length: 4 · Owner: Distributor · Required: No

This field identifies the page number in the distributor catalogue on which an item’s solicitation information can be found.

Example: 14

CatalogMonth​

Machine name: CatalogMonth · Position: 97 · Type: YearMonth · Length: 7 · Owner: Distributor · Required: No

Identifies the original date the item was solicited. Also known as "Catalogue Date". (YYYY-MM), for items that are cancelled and re-solicited, this date will be for the NEW solicitation date.

Example: 2021-02

DiscountCode​

Machine name: DiscountCode · Position: 98 · Type: Text · Length: 6 · Owner: Distributor · Required: No

Discount codes are the code which designates which discount an account is eligible for. This supports fluctuating discounts based on publisher or vendor, and requires a table to decode.

Example: D

ReorderDiscountCode​

Machine name: ReorderDiscountCode · Position: 99 · Type: Text · Length: 6 · Owner: Distributor · Required: No

Discount codes are the code which designates which discount an account is eligible for a reorder.

Example: DR

Returnable​

Machine name: Returnable · Position: 100 · Type: Y/N · Length: 1 · Owner: Distributor · Required: No

The item is returnable

Example: Y

ReturnWindow​

Machine name: ReturnWindow · Position: 101 · Type: Date · Length: 21 · Owner: Distributor · Required: No

The ReturnWindow field corresponds to the applicable date when an item can be returned YYYY-MM-DD. Example 2021-05-01.

Example: 2024-08-01:2024-08-15

ReturnType​

Machine name: ReturnType · Position: 102 · Type: Pick List · Length: 32 · Owner: Distributor · Required: No

The type of returnability (affidavit, stripped cover, return to publisher, etc)

Example: Affidavit

Picklist: ReturnType

ReturnQualifier​

Machine name: ReturnQualifier · Position: 103 · Type: Pick List · Length: 32 · Owner: Distributor · Required: No

Open return, vs returns with qualifiers.

Example: Open

Picklist: ReturnQualifier

ReturnPercent​

Machine name: ReturnPercent · Position: 104 · Type: Number · Length: 3 · Owner: Distributor · Required: No

Percentage of FOC order you may return

Example: 75

ImageUrl​

Machine name: ImageUrl · Position: 106 · Type: Text · Length: 512 · Owner: Distributor · Required: No

The ImageURL field is a persistent URL that points to a high-resolution cover image for the item. If the field is blank, it means that a cover image is not yet available.

Example: https://retailerservices.diamondcomics.com/Image/ItemMainImageLowRes/STK355285.jpg

ImageUpdateDate​

Machine name: ImageUpdateDate · Position: 107 · Type: Date · Length: 10 · Owner: Distributor · Required: No

The date the image was last updated. Expressed in YYYY-MM-DD. Example, 2021-05-01. Should be populated with the date the first time when the ImageURL has a value.

Example: 2021-05-01

SalesStatusCode​

Machine name: SalesStatusCode · Position: 109 · Type: Text · Length: 2 · Owner: Distributor · Required: No

A two digit code that indicates the status of a product. (See Sales Status Codes in Data Definitions)

Example: IP

SalesTerritory​

Machine name: SalesTerritory · Position: 110 · Type: Text · Owner: Distributor · Required: No

Positive list of territories an item is available in.

MaxOrderQuantity​

Machine name: MaxOrderQuantity · Position: 111 · Type: Number · Length: 5 · Owner: Distributor · Required: No

The MaxOrderQuantity field indicates the maximum orderable quantity, if any, of that item. If blank, there is no limit.

NETPriceCA​

Machine name: NETPriceCA · Position: 117 · Type: Decimal · Length: 10,2 · Owner: Distributor · Required: No

NET Price in CAD

NETPricedCA​

Machine name: NETPricedCA · Position: 118 · Type: Y/N · Length: 1 · Owner: Distributor · Required: No

Boolean Y/N to indicate there is a Net Price in CAD

NETPriceUK​

Machine name: NETPriceUK · Position: 119 · Type: Decimal · Length: 10,2 · Owner: Distributor · Required: No

NET Price in UK

NETPricedUK​

Machine name: NETPricedUK · Position: 120 · Type: Y/N · Length: 1 · Owner: Distributor · Required: No

Boolean Y/N to indicate there is a Net Price in UK

DistributorPublisherCode​

Machine name: DistributorPublisherCode · Position: 121 · Type: Text · Length: 10 · Owner: Distributor · Required: No

A code for the publisher that indicates the internal code for the distributor.

OtherMarketOnSaleDate​

Machine name: OtherMarketOnSaleDate · Position: 125 · Type: Date · Length: 10 · Owner: Distributor · Required: No

The date that other markets outside the comics industry may offer this item on sale, expressed in YYYY-MM-DD. Example 2023-10-13