|
|
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
AC160 AM115 AM117 AM125 AM135 AM145
AM15.1 AM15.2 AM15.3 AM15.4 AM154 AM19.1
AM19.2 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 AM502 AM551
AM92.1 AM98.1 AP115 AP125 AP126 AP131
AP20.1 AP20.2 AP20.3 AP20.4 AP20.5 AP20.7
AP21.1 AP220 AP23.1 AP25.1 AP25.2 AP26.1
AP27.1 AP30.2 AP30.4 AP305 API1.1 API2.1
BL120 BL122 BL130 BL20.1 BL20.3 BL21.2
BL21.5 BL29.1 BL29.2 BL520 BL820 BL92.1
MA180 MA41.1 MA41.2 MA41.4 MA41.7 MA43.1
MA43.2 MA43.3 MA43.4 MA43.6 MA43.7 MA530
MA531 MA60.2 MA60.3 MA60.5 MA61.1 MA63.1
MA65.1 MA66.2 MA66.3 MA67.2 MA67.3 MA68.2
MA68.3 MA68.5 MA70.1 MA75.1 MA80.1 MAI1.1
PD10.1 PD10.2 PD130 PD20.1 PD20.2 PD20.3
PO100 PO101 PO122 PO131 PO20.1 PO21.1
PO21.2 PO21.3 PO21.4 PO21.5 PO22.1 PO23.1
PO24.1 PO25.1 PO25.5 PO25.6 PO25.7 PO27.2
PO29.1 PO30.1 PO30.2 PO30.3 PO300 PO31.1
PO31.2 PO32.2 PO32.4 PO33.1 PO34.1 PO35.1
PO36.1 PO36.2 PO38.1 PO39.1 PO39.2 PO44.1
PO50.1 PO52.1 PO520 PO536 POI3.1 POID.1
POII.1 POIJ.1 RQ10.1 RQ10.2 WH20.2 WH20.7
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: Start Date The start date from which to begin
allocating deprecation.
AXL-SEQUENCE-NBR Numeric 4 AM06.6
Element: Sequence Nbr The sequence number used to identify
multiple allocations for the same start
date.
AXL-ACCT-UNIT Alpha 15 AM06.6
Element: Acct Unit One of the accounting units that will
store a portion of the allocated
depreciation expense.
AXL-ALLOC-PERCENT Signed 7.4 AM06.6
Element: Alloc Percent The 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 AC160 AM06.6
ASSET-TYPE AM115 AM117
SUB-TYPE AM125 AM135
START-DATE AM145 AM15.1
SEQUENCE-NBR AM15.2 AM15.3
ACCT-UNIT AM15.4 AM154
AM19.1 AM19.2
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
...
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
|
