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
PRINT 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

Visit us: www.caseware.com | Follow us: LinkedIn Facebook Twitter YouTube

© 2022 Caseware International Inc. | Privacy | Terms of Use | Trademarks