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:
ACCTDESC = ""Accounts Receivable%""
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:
QTYSW = 1
QTYSW = "Yes"
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