CV1:Sales Order Detail
Version 2.01 6/10/2008
Format: PIDF: PIDF
CETE Topic: SD: SD
Usage: Sales order detail line.: Sales order detail line.
| Description | Start Position | Length | Format | Required? | Format/Comments | Possible X.12 Mapping |
| Line # | 1 | 5 | N | N | Line # of the seller’s invoice | 810.IT101.350 |
| Secondary Line # | 6 | 3 | N | N | Secondary Line # of the seller's invoice. | |
| Line Type | 9 | 1 | A | Y | What type of
line is this? "C"=Charge Item "D"=Deal Explosion "F"=Free Item "I"=Line Item "M"=Message Line |
|
| CV1 Item Number | 10 | 6 | N | Y | 810.IT109.234 | |
| Cv1 Category Number | 16 | 2 | N | N | ||
| Cv1 Sales Class | 18 | 5 | N | N | ||
| U/M Number | 23 | 1 | N | N | Unit of measure # ordered for Item - (Zero means default unit of measure if no ANSIUM is given) Use only values 0-4. | 810.IT103.355 |
| U/M Text | 24 | 3 | A | N | Text of unit ordered. For example, EA, BOX, CSE. | |
| Quantity Ordered | 27 | 7 | R | Y | Quantity Ordered | 810.IT102.358 |
| Quantity Shipped | 34 | 5 | R | Y | Quantity Shipped | |
| Unit Price | 39 | 9 | R | N | Price for one. If an override price is present, that value will be given here. This field does not include taxes. | 810.IT104.212 |
| Unit Retail | 48 | 9 | R | N | Retail value for one. | |
| Unit Allowance | 57 | 7 | R | N | How much price allowance per unit was awarded. | 810.SAC05.610 |
| Extended Price | 64 | 9 | R | N | (Unit Price * Qty) Does not include taxes. | |
| Extended Retail | 73 | 9 | R | N | (Unit Retail * Qty) | |
| Extended Stamp Tax | 82 | 6 | R | N | ||
| Extended Sales Tax | 88 | 7 | R | N | This is the amount of sales tax that is actually due on the line. | |
| Invoice Print Retail | 95 | 6 | R | N | Unit retail price that prints on an invoice. | |
| Retailer's selling unit. | 101 | 1 | N | N | Unit of measure# which the retailer normally resells this product in. | |
| Line Description | 102 | 35 | A | N | Line Description | 810.PID105.352 |
| UPC code | 137 | 15 | A | N | Product reference code of the entity that manufactures the product. Note: A single product may have a discrete UPC code for each of its units.. The UPC code in this field corresponds to the unit defined in the "Print Which UPC?" field in the customer's Invoice Options. If nothing is defined there, unit 1 is used.The UPC code in this field corresponds to the unit defined in the "Print Which UPC?" field in the customer's Invoice Options. If nothing is defined there, unit 1 is used. | 810.IT111.234 |
| Billing Reason | 152 | 1 | A | N | Reason code for why this line exists. (User defined) | |
| Customer's Product ID | 153 | 15 | A | N | Reference code the customer uses to identify the product. | |
| Customer's Category | 168 | 2 | A | N | Reference code the customer uses to categorize the product. | |
| Allowance Type | 170 | 1 | A | N | The type of allowance awarded if
applicable. 1 = Cent's Off 2 = List Less 3 = Fixed 4 = Super Item Pre-Packed 5 = Super Item Non Pre-Packed |
|
| Unused | 171 | 2 | A | N | ||
| Customer's Category Description | 173 | 35 | A | N | Description of the customer's category. | |
| Customer's Class | 208 | 5 | A | N | Reference code the customer uses to further categorize the product. | |
| Customer's Class Description | 213 | 35 | A | N | Description of the customer's class | |
| Pack Description | 248 | 10 | A | N | Describes how this product is packed | |
| Pack Qty | 258 | 5 | N | N | How many single units are in the shipped unit | |
| Ship Date | 263 | 8 | N | N | YYYYMMDD. Applies only if the order is of type "Prebook". | |
| Picking Region | 271 | 2 | A | N | A picking region groups together numerous, contiguous locations in desired sections of a warehouse, generally for the purpose of picking product. | |
| Warehouse Area | 273 | 6 | A | N | A warehouse area groups together numerous locations in desired sections of a warehouse, generally for the purpose of taking inventory counts. | |
| Warehouse Location | 279 | 9 | A | N | A specific stock keeping unit. This is where the item will be "picked" from. | |
| ANSI U/M | 288 | 2 | A | N | The ANSI Unit of Measure for the Unit Purchased (If defined in ANSI UM Lookup Table in DAC) | |
| Transaction Terminator Symbol | 290 | 2 | A | Y | Literal "//" | |
| Total Length | 291 |
CV1:Sales Order Detail
Version 2.00 3/11/03
Format: PIDF: PIDF
CETE Topic: SD: SD
Usage: Generally used to reconcile a "Requested Sales Order" with an actual order.: Generally used to reconcile a "Requested Sales Order" with an actual order.
| Description | Start Position | Length | Format | Required? | Format/Comments | Possible X.12 Mapping |
| Line # | 1 | 5 | N | N | Line # of the seller’s invoice | 810.IT101.350 |
| Secondary Line # | 6 | 3 | N | N | Secondary Line # of the seller's invoice.. | |
| Line Type | 9 | 1 | A | Y | What type of
line is this?? "C"=Charge Itemm "D"=Deal Explosionn "F"=Free Itemm "I"=Line Itemm "M"=Message Linee |
|
| CV1 Item Number | 10 | 6 | N | Y | 810.IT109.234 | |
| Cv1 Category Number | 16 | 2 | N | N | ||
| Cv1 Sales Class | 18 | 5 | N | N | ||
| U/M Number | 23 | 1 | N | N | Unit of measure # ordered for Item - (Zero means default unit of measure if no ANSIUM is given) Use only values 0-4. | 810.IT103.355 |
| U/M Text | 24 | 3 | A | N | Text of unit ordered. For example, EA, BOX, CSE.. | |
| Quantity Ordered | 27 | 7 | R | Y | Quantity Ordered | 810.IT102.358 |
| Quantity Shipped | 34 | 5 | R | Y | Quantity Shippedd | |
| Unit Price | 39 | 9 | R | N | Price for one. If an override price is present, that value will be given here. This field does not include taxes. | 810.IT104.212 |
| Unit Retail | 48 | 9 | R | N | Retail value for one.. | |
| Unit Allowance | 57 | 7 | R | N | How much price allowance per unit was awarded. | 810.SAC05.610 |
| Extended Price | 64 | 9 | R | N | (Unit Price * Qty) Does not include taxes.. | |
| Extended Retail | 73 | 9 | R | N | (Unit Retail * Qty)) | |
| Extended Stamp Tax | 82 | 6 | R | N | ||
| Extended Sales Tax | 88 | 7 | R | N | This is the amount of sales tax that is actually due on the line.. | |
| Invoice Print Retail | 95 | 6 | R | N | Unit retail price that prints on an invoice.. | |
| Retailer's selling unit. | 101 | 1 | N | N | Unit of measure# which the retailer normally resells this product in.. | |
| Line Description | 102 | 35 | A | N | Line Description | 810.PID105.352 |
| UPC code | 137 | 15 | A | N | Product reference code of the entity that manufactures the product. Note: A single product may have a discrete UPC code for each of its units.. The UPC code in this field corresponds to the unit defined in the "Print Which UPC?" field in the customer's Invoice Options. If nothing is defined there, unit 1 is used.The UPC code in this field corresponds to the unit defined in the "Print Which UPC?" field in the customer's Invoice Options. If nothing is defined there, unit 1 is used. | 810.IT111.234 |
| Billing Reason | 152 | 1 | A | N | Reason code for why this line exists. (User defined)) | |
| Customer's Product ID | 153 | 15 | A | N | Reference code the customer uses to identify the product.. | |
| Customer's Category | 168 | 2 | A | N | Reference code the customer uses to categorize the product.. | |
| Allowance Type | 170 | 1 | A | N | The type of allowance awarded if
applicable. 1 = Cent's Off 2 = List Less 3 = Fixed 4 = Super Item Pre-Packed 5 = Super Item Non Pre-Packed |
|
| Unused | 171 | 2 | A | N | ||
| Customer's Category Description | 173 | 35 | A | N | Description of the customer's category.. | |
| Customer's Class | 208 | 5 | A | N | Reference code the customer uses to further categorize the product.. | |
| Customer's Class Description | 213 | 35 | A | N | Description of the customer's classs | |
| Pack Description | 248 | 10 | A | N | Describes how this product is packedd | |
| Pack Qty | 258 | 5 | N | N | How many single units are in the shipped unitt | |
| Ship Date | 263 | 8 | N | N | YYYYMMDD. Applies only if the order is of type "Prebook".. | |
| Transaction Terminator Symbol | 271 | 2 | A | Y | Literal "//"" | |
| Total Lengthh | 272 |
V1:Sales Order Detail
Version 1.02 4/01/02CV1:Sales Order Detail
Version 1.02 4/01/02
Format: PIDF: PIDF
CETE Topic: SD: SD
Usage: Generally used to reconcile a "Requested Sales Order" with an actual order.: Generally used to reconcile a "Requested Sales Order" with an actual order.
| Descriptionn | Len | Fmt | Req | Format/Comments | Possible X.12 Mapping | |
| CV1 Item Number | 1 | 6 | N | Y | 810.IT109.234 | |
| UPC code | 7 | 15 | A | N | Product reference code of the entity that manufactures the product. Note: A single product may have a discrete UPC code for each of its units.. The UPC code in this field corresponds to the unit defined in the "Print Which UPC?" field in the customer's Invoice Options. If nothing is defined there, unit 1 is used. | 810.IT111.234 |
| Quantity Ordered | 22 | 7 | N | Y | Quantity Ordered | 810.IT102.358 |
| Quantity Shipped | 29 | 5 | N | Y | Quantity Shippedd | |
| Weight Ordered | 34 | 17 | R | N | Weight Orderedd | |
| Weight Shipped | 51 | 17 | R | N | Weight Shippedd | |
| U/M Number | 68 | 1 | N | N | Unit of measure # for Item - (Zero means standard if no ANSIUM is given) Use only values 0-4. If both ANSIUM and this field are specified, this field will take precedence | 810.IT103.355 |
| ANSIUM | 69 | 2 | A | N | ANSI Unit of measurement | 810.IT103.355 |
| Price | 71 | 17 | R | N | Price for one. If an override price is present, that value will be given here. | 810.IT104.212 |
| Line Description | 88 | 35 | A | N | Line Description | 810.PID105.352 |
| Taxable | 123 | 1 | A | Y | Was tax charged on this line item? (Y/N)) | |
| Reseller Taxable | 124 | 1 | A | Y | Does reseller charge tax for this item? (Y/N)) | |
| Tax Amount | 125 | 17 | R | N | How much tax was charged for this linee | |
| Custom Retail | 142 | 17 | R | N | Provides a customized retail amount if this product is to be resold.. | |
| Pack Description | 159 | 10 | A | N | Describes how this product is packedd | |
| Pack Qty | 169 | 5 | N | N | How many single units are in the shipped unitt | |
| Allowance | 174 | 17 | R | N | How much price allowance per unit was awarded. | 810.SAC05.610 |
| Order # | 191 | 7 | N | Y | CV1's Order Number | 810.BIG02.76 |
| Line # | 198 | 5 | N | N | Line # of the seller’s invoice | 810.IT101.350 |
| Purchase Order # | 203 | 15 | A | N | Purchaser’s PO # | 810.BIG04.324 |
| Remote Order ID | 218 | 15 | A | N | ID of remote order that caused this live order to be created.. | |
| Secondary Line # | 233 | 3 | N | N | Secondary Line # of the seller's invoice.. | |
| Line Type | 236 | 1 | A | Y | What type of line is this? | "C"=Charge
Itemm "D"=Deal Explosionn "F"=Free Itemm "I"=Line Itemm "M"=Message Line"M"=Message Line |
| Transaction Terminator Symbol | 237 | 2 | A | Y | Literal "//"" | |
| Total Lengthh | 238 |
CV1:Sales Order Detail Version 1.01 4/01/02
Format: PIDF: PIDF
CETE Topic: SD: SD
Usage: Generally used to reconcile a "Requested Sales Order" with an actual order.: Generally used to reconcile a "Requested Sales Order" with an actual order.
| Descriptionn | Len | Fmt | Req | Format/Comments | Possible X.12 Mapping | |
| CV1 Item Number | 1 | 6 | N | Y | 810.IT109.234 | |
| UPC code | 7 | 15 | A | N | Product reference code of the entity that manufactures the product. Note: A single product may have a discrete UPC code for each of its units.. The UPC code in this field corresponds to the unit defined in the "Print Which UPC?" field in the customer's Invoice Options. If nothing is defined there, unit 1 is used.The UPC code in this field corresponds to the unit defined in the "Print Which UPC?" field in the customer's Invoice Options. If nothing is defined there, unit 1 is used. | 810.IT111.234 |
| Quantity Ordered | 22 | 7 | N | Y | Quantity Ordered | 810.IT102.358 |
| Quantity Shipped | 29 | 5 | N | Y | Quantity Shippedd | |
| Weight Ordered | 34 | 17 | R | N | Weight Orderedd | |
| Weight Shipped | 51 | 17 | R | N | Weight Shippedd | |
| U/M Number | 68 | 1 | N | N | Unit of measure # for Item - (Zero means standard if no ANSIUM is given) Use only values 0-4. If both ANSIUM and this field are specified, this field will take precedence | 810.IT103.355 |
| ANSIUM | 69 | 2 | A | N | ANSI Unit of measurement | 810.IT103.355 |
| Price | 71 | 17 | R | N | Price for one. If an override price is present, that value will be given here. | 810.IT104.212 |
| Line Description | 88 | 35 | A | N | Line Description | 810.PID105.352 |
| Taxable | 123 | 1 | A | Y | Was tax charged on this line item? (Y/N)) | |
| Reseller Taxable | 124 | 1 | A | Y | Does reseller charge tax for this item? (Y/N)) | |
| Tax Amount | 125 | 17 | R | N | How much tax was charged for this linee | |
| Custom Retail | 142 | 17 | R | N | Provides a customized retail amount if this product is to be resold.. | |
| Pack Description | 159 | 10 | A | N | Describes how this product is packedd | |
| Pack Qty | 169 | 5 | N | N | How many single units are in the shipped unitt | |
| Allowance | 174 | 17 | R | N | How much price allowance per unit was awarded. | 810.SAC05.610 |
| Order # | 191 | 7 | N | Y | CV1's Order Number | 810.BIG02.76 |
| Line # | 198 | 5 | N | N | Line # of the seller’s invoice | 810.IT101.350 |
| Purchase Order # | 203 | 15 | A | N | Purchaser’s PO # | 810.BIG04.324 |
| Remote Order ID | 218 | 15 | A | N | ID of remote order that caused this live order to be created.. | |
| Secondary Line # | 233 | 3 | N | N | Secondary Line # of the seller's invoice.. | |
| Transaction Terminator Symbol | 237 | 2 | A | Y | Literal "//"" | |
| Total Lengthh | 237 |