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

AM Database (Trial Balance)

Field Contents Description
LINENO 8 digits right aligned Line number
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
CLASS 2 characters left aligned Class - for ratio calculations (user definable)
AC_NO 40 characters centered Prime account number
ENTITY 40 characters left aligned Code for the entity in a consolidated file
DIV 6 characters left aligned Division
SUB 6 characters left aligned Sub account
SUB_NO 40 characters left aligned Prime sub account number
SPLITUP 1 character left aligned Split up accounts
DIST 1 character left aligned Distributor code
AC_NO2 16 characters centered Map number
AC_NO2CR 16 characters centered Map number credit
AC_DESC 50 characters left aligned Account name
MEMO Memo field, 10 characters Memo description for account
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
GROUP2 through GROUP9 and GROUP0 40 characters left aligned Group number
GROUP2CR through GROUP9CR and GROUP0CR 40 characters left aligned Group number for credit balance
TAC_NO 16 characters centered Tax group
GIFI 10 characters left aligned GIFI code
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
UNIT 4 characters left aligned Units
UNIT_B 4 characters left aligned Units
COLUMN 1 character left aligned F/S Column, which can be 1, 2, 3, or blank
DOLLAR 1 character left aligned Print currency sign, which can be Y, N, or blank
ULINE 1 character left aligned Print underline
PAGE 1 character left aligned New page
SIGN 1 character left aligned Debit or Credit
POST 1 character left aligned Posting - If Y can post to
PRINT 1 character left aligned Print/display
CTL 2 characters left aligned Control Account
TOTAL 1 character left aligned Total Accumulator
DEN 40 characters left aligned Denominator for sales
OPEN 19 digits and 2 decimal places Opening Balance
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
CT 19 digits and 2 decimal places Calculated total
CUR_MTH 19 digits and 2 decimal places Current Month
CUR_YTD 19 digits and 2 decimal places Current Year
AJE_BAL 19 digits and 2 decimal places Normal adjusting entries
EJE_BAL 19 digits and 2 decimal places Eliminating entries
RJE_BAL 19 digits and 2 decimal places Reclassifying entries
ERR_BAL 19 digits and 2 decimal places Known error entries
TAX_FED 19 digits and 2 decimal places Tax balance
TAX_STATE 19 digits and 2 decimal places Alternate basis 1 (default for state tax)
TAX_CITY 19 digits and 2 decimal places Alternate basis 2 (default for city tax)
FED_PY 19 digits and 2 decimal places Federal tax prior year
STATE_PY 19 digits and 2 decimal places State tax prior year
CITY_PY 19 digits and 2 decimal places City tax prior year
C1 19 digits and 2 decimal places Calculated field for browses
C2 19 digits and 2 decimal places Calculated field for browses
CT1 19 digits and 2 decimal places Calculated total field for browses
CT2 19 digits and 2 decimal places Calculated total field for browses
MEMO_NO 2 characters left aligned Commentary
FROM_REF 12 characters left aligned Document reference
REV_CODE 2 characters left aligned Tickmark
B1 19 digits and 2 decimal places Budget period 1
B2 19 digits and 2 decimal places Budget period 2
B3 19 digits and 2 decimal places Budget period 3
B4 19 digits and 2 decimal places Budget period 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
BT 19 digits and 2 decimal places Budget total
P1 19 digits and 2 decimal places Prior period 1
P2 19 digits and 2 decimal places Prior period 2
P3 19 digits and 2 decimal places Prior period 3
P4 19 digits and 2 decimal places Prior period 4
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
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
C_RATE 13 digit and 5 decimal places Current foreign exchange rate for foreign currency translation
B_RATE 13 digit and 5 decimal places Budget foreign exchange rate for foreign currency translation
P_RATE 13 digit and 5 decimal places Prior foreign exchange rate for foreign currency translation
P2_RATE 13 digit and 5 decimal places Prior year 2 foreign exchange rate
P3_RATE 13 digit and 5 decimal places Prior year 3 foreign exchange rate
P4_RATE 13 digit and 5 decimal places Prior year 4 foreign exchange rate
FXCYTD 19 digits and 2 decimal places Current year to date foreign currency translation
FXBYTD 19 digits and 2 decimal places Budget year to date foreign currency translation
FXPYTD 19 digits and 2 decimal places Prior 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
LINK1 8 characters Unused
LINK2 8 characters Unused
LINK3 8 characters Unused
SU_YTD 19 digits and 2 decimal places Split-up balance year to date
SU_PY 19 digits and 2 decimal places Split-up balance prior year
SU_BY 19 digits and 2 decimal places Split-up balance budget year
STATUS 8 characters left aligned Split-up status of balances
BASELN 19 digits and 2 decimal places Baseline amount (performance measures)
TAX_ID 4 characters left aligned Tax code (e.g. GST, PST)
UID_NOTE Memo field 10 characters Unused
UNUSED42   Unused
CWGUID 22 characters For internal purposes only. Unique identifier, created when the record is appended.
B1_RATE 13 digits and 5 decimal places Foreign exchange rate - prior year budget 1
B2_RATE 13 digits and 5 decimal places Foreign exchange rate - prior year budget 2
B3_RATE 13 digits and 5 decimal places Foreign exchange rate - prior year budget 3
B4_RATE 13 digits and 5 decimal places Foreign exchange rate - prior year budget 4
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
LOCKED   Lock down status
EXINFO 10 characters For internal purposes only. Memo used for reports
PAC_NO    
FXTYPE   Foreign exchange type
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.

Related Topics