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
IC220 IC50.2 MA52.1 PO220 PO221 PO225
PO236 RQ111 RQ120 RQ230 WO293
UPDATED BY
AP125 AP126 AP225 AP226 AP25.1 AP25.2
AP26.1 BL92.1 DR100 IC130 IC141 IC142
IC300 IC83.1 IN20.1 MA300 MA40.1 MA41.4
MA41.6 MA43.3 MA43.4 MA520 MA530 MA540
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 OE113 OE114 OE129 OE14.4 OE15.1
OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE30.1
OE30.2 OE30.3 OE30.4 OE30.5 OE30.6 OE30.7
OE30.9 OE510 OE810 OE830 OE920 OE950
PO100 PO135 PO180 PO20.1 PO21.1 PO21.2
PO21.3 PO21.5 PO21.6 PO22.1 PO22.2 PO22.3
PO25.1 PO25.2 PO25.4 PO26.1 PO28.6 PO30.1
PO31.1 PO32.1 PO33.1 PO34.1 PO35.1 PO530
PO821 PO990 RQ10.1 RQ10.2 RQ10.3 RQ11.1
RQ12.1 RQ13.1 RQ20.1 RQ20.3 RQ20.4 RQ35.1
RQ500 RQ990 WH130 WH132 WH190 WH20.2
WH20.7 WH30.1 WH30.2 WH30.3 WH31.1 WH31.2
WH31.3 WH32.1 WH32.2 WH32.3 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 WO132 WO140 RQ300
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MMD-COMPANY Numeric 4 AP125 AP126
Company The company number. AP225 AP226
AP25.1 AP25.2
AP26.1 BL92.1
DR100 IC130
IC141 IC142
IC83.1 IN20.1
MA40.1 MA41.4
MA41.6 MA43.3
MA43.4 MA520
MA530 MA540
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 OE113
OE114 OE129
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE810 OE830
OE920 OE950
PO100 PO135
...
MMD-SYSTEM-CD Alpha 2 AP125 AP126
System Code This field indicates on what system the AP225 AP226
transaction originated. AP25.1 AP25.2
IC = INVENTORY-CONTROL AP26.1 BL92.1
PO = PURCHASE-ORDER DR100 IC130
RQ = REQUISITIONS IC141 IC142
IC83.1 IN20.1
MA40.1 MA41.4
MA41.6 MA43.3
MA43.4 MA520
MA530 MA540
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 OE113
OE114 OE129
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE810 OE830
OE920 OE950
PO100 PO135
...
MMD-LOCATION Alpha 5 AP125 AP126
Location Code This field contains a valid stock AP225 AP226
location within the company inventory. AP25.1 AP25.2
AP26.1 BL92.1
DR100 IC130
IC141 IC142
IC83.1 IN20.1
MA40.1 MA41.4
MA41.6 MA43.3
MA43.4 MA520
MA530 MA540
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 OE113
OE114 OE129
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE810 OE830
OE920 OE950
PO100 PO135
...
MMD-DOC-TYPE Alpha 2 AP125 AP126
Document Type This field contains the type of AP225 AP226
transaction. AP25.1 AP25.2
IS = Issues AP26.1 BL92.1
IT = Inventory Transfers DR100 IC130
IR = Intransit Receiving IC141 IC142
RC = Inventory Receipts IC83.1 IN20.1
PO = Purchase Order Receiving MA40.1 MA41.4
VR = Vendor Returns MA41.6 MA43.3
ST = Standard Orders MA43.4 MA520
RA = Receiving Adjustment MA530 MA540
RJ = Inspection Reject OE10.1 OE10.2
PT = Purchase Order Template-New PO OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE113
OE114 OE129
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE810 OE830
OE920 OE950
PO100 PO135
...
MMD-DOC-NBR Alpha 10 (Right Justified) AP125 AP126
Doc Nbr This field contains the number for the AP225 AP226
document tied to the distribution if an AP25.1 AP25.2
alpha document number. AP26.1 BL92.1
DR100 IC130
IC141 IC142
IC83.1 IN20.1
MA40.1 MA41.4
MA41.6 MA43.3
MA43.4 MA520
MA530 MA540
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 OE113
OE114 OE129
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE810 OE830
OE920 OE950
PO100 PO135
...
MMD-DOC-NBR-NUM Numeric 10 AP125 AP126
Doc Nbr Num This field contains the number for the AP225 AP226
document tied to the distribution if a AP25.1 AP25.2
numeric document. AP26.1 BL92.1
DR100 IC130
IC141 IC142
IC83.1 IN20.1
MA40.1 MA41.4
MA41.6 MA43.3
MA43.4 MA520
MA530 MA540
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 OE113
OE114 OE129
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE810 OE830
OE920 OE950
PO100 PO135
...
MMD-LINE-NBR Numeric 6 AP125 AP126
Line Number This field contains the line number. AP225 AP226
AP25.1 AP25.2
AP26.1 BL92.1
DR100 IC130
IC141 IC142
IC83.1 IN20.1
MA40.1 MA41.4
MA41.6 MA43.3
MA43.4 MA520
MA530 MA540
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 OE113
OE114 OE129
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE810 OE830
OE920 OE950
PO100 PO135
...
MMD-COMPONENT-SEQ Numeric 3 AP125 AP126
Component Sequence This field contains the component AP225 AP226
Number sequence number. AP25.1 AP25.2
AP26.1 BL92.1
DR100 IC130
IC141 IC142
IC83.1 IN20.1
MA40.1 MA41.4
MA41.6 MA43.3
MA43.4 MA520
MA530 MA540
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 OE113
OE114 OE129
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE810 OE830
OE920 OE950
PO100 PO135
...
MMD-LINE-SEQ Numeric 3 AP125 AP126
Line Seq Sequence number within a line number. AP225 AP226
AP25.1 AP25.2
AP26.1 BL92.1
DR100 IC130
IC141 IC142
IC83.1 IN20.1
MA40.1 MA41.4
MA41.6 MA43.3
MA43.4 MA520
MA530 MA540
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 OE113
OE114 OE129
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE810 OE830
OE920 OE950
PO100 PO135
...
MMD-AOC-CODE Alpha 2 AP125 AP126
Add On Cost Code This field contains the identifier for AP225 AP226
the add-on cost associated with this AP25.1 AP25.2
line item. AP26.1 BL92.1
DR100 IC130
IC141 IC142
IC83.1 IN20.1
MA40.1 MA41.4
MA41.6 MA43.3
MA43.4 MA520
MA530 MA540
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 OE113
OE114 OE129
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE810 OE830
OE920 OE950
PO100 PO135
...
MMD-ACCT-UNIT Alpha 15 AP125 AP126
Accounting Unit The accounting unit is a shorthand AP225 AP226
notation representing the variable level AP25.1 AP25.2
number. When used in the General Ledger AP26.1 BL92.1
account master file, the accounting unit DR100 IC130
must be defined in the General Ledger IC141 IC142
names file as a posting accounting unit. IC83.1 IN20.1
MA40.1 MA41.4
MA41.6 MA43.3
MA43.4 MA520
MA530 MA540
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 OE113
OE114 OE129
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE810 OE830
OE920 OE950
PO100 PO135
...
MMD-ACCOUNT Numeric 6 AP125 AP126
Account This field along with the accounting AP225 AP226
unit and subaccount make up the location AP25.1 AP25.2
(account) where amounts and other AP26.1 BL92.1
account information is stored. DR100 IC130
IC141 IC142
IC83.1 IN20.1
MA40.1 MA41.4
MA41.6 MA43.3
MA43.4 MA520
MA530 MA540
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 OE113
OE114 OE129
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE810 OE830
OE920 OE950
PO100 PO135
...
MMD-SUB-ACCT Numeric 4 AP125 AP126
Subaccount This field contains the subaccount from AP225 AP226
your general ledger chart of accounts AP25.1 AP25.2
that was charged with the amount carried AP26.1 BL92.1
on this record. DR100 IC130
IC141 IC142
IC83.1 IN20.1
MA40.1 MA41.4
MA41.6 MA43.3
MA43.4 MA520
MA530 MA540
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 OE113
OE114 OE129
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE810 OE830
OE920 OE950
PO100 PO135
...
MMD-DIST-COMPANY Numeric 4 AP125 AP126
Distribution Company The company number used for posting the AP225 AP226
transaction. A valid intercompany AP25.1 AP25.2
relationship must be defined in the AP26.1 BL92.1
General Ledger system. DR100 IC130
IC141 IC142
IC83.1 IN20.1
MA40.1 MA41.4
MA41.6 MA43.3
MA43.4 MA520
MA530 MA540
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 OE113
OE114 OE129
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE810 OE830
OE920 OE950
PO100 PO135
...
MMD-ACTIVITY Alpha 15 AP125 AP126
Activity Activities are the processes or AP225 AP226
procedures that produce work. Cost AP25.1 AP25.2
objects (products, services, customers, AP26.1 BL92.1
and so on) are the reasons for DR100 IC130
performing the activity. Activities and IC141 IC142
cost object activities are used IC83.1 IN20.1
synonymously in the Activity Management MA40.1 MA41.4
system. Direct costs are posted to MA41.6 MA43.3
activities, and indirect costs are MA43.4 MA520
allocated to activities based on MA530 MA540
activity drivers. OE10.1 OE10.2
OE10.3 OE10.4
Activities are grouped or organized by OE10.5 OE10.6
activity levels. There are two types of OE10.7 OE10.8
activities: "posting allowed" and OE11.1 OE11.4
"summary only." Use posting level OE11.8 OE11.9
activities to budget and maintain all OE110 OE113
posted transactions. Summary activities OE114 OE129
or macro activities combine information OE14.4 OE15.1
and balances from lower level activities OE15.2 OE15.3
for reporting and inquiries. OE15.4 OE15.5
OE15.7 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE810 OE830
OE920 OE950
PO100 PO135
...
MMD-ACCT-CATEGORY Alpha 5 AP125 AP126
Account Category Account categories are groupings of AP225 AP226
costs, revenues, or a combination of AP25.1 AP25.2
both used for reporting and inquiries AP26.1 BL92.1
for activities in the Activity DR100 IC130
Management system. All transactions are IC141 IC142
posted to an account category within an IC83.1 IN20.1
activity. You can assign a specific MA40.1 MA41.4
general ledger account or range of MA41.6 MA43.3
accounts (company, accounting unit, MA43.4 MA520
account, and subaccount) that make up MA530 MA540
the transactions posted to an account OE10.1 OE10.2
category using AC07.1 (Account OE10.3 OE10.4
Assignment). OE10.5 OE10.6
OE10.7 OE10.8
Period-to-date, year-to-date, and OE11.1 OE11.4
life-to-date balances are maintained by OE11.8 OE11.9
account category for activities. Account OE110 OE113
categories must be assigned to OE114 OE129
activities before you do any budgeting OE14.4 OE15.1
or transaction processing. OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE810 OE830
OE920 OE950
PO100 PO135
...
MMD-ASSET-TEMPLATE Alpha 10 AP125 AP126
Asset Template A user-defined asset template AP225 AP226
identifies general asset creation AP25.1 AP25.2
parameters that you can use to quickly AP26.1 BL92.1
add assets with minimal keying. Using a DR100 IC130
template lets you default many data IC141 IC142
items associated with a new asset. IC83.1 IN20.1
MA40.1 MA41.4
You can use an asset template to MA41.6 MA43.3
process quick asset additions in AM20.1 MA43.4 MA520
(Quick Addition) and to create assets MA530 MA540
and asset books from Accounts Payable OE10.1 OE10.2
and Activity Management interface OE10.3 OE10.4
information. Asset templates are OE10.5 OE10.6
required if you define new assets as a OE10.7 OE10.8
result of transactions interfaced from OE11.1 OE11.4
the Purchase Order or Accounts Payable OE11.8 OE11.9
systems. OE110 OE113
OE114 OE129
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE810 OE830
OE920 OE950
PO100 PO135
...
MMD-ASSET Numeric 10 AP125 AP126
Asset Number The asset number contains up to ten AP225 AP226
numeric characters that uniquely AP25.1 AP25.2
identify an asset. Assets are AP26.1 BL92.1
automatically numbered system-wide. DR100 IC130
IC141 IC142
IC83.1 IN20.1
MA40.1 MA41.4
MA41.6 MA43.3
MA43.4 MA520
MA530 MA540
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 OE113
OE114 OE129
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE810 OE830
OE920 OE950
PO100 PO135
...
MMD-DIST-PERCENT Signed 6.3 AP125 AP126
Distribution Percent This field indicates the percent of the AP225 AP226
extended value of the line that is AP25.1 AP25.2
associated with this account, if the AP26.1 BL92.1
breakdown is by percent. DR100 IC130
IC141 IC142
IC83.1 IN20.1
MA40.1 MA41.4
MA41.6 MA43.3
MA43.4 MA520
MA530 MA540
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 OE113
OE114 OE129
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE810 OE830
OE920 OE950
PO100 PO135
...
MMD-DIST-QTY Signed 13.4 AP125 AP126
Distribution This field indicates the quantity from AP225 AP226
Quantity the line that is to be posted to this AP25.1 AP25.2
account, if distributed by quantity. The AP26.1 BL92.1
total amount distributed would be DR100 IC130
quantity times unit cost. IC141 IC142
IC83.1 IN20.1
MA40.1 MA41.1
MA41.2 MA41.4
MA41.5 MA41.6
MA43.1 MA43.2
MA43.3 MA43.4
MA520 MA530
MA540 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
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE510 OE810
...
MMD-DIST-AMOUNT Signed 11.2 AP125 AP126
Distribution Amount This is the total amount posted to the AP225 AP226
general ledger for this account. This AP25.1 AP25.2
field is used for drillback information AP26.1 BL92.1
to transactions from the Inventory DR100 IC130
Control system and inventory and IC141 IC142
received not invoiced items from the IC83.1 IN20.1
Purchase Order system. MA40.1 MA41.4
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA520
MA530 MA540
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 OE113
OE114 OE129
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE810 OE830
OE920 OE950
...
MMD-POSTING-TYPE Alpha 2 AP125 AP126
Posting Type For distribution records posted from AP225 AP226
Inventory Control, this field indicates AP25.1 AP25.2
if the postings were to the inventory AP26.1 BL92.1
account or offset accounts. DR100 IC130
IC141 IC142
IC83.1 IN20.1
MA40.1 MA41.4
MA41.6 MA43.3
MA43.4 MA520
MA530 MA540
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 OE113
OE114 OE129
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE810 OE830
OE920 OE950
PO100 PO135
...
MMD-STATUS Numeric 1 AP125 AP126
Status This field contains the status of the AP225 AP226
transaction. AP25.1 AP25.2
AP26.1 BL92.1
DR100 IC130
IC141 IC142
IC83.1 IN20.1
MA40.1 MA41.4
MA41.6 MA43.3
MA43.4 MA520
MA530 MA540
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 OE113
OE114 OE129
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE810 OE830
OE920 OE950
PO100 PO135
...
MMD-POSTED-DATE Numeric 8 (yyyymmdd) AP125 AP126
Posted Date Date posted to the General Ledger AP225 AP226
system. AP25.1 AP25.2
AP26.1 BL92.1
DR100 IC130
IC141 IC142
IC83.1 IN20.1
MA40.1 MA41.4
MA41.6 MA43.3
MA43.4 MA520
MA530 MA540
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 OE113
OE114 OE129
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE810 OE830
OE920 OE950
PO100 PO135
...
MMD-POSTED-TIME Numeric 6 (hhmmss) AP125 AP126
Posted Time Time posted to the General Ledger AP225 AP226
system. AP25.1 AP25.2
AP26.1 BL92.1
DR100 IC130
IC141 IC142
IC83.1 IN20.1
MA40.1 MA41.4
MA41.6 MA43.3
MA43.4 MA520
MA530 MA540
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 OE113
OE114 OE129
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE810 OE830
OE920 OE950
PO100 PO135
...
MMD-GLT-OBJ-ID Numeric 12 AP125 AP126
Subsystem GL This is a subsystem General Ledger AP225 AP226
Interface ID interface identification number. It is AP25.1 AP25.2
used for Drill Around purposes. AP26.1 BL92.1
DR100 IC130
IC141 IC142
IC83.1 IN20.1
MA40.1 MA41.4
MA41.6 MA43.3
MA43.4 MA520
MA530 MA540
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 OE113
OE114 OE129
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE810 OE830
OE920 OE950
PO100 PO135
...
MMD-ATN-OBJ-ID Numeric 12 AP125 AP126
AC System Object ID This field is used to link general AP225 AP226
(Sales) ledger distributions in the Purchase AP25.1 AP25.2
Order system to activities in the AP26.1 BL92.1
Activity Management system. The field DR100 IC130
allows drill backs to the distribution IC141 IC142
records from the activities. IC83.1 IN20.1
MA40.1 MA41.4
MA41.6 MA43.3
MA43.4 MA520
MA530 MA540
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 OE113
OE114 OE129
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE810 OE830
OE920 OE950
PO100 PO135
...
MMDIST FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MMDSET1 COMPANY AP125 AP126
SYSTEM-CD AP225 AP226
LOCATION AP25.1 AP25.2
DOC-TYPE AP26.1 BL92.1
DOC-NBR DR100 IC130
DOC-NBR-NUM IC141 IC142
LINE-NBR IC220 IC300
COMPONENT-SEQ IC50.2 IC83.1
AOC-CODE IN20.1 MA300
LINE-SEQ MA40.1 MA41.1
MA41.2 MA41.4
MA41.5 MA41.6
MA43.1 MA43.2
MA43.3 MA43.4
MA52.1 MA520
...
MMDSET2 ATN-OBJ-ID Subset
COMPANY Where ATN-OBJ-ID != Zeroes
SYSTEM-CD
LOCATION
DOC-TYPE
DOC-NBR
DOC-NBR-NUM
LINE-NBR
COMPONENT-SEQ
LINE-SEQ
MMDSET3 GLT-OBJ-ID Subset
COMPANY Where GLT-OBJ-ID != Zeroes
SYSTEM-CD
LOCATION
DOC-TYPE
DOC-NBR
DOC-NBR-NUM
LINE-NBR
COMPONENT-SEQ
LINE-SEQ
MMDIST FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Glmaster GLMASTER Required
MMD-COMPANY -> GLM-COMPANY (GLMSET2)
MMD-ACCT-UNIT -> GLM-ACCT-UNIT
MMD-ACCOUNT -> GLM-ACCOUNT
MMD-SUB-ACCT -> GLM-SUB-ACCOUNT
Ictrans ICTRANS Required
MMD-COMPANY -> ICT-COMPANY
MMD-LOCATION -> ICT-LOCATION
MMD-DOC-TYPE -> ICT-DOC-TYPE
MMD-SYSTEM-CD -> ICT-SYSTEM-CD
MMD-DOC-NBR -> 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-NBR -> PLI-PO-NUMBER
MMD-DOC-NBR-NUM -> PLI-PO-RELEASE
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-TYPE -> PRL-DOC-TYPE
MMD-DOC-NBR -> PRL-DOCUMENT
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-DOC-NBR -> PCR-PO-NUMBER
MMD-DOC-NBR-NUM -> PCR-PO-RELEASE
Reqline REQLINE Required
When MMD-SYSTEM-CD = "RQ"
MMD-COMPANY -> RLN-COMPANY
MMD-DOC-NBR-NUM -> RLN-REQ-NUMBER
MMD-LINE-NBR -> RLN-LINE-NBR
Reqline2 REQLINE Required
When MMD-SYSTEM-CD = "RQ"
MMD-COMPANY -> RLN-COMPANY
MMD-DOC-NBR -> RLN-REQ-NUMBER
MMD-LINE-NBR -> RLN-LINE-NBR
Whshipline WHSHIPLINE Required
MMD-COMPANY -> WHL-COMPANY
MMD-LOCATION -> WHL-LOCATION
MMD-DOC-NBR-NUM -> WHL-SHIPMENT-NBR
MMD-LINE-NBR -> WHL-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
|