MP Database

Field

Contents

Description

LINENO

8 digits right aligned

Line number

ID

1 character

Grouping number (1, 2, 3, or 4) or M for map number

TYPE

1 character left aligned

Account Type, which can be B for Balance Sheet, I for Income Statement, or S for Statement of Cash Flow

CLASS

2 characters left aligned

Ratio Class

MAP_NO

16 characters centered

Map or group number

AC_DESC

35 characters left aligned

Map or group number name

TAC_NO

16 characters centered

Tax group

CC

3 characters left aligned

Credit code for Statement of Cash Flow or reference to Statement of Cash Flow account

DC

3 characters left aligned

Debit code for Statement of Cash Flow or reference to Statement of Cash Flow account

COLUMN

1 character left aligned

F/S Column

DOLLAR

1 character left aligned

Print currency sign

ULINE

1 character left aligned

Print underline

PAGE

1 character left aligned

New page

SIGN

1 character left aligned

Debit or Credit

PRINT

1 character left aligned

Print/display

CTL

2 characters left aligned

Control Account

TOTAL

1 character left aligned

Total Accumulator

MEMO

1 character left aligned

Extended description of the account name

GROUP1

12 characters left aligned

Group number from grouping 1 assigned to the item in the MAP_NO field

GROUP2

16 characters centered

Group number from grouping 2 assigned to the item in the MAP_NO field

GROUP3

16 characters centered

Group number from grouping 3 assigned to the item in the MAP_NO field

GROUP4

16 characters centered

Group number from grouping 4 assigned to the item in the MAP_NO field

DEN

16 characters left aligned

Denominator for sales

TITLE

Left aligned, bold

Map code titles in the Mapping database

UNIT

C,10

Units

UNITS_B

C,10

Second type of units