Lawson Insight Technical Documentation |
|
ACCUAMTX
ACCUAMTX FILE
AC Currency Amount Detail
This file contains currency amount details by period.
REFERENCED BY
AC130 AC21.3 AC21.4 AC295 AC32.1 AC37.1
AC400 AC410 AC420 AC473 AC490 AC96.1
AC98.2 ACTA.1 AC220 AC297 ACDL.1
UPDATED BY
AC121 AC123 AC127 AC190 AC20.1 AC20.2
AC20.3 AC20.4 AC20.5 AC20.7 AC20.6 AC22.1
AC300 AC310 AC45.1 ACDR.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ACX-ACTIVITY-GRP Alpha 15 AC121 AC123
Element: Activity GroupRequired key. This is the activity AC127 AC190
group for the currency information. AC20.1 AC20.2
AC20.3 AC20.4
AC20.5 AC22.1
ACDR.1
ACX-ACTIVITY Alpha 15 AC121 AC123
Element: Activity Required key. This is the activity for AC127 AC190
the currency information. AC20.1 AC20.2
AC20.3 AC20.4
AC20.5 AC22.1
ACDR.1
ACX-BUDGET-NBR Numeric 3 AC121 AC123
Element: Budget Number Required key. This is the budget number AC127 AC190
for the currency information.. AC20.1 AC20.2
AC20.3 AC20.4
AC20.5 AC22.1
ACDR.1
ACX-FISCAL-YEAR Numeric 4 AC121 AC123
Element: Fiscal Year Required key. This is the fiscal year. AC127 AC190
AC20.1 AC20.2
AC20.3 AC20.4
AC20.5 AC22.1
ACDR.1
ACX-ACCT-CATEGORY Alpha 5 AC121 AC123
Element: Account CategoRequired key. This is the account AC127 AC190
category for the currency information. AC20.1 AC20.2
AC20.3 AC20.4
AC20.5 AC22.1
ACDR.1
ACX-CURRENCY-CODE Alpha 5 AC121 AC123
Element: Currency Code Required key. This field defines the AC127 AC190
base currency code for the activity AC20.1 AC20.2
group. It is defined in AC00.1 (Activity AC20.3 AC20.4
Group). AC20.5 AC22.1
ACDR.1
ACX-PERIOD Numeric 2 AC121 AC123
Element: Period Required key. This is the fiscal period AC127 AC190
for the currency information. AC20.1 AC20.2
AC20.3 AC20.4
AC20.5 AC22.1
ACDR.1
ACX-PARENT-ACTV Alpha 15 AC121 AC123
Element: Parent Actv AC127 AC190
AC20.1 AC20.2
AC20.3 AC20.4
AC20.5 AC22.1
ACDR.1
ACX-AMOUNT Currency 15.2 AC121 AC123
Element: Amount This is the period amount for the AC127 AC190
currency information for the specified AC20.1 AC20.2
record. AC20.3 AC20.4
AC20.5 AC22.1
ACDR.1
ACX-UNIT Signed 15.2 AC121 AC123
Element: Unit This is the number of units for the AC127 AC190
period. AC20.1 AC20.2
AC20.3 AC20.4
AC20.5 AC22.1
ACDR.1
ACX-FACTOR Alpha 15 AC121 AC123
Element: Factor The element that affects the budget AC127 AC20.2
change. AC20.3 AC20.4
AC20.5 AC22.1
ACX-FACTOR-RATE Signed 12.6 AC121 AC123
Element: Account Rate AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC22.1
ACX-ACCT-CAT-TYPE Derived
Element: Acct Cat Type
ACCUAMTX FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ACXSET1 ACTIVITY-GRP AC121 AC123
ACTIVITY AC127 AC130
CURRENCY-CODE AC190 AC20.1
BUDGET-NBR AC20.2 AC20.3
FISCAL-YEAR AC20.4 AC20.5
ACCT-CATEGORY AC20.6 AC20.7
PERIOD AC21.3 AC21.4
AC22.1 AC295
AC300 AC310
AC32.1 AC37.1
AC400 AC410
AC420 AC45.1
AC473 AC490
AC96.1 AC98.2
ACDR.1 ACTA.1
ACXSET2 ACTIVITY-GRP AC220 AC295
ACTIVITY AC297 AC410
CURRENCY-CODE
BUDGET-NBR
ACCT-CATEGORY
FISCAL-YEAR
PERIOD
ACXSET3 ACTIVITY-GRP
ACTIVITY
CURRENCY-CODE
BUDGET-NBR
ACCT-CATEGORY
FISCAL-YEAR*
PERIOD*
ACXSET4 ACTIVITY-GRP AC473
ACTIVITY
CURRENCY-CODE
FISCAL-YEAR
PERIOD
BUDGET-NBR
ACCT-CATEGORY
ACXSET5 FISCAL-YEAR AC400 ACDL.1
PERIOD
ACTIVITY-GRP
ACTIVITY
CURRENCY-CODE
ACCT-CATEGORY
BUDGET-NBR
ACXSET6 ACTIVITY-GRP KeyChange
PARENT-ACTV
CURRENCY-CODE
BUDGET-NBR
ACCT-CATEGORY
FISCAL-YEAR
PERIOD
ACTIVITY
ACCUAMTX FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acacctcat ACACCTCAT Required
ACX-ACCT-CATEGORY -> AAX-ACCT-CATEGORY (AAXSET1)
Acactgrp ACACTGRP Required
ACX-ACTIVITY-GRP -> AGP-ACTIVITY-GRP
Acactivity ACACTIVITY Required
ACX-ACTIVITY -> ACV-ACTIVITY
Acbuddtlx ACBUDDTLX Not Required
ACX-ACTIVITY-GRP -> BDX-ACTIVITY-GRP
ACX-ACTIVITY -> BDX-ACTIVITY
ACX-BUDGET-NBR -> BDX-BUDGET-NBR
ACX-ACCT-CATEGORY -> BDX-ACCT-CATEGORY
ACX-FISCAL-YEAR -> BDX-FISCAL-YEAR
ACX-PERIOD -> BDX-PERIOD
Accuamt ACCUAMT Not Required
ACX-ACTIVITY-GRP -> ACU-ACTIVITY-GRP
ACX-ACTIVITY -> ACU-ACTIVITY
ACX-CURRENCY-CODE -> ACU-CURRENCY-CODE
ACX-BUDGET-NBR -> ACU-BUDGET-NBR
ACX-FISCAL-YEAR -> ACU-FISCAL-YEAR
ACX-ACCT-CATEGORY -> ACU-ACCT-CATEGORY
Aclevel ACLEVEL Required
ACX-ACTIVITY-GRP -> LVL-ACTIVITY-GRP
ACU-VAR-LEVELS -> LVL-VAR-LEVELS
Acmasterx ACMASTERX Not Required
ACX-ACTIVITY-GRP -> MSX-ACTIVITY-GRP
ACX-ACTIVITY -> MSX-ACTIVITY
ACX-ACCT-CATEGORY -> MSX-ACCT-CATEGORY
ACX-FISCAL-YEAR -> MSX-FISCAL-YEAR
ACX-PERIOD -> MSX-PERIOD
Cucodes CUCODES Not Required
ACX-CURRENCY-CODE -> CUC-CURRENCY-CODE
ACCUAMTX FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Posted Actrans ACTRANS
ACX-ACTIVITY-GRP -> ATN-ACTIVITY-GRP
ACU-VAR-LEVELS -> ATN-VAR-LEVELS
9 -> ATN-STATUS
ACX-ACCT-CATEGORY -> ATN-ACCT-CATEGORY
ACX-FISCAL-YEAR -> ATN-FISCAL-YEAR
ACX-PERIOD -> ATN-PERIOD
ATN-OBJ-ID
|