AMTYPALLOC

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
AM155 AM170 AM19.1 AM19.2 AM192 AM20.1
AM20.2 AM20.4 AM20.5 AM205 AM21.1 AM21.2
AM21.4 AM21.5 AM22.2 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 AP510 API1.1 API2.1 CX100 CX20.1
CX20.2 CX20.4 CX20.5 CX220 CX30.1 CX300
CX506 CXCP.1 DR100 IC12.1 IC140 IC141
IC142 IC145 IC243 IC330 IC64.1 IC64.2
IC64.3 IC64.4 IC64.5 IC64.6 IC64.7 IC64.8
IC64.9 IC66.1 IC83.1 MA126 MA180 MA278
MA41.1 MA41.2 MA41.4 MA41.7 MA42.1 MA42.2
MA43.1 MA43.2 MA43.3 MA43.4 MA43.6 MA43.7
MA44.1 MA44.2 MA53.1 MA530 MA531 MA60.2
MA60.3 MA60.5 MA61.1 MA63.1 MA65.1 MA66.2
MA67.2 MA67.3 MA68.2 MA68.3 MA68.5 MA69.1
MA70.1 MA75.1 MA80.1 MAI1.1 PD10.1 PD10.2
PD130 PD20.1 PD20.2 PD20.3 PD570 PO04.1
PO04.2 PO10.1 PO10.2 PO100 PO101 PO115
PO120 PO122 PO131 PO132 PO136 PO15.1
PO15.2 PO15.4 PO150 PO17.1 PO190 PO20.1
PO20.6 PO20.9 PO204 PO21.1 PO21.2 PO21.3
PO21.4 PO21.5 PO22.1 PO22.3 PO22.4 PO220
PO222 PO224 PO225 PO229 PO23.1 PO230
PO234 PO24.1 PO25.1 PO25.5 PO25.6 PO25.7
PO251 PO26.3 PO26.7 PO26.9 PO27.2 PO27.3
PO27.4 PO275 PO276 PO277 PO28.2 PO280
PO29.1 PO30.1 PO30.2 PO30.3 PO30.4 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 PO54.5
POCP.1 POI3.1 POID.1 POII.1 POIJ.1 RQ01.1
RQ10.1 RQ10.2 RQ10.3 RQ10.4 RQ10.5 RQ11.1
RQ12.1 RQ13.1 RQ13.2 RQ35.1 RQ44.1 RQ500
RQ810 RQIB.1 RQIF.1 RQII.1 RQIJ.1 WH130
WH132 WH190 WH20.2 WH20.7 WH222 WH30.1
WH30.2 WH30.3 WH30.4 WH31.1 WH31.2 WH31.3
WH31.4 WH32.1 WH32.2 WH32.3 WH32.4 WH32.5
WH33.1 WH33.2 WH33.3 WH33.4 WH33.5 WH33.6
WH33.8 WH33.9 WH34.1 WH34.2 WH34.3 WH34.4
WH40.1 WH40.2 WH520 WH830


UPDATED BY
AM06.6

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ALL-COMPANY
Element: Company		Numeric 4
The company to which the type is attached.
AM06.6
ALL-ASSET-TYPE
Element: Asset Type		Alpha 10
The type for which an allocation is defined.
AM06.6
ALL-SUB-TYPE
Element: Sub Type		Alpha 10
The subtype for which an allocation is defined.
AM06.6
ALL-START-DATE
Element: Start Date		Numeric 8 (yyyymmdd)
The start date from which to begin allocating depreciation.
AM06.6
ALL-SEQUENCE-NBR
Element: Sequence Nbr		Numeric 4
The sequence number used to identify multiple allocations with the same start date.
AM06.6
ALL-END-DATE
Element: End Date		Numeric 8 (yyyymmdd)
The end date from which to stop allocating depreciation.
AM06.6
ALL-STATUS
Element: Status		Numeric 1
The status of the allocation. Valid values are: R = Released U = Unreleased (the default).
0 = Unreleased
1 = Released
AM06.6
ALL-CREATION-DATE
Element: Creation Date		Numeric 8 (yyyymmdd)
The date the record was created.
AM06.6
ALL-CREATION-TIME
Element: Creation Time		Numeric 6 (hhmmss)
The time the recotd was created.
AM06.6
ALL-CREATOR-ID
Element: Operator		Alpha 10
The original creator of ther ecord.
AM06.6


AMTYPALLOC FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ALLSET1 COMPANY
ASSET-TYPE
SUB-TYPE
START-DATE
SEQUENCE-NBR
AM06.6 AM190
ALLSET2 COMPANY
ASSET-TYPE
SUB-TYPE
START-DATE*
SEQUENCE-NBR*
KeyChange
...
AC160 AM06.6
AM115 AM117
AM125 AM135
AM145 AM15.1
AM15.2 AM15.3
AM15.4 AM154
AM155 AM170
AM19.1 AM19.2
AM190 AM192
AM20.1 AM20.2
AM20.4 AM20.5
AM205 AM21.1
AM21.2 AM21.4
AM21.5 AM22.2
AM30.1 AM30.2


AMTYPALLOC FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME		 RELATED 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

File created: Thu Jun 09 02:05:50 2016

Home
Contact Us



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