AC Historical Commit Balances

The ACCOMITBAL (Balance) and ACCOMITDTL (Detail) files store activity commitment history. Run AC147 (Activity Commitment History Load) to copy and store commitment balances and detail at month end or year end for historical or "as of date" reporting. The ACCOMITBAL and ACCOMITDTL files store an exact copy of the ACCOMMIT and ACCOMMITX records. The creation and timing of the capture of these records for historical analysis is up to the user. Use AC47 (Commitment History Analysis) to view historical commitments for an "as of date". The online inquiry is modeled after AC98 (Activity Commitment Analysis) which allows the user to view "current" commitments. Use AC247 (Activity Commitment History) to report on historical activity balances (including actual, budget, and commitments amounts) for a project for an "as of date". AC247 is formatted the same as AC295 (Activity Commitment Summary) and AC298 (Activity Commitment Detail).

REFERENCED BY

AC47.1

UPDATED BY

AC147

FIELD NAME	DESCRIPTION/VALID VALUES	UPDATED BY
ECB-ACTIVITY-GRP Element: Activity Grp	Alpha 15 Required key. This is the activity group for the historical commitment balance.	AC147
ECB-ACTIVITY Element: Activity	Alpha 15 Required key. This is the posting activity for the historical commitment balance.	AC147
ECB-ACCT-CATEGORY Element: Acct Category	Alpha 5 Key field. This is the detail account category for the historical commitment balance.	AC147
ECB-FISCAL-YEAR Element: Year	Numeric 4 Key field. This is the activity fiscal year for the historical commitment balance.	AC147
ECB-PERIOD Element: Period	Numeric 2 Required key. This is the activity fiscal period for the historical commitment balance.	AC147
ECB-SYSTEM Element: System	Alpha 2 Required key. This is the system code for the historical commitment balance. A system code is a two-character code representing an application used within the Lawson System. (i.e. PO - Purchase Order, MA - Matching, AP - Accounts Payable, etc.)	AC147
ECB-COMPANY Element: Company	Numeric 4 Required key. This is the GL company for the historical commitment balance.	AC147
ECB-CURRENCY-CODE Element: Currency Code	Alpha 5 Required key. This field defines the transaction currency code for the historical commitment balance.	AC147
ECB-VAR-LEVELS Element: Var Levels	Alpha 30 This is the activity level address for the commitment historical balance.	AC147
ECB-TRAN-ND Element: Acct Nd	Numeric 1 This defines the transaction number of decimals for the transaction currency for the commitment historical balance.	AC147
ECB-BALANCE-AMOUNT Element: Intl Amt	Signed 18.2 This is the balance amount for the key fields activity group, activity, account category, fiscal year, fiscal period, system, and currency.	AC147
ECB-BALANCE-UNIT Element: Balance Unit	Signed 17.2 This is the commitment historical units balance. Units represent statistical data such as hours.	AC147
ECB-BURDEN-AMT Element: Intl Amt	Signed 18.2 The burden amount is a calculated amount which represents the burden (fringe or overhead expense) which will be posted with the actual. The burden percent is established on GL01.4 by system code.	AC147
ECB-MAINT-DATE Element: Maint Date	Numeric 8 (yyyymmdd) Key field. As of date for the commitment balance. System date of the capture.	AC147
ECB-MAINT-TIME Element: Sys Time	Numeric 6 (hhmmss) Key field. As of date and time for the commitment balance. System date and time of the capture.	AC147
ECB-SUM-ACCT-CAT Element: Sum Acct Cat	Alpha 5 Identifies the summary account category the detail account category is assigned to in the category structure (lowest summary level account category in the structure).	AC147
ECB-ACCT-CAT-TYPE Element: Acct Cat Type	Derived The detail account category type. (e.g. cost, revenue or accrual)

ACCOMITBAL FILE INDEX

ACCOMITBAL FILE RELATIONS

ONE TO ONE RELATIONS

ACCOMITBAL FILE RELATIONS

ONE TO MANY RELATIONS

All trademarks and registered trademarks are the property of their respective owners.