Vermont Information Processing Export Format

You can export the following files for Vermont Information Processing (VIP) in Generate Data Extract.

Each of these files includes, header, detail, and trailer records. The following tables list the format for these files.

Distributor Salesperson Header Record

Field

Position

Maximum Length

Type

Required

Description

RECID

1-2

2

A

Yes

This field is the record identifier. The value of this field is 07.

SUPPID

3-5

3

A

Yes

This field is the supplier ID stored in suppname.beverage-extract-supplier-id.

DISTID

6-13

8

A

Yes

This field is the distributor ID stored in suppname.distributor-id.

DISTGLN

14-26

13

N

No

This field is the distributor GLN. The value of this field is 0000000000000.

ISVID

27-30

4

A

Yes

This field is the ISV ID entered in the ISV ID field when you export the file.

FILEVER

31-33

3

A

Yes

This field is the version number. The value of this field is 030 to indicate version 3.0.

CRTDATE

34-41

8

N

Yes

This field is the file creation date in the format YYYYMMDD. This is generated from the system date.

CRTTIME

42-47

6

N

Yes

This field is the file creation time in the format HHMMSS. This is generated from the system time.

Distributor Salesperson Detail Record

Field

Position

Maximum Length

Type

Required

Description

RECID

1-2

2

A

Yes

This field is the record identifier. The value of this field is 27.

SUPPID

3

3

A

Yes

This field is the supplier ID stored in suppname.beverage-extract-supplier-id.

SMDIST

6-13

8

A

Yes

This field is the distributor ID stored in suppname.distributor-id.

SMSLSMN#

14-18

5

A

Yes

This field is the distributor sales representative code stored in arinvitm.sales-agent, or if that is blank, in arinvhdr.sales-agent

SMNAME

19-53

35

A

Yes

This field is the distributor sales representative first and last name stored in sales-agent.first-name and sales-agent.last-name.

SMLEVEL1

54-58

5

A

No

This is the sales organization code one level above the sales representative (i.e., a team manager).

SML1NAME

59-93

35

A

No

This is the sales organization name one level above the sales representative (i.e., a team manager).

SMLEVEL2

94-98

5

A

No

This is the sales organization code two levels above the sales representative (i.e., a team manager).

SML2NAME

99-133

35

A

No

This is the sales organization name two levels above the sales representative (i.e., a team manager).

SMLEVEL3

134-138

5

A

No

This is the sales organization code three levels above the sales representative (i.e., a team manager).

SML3NAME

139-173

35

A

No

This is the sales organization name three levels above the sales representative (i.e., a team manager).

SMDIV

174-178

5

A

No

This is the distributor sales division code.

SMDIVNAME

179-213

35

A

No

This is the distributor sales division description.

SMEND

214

1

A

Yes

This field identifies the end of the record. The value of this field is X.

Distributor Salesperson Trailer Record

Field

Position

Maximum Length

Type

Required

Description

RECID

1-2

2

A

Yes

This field is the record identifier. The value of this field is 93.

SUPPID

3-5

3

A

Yes

This field is the supplier ID stored in suppname.beverage-extract-supplier-id.

DISTID

6-13

8

A

Yes

This field is the distributor ID stored in suppname.distributor-id.

DISTGLN

14-26

13

N

No

This field is the distributor GLN. The value of this field is 0000000000000.

ISVID

27-30

4

A

Yes

This field is the ISV ID entered in the ISV ID field when you export the file.

FILEVER

31-33

3

A

Yes

This field is the version number. The value of this field is 030 to indicate version 3.0.

TOTREC

34-40

7

N

Yes

This field is the total number of detail records, which is the total number of customers for the selected supplier.

Inventory Header Record

Field

Position

Maximum Length

Type

Required

Description

RECID

1-2

2

A

Yes

This field is the record identifier. The value of this field is 03.

SUPPID

3-5

3

A

Yes

This field is the supplier ID stored in suppname.beverage-extract-supplier-id.

DISTID

6-13

8

A

Yes

This field is the distributor ID stored in suppname.distributor-id.

