Show TOC

Background documentationReceiving File Format

 

File: [SSSSSSNNNN.RCV]1

Store Manager application: Place files in the dnload subdirectory of the Xpress Server.

This file may contain multiple documents. A document transaction consists of one header record (denoted by the record type H) and multiple detail records (denoted by the record type D).

Field Number and Name

Type/Length

Column

Possible Values

1 Record Type *

String 1

1 - 1

H

2 Document No.*

String 20

2 - 21

3 Purchase Order No.

String 20

22 - 41

4 Vendor No./Invoice #

String 9

42 - 50

5 Filler

String 1

51 - 51

6 Receive Type

String 2

52 - 53

User defined

7 Ship Type

String 2

54 - 55

User defined

8 No. of Cartons/Cases

Decimal 2.0

56 - 57

9 Total Units

Decimal 4.0

58 - 61

10 Vendor-SKU Flag

String 1

62 - 62

Not used.

11 Note

String 40

63 -102

12 Auto Receive All

Decimal 1.0

103 - 103

Automatically receive all items and complete document.

1 – Enable

0 - Disable

13 Auto Delete PO Document

Decimal 1.0

104 - 104

Automatically delete the Purchase Order document with the number specified in field number 3.

1 – Enable

0 – Disable

14 Reference #

String 20

105 - 24

15 Ship Date

Decimal 8.0

125 -132

YYYYMMDD

16 Expected Delivery Date

Decimal 8.0

133 -140

YYYYMMDD

17 Filler

String 1

141 - 141

Total Header Record bytes: 141

Field Number and Name

Type/Length

Column

Possible Values

1 Record Type *

String 1

1 - 1

D

2 PLU *

String 18

2 - 19

3 Quantity 1 *

Decimal 3.3

20 - 25

4 Pkg Size

Decimal 4.0

26 - 29

Not used.

5 Filler

String 2

30 - 31

6 Cost

Decimal 4.2

32 - 37

Not used.

7 Quantity 2

Decimal 6.3

38 - 46

Same as field 3 except this filed accommodates quantities up to a maximum of 999,999.000.

8 Actual Quantity

Decimal 6.3

47 - 55

Actual quantity received.

Total Detail Record bytes: 55