You can export the following files for Vermont Information Processing (VIP) in Generate Data Extract.
Distributor Salesperson - This file contains sales representative information. These files are named Mxxxxxyyy.SLM where xxxxx is the unique 5-character SRS ID and yyy is a sequential 3-digit number.
Inventory - This file contains beginning and ending quantity on hand for products and the related transactions. These files are named Ixxxxxyyy.INV where xxxxx is the unique 5-character SRS ID and yyy is a sequential 3-digit number.
Item Cross-Reference - This file contains supplier production information. These files are named Cxxxxxyyy.ITM where xxxxx is the unique 5-character SRS ID and yyy is a sequential 3-digit number.
Retail Outlet - This file contains customer information for customers who could carry a supplier's product. These are customers with license types (wine, spirits, and/or beer) that match supplier license types. These files are named Oxxxxxyyy.OUT where xxxxx is the unique 5-character SRS ID and yyy is a sequential 3-digit number.
Sales - This file contains product sales from suppliers to customers. These files are named Sxxxxxyyy.SLS where xxxxx is the unique 5-character SRS ID and yyy is a sequential 3-digit number.
Each of these files includes, header, detail, and trailer records. The following tables list the format for these files.
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. |
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. |
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. |
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. |
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:
|
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. |
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. |
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. |
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. |
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. |
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). |
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:
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. |
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. |
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. |
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:
|
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:
|
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. |
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. |
The Type columns in the tables above indicate the type of data for each field. The following types are used:
A - Character
D - Date
N - Numeric
S - Signed (numeric that may have a negative sign)
The last two or four digits of decimal format fields are after the decimal point (e.g., 123.45 displays as 12345 in the exported file).
All sales and inventory movement quantities are reported in cases and/or fractions of cases. The bottle unit of measure is the base/stocking unit of measure. Typically, the only other unit of measure for the product is the case unit of measure, but if there are more than two units of measure for a product, the case unit of measure is determined as follows:
If there is a default package unit of measure set up (package unit of measure in Product Location Maintenance), it is the case unit of measure.
If the default selling unit of measure is not the same as the base unit of measure, it is the case unit of measure.
The Maximum Length columns in the tables above list the maximum number of characters or numbers that each field can contain. Zeros are added to numeric format fields that are not the maximum length (e.g., if the maximum length is 9 and a value is 9870, the field displays as 000009870 in the exported file).