SH Database

Field

Contents

Description

LINENO

6 digits right aligned

Line number

PRG

2 characters, centered

External Program module

SCHEDULE

12 characters centered

Document Number

NAME

8 characters left aligned

Code for the type of automatic document being created or the identifier for a CaseView document

TYPE

1 character left aligned

Document Type, which can be A for automatic, F for CaseView, H for folder, M for manual, and E for external document link.

SCH_DESC

60 characters left aligned

Document description

ACCESS

4 characters right aligned

Employee number who can access document (not used)

S1

4 characters right aligned

Assigned User 1

SD1

8 characters in date format

Date User 1 was assigned (not used)

S2

4 characters right aligned

Assigned User 2

SD2

8 characters in date format

Date User 2 was assigned (not used)

S3

4 characters right aligned

Assigned User 3

SD3

8 characters in date format

Date User 3 was assigned (not used)

S4

4 characters right aligned

Assigned User 4

SD4

8 characters in date format

Date User 4 was assigned (not used)

A1

4 characters right aligned

Initials of User 1

AD1

8 characters in date format

Date of completion

A2

4 characters right aligned

Initials of User 2

AD2

8 characters in date format

Date of completion

A3

4 characters right aligned

Initials of User 3

AD3

8 characters in date format

Date of completion

A4

4 characters right aligned

Initials of User 4

AD4

8 characters in date format

Date of completion

AC_FROM

16 characters centered

Account from for filtering of certain automatic reports

AC_TO

16 characters centered

Account to for filtering of certain automatic reports

DATE_FROM

8 characters in date format

Date From for filtering of certain automatic reports

DATE_TO

8 characters in date format

Date To for filtering of certain automatic reports

AMT_FROM

15 digits and 2 decimal places

Amount From for filtering of certain automatic reports

AMT_TO

15 digits and 2 decimal places

Amount To for filtering of certain automatic reports

AMT_CHG

15 digits and 2 decimal places

Amount Change for filtering of certain automatic reports

OTHER

60 characters centered

Filter information for external document links and automatic documents

VIEW

2 characters centered

Document format for automatic documents

H1

60 characters left aligned

Heading 1 for automatic type documents

H2

60 characters left aligned

Heading 2 for automatic type documents

RND

1 character centered

Rounding code for financial statement documents, which can be D for currencies, T for thousands of currencies, M for millions of currencies, and blank for no rounding

B_PRT

1 character centered

Batch printing code (Y, N or blank)

A_CODE

1 character centered

Document Index code (Y, N, * , or blank)

UPD

1 character centered

System code (Y, N, or blank)

DGN

10 characters centered

Document Index - display code

MEMO

1 character centered

Extended Description

SIGN

1 character centered

To take into account the normal sign for the account when presented certain automatic documents (y/n)

MASK

16 characters left aligned

Group number or wildcard when creating documents such as leadsheets or grouping schedules

GROUP

1 character left aligned

The grouping type to display on the report, which can be S for L/S, G for Group 2, H for Group 3, I for Group 4, M for Map No, T for Tax Code, A for Account, and D for Report

SORT

1 character left aligned

Order of presentation for certain automatic documents, which can be A for Account, D for Report, S for L/S, G for Group 2, H for Group 3, I for Group 4, M for Map No, T for Tax Code

FE

1 character centered

Foreign exchange translation to be displayed on the document

INITIALS

1 character centered

Location of preparer and reviewer initials, which can be T for Top, B for bottom, and blank for Use default

ORIENT

1 character left aligned

Landscape printing (Y)

ADJ

1 character left aligned

Combine adjustments into one column (Y or N)

ARRANGE

1 character left aligned

Auto arrange numbers on the document (Y or N)

ANFLG

1 character right aligned

And flag for variance analysis threshold AND/OR property. Returns 1 for OR and 0 for AND.

ENTITY

40 characters left aligned

Code for the entity in a consolidated file

ACT_TYPE

1 character, left aligned

Type of account. S for Cash Flow, P for Performance Measure, " " (space) for Financial.