7 | ALM Invoice File Specification

This article contains file specs and a sample file for the Metcash HOST Interface.

HEADER:

FD71747 00000083668 GRACEMERE HOTEL OLD CAPRICORN HWY GRACEMERE 4702008366887274 04082020

	ALM_HEAD_REC_TYPE = 1	"FD"
1	ALM_HEAD_INV_NUM = 2	"71747"
2	ALM_HEAD_CLAIM = 3	""
3	ALM_HEAD_PAGENUM = 4	"000"
4	ALM_HEAD_LINENUM = 5	"00"
5	ALM_HEAD_CUST_CODE = 6	"083668"
6	ALM_HEAD_ORD_NUM = 7	""
7	ALM_HEAD_STORE_NAME = 8	"GRACEMERE HOTEL"
8	ALM_HEAD_STREET = 9	"OLD CAPRICORN HWY"
9	ALM_HEAD_SUBURB = 10	"GRACEMERE"
10	ALM_HEAD_POSTCODE = 11	"4702"
11	ALM_HEAD_DEBTOR_CODE = 12	"0083668"
12	ALM_HEAD_LICENSE = 13	"87274"
13	ALM_HEAD_BONDNUM = 14	""
14	ALM_HEAD_MESSAGE = 15	""
15	ALM_HEAD_INV_DATE = 16	"04082020"
16	ALM_HEAD_ABN = 17	""
17	ALM_HEAD_FILLER = 18	""

LINE:

FD71747 0010108366800000000047170372SOMERSBY CDR APL 4.5% 330ML8 566027566027002400001680000168 029000100000000000370300010740000478000000005255000036785 000007518 000003346 0000000000000554 932998201683209329982016856C

1	ALM_LINE_REC_TYPE = 1	"FD"
2	ALM_LINE_INV_NUM = 2	"71747"
3	ALM_LINE_CLAIM = 3	""
4	ALM_LINE_PAGENUM = 4	"001"
5	ALM_LINE_LINENUM = 5	"01"
6	ALM_LINE_CUST_CODE = 6	"083668"
7	ALM_LINE_PROD_STATUS = 7	"0"
8	ALM_LINE_AVAIL_DATE = 8	"000000"
9	ALM_LINE_GROUP = 9	"00471"
10	ALM_LINE_SUPP_ORIG = 10	"70372"
11	ALM_LINE_DESCRIPTION = 11	"SOMERSBY CDR APL 4.5% 330ML"
12	ALM_LINE_TYPE = 12	"8"
13	ALM_LINE_ORDER_TYPE = 13	""
14	ALM_LINE_ORDER_TYPE = 14	""
15	ALM_LINE_ITEM_NUMBER = 15	"566027"
16	ALM_LINE_ORIG_ITEM = 16	"566027"
17	ALM_LINE_PACK_QTY = 17	"0024"
18	ALM_LINE_UNITS_ORD = 18	"0000168"
19	ALM_LINE_UNITS_SUPP = 19	"0000168"
20	ALM_LINE_UNITS_SIGN = 20	""
21	ALM_LINE_WET_RATE = 21	"02900"
22	ALM_LINE_GST_RATE = 22	"01000"
23	ALM_LINE_DEPOSIT = 23	"00000"
24	ALM_LINE_BASE_PRICE = 24	"0003703"
25	ALM_LINE_WET_VALUE = 25	"0001074"
26	ALM_LINE_GST_VALUE = 26	"0000478"
27	ALM_LINE_DELIVERY_FEE = 27	"00000"
28	ALM_LINE_CASE_PRICE = 28	"0005255"
29	ALM_LINE_EXT_WHOLESALE = 29	"000036785"
30	ALM_LINE_EXT_SIGN = 30	""
31	ALM_LINE_EXT_WET_VALUE = 31	"000007518"
32	ALM_LINE_EXT_WET_SIGN = 32	""
33	ALM_LINE_EXT_GST_VALUE = 33	"000003346"
34	ALM_LINE_EXT_GST_SIGN = 34	""
35	ALM_LINE_REC_RETAIL = 35	"0000000"
36	ALM_LINE_LITRES = 36	"000000554"
37	ALM_LINE_LITRES_SIGN = 37	""
38	ALM_LINE_APN_CODE = 38	"9329982016832"
39	ALM_LINE_TUN_CODE = 39	"09329982016856"
40	ALM_LINE_FILLER = 41	""
41		""
42		""

FOOTER:

FD71747 99999083668000000000 000204059 000000000 000000000000204059 000004067 000024609 000018554 000185505 000000000 000002438 000162103 000000450 000041956 000000000 000000000 000000000 000000000 000000000 000000000 000000000 000000000

1	ALM_FOOT_REC_TYPE = 1	"FD"
2	ALM_FOOT_INV_NUM = 2	"71747"
3	ALM_FOOT_CLAIM = 3	""
4	ALM_FOOT_PAGENUM = 4	"999"
5	ALM_FOOT_LINENUM = 5	"99"
6	ALM_FOOT_CUST_CODE = 6	"083668"
7	ALM_FOOT_DEL_FEE = 7	"000000000"
8	ALM_FOOT_DEL_FEE_SIGN = 8	""
9	ALM_FOOT_INV_SUB_TOTAL = 9	"000204059"
10	ALM_FOOT_INV_SUB_TOTAL_SIGN = 10	""
11	ALM_FOOT_ADMIN_FEE = 11	"000000000"
12	ALM_FOOT_ADMIN_FEE_SIGN = 12	""
13	ALM_FOOT_SHRINK_WRAP = 13	"000000000"
14	ALM_FOOT_INV_TOTAL = 14	"000204059"
15