Limitación de responsabilidad por el uso del Traductor Google. Haga clic aquí .
-- 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 |
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. |
Notes
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.