AMTYPALLOC

The The Asset Management Type Allocation file stores the allocation history for a type (type and subtype).
UPDATED BY
AM06.6 AM190 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 MA41.1 MA41.2 MA41.4 MA41.7 MA43.1
MA43.2 MA43.3 MA43.4 MA43.6 MA43.7 MAI1.1
PO136 PO190 PO300 PO520 POCP.1 POI3.1
POII.1 POIJ.1

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
...
AM06.6 AM115
AM117 AM125
AM135 AM145
AM15.1 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 AM40.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: Wed Jun 08 20:47:13 2016

Home
Contact Us



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