DISTGLN

14-26

13

N

No

This field is the distributor GLN. The value of this field is 0000000000000.

ISVID

27-30

4

A

Yes

This field is the ISV ID entered in the ISV ID field when you export the file.

INDATE

31-38

8

D

Yes

This field is the inventory date in the format YYYYMMDD.

FILEVER

39-41

3

A

Yes

This field is the version number. The value of this field is 030 to indicate version 3.0.

CRTDATE

42-49

8

N

Yes

This field is the file creation date in the format YYYYMMDD. This is generated from the system date.

CRTTIME

50-55

6

N

Yes

This field is the file creation time in the format HHMMSS. This is generated from the system time.

Inventory Detail Record

Field

Position

Maximum Length

Type

Required

Description

RECID

1-2

2

A

Yes

This field is the record identifier. The value of this field is 22.

SUPPID

3-5

3

A

Yes

This field is the supplier ID stored in suppname.beverage-extract-supplier-id.

DISTID

6-13

8

A

Yes

This field is the distributor ID stored in suppname.distributor-id.

DISTGLN

14-26

13

N

No

This field is the distributor GLN. The value of this field is 0000000000000.

INITEM

27-36

10

A

Yes

This field is the supplier product code stored in supp-prod.supplier-prod-code.

INTRANS

37-38

2

N

Yes

This field is the inventory transaction code, which is one of the following values:

  • 10 - Ending inventory equal to inventory quantity on hand for the each day in a date range

  • 20 - Total receipts for a date range, excluding transfer receipts

  • 21 - Total transfer receipts by purchase order ship-to location

  • 22 - Transfer out transactions by order shipping location

  • 30 - Supplier returns; total quantity of invoiced sales orders for customers that have the suppname.invoice-cust-key connected to the supplier of the record.

  • 40 - Breakage; total inventory adjustments for a date range (only for inventory adjustment codes set up as breakages in Data Extract Selection Maintenance)

  • 41 - Total pick demands for samples for a date range

  • 99 - All inventory adjustments except for breakages

INDATE

39-46

8

D

Yes

This field is the date when the transaction was recorded in the format YYYYMMDD.

INQTY

47-56

10

S

Yes

This field is the transaction quantity, which is the quantity of the product for the transaction type.

INUOM

57

1

A

Yes

This field is the case unit of measure that the indicated quantity represents.

INEOM

58

1

A

Yes

This field is an end of month indicator. The value of this field is N.

INPOID

59-68

10

A

No

This field is for a supplier supplied purchase order identifier (required for supplier order receipts only). This field is po-header.supp-order-num..

INDISTNAME

69-103

35

A

Yes, only for transfer transactions

This field is the name of the distributor the product was transferred to or from.

If the INTRANS field is 21, this is the location name of the transfer-out location (the sales order shipping location).

If the INTRANS field is 22, this is the location name of the transfer-in location (the purchase order ship-to location).

If the INTRANS field is any other value, this field is blank.

INDISTST

104-105

2

A

Yes, only for transfer transactions

This field is the two-digit USPS state ID of where product was transferred to or from. This is the state of the physical address of the location.

DISTITEM

106-115

10

A

Yes

This field is the distributor product code stored in product.product-code.

INITMSTS

116

1

A

Yes

This field is the status of the product for this distributor warehouse. The value of this field is A if the product is active or I if the product is inactive.

INREPACK

117

1

A

Yes

This field indicates whether the record was repacked (changed from the original configuration). The value of this field is Y if the record was repacked. This defaults to N.

INEND

118

1

A

Yes

This field identifies the end of the record. The value of this field is X.

Inventory Trailer Record

Field

Position

Maximum Length

Type

Required

Description

RECID

1-2

2

A

Yes

This field is the record identifier. The value of this field is 97.

SUPPID

3-5

3

A

Yes

This field is the supplier ID stored in suppname.beverage-extract-supplier-id.

DISTID

6-13

8

A

Yes

This field is the distributor ID stored in suppname.distributor-id.

DISTGLN

14-26

13

N

No

