Account Master Fields
You can use a selection criteria expression with any of the fields in the general ledger account master (listed below).
Many 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 always supplies 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.
Note: If a field's value is text, you must enclose field values in quotation marks. If the text contains a space, it is best to enclose values in a second set of quotation marks: ACCTDESC = ""Accounts Receivable%"".
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.
The following table shows G/L account data field names:
|
Name |
Field Contents |
|---|---|
|
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". |