Lawson Insight Technical Documentation |
|
MAAOCDTL
MAAOCDTL FILE
This is the AOC detail record. This file contains the AOC details related to
the APINVOICE and MAINVDTL records.
REFERENCED BY
AP295 MA126 MA279 MA69.1 MA69.2 MA69.3
MA69.4 MA69.5 MA69.6 MA90.1 MA90.2 MA90.3
MA90.5 MM280 MM80.1 MM80.2 MA278 PO135
PO64.1
UPDATED BY
AM19.1 AM19.2 AP115 AP125 AP126 AP131
AP180 AP181 AP190 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 AP28.1 AP28.2
AP30.2 AP30.4 AP300 AP305 AP45.1 API1.1
API2.1 BL120 BL122 BL130 BL20.1 BL20.3
BL21.2 BL21.5 BL29.1 BL29.2 BL520 BL820
BL92.1 MA180 MA310 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.4
MA60.5 MA61.1 MA63.1 MA65.1 MA66.2 MA66.3
MA67.2 MA67.3 MA68.2 MA68.3 MA68.4 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 AP198
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MAA-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 AP180 AP181
blank for type A, P or Q resources. AP190 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
AP28.1 AP28.2
AP30.2 AP30.4
AP305 AP45.1
API1.1 API2.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
MA126 MA180
MA310 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
...
MAA-VENDOR Alpha 9 (Right Justified) AM19.1 AM19.2
Element: Vendor The vendor's identification code. AP115 AP125
AP126 AP131
AP180 AP181
AP190 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
AP28.1 AP28.2
AP30.2 AP30.4
AP305 AP45.1
API1.1 API2.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
MA126 MA180
MA310 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
...
MAA-INVOICE Alpha 22 AM19.1 AM19.2
Element: Invoice Used to identify the invoice. AP115 AP125
AP126 AP131
AP180 AP181
AP190 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
AP28.1 AP28.2
AP30.2 AP30.4
AP305 AP45.1
API1.1 API2.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
MA126 MA180
MA310 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
...
MAA-SUFFIX Numeric 3 AM19.1 AM19.2
Element: Suffix This is the suffix for the invoice. AP115 AP125
AP126 AP131
AP180 AP181
AP190 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
AP28.1 AP28.2
AP30.2 AP30.4
AP305 AP45.1
API1.1 API2.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
MA126 MA180
MA310 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
...
MAA-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
AP180 AP181
AP190 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
AP28.1 AP28.2
AP30.2 AP30.4
AP305 AP45.1
API1.1 API2.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
MA126 MA180
MA310 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
...
MAA-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). AP180 AP181
AP190 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
AP28.1 AP28.2
AP30.2 AP30.4
AP305 AP45.1
API1.1 API2.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
MA126 MA180
MA310 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
...
MAA-PO-CODE Alpha 4 AM19.1 AM19.2
Element: Po Code This is the purchase order code. AP115 AP125
AP126 AP131
AP180 AP181
AP190 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
AP28.1 AP28.2
AP30.2 AP30.4
AP305 AP45.1
API1.1 API2.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
MA126 MA180
MA310 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
...
MAA-LINE-NBR Numeric 6 AM19.1 AM19.2
Element: Line Nbr This field contains the line number. AP115 AP125
AP126 AP131
AP180 AP181
AP190 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
AP28.1 AP28.2
AP30.2 AP30.4
AP305 AP45.1
API1.1 API2.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
MA126 MA180
MA310 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
...
MAA-AOC-CODE Alpha 2 AM19.1 AM19.2
Element: Aoc Code This field contains the identifier for AP115 AP125
the add on cost associated with this AP126 AP131
line item. AP180 AP181
AP190 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
AP28.1 AP28.2
AP30.2 AP30.4
AP305 AP45.1
API1.1 API2.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
MA126 MA180
MA310 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
...
MAA-CANCEL-SEQ Numeric 4 AM19.1 AM19.2
Element: Seq Nbr An automatically assigned sequence AP115 AP125
number. 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
MA126 MA180
MA310 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
...
MAA-SEQ-NBR Numeric 4 AM19.1 AM19.2
Element: Seq Nbr An automatically assigned sequence AP115 AP125
number. AP126 AP131
AP180 AP181
AP190 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
AP28.1 AP28.2
AP30.2 AP30.4
AP305 AP45.1
API1.1 API2.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
MA126 MA180
MA310 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
...
MAA-MATCH-DTL-KEY Alpha 85 AM19.1 AM19.2
Element: Match Dtl Key The match detail key is a user defined AP115 AP125
set of match criteria. THe item number AP126 AP131
is required and other criteria can be AP180 AP181
added up to 85 charachters. AP190 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
AP28.1 AP28.2
AP30.2 AP30.4
AP305 AP45.1
API1.1 API2.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
MA126 MA180
MA310 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
...
MAA-PURCH-FR-LOC Alpha 4 AM19.1 AM19.2
Element: Purch Fr Loc The vendor's purchase from location. 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
MA126 MA180
MA310 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
...
MAA-LOCATION Alpha 5 AM19.1 AM19.2
Element: Location This field contains a valid stocking AP115 AP125
location within the company inventory. AP126 AP131
AP180 AP181
AP190 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
AP28.1 AP28.2
AP30.2 AP30.4
AP305 AP45.1
API1.1 API2.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
MA126 MA180
MA310 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
...
MAA-AOC-RATE Percent 7.3 (Percent) AM19.1 AM19.2
Element: Aoc Rate Add On Cost Percentage Rate. If add on AP115 AP125
cost is spread by rate, this value times AP126 AP131
the line unit cost is the unit add on AP20.1 AP20.2
cost for the PO line. 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
MA126 MA180
MA310 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
...
MAA-API-OBJ-ID Numeric 12 AM19.1 AM19.2
Element: Obj Id This object ID links the detail records AP115 AP125
to the invoice. AP126 AP131
AP180 AP181
AP190 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
AP28.1 AP28.2
AP30.2 AP30.4
AP305 AP45.1
API1.1 API2.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
MA126 MA180
MA310 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
...
MAA-MA-REC-NBR Numeric 10 AM19.1 AM19.2
Element: Rec Number Receipt number associated with the this AP115 AP125
AOC record. AP126 AP131
AP180 AP181
AP190 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
AP28.1 AP28.2
AP30.2 AP30.4
AP305 AP45.1
API1.1 API2.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
MA126 MA180
MA310 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
...
MAA-MA-LINE-NBR Numeric 6 AM19.1 AM19.2
Element: Line Nbr The receipt line number associated with AP115 AP125
this AOC line. AP126 AP131
AP180 AP181
AP190 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
AP28.1 AP28.2
AP30.2 AP30.4
AP305 AP45.1
API1.1 API2.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
MA126 MA180
MA310 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
...
MAA-MATCH-SEQ-NBR Numeric 4 AM19.1 AM19.2
Element: Match Seq Nbr This sequence number is assigned to the AP115 AP125
detail information in order to link to AP126 AP131
the goods line. AP180 AP181
AP190 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
AP28.1 AP28.2
AP30.2 AP30.4
AP305 AP45.1
API1.1 API2.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
MA126 MA180
MA310 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
...
MAA-INVOICE-TYPE Alpha 1 AP180 AP181
Element: Invoice Type THis field will be filled in from the AP190 AP28.1
Invoice based on PO number. This is a AP28.2 AP45.1
carrier for the field. The PORECEIVE
file will have to be updated with this
field.
MAA-INVOICE-VENDOR Alpha 9 (Right Justified)
Element: Invoice VendorThis is the AP vendor that is on the
invoice. There are cases when the
invoice on the invoice and the vendor on
an interfaced PO may be different.
MAA-MATCH-OBJ-ID Numeric 12 AM19.1 AM19.2
Element: Obj Id This object ID links the MAAOCDTL record AP115 AP125
to the MAINVDTL record. There can be AP126 AP131
multiple MAAOCDTL records(AOC details) AP180 AP181
associated to one MAINVDTL record (item AP190 AP20.1
detail) AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.2 AP30.4
AP305 AP45.1
API1.1 API2.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
MA126 MA180
MA310 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.4
...
MAA-ENT-UNIT-CST Signed 18.5 AM19.1 AM19.2
Element: Intl Cost The entered unit cost in vendor price AP115 AP125
unit of measure. May be entered AP126 AP131
manually on the line or calculated from AP180 AP181
entry of cost in buy unit of measure AP190 AP20.1
terms. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.2 AP30.4
AP305 AP45.1
API1.1 API2.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
MA126 MA180
MA310 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
...
MAA-MATCH-UNIT-CST Signed 18.5 AM19.1 AM19.2
Element: Intl Cost This unit cost is updated at match. AP115 AP125
AP126 AP131
AP180 AP181
AP190 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
AP28.1 AP28.2
AP30.2 AP30.4
AP305 AP45.1
API1.1 API2.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
MA126 MA180
MA310 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
...
MAA-TOTAL-AOC Signed 18.2 AM19.1 AM19.2
Element: Intl Amt THis is the AOC in the vendor currency. AP115 AP125
The total add on cost amount can be an AP126 AP131
entered amount if entered at this level, AP20.1 AP20.2
or a calculated amount if a unit add on AP20.3 AP20.4
cost or add on cost percent is entered. AP20.5 AP20.7
The total AOC would be the UNIT-COST * AP21.1 AP220
the QUANTITY 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
MA126 MA180
MA310 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
...
MAA-TAX-CODE Alpha 10 AM19.1 AM19.2
Element: Tax Code This field contains a code representing AP115 AP125
specific tax information. This must be AP126 AP131
valid Tax Code. AP180 AP181
AP190 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
AP28.1 AP28.2
AP30.2 AP30.4
AP305 AP45.1
API1.1 API2.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
MA126 MA180
MA310 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
...
MAA-TAXABLE-FLAG Alpha 1 AM19.1 AM19.2
Element: Taxable Flag Defines if Taxable. 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
MA126 MA180
MA310 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
...
MAA-TAX-AMOUNT Signed 18.2 AM19.1 AM19.2
Element: Intl Amt This is the tax amount associated with AP115 AP125
this AOC record. AP126 AP131
AP180 AP181
AP190 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
AP28.1 AP28.2
AP30.2 AP30.4
AP305 AP45.1
API1.1 API2.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
MA126 MA180
MA310 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
...
MAA-TAX-USAGE-CD Alpha 10 AM19.1 AM19.2
Element: Tax Usage Cd The tax usage coe for the vendor. This AP115 AP125
filed is required if the AP Company AP126 AP131
inidcates that VAT reporting required. AP180 AP181
AP190 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
AP28.1 AP28.2
AP30.2 AP30.4
AP305 AP45.1
API1.1 API2.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
MA126 MA180
MA310 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
...
MAA-AOC-ON-PO Alpha 1 AM19.1 AM19.2
Element: Aoc On Po Indicates if the add-on cost is to AP115 AP125
appear on the Purchase Order document AP126 AP131
that is issued to the vendor. 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
MA126 MA180
MA310 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
...
MAA-LANDED-FLAG Numeric 1 AM19.1 AM19.2
Element: Landed Flag This flag notes that the AOC of record AP115 AP125
is landed. Landed means as the goods AP126 AP131
change the AOC will change in the same AP20.1 AP20.2
manner. 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
MA126 MA180
MA310 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
...
MAA-SUMMARY-FLAG Alpha 1 AM19.1 AM19.2
Element: Summary Flag Defines if add on cost is printed in AP115 AP125
summary or at a detail level on the AP126 AP131
Lawson Purchase Order document. 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
MA126 MA180
MA310 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
...
MAA-ZERO-COST-FLG Alpha 1 AM19.1 AM19.2
Element: Zero Cost Flg Defines if this tax record is allowed AP115 AP125
to have a zero unit cost. 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
MA126 MA180
MA310 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
...
MAA-CANCELLED-FL Alpha 1 AM19.1 AM19.2
Element: All Flag 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
MA126 MA180
MA310 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
...
MAA-CLOSED-FL Alpha 1 AM19.1 AM19.2
Element: Closed Fl The Closed Flag. 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
MA126 MA180
MA310 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
...
MAA-INV-SPRD-CRET Numeric 1 AM19.1 AM19.2
Element: Inv Sprd Cret Defines if record was created during PO AP115 AP125
invoice spread. 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
MA126 MA180
MA310 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
...
MAA-ISSUED-FLAG Alpha 1 AM19.1 AM19.2
Element: All Flag 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
MA126 MA180
MA310 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
...
MAA-INVC-TAX-AMT Signed 18.2 AM19.1 AM19.2
Element: Intl Amt The tax amount that is to be invoiced. 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
MA126 MA180
MA310 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
...
MAA-ACCR-TAX-AMT 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
MA126 MA180
MA310 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
...
MAA-EXT-TAX-AMT Signed 18.2 AM19.1 AM19.2
Element: Intl Amt The extended tax amount on the record. AP115 AP125
WHich would be the INVC-TAX-AMT and the AP126 AP131
ACCR-TAX-AMT 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
MA126 MA180
MA310 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
...
MAA-LAND-UNIT-CST Signed 18.5 AM19.1 AM19.2
Element: Intl Cost In this record the landed unit cost AP115 AP125
would be the landed ta associated to the AP126 AP131
AOC 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
MA126 MA180
MA310 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
...
MAA-AOC-ALPHA Alpha 12 AM19.1 AM19.2
Element: Aoc Alpha 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
MA126 MA180
MA310 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
...
MAA-AOC-NUM Numeric 12 AM19.1 AM19.2
Element: Aoc Num 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
MA126 MA180
MA310 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
...
MAA-AOC-AMT 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
MA126 MA180
MA310 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
...
MAA-XREF-VENDOR Alpha 9 (Right Justified) AM19.1 AM19.2
Element: Xref Vendor This is a vendor that is supported on a AP115 AP125
system outside Lawson. When records are AP126 AP131
interfaces we will maintain this vendor AP20.1 AP20.2
on the file but we will use the Lawson AP20.3 AP20.4
vendor while in the lawson application. 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
MA126 MA180
MA310 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
...
MAA-REASON-CODE Alpha 4 AM19.1 AM19.2
Element: Reason Code This field contains the reason code, AP115 AP125
which indicates the cause for AP126 AP131
chargebacks(credit memos). 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
MA126 MA180
MA310 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
...
MAA-CHARGEBACK-FL Alpha 1 AM19.1 AM19.2
Element: Chargeback Fl This flag notes if a chargeback was AP115 AP125
created for differences related to this AP126 AP131
record. 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
MA126 MA180
MA310 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
...
MAA-IR-DIFF-AMT 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
MA126 MA180
MA310 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
...
MAA-ENTERED-QTY Signed 13.4 AM19.1 AM19.2
Element: Rec Qty THis is the Quanitity entered on the AP115 AP125
invoice. If the AOC is landed the AP126 AP131
Quantity is always equal to the goods AP180 AP181
quantity on the MAIVDTL record. If the AP190 AP20.1
AOC code is non landed the entered qty AP20.2 AP20.3
could be different than the goods. AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.2 AP30.4
AP305 AP45.1
API1.1 API2.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
MA126 MA180
MA310 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
...
MAA-MATCHED-QTY Signed 13.4 AM19.1 AM19.2
Element: Quantity This is the quantity that was matched. AP115 AP125
AP126 AP131
AP180 AP181
AP190 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
AP28.1 AP28.2
AP30.2 AP30.4
AP305 AP45.1
API1.1 API2.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
MA126 MA180
MA310 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
...
MAA-DUE-DATE Numeric 8 (yyyymmdd) AM19.1 AM19.2
Element: Due Date The transaction due date. 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
MA126 MA180
MA310 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
...
MAA-TOT-DIST-AMT Signed 18.2 AM19.1 AM19.2
Element: Intl Amt Total distribution amount on this record AP115 AP125
AP126 AP131
AP180 AP181
AP190 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
AP28.1 AP28.2
AP30.2 AP30.4
AP305 AP45.1
API1.1 API2.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
MA126 MA180
MA310 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
...
MAA-TOT-BASE-AMT Signed 18.2 AM19.1 AM19.2
Element: Intl Amt AP115 AP125
AP126 AP131
AP180 AP181
AP190 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
AP28.1 AP28.2
AP30.2 AP30.4
AP305 AP45.1
API1.1 API2.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
MA126 MA180
MA310 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
...
MAA-STATUS Numeric 1 AM19.1 AM19.2
Element: Status This field displays the status of the AP115 AP125
transaction. AP126 AP131
AP180 AP181
AP190 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
AP28.1 AP28.2
AP30.2 AP30.4
AP305 AP45.1
API1.1 API2.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
MA126 MA180
MA310 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
...
MAA-DISTRIB-DATE Numeric 8 (yyyymmdd) AM19.1 AM19.2
Element: Date This field displays the system date AP115 AP125
when this was created. AP126 AP131
AP180 AP181
AP190 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
AP28.1 AP28.2
AP30.2 AP30.4
AP305 AP45.1
API1.1 API2.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
MA126 MA180
MA310 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
...
MAA-UPDATE-DATE Numeric 8 (yyyymmdd) AM19.1 AM19.2
Element: Update Date This field contains the date the record AP115 AP125
was updated. AP126 AP131
AP180 AP181
AP190 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
AP28.1 AP28.2
AP30.2 AP30.4
AP305 AP45.1
API1.1 API2.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
MA126 MA180
MA310 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
...
MAA-UPDATE-TIME Numeric 6 AM19.1 AM19.2
Element: Update Time This field contains the system time AP115 AP125
when the record was updated. AP126 AP131
AP180 AP181
AP190 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
AP28.1 AP28.2
AP30.2 AP30.4
AP305 AP45.1
API1.1 API2.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
MA126 MA180
MA310 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
...
MAA-REC-SOURCE Alpha 2 AM19.1 AM19.2
Element: Rec Source AP115 AP125
AP126 AP131
AP180 AP181
AP190 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
AP28.1 AP28.2
AP30.2 AP30.4
AP305 AP45.1
API1.1 API2.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
MA126 MA180
MA310 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
...
MAA-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. AP180 AP181
AP190 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
AP28.1 AP28.2
AP30.2 AP30.4
AP305 AP45.1
API1.1 API2.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
MA126 MA180
MA310 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
...
MAA-NO-TAX-FLAG Alpha 1 AM19.1 AM19.2
Element: Account Flag AP115 AP125
AP126 AP131
AP180 AP181
AP190 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
AP28.1 AP28.2
AP30.2 AP30.4
AP305 AP45.1
API1.1 API2.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
MA126 MA180
MA310 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
...
MAA-TAX-TYPE Alpha 1 AM19.1 AM19.2
Element: Tax Type The type of tax. 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
MA126 MA180
MA310 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
...
MAA-ITEM Alpha 32 AM19.1 AM19.2
Element: Item This field contains the item AP115 AP125
identifier. AP126 AP131
AP180 AP181
AP190 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
AP28.1 AP28.2
AP30.2 AP30.4
AP305 AP45.1
API1.1 API2.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
MA126 MA180
MA310 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
...
MAA-ITEM-TYPE Alpha 1 AM19.1 AM19.2
Element: Item Type This field identifies the line item AP115 AP125
type. AP126 AP131
AP180 AP181
AP190 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
AP28.1 AP28.2
AP30.2 AP30.4
AP305 AP45.1
API1.1 API2.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
MA126 MA180
MA310 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
...
MAA-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
MA126 MA180
MA310 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
...
MAA-ORIG-CNV-RATE Signed 14.7 AM19.1 AM19.2
Element: Acct Rate 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
MA126 MA180
MA310 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
...
MAAOCDTL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MAASET1 COMPANY AM19.1 AM19.2
VENDOR AP115 AP125
INVOICE AP126 AP131
SUFFIX AP198 AP20.1
PO-NUMBER AP20.2 AP20.3
PO-RELEASE AP20.4 AP20.5
PO-CODE AP20.7 AP21.1
LINE-NBR AP220 AP23.1
AOC-CODE AP25.1 AP25.2
SEQ-NBR AP26.1 AP27.1
AP295 AP30.2
AP30.4 AP300
AP305 API1.1
API2.1 BL120
BL122 BL130
...
MAASET10 COMPANY KeyChange MA278
PO-NUMBER
PO-RELEASE
PO-CODE
LINE-NBR
UPDATE-DATE*
UPDATE-TIME*
VENDOR
INVOICE
SUFFIX
AOC-CODE
SEQ-NBR
MAASET2 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
VENDOR AP20.5 AP20.7
INVOICE AP21.1 AP220
SUFFIX AP23.1 AP25.1
AOC-CODE AP25.2 AP26.1
SEQ-NBR AP27.1 AP30.2
AP30.4 AP305
API1.1 API2.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
...
MAASET3 COMPANY KeyChange AM19.1 AM19.2
API-OBJ-ID AP115 AP125
PO-NUMBER AP126 AP131
PO-RELEASE AP20.1 AP20.2
PO-CODE AP20.3 AP20.4
MATCH-DTL-KEY AP20.5 AP20.7
SEQ-NBR AP21.1 AP220
AOC-CODE 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
...
MAASET6 COMPANY KeyChange AP125 AP126
PO-NUMBER AP131 AP20.1
PO-RELEASE AP20.2 AP20.3
PO-CODE AP20.4 AP20.5
LINE-NBR AP20.7 AP21.1
VENDOR AP23.1 AP25.1
AOC-CODE AP25.2 AP26.1
INVOICE AP27.1 AP30.4
SUFFIX API1.1 BL120
SEQ-NBR BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA180
...
MAASET8 COMPANY KeyChange AM19.1 AM19.2
API-OBJ-ID AP115 AP125
PO-NUMBER AP126 AP131
PO-RELEASE AP20.1 AP20.2
PO-CODE AP20.3 AP20.4
LOCATION AP20.5 AP20.7
MATCH-DTL-KEY AP21.1 AP220
LINE-NBR AP23.1 AP25.1
AOC-CODE AP25.2 AP26.1
SEQ-NBR AP27.1 AP30.2
AP30.4 AP305
API1.1 API2.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
...
MAASET9 COMPANY KeyChange, Subset AM19.1 AM19.2
MATCH-OBJ-ID Where INVOICE-TYPE = Spaces AP115 AP125
MATCH-SEQ-NBR AP126 AP131
VENDOR AP20.1 AP20.2
INVOICE AP20.3 AP20.4
SUFFIX AP20.5 AP20.7
PO-NUMBER AP21.1 AP220
PO-RELEASE AP23.1 AP25.1
PO-CODE AP25.2 AP26.1
LINE-NBR AP27.1 AP30.2
AOC-CODE AP30.4 AP305
SEQ-NBR API1.1 API2.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
...
MAAOCDTL FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Apbatch APBATCH Not Required
MAA-COMPANY -> APB-COMPANY
API-BATCH-NUM -> APB-BATCH-NUM
Apinvoice APINVOICE Required
MAA-COMPANY -> API-COMPANY
MAA-VENDOR -> API-VENDOR
MAA-INVOICE -> API-INVOICE
MAA-SUFFIX -> API-SUFFIX
Zeroes -> API-CANCEL-SEQ
Mainvdtl MAINVDTL Required
MAA-COMPANY -> MAD-COMPANY
MAA-VENDOR -> MAD-VENDOR
MAA-INVOICE -> MAD-INVOICE
MAA-SUFFIX -> MAD-SUFFIX
MAA-PO-NUMBER -> MAD-PO-NUMBER
MAA-PO-RELEASE -> MAD-PO-RELEASE
MAA-PO-CODE -> MAD-PO-CODE
MAA-LINE-NBR -> MAD-LINE-NBR
MAA-SEQ-NBR -> MAD-SEQ-NBR
Poaocmast POAOCMAST Required
When ((MAA-AOC-CODE != Spaces )
And (MAA-TAX-CODE = Spaces ))
MAA-COMPANY -> PAM-COMPANY
MAA-AOC-CODE -> PAM-AOC-CODE
Poline POLINE Not Required
MAA-COMPANY -> PLI-COMPANY
MAA-PO-NUMBER -> PLI-PO-NUMBER
MAA-PO-RELEASE -> PLI-PO-RELEASE
MAA-PO-CODE -> PLI-PO-CODE
MAA-LINE-NBR -> PLI-LINE-NBR
Pomatchobj POMATCHOBJ Required
MAA-COMPANY -> PMJ-COMPANY
MAA-MATCH-OBJ-ID -> PMJ-MATCH-OBJ-ID
MAA-MATCH-SEQ-NBR -> PMJ-MATCH-SEQ-NBR
MAA-MA-REC-NBR -> PMJ-REC-NUMBER
MAA-LINE-NBR -> PMJ-LINE-NBR
MAA-AOC-CODE -> PMJ-AOC-CODE
MAAOCDTL FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Mmdist MMDIST
Valid When MAA-ITEM-TYPE != "I"
MAA-COMPANY -> MMD-COMPANY
"PO" -> MMD-SYSTEM-CD
MAA-LOCATION -> MMD-LOCATION
"PT" -> MMD-DOC-TYPE
MAA-PO-NUMBER -> MMD-DOC-NUMBER
MAA-PO-RELEASE -> MMD-DOC-NBR-NUM
MAA-PO-CODE -> MMD-PO-CODE
MAA-LINE-NBR -> MMD-LINE-NBR
Zeroes -> MMD-COMPONENT-SEQ
MAA-AOC-CODE -> MMD-AOC-CODE
MMD-LINE-SEQ
MMD-REQ-LOCATION
MMD-API-OBJ-ID
Recaocdtl RECAOCDTL
MAA-COMPANY -> REC-COMPANY
MAA-PO-NUMBER -> REC-PO-NUMBER
MAA-PO-RELEASE -> REC-PO-RELEASE
MAA-PO-CODE -> REC-PO-CODE
REC-REC-NUMBER
REC-LINE-NBR
REC-AOC-CODE
REC-VENDOR
REC-LOCATION
|