COMET Standard Data Dictionary v 1.0.10

	A	B	C	D	E	F	G	H	I	J	K
1	Field Name	Field Position	Field Class	Field Type	Required	Field Length	Field Description	Field Example	Field Media	Field Notes	TO WORK ON

9	NETPrice	8	Extended Data	Decimal	No	10,2	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)	5.06
10	NETPriced	9	Extended Data	Y/N	No	1	Indicates a product is NET priced	N
21	InitialOrderDate	20	Extended Data	Date	No	10	Identifies when the initial orders are due on a product (YYYY-MM-DD)	2021-02-02
22	FOCDate	21	Extended Data	Date	No	10	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)	2021-03-26
24	OriginalCatalogDate	23	Extended Data	Date	No	10	The OriginalCatalogDate field corresponds to the date when the item was originally listed, expressed in YYYY-MM-DD. (for Offered again and Resolicited Items)	2021-01-26
80	Case Weight	79	Extended Data	Decimal	No	10,4	The weight of a case pounds (Imperial) or grams (Metric), rounded to the fourth decimal place.	8.1673
81	Case Length	80	Extended Data	Decimal	No	10,4	The length of a case inches (Imperial), or cm (Metric), rounded to the fourth decimal place.	14.25
82	Case Width	81	Extended Data	Decimal	No	10,4	The width of a case inches (Imperial), or cm (Metric), rounded to the fourth decimal place.	36.616
83	Case Height	82	Extended Data	Decimal	No	10,4	The height of the case inches (Imperial), or cm (Metric), rounded to the fourth decimal place.	5.24
84	StockCode	83	Extended Data	Text	Yes	36	The Primary ID of the item that can be tracked month-to-month	ID11031989		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.
85	MonthCode	84	Extended Data	Text	No	10	The ID of the item for a specific catalogue month (traditionally MMMYY#### format)	SEP081984
86	AlternateCode	85	Extended Data	Text	No	36	Any alternate codes for other distribution arms.	SBAPR0550
87	OfferedAgain	86	Extended Data	Y/N	No	1	Sometimes, items are solicited more than once in subsequent catalogues. This field denotes if an item is being Offered Again.	N
88	Resolicited	87	Extended Data	Y/N	No	1	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.	N
89	FOCItem	88	Extended Data	Y/N	No	1	This field denotes whether a title is eligible for order adjustments by the Final Order Cutoff.	Y
90	DemandCheck	89	Extended Data	Y/N	No	1	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.	N
91	InitialOrderIncrement	90	Extended Data	Number	No	10	Minimum quantity required to order, similar to a case quantity.	12		This field serves a different purpose than the pre-existing Diamond field named OrderIncrement.
92	ReOrderIncrement	91	Extended Data	Number	No	10	Minimum quantity required to re-order, similar to a case quantity.	6
93	BundleQuantity	92	Extended Data	Number	No	10	Quantity of breakable units in a bundle.	12
94	BundleUPCs	93	Extended Data	Composite	No	2048	What UPCs are within this bundle of items?	72513032443605151, 72513032443605161
95	SalesRestrictions	94	Extended Data	Pick List	No	2048	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).	CA, UK		Using the standard ISO 3166-1 Alpha-2 Codes
96	OrderFormNotes	95	Extended Data	Text	No	1024	Order Form Notes are parenthetical descriptions, added below catalogue line items, offering additional ordering information on solicited merchandise.	50/50 Covers Distributed in Equal Ratio
97	CatalogPage	96	Extended Data	Number	No	4	This field identifies the page number in the distributor catalogue on which an item’s solicitation information can be found.	14
98	CatalogMonth	97	Extended Data	Date	No	7	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.	2021-02
99	DiscountCode	98	Extended Data	Text	No	6	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.	D
100	ReorderDiscountCode	99	Extended Data	Text	No	6	Discount codes are the code which designates which discount an account is eligible for a reorder.	DR
101	Returnable	100	Extended Data	Y/N	No	1	The item is returnable	Y
102	ReturnWindow	101	Extended Data	Date	No	21	The ReturnWindow field corresponds to the applicable date when an item can be returned YYYY-MM-DD. Example 2021-05-01.	2024-08-01:2024-08-15
103	ReturnType	102	Extended Data	Pick List	No	32	The type of returnability (affidavit, stripped cover, return to publisher, etc)	Affidavit
104	ReturnQualifier	103	Extended Data	Pick List	No	32	Open return, vs returns with qualifiers.	Open
105	ReturnPercent	104	Extended Data	Number	No	3	Percentage of FOC order you may return	75
106	ImageUrl	106	Extended Data	Text	No	512	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.	https://retailerservices.diamondcomics.com/Image/ItemMainImageLowRes/STK355285.jpg
107	ImageUpdateDate	107	Extended Data	Date	No	10	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.	2021-05-01
109	SalesStatusCode	109	Extended Data	Text	No	2	A two digit code that indicates the status of a product. (See Sales Status Codes in Data Definitions)	IP
110	SalesTerritory	110	Extended Data	Text	No		Positive list of territories an item is available in.
111	MaxOrderQuantity	111	Extended Data	Number	No	5	The MaxOrderQuantity field indicates the maximum orderable quantity, if any, of that item. If blank, there is no limit.
117	NETPriceCA	117	Extended Data	Decimal	No	10,2	NET Price in CAD
118	NETPricedCA	118	Extended Data	Y/N	No	1	Boolean Y/N to indicate there is a Net Price in CAD
119	NETPriceUK	119	Extended Data	Decimal	No	10,2	NET Price in UK
120	NETPricedUK	120	Extended Data	Y/N	No	1	Boolean Y/N to indicate there is a Net Price in UK
121	DistributorPublisherCode	121	Extended Data	Text	No		A code for the publisher that indicates the internal code for the distributor.
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180