AMTYPALLOC FILE
The The Asset Management Type Allocation file stores the allocation history
for a type (type and subtype).
REFERENCED BY
AM190 AC160 AM115 AM117 AM125 AM135
AM145 AM15.1 AM15.2 AM15.3 AM15.4 AM154
AM170 AM19.1 AM19.2 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
ALL-COMPANY Numeric 4 AM06.6
Element: Company The company to which the type is
attached.
ALL-ASSET-TYPE Alpha 10 AM06.6
Element: Asset Type The type for which an allocation is
defined.
ALL-SUB-TYPE Alpha 10 AM06.6
Element: Sub Type The subtype for which an allocation is
defined.
ALL-START-DATE Numeric 8 (yyyymmdd) AM06.6
Element: Start Date The start date from which to begin
allocating depreciation.
ALL-SEQUENCE-NBR Numeric 4 AM06.6
Element: Sequence Nbr The sequence number used to identify
multiple allocations with the same start
date.
ALL-END-DATE Numeric 8 (yyyymmdd) AM06.6
Element: End Date The end date from which to stop
allocating depreciation.
ALL-STATUS Numeric 1 AM06.6
Element: Status The status of the allocation. Valid
values are:
R = Released
U = Unreleased (the default).
0 = Unreleased
1 = Released
ALL-CREATION-DATE Numeric 8 (yyyymmdd) AM06.6
Element: Creation Date The date the record was created.
ALL-CREATION-TIME Numeric 6 (hhmmss) AM06.6
Element: Creation Time The time the recotd was created.
ALL-CREATOR-ID Alpha 10 AM06.6
Element: Operator The original creator of ther ecord.
AMTYPALLOC FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ALLSET1 COMPANY AM06.6 AM190
ASSET-TYPE
SUB-TYPE
START-DATE
SEQUENCE-NBR
ALLSET2 COMPANY KeyChange AC160 AM06.6
ASSET-TYPE AM115 AM117
SUB-TYPE AM125 AM135
START-DATE* AM145 AM15.1
SEQUENCE-NBR* AM15.2 AM15.3
AM15.4 AM154
AM170 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
...
AMTYPALLOC FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Amtypallox AMTYPALLOX
ALL-COMPANY -> AXL-COMPANY
ALL-ASSET-TYPE -> AXL-ASSET-TYPE
ALL-SUB-TYPE -> AXL-SUB-TYPE
ALL-START-DATE -> AXL-START-DATE
ALL-SEQUENCE-NBR -> AXL-SEQUENCE-NBR
AXL-ACCT-UNIT
|
