CATEGORY/QUERY: Financial/Financial Transactions
NOTES: This query describes financial transactions.
Financial Transaction Code/ID
|
Text (30)
|
Required
|
Unique code/id to describe transaction.
|
Financial Transaction Description
|
Text (50)
|
Optional
|
Description/memo of transaction.
|
Transaction Date
|
DateTime
|
Required
|
Actual date of transaction.
|
Amount
|
Currency
|
Required
|
Amount of transaction (in the base currency of the GL).
|
Financial Account Code/ID
|
Text (50)
|
Required
|
Unique code/id to describe Financial Account.
|
Financial Account Description
|
Text (50)
|
Optional
|
Description of Financial Account.
|
GL Account Code/ID
|
Text (18)
|
Required
|
Unique code/id to describe GL Account.
|
GL Account Description
|
Text (50)
|
Optional
|
Description of GL Account.
|
Reference
|
Text (10)
|
Optional
|
User-defined reference field.
|
Fiscal Year
|
Integer
|
Optional
|
Fiscal year of when transaction was posted into the GL.
|
Fiscal Period
|
Integer
|
Optional
|
Fiscal month of when transaction was posted into the GL.
|