Purchase Order       Version 2.00 6/29/99

Keyword: PURCHORD

Format   : Transactional

Usage     : Header Record.  Used to send a Purchase Order to a supplier.

 Note       :  The only difference between version 2.00 and 1.00 is that the Dates in version 2.00 were converted to Y2K-compliant (YYYYMMDD) and a case count was added to the trailer.  Only these two formats changed so other Purchase Order components (such as message and detail lines) are not duplicated in this document.  For these, version 2.00 are the same as version 1.00.

 

Description

Len

Mask

Fmt

Req

Format/Comments

Record Type

1

 

A

Y

“H” = Header

PO Number

6

999999

N

Y

CV1’s PO Number

Date Placed

8

99999999

N

Y

Date the PO was created in the CV1 system. (YYYYMMDD)

Ship Date

8

 

N

N

Ship Date (YYYYMMDD)

Vendor Number

6

 

A

Y

ID of seller in purchaser’s system

Backorder Code

1

 

A

N

Buyer will accept a backorder (Y/N)

Freight Terms

1

 

A

N

”C”=Collect, “P”=Prepaid

Backhaul

1

 

A

N

Backhaul (Y/N)

Seller’s Name

35

 

A

N

Seller’s Name

Terms Description

25

 

A

N

Terms Description

Terms Percent

5

 

R

N

Terms Percentage (10% is written as .10)

Terms Discount Days

3

 

N

N

Terms Discount Days

Terms Late Days

3

 

N

N

Terms Late Days

Buyer Name

25

 

A

N

Buyer Name

Customer Number

30

 

A

N

ID of purchaser in seller’s system

Delivery Date

8

 

N

N

Delivery Date (YYYYMMDD)

Warehouse Code

6

 

A

N

Warehouse being delivered to

Ship-to Name

35

 

A

N

Name of the company the goods are being shipped to

Duns + 4

13

 

A

N

Duns# plus 4 additional bytes.

Total Length

220

 

 

 

 

 


 

Keyword: PURCHORD

Format   : Transactional

Usage     : Message Record.  Used to send a Purchase Order message attachment to a supplier.

 

Description

Len

Mask

Fmt

Req

Format/Comments

Record Type

1

 

A

Y

 “M” = PO Message

Message

70

 

A

N

Message for this PO

Total Length

71

 

 

 

 

 

 

 

Keyword: PURCHORD

Format   : Transactional

Usage     : Detail Record.  Used to send a Purchase Order line-item detail information to a supplier.

Description

Start Position Ending Position

Length

Mask

Type

Required?

Format/Comments

Record Type

1 1

1

 

A

Y

“D” = PO Detail Line

Line Number

2 6

5

99999

N

Y

Detail line number

Purchaser's Item #

7 12

6

999999

N

Y

Purchaser's Item reference number

Quantity Ordered

13 19

7

9999999

N

Y

Quantity Ordered

Unit Weight

20 26

7

 

R

N

Unit weight

Extended Weight

27 35

9

 

R

N

Extended weight

Unit Cost

36 44

9

 

R

N

Unit Cost

Item Description

45 79

35

 

A

N

Description of the item

ANSI Unit of measure

80 81

2

 

A

N

ANSI Unit of measure

Manufacturer Part #

82 96

15

 

A

N

Manufacturer's part #

UPC #

97 111

15

999999999999999

N

N

UPC Number

Deal Number

112 119

8

 

A

N

If the buyer is getting a special discount, this is the seller’s deal #.

Allowance Amount

120 128

9

9999999v99

R

N

If buyer gets discount, this is how much.

Seller's Item Number

129 143 15

 

A

N

Seller's item reference number

Total Length

   

143

 

 

 

 

 


Keyword: PURCHORD

Format   : Transactional

Usage     : Trailer Record.  Used to send a Purchase Order summary information to a supplier.

 

Description

Len

Mask

Fmt

Req

Format/Comments

Record Type

1

 

A

Y

 “T” = PO Trailer Line

Line Count

5

99999

N

N

How many lines in this PO?

Total Weight

8

99999999

N

N

How much does the total order weigh?

Total Qty

7

9999999

N

N

How many units were ordered (case count)

Total Length

21