Description of Issue

Need for layout information to complete Export/Import process for Mass Payment Processing

Context

Munis

Mass Payment Processing

Utility Billing

General Billing

Cause

Resolution

Export Information Record Layout

Field Name	Positions	Type	Comments
Bill Year	1-4	Numeric	Identifies the year in which the bill was created.
Bill Category	5-6	Numeric	Identifies the bill category, such as 20 (Real Estate), 25 (Personal Property), and so on.
Bill Number	7-14	Numeric	Identifies the bill number.
Parcel ID	15-34	Alphanumeric	Identifies the parcel ID for which the bill was created.
Semiannual Indicator	35	Alphanumeric	Maryland: If the bill is a semiannual bill, then this position is left blank; otherwise, this position is completed with an “X”.Other states: Unused.
First Owner Name 1	36-75	Alphanumeric	The first full name of the current owner stored on the Munis customer record.
First Owner Name 2	76-115	Alphanumeric	The second full name of the current owner stored on the Munis customer record.
First Owner Address Line 1	116-145	Alphanumeric	The first address line of the current owner address stored on the Munis customer record.
First Owner Address Line 2	146-175	Alphanumeric	The second address line of the current owner address stored on the Munis customer record.
First Owner City	176-195	Alphanumeric	The city of the current owner address stored on the Munis customer record.
First Owner State	196-197	Alphanumeric	The state of the current owner address stored on the Munis customer record.
First Owner Zip	198-207	Numeric	The zip code of the current owner address stored on the Munis customer record.
Property Description Line 1	208-237	Alphanumeric	A description of the property.
Property Description Line 2	238-261	Alphanumeric	A description of the property. Maryland only.
Property Description Line 3	262-285	Alphanumeric	A description of the property. Maryland only.
Unpaid Balance	286-295	Numeric	Indicates the total of the first and second installment including interest. Decimal implied.Maryland: If date is greater than 10/1/current bill year, then the total also includes service charges.
Tax Sale Year	296-299	Numeric	Indicates the year the bill was included in a tax sale.
Tax Sale Redemption	300	Alphanumeric	Indicates whether the bill has been redeemed from tax sale.
Use Code	301-304	Alphanumeric	Indicates the class code to which the property belongs.
First Installment Amount	305-314	Numeric	Indicates the amount due on the first installment.Maryland: If this is an annual bill, then this amount is 0.
Second Installment Amount	315-324	Numeric	Indicates the amount due on the second installment.Maryland: If this is an annual bill, then this amount is 0.
Service Charge	325-334	Numeric	Maryland only: Lost interest and administrative fees.
Billed Amount	335-344	Numeric	Indicates the initial billing amount including any adjustments or abatements.

The Import layout contains two types of entries – (1) a header record and (2) a detail record. The header record contains identifying information about the batch of payments represented in the file. The detail record(s) contains identifying information about individual payments to be processed.

Import Batch Header (Batch) Record Layout

Field Name	Positions	Type	Comments
Batch Header Record Information	1	Alphanumeric	Value must be “H”.Identifies this as a ‘H’eader entry in the file.
Mass Payer Name	2-21	Alphanumeric	The name of the mass payment processor.
Filler	22-36	Alphanumeric	Unused.
Bank Name	37-76	Alphanumeric	The name of the bank that processed the payments.
Bank Code	77-80	Numeric	The Munis lender code.

Import Batch Detail (Payment) Record Layout

Field Name	Positions	Type	Comments
Detail Bill Year	1-4	Numeric	The year associated with the item to be paid.
Detail Bill Number	5-12	Numeric	The bill number associated with the item to be paid.
Detail Bill Category	13-14	Numeric	The Munis category associated with the item to be paid. 20 = Real Estate25 = Personal Property60 = Utility Billingetc.,
Parcel ID	15-34	Alphanumeric	The parcel ID associated with the property for which the payment was accepted.
Bank Code	35-38	Numeric	The bank code for the bank that processed the payment.
Lender Loan Number	39-53	Alphanumeric	The loan number. Optional.
Filler	54-54	Alphanumeric	Unused
Payment Amount	55-64	Numeric	The payment amount. Decimal implied.
Paid by CID	65-72	Numeric	The customer ID for the payee or bank. Optional.
Filler	73-80	Alphanumeric	Unused.

Additional Information

Knowledge Assistant

Mass Payment Processing layouts

Export Information Record Layout

Import Batch Header (Batch) Record Layout

Import Batch Detail (Payment) Record Layout

Unused