 |
Lawson Insight Technical Documentation |
|
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. The record is for
an item on either a requisition, a purchase order or a standard purchase
order. For the non-inventory item 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 IC240 IC280 PO220 PO254 PO54.1
PO54.2 PO54.3 PO54.4 RQ230 POIG.1 POIM.1
RQ111
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 MA126
MA180 MA41.1 MA41.2 MA41.4 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 MAI1.1 PO100 PO101 PO122
PO131 PO135 PO136 PO20.1 PO21.2 PO21.3
PO21.4 PO21.5 PO22.1 PO23.1 PO25.2 PO25.6
PO25.7 PO25.8 PO26.1 PO27.3 PO29.1 PO30.1
PO30.2 PO30.3 PO300 PO31.1 PO31.2 PO32.1
PO32.2 PO33.1 PO34.1 PO35.1 PO38.1 PO39.1
PO39.2 PO44.1 PO50.1 PO52.1 PO520 POI3.1
POIE.1 POIF.1 POII.1 POIJ.1 RQ10.1 RQ10.2
RQ10.3 RQ11.1 RQ12.1 RQ13.1 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 RQ300
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MMD-COMPANY Numeric 4 AP115 AP125
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
MA126 MA180
MA41.1 MA41.2
MA41.4 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 MAI1.1
PO100 PO101
PO122 PO131
PO135 PO136
...
MMD-SYSTEM-CD Alpha 2 AP115 AP125
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
MA126 MA180
MA41.1 MA41.2
MA41.4 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 MAI1.1
PO100 PO101
PO122 PO131
PO135 PO136
...
MMD-LOCATION Alpha 5 AP115 AP125
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
MA126 MA180
MA41.1 MA41.2
MA41.4 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 MAI1.1
PO100 PO101
PO122 PO131
PO135 PO136
...
MMD-DOC-TYPE Alpha 2 AP115 AP125
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 MA126 MA180
PT = Purchase Order Template-New PO MA41.1 MA41.2
RA = Receiving Adjustment MA41.4 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 MAI1.1
PO100 PO101
PO122 PO131
PO135 PO136
...
MMD-DOC-NUMBER Alpha 14 (Right Justified) AP115 AP125
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
MA126 MA180
MA41.1 MA41.2
MA41.4 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 MAI1.1
PO100 PO101
PO122 PO131
PO135 PO136
...
MMD-DOC-NBR-NUM Numeric 10 AP115 AP125
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
MA126 MA180
MA41.1 MA41.2
MA41.4 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 MAI1.1
PO100 PO101
PO122 PO131
PO135 PO136
...
MMD-PO-CODE Alpha 4 AP115 AP125
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
MA126 MA180
MA41.1 MA41.2
MA41.4 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 MAI1.1
PO100 PO101
PO122 PO131
PO135 PO136
...
MMD-LINE-NBR Numeric 6 AP115 AP125
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
MA126 MA180
MA41.1 MA41.2
MA41.4 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 MAI1.1
PO100 PO101
PO122 PO131
PO135 PO136
...
MMD-COMPONENT-SEQ Numeric 3 AP115 AP125
Component Sequence This field contains the component AP126 AP131
Number sequence number. 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
MA126 MA180
MA41.1 MA41.2
MA41.4 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 MAI1.1
PO100 PO101
PO122 PO131
PO135 PO136
...
MMD-LINE-SEQ Numeric 3 AP115 AP125
Line Seq Sequence 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
MA126 MA180
MA41.1 MA41.2
MA41.4 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 MAI1.1
PO100 PO101
PO122 PO131
PO135 PO136
...
MMD-AOC-CODE Alpha 2 AP115 AP125
Add On Cost Code This 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
MA126 MA180
MA41.1 MA41.2
MA41.4 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 MAI1.1
PO100 PO101
PO122 PO131
PO135 PO136
...
MMD-REQ-LOCATION Alpha 5 AP115 AP125
To Location The location requisitioning items. AP126 AP131
This location can be an inventory or AP20.1 AP20.2
noninventory location. 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
MA126 MA180
MA41.1 MA41.2
MA41.4 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 MAI1.1
PO100 PO101
PO122 PO131
PO135 PO136
...
MMD-ACCT-UNIT Alpha 15 AP115 AP125
Accounting Unit The 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
MA126 MA180
MA41.1 MA41.2
MA41.4 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 MAI1.1
PO100 PO101
PO122 PO131
PO135 PO136
...
MMD-ACCOUNT Numeric 6 AP115 AP125
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
MA126 MA180
MA41.1 MA41.2
MA41.4 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 MAI1.1
PO100 PO101
PO122 PO131
PO135 PO136
...
MMD-SUB-ACCT Numeric 4 AP115 AP125
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
MA126 MA180
MA41.1 MA41.2
MA41.4 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 MAI1.1
PO100 PO101
PO122 PO131
PO135 PO136
...
MMD-DIST-COMPANY Numeric 4 AP115 AP125
Distribution 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
MA126 MA180
MA41.1 MA41.2
MA41.4 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 MAI1.1
PO100 PO101
PO122 PO131
PO135 PO136
...
MMD-ACTIVITY Alpha 15 AP115 AP125
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 MA126 MA180
activity levels. There are two types of MA41.1 MA41.2
activities: "posting allowed" and MA41.4 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 MAI1.1
PO100 PO101
PO122 PO131
PO135 PO136
...
MMD-ACCT-CATEGORY Alpha 5 AP115 AP125
Account Category Account 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). MA126 MA180
MA41.1 MA41.2
Period-to-date, year-to-date, and MA41.4 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 MAI1.1
PO100 PO101
PO122 PO131
PO135 PO136
...
MMD-ASSET-TEMPLATE Alpha 10 AP115 AP125
Asset Template A 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 MA126 MA180
required if you define new assets as a MA41.1 MA41.2
result of transactions interfaced from MA41.4 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 MAI1.1
PO100 PO101
PO122 PO131
PO135 PO136
...
MMD-ASSET Numeric 10 AP115 AP125
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
MA126 MA180
MA41.1 MA41.2
MA41.4 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 MAI1.1
PO100 PO101
PO122 PO131
PO135 PO136
...
MMD-DIST-PERCENT Signed 6.3 AP115 AP125
Distribution 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
MA126 MA180
MA41.1 MA41.2
MA41.4 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 MAI1.1
PO100 PO101
PO122 PO131
PO135 PO136
...
MMD-DIST-QTY Signed 13.4 AP115 AP125
Distribution This field indicates the quantity from AP126 AP131
Quantity the line that is to be posted to this AP20.1 AP20.2
account, if distributed by quantity. The AP20.3 AP20.4
total amount distributed would be AP20.5 AP20.7
quantity times unit cost. 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
MA126 MA180
MA41.1 MA41.2
MA41.4 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 MAI1.1
PO100 PO101
PO122 PO131
PO135 PO136
...
MMD-DIST-AMOUNT Signed 13.2 AP115 AP125
Distribution Amount This 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
MA126 MA180
MA41.1 MA41.2
MA41.4 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 MAI1.1
PO100 PO101
PO122 PO131
PO135 PO136
...
MMD-POSTING-TYPE Alpha 2 AP115 AP125
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
MA126 MA180
MA41.1 MA41.2
MA41.4 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 MAI1.1
PO100 PO101
PO122 PO131
PO135 PO136
...
MMD-STATUS Numeric 1 AP115 AP125
Status This field displays the status of the AP126 AP131
transaction. AP20.1 AP20.2
AP20.3 AP20.4
0 = Unposted AP20.5 AP20.7
1 = Posted AP220 AP23.1
2 = Not to be Posted AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 API1.1
DR100 IC130
IC141 IC142
IC28.1 IC83.1
MA126 MA180
MA41.1 MA41.2
MA41.4 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 MAI1.1
PO100 PO101
PO122 PO131
PO135 PO136
...
MMD-POSTED-DATE Numeric 8 (yyyymmdd) AP115 AP125
Posted 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
MA126 MA180
MA41.1 MA41.2
MA41.4 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 MAI1.1
PO100 PO101
PO122 PO131
PO135 PO136
...
MMD-POSTED-TIME Numeric 6 (hhmmss) AP115 AP125
Posted 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
MA126 MA180
MA41.1 MA41.2
MA41.4 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 MAI1.1
PO100 PO101
PO122 PO131
PO135 PO136
...
MMD-GLT-OBJ-ID Numeric 12 AP115 AP125
Subsystem GL This is a subsystem General Ledger AP126 AP131
Interface ID 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
MA126 MA180
MA41.1 MA41.2
MA41.4 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 MAI1.1
PO100 PO101
PO122 PO131
PO135 PO136
...
MMD-ATN-OBJ-ID Numeric 12 AP115 AP125
Atn Object ID This field is used to link general AP126 AP131
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
MA126 MA180
MA41.1 MA41.2
MA41.4 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 MAI1.1
PO100 PO101
PO122 PO131
PO135 PO136
...
MMD-API-OBJ-ID Numeric 12 AP115 AP125
Api Obj Id 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
MA126 MA180
MA41.1 MA41.2
MA41.4 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 MAI1.1
PO100 PO101
PO122 PO131
PO135 PO136
...
MMD-PULL-FOR-FR-FL Alpha 1 AP115 AP125
Pull For Fr Fl 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
IC131 IC141
IC142 IC28.1
IC83.1 MA126
MA180 MA41.1
MA41.2 MA41.4
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
MAI1.1 PO100
PO101 PO122
PO131 PO135
...
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 IC240
IC28.1 IC280
IC300 IC83.1
...
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 IC28.1
DOC-NUMBER MA180 MA43.9
DOC-NBR-NUM MA530 MA531
PO-CODE MA60.2 MA60.3
LINE-NBR MA60.5 MA61.1
COMPONENT-SEQ MA66.3 MA67.1
AOC-CODE MA67.2 MA70.1
LINE-SEQ MAI1.1 PO100
API-OBJ-ID PO101 PO122
REQ-LOCATION PO131 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
...
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
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" AP25.1 AP25.2
DOC-NBR-NUM And DOC-TYPE = "PT" AP26.1 AP27.1
PO-CODE And LINE-SEQ < 997 API1.1 MA180
LINE-NBR MA61.1 MA66.2
AOC-CODE MAI1.1
LINE-SEQ
MMDSET5 COMPANY Subset AP125 AP126
API-OBJ-ID Where SYSTEM-CD = "AP" AP25.1 AP25.2
LINE-NBR AP26.1 AP27.1
AOC-CODE AP300 API1.1
LINE-SEQ MA61.1 MA66.2
MAI1.1
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
MA126 MA180
MA41.1 MA41.2
...
MMDSET8 COMPANY Subset DR100 IC141
DOC-NBR-NUM Where SYSTEM-CD = "RQ" IC142 IC83.1
LINE-NBR And DOC-TYPE = "RQ" PO100 PO23.1
LINE-SEQ POIF.1 POIG.1
POIM.1 RQ10.1
RQ10.2 RQ10.3
RQ11.1 RQ111
RQ12.1 RQ13.1
RQ230 RQ300
RQ35.1 RQ500
RQIF.1 WH20.7
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"
Or MMD-DOC-TYPE = "RA"
Or MMD-DOC-TYPE = "RJ"
MMD-COMPANY -> PRL-COMPANY
MMD-DOC-NBR-NUM -> PRL-REC-NUMBER
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
|