AC Historical Commit Detail

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)

REFERENCED BY

AC47.1

AC47.2

UPDATED BY

AC147

AC247

FIELD NAME	DESCRIPTION/VALID VALUES	UPDATED BY
ECD-ACTIVITY-GRP Element: Activity Grp	Alpha 15 Required key. This is the activity group for the commitment transaction.	AC147
ECD-ACTIVITY Element: Activity	Alpha 15 Required key. This is the posting activity for the historical commitment transaction.	AC147
ECD-ACCT-CATEGORY Element: Acct Category	Alpha 5 Required key. This is the detail account category for the historical commitment transaction.	AC147
ECD-FISCAL-YEAR Element: Year	Numeric 4 Required key. This is the activity fiscal year for the historical commitment transaction.	AC147 AC247
ECD-PERIOD Element: Period	Numeric 2 Required key. This is the activity fiscal period for the historical commitment transaction.	AC147 AC247
ECD-SYSTEM Element: System	Alpha 2 Required key. This is the system code or source system for the historical commitment. A system code is a two-character code representing an application used within the Lawson System (e.g. PO - Purchase Order, MA - Matching, AP - Accounts Payable, etc.)	AC147
ECD-COMPANY Element: Company	Numeric 4 Required key. This is the GL company for the historical commitment.	AC147
ECD-CURRENCY-CODE Element: Currency Code	Alpha 5 Required key. This field defines the transaction currency code for the historical commitment.	AC147
ECD-ATN-OBJ-ID Element: Obj Id	Numeric 12 Key field. This is the object identifier which keys the record unique and also identifies the source transaction in the Lawson subsystem.	AC147
ECD-ACCT-UNIT Element: Acct Unit	Alpha 15 This is the accounting unit for the committed expense.	AC147
ECD-ACCOUNT Element: Account	Numeric 6 This is the expense account for the committed expense.	AC147
ECD-SUB-ACCOUNT Element: Sub Acct	Numeric 4 This is the sub account for the commitment.	AC147
ECD-TRAN-AMOUNT Element: Intl Amt	Signed 18.2 This is the amount in transaction currency for the commitment.	AC147
ECD-UNIT Element: Unit	Signed 15.2 This is the number of units for the commitment. A unit represents a unit of measure such as "each" or "hours".	AC147
ECD-BURDEN-AMT Element: Intl Amt	Signed 18.2 This represents the burden or fringe amount for the commitment.	AC147
ECD-ACCT-CAT-TYPE Element: Acct Cat Type	Derived This is the detail account category type. (e.g. cost, revenue or accrual)
ECD-INVOICE Element: Invoice	Alpha 22 This field contains the requisition number, PO number or AP invoice number. Commonly referred to as the document number.	AC147
ECD-ITEM Element: Item	Alpha 32 This field contains the item number.	AC147
ECD-RESOURCE-CODE Element: Resource Code	Alpha 10 The resource code is the code identifying the resource assigned to the commitment. (e.g. For Payroll the resource represents the employee or contractor, for RQ, PO, and AP the resource represents the vendor.)	AC147
ECD-RESOURCE-TYPE Element: Resource Type	Alpha 1 Identifies the resource type. Valid values are: P - AC person, Q - Equipment, E - Employee, V - Vendor, or A - Asset.	AC147
ECD-RESOURCE-DESC Element: Description	Alpha 30 (Lower Case) Contains the resource description or name.	AC147
ECD-GLT-OBJ-ID Element: Obj Id	Numeric 12 This is the GL object identifier. It is used to relate commitments or posted transactions back to the originating subsystems. Each subsystem record that is updated as a commitment or posted transaction is assigned an object identifier. The object identifier is a uniqu key used to drill back from GL or activity management to the subsystems.	AC147
ECD-RESOURCE-COMP Element: Resource Comp	Numeric 4 Required field if a resource is present in the commitment transaction. Captures the HR company if the resource is an employee; AP company if the resource is a vendor; and AM company if the resource is an asset.	AC147
ECD-TRANS-DATE Element: Trans Date	Numeric 8 (yyyymmdd) The date of the transaction. For RQ the represents the requisition date; for PO the represents the PO date, delivery date or system date; for AP the date represents the AP posting date.	AC147
ECD-END-DATE Element: End Date	Numeric 8 (yyyymmdd) Contains the manual commitment end date.	AC147
ECD-USER-ID Element: User	Alpha 10 (Lower Case)	AC147
ECD-SOURCE-CODE Element: Source Code	Alpha 2 Identifies the commitment transactions source code.	AC147
ECD-GMA-OBJ-ID Element: Obj Id	Numeric 12 Transaction object id or unique identifier used specifically by Grant Management.	AC147
ECD-GM-SALARY-PCT Element: Gm Salary Pct	Signed 13.6 Grant Management salary percentage.	AC147
ECD-MAINT-DATE Element: Maint Date	Numeric 8 (yyyymmdd) Key field. As of date or system create date for the commitment transaction. Date of the copy or capture.	AC147
ECD-MAINT-TIME Element: Sys Time	Numeric 6 (hhmmss) Key field. Create as of date and time date for the commitment transaction. Date of the copy or capture.	AC147

ACCOMITDTL FILE INDEX

ACCOMITDTL FILE RELATIONS

ONE TO ONE RELATIONS

ACCOMITDTL FILE RELATIONS

ONE TO MANY RELATIONS

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