This field is the distributor GLN. The value of this field is 0000000000000.

ISVID

27-30

4

A

Yes

This field is the ISV ID entered in the ISV ID field when you export the file.

FILEVER

31-33

3

A

Yes

This field is the version number. The value of this field is 030 to indicate version 3.0.

TOTREC

34-40

7

N

Yes

This field is the total number of detail records (total transactions per supplier).

TOTQTY

41-54

14

S

Yes

This field is the total of all quantities in detail records, calculated as the sum of all INQTY fields for inventory detail records. If this is less than zero, the negative sign is in the first position of the field.

Item Cross-Reference Header Record

Field

Position

Maximum Length

Type

Required

Description

RECID

1-2

2

A

Yes

This field is the record identifier. The value of this field is 04.

SUPPID

3-5

3

A

Yes

This field is the supplier ID stored in suppname.beverage-extract-supplier-id.

DISTID

6-13

8

A

Yes

This field is the distributor ID stored in suppname.distributor-id.

DISTGLN

14-26

13

N

No

This field is the distributor GLN. The value of this field is 0000000000000.

ISVID

27-30

4

A

Yes

This field is the ISV ID entered in the ISV ID field when you export the file.

FILEVER

31-33

3

A

Yes

This field is the version number. The value of this field is 030 to indicate version 3.0.

CRTDATE

34-41

8

N

Yes

This field is the file creation date in the format YYYYMMDD. This is generated from the system date.

CRTTIME

42-47

6

N

Yes

This field is the file creation time in the format HHMMSS. This is generated from the system time.

Item Cross-Reference Detail Record

Field

Position

Maximum Length

Type

Required

Description

RECID

1-2

2

A

Yes

This field is the record identifier. The value of this field is 24.

SUPPID

3-5

3

A

Yes

This field is the supplier ID stored in suppname.beverage-extract-supplier-id.

DISTID

6-13

8

A

Yes

This field is the distributor ID stored in suppname.distributor-id.

DISTGLN

14-26

13

N

No

This field is the distributor GLN. The value of this field is 0000000000000.

INSITEM

27-36

10

A

Yes

This field is the supplier product code stored in supp-prod.supplier-prod-code.

INDITEM

37-46

10

A

Yes

This field is the distributor product code stored in product.product-code.

INDDESC

47-106

60

A

Yes

This field is the distributor product description stored in product.description, or if that is blank, the product name stored in product.product-name.

INGTIN

107-120

14

N

No

This field is the case GTIN (SCC). This field is all zeros.

INACT

121

1

A

Yes

This field indicates if the product is an active product. If product.active=Yes, this value is A. If it is No, this value is I.

SELLUNIT

122-124

3

N

Yes

This field is the selling units per case. This is the bottles per case.

UNIT

125-127

3

N

Yes

This field is the units per case. This is the bottles per case.

IXDITMSIZ

128-137

10

A

No

This field is the distributor product size description (bottles per case).

EXAMPLE If there are six bottles in a case and each bottle is .75 L, the value of this field is 6/0.75L.

IXDITMALC

138-142

5

N

No

This field is the distributor product alcohol percentage.

IXVINTAGE

143-146

4

A

No

This field is the vintage of the product either expressed as the year of manufacture or age.

IXGTINR

147-160

14

N

No

This is the UPC assigned to the retail package of the product, which is stored in product-um.upc-code, or if that is blank, in product.upc-code.

IXREPACK

161

1

A

Yes

This field indicates whether the record was repacked (changed from the original configuration). The value of this field is Y if the record was repacked. This defaults to N.

IXEND

162

1

A

Yes

This field identifies the end of the record. The value of this field is X.

Item Cross-Reference Trailer Record

Field

Position

Maximum Length

Type

Required

Description

RECID

1-2

2

A

Yes

This field is the record identifier. The value of this field is 96.

SUPPID

3-5

3

A

Yes

This field is the supplier ID stored in suppname.beverage-extract-supplier-id.

DISTID

6-13

8

A

Yes

This field is the distributor ID stored in suppname.distributor-id.

