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
IC50.2 IC53.1 IC55.1 IC55.2 PO190 PO220
PO223 PO254 PO54.1 PO54.2 PO54.3 PO54.4
POIE.1 MM280 MM80.1 MM80.2 RQ230 WO293
MA236 POIG.1 POIM.1 RQ111 RQID.1 RQIJ.1
UPDATED BY
AP115 AP125 AP126 AP131 AP20.1 AP20.2
AP20.3 AP20.4 AP20.5 AP20.7 AP220 AP23.1
AP25.1 AP25.2 AP26.1 AP27.1 AP30.2 AP30.4
AP300 AP305 API1.1 DR100 IC130 IC131
IC141 IC142 IC28.1 IC300 IC83.1 MA180
MA41.1 MA41.2 MA41.4 MA41.7 MA43.1 MA43.2
MA43.3 MA43.4 MA43.5 MA43.7 MA43.8 MA43.9
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 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 POD0.1
POI3.1 POIF.1 POII.1 POIJ.1 RQ10.1 RQ10.2
RQ10.3 RQ11.1 RQ12.1 RQ13.1 RQ35.1 RQ500
RQD0.1 RQIE.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
WO140 RQ300
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MMD-COMPANY Numeric 4 AP115 AP125
Element: Company The company number. AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 API1.1
DR100 IC130
IC141 IC142
IC28.1 IC83.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.7 MA43.8
MA43.9 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
PO100 PO101
PO122 PO131
...
MMD-SYSTEM-CD Alpha 2 AP115 AP125
Element: System Code This field indicates on what system the AP126 AP131
transaction originated. AP20.1 AP20.2
IC = INVENTORY-CONTROL AP20.3 AP20.4
PO = PURCHASE-ORDER AP20.5 AP20.7
RQ = REQUISITIONS AP220 AP23.1
AP = Accounts Payable AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 API1.1
DR100 IC130
IC141 IC142
IC28.1 IC83.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.7 MA43.8
MA43.9 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
PO100 PO101
PO122 PO131
...
MMD-LOCATION Alpha 5 AP115 AP125
Element: Location Code This field contains a valid stock AP126 AP131
location within the company inventory. AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 API1.1
DR100 IC130
IC141 IC142
IC28.1 IC83.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.7 MA43.8
MA43.9 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
PO100 PO101
PO122 PO131
...
MMD-DOC-TYPE Alpha 2 AP115 AP125
Element: Document Type This field contains the type of AP126 AP131
transaction. AP20.1 AP20.2
AJ = Adjustment AP20.3 AP20.4
AR = Receiving Archive AP20.5 AP20.7
CA = Cost Adjustment AP220 AP23.1
CR = Customer Return AP25.1 AP25.2
DT = Direct Transfer AP26.1 AP27.1
IN = Invoice Details AP30.2 AP30.4
IS = Issue AP305 API1.1
IT = Transfer Issue DR100 IC130
PA = Price Agreement IC141 IC142
PI = Physical Inventory Adjustment IC28.1 IC83.1
PO = PO Receiving MA180 MA41.1
PT = Purchase Order Template-New PO MA41.2 MA41.4
RA = Receiving Adjustment MA41.7 MA43.1
RC = Receipt MA43.2 MA43.3
RJ = Inspection Reject MA43.4 MA43.5
RR = Requisition Return MA43.7 MA43.8
RT = Receiving Transfer MA43.9 MA530
VA = Vendor Return Adjustment MA531 MA60.2
VR = Vendor Return MA60.3 MA60.5
IF = Interface MA61.1 MA63.1
RQ = Requisition MA65.1 MA66.2
AC = Accepted Inspection MA66.3 MA67.1
MA67.2 MA68.1
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
...
MMD-DOC-NUMBER Alpha 14 (Right Justified) AP115 AP125
Element: Doc Number AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 API1.1
DR100 IC130
IC141 IC142
IC28.1 IC83.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.7 MA43.8
MA43.9 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
PO100 PO101
PO122 PO131
...
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 AP20.1 AP20.2
numeric document. AP20.3 AP20.4
AP20.5 AP20.7
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 API1.1
DR100 IC130
IC141 IC142
IC28.1 IC83.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.7 MA43.8
MA43.9 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
PO100 PO101
PO122 PO131
...
MMD-PO-CODE Alpha 4 AP115 AP125
Element: Po Code This is the purchase order code. AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 API1.1
DR100 IC130
IC141 IC142
IC28.1 IC83.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.7 MA43.8
MA43.9 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
PO100 PO101
PO122 PO131
...
MMD-LINE-NBR Numeric 6 AP115 AP125
Element: Line Number This field contains the line number. AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 API1.1
DR100 IC130
IC141 IC142
IC28.1 IC83.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.7 MA43.8
MA43.9 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
PO100 PO101
PO122 PO131
...
MMD-COMPONENT-SEQ Numeric 3 AP115 AP125
Element: Sequence Number AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 API1.1
DR100 IC130
IC141 IC142
IC28.1 IC83.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.7 MA43.8
MA43.9 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
PO100 PO101
PO122 PO131
...
MMD-LINE-SEQ Numeric 3 AP115 AP125
Element: Sequence NumbeSequence number within a line number. AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 API1.1
DR100 IC130
IC141 IC142
IC28.1 IC83.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.7 MA43.8
MA43.9 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
PO100 PO101
PO122 PO131
...
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 AP20.1 AP20.2
line item. AP20.3 AP20.4
AP20.5 AP20.7
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 API1.1
DR100 IC130
IC141 IC142
IC28.1 IC83.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.7 MA43.8
MA43.9 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
PO100 PO101
PO122 PO131
...
MMD-REQ-LOCATION Alpha 5 AP115 AP125
Element: Location Code AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 API1.1
DR100 IC130
IC141 IC142
IC28.1 IC83.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.7 MA43.8
MA43.9 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
PO100 PO101
PO122 PO131
...
MMD-ACCT-UNIT Alpha 15 AP115 AP125
Element: Accounting UniThe accounting unit is a shorthand AP126 AP131
notation representing the variable level AP20.1 AP20.2
number. When used in the General Ledger AP20.3 AP20.4
account master file, the accounting unit AP20.5 AP20.7
must be defined in the General Ledger AP220 AP23.1
names file as a posting accounting unit. AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 API1.1
DR100 IC130
IC141 IC142
IC28.1 IC83.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.7 MA43.8
MA43.9 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
PO100 PO101
PO122 PO131
...
MMD-ACCOUNT Numeric 6 AP115 AP125
Element: Account This field along with the accounting AP126 AP131
unit and subaccount make up the location AP20.1 AP20.2
(account) where amounts and other AP20.3 AP20.4
account information is stored. AP20.5 AP20.7
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 API1.1
DR100 IC130
IC141 IC142
IC28.1 IC83.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.7 MA43.8
MA43.9 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
PO100 PO101
PO122 PO131
...
MMD-SUB-ACCT Numeric 4 AP115 AP125
Element: Subaccount This field contains the subaccount from AP126 AP131
your general ledger chart of accounts AP20.1 AP20.2
that was charged with the amount carried AP20.3 AP20.4
on this record. AP20.5 AP20.7
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 API1.1
DR100 IC130
IC141 IC142
IC28.1 IC83.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.7 MA43.8
MA43.9 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
PO100 PO101
PO122 PO131
...
MMD-DIST-COMPANY Numeric 4 AP115 AP125
Element: Company The company number used for posting the AP126 AP131
transaction. A valid intercompany AP20.1 AP20.2
relationship must be defined in the AP20.3 AP20.4
General Ledger system. AP20.5 AP20.7
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 API1.1
DR100 IC130
IC141 IC142
IC28.1 IC83.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.7 MA43.8
MA43.9 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
PO100 PO101
PO122 PO131
...
MMD-ACTIVITY Alpha 15 AP115 AP125
Element: Activity Activities are the processes or AP126 AP131
procedures that produce work. Cost AP20.1 AP20.2
objects (products, services, customers, AP20.3 AP20.4
and so on) are the reasons for AP20.5 AP20.7
performing the activity. Activities and AP220 AP23.1
cost object activities are used AP25.1 AP25.2
synonymously in the Activity Management AP26.1 AP27.1
system. Direct costs are posted to AP30.2 AP30.4
activities, and indirect costs are AP305 API1.1
allocated to activities based on DR100 IC130
activity drivers. IC141 IC142
IC28.1 IC83.1
Activities are grouped or organized by MA180 MA41.1
activity levels. There are two types of MA41.2 MA41.4
activities: "posting allowed" and MA41.7 MA43.1
"summary only." Use posting level MA43.2 MA43.3
activities to budget and maintain all MA43.4 MA43.5
posted transactions. Summary activities MA43.7 MA43.8
or macro activities combine information MA43.9 MA530
and balances from lower level activities MA531 MA60.2
for reporting and inquiries. 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
PO100 PO101
PO122 PO131
...
MMD-ACCT-CATEGORY Alpha 5 AP115 AP125
Element: Account CategoAccount categories are groupings of AP126 AP131
costs, revenues, or a combination of AP20.1 AP20.2
both used for reporting and inquiries AP20.3 AP20.4
for activities in the Activity AP20.5 AP20.7
Management system. All transactions are AP220 AP23.1
posted to an account category within an AP25.1 AP25.2
activity. You can assign a specific AP26.1 AP27.1
general ledger account or range of AP30.2 AP30.4
accounts (company, accounting unit, AP305 API1.1
account, and subaccount) that make up DR100 IC130
the transactions posted to an account IC141 IC142
category using AC07.1 (Account IC28.1 IC83.1
Assignment). MA180 MA41.1
MA41.2 MA41.4
Period-to-date, year-to-date, and MA41.7 MA43.1
life-to-date balances are maintained by MA43.2 MA43.3
account category for activities. Account MA43.4 MA43.5
categories must be assigned to MA43.7 MA43.8
activities before you do any budgeting MA43.9 MA530
or transaction processing. 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
PO100 PO101
PO122 PO131
...
MMD-ASSET-TEMPLATE Alpha 10 AP115 AP125
Element: Asset TemplateA user-defined asset template AP126 AP131
identifies general asset creation AP20.1 AP20.2
parameters that you can use to quickly AP20.3 AP20.4
add assets with minimal keying. Using a AP20.5 AP20.7
template lets you default many data AP220 AP23.1
items associated with a new asset. AP25.1 AP25.2
AP26.1 AP27.1
You can use an asset template to AP30.2 AP30.4
process quick asset additions in AM20.1 AP305 API1.1
(Quick Addition) and to create assets DR100 IC130
and asset books from Accounts Payable IC141 IC142
and Activity Management interface IC28.1 IC83.1
information. Asset templates are MA180 MA41.1
required if you define new assets as a MA41.2 MA41.4
result of transactions interfaced from MA41.7 MA43.1
the Purchase Order or Accounts Payable MA43.2 MA43.3
systems. MA43.4 MA43.5
MA43.7 MA43.8
MA43.9 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
PO100 PO101
PO122 PO131
...
MMD-ASSET Numeric 10 AP115 AP125
Element: Asset Number The asset number contains up to ten AP126 AP131
numeric characters that uniquely AP20.1 AP20.2
identify an asset. Assets are AP20.3 AP20.4
automatically numbered system-wide. AP20.5 AP20.7
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 API1.1
DR100 IC130
IC141 IC142
IC28.1 IC83.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.7 MA43.8
MA43.9 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
PO100 PO101
PO122 PO131
...
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 AP20.1 AP20.2
associated with this account, if the AP20.3 AP20.4
breakdown is by percent. 100 % is AP20.5 AP20.7
stored as 100.000. AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 API1.1
DR100 IC130
IC141 IC142
IC28.1 IC83.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.7 MA43.8
MA43.9 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
PO100 PO101
PO122 PO131
...
MMD-DIST-QTY Signed 13.4 AP115 AP125
Element: Quantity AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 API1.1
DR100 IC130
IC141 IC142
IC28.1 IC83.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.7 MA43.8
MA43.9 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
PO100 PO101
PO122 PO131
...
MMD-DIST-AMOUNT Signed 13.2 AP115 AP125
Element: Distribution AThis is the total amount posted to the AP126 AP131
general ledger for this account. This AP20.1 AP20.2
field is used for drillback information AP20.3 AP20.4
to transactions from the Inventory AP20.5 AP20.7
Control system and inventory and AP220 AP23.1
received not invoiced items from the AP25.1 AP25.2
Purchase Order system. AP26.1 AP27.1
AP30.2 AP30.4
AP305 API1.1
DR100 IC130
IC141 IC142
IC28.1 IC83.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.7 MA43.8
MA43.9 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
PO100 PO101
PO122 PO131
...
MMD-POSTING-TYPE Alpha 2 AP115 AP125
Element: Posting Type For distribution records posted from AP126 AP131
Inventory Control, this field indicates AP20.1 AP20.2
if the postings were to the inventory AP20.3 AP20.4
account or offset accounts. AP20.5 AP20.7
I1 = Inventory AP220 AP23.1
O1 = Offset AP25.1 AP25.2
E1 = RNI Expense Account AP26.1 AP27.1
RN = Received Not Invoiced AP30.2 AP30.4
MN = Matched Not Received AP305 API1.1
A = Add On Cost DR100 IC130
IC141 IC142
IC28.1 IC83.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.7 MA43.8
MA43.9 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
PO100 PO101
PO122 PO131
...
MMD-STATUS Numeric 1 AP115 AP125
Element: Status This field displays the status of the AP126 AP131
transaction. AP20.1 AP20.2
0 = Unposted AP20.3 AP20.4
1 = Posted AP20.5 AP20.7
2 = Not to be Posted AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 API1.1
DR100 IC130
IC141 IC142
IC28.1 IC83.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.7 MA43.8
MA43.9 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
PO100 PO101
PO122 PO131
...
MMD-POSTED-DATE Numeric 8 (yyyymmdd) AP115 AP125
Element: Date Date posted to the General Ledger AP126 AP131
system. AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 API1.1
DR100 IC130
IC141 IC142
IC28.1 IC83.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.7 MA43.8
MA43.9 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
PO100 PO101
PO122 PO131
...
MMD-POSTED-TIME Numeric 6 (hhmmss) AP115 AP125
Element: Sys Time Time posted to the General Ledger AP126 AP131
system. AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 API1.1
DR100 IC130
IC141 IC142
IC28.1 IC83.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.7 MA43.8
MA43.9 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
PO100 PO101
PO122 PO131
...
MMD-GLT-OBJ-ID Numeric 12 AP115 AP125
Object This is a subsystem General Ledger AP126 AP131
Identification interface identification number. It is AP20.1 AP20.2
used for Drill Around purposes. AP20.3 AP20.4
AP20.5 AP20.7
In addition, if a GL Commmitment is AP220 AP23.1
written to the GLCOMMITX file from RQ or AP25.1 AP25.2
PO, then the GLT-OBJ-ID assigned by the AP26.1 AP27.1
GL system is placed in the MMDIST record AP30.2 AP30.4
and the GLCOMMITX record. The GLT-OBJ-ID AP305 API1.1
on the MMDIST record is used later via DR100 IC130
PO and AP as a key to remove a IC141 IC142
corresponding GLCOMMITX record. IC28.1 IC83.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.7 MA43.8
MA43.9 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
PO100 PO101
PO122 PO131
...
MMD-ATN-OBJ-ID Numeric 12 AP115 AP125
Object This field is used to link general AP126 AP131
Identification ledger distributions in the Purchase AP20.1 AP20.2
Order system to activities in the AP20.3 AP20.4
Activity Management system. The field AP20.5 AP20.7
allows drill backs to the distribution AP220 AP23.1
records from the activities. AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 API1.1
DR100 IC130
IC141 IC142
IC28.1 IC83.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.7 MA43.8
MA43.9 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
PO100 PO101
PO122 PO131
...
MMD-API-OBJ-ID Numeric 12 AP115 AP125
Object AP126 AP131
Identification AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 API1.1
DR100 IC130
IC141 IC142
IC28.1 IC83.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.7 MA43.8
MA43.9 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
PO100 PO101
PO122 PO131
...
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 AP20.1 AP20.2
financial reporting extract file. AP20.3 AP20.4
AP20.5 AP20.7
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 API1.1
DR100 IC130
IC131 IC141
IC142 IC28.1
IC83.1 MA180
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.5 MA43.7
MA43.8 MA43.9
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 PO100
PO101 PO122
...
MMD-RNI-OBJ-ID Numeric 12 AP115 AP125
Object AP126 AP131
Identification AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 API1.1
DR100 IC130
IC141 IC142
IC28.1 IC83.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.7 MA43.8
MA43.9 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
PO100 PO101
PO122 PO131
...
MMDIST FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MMDSET1 COMPANY AP115 AP125
SYSTEM-CD AP126 AP131
LOCATION AP20.1 AP20.2
DOC-TYPE AP20.3 AP20.4
DOC-NUMBER AP20.5 AP20.7
DOC-NBR-NUM AP220 AP23.1
PO-CODE AP25.1 AP25.2
LINE-NBR AP26.1 AP27.1
COMPONENT-SEQ AP30.2 AP30.4
AOC-CODE AP305 API1.1
LINE-SEQ API2.1 DR100
REQ-LOCATION IC130 IC141
API-OBJ-ID IC142 IC220
IC240 IC242
IC28.1 IC280
...
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 AP20.1
LOCATION problems. AP20.2 AP20.3
DOC-TYPE KeyChange AP20.4 AP20.5
DOC-NUMBER AP20.7 AP23.1
DOC-NBR-NUM AP25.1 AP25.2
PO-CODE AP26.1 AP27.1
LINE-NBR AP30.4 API1.1
COMPONENT-SEQ IC28.1 MA180
AOC-CODE MA41.2 MA41.7
LINE-SEQ MA43.1 MA43.2
API-OBJ-ID MA43.3 MA43.9
REQ-LOCATION MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
...
MMDSET12 RNI-OBJ-ID KeyChange, Subset MM280 MM80.1
COMPANY Where RNI-OBJ-ID != Zeroes 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 AP125 AP126
DOC-NUMBER Where SYSTEM-CD = "PO" AP220 AP25.1
DOC-NBR-NUM And DOC-TYPE = "PT" AP25.2 AP26.1
PO-CODE And LINE-SEQ < 997 AP27.1 API1.1
LINE-NBR MA180 MA236
AOC-CODE MA41.7 MA61.1
LINE-SEQ MA66.2 MAI1.1
PO21.5 POIJ.1
MM280 MM80.1
MM80.2
MMDSET5 COMPANY Subset AP115 AP125
API-OBJ-ID Where SYSTEM-CD = "AP" AP126 AP131
LINE-NBR AP20.1 AP20.2
AOC-CODE AP20.3 AP20.4
LINE-SEQ AP20.5 AP20.7
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP300 AP305
API1.1 DR100
IC141 IC142
IC83.1 MA236
MA41.1 MA41.2
MA41.4 MA41.7
...
MMDSET6 COMPANY KeyChange, Subset PO100 PO23.1
SYSTEM-CD Where DOC-TYPE = "IF" WH20.2 WH20.7
DOC-NUMBER
DOC-NBR-NUM
REQ-LOCATION
LINE-NBR
LINE-SEQ
MMDSET7 COMPANY Subset AP115 AP125
SYSTEM-CD Where STATUS = Zeroes AP126 AP131
DOC-TYPE And ((SYSTEM-CD = "PO" ) AP20.1 AP20.2
DOC-NUMBER And (DOC-TYPE != "VA" ) AP20.3 AP20.4
DOC-NBR-NUM And (DOC-TYPE != "VR" )) AP20.5 AP20.7
LINE-NBR Or ((SYSTEM-CD = "RQ" ) AP220 AP23.1
LINE-SEQ And (DOC-TYPE = "IS" ) AP25.1 AP25.2
Or (DOC-TYPE = "RR" )) AP26.1 AP27.1
AP30.2 AP30.4
AP305 API1.1
DR100 IC130
IC141 IC142
IC28.1 IC83.1
MA180 MA41.1
MA41.2 MA41.4
...
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 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC28.1 IC83.1
MA180 MA41.2
MA41.7 MA43.1
MA43.2 MA43.3
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
...
MMDSET9 COMPANY This index is used for budget checking MA531 PO30.1
SYSTEM-CD and commitment processing when working PO30.2 PO30.3
DOC-TYPE with activities. PO300 PO33.1
DOC-NUMBER Subset PO34.1 PO39.2
DOC-NBR-NUM Where (SYSTEM-CD = "PO" PO52.1 POIF.1
PO-CODE And DOC-TYPE = "PT" POIG.1 POIM.1
LINE-NBR And LINE-SEQ < 997 ) WH130 WH132
AOC-CODE Or (SYSTEM-CD = "RQ" WH190 WH30.1
LINE-SEQ And DOC-TYPE = "RQ" ) 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
...
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-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
|