|
AMTYPALLOX FILE
The Asset Type Allocation Detail file stores the accounting units and
percentages for each company, asset type (or asset type and subtype), start
date, and sequence number.
REFERENCED BY
AM115 AM125 AM135 AM145 AM15.1 AM15.2
AM15.3 AM15.4 AM154 AM190 AM192 AM20.1
AM20.2 AM20.4 AM20.5 AM205 AM21.1 AM21.2
AM21.4 AM21.5 AM30.1 AM30.2 AM30.3 AM40.1
AM40.2 AM40.3 AM40.4 AM41.1 AM41.2 AM500
AM551 AM98.1
UPDATED BY
AM06.6
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
AXL-COMPANY Numeric 4 AM06.6
Element: Company The company to which the type is
attached.
AXL-ASSET-TYPE Alpha 10 AM06.6
Element: Asset Type The type for which the allocation is
defined.
AXL-SUB-TYPE Alpha 10 AM06.6
Element: Sub Type The subtype for which the allocation is
defined.
AXL-START-DATE Numeric 8 (yyyymmdd) AM06.6
Element: Date The start date from which to begin
allocating deprecation.
AXL-SEQUENCE-NBR Numeric 4 AM06.6
Element: Number of ItemThe sequence number used to identify
multiple allocations for the same start
date.
AXL-ACCT-UNIT Alpha 15 AM06.6
Element: Accounting UniOne of the accounting units that will
store a portion of the allocated
depreciation expense.
AXL-ALLOC-PERCENT Signed 7.4 AM06.6
Element: Allocation PerThe percentage of the current period
depeciation expense to be allocated to
the accounting unit.
AMTYPALLOX FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
AXLSET1 COMPANY AM06.6 AM115
ASSET-TYPE AM125 AM135
SUB-TYPE AM145 AM15.1
START-DATE AM15.2 AM15.3
SEQUENCE-NBR AM15.4 AM154
ACCT-UNIT AM190 AM192
AM20.1 AM20.2
AM20.4 AM20.5
AM205 AM21.1
AM21.2 AM21.4
AM21.5 AM30.1
AM30.2 AM30.3
AM40.1 AM40.2
AM40.3 AM40.4
AM41.1 AM41.2
...
AMTYPALLOX FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Amtypalloc AMTYPALLOC Required
AXL-COMPANY -> ALL-COMPANY
AXL-ASSET-TYPE -> ALL-ASSET-TYPE
AXL-SUB-TYPE -> ALL-SUB-TYPE
AXL-START-DATE -> ALL-START-DATE
AXL-SEQUENCE-NBR -> ALL-SEQUENCE-NBR
|