AMPODFLTS

REFERENCED BY
IC130 IC141 IC142 MA26.1 MA310 PO135
PO26.1 RQ11.1


UPDATED BY
AM17.1 AM19.1 AM19.2 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 CX100 CX20.1 CX20.2 CX20.4 CX20.5
CX220 CX30.1 CX300 CX506 CXCP.1 DR100
IC140 IC66.1 IC83.1 MA180 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
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 PO100 PO101 PO122 PO131 PO136
PO150 PO190 PO20.1 PO20.6 PO20.9 PO21.1
PO21.2 PO21.3 PO21.4 PO21.5 PO22.1 PO22.3
PO22.4 PO23.1 PO24.1 PO25.1 PO25.5 PO25.6
PO25.7 PO27.2 PO28.2 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 RQ10.1 RQ10.2 RQ10.4 RQ12.1
RQ13.1 RQ13.2 RQ35.1 RQ500 RQIF.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 ZW130

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
AOT-COMPANY
Element: Company
Numeric 4
Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.
...
AM17.1 AM19.1
AM19.2 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 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC140 IC66.1
IC83.1 MA180
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
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
AOT-PO-NUMBER
Element: Po Number
Alpha 14 (Right Justified)
This field contains the number representing the purchase order.
...
AM17.1 AM19.1
AM19.2 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 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC140 IC66.1
IC83.1 MA180
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
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
AOT-PO-RELEASE
Element: Po Release
Numeric 4
Used to identify a purchase order release (created from a Blanket or Standing order).
...
AM17.1 AM19.1
AM19.2 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 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC140 IC66.1
IC83.1 MA180
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
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
AOT-PO-CODE
Element: Po Code
Alpha 4
This is the purchase order code.
...
AM17.1 AM19.1
AM19.2 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 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC140 IC66.1
IC83.1 MA180
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
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
AOT-LINE-NBR
Element: Line Nbr
Numeric 6
This field contains the line number.
...
AM17.1 AM19.1
AM19.2 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 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC140 IC66.1
IC83.1 MA180
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
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
AOT-ASSET-DESC
Element: Description
Alpha 30 (Lower Case)
This field displays the description.
...
AM17.1 AM19.1
AM19.2 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 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC140 IC66.1
IC83.1 MA180
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
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
AOT-TAG-NBR
Element: Tag Nbr
Alpha 12
The tag is a user definable identifier assigned to an asset.
...
AM17.1 AM19.1
AM19.2 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 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC140 IC66.1
IC83.1 MA180
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
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
AOT-ASSET-GROUP
Element: Asset Group
Alpha 10
...
AM17.1 AM19.1
AM19.2 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 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC140 IC66.1
IC83.1 MA180
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
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
AOT-AU-GROUP
Element: Au Group
Alpha 10
Accounting unit groups group and identify the accounting units to use when you create journal entries for adding, adjusting, transferring, or disposing of assets. Changes to accounting unit groups are dynamic, affecting all assets using the accounting unit group. Accounting unit group names are user-definable, and accounting unit groups are set up by company.
...
AM17.1 AM19.1
AM19.2 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 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC140 IC66.1
IC83.1 MA180
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
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
AOT-COMBINE
Element: Combine
Alpha 10
...
AM17.1 AM19.1
AM19.2 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 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC140 IC66.1
IC83.1 MA180
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
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
AOT-HOLD-AM
Element: All Flag
Alpha 1

N = No
Y = Yes
...
AM17.1 AM19.1
AM19.2 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 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC140 IC66.1
IC83.1 MA180
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
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
AOT-ACTIVITY
Element: Activity
Alpha 15
Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity.
...
AM17.1 AM19.1
AM19.2 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 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC140 IC66.1
IC83.1 MA180
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
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
AOT-ACCT-CATEGORY
Element: Acct Category
Alpha 5
Account categories are groupings of costs, revenues, or a combination of both used for reporting and inquiries for activities in the Activity Management system. All transactions are posted to an account category within an activity. You can assign a specific General Ledger account or range of accounts (company, accounting unit, account, and subaccount) that make up the transactions posted to an account category using AC07.1 (Account Assignment). Period-to-date, year-to-date, and life-to-date balances are maintained by account category for activities. Account categories must be assigned to activities before you do any budgeting or transaction processing. Valid account category types are: cost revenue accrual pass thru
...
AM17.1 AM19.1
AM19.2 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 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC140 IC66.1
IC83.1 MA180
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
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
AOT-ITEM-NBR
Element: Item
Alpha 32
This field contains the item identifier.
...
AM17.1 AM19.1
AM19.2 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 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC140 IC66.1
IC83.1 MA180
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
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
AOT-ITEM-DESC
Element: Description
Alpha 30 (Lower Case)
This field displays the description.
...
AM17.1 AM19.1
AM19.2 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 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC140 IC66.1
IC83.1 MA180
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
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
AOT-MODEL-NUMBER
Element: Model Number
Alpha 30
...
AM17.1 AM19.1
AM19.2 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 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC140 IC66.1
IC83.1 MA180
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
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
AOT-PURCHASE-DATE
Element: Purchase Date
Numeric 8 (yyyymmdd)
The date the asset was purchased. This purchased date can be different from the in-service dates for the depreciation books used.
...
AM17.1 AM19.1
AM19.2 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 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC140 IC66.1
IC83.1 MA180
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
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
AOT-INSRV-DATE
Element: Insrv Date
Numeric 8 (yyyymmdd)
The book in-service date for the asset. Note: The in-service date can be different for each depreciation book used.
...
AM17.1 AM19.1
AM19.2 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 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC140 IC66.1
IC83.1 MA180
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
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
AOT-ITEM-TAX-TRAN
Element: Intl Amt
Signed 18.2
...
AM17.1 AM19.1
AM19.2 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 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC140 IC66.1
IC83.1 MA180
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
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
AOT-LOCATION-NAME
Element: Location Name
Alpha 15
A user-defined location name which represents where an asset is physically located. Locations are used to report asset information.
...
AM17.1 AM19.1
AM19.2 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 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC140 IC66.1
IC83.1 MA180
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
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
AOT-DIVISION
Element: Division
Alpha 15
A user-defined division which is used for reporting assets.
...
AM17.1 AM19.1
AM19.2 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 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC140 IC66.1
IC83.1 MA180
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
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
AOT-ITEM-LOC-DTL
Element: Item Loc Dtl
Alpha 14
...
AM17.1 AM19.1
AM19.2 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 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC140 IC66.1
IC83.1 MA180
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
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1


AMPODFLTS FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
AOTSET1 COMPANY
PO-NUMBER
PO-RELEASE
PO-CODE
LINE-NBR
...
AM17.1 AM19.1
AM19.2 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 CX100
CX20.1 CX20.2
CX20.4 CX20.5


AMPODFLTS FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Ampoasthdr AMPOASTHDR Not Required
AOT-COMPANY->AOH-COMPANY
AOT-PO-NUMBER->AOH-PO-NUMBER
AOT-PO-RELEASE->AOH-PO-RELEASE
AOT-PO-CODE->AOH-PO-CODE
AOT-LINE-NBR->AOH-LINE-NBR


File created: Thu Jun 09 11:06:16 2016

Home
Contact Us



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