DISTGLN

14-26

13

N

No

This field is the distributor GLN. The value of this field is 0000000000000.

ISVID

27-30

4

A

Yes

This field is the ISV ID entered in the ISV ID field when you export the file.

FILEVER

31-33

3

A

Yes

This field is the version number. The value of this field is 030 to indicate version 3.0.

TOTITEM

34-40

7

N

Yes

This field is the total number of supplier products per supplier.

Retail Outlet Header Record

Field

Position

Maximum Length

Type

Required

Description

RECID

1-2

2

A

Yes

This field is the record identifier. The value of this field is 01.

SUPPID

3-5

3

A

Yes

This field is the supplier ID stored in suppname.beverage-extract-supplier-id.

DISTID

6-13

8

A

Yes

This field is the distributor ID stored in suppname.distributor-id.

DISTGLN

14-26

13

N

No

This field is the distributor GLN. The value of this field is 0000000000000.

ISVID

27-30

4

A

Yes

This field is the ISV ID entered in the ISV ID field when you export the file.

FILEVER

31-33

3

A

Yes

This field is the version number. The value of this field is 030 to indicate version 3.0.

FILETYPE

34

1

A

Yes

This field indicates if the file is a complete file or updates only. The value of this field is A.

CRTDATE

35-42

8

N

Yes

This field is the file creation date in the format YYYYMMDD.

CRTTIME

43-48

6

N

Yes

This field is the file creation time in the format HHMMSS (military time).

Retail Outlet Detail Record

Field

Position

Maximum Length

Type

Required

Description

RECID

1-2

2

A

Yes

This field is the record identifier. The value of this field is 20.

SUPPID

3-5

3

A

Yes

This field is the supplier ID stored in suppname.beverage-extract-supplier-id.

DISTID

6-13

8

A

Yes

This field is the distributor ID stored in suppname.distributor-id.

DISTGLN

14-26

13

N

No

This field is the distributor GLN. The value of this field is 0000000000000.

ROCUST

27-41

15

A

Yes

This field is the retail outlet customer code, stored in custname.cust-code.

RODBA

42-76

35

A

Yes

This field is the name by which the customer does business stored in custname.cust-name.

ROLNAM

77-111

35

A

No

This field is the licensee name of the customer stored in custname.alt-search.

ROADDR1

112-146

35

A

Yes

This field is the first line of the customer's street address stored in custname.address-1.

ROADDR2

147-166

20

A

No

This field is the second line of the customer's street address stored in custname.address-2.

ROLICENSE

167-181

15

A

No

This field is the license number of the customer stored in customer user-defined field 1.

ROCITY

182-211

30

A

Yes

This field is the city of the customer's address stored in custname.city.

ROSTATE

212-213

2

A

Yes

This field is the state of the customer's address stored in custname.state.

ROZIP9

214-222

9

A

No

This field is the postal code of the customer's address stored in custname.postal-code.

ROCTRY

223-225

3

A

No

This field is the country of the customer's address stored in custname.country.

ROPHONE

226-245

20

N

No

This field is the customer's phone number stored in custname.phone.

ROCHN

246-255

10

A

Yes

This field is the customer's chain code stored in customer user-defined field 3.

ROCHN2

256-265

10

A

No

This field is the customer's chain code 2. This field is blank.

ROCOT

266-267

2

A

Yes

This field is the customer's channel stored in customer user-defined field 5.

ROFWN

268

1

A

No

This field is used to indicate the customer is a fine wine store. This field is blank.

ROCSTS

269

1

A

No

This field is the customer's chain status. If the ROCHN field is blank, the value of this field is I to indicate the customer is an independent store. If the ROCHN field is not blank, the value of this field is C to indicate the customer is a chain store.

RODISP

270-271

2

A

No

This field is the customer's display account. The value of this field is Y if Y is stored in custname.user-defined-6. Otherwise, the value of this field is N.

ROETHN

272-273

2

A

No

This field is the customer's patron ethnicity. This field is blank.

ROIVOL

274

1

A

Yes

