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