Fields - Examples

The table shows the fields used in the example:
Table 1. Fields, examples
Field Definition
ACTUALITY
  • Format - Alpha, uppercase, 2 characters long
  • Origin - Variable: &ACT
  • Operation - None
The ACTUALITY field loads the value from the &ACT variable, which, in turn, obtains its value from what is written at the prompt during import.
@AMOUNT The temporary field @AMOUNT must be defined:
  • Numeric, 15 characters long, 2 decimal places
  • Origin - File
  • Operation - Substring, from position 12, 15 characters long.
@AMOUNT loads the amount from the file.
@ACCOUNT The temporary field @ACCOUNT must be defined:
  • Format - Numeric, 4 characters long
  • Origin - File
  • Operation - Substring, from position 1, 4 characters long.
@ACCOUNT loads the account from the file. You have to define an operation template which will change the sign on certain account values OP_FACT. See Step 10.
@FACT
  • Format - Numeric, 2 characters long, 0 decimal places
  • Origin - The temporary field: @ACCOUNT
  • Operation - Op template: OP_FACT
@ACCOUNT loads the account from the file and OP_FACT loads the factor for each account. The value in @FACT is either 1 or -1. You have to define an operation template to create the amount: OP_AMOUNT. See Step 10.
AMOUNT
  • Format - Numeric, 15 characters long
  • Origin - The temporary field: @AMOUNT
  • Operation - Op template: OP_AMOUNT
@AMOUNT has loaded the amount from the file and OP_AMOUNT divides the value by 1,000, rounds to no decimal places, and multiplies by the factor to reverse the sign on income, expenses and liabilities.
COMPANY
  • Format - Alpha, 6 characters long·
  • Origin - Variable: &COMP·
  • Operation - None
&COMP loads the value from the first row in the file.
CURRENCY
  • Format - Alpha, 3 characters long
  • Origin - The Temporary field: @COMP·
  • Operation- Operation template OP_CURR
To obtain the final CURRENCY field, you have to create the operation template OP_CURR.
ACCOUNT
  • Format - Alpha, 9 characters long
  • Origin - The Temporary field: @ACCOUNT
  • Operation - Op template: OP_ACCOUNT
@ACCOUNT loads the account in the file and using the operation template OP_ACCOUNT translates it to an account in Controller. To obtain the final ACCOUNT field, you have to create the operation template OP_ACCOUNT. See Step 10.
PERIOD
  • Format - Numeric, 4 characters long
  • Origin - Variable: &PER·
  • Operation - None