Interface Types (Load Types)
The following table defines Interface Types:
Interface Type |
Long Name |
Usage |
Tables Updated |
---|---|---|---|
AAD |
Additional Cost Add |
Rarely used. Adds cost information to an asset. Mainly used for joint venture and composite rollups. |
Cost, Open Trans |
ACQ |
Insert Acquisition Detail |
Inserts into Acquisition Detail. |
Acquisition Detail |
ADD |
Asset Add |
Asset add - Financial only. For details, see load type CN2. |
Book, Cost, Depr, Open Trans |
ADJ |
Asset Cost Adjustment |
Adjusts the cost of an existing asset. |
Cost, Open Trans |
ADP |
Asset Depreciation |
Inserts depreciation information created by the Revaluation en Masse programs. |
Depreciation, Open Trans |
ADQ |
Adjust Cost and Acquisition Detail |
Adjusts the cost and acquisition details of an existing asset. |
Acquisition Detail, Cost, Open Trans |
ARA |
Add Retired Asset |
Adds an asset that has been fully reserved and retired. |
Book, Cost, Depr, Asset, and if applicable Custodian, Asset Location, Warranty, Attribute, License, Comments, and Acquisition Detail |
ASD |
Asset Deletion |
Deletes an existing asset. Only assets that have not been used to generate any journals will be deleted. |
Asset, Acquisition Detail, Asset Fair Value, Attribute, Comments, Custodian, Location, Maintenance, Warranty, Book, Book Tax Credit, Cost, Depr, Dist Line, Open Trans, Retirement, Lease, Lease Schedule, PI Asset History, |
AUP |
Asset Information Update |
Updates the asset table only. Rarely used, except in physical inventory. |
Asset, Component of Asset History |
BKD |
Book Deletion |
Deletes a book for an asset or business unit. For example, you can use it to delete dummy books used for performing "what if" analyses. |
Book, Book Tax Credit, Depr, Dist Line, Retirement, Open Trans |
BKS |
Book Change |
Makes any change to an asset book. |
Book, Open Trans |
BSD |
Selective Book Delete |
Deletes a book from a range of asset IDs. Similar to BKD. |
Book, Book Tax Credit, Depr, Dist Line, Retirement, Open Trans |
CAP |
Asset Capitalization |
Adds a line of acquisition detail and capitalizes it. If the acquisition detail line is originally uncapitalized, the interface will insert book, cost, and open trans as well as acquisition detail. If it is originally capitalized, the book information will not be inserted. |
Acquisition Detail, Book, Cost, Open Trans |
CIC |
Capitalize into Composite |
Capitalizes composite assets. Similar to CAP. |
Acquisition Detail, Book, Cost, Open Trans |
CLC |
Custodian/Location Change |
Updates custodian/location information. |
Custodian, Location |
CN1 |
Conversion of First Book |
During conversion, converts the first asset book. Inserts into all asset tables, as well as financial tables. |
Book, Cost, Depr, Open Trans, Asset, Acquisition Detail, Location, PI Asset History, Component of Asset History, Parent Asset, Attribute, Comments, License, Warranty |
CN2 |
Conversion of Subsequent Books |
During conversion, converts any subsequent books. Inserts only into financial tables. |
Book, Cost, Depr, Component of Asset History, Open Trans |
FAD |
Financial and Physical Add |
Adds assets with both physical and financial information. This Interface Type is used most commonly for adding assets. |
Book, Cost, Depr, Open Trans, Asset, Acquisition Detail, Location, PI Asset History, Component of Asset History, Parent Asset, Attribute, Comments, License, Warranty |
IHI |
Physical Inventory History Insert |
Inserts asset history. Used by the Physical Inventory SQR (AMPI1000). |
PI Asset History |
IUI |
InterUnit Transfer, In Side |
Provides the IN side of an InterUnit Transfer. Valid values for ACTIVITY_SW are: 1 Full Transfer 0 Active ChartField combination –1 Reactivated ChartField combination For example, one ChartField combination is fully transferred out of a department (ACTIVITY_SW = 1), and an identical ChartField combination is transferred into the same department (ACTIVITY_SW = –1). The activity switch values for the two transactions then cancel each other, resulting in an active ChartField combination (ACTIVITY_SW = 0). |
Asset, Book, Cost, Asset Fair Value, Open Trans, Component of Asset History |
IUO |
InterUnit Transfer, Out Side |
Used for the OUT side of an InterUnit Transfer. Valid values for ACTIVITY_SW are: 1 Full Transfer 0 Active ChartField combination –1 Reactivated ChartField combination For example, one ChartField combination is fully transferred out of a department (ACTIVITY_SW = 1), and an identical ChartField combination is transferred into the same department (ACTIVITY_SW = -1). The activity switch values for the two transactions then cancel each other, resulting in an active ChartField combination (ACTIVITY_SW = 0). |
Cost, Open Trans |
LAD |
Leased Asset Add |
Adds leased assets. |
Lease, Lease Schedule, Book, Cost, Depr, Open Trans, Asset, Acquisition Detail, Asset Fair Value, Location, PI Asset History, Parent Asset, Attribute, Comments, License, Warranty |
NAD |
Non-Financial Add |
Adds an asset with only physical information. |
Asset, Custodian, Location, PI Asset History, Component of Asset History, Parent Asset, Attribute, Comments, License, Warranty, Open Trans |
OPT |
Open Transaction Generator |
Creates open transactions for a set of assets. Rarely used. |
Open Trans |
PHY |
Physical Asset Change |
Performs inserts to any physical asset tables other than the Asset Table, for example, location, custodian, or manufacturer. |
Acquisition Detail, Custodian, Location, Attribute, Comments, License, Warranty |
PRT |
Partial Retirement |
Performs partial retirements. |
Cost, Retirement, Open Trans, Asset |
RAQ |
Replace Acquisition Detail |
Replaces acquisition details using AMIF1000. |
Acquisition Detail |
RCT |
Asset Recategorization |
Performs recategorizations. |
Cost, Open Trans |
REI |
Asset Reinstatement |
Performs reinstatements. |
Cost, Retirement, Open Trans, Asset |
RET |
Asset Retirement |
Performs full retirements. |
Cost, Retirement, Open Trans, Asset |
RNA |
Non-Financial Retirements |
Performs retirements of non-financial assets. |
Asset, Asset Retirement |
TRF |
IntraUnit Transfer |
Performs transfers within the same business unit. Valid values for ACTIVITY_SW are: 1 Full Transfer 0 Active ChartField Combination –1 Reactivated ChartField Combination For example, one ChartField combination is fully transferred out of a department (ACTIVITY_SW = 1), and an identical ChartField combination is transferred into the same department (ACTIVITY_SW = –1). The activity switch values for the two transactions then cancel each other, resulting in an active ChartField combination (ACTIVITY_SW = 0). |
Cost, Open Trans |