Lawson Insight Technical Documentation |
|
AMPOASTDTL
AMPOASTDTL FILE
REFERENCED BY
AM219 IC130 MA310 PO135 PO136 PO190
PO26.1 RQ11.1 RQ12.1 RQ13.1 RQ13.2 RQ35.1
RQ500 RQIF.1 WH130 WH132 WH190 WH30.1
WH30.2 WH30.3 WH30.4 WH31.1 WH31.2 WH31.3
WH31.4 WH32.1 WH32.2 WH32.3 WH32.4 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
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 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
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
AOD-COMPANY Numeric 4 AM19.1 AM19.2
Element: Company Identifies the AP company if the AP115 AP125
resource type = V. Identifies the HR AP126 AP131
company if the resource type = E. It is AP20.1 AP20.2
blank for type A, P or Q resources. 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
...
AOD-PO-NUMBER Alpha 14 (Right Justified) AM19.1 AM19.2
Element: Po Number This field contains the number AP115 AP125
representing the purchase order. 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
...
AOD-PO-RELEASE Numeric 4 AM19.1 AM19.2
Element: Po Release Used to identify a purchase order AP115 AP125
release (created from a Blanket or AP126 AP131
Standing order). 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
...
AOD-PO-CODE Alpha 4 AM19.1 AM19.2
Element: Po Code This is the purchase order code. 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
...
AOD-LINE-NBR Numeric 6 AM19.1 AM19.2
Element: Line Nbr This field contains the line number. 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
...
AOD-DTL-SEQ-NBR Numeric 6 AM19.1 AM19.2
Element: Seq Number A unique number assigned to each AP115 AP125
transaction to be interfaced into the AP126 AP131
Lawson system. 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
...
AOD-CURRENCY-CODE Alpha 5 AM19.1 AM19.2
Element: Currency Code This field contains the company base AP115 AP125
currency code established in Company AP126 AP131
(GL10.1 ). 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
...
AOD-TRAN-ND Numeric 1 AM19.1 AM19.2
Element: Acct Nd The number of decimals assigned to a AP115 AP125
particular account as determined by the AP126 AP131
account currency. 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
...
AOD-BASE-ND Numeric 1 AM19.1 AM19.2
Element: Base Nd The number of decimal positions defined AP115 AP125
for the company base currency. 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
...
AOD-BAR-CODE Alpha 30 AM19.1 AM19.2
Element: Bar Code 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
...
AOD-SERIAL-NUMBER Alpha 30 AM19.1 AM19.2
Element: Serial Number This optional field is used for the AP115 AP125
serial number of the asset. 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
...
AOD-DIST-COMPANY Numeric 4 AM19.1 AM19.2
Element: Company Identifies the AP company if the AP115 AP125
resource type = V. Identifies the HR AP126 AP131
company if the resource type = E. It is AP20.1 AP20.2
blank for type A, P or Q resources. 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
...
AOD-ASSET-TEMPLATE Alpha 10 AM19.1 AM19.2
Element: Asset TemplateA user-defined asset template AP115 AP125
identifies general asset creation AP126 AP131
parameters that you can use to quickly AP20.1 AP20.2
add assets with minimal keying. Using a AP20.3 AP20.4
template lets you default many data AP20.5 AP20.7
items associated with a new asset. AP21.1 AP220
AP23.1 AP25.1
You can use an asset template to AP25.2 AP26.1
process quick asset additions in AM20.1 AP27.1 AP30.2
(Quick Addition) and to create assets AP30.4 AP305
and asset books from Accounts Payable API1.1 API2.1
and Activity Management interface BL120 BL122
information. Asset templates are BL130 BL20.1
required if you define new assets as a BL20.3 BL21.2
result of transactions interfaced from BL21.5 BL29.1
the Lawson Purchase Order or Accounts BL29.2 BL520
Payable systems. 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
...
AOD-ASSET-DESC Alpha 30 (Lower Case) AM17.1 AM19.1
Element: Description This field displays the description. 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 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
...
AOD-TAG-NBR Alpha 12 AM17.1 AM19.1
Element: Tag Nbr The tag is a user definable identifier AM19.2 AP115
assigned to an asset. 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
...
AOD-ASSET-GROUP Alpha 10 AM17.1 AM19.1
Element: Asset Group 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 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
...
AOD-AU-GROUP Alpha 10 AM17.1 AM19.1
Element: Au Group Accounting unit groups group and AM19.2 AP115
identify the accounting units to use AP125 AP126
when you create journal entries for AP131 AP20.1
adding, adjusting, transferring, or AP20.2 AP20.3
disposing of assets. Changes to AP20.4 AP20.5
accounting unit groups are dynamic, AP20.7 AP21.1
affecting all assets using the AP220 AP23.1
accounting unit group. Accounting unit AP25.1 AP25.2
group names are user-definable, and AP26.1 AP27.1
accounting unit groups are set up by AP30.2 AP30.4
company. 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
...
AOD-COMBINE Alpha 10 AM17.1 AM19.1
Element: Combine 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 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
...
AOD-HOLD-AM Alpha 1 AM17.1 AM19.1
Element: All Flag 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 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
...
AOD-ACTIVITY Alpha 15 AM17.1 AM19.1
Element: Activity Activities are the processes or AM19.2 AP115
procedures that produce work. Cost AP125 AP126
objects (products, services, customers, AP131 AP20.1
and so on) are the reasons for AP20.2 AP20.3
performing the activity. 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
...
AOD-ACCT-CATEGORY Alpha 5 AM17.1 AM19.1
Element: Acct Category Account categories are groupings of AM19.2 AP115
costs, revenues, or a combination of AP125 AP126
both used for reporting and inquiries AP131 AP20.1
for activities in the Activity AP20.2 AP20.3
Management system. All transactions are AP20.4 AP20.5
posted to an account category within an AP20.7 AP21.1
activity. You can assign a specific AP220 AP23.1
General Ledger account or range of AP25.1 AP25.2
accounts (company, accounting unit, AP26.1 AP27.1
account, and subaccount) that make up AP30.2 AP30.4
the transactions posted to an account AP305 API1.1
category using AC07.1 (Account API2.1 BL120
Assignment). BL122 BL130
BL20.1 BL20.3
Period-to-date, year-to-date, and BL21.2 BL21.5
life-to-date balances are maintained by BL29.1 BL29.2
account category for activities. Account BL520 BL820
categories must be assigned to BL92.1 MA180
activities before you do any budgeting MA41.1 MA41.2
or transaction processing. MA41.4 MA41.7
MA43.1 MA43.2
Valid account category types are: MA43.3 MA43.4
cost MA43.6 MA43.7
revenue MA530 MA531
accrual MA60.2 MA60.3
pass thru MA60.5 MA61.1
MA63.1 MA65.1
MA66.2 MA66.3
MA67.2 MA67.3
...
AOD-ITEM-NBR Alpha 32 AM17.1 AM19.1
Element: Item This field contains the item AM19.2 AP115
identifier. 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
...
AOD-ITEM-DESC Alpha 30 (Lower Case) AM17.1 AM19.1
Element: Description This field displays the description. 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 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
...
AOD-MODEL-NUMBER Alpha 30 AM17.1 AM19.1
Element: Model Number 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 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
...
AOD-PURCHASE-DATE Numeric 8 (yyyymmdd) AM17.1 AM19.1
Element: Purchase Date The date the asset was purchased. This AM19.2 AP115
purchased date can be different from the AP125 AP126
in-service dates for the depreciation AP131 AP20.1
books used. 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
...
AOD-INSRV-DATE Numeric 8 (yyyymmdd) AM17.1 AM19.1
Element: Insrv Date The book in-service date for the asset. AM19.2 AP115
AP125 AP126
Note: The in-service date can be AP131 AP20.1
different for each depreciation book AP20.2 AP20.3
used. 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
...
AOD-ITEM-TAX-TRAN Signed 18.2 AM19.1 AM19.2
Element: Intl Amt 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
...
AOD-ITEM-TAX-BASE Signed 18.2 AM19.1 AM19.2
Element: Intl Amt 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
...
AOD-INVOICE Alpha 22 AM19.1 AM19.2
Element: Invoice Used to identify the invoice. 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
...
AOD-SUFFIX Numeric 3 AM19.1 AM19.2
Element: Suffix This is the suffix for the invoice. 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
...
AOD-ACCT-UNIT Alpha 15 AM19.1 AM19.2
Element: Acct Unit The accounting unit is a shorthand AP115 AP125
notation representing the variable level AP126 AP131
number. When used in the General Ledger AP20.1 AP20.2
Account Master file, the accounting unit AP20.3 AP20.4
must be defined in the General Ledger AP20.5 AP20.7
Names file as a posting accounting unit. 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
...
AOD-LOCATION-NAME Alpha 15 AM17.1 AM19.1
Element: Location Name A user-defined location name which AM19.2 AP115
represents where an asset is physically AP125 AP126
located. Locations are used to report AP131 AP20.1
asset information. 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
...
AOD-DIVISION Alpha 15 AM17.1 AM19.1
Element: Division A user-defined division which is used AM19.2 AP115
for reporting assets. 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
...
AOD-ITEM-LOC-DTL Alpha 14 AM17.1 AM19.1
Element: Item Loc Dtl 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 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
...
AOD-PO-AST-OBJ-ID Numeric 12 AM19.1 AM19.2
Element: Obj Id This is the object identifier. It is AP115 AP125
used to relate commitments or posted AP126 AP131
transactions back to the originating AP20.1 AP20.2
subsystems. Each subsystem record that AP20.3 AP20.4
is updated as a commitment or posted AP20.5 AP20.7
transaction is assigned an object AP21.1 AP220
identifier. The object identifier is AP23.1 AP25.1
maintained in the subsystem files and in AP25.2 AP26.1
the Activity Commitments Detail and AP27.1 AP30.2
Activity Transaction files. The object AP30.4 AP305
identifier is a unique key used to drill API1.1 API2.1
back from Activity Management to the BL120 BL122
subsystems. 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
...
AOD-RECEIVED Numeric 1 AM19.1 AM19.2
Element: Flag Num 0 AP115 AP125
1 = X 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
...
AOD-REJECTED Numeric 1 AM19.1 AM19.2
Element: Flag Num 0 AP115 AP125
1 = X 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
...
AOD-RETURNED Numeric 1 AM19.1 AM19.2
Element: Flag Num 0 AP115 AP125
1 = X 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
...
AOD-INVOICED Numeric 1 AM19.1 AM19.2
Element: Flag Num 0 AP115 AP125
1 = X 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
...
AOD-ASSET-CREATED Numeric 1 AM19.1 AM19.2
Element: Flag Num 0 AP115 AP125
1 = X 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
...
AOD-CANCELLED Numeric 1 AM19.1 AM19.2
Element: Flag Num 0 AP115 AP125
1 = X 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
...
AMPOASTDTL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
AODSET1 COMPANY AM17.1 AM19.1
PO-NUMBER AM19.2 AM19.3
PO-RELEASE AM219 AP115
PO-CODE AP125 AP126
LINE-NBR AP131 AP20.1
DTL-SEQ-NBR 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
...
AODSET2 COMPANY KeyChange AM19.1 AM19.2
PO-NUMBER AP115 AP125
PO-RELEASE AP126 AP131
PO-CODE AP20.1 AP20.2
LINE-NBR AP20.3 AP20.4
DTL-SEQ-NBR* 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
...
AODSET3 COMPANY KeyChange AM19.1
PO-NUMBER
PO-RELEASE
PO-CODE
LINE-NBR
BAR-CODE
SERIAL-NUMBER
DTL-SEQ-NBR
AMPOASTDTL FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Amastitem AMASTITEM Not Required
AOD-PO-AST-OBJ-ID -> ASI-PO-AST-OBJ-ID
Ampoasthdr AMPOASTHDR Required
AOD-COMPANY -> AOH-COMPANY
AOD-PO-NUMBER -> AOH-PO-NUMBER
AOD-PO-RELEASE -> AOH-PO-RELEASE
AOD-PO-CODE -> AOH-PO-CODE
AOD-LINE-NBR -> AOH-LINE-NBR
Poline POLINE Required
AOD-COMPANY -> PLI-COMPANY
AOD-PO-NUMBER -> PLI-PO-NUMBER
AOD-PO-RELEASE -> PLI-PO-RELEASE
AOD-PO-CODE -> PLI-PO-CODE
AOD-LINE-NBR -> PLI-LINE-NBR
|