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
PO220 PO223 PO253 PO254 PO54.1 PO54.2
PO54.3 PO54.4 POIE.1 MM280 MM80.1 MM80.2
RQ230 PO278 AM17.1 MA236 POIG.1 POIM.1
RQ111 RQID.1 RQIJ.1
UPDATED BY
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 AP300 AP305 API1.1
API2.1 BL120 BL122 BL130 BL20.1 BL20.3
BL21.2 BL21.5 BL29.1 BL29.2 BL520 BL820
BL92.1 IC130 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 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 PO135 PO136 PO190 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 PO26.1
PO27.2 PO29.1 PO30.1 PO30.2 PO30.3 PO300
PO31.1 PO31.2 PO32.1 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
POD0.1 POI3.1 POID.1 POIF.1 POII.1 POIJ.1
RQ10.1 RQ10.2 RQ10.3 RQ11.1 RQ12.1 RQ13.1
RQ13.2 RQ35.1 RQ500 RQD0.1 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 RQ300
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MMD-COMPANY Numeric 4 AM19.1 AM19.2
Element: Company The company 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
IC130 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
...
MMD-SYSTEM-CD Alpha 2 AM19.1 AM19.2
Element: System Cd This field indicates on what system the AP115 AP125
transaction originated. AP126 AP131
IC = INVENTORY-CONTROL AP20.1 AP20.2
PO = PURCHASE-ORDER AP20.3 AP20.4
RQ = REQUISITIONS AP20.5 AP20.7
AP = Accounts Payable 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
IC130 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
...
MMD-LOCATION Alpha 5 AM19.1 AM19.2
Element: Location This field contains a valid stock AP115 AP125
location within the company inventory. 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
IC130 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
...
MMD-DOC-TYPE Alpha 2 AM19.1 AM19.2
Element: Doc Type This field contains the type of AP115 AP125
transaction. AP126 AP131
AJ = Adjustment AP20.1 AP20.2
AR = Receiving Archive AP20.3 AP20.4
CA = Cost Adjustment AP20.5 AP20.7
CR = Customer Return AP21.1 AP220
DT = Direct Transfer AP23.1 AP25.1
IN = Invoice Details AP25.2 AP26.1
IS = Issue AP27.1 AP30.2
IT = Transfer Issue AP30.4 AP305
PA = Price Agreement API1.1 API2.1
PI = Physical Inventory Adjustment BL120 BL122
PO = PO Receiving BL130 BL20.1
PT = Purchase Order Template-New PO BL20.3 BL21.2
RA = Receiving Adjustment BL21.5 BL29.1
RC = Receipt BL29.2 BL520
RJ = Inspection Reject BL820 BL92.1
RR = Requisition Return IC130 MA180
RT = Receiving Transfer MA310 MA41.1
VA = Vendor Return Adjustment MA41.2 MA41.4
VR = Vendor Return MA41.7 MA43.1
IF = Interface MA43.2 MA43.3
RQ = Requisition MA43.4 MA43.6
AC = Accepted Inspection MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA63.1
MA65.1 MA66.2
MA66.3 MA67.2
...
MMD-DOC-NUMBER Alpha 14 (Right Justified) AM19.1 AM19.2
Element: Doc 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
IC130 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
...
MMD-DOC-NBR-NUM Numeric 10 AM19.1 AM19.2
Element: Doc Nbr Num This field contains the number for the AP115 AP125
document tied to the distribution if a AP126 AP131
numeric 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
IC130 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
...
MMD-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
IC130 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
...
MMD-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
IC130 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
...
MMD-COMPONENT-SEQ Numeric 3 AM19.1 AM19.2
Element: Seq This field contains the record 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
IC130 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
...
MMD-LINE-SEQ Numeric 3 AM19.1 AM19.2
Element: Seq Sequence number within a 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
IC130 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
...
MMD-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. 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
IC130 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
...
MMD-REQ-LOCATION Alpha 5 AM19.1 AM19.2
Element: Req Location The location requisitioning items. AP115 AP125
This location can be an inventory or AP126 AP131
noninventory location. 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
IC130 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
...
MMD-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
IC130 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
...
MMD-ACCOUNT Numeric 6 AM19.1 AM19.2
Element: Account This field along with the accounting AP115 AP125
unit and subaccount make up the location AP126 AP131
(account) where amounts and other AP20.1 AP20.2
account information is stored. 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
IC130 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
...
MMD-SUB-ACCT Numeric 4 AM19.1 AM19.2
Element: Sub Acct This field contains the subaccount from AP115 AP125
your general ledger chart of accounts AP126 AP131
that was charged with the amount carried AP20.1 AP20.2
on this record. 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
IC130 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
...
MMD-DIST-COMPANY Numeric 4 AM19.1 AM19.2
Element: Company The company number used for posting the AP115 AP125
transaction. A valid intercompany AP126 AP131
relationship must be defined in General AP20.1 AP20.2
Ledger. 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
IC130 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
...
MMD-ACTIVITY Alpha 15 AM19.1 AM19.2
Element: Activity Activities are the processes or AP115 AP125
procedures that produce work. Cost AP126 AP131
objects (products, services, customers, AP20.1 AP20.2
and so on) are the reasons for AP20.3 AP20.4
performing the activity. Activities and AP20.5 AP20.7
cost object activities are used AP21.1 AP220
synonymously in Project Accounting. AP23.1 AP25.1
Direct costs are posted to activities, AP25.2 AP26.1
and indirect costs are allocated to AP27.1 AP30.2
activities based on activity drivers. AP30.4 AP305
API1.1 API2.1
Activities are grouped or organized by BL120 BL122
activity levels. There are two types of BL130 BL20.1
activities: "posting allowed" and BL20.3 BL21.2
"summary only." Use posting level BL21.5 BL29.1
activities to budget and maintain all BL29.2 BL520
posted transactions. Summary activities BL820 BL92.1
or macro activities combine information IC130 MA180
and balances from lower level activities MA310 MA41.1
for reporting and inquiries. 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
...
MMD-ACCT-CATEGORY Alpha 5 AM19.1 AM19.2
Element: Acct Category Account categories are groupings of AP115 AP125
costs, revenues, or a combination of AP126 AP131
both used for reporting and inquiries AP20.1 AP20.2
for activities in Project Accounting. AP20.3 AP20.4
All transactions are posted to an AP20.5 AP20.7
account category within an activity. You AP21.1 AP220
can assign a specific general ledger AP23.1 AP25.1
account or range of accounts (company, AP25.2 AP26.1
accounting unit, account, and AP27.1 AP30.2
subaccount) that make up the AP30.4 AP305
transactions posted to an account API1.1 API2.1
category using Account Assignment BL120 BL122
(AC07.1). BL130 BL20.1
BL20.3 BL21.2
Period-to-date, year-to-date, and BL21.5 BL29.1
life-to-date balances are maintained by BL29.2 BL520
account category for activities. Account BL820 BL92.1
categories must be assigned to IC130 MA180
activities before you do any budgeting MA310 MA41.1
or transaction processing. 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
...
MMD-BILL-CATEGORY Alpha 32 AM19.1 AM19.2
Element: Bill Category 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
IC130 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
...
MMD-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 Quick AP27.1 AP30.2
Addition (AM20.1) and to create assets AP30.4 AP305
and asset books from Accounts Payable API1.1 API2.1
and Project Accounting 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
Purchase Order or Accounts Payable. BL29.2 BL520
BL820 BL92.1
IC130 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
...
MMD-ASSET Numeric 10 AM19.1 AM19.2
Element: Asset The asset number contains up to ten AP115 AP125
numeric characters that uniquely AP126 AP131
identify an asset. Assets are AP20.1 AP20.2
automatically numbered system-wide. 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
IC130 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
...
MMD-DIST-PERCENT Signed 6.3 AM19.1 AM19.2
Element: Total Percent This field indicates the percent of the AP115 AP125
extended value of the line that is AP126 AP131
associated with this account, if the AP20.1 AP20.2
breakdown is by percent. 100 % is AP20.3 AP20.4
stored as 100.000. 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
IC130 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
...
MMD-DIST-QTY Signed 13.4 AM19.1 AM19.2
Element: Quantity This field contains the desired AP115 AP125
quantity. 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
IC130 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
...
MMD-DIST-AMOUNT Signed 18.2 AM19.1 AM19.2
Element: Intl Amt This is the total amount posted to the AP115 AP125
general ledger for this account. This AP126 AP131
field is used for drillback information AP20.1 AP20.2
to transactions from Inventory Control AP20.3 AP20.4
and inventory and received not invoiced AP20.5 AP20.7
items from Purchase Order. 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
IC130 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
...
MMD-POSTING-TYPE Alpha 2 AM19.1 AM19.2
Element: Posting Type For distribution records posted from AP115 AP125
Inventory Control, this field indicates AP126 AP131
if the postings were to the inventory AP20.1 AP20.2
account or offset accounts. AP20.3 AP20.4
I1 = Inventory AP20.5 AP20.7
O1 = Offset AP21.1 AP220
E1 = RNI Expense Account AP23.1 AP25.1
RN = Received Not Invoiced AP25.2 AP26.1
MN = Matched Not Received AP27.1 AP30.2
A = Add On Cost 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
IC130 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
...
MMD-STATUS Numeric 1 AM19.1 AM19.2
Element: Status This field displays the status of the AP115 AP125
transaction. AP126 AP131
0 = Unposted AP20.1 AP20.2
1 = Posted AP20.3 AP20.4
2 = Not to be Posted 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
IC130 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
...
MMD-POSTED-DATE Numeric 8 (yyyymmdd) AM19.1 AM19.2
Element: Posted Date Date posted to the General Ledger AP115 AP125
system. 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
IC130 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
...
MMD-POSTED-TIME Numeric 6 (hhmmss) AM19.1 AM19.2
Element: Sys Time Time posted to the General Ledger AP115 AP125
system. 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
IC130 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
...
MMD-GLT-OBJ-ID Numeric 12 AM19.1 AM19.2
Element: Obj Id This is a subsystem General Ledger AP115 AP125
interface identification number. It is AP126 AP131
used for Drill Around purposes. AP20.1 AP20.2
AP20.3 AP20.4
In addition, if a GL Commmitment is AP20.5 AP20.7
written to the GLCOMMITX file from RQ or AP21.1 AP220
PO, then the GLT-OBJ-ID assigned by the AP23.1 AP25.1
GL system is placed in the MMDIST record AP25.2 AP26.1
and the GLCOMMITX record. The GLT-OBJ-ID AP27.1 AP30.2
on the MMDIST record is used later via AP30.4 AP305
PO and AP as a key to remove a API1.1 API2.1
corresponding GLCOMMITX record. BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
IC130 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
...
MMD-ATN-OBJ-ID Numeric 12 AM19.1 AM19.2
Element: Obj Id This field is used to link general AP115 AP125
ledger distributions in the Purchase AP126 AP131
Order system to activities in the AP20.1 AP20.2
Activity Management system. The field AP20.3 AP20.4
allows drill backs to the distribution AP20.5 AP20.7
records from the activities. 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
IC130 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
...
MMD-API-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
IC130 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
...
MMD-PULL-FOR-FR-FL Alpha 1 AM19.1 AM19.2
Element: Pull For Fr FlIf Y-Yes the user has specified to AP115 AP125
process transactions to a retail AP126 AP131
financial reporting extract file. 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
IC130 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
...
MMD-RNI-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
IC130 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
...
MMDIST FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MMDSET1 COMPANY AM19.1 AM19.2
SYSTEM-CD AP115 AP125
LOCATION AP126 AP131
DOC-TYPE AP20.1 AP20.2
DOC-NUMBER AP20.3 AP20.4
DOC-NBR-NUM AP20.5 AP20.7
PO-CODE AP21.1 AP220
LINE-NBR AP23.1 AP25.1
COMPONENT-SEQ AP25.2 AP26.1
AOC-CODE AP27.1 AP30.2
LINE-SEQ AP30.4 AP305
REQ-LOCATION API1.1 API2.1
API-OBJ-ID BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
...
MMDSET10 COMPANY Subset
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 KeyChange AP125 AP126
SYSTEM-CD AP131 AP20.1
LOCATION AP20.2 AP20.3
DOC-TYPE AP20.4 AP20.5
DOC-NUMBER AP20.7 AP21.1
DOC-NBR-NUM AP23.1 AP25.1
PO-CODE AP25.2 AP26.1
LINE-NBR AP27.1 AP30.4
COMPONENT-SEQ API1.1 BL120
AOC-CODE BL122 BL130
LINE-SEQ BL20.1 BL20.3
API-OBJ-ID BL21.2 BL21.5
REQ-LOCATION BL29.1 BL29.2
BL520 BL820
BL92.1 MA180
...
MMDSET12 RNI-OBJ-ID KeyChange, Subset PO278 MM280
COMPANY Where RNI-OBJ-ID != Zeroes MM80.1 MM80.2
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 MM80.1
COMPANY Where GLT-OBJ-ID != Zeroes MM80.2
SYSTEM-CD
LOCATION
DOC-TYPE
DOC-NUMBER
DOC-NBR-NUM
LINE-NBR
COMPONENT-SEQ
LINE-SEQ
MMDSET4 COMPANY Subset AM17.1 AM19.1
DOC-NUMBER Where SYSTEM-CD = "PO" AM19.2 AP115
DOC-NBR-NUM And DOC-TYPE = "PT" AP125 AP126
PO-CODE And LINE-SEQ < 997 AP131 AP20.1
LINE-NBR AP20.2 AP20.3
AOC-CODE AP20.4 AP20.5
LINE-SEQ 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
...
MMDSET5 COMPANY Subset AM17.1 AM19.1
API-OBJ-ID Where SYSTEM-CD = "AP" AM19.2 AP115
LINE-NBR AP125 AP126
AOC-CODE AP131 AP20.1
LINE-SEQ 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
AP300 AP305
API1.1 API2.1
BL120 BL122
BL130 BL20.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 PO100 PO23.1
WH20.2 WH20.7
MMDSET7 COMPANY Subset AM19.1 AM19.2
SYSTEM-CD Where STATUS = Zeroes AP115 AP125
DOC-TYPE And ((SYSTEM-CD = "PO" ) AP126 AP131
DOC-NUMBER And (DOC-TYPE != "VA" ) AP20.1 AP20.2
DOC-NBR-NUM And (DOC-TYPE != "VR" )) AP20.3 AP20.4
LINE-NBR Or ((SYSTEM-CD = "RQ" ) AP20.5 AP20.7
LINE-SEQ And (DOC-TYPE = "IS" ) AP21.1 AP220
Or (DOC-TYPE = "RR" )) 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
...
MMDSET8 COMPANY Subset AP125 AP126
DOC-NBR-NUM Where SYSTEM-CD = "RQ" AP131 AP20.1
LINE-NBR And DOC-TYPE = "RQ" AP20.2 AP20.3
LINE-SEQ AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA180
...
MMDSET9 COMPANY Subset BL92.1 MA531
SYSTEM-CD Where (SYSTEM-CD = "PO" PO30.1 PO30.2
DOC-TYPE And DOC-TYPE = "PT" PO30.3 PO300
DOC-NUMBER And LINE-SEQ < 997 ) PO33.1 PO34.1
DOC-NBR-NUM Or (SYSTEM-CD = "RQ" PO39.2 PO52.1
PO-CODE And DOC-TYPE = "RQ" ) POIF.1 POIG.1
LINE-NBR POIM.1 WH130
AOC-CODE WH132 WH190
LINE-SEQ 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
...
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
Poaocdtl POAOCDTL Required
When MMD-SYSTEM-CD = "PO"
And MMD-DOC-TYPE = "PT"
MMD-COMPANY -> PAO-COMPANY
Spaces -> PAO-PROCURE-GROUP
Spaces -> PAO-VEN-AGRMT-REF
MMD-DOC-NUMBER -> PAO-PO-NUMBER
MMD-DOC-NBR-NUM -> PAO-PO-RELEASE
MMD-PO-CODE -> PAO-PO-CODE
MMD-LINE-NBR -> PAO-LINE-NBR
MMD-AOC-CODE -> PAO-AOC-CODE
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
Reqline2 REQLINE Required
MMD-COMPANY -> RLN-COMPANY
MMD-DOC-NUMBER -> RLN-REQ-NUMBER-A
MMD-LINE-NBR -> RLN-LINE-NBR
Reqline3 REQLINE Required
When MMD-COMPANY != MMD-DIST-COMPANY
MMD-DIST-COMPANY -> RLN-COMPANY
MMD-DOC-NUMBER -> RLN-REQ-NUMBER-A
MMD-LINE-NBR -> RLN-LINE-NBR
Reqline9 REQLINE Required
MMD-COMPANY -> RLN-FROM-COMPANY
MMD-DOC-NUMBER -> RLN-REQ-NUMBER-A
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
|