AM Database
The following describes the fields in the AM (Trial Balance) database.
| Field | Contents | Description |
|---|---|---|
| AC_DESC | 50 characters left aligned | Account name |
| AC_NO | 40 characters centered | Prime account number |
| AC_NO2 | 16 characters centered | Map number |
| AC_NO2CR | 16 characters centered | Map number credit |
| AJE_BAL | 19 digits and 2 decimal places | Normal adjusting entries |
| B_RATE | 13 digit and 5 decimal places | Budget foreign exchange rate for foreign currency translation |
| B1 | 19 digits and 2 decimal places | Budget period 1 |
| B1_RATE | 13 digits and 5 decimal places | Foreign exchange rate - prior year budget 1 |
| B2 | 19 digits and 2 decimal places | Budget period 2 |
| B2_RATE | 13 digits and 5 decimal places | Foreign exchange rate - prior year budget 2 |
| B3 | 19 digits and 2 decimal places | Budget period 3 |
| B3_RATE | 13 digits and 5 decimal places | Foreign exchange rate - prior year budget 3 |
| B4 | 19 digits and 2 decimal places | Budget period 4 |
| B4_RATE | 13 digits and 5 decimal places | Foreign exchange rate - prior year budget 4 |
| B5 | 19 digits and 2 decimal places | Budget period 5 |
| B6 | 19 digits and 2 decimal places | Budget period 6 |
| B7 | 19 digits and 2 decimal places | Budget period 7 |
| B8 | 19 digits and 2 decimal places | Budget period 8 |
| B9 | 19 digits and 2 decimal places | Budget period 9 |
| B10 | 19 digits and 2 decimal places | Budget period 10 |
| B11 | 19 digits and 2 decimal places | Budget period 11 |
| B12 | 19 digits and 2 decimal places | Budget period 12 |
| B13 | 19 digits and 2 decimal places | Budget period 13 |
| BASELN | 19 digits and 2 decimal places | Baseline amount (performance measures) |
| BT | 19 digits and 2 decimal places | Budget total |
| C_RATE | 13 digit and 5 decimal places | Current foreign exchange rate for foreign currency translation |
| C1 | 19 digits and 2 decimal places | Calculated field for browses |
| C2 | 19 digits and 2 decimal places | Calculated field for browses |
| CC | 3 characters left aligned | Credit code for Statement of Cash Flow or reference to Statement of Cash Flow account |
| CITY_PY | 19 digits and 2 decimal places | City tax prior year |
| CLASS | 2 characters left aligned | Class - for ratio calculations (user definable) |
| COLUMN | 1 character left aligned | F/S Column, which can be 1, 2, 3, or blank |
| CP1 | 19 digits and 2 decimal places | Current period 1 |
| CP2 | 19 digits and 2 decimal places | Current period 2 |
| CP3 | 19 digits and 2 decimal places | Current period 3 |
| CP4 | 19 digits and 2 decimal places | Current period 4 |
| CP5 | 19 digits and 2 decimal places | Current period 5 |
| CP6 | 19 digits and 2 decimal places | Current period 6 |
| CP7 | 19 digits and 2 decimal places | Current period 7 |
| CP8 | 19 digits and 2 decimal places | Current period 8 |
| CP9 | 19 digits and 2 decimal places | Current period 9 |
| CP10 | 19 digits and 2 decimal places | Current period 10 |
| CP11 | 19 digits and 2 decimal places | Current period 11 |
| CP12 | 19 digits and 2 decimal places | Current period 12 |
| CP13 | 19 digits and 2 decimal places | Current period 13 |
| CREATEDON | 14 characters | For internal purposes only. Marks date and time record was created. |
| CT | 19 digits and 2 decimal places | Calculated total |
| CT1 | 19 digits and 2 decimal places | Calculated total field for browses |
| CT2 | 19 digits and 2 decimal places | Calculated total field for browses |
| CTL | 2 characters left aligned | Control Account |
| CUR_MTH | 19 digits and 2 decimal places | Current Month |
| CUR_YTD | 19 digits and 2 decimal places | Current Year |
| CWDATE | 14 characters | For internal purposes only. Marks date and time of database changes. |
| CWGUID | 22 characters | For internal purposes only. Unique identifier, created when the record is appended. |
| DC | 3 characters left aligned | Debit code for Statement of Cash Flow or reference to Statement of Cash Flow account |
| DEN | 40 characters left aligned | Denominator for sales |
| DIST | 1 character left aligned | Distributor code |
| DIV | 6 characters left aligned | Division |
| DOLLAR | 1 character left aligned | Print currency sign, which can be Y, N, or blank |
| EJE_BAL | 19 digits and 2 decimal places | Eliminating entries |
| ENTITY | 40 characters left aligned | Code for the entity in a consolidated file |
| ERR_BAL | 19 digits and 2 decimal places | Known error entries |
| EXINFO | 10 characters | For internal purposes only. Memo used for reports |
| F_RATE | 13 digits and 5 decimal places | Foreign exchange rate - current year forecast |
| F1_RATE | 13 digits and 5 decimal places | Foreign exchange rate - future year forecast 1 |
| F2_RATE | 13 digits and 5 decimal places | Foreign exchange rate - future year forecast 2 |
| F3_RATE | 13 digits and 5 decimal places | Foreign exchange rate - future year forecast 3 |
| F4_RATE | 13 digits and 5 decimal places | Foreign exchange rate - future year forecast 4 |
| FED_PY | 19 digits and 2 decimal places | Federal tax prior year |
| FROM_REF | 12 characters left aligned | Document reference |
| FXBYTD | 19 digits and 2 decimal places | Budget year to date foreign currency translation |
| FXCYTD | 19 digits and 2 decimal places | Current year to date foreign currency translation |
| FXP2 | 19 digits and 2 decimal places | Prior year 2 foreign currency translation |
| FXP3 | 19 digits and 2 decimal places | Prior year 3 foreign currency translation |
| FXP4 | 19 digits and 2 decimal places | Prior year 4 foreign currency translation |
| FXPYTD | 19 digits and 2 decimal places | Prior year to date foreign currency translation |
| FXTYPE | - | Foreign exchange type |
| GIFI | 10 characters left aligned | GIFI code |
| GROUP2CR through GROUP9CR and GROUP0CR | 40 characters left aligned | Group number for credit balance |
| GROUP2 through GROUP9 and GROUP0 | 40 characters left aligned | Group number |
| LINENO | 8 digits right aligned | Line number |
| LINK1 | 8 characters | Unused |
| LINK2 | 8 characters | Unused |
| LINK3 | 8 characters | Unused |
| LOCKED | - | Lock down status |
| MEMO | Memo field, 10 characters | Memo description for account |
| MEMO_NO | 2 characters left aligned | Commentary |
| OPEN | 19 digits and 2 decimal places | Opening Balance |
| P_RATE | 13 digit and 5 decimal places | Prior foreign exchange rate for foreign currency translation |
| P1 | 19 digits and 2 decimal places | Prior period 1 |
| P2 | 19 digits and 2 decimal places | Prior period 2 |
| P2_RATE | 13 digit and 5 decimal places | Prior year 2 foreign exchange rate |
| P3 | 19 digits and 2 decimal places | Prior period 3 |
| P3_RATE | 13 digit and 5 decimal places | Prior year 3 foreign exchange rate |
| P4 | 19 digits and 2 decimal places | Prior period 4 |
| P4_RATE | 13 digit and 5 decimal places | Prior year 4 foreign exchange rate |
| P5 | 19 digits and 2 decimal places | Prior period 5 |
| P6 | 19 digits and 2 decimal places | Prior period 6 |
| P7 | 19 digits and 2 decimal places | Prior period 7 |
| P8 | 19 digits and 2 decimal places | Prior period 8 |
| P9 | 19 digits and 2 decimal places | Prior period 9 |
| P10 | 19 digits and 2 decimal places | Prior period 10 |
| P11 | 19 digits and 2 decimal places | Prior period 11 |
| P12 | 19 digits and 2 decimal places | Prior period 12 |
| P13 | 19 digits and 2 decimal places | Prior period 13 |
| PAGE | 1 character left aligned | New page |
| POST | 1 character left aligned | Posting - If Y can post to |
| 1 character left aligned | Print/display | |
| PT | 19 digits and 2 decimal places | Prior total |
| PT_2 | 19 digits and 2 decimal places | Second prior year |
| PT_3 | 19 digits and 2 decimal places | Third prior year |
| PT_4 | 19 digits and 2 decimal places | Fourth prior year |
| PT_5 | 19 digits and 2 decimal places | Fifth prior year |
| REV_CODE | 2 characters left aligned | Tickmark |
| RJE_BAL | 19 digits and 2 decimal places | Reclassifying entries |
| SCHEDULE | 12 characters, padded according to the leadsheet mask. So for mask XX.XXX, the schedule will have a leading space of only one character (ex. "_A") | Grouping schedule or leadsheet number from grouping 1 (L/S) |
| SCHEDULECR | 12 characters left aligned | Grouping schedule or leadsheet number from grouping 1 (L/S) for credit balance |
| SIGN | 1 character left aligned | Debit or Credit |
| SPLITUP | 1 character left aligned | Split up accounts |
| STATE_PY | 19 digits and 2 decimal places | State tax prior year |
| STATUS | 8 characters left aligned | Split-up status of balances |
| SU_BY | 19 digits and 2 decimal places | Split-up balance budget year |
| SU_PY | 19 digits and 2 decimal places | Split-up balance prior year |
| SU_YTD | 19 digits and 2 decimal places | Split-up balance year to date |
| SUB | 6 characters left aligned | Sub account |
| SUB_NO | 40 characters left aligned | Prime sub account number |
| TAC_NO | 16 characters centered | Tax group |
| TAX_CITY | 19 digits and 2 decimal places | Alternate basis 2 (default for city tax) |
| TAX_FED | 19 digits and 2 decimal places | Tax balance |
| TAX_ID | 4 characters left aligned | Tax code (e.g. GST, PST) |
| TAX_STATE | 19 digits and 2 decimal places | Alternate basis 1 (default for state tax) |
| TOTAL | 1 character left aligned | Total Accumulator |
| TYPE | 1 character left aligned | F/S type, which can be B for Balance Sheet, I for Income Statement, and S for Statement of Cash Flow |
| UID_NOTE | Memo field 10 characters | Unused |
| ULINE | 1 character left aligned | Print underline |
| UNIT | 4 characters left aligned | Units |
| UNIT_B | 4 characters left aligned | Units |
