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 MA531 MA63.1 MA67.1 MA67.2
PO135 PO64.1 MM280 API5.1 BL120 BL122
BL130 BL20.1 BL20.3 BL21.2 BL21.5 BL29.1
BL29.2 BL520 BL820 BL92.1 IC28.1 MA180
MA530 MA66.2 MA66.3 MA80.1 OE10.1 OE10.2
OE10.3 OE10.4 OE10.5 OE10.6 OE10.7 OE10.8
OE11.1 OE11.4 OE11.8 OE11.9 OE110 OE111
OE113 OE114 OE116 OE129 OE13.2 OE13.3
OE13.5 OE13.6 OE14.4 OE30.1 OE30.2 OE30.3
OE30.4 OE30.5 OE30.6 OE30.7 OE30.9 OE510
OE530 OE81.1 OE810 OE830 OE90.1 OE90.2
PO100 PO101 PO122 PO131 PO20.1 PO21.2
PO21.3 PO21.4 PO21.5 PO22.1 PO23.1 PO25.1
PO25.5 PO25.6 PO25.7 PO29.1 PO30.1 PO30.2
PO30.3 PO300 PO31.1 PO31.2 PO32.2 PO33.1
PO34.1 PO35.1 PO36.1 PO36.2 PO38.1 PO39.1
PO39.2 PO44.1 PO50.1 PO52.1 PO520 PO536
POIE.1 POII.1 POIJ.1 RQ10.1 RQ10.2 WH20.2
WH20.7
UPDATED BY
AP115 AP125 AP126 AP131 AP180 AP181
AP190 AP198 AP220 AP25.1 AP25.2 AP26.1
AP27.1 AP28.1 AP28.2 AP30.2 AP30.4 AP300
AP305 AP45.1 API1.1 MA60.2 MA60.4 MA61.1
MA70.1 MA75.1 MAI1.1 POI3.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MAA-COMPANY Numeric 4 AP115 AP125
Element: Company Identifies the AP company if the AP126 AP131
resource type = V. Identifies the HR AP180 AP181
company if the resource type = E. It is AP190 AP220
blank for type A, P or Q resources. AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.2 AP30.4
AP305 AP45.1
API1.1 MA126
MA531 MA60.2
MA60.3 MA61.1
MA63.1 MA67.1
MA67.2 MAI1.1
POI3.1
MAA-VENDOR Alpha 9 (Right Justified) AP115 AP125
Element: Vendor ID The vendor's identification code. AP126 AP131
AP180 AP181
AP190 AP220
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.2 AP30.4
AP305 AP45.1
API1.1 MA126
MA531 MA60.2
MA60.3 MA61.1
MA63.1 MA67.1
MA67.2 MAI1.1
POI3.1
MAA-INVOICE Alpha 22 AP115 AP125
Element: Invoice NumberUsed to identify the invoice. AP126 AP131
AP180 AP181
AP190 AP220
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.2 AP30.4
AP305 AP45.1
API1.1 MA126
MA531 MA60.2
MA60.3 MA61.1
MA63.1 MA67.1
MA67.2 MAI1.1
POI3.1
MAA-SUFFIX Numeric 3 AP115 AP125
Element: Invoice SuffixThis is the suffix for the invoice. AP126 AP131
AP180 AP181
AP190 AP220
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.2 AP30.4
AP305 AP45.1
API1.1 MA126
MA531 MA60.2
MA60.3 MA61.1
MA63.1 MA67.1
MA67.2 MAI1.1
POI3.1
MAA-PO-NUMBER Alpha 14 (Right Justified) AP115 AP125
Element: PO Number This field contains the number AP126 AP131
representing the purchase order. AP180 AP181
AP190 AP220
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.2 AP30.4
AP305 AP45.1
API1.1 MA126
MA531 MA60.2
MA60.3 MA61.1
MA63.1 MA67.1
MA67.2 MAI1.1
POI3.1
MAA-PO-RELEASE Numeric 4 AP115 AP125
Element: PO Release NumUsed to identify a purchase order AP126 AP131
release (created from a Blanket or AP180 AP181
Standing order). AP190 AP220
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.2 AP30.4
AP305 AP45.1
API1.1 MA126
MA531 MA60.2
MA60.3 MA61.1
MA63.1 MA67.1
MA67.2 MAI1.1
POI3.1
MAA-PO-CODE Alpha 4 AP115 AP125
Element: Po Code This is the purchase order code. AP126 AP131
AP180 AP181
AP190 AP220
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.2 AP30.4
AP305 AP45.1
API1.1 MA126
MA531 MA60.2
MA60.3 MA61.1
MA63.1 MA67.1
MA67.2 MAI1.1
POI3.1
MAA-LINE-NBR Numeric 6 AP115 AP125
Element: Line Number This field contains the line number. AP126 AP131
AP180 AP181
AP190 AP220
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.2 AP30.4
AP305 AP45.1
API1.1 MA126
MA531 MA60.2
MA60.3 MA61.1
MA63.1 MA67.1
MA67.2 MAI1.1
POI3.1
MAA-AOC-CODE Alpha 2 AP115 AP125
Element: Add On Cost CoThis field contains the identifier for AP126 AP131
the add on cost associated with this AP180 AP181
line item. AP190 AP220
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.2 AP30.4
AP305 AP45.1
API1.1 MA126
MA531 MA60.2
MA60.3 MA61.1
MA63.1 MA67.1
MA67.2 MAI1.1
POI3.1
MAA-CANCEL-SEQ Numeric 4
Element: Sequence NumbeThe sequence number assigned upon a
cancellation of a distributed invoice.
The first sequence assigned is 9999.
MAA-SEQ-NBR Numeric 4 AP115 AP125
Element: Sequence NumbeAn automatically assigned sequence AP126 AP131
number. AP180 AP181
AP190 AP220
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.2 AP30.4
AP305 AP45.1
API1.1 MA126
MA531 MA60.2
MA60.3 MA61.1
MA63.1 MA67.1
MA67.2 MAI1.1
POI3.1
MAA-MATCH-DTL-KEY Alpha 85 AP115 AP125
Element: Match Dtl Key AP126 AP131
AP180 AP181
AP190 AP220
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.2 AP30.4
AP305 AP45.1
API1.1 MA126
MA531 MA60.2
MA60.3 MA61.1
MA63.1 MA67.1
MA67.2 MAI1.1
POI3.1
MAA-PURCH-FR-LOC Alpha 4
Purchase From The vendor's purchase from location.
Location Code
MAA-LOCATION Alpha 5 AP115 AP125
Element: Location Code This field contains a valid stocking AP126 AP131
location within the company inventory. AP180 AP181
AP190 AP220
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.2 AP30.4
AP305 AP45.1
API1.1 MA126
MA531 MA60.2
MA60.3 MA61.1
MA63.1 MA67.1
MA67.2 MAI1.1
POI3.1
MAA-AOC-RATE Percent 7.3 (Percent)
Element: Add On Cost RaAdd On Cost Percentage Rate. If add on
cost is spread by rate, this value times
the line unit cost is the unit add on
cost for the PO line.
MAA-API-OBJ-ID Numeric 12 AP115 AP125
Object AP126 AP131
Identification AP180 AP181
AP190 AP220
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.2 AP30.4
AP305 AP45.1
API1.1 MA126
MA531 MA60.2
MA60.3 MA61.1
MA63.1 MA67.1
MA67.2 MAI1.1
POI3.1
MAA-MA-REC-NBR Numeric 10 AP115 AP125
Element: Receiver Number AP126 AP131
AP180 AP181
AP190 AP220
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.2 AP30.4
AP305 AP45.1
API1.1 MA126
MA531 MA60.2
MA60.3 MA61.1
MA63.1 MA67.1
MA67.2 MA70.1
MA75.1 MAI1.1
MAA-MA-LINE-NBR Numeric 6 AP115 AP125
Element: Line Number AP126 AP131
AP180 AP181
AP190 AP220
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.2 AP30.4
AP305 AP45.1
API1.1 MA126
MA531 MA60.2
MA60.3 MA61.1
MA63.1 MA67.1
MA67.2 MA70.1
MA75.1 MAI1.1
MAA-MATCH-SEQ-NBR Numeric 4 AP180 AP181
Element: Match Seq Nbr AP190 AP28.1
AP28.2 AP45.1
MA70.1 MA75.1
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 Vendor
MAA-MATCH-OBJ-ID Numeric 12 AP115 AP125
Object AP126 AP131
Identification AP180 AP181
AP190 AP220
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.2 AP30.4
AP305 AP45.1
API1.1 MA126
MA531 MA60.2
MA60.3 MA60.4
MA61.1 MA63.1
MA67.1 MA67.2
MA70.1 MA75.1
MAI1.1 POI3.1
MAA-ENT-UNIT-CST Signed 18.5 AP115 AP125
Element: Intl Cost The entered unit cost. AP126 AP131
AP180 AP181
AP190 AP220
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.2 AP30.4
AP305 AP45.1
API1.1 MA126
MA531 MA60.2
MA60.3 MA61.1
MA63.1 MA67.1
MA67.2 MAI1.1
POI3.1
MAA-ORIG-UNIT-CST Signed 18.5
Element: Intl Cost
MAA-MATCH-UNIT-CST Signed 18.5 AP115 AP125
Element: Intl Cost AP126 AP131
AP180 AP181
AP190 AP220
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.2 AP30.4
AP305 AP45.1
API1.1 MA126
MA531 MA60.2
MA60.3 MA61.1
MA63.1 MA67.1
MA67.2 MAI1.1
POI3.1
MAA-TOTAL-AOC Signed 18.2
Element: Intl Amt The total add on cost amount can be an
entered amount if entered at this
level, or a calculated amount if a unit
add on cost or add on cost percent is
entered.
MAA-TAX-CODE Alpha 10 AP115 AP125
Element: Tax Code This field contains a code representing AP126 AP131
specific tax information. This must be AP180 AP181
valid Tax Code. AP190 AP220
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.2 AP30.4
AP305 AP45.1
API1.1 MA126
MA531 MA60.2
MA60.3 MA61.1
MA63.1 MA67.1
MA67.2 MAI1.1
POI3.1
MAA-TAXABLE-FLAG Alpha 1
Taxable or Defines if Taxable.
Non-Taxable Flag
MAA-TAX-AMOUNT Signed 18.2 AP115 AP125
Element: Intl Amt AP126 AP131
AP180 AP181
AP190 AP220
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.2 AP30.4
AP305 AP45.1
API1.1 MA126
MA531 MA60.2
MA60.3 MA61.1
MA63.1 MA67.1
MA67.2 MAI1.1
POI3.1
MAA-TAX-USAGE-CD Alpha 10 AP115 AP125
Element: Tax Usage Cd The tax usage coe for the vendor. This AP126 AP131
filed is required if the AP Company AP180 AP181
inidcates that VAT reporting required. AP190 AP220
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.2 AP30.4
AP305 AP45.1
API1.1 MA126
MA531 MA60.2
MA60.3 MA61.1
MA63.1 MA67.1
MA67.2 MAI1.1
MAA-AOC-ON-PO Alpha 1
Element: Aoc On Po Indicates if the add-on cost is to
appear on the Purchase Order document
that is issued to the vendor.
MAA-LANDED-FLAG Numeric 1
Element: Landed Flag
MAA-SUMMARY-FLAG Alpha 1
Element: Summary Flag Defines if add on cost is printed in
summary or at a detail level on the
Lawson Purchase Order document.
MAA-ZERO-COST-FLG Alpha 1
Element: Zero Cost FlagDefines if this tax record is allowed
to have a zero unit cost.
MAA-CANCELLED-FL Alpha 1
Element: All Flag The canceled flag.
MAA-CLOSED-FL Alpha 1
Element: Closed Flag The Closed Flag.
MAA-INV-SPRD-CRET Numeric 1
Element: Inv Sprd Cret Defines if record was created during PO
invoice spread.
MAA-ISSUED-FLAG Alpha 1
Element: All Flag This is the issue status of the purchase
order source record. If the PO has been
issued at least once since the PO source
record was created, this flag will be
set to a value of "Y". Once set to "Y",
it never changes.
MAA-INVC-TAX-AMT Signed 18.2
Element: Intl Amt fThe tax amount that is to be invoiced.
MAA-ACCR-TAX-AMT Signed 18.2
Element: Intl Amt The tax amount that is to be accrued.
MAA-EXT-TAX-AMT Signed 18.2
Element: Intl Amt
MAA-LAND-UNIT-CST Signed 18.5
Element: Intl Cost All add on costs that are landed
in addition to the product unit cost.
MAA-BL-INVC-AMT Signed 18.2
Element: Intl Amt
MAA-AOC-ALPHA Alpha 12
Element: Aoc Alpha
MAA-AOC-NUM Numeric 12
Element: Aoc Num
MAA-AOC-AMT Signed 18.2
Element: Intl Amt
MAA-XREF-VENDOR Alpha 9 (Right Justified)
Element: Xref Vendor This is a vendor that is supported on a
system outside Lawson. When records are
interfaces we will maintain this vendor
on the file but we will use the Lawson
vendor while in the lawson application.
MAA-REASON-CODE Alpha 4
Element: Reason Code This field contains the reason code,
which indicates the cause for credit
memos.
MAA-CHARGEBACK-FL Alpha 1
Element: Chargeback Fl
MAA-IR-DIFF-AMT Signed 18.2
Element: Intl Amt THis is the field that will hold the
difference between the invoice and the
receipt in order to calculate the
chargeback
MAA-ENTERED-QTY Signed 13.4 AP115 AP125
Element: Receiving Quantity AP126 AP131
AP180 AP181
AP190 AP220
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.2 AP30.4
AP305 AP45.1
API1.1 MA126
MA531 MA60.2
MA60.3 MA61.1
MA63.1 MA67.1
MA67.2 MAI1.1
MAA-MATCHED-QTY Signed 13.4 AP115 AP125
Element: Quantity AP126 AP131
AP180 AP181
AP190 AP220
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.2 AP30.4
AP305 AP45.1
API1.1 MA126
MA531 MA60.2
MA60.3 MA61.1
MA63.1 MA67.1
MA67.2 MAI1.1
POI3.1
MAA-DUE-DATE Numeric 8 (yyyymmdd)
Element: Due Date The transaction due date.
MAA-TOT-DIST-AMT Signed 18.2 AP115 AP125
Element: Intl Amt AP126 AP131
AP180 AP181
AP190 AP220
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.2 AP30.4
AP305 AP45.1
API1.1 MA126
MA531 MA60.2
MA60.3 MA61.1
MA63.1 MA67.1
MA67.2 MAI1.1
POI3.1
MAA-TOT-BASE-AMT Signed 18.2 AP115 AP125
Element: Intl Amt This defines the total distributed AP126 AP131
approval amount in the company base AP180 AP181
currency. AP190 AP220
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.2 AP30.4
AP305 AP45.1
API1.1 MA126
MA531 MA60.2
MA60.3 MA61.1
MA63.1 MA67.1
MA67.2 MAI1.1
POI3.1
MAA-STATUS Numeric 1 AP115 AP125
Element: Status This field displays the status of the AP126 AP131
transaction. AP180 AP181
AP190 AP220
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.2 AP30.4
AP305 AP45.1
API1.1 MA126
MA531 MA60.2
MA60.3 MA61.1
MA63.1 MA67.1
MA67.2 MA70.1
MA75.1 MAI1.1
POI3.1
MAA-DISTRIB-DATE Numeric 8 (yyyymmdd) AP115 AP125
Element: Date The date used for posting the AP126 AP131
transactions to the general ledger. AP180 AP181
AP190 AP220
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.2 AP30.4
AP305 AP45.1
API1.1 MA126
MA531 MA60.2
MA60.3 MA61.1
MA63.1 MA67.1
MA67.2 MAI1.1
POI3.1
MAA-UPDATE-DATE Numeric 8 (yyyymmdd) AP115 AP125
Element: Update Date This field contains the date the record AP126 AP131
was updated. AP180 AP181
AP190 AP220
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.2 AP30.4
AP305 AP45.1
API1.1 MA126
MA531 MA60.2
MA60.3 MA61.1
MA63.1 MA67.1
MA67.2 MA70.1
MA75.1 MAI1.1
MAA-UPDATE-TIME Numeric 6 AP115 AP125
Element: Update Time This field contains the system time AP126 AP131
when the record was updated. AP180 AP181
AP190 AP220
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.2 AP30.4
AP305 AP45.1
API1.1 MA126
MA531 MA60.2
MA60.3 MA61.1
MA63.1 MA67.1
MA67.2 MA70.1
MA75.1 MAI1.1
MAA-REC-SOURCE Alpha 2 AP115 AP125
Element: Rec Source AP126 AP131
AP180 AP181
AP190 AP220
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.2 AP30.4
AP305 AP45.1
API1.1 MA126
MA531 MA60.2
MA60.3 MA61.1
MA63.1 MA67.1
MA67.2 MAI1.1
POI3.1
MAA-TRAN-ND Numeric 1 AP115 AP125
Account Currency The number of decimal positions defined AP126 AP131
Code for the transaction currency. AP180 AP181
AP190 AP220
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.2 AP30.4
AP305 AP45.1
API1.1 MA126
MA531 MA60.2
MA60.3 MA61.1
MA63.1 MA67.1
MA67.2 MAI1.1
POI3.1
MAA-NO-TAX-FLAG Alpha 1 AP115 AP125
Element: Account Flag AP126 AP131
AP180 AP181
AP190 AP220
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.2 AP30.4
AP305 AP45.1
API1.1 MA126
MA531 MA60.2
MA60.3 MA61.1
MA63.1 MA67.1
MA67.2 MAI1.1
MAA-TAX-TYPE Alpha 1 AP115 AP125
Element: Tax Type The type of tax. AP126 AP131
AP220 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
API1.1 MA126
MA531 MA60.2
MA60.3 MA61.1
MA63.1 MA67.1
MA67.2 MAI1.1
POI3.1
MAA-ITEM Alpha 32 AP115 AP125
Element: Item Number This field contains the item AP126 AP131
identifier. AP180 AP181
AP190 AP220
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.2 AP30.4
AP305 AP45.1
API1.1 MA126
MA531 MA60.2
MA60.3 MA61.1
MA63.1 MA67.1
MA67.2 MAI1.1
POI3.1
MAA-ITEM-TYPE Alpha 1 AP115 AP125
Element: Item Type This field identifies the line item AP126 AP131
type. AP180 AP181
AP190 AP220
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.2 AP30.4
AP305 AP45.1
API1.1 MA126
MA531 MA60.2
MA60.3 MA61.1
MA63.1 MA67.1
MA67.2 MAI1.1
POI3.1
MAA-CURRENCY-CODE Alpha 5
Element: Currency Code This field contains the company base
currency code established in Company
(GL10.1 ).
MAA-TOTAL-AOC-PO Signed 18.2
Element: Intl Amt
MAA-ORIG-CNV-RATE Signed 14.7
Element: Account Rate Represents the currency exchange rate
the transaction was created with.
MAAOCDTL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MAASET1 COMPANY AP115 AP125
VENDOR AP126 AP131
INVOICE AP198 AP220
SUFFIX AP25.1 AP25.2
PO-NUMBER AP26.1 AP27.1
PO-RELEASE AP295 AP30.2
PO-CODE AP30.4 AP300
LINE-NBR AP305 API1.1
AOC-CODE MA126 MA531
SEQ-NBR MA60.2 MA60.3
MA60.4 MA61.1
MA63.1 MA67.1
MA67.2 MAI1.1
MAASET10 COMPANY KeyChange
PO-NUMBER
PO-RELEASE
PO-CODE
LINE-NBR
UPDATE-DATE*
UPDATE-TIME*
VENDOR
INVOICE
SUFFIX
AOC-CODE
SEQ-NBR
MAASET2 COMPANY KeyChange AP115 AP125
PO-NUMBER AP126 AP131
PO-RELEASE AP220 AP25.1
PO-CODE AP25.2 AP26.1
LINE-NBR AP27.1 AP30.2
VENDOR AP30.4 AP305
INVOICE MA61.1 MAI1.1
SUFFIX PO135 PO64.1
AOC-CODE MM280
SEQ-NBR
MAASET3 COMPANY KeyChange AP115 AP125
API-OBJ-ID AP126 AP131
PO-NUMBER AP220 AP25.1
PO-RELEASE AP25.2 AP26.1
PO-CODE AP27.1 AP30.2
MATCH-DTL-KEY AP30.4 AP305
SEQ-NBR MA61.1 MAI1.1
AOC-CODE
MAASET4 COMPANY KeyChange AP115 AP125
VENDOR AP126 AP131
INVOICE AP220 AP25.1
SUFFIX AP25.2 AP26.1
PO-NUMBER AP27.1 AP30.2
PO-RELEASE AP30.4 AP305
PO-CODE MA61.1 MAI1.1
AOC-CODE
SEQ-NBR
MAASET6 COMPANY KeyChange AP125 AP126
PO-NUMBER AP131 AP25.1
PO-RELEASE AP25.2 AP26.1
PO-CODE AP27.1 AP30.4
LINE-NBR API5.1 BL120
VENDOR BL122 BL130
AOC-CODE BL20.1 BL20.3
INVOICE BL21.2 BL21.5
SUFFIX BL29.1 BL29.2
SEQ-NBR BL520 BL820
BL92.1 IC28.1
MA180 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
...
MAASET8 COMPANY KeyChange AP115 AP125
API-OBJ-ID AP126 AP131
PO-NUMBER AP220 AP25.1
PO-RELEASE AP25.2 AP26.1
PO-CODE AP27.1 AP30.2
LOCATION AP30.4 AP305
MATCH-DTL-KEY MA61.1 MA70.1
LINE-NBR MA75.1 MAI1.1
AOC-CODE
SEQ-NBR
MAASET9 COMPANY KeyChange, Subset AP115 AP125
MATCH-OBJ-ID Where INVOICE-TYPE = Spaces AP126 AP131
MATCH-SEQ-NBR AP220 AP25.1
VENDOR AP25.2 AP26.1
INVOICE AP27.1 AP30.2
SUFFIX AP30.4 AP305
PO-NUMBER MA61.1 MAI1.1
PO-RELEASE
PO-CODE
LINE-NBR
AOC-CODE
SEQ-NBR
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
|