Lawson Insight Technical Documentation |
|
MMDIST
MMDIST FILE
Account Distributions
This record holds an account number and possibly an activity code intended for
a general ledger distribution of a non-inventory item, or a Inventory Item
("I" type) that has been expensed (issued). The record is for an item on
either a requisition, a purchase order or a standard purchase order. For a
non-inventory item and an Inventory Item (Issue), there may be multiple
distribution accounts (more than one MMDIST).
This record may also exist as a result of building general ledger transactions
for inventory items. These come out of the subledger posting programs for
inventory control and purchase order. They are used by drill arounds out of
the general ledger programs when tracing back the origin of a general ledger
transaction.
REFERENCED BY
API2.1 IC220 IC240 IC242 IC280 IC282
IC55.1 IC55.2 PO190 PO220 PO223 PO24.1
PO254 PO54.1 PO54.2 PO54.3 PO54.4 RQ230
WO293 MM280 MA236 POIG.1 POIM.1 RQ111
RQID.1 RQIJ.1
UPDATED BY
AP115 AP125 AP126 AP131 AP220 AP25.1
AP25.2 AP26.1 AP27.1 AP30.2 AP30.4 AP300
AP305 API1.1 BL120 BL122 BL130 BL20.1
BL20.3 BL21.2 BL21.5 BL29.1 BL29.2 BL520
BL820 BL92.1 DR100 IC130 IC131 IC141
IC142 IC28.1 IC300 IC83.1 MA126 MA180
MA530 MA531 MA60.2 MA60.3 MA60.5 MA61.1
MA63.1 MA65.1 MA66.2 MA66.3 MA67.1 MA67.2
MA68.1 MA70.1 MA75.1 MA80.1 MAI1.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 PO135
PO136 PO20.1 PO21.1 PO21.2 PO21.3 PO21.4
PO21.5 PO22.1 PO23.1 PO25.1 PO25.5 PO25.6
PO25.7 PO26.1 PO27.2 PO29.1 PO30.1 PO30.2
PO30.3 PO300 PO31.1 PO31.2 PO32.1 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 POI3.1 POIE.1 POIF.1 POII.1 POIJ.1
RQ10.1 RQ10.2 RQ10.3 RQ11.1 RQ12.1 RQ13.1
RQ13.2 RQ35.1 RQ500 RQIF.1 WH130 WH132
WH190 WH20.2 WH20.7 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 WO140 RQ300
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MMD-COMPANY Numeric 4 AP115 AP125
Element: Company The company number. AP126 AP131
AP220 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 DR100
IC130 IC141
IC142 IC28.1
IC83.1 MA126
MA180 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA63.1
MA65.1 MA66.2
MA66.3 MA67.1
MA67.2 MA68.1
MA70.1 MA75.1
MA80.1 MAI1.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
...
MMD-SYSTEM-CD Alpha 2 AP115 AP125
Element: System Code This field indicates on what system the AP126 AP131
transaction originated. AP220 AP25.1
IC = INVENTORY-CONTROL AP25.2 AP26.1
PO = PURCHASE-ORDER AP27.1 AP30.2
RQ = REQUISITIONS AP30.4 AP305
AP = Accounts Payable API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 DR100
IC130 IC141
IC142 IC28.1
IC83.1 MA126
MA180 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA63.1
MA65.1 MA66.2
MA66.3 MA67.1
MA67.2 MA68.1
MA70.1 MA75.1
MA80.1 MAI1.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
...
MMD-LOCATION Alpha 5 AP115 AP125
Element: Location Code This field contains a valid stock AP126 AP131
location within the company inventory. AP220 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 DR100
IC130 IC141
IC142 IC28.1
IC83.1 MA126
MA180 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA63.1
MA65.1 MA66.2
MA66.3 MA67.1
MA67.2 MA68.1
MA70.1 MA75.1
MA80.1 MAI1.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
...
MMD-DOC-TYPE Alpha 2 AP115 AP125
Element: Document Type This field contains the type of AP126 AP131
transaction. AP220 AP25.1
AJ = Adjustment AP25.2 AP26.1
AR = Receiving Archive AP27.1 AP30.2
CA = Cost Adjustment AP30.4 AP305
CR = Customer Return API1.1 BL120
DT = Direct Transfer BL122 BL130
IN = Invoice Details BL20.1 BL20.3
IS = Issue BL21.2 BL21.5
IT = Transfer Issue BL29.1 BL29.2
PA = Price Agreement BL520 BL820
PI = Physical Inventory Adjustment BL92.1 DR100
PO = PO Receiving IC130 IC141
PT = Purchase Order Template-New PO IC142 IC28.1
RA = Receiving Adjustment IC83.1 MA126
RC = Receipt MA180 MA530
RJ = Inspection Reject MA531 MA60.2
RR = Requisition Return MA60.3 MA60.5
RT = Receiving Transfer MA61.1 MA63.1
VA = Vendor Return Adjustment MA65.1 MA66.2
VR = Vendor Return MA66.3 MA67.1
IF = Interface MA67.2 MA68.1
RQ = Requisition MA70.1 MA75.1
AC = Accepted Inspection MA80.1 MAI1.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
...
MMD-DOC-NUMBER Alpha 14 (Right Justified) AP115 AP125
Element: Doc Number AP126 AP131
AP220 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 DR100
IC130 IC141
IC142 IC28.1
IC83.1 MA126
MA180 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA63.1
MA65.1 MA66.2
MA66.3 MA67.1
MA67.2 MA68.1
MA70.1 MA75.1
MA80.1 MAI1.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
...
MMD-DOC-NBR-NUM Numeric 10 AP115 AP125
Element: Doc Nbr Num This field contains the number for the AP126 AP131
document tied to the distribution if a AP220 AP25.1
numeric document. AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 DR100
IC130 IC141
IC142 IC28.1
IC83.1 MA126
MA180 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA63.1
MA65.1 MA66.2
MA66.3 MA67.1
MA67.2 MA68.1
MA70.1 MA75.1
MA80.1 MAI1.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
...
MMD-PO-CODE Alpha 4 AP115 AP125
Element: Po Code This is the purchase order code. AP126 AP131
AP220 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 DR100
IC130 IC141
IC142 IC28.1
IC83.1 MA126
MA180 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA63.1
MA65.1 MA66.2
MA66.3 MA67.1
MA67.2 MA68.1
MA70.1 MA75.1
MA80.1 MAI1.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
...
MMD-LINE-NBR Numeric 6 AP115 AP125
Element: Line Number This field contains the line number. AP126 AP131
AP220 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 DR100
IC130 IC141
IC142 IC28.1
IC83.1 MA126
MA180 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA63.1
MA65.1 MA66.2
MA66.3 MA67.1
MA67.2 MA68.1
MA70.1 MA75.1
MA80.1 MAI1.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
...
MMD-COMPONENT-SEQ Numeric 3 AP115 AP125
Element: Sequence NumbeThis field contains the component AP126 AP131
sequence number. AP220 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 DR100
IC130 IC141
IC142 IC28.1
IC83.1 MA126
MA180 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA63.1
MA65.1 MA66.2
MA66.3 MA67.1
MA67.2 MA68.1
MA70.1 MA75.1
MA80.1 MAI1.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
...
MMD-LINE-SEQ Numeric 3 AP115 AP125
Element: Sequence NumbeSequence number within a line number. AP126 AP131
AP220 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 DR100
IC130 IC141
IC142 IC28.1
IC83.1 MA126
MA180 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA63.1
MA65.1 MA66.2
MA66.3 MA67.1
MA67.2 MA68.1
MA70.1 MA75.1
MA80.1 MAI1.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
...
MMD-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 AP220 AP25.1
line item. AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 DR100
IC130 IC141
IC142 IC28.1
IC83.1 MA126
MA180 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA63.1
MA65.1 MA66.2
MA66.3 MA67.1
MA67.2 MA68.1
MA70.1 MA75.1
MA80.1 MAI1.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
...
MMD-REQ-LOCATION Alpha 5 AP115 AP125
Element: To Location The location requisitioning items. AP126 AP131
This location can be an inventory or AP220 AP25.1
noninventory location. AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 DR100
IC130 IC141
IC142 IC28.1
IC83.1 MA126
MA180 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA63.1
MA65.1 MA66.2
MA66.3 MA67.1
MA67.2 MA68.1
MA70.1 MA75.1
MA80.1 MAI1.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
...
MMD-ACCT-UNIT Alpha 15 AP115 AP125
Element: Accounting UniThe accounting unit is a shorthand AP126 AP131
notation representing the variable level AP220 AP25.1
number. When used in the General Ledger AP25.2 AP26.1
account master file, the accounting unit AP27.1 AP30.2
must be defined in the General Ledger AP30.4 AP305
names file as a posting accounting unit. API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 DR100
IC130 IC141
IC142 IC28.1
IC83.1 MA126
MA180 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA63.1
MA65.1 MA66.2
MA66.3 MA67.1
MA67.2 MA68.1
MA70.1 MA75.1
MA80.1 MAI1.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
...
MMD-ACCOUNT Numeric 6 AP115 AP125
Element: Account This field along with the accounting AP126 AP131
unit and subaccount make up the location AP220 AP25.1
(account) where amounts and other AP25.2 AP26.1
account information is stored. AP27.1 AP30.2
AP30.4 AP305
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 DR100
IC130 IC141
IC142 IC28.1
IC83.1 MA126
MA180 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA63.1
MA65.1 MA66.2
MA66.3 MA67.1
MA67.2 MA68.1
MA70.1 MA75.1
MA80.1 MAI1.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
...
MMD-SUB-ACCT Numeric 4 AP115 AP125
Element: Subaccount This field contains the subaccount from AP126 AP131
your general ledger chart of accounts AP220 AP25.1
that was charged with the amount carried AP25.2 AP26.1
on this record. AP27.1 AP30.2
AP30.4 AP305
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 DR100
IC130 IC141
IC142 IC28.1
IC83.1 MA126
MA180 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA63.1
MA65.1 MA66.2
MA66.3 MA67.1
MA67.2 MA68.1
MA70.1 MA75.1
MA80.1 MAI1.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
...
MMD-DIST-COMPANY Numeric 4 AP115 AP125
Element: Company The company number used for posting the AP126 AP131
transaction. A valid intercompany AP220 AP25.1
relationship must be defined in the AP25.2 AP26.1
General Ledger system. AP27.1 AP30.2
AP30.4 AP305
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 DR100
IC130 IC141
IC142 IC28.1
IC83.1 MA126
MA180 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA63.1
MA65.1 MA66.2
MA66.3 MA67.1
MA67.2 MA68.1
MA70.1 MA75.1
MA80.1 MAI1.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
...
MMD-ACTIVITY Alpha 15 AP115 AP125
Element: Activity Activities are the processes or AP126 AP131
procedures that produce work. Cost AP220 AP25.1
objects (products, services, customers, AP25.2 AP26.1
and so on) are the reasons for AP27.1 AP30.2
performing the activity. Activities and AP30.4 AP305
cost object activities are used API1.1 BL120
synonymously in the Activity Management BL122 BL130
system. Direct costs are posted to BL20.1 BL20.3
activities, and indirect costs are BL21.2 BL21.5
allocated to activities based on BL29.1 BL29.2
activity drivers. BL520 BL820
BL92.1 DR100
Activities are grouped or organized by IC130 IC141
activity levels. There are two types of IC142 IC28.1
activities: "posting allowed" and IC83.1 MA126
"summary only." Use posting level MA180 MA530
activities to budget and maintain all MA531 MA60.2
posted transactions. Summary activities MA60.3 MA60.5
or macro activities combine information MA61.1 MA63.1
and balances from lower level activities MA65.1 MA66.2
for reporting and inquiries. MA66.3 MA67.1
MA67.2 MA68.1
MA70.1 MA75.1
MA80.1 MAI1.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
...
MMD-ACCT-CATEGORY Alpha 5 AP115 AP125
Element: Account CategoAccount categories are groupings of AP126 AP131
costs, revenues, or a combination of AP220 AP25.1
both used for reporting and inquiries AP25.2 AP26.1
for activities in the Activity AP27.1 AP30.2
Management system. All transactions are AP30.4 AP305
posted to an account category within an API1.1 BL120
activity. You can assign a specific BL122 BL130
general ledger account or range of BL20.1 BL20.3
accounts (company, accounting unit, BL21.2 BL21.5
account, and subaccount) that make up BL29.1 BL29.2
the transactions posted to an account BL520 BL820
category using AC07.1 (Account BL92.1 DR100
Assignment). IC130 IC141
IC142 IC28.1
Period-to-date, year-to-date, and IC83.1 MA126
life-to-date balances are maintained by MA180 MA530
account category for activities. Account MA531 MA60.2
categories must be assigned to MA60.3 MA60.5
activities before you do any budgeting MA61.1 MA63.1
or transaction processing. MA65.1 MA66.2
MA66.3 MA67.1
MA67.2 MA68.1
MA70.1 MA75.1
MA80.1 MAI1.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
...
MMD-BILL-CATEGORY Alpha 32 AP115 AP125
Element: Bill Category AP126 AP131
AP220 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 DR100
IC130 IC141
IC142 IC28.1
IC83.1 MA126
MA180 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA63.1
MA65.1 MA66.2
MA66.3 MA67.1
MA67.2 MA68.1
MA70.1 MA75.1
MA80.1 MAI1.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
...
MMD-ASSET-TEMPLATE Alpha 10 AP115 AP125
Element: Asset TemplateA user-defined asset template AP126 AP131
identifies general asset creation AP220 AP25.1
parameters that you can use to quickly AP25.2 AP26.1
add assets with minimal keying. Using a AP27.1 AP30.2
template lets you default many data AP30.4 AP305
items associated with a new asset. API1.1 BL120
BL122 BL130
You can use an asset template to BL20.1 BL20.3
process quick asset additions in AM20.1 BL21.2 BL21.5
(Quick Addition) and to create assets BL29.1 BL29.2
and asset books from Accounts Payable BL520 BL820
and Activity Management interface BL92.1 DR100
information. Asset templates are IC130 IC141
required if you define new assets as a IC142 IC28.1
result of transactions interfaced from IC83.1 MA126
the Purchase Order or Accounts Payable MA180 MA530
systems. MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA63.1
MA65.1 MA66.2
MA66.3 MA67.1
MA67.2 MA68.1
MA70.1 MA75.1
MA80.1 MAI1.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
...
MMD-ASSET Numeric 10 AP115 AP125
Element: Asset Number The asset number contains up to ten AP126 AP131
numeric characters that uniquely AP220 AP25.1
identify an asset. Assets are AP25.2 AP26.1
automatically numbered system-wide. AP27.1 AP30.2
AP30.4 AP305
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 DR100
IC130 IC141
IC142 IC28.1
IC83.1 MA126
MA180 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA63.1
MA65.1 MA66.2
MA66.3 MA67.1
MA67.2 MA68.1
MA70.1 MA75.1
MA80.1 MAI1.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
...
MMD-DIST-PERCENT Signed 6.3 AP115 AP125
Element: Total Percent This field indicates the percent of the AP126 AP131
extended value of the line that is AP220 AP25.1
associated with this account, if the AP25.2 AP26.1
breakdown is by percent. 100 % is AP27.1 AP30.2
stored as 100.000. AP30.4 AP305
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 DR100
IC130 IC141
IC142 IC28.1
IC83.1 MA126
MA180 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA63.1
MA65.1 MA66.2
MA66.3 MA67.1
MA67.2 MA68.1
MA70.1 MA75.1
MA80.1 MAI1.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
...
MMD-DIST-QTY Signed 13.4 AP115 AP125
Element: Quantity This field indicates the quantity from AP126 AP131
the line that is to be posted to this AP220 AP25.1
account, if distributed by quantity. The AP25.2 AP26.1
total amount distributed would be AP27.1 AP30.2
quantity times unit cost. AP30.4 AP305
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 DR100
IC130 IC141
IC142 IC28.1
IC83.1 MA126
MA180 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA63.1
MA65.1 MA66.2
MA66.3 MA67.1
MA67.2 MA68.1
MA70.1 MA75.1
MA80.1 MAI1.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
...
MMD-DIST-AMOUNT Signed 18.2 AP115 AP125
Element: Intl Amt This is the total amount posted to the AP126 AP131
general ledger for this account. This AP220 AP25.1
field is used for drillback information AP25.2 AP26.1
to transactions from the Inventory AP27.1 AP30.2
Control system and inventory and AP30.4 AP305
received not invoiced items from the API1.1 BL120
Purchase Order system. BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 DR100
IC130 IC141
IC142 IC28.1
IC83.1 MA126
MA180 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA63.1
MA65.1 MA66.2
MA66.3 MA67.1
MA67.2 MA68.1
MA70.1 MA75.1
MA80.1 MAI1.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
...
MMD-POSTING-TYPE Alpha 2 AP115 AP125
Element: Posting Type For distribution records posted from AP126 AP131
Inventory Control, this field indicates AP220 AP25.1
if the postings were to the inventory AP25.2 AP26.1
account or offset accounts. AP27.1 AP30.2
I1 = Inventory AP30.4 AP305
O1 = Offset API1.1 BL120
E1 = RNI Expense Account BL122 BL130
RN = Received Not Invoiced BL20.1 BL20.3
MN = Matched Not Received BL21.2 BL21.5
A = Add On Cost BL29.1 BL29.2
BL520 BL820
BL92.1 DR100
IC130 IC141
IC142 IC28.1
IC83.1 MA126
MA180 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA63.1
MA65.1 MA66.2
MA66.3 MA67.1
MA67.2 MA68.1
MA70.1 MA75.1
MA80.1 MAI1.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
...
MMD-STATUS Numeric 1 AP115 AP125
Element: Status This field displays the status of the AP126 AP131
transaction. AP220 AP25.1
0 = Unposted AP25.2 AP26.1
1 = Posted AP27.1 AP30.2
2 = Not to be Posted AP30.4 AP305
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 DR100
IC130 IC141
IC142 IC28.1
IC83.1 MA126
MA180 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA63.1
MA65.1 MA66.2
MA66.3 MA67.1
MA67.2 MA68.1
MA70.1 MA75.1
MA80.1 MAI1.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
...
MMD-POSTED-DATE Numeric 8 (yyyymmdd) AP115 AP125
Element: Posted Date Date posted to the General Ledger AP126 AP131
system. AP220 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 DR100
IC130 IC141
IC142 IC28.1
IC83.1 MA126
MA180 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA63.1
MA65.1 MA66.2
MA66.3 MA67.1
MA67.2 MA68.1
MA70.1 MA75.1
MA80.1 MAI1.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
...
MMD-POSTED-TIME Numeric 6 (hhmmss) AP115 AP125
Element: Sys Time Time posted to the General Ledger AP126 AP131
system. AP220 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 DR100
IC130 IC141
IC142 IC28.1
IC83.1 MA126
MA180 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA63.1
MA65.1 MA66.2
MA66.3 MA67.1
MA67.2 MA68.1
MA70.1 MA75.1
MA80.1 MAI1.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
...
MMD-GLT-OBJ-ID Numeric 12 AP115 AP125
Object This is a subsystem General Ledger AP126 AP131
Identification interface identification number. It is AP220 AP25.1
used for Drill Around purposes. AP25.2 AP26.1
AP27.1 AP30.2
In addition, if a GL Commmitment is AP30.4 AP305
written to the GLCOMMITX file from RQ or API1.1 BL120
PO, then the GLT-OBJ-ID assigned by the BL122 BL130
GL system is placed in the MMDIST record BL20.1 BL20.3
and the GLCOMMITX record. The GLT-OBJ-ID BL21.2 BL21.5
on the MMDIST record is used later via BL29.1 BL29.2
PO and AP as a key to remove a BL520 BL820
corresponding GLCOMMITX record. BL92.1 DR100
IC130 IC141
IC142 IC28.1
IC83.1 MA126
MA180 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA63.1
MA65.1 MA66.2
MA66.3 MA67.1
MA67.2 MA68.1
MA70.1 MA75.1
MA80.1 MAI1.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
...
MMD-ATN-OBJ-ID Numeric 12 AP115 AP125
Object This field is used to link general AP126 AP131
Identification ledger distributions in the Purchase AP220 AP25.1
Order system to activities in the AP25.2 AP26.1
Activity Management system. The field AP27.1 AP30.2
allows drill backs to the distribution AP30.4 AP305
records from the activities. API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 DR100
IC130 IC141
IC142 IC28.1
IC83.1 MA126
MA180 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA63.1
MA65.1 MA66.2
MA66.3 MA67.1
MA67.2 MA68.1
MA70.1 MA75.1
MA80.1 MAI1.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
...
MMD-API-OBJ-ID Numeric 12 AP115 AP125
Object AP126 AP131
Identification AP220 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 DR100
IC130 IC141
IC142 IC28.1
IC83.1 MA126
MA180 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA63.1
MA65.1 MA66.2
MA66.3 MA67.1
MA67.2 MA68.1
MA70.1 MA75.1
MA80.1 MAI1.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
...
MMD-PULL-FOR-FR-FL Alpha 1 AP115 AP125
Element: Pull For Fr FlIf Y-Yes the user has specified to AP126 AP131
process transactions to a retail AP220 AP25.1
financial reporting extract file. AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 DR100
IC130 IC131
IC141 IC142
IC28.1 IC83.1
MA126 MA180
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA63.1 MA65.1
MA66.2 MA66.3
MA67.1 MA67.2
MA68.1 MA70.1
MA75.1 MA80.1
MAI1.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
...
MMD-RNI-OBJ-ID Numeric 12 AP115 AP125
Object AP126 AP131
Identification AP220 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 DR100
IC130 IC141
IC142 IC28.1
IC83.1 MA126
MA180 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA63.1
MA65.1 MA66.2
MA66.3 MA67.1
MA67.2 MA68.1
MA70.1 MA75.1
MA80.1 MAI1.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
...
MMDIST FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MMDSET1 COMPANY AP115 AP125
SYSTEM-CD AP126 AP131
LOCATION AP220 AP25.1
DOC-TYPE AP25.2 AP26.1
DOC-NUMBER AP27.1 AP30.2
DOC-NBR-NUM AP30.4 AP305
PO-CODE API1.1 API2.1
LINE-NBR BL120 BL122
COMPONENT-SEQ BL130 BL20.1
AOC-CODE BL20.3 BL21.2
LINE-SEQ BL21.5 BL29.1
REQ-LOCATION BL29.2 BL520
API-OBJ-ID BL820 BL92.1
DR100 IC130
IC141 IC142
...
MMDSET10 COMPANY Subset IC131
SYSTEM-CD Where (PULL-FOR-FR-FL = "Y" )
LOCATION
DOC-TYPE
DOC-NUMBER
DOC-NBR-NUM
PO-CODE
LINE-NBR
COMPONENT-SEQ
AOC-CODE
LINE-SEQ
REQ-LOCATION
API-OBJ-ID
MMDSET11 COMPANY This key was added to allow alternate AP125 AP126
SYSTEM-CD file access for correcting DBAPIERROR AP131 AP25.1
LOCATION problems. AP25.2 AP26.1
DOC-TYPE KeyChange AP27.1 AP30.4
DOC-NUMBER BL120 BL122
DOC-NBR-NUM BL130 BL20.1
PO-CODE BL20.3 BL21.2
LINE-NBR BL21.5 BL29.1
COMPONENT-SEQ BL29.2 BL520
AOC-CODE BL820 BL92.1
LINE-SEQ IC28.1 MA180
API-OBJ-ID MA530 MA531
REQ-LOCATION MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
...
MMDSET12 RNI-OBJ-ID KeyChange, Subset MM280
COMPANY Where RNI-OBJ-ID != Zeroes
SYSTEM-CD
LOCATION
DOC-TYPE
DOC-NUMBER
DOC-NBR-NUM
LINE-NBR
COMPONENT-SEQ
LINE-SEQ
MMDSET2 ATN-OBJ-ID KeyChange, Subset
COMPANY Where ATN-OBJ-ID != Zeroes
SYSTEM-CD
LOCATION
DOC-TYPE
DOC-NUMBER
DOC-NBR-NUM
LINE-NBR
COMPONENT-SEQ
LINE-SEQ
MMDSET3 GLT-OBJ-ID KeyChange, Subset MM280
COMPANY Where GLT-OBJ-ID != Zeroes
SYSTEM-CD
LOCATION
DOC-TYPE
DOC-NUMBER
DOC-NBR-NUM
LINE-NBR
COMPONENT-SEQ
LINE-SEQ
MMDSET4 COMPANY Subset AP125 AP126
DOC-NUMBER Where SYSTEM-CD = "PO" AP131 AP25.1
DOC-NBR-NUM And DOC-TYPE = "PT" AP25.2 AP26.1
PO-CODE And LINE-SEQ < 997 AP27.1 AP30.4
LINE-NBR API1.1 BL120
AOC-CODE BL122 BL130
LINE-SEQ BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC28.1
MA180 MA236
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
...
MMDSET5 COMPANY Subset AP115 AP125
API-OBJ-ID Where SYSTEM-CD = "AP" AP126 AP131
LINE-NBR AP220 AP25.1
AOC-CODE AP25.2 AP26.1
LINE-SEQ AP27.1 AP30.2
AP30.4 AP300
AP305 API1.1
DR100 IC141
IC142 IC83.1
MA126 MA236
MA60.2 MA60.3
MA61.1 MA63.1
MA65.1 MA66.2
MA68.1 MA70.1
MA75.1 MAI1.1
...
MMDSET6 COMPANY KeyChange, Subset BL120 BL122
SYSTEM-CD Where DOC-TYPE = "IF" BL130 BL20.1
DOC-NUMBER BL20.3 BL21.2
DOC-NBR-NUM BL21.5 BL29.1
REQ-LOCATION BL29.2 BL520
LINE-NBR BL820 BL92.1
LINE-SEQ 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
...
MMDSET7 COMPANY Subset AP115 AP125
SYSTEM-CD Where STATUS = Zeroes AP126 AP131
DOC-TYPE And ((SYSTEM-CD = "PO" ) AP220 AP25.1
DOC-NUMBER And (DOC-TYPE != "VA" ) AP25.2 AP26.1
DOC-NBR-NUM And (DOC-TYPE != "VR" )) AP27.1 AP30.2
LINE-NBR Or ((SYSTEM-CD = "RQ" ) AP30.4 AP305
LINE-SEQ And (DOC-TYPE = "IS" ) API1.1 BL120
Or (DOC-TYPE = "RR" )) BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 DR100
IC130 IC141
IC142 IC28.1
...
MMDSET8 COMPANY Subset AP125 AP126
DOC-NBR-NUM Where SYSTEM-CD = "RQ" AP131 AP25.1
LINE-NBR And DOC-TYPE = "RQ" AP25.2 AP26.1
LINE-SEQ AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
IC28.1 IC83.1
MA180 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
...
MMDSET9 COMPANY This index is used for budget checking BL92.1 MA531
SYSTEM-CD and commitment processing when working OE114 PO30.1
DOC-TYPE with activities. PO30.2 PO30.3
DOC-NUMBER Subset PO300 PO33.1
DOC-NBR-NUM Where (SYSTEM-CD = "PO" PO34.1 PO39.2
PO-CODE And DOC-TYPE = "PT" PO52.1 POIF.1
LINE-NBR And LINE-SEQ < 997 ) POIG.1 POIM.1
AOC-CODE Or (SYSTEM-CD = "RQ" WH130 WH132
LINE-SEQ And DOC-TYPE = "RQ" ) 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
...
MMDIST FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Glmaster GLMASTER Required
MMD-COMPANY -> GLM-COMPANY
MMD-ACCT-UNIT -> GLM-ACCT-UNIT
MMD-ACCOUNT -> GLM-ACCOUNT
MMD-SUB-ACCT -> GLM-SUB-ACCOUNT
Ictrans ICTRANS Required
When MMD-SYSTEM-CD = "IC"
MMD-COMPANY -> ICT-COMPANY
MMD-LOCATION -> ICT-LOCATION
MMD-DOC-TYPE -> ICT-DOC-TYPE
MMD-SYSTEM-CD -> ICT-SYSTEM-CD
MMD-DOC-NUMBER -> ICT-DOCUMENT
MMD-DOC-NBR-NUM -> ICT-SHIPMENT-NBR
MMD-LINE-NBR -> ICT-LINE-NBR
MMD-COMPONENT-SEQ -> ICT-COMPONENT-SEQ
Poline POLINE Required
When MMD-SYSTEM-CD = "PO"
And MMD-DOC-TYPE = "PT"
MMD-COMPANY -> PLI-COMPANY
MMD-DOC-NUMBER -> PLI-PO-NUMBER
MMD-DOC-NBR-NUM -> PLI-PO-RELEASE
MMD-PO-CODE -> PLI-PO-CODE
MMD-LINE-NBR -> PLI-LINE-NBR
Porecline PORECLINE Required
When (MMD-DOC-TYPE = "PO" )
MMD-COMPANY -> PRL-COMPANY
MMD-DOC-NUMBER -> PRL-REC-NUMBER-A
MMD-LINE-NBR -> PRL-LINE-NBR
Poreturnhd PORETURNHD Required
When MMD-DOC-TYPE = "VR"
MMD-COMPANY -> PTH-COMPANY
MMD-DOC-NBR-NUM -> PTH-RETURN-NUMBER
Poreturnln PORETURNLN Required
When MMD-DOC-TYPE = "VR"
MMD-COMPANY -> PTL-COMPANY
MMD-DOC-NBR-NUM -> PTL-RETURN-NUMBER
MMD-LINE-NBR -> PTL-RET-LINE-NBR
Purchorder PURCHORDER Required
When MMD-SYSTEM-CD = "PO"
And MMD-DOC-TYPE = "PT"
MMD-COMPANY -> PCR-COMPANY
MMD-PO-CODE -> PCR-PO-CODE
MMD-DOC-NUMBER -> PCR-PO-NUMBER
MMD-DOC-NBR-NUM -> PCR-PO-RELEASE
Reqline REQLINE Required
MMD-COMPANY -> RLN-COMPANY
MMD-DOC-NBR-NUM -> RLN-REQ-NUMBER
MMD-LINE-NBR -> RLN-LINE-NBR
MMDIST FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Sltrans SLTRANS
MMD-GLT-OBJ-ID -> SLT-GLT-OBJ-ID
SLT-OBJ-ID
|