You are here: All Help Topics > Accounting and Assurance > Working Trial Balance > MP Database
-- Reference --

MP Database (Mapping)

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
FLIPTYPE 1 character left aligned Type of flip associated with this account.
CLASS 2 characters left aligned Ratio Class
MAP_NO 40 characters centered Map or group number
MAP_NOCR 40 characters centered Map or group number for credit
AC_DESC 50 characters left aligned Map or group number name
TAC_NO 16 characters centered Tax group
TAX1 16 characters centered  
TAX2 16 characters centered  
TAX3 16 characters centered  
TAX4 16 characters centered  
GIFI 10 characters left aligned GIFI 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 10 character left aligned Extended description of the account name
GROUP0 16 characters centered Group number from grouping 0 assigned to the item in the MAP_NO field
GROUP0CR 12 characters left aligned Group number from grouping 0 assigned to the item in the MAP_NO field - credit
GROUP1 12 characters left aligned Group number from grouping 1 assigned to the item in the MAP_NO field
GROUP1CR 12 characters left aligned Group number from grouping 1 assigned to the item in the MAP_NO field - credit
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 through GROUP9 16 characters centered Group number from grouping 4 to Group 9 assigned to the item in the MAP_NO field
GROUP2 through GROUP9CR 16 characters centered Group number from grouping 2 to grouping 9 assigned to the item in the MAP_NO field - credit
TITLE Left aligned, bold Map code titles in the Mapping database
UNIT 4 characters Units
UNITS_B 4 characters Second type of units
DEN 40 characters left aligned Denominator for sales
BM 19 digits and 2 decimal places  
FXCYTD 13 digits and 5 decimal places Foreign exchange current year to date
PROP 1 character left aligned Property (performance measure)
CONV 1 digit no decimal places Unused
MAPTYPE 1 character Map number type (e.g. unassignable)
FORMULA 10 character Memo field Formula for calculated map number
WP_REF 12 character left aligned Work paper reference
ECODE 25 character Unknown
TAGS 10 character memo field XML tags
TAX_ID 4 characters left aligned Tax code (e.g. GST, PST)
CWGUID 22 characters For internal purposes only. Unique identifier, created when the record is appended.
FXTYPE 1  
CWDATE 14 characters For internal purposes only. Marks date and time of database changes.
CREATEDON 14 characters For internal purposes only. Marks date and time record was created.

For consistency across client files, the Mapping database must include the greatest number of accounts possible. Map numbers in the Mapping database are then assigned or mapped to the client chart of accounts. Map numbers contain identical fields to account numbers and can be used to complete account properties when entering a client's chart of accounts in the Working Trial Balance.

Related Topics