Account Master Fields

Sage ERP Accpac General Ledger 6.0

Account Master Fields

You can use a selection criteria expression with any of the fields in the general ledger account master (listed below).

Note that you must enclose field values in quotation marks if the field value is text, and it is best to enclose values in a second set of quotation marks if the text contains a space.

For example:

Note also that many of the values can be expressed in more than one way.

For example, the quantity switch can be 1 or "Yes" if the account keeps quantities, or 0 or "No" if it does not. A criteria expression for this field can look like either of the following:

FR Paste will always supply the text value of G/L account master fields ("Yes" in the above example). If you want to see the non-text values and the text values of these fields, see the Object Information for the GLACCOUNT view in the Macro Editor.

The following table shows the G/L account data field names:

Name

Contents of the field

ACCTID

Account number, including all segments.

CREATEDATE

Date the account was created. Dates are specified as "yyyymmdd".

ACCTDESC

Account description.

ACCTTYPE

Account type I, B or R for income statement, balance sheet, or retained earnings account.

ACCTBAL

1 for normal debit; 2 for normal credit.

ACTIVESW

"ACTIVE" or "INACTIVE".

CONSLDSW

"Do not consolidate journals" or 0 if transactions are not consolidated; "Consolidate journals" or 1 if transactions are consolidated on posting

QTYSW

"Yes" or 1 if quantities are used with account; "No" or 0 if not.

UOM

The unit of measure if quantities are used.

ALLOCSW

If account can be reallocated: "Yes" or 1 is yes; "No" or 0 is no.

ACCTOFSET

Account number for reallocation.

ACCTSRTV

Allocation transaction source code.

MCSW

Multicurrency switch: "Yes" or 1 is yes; "No" or 0 is no.

SPECSW

If posting is in all or specific source currencies. "All currency" or 1 is all; "Specific curency" or 0 is specified.

ACCTGRPCOD

Account group code.

CTRLACCTSW

If account is a control account. "Control account" or 1 is yes; "Non control account" or 0 is no.

SRCELDGID

Source ledger if control account (e.g. AR, AP). (Reserved field)

ALLOCTOT

Total of different allocation rates (100).

ABRKID

Account structure code.

YRACCTCLOS

Year of the last close.

POSTOSEGID

The account segment by which the account is closed.

DEFCURNCOD

Default currency code for the account.

ACCTFMTTD

Formatted account number.

ACSEGVALn

Account segment value 01 to 10.

ACCTSEGVAL

Account Segment Code

ACCTGRPCPY

Account group COPY. A copy of the group code that is a string instead of an integer.

ROLLUPSW

Rollup switch. If unformatted, 1 if account is a rollup account, 0 if not. If formatted, "Yes" or "No".

To retrieve account optional fields, add the prefix A before a field name (for example, A.ACCTID). Be sure to include the period after the prefix.

See also