AM Database

Field

Contents

Description

LINENO

6 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

16 characters centered

Prime account number

AC_NO2

16 characters centered

Map number

AC_DESC

35 characters left aligned

Account name

MEMO

M,10

Memo description for account

SCHEDULE

12 characters left aligned

Grouping schedule or leadsheet number from grouping 1 (L/S)

GROUP 2

12 characters left aligned

Group number from grouping 2

GROUP 3

12 characters left aligned

Group number from grouping 3

GROUP 4

12 characters left aligned

Group number from grouping 4

TAC_NO

16 characters centered

Tax 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

UNIT

C,10

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

SUB

3 characters left aligned

Sub codes for sub account

DIV

6 characters left aligned

Division

DEN

16 characters left aligned

Denominator for sales

OPEN

15 digits and 2 decimal places

Opening Balance

CP1

15 digits and 2 decimal places

Current period 1

CP2

15 digits and 2 decimal places

Current period 2

CP3

15 digits and 2 decimal places

Current period 3

CP4

15 digits and 2 decimal places

Current period 4

CP5

15 digits and 2 decimal places

Current period 5

CP6

15 digits and 2 decimal places

Current period 6

CP7

15 digits and 2 decimal places

Current period 7

CP8

15 digits and 2 decimal places

Current period 8

CP9

15 digits and 2 decimal places

Current period 9

CP10

15 digits and 2 decimal places

Current period 10

CP11

15 digits and 2 decimal places

Current period 11

CP12

15 digits and 2 decimal places

Current period 12

CP13

15 digits and 2 decimal places

Current period 13

CUR_MTH

15 digits and 2 decimal places

Current Month

CUR_YTD

15 digits and 2 decimal places

Current Year

AJE_BAL

15 digits and 2 decimal places

Normal adjusting entries

EJE_BAL

15 digits and 2 decimal places

Eliminating entries

RJE_BAL

15 digits and 2 decimal places

Reclassifying entries

ERR_BAL

15 digits and 2 decimal places

Known error entries

TAX_FED

15 digits and 2 decimal places

Tax balance

TAX_STATE

15 digits and 2 decimal places

Alternative basis 1 (default for state tax)

TAX_CITY

15 digits and 2 decimal places

Alternative basis 2 (default for city tax)

C1

15 digits and 2 decimal places

Calculated field for browses

C2

15 digits and 2 decimal places

Calculated field for browses

AJ1

15 digits and 2 decimal places

Adjusting journal entry 1

AJ2

15 digits and 2 decimal places

Adjusting journal entry 2

AJ3

15 digits and 2 decimal places

Adjusting journal entry 3

AJ4

15 digits and 2 decimal places

Adjusting journal entry 4

AJ5

15 digits and 2 decimal places

Adjusting journal entry 5

AJ6

15 digits and 2 decimal places

Adjusting journal entry 6

AJ7

15 digits and 2 decimal places

Adjusting journal entry 7

AJ8

15 digits and 2 decimal places

Adjusting journal entry 8

AJ9

15 digits and 2 decimal places

Adjusting journal entry 9

CT1

15 digits and 2 decimal places

Calculated total field for browses

CT2

15 digits and 2 decimal places

Calculated total field for browses

MEMO_NO

2 characters left aligned

Annotation reference

FROM_REF

12 characters left aligned

Document reference

REV_CODE

2 characters left aligned

Tick mark

B1

13 digits and 2 decimal places

Budget period 1

B2

13 digits and 2 decimal places

Budget period 2

B3

13 digits and 2 decimal places

Budget period 3

B4

13 digits and 2 decimal places

Budget period 4

B5

13 digits and 2 decimal places

Budget period 5

B6

13 digits and 2 decimal places

Budget period 6

B7

13 digits and 2 decimal places

Budget period 7

B8

13 digits and 2 decimal places

Budget period 8

B9

13 digits and 2 decimal places

Budget period 9

B10

13 digits and 2 decimal places

Budget period 10

B11

13 digits and 2 decimal places

Budget period 11

B12

13 digits and 2 decimal places

Budget period 12

B13

13 digits and 2 decimal places

Budget period 13

BT

13 digits and 2 decimal places

Budget total

P1

13 digits and 2 decimal places

Prior period 1

P2

13 digits and 2 decimal places

Prior period 2

P3

13 digits and 2 decimal places

Prior period 3

P4

13 digits and 2 decimal places

Prior period 4

P5

13 digits and 2 decimal places

Prior period 5

P6

13 digits and 2 decimal places

Prior period 6

P7

13 digits and 2 decimal places

Prior period 7

P8

13 digits and 2 decimal places

Prior period 8

P9

13 digits and 2 decimal places

Prior period 9

P10

13 digits and 2 decimal places

Prior period 10

P11

13 digits and 2 decimal places

Prior period 11

P12

13 digits and 2 decimal places

Prior period 12

P13

13 digits and 2 decimal places

Prior period 13

PT

13 digits and 2 decimal places

Prior total

PT_2

13 digits and 2 decimal places

Second prior year

PT_3

13 digits and 2 decimal places

Third prior year

PT_4

13 digits and 2 decimal places

Fourth prior year

PT_5

13 digits and 2 decimal places

Fifth prior year

C_RATE

1 digit and 5 decimal places

Current foreign exchange rate for foreign currency translation

B_RATE

1 digit and 5 decimal places

Budget foreign exchange rate for foreign currency translation

P_RATE

1 digit and 5 decimal places

Prior foreign exchange rate for foreign currency translation

P2_RATE

1 digit and 5 decimal places

Prior year 2 foreign exchange rate

P3_RATE

1 digit and 5 decimal places

Prior year 3 foreign exchange rate

P4_RATE

1 digit and 5 decimal places

Prior year 4 foreign exchange rate

FXCYTD

13 digits and 2 decimal places

Current year to date foreign currency translation

FXBYTD

13 digits and 2 decimal places

Budget year to date foreign currency translation

FXPYTD

13 digits and 2 decimal places

Prior year to date foreign currency translation

FXP2

13 digits and 2 decimal places

Prior year 2 foreign currency translation

FXP3

13 digits and 2 decimal places

Prior year 3 foreign currency translation

FXP4

13 digits and 2 decimal places

Prior year 4 foreign currency translation

ENTITY

40 characters left aligned

Code for the entity in a consolidated file