This field is the industry volume stored in customer user-defined field 7.

ROLIFE

275

1

A

No

This field is the customer's patron lifestyle. This field is blank.

ROOCC

276-277

2

A

No

This field is the customer's patron occupation. This field is blank.

ROPAGE

278-279

2

A

No

This field is the customer's patron age. This field is blank.

ROPTYPE

280

1

A

No

This field is the type of package sold (1=draft only, 2=package and draft, 3=package only). This field is blank.

ROWMVT

281-282

2

A

No

This field is the customer's wine movement. This field is blank.

ROSMVT

283-284

2

A

No

This field is the customer's spirit movement. This field is blank.

ROMMVT

285-286

2

A

No

This field is the customer's malt movement. This field is blank.

ROSELL

287

1

A

No

This field is the outlet sell type (1=driver sell, 2=presell, 3=tel-sell, 4=house account. This field is blank.

ROSM1

288-292

5

A

Yes

This field is the primary sales route for the customer stored in custname.default-sales-agent.

ROSM2

293-297

5

A

No

This field is the secondary sales route for the customer. This field is blank..

ROSTORE

298-307

10

A

Yes

This field is the store number. If the ROCSTS field is C, the value of this field is stored in custname.store-id. Otherwise, this field is blank.

ROSTS

308

1

A

Yes

This field is the customer's retail outlet status (A=active, I=Inactive, Closed, O=Out of business). If Custname.active is Yes, then the value of this field is A. Otherwise, the value of this field is I.

ROLICTYPE

309

1

A

No

This field is the type of alcohol license for the retail outlet that dictates what type of alcoholic beverages they can carry. This is one of the following values:

  • A - Can serve all alcohol types

  • B - Can only sell beer and malt-based RTD

  • C - Can only sell beer and malt-based RTD of 3.2% ABW

  • D - Can only sell beer and malt-based RTD up to and including high alcohol products with > 8-10%

  • E - Licensed for all but spirits-based products

  • F - Licensed for all but spirits-based products including high alcohol products with > 8-10%

  • G - Licensed for low alcohol beer and malt-based RTD and wine

  • H - Licensed for all but high alcohol, malt-based products

  • I - Licensed for all but regular and high alcohol, malt-based products

  • J - Can only sell wine

  • K - Can only sell wine and spirits (no malt-based products)

  • L - Can only sell spirits

  • Z - No license to sell alcohol

NOTE This information should be stored in customer user-defined field 10.

ROBUYER

310-344

35

A

No

This field is the buyer name of the contact at the retail outlet.

ROWHSE

345-352

8

A

Yes

This field is the distributor warehouse to which the retail outlet is assigned. This should be cross referenced to a valid distributor ID (ship-to ID) for each supplier. This field is stored in suppname.distributor-id.

ROEND

353

1

A

Yes

This field identifies the end of the record. The value of this field is X.

Retail Outlet Trailer Record

Field

Position

Maximum Length

Type

Required

Description

RECID

1-2

2

A

Yes

This field is the record identifier. The value of this field is 99.

SUPPID

3-5

3

A

Yes

This field is the supplier ID stored in suppname.beverage-extract-supplier-id.

DISTID

6-13

8

A

Yes

This field is the distributor ID stored in suppname.distributor-id.

DISTGLN

14-26

13

N

No

This field is the distributor GLN. The value of this field is 0000000000000.

ISVID

27-30

4

A

Yes

This field is the ISV ID entered in the ISV ID field when you export the file.

FILEVER

31-33

3

A

Yes

This field is the version number. The value of this field is 030 to indicate version 3.0.

TOTREC

34-40

7

N

Yes

This field is the total number of detail records, which is the total number of customers for the selected supplier.

Sales Header Record

Field

Position

Maximum Length

Type

Required

Description

RECID

1-2

2

A

Yes

This field is the record identifier. The value of this field is 02.

SUPPID

3-5

3

A

Yes

This field is the supplier ID stored in suppname.beverage-extract-supplier-id.

DISTID

6-13

8

A

Yes

This field is the distributor ID stored in suppname.distributor-id.

DISTGLN

14-26

13

N

No

This field is the distributor GLN. The value of this field is 0000000000000.

ISVID

27-30

4

A

Yes

This field is the ISV ID entered in the ISV ID field when you export the file.

FILEVER

31-33

3

A

Yes

This field is the version number. The value of this field is 051 to indicate version 5.1.

IPFLAG

34

1

A

Yes

This field is the invoice date or posting date flag. The value of this field is I.

STRDATE

35-42

8

N

Yes

This field is the posting date in the format YYYYMMDD. The value of this field is stored in arinvhdr.ref-date.

CRTDATE

43-50

8

N

Yes

This field is the file creation date in the format YYYYMMDD. This is generated from the system date.

CRTTIME

51-56

6

N

Yes

This field is the file creation time in the format HHMMSS. This is generated from the system time.

Sales Detail Record

Field

Position

Maximum Length

Type

Required

Description

RECID

1-2

2

A

Yes

This field is the record identifier. The value of this field is 21.

SUPPID

3-5

3

A

Yes

This field is the supplier ID stored in suppname.beverage-extract-supplier-id.

DISTID

6-13

8

A

Yes

This field is the distributor ID stored in suppname.distributor-id.

RSOUTGLN

14-26

13

N

No

This field is the distributor GLN. The value of this field is 0000000000000.

RSIDAT

27-34

8

N

Yes

This field is the invoice date stored in arinvhdr.ref-date.

RSINV#

35-59

25

A

Yes

This field is the invoice number stored in arinvhdr.ref-num.

RSCUST

60-74

15

A

Yes

This field is the customer code stored in custname.cust-code.

RSITEM

75-84

10

A

Yes

This field is the supplier product code stored in supp-prod.supplier-prod-code. If there is no supplier product code, this field is blank.

RSQTY

85-91

7

S

Yes

This field is the quantity delivered (product quantity sold). If this field is less than zero, the negative sign is in the first position of the field.

RSUOM

92

1

A

Yes

This field is the quantity unit of measure. The value of this field is B for any unit of measure that is equal to a single unit, and C for any other unit of measure.

RSFRONT

93-101

9

N

Yes

This field is the frontline unit price (price without adjustments). This is an absolute value for all transactions, and has two implied decimal places.

RSNET

102-110

9

N

Yes

This field is the price per unit recorded for the sale (including any discounts or other adjustments). This is an absolute value for all transactions, and has two implied decimal places.

DISTITEM

111-120

10

A

Yes

This field is the distributor product code stored in product.product-code.

RSDEPOS

121-127

7

N

Yes

This field is the deposit amount per unit. This is either the manufactured deposit (i.e., keg deposit), or the deposit imposed by the state (i.e., bottle deposit). This has four implied decimal places.

RSCRV

128-134

7

N

No

This field is the California Redemption Value (CRV) per unit that is included in the net price. If it is not part of the reported price (RSNET and RSTOTSLS), it is zero. This has four implied decimal places.

RSLOCTAX

135-141

7

 

No

This field is the municipal or county tax imposed on the product that is included in the net price. If it is not part of the reported price (RSNET and RSTOTSLS), it is zero. This has four implied decimal places.

RSADDCHG

142-148

7

N

No

This field is the additional charges (i.e., split case charge, fuel charge, etc.) that is included in the net price. If it is not part of the reported price (RSNET and RSTOTSLS), it is zero. This has four implied decimal places.

RSSLSREPID

149-153

5

A

Yes

This field is the sales representative responsible for the sale to this outlet for this product. This is stored in arinvitm.sales-agent, or if that is blank, arinvhdr.sales-agent.

RSREPACK

154

1

A

Yes

This field indicates whether the record was repacked (changed from the original configuration). The value of this field is Y if the record was repacked. This defaults to N.

RSWHSE

155-162

8

A

Yes

This field is the distributor warehouse ID for the sale stored in suppname.distributor-id.

RSTOTSLS

163-175

13

N

Yes

This field is the extended net price (including any discounts). This typically is the total of RSNET * RSQTY. This has four implied decimal places.

RSTRTYPE

176

1

A

No

This field is the type of transaction, as follows:

  • R - Retail sales (default)

  • S - Supplier samples

  • B - Warehouse breakage

  • T - Warehouse/Distributor Transfer

  • E - Revenue Adjustment - Current Month

  • V - Revenue Adjustment - Following Month

RSDISCID

177-191

15

A

No

This field is the distributor internal identifier for the discount program attributed to the invoice.

RSPRGRP

192-206

15

A

No

This field is the distributor internal identifier for the discount group program attributed to the invoice. Discount groups may be used for grouping records together to meet quantity discount levels.

RSPRSUPP

207-221

15

A

No

This field is the supplier originated identifier for the price promotion program attributed to this invoice. This would apply when a distributor updated their system with the identifier provided by the supplier for a specific program.

RSDISC

222-230

9

N

No

This field is the extended distributor amount of price support per line (on invoice discount less supplier DA, off invoice RIPS less supplier DA). For sales records with no price support, the value is zero. Price adjustments per line are from order entry. This has two implied decimal places.

RSSUPPDA

231-239

9

N

No

This field is the extended supplier amount of price support per line (depletion allowance), stored in arinvitm.ship-debit-amt. For sales records with no price support, or if the distributor does not calculate supplier rebates, this value is zero. This is an absolute value. This has two implied decimal places.

RSSPLIT

240-243

4

N

No

This field is the split case charge per unit that is not included in the price. If this is included in the value for the RSNET field, this value is reported in the RSADDCHG field. This has two implied decimal places.

RSCOMBO

244

1

A

No

This field indicates if the product was sold as part of a distributor-created package of combined products (a combo pack). The value of this field is Y if it is a combo, or N if it is not.

RSFREE

245

1

A

No

This field indicates if the product was free goods. The value of this field is Y if it was free goods, or N if it was not.

RSDUTY

246

1

A

No

This field indicates if the product was sold as a duty free product. The value of this field is Y if was duty free, or N if it was not.

RSORDDT

247-254

8

N

No

This field is the date the product was ordered.

RSORDQTY

255-261

7

S

No

This field is the quantity of the original order.

RSORDUOM

262

1

A

No

This field is the unit of measure of the original order, as follows:

  • B - Bottle

  • C - Case

RSLINE#

263-268

6

N

Yes

This field is the line number of the record on the invoice stored in arinvitm.sequence.

RSREFINV

269-293

25

A

No

This field is the reference invoice number. For cumulative and retroactive discount markets, this refers to the new invoice creating additional discounts on previous invoices. This is also used as a reference for cancellations, returns, and credits.

RSFRNTEXT

294-306

13

N

Yes

This field is the extended front line price to four decimals.

RSPERIOD

307-312

6

N

Yes

This field is the depletion period for the invoice in YYYYMM format.

RSEND

313

1

A

Yes

This field identifies the end of the record. The value of this field is X.

Sales Trailer Record

Field

Position

Maximum Length

Type

Required

Description

RECID

1-2

2

A

Yes

This field is the record identifier. The value of this field is 98.

SUPPID

3-5

3

A

Yes

This field is the supplier ID stored in suppname.beverage-extract-supplier-id.

DISTID

6-13

8

A

Yes

This field is the distributor ID stored in suppname.distributor-id.

DISTGLN

14-26

13

N

No

This field is the distributor GLN. The value of this field is 0000000000000.

ISVID

27-30

4

A

Yes

This field is the ISV ID entered in the ISV ID field when you export the file.

FILEVER

31-33

3

A

Yes

This field is the version number. The value of this field is 051 to indicate version 5.1.

TOTREC

34-40

7

N

Yes

This field is the total number of detail records, which is the total number of invoice line items for each supplier and the date.

TOTQTY

41-51

11

S

Yes

This field is the total quantity of all products sold for the supplier and the date, which is equal to the sum of all RSQTY field quantities in detail records. If this field is less than zero, the negative sign is in the first position of the field.

Export Format Notes