 |
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 PO220 RQ230 RQ111
UPDATED BY
AP115 AP220 AP30.2 AP30.4 AP305 API1.1
DR100 IC130 IC141 IC142 IC300 IC83.1
MA126 MA63.1 MA65.1 MA68.1 PO135 PO136
PO26.1 POIF.1 POIJ.1 RQ11.1 RQ12.1 RQ13.1
WH130 WH33.1 WH33.2 WH33.3 WH33.4 WH33.5
WH33.6 WH33.8 WH33.9 WH34.1 WH34.2 WH34.3
WH34.4 RQ300
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MMD-COMPANY Numeric 4 AP115 AP220
Company The company number. AP30.2 AP30.4
AP305 API1.1
DR100 IC130
IC141 IC142
IC83.1 MA126
MA63.1 MA65.1
MA68.1 PO135
PO136 PO26.1
POIJ.1 RQ11.1
RQ12.1 RQ13.1
WH130 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
MMD-SYSTEM-CD Alpha 2 AP115 AP220
System Code This field indicates on what system the AP30.2 AP30.4
transaction originated. AP305 API1.1
IC = INVENTORY-CONTROL DR100 IC130
PO = PURCHASE-ORDER IC141 IC142
RQ = REQUISITIONS IC83.1 MA126
AP = Accounts Payable MA63.1 MA65.1
MA68.1 PO135
PO136 PO26.1
POIJ.1 RQ11.1
RQ12.1 RQ13.1
WH130 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
MMD-LOCATION Alpha 5 AP115 AP220
Location Code This field contains a valid stock AP30.2 AP30.4
location within the company inventory. AP305 API1.1
DR100 IC130
IC141 IC142
IC83.1 MA126
MA63.1 MA65.1
MA68.1 PO135
PO136 PO26.1
POIJ.1 RQ11.1
RQ12.1 RQ13.1
WH130 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
MMD-DOC-TYPE Alpha 2 AP115 AP220
Document Type This field contains the type of AP30.2 AP30.4
transaction. AP305 API1.1
AJ = Adjustment DR100 IC130
AR = Receiving Archive IC141 IC142
CA = Cost Adjustment IC83.1 MA126
CR = Customer Return MA63.1 MA65.1
DT = Direct Transfer MA68.1 PO135
IN = Invoice Details PO136 PO26.1
IS = Issue POIJ.1 RQ11.1
IT = Transfer Issue RQ12.1 RQ13.1
PA = Price Agreement WH130 WH33.1
PI = Physical Inventory Adjustment WH33.2 WH33.3
PO = PO Receiving WH33.4 WH33.5
PT = Purchase Order Template-New PO WH33.6 WH33.8
RA = Receiving Adjustment WH33.9 WH34.1
RC = Receipt WH34.2 WH34.3
RJ = Inspection Reject WH34.4
RR = Requisition Return
RT = Receiving Transfer
VA = Vendor Return Adjustment
VR = Vendor Return
IF = Interface
RQ = Requisition
AC = Accepted Inspection
MMD-DOC-NUMBER Alpha 14 (Right Justified) AP115 AP220
Doc Number AP30.2 AP30.4
AP305 API1.1
DR100 IC130
IC141 IC142
IC83.1 MA126
MA63.1 MA65.1
MA68.1 PO135
PO136 PO26.1
POIJ.1 RQ11.1
RQ12.1 RQ13.1
WH130 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
MMD-DOC-NBR-NUM Numeric 10 AP115 AP220
Doc Nbr Num This field contains the number for the AP30.2 AP30.4
document tied to the distribution if a AP305 API1.1
numeric document. DR100 IC130
IC141 IC142
IC83.1 MA126
MA63.1 MA65.1
MA68.1 PO135
PO136 PO26.1
POIJ.1 RQ11.1
RQ12.1 RQ13.1
WH130 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
MMD-PO-CODE Alpha 4 AP115 AP220
Po Code This is the purchase order code. AP30.2 AP30.4
AP305 API1.1
DR100 IC130
IC141 IC142
IC83.1 MA126
MA63.1 MA65.1
MA68.1 PO135
PO136 PO26.1
POIJ.1 RQ11.1
RQ12.1 RQ13.1
WH130 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
MMD-LINE-NBR Numeric 6 AP115 AP220
Line Number This field contains the line number. AP30.2 AP30.4
AP305 API1.1
DR100 IC130
IC141 IC142
IC83.1 MA126
MA63.1 MA65.1
MA68.1 PO135
PO136 PO26.1
POIJ.1 RQ11.1
RQ12.1 RQ13.1
WH130 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
MMD-COMPONENT-SEQ Numeric 3 AP115 AP220
Component Sequence This field contains the component AP30.2 AP30.4
Number sequence number. AP305 API1.1
DR100 IC130
IC141 IC142
IC83.1 MA126
MA63.1 MA65.1
MA68.1 PO135
PO136 PO26.1
POIJ.1 RQ11.1
RQ12.1 RQ13.1
WH130 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
MMD-LINE-SEQ Numeric 3 AP115 AP220
Line Seq Sequence number within a line number. AP30.2 AP30.4
AP305 API1.1
DR100 IC130
IC141 IC142
IC83.1 MA126
MA63.1 MA65.1
MA68.1 PO135
PO136 PO26.1
POIJ.1 RQ11.1
RQ12.1 RQ13.1
WH130 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
MMD-AOC-CODE Alpha 2 AP115 AP220
Add On Cost Code This field contains the identifier for AP30.2 AP30.4
the add-on cost associated with this AP305 API1.1
line item. DR100 IC130
IC141 IC142
IC83.1 MA126
MA63.1 MA65.1
MA68.1 PO135
PO136 PO26.1
POIJ.1 RQ11.1
RQ12.1 RQ13.1
WH130 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
MMD-REQ-LOCATION Alpha 5 AP115 AP220
To Location The location requisitioning items. AP30.2 AP30.4
This location can be an inventory or AP305 API1.1
noninventory location. DR100 IC130
IC141 IC142
IC83.1 MA126
MA63.1 MA65.1
MA68.1 PO135
PO136 PO26.1
POIJ.1 RQ11.1
RQ12.1 RQ13.1
WH130 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
MMD-ACCT-UNIT Alpha 15 AP115 AP220
Accounting Unit The accounting unit is a shorthand AP30.2 AP30.4
notation representing the variable level AP305 API1.1
number. When used in the General Ledger DR100 IC130
account master file, the accounting unit IC141 IC142
must be defined in the General Ledger IC83.1 MA126
names file as a posting accounting unit. MA63.1 MA65.1
MA68.1 PO135
PO136 PO26.1
POIJ.1 RQ11.1
RQ12.1 RQ13.1
WH130 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
MMD-ACCOUNT Numeric 6 AP115 AP220
Account This field along with the accounting AP30.2 AP30.4
unit and subaccount make up the location AP305 API1.1
(account) where amounts and other DR100 IC130
account information is stored. IC141 IC142
IC83.1 MA126
MA63.1 MA65.1
MA68.1 PO135
PO136 PO26.1
POIJ.1 RQ11.1
RQ12.1 RQ13.1
WH130 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
MMD-SUB-ACCT Numeric 4 AP115 AP220
Subaccount This field contains the subaccount from AP30.2 AP30.4
your general ledger chart of accounts AP305 API1.1
that was charged with the amount carried DR100 IC130
on this record. IC141 IC142
IC83.1 MA126
MA63.1 MA65.1
MA68.1 PO135
PO136 PO26.1
POIJ.1 RQ11.1
RQ12.1 RQ13.1
WH130 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
MMD-DIST-COMPANY Numeric 4 AP115 AP220
Distribution Company The company number used for posting the AP30.2 AP30.4
transaction. A valid intercompany AP305 API1.1
relationship must be defined in the DR100 IC130
General Ledger system. IC141 IC142
IC83.1 MA126
MA63.1 MA65.1
MA68.1 PO135
PO136 PO26.1
POIJ.1 RQ11.1
RQ12.1 RQ13.1
WH130 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
MMD-ACTIVITY Alpha 15 AP115 AP220
Activity Activities are the processes or AP30.2 AP30.4
procedures that produce work. Cost AP305 API1.1
objects (products, services, customers, DR100 IC130
and so on) are the reasons for IC141 IC142
performing the activity. Activities and IC83.1 MA126
cost object activities are used MA63.1 MA65.1
synonymously in the Activity Management MA68.1 PO135
system. Direct costs are posted to PO136 PO26.1
activities, and indirect costs are POIJ.1 RQ11.1
allocated to activities based on RQ12.1 RQ13.1
activity drivers. WH130 WH33.1
WH33.2 WH33.3
Activities are grouped or organized by WH33.4 WH33.5
activity levels. There are two types of WH33.6 WH33.8
activities: "posting allowed" and WH33.9 WH34.1
"summary only." Use posting level WH34.2 WH34.3
activities to budget and maintain all WH34.4
posted transactions. Summary activities
or macro activities combine information
and balances from lower level activities
for reporting and inquiries.
MMD-ACCT-CATEGORY Alpha 5 AP115 AP220
Account Category Account categories are groupings of AP30.2 AP30.4
costs, revenues, or a combination of AP305 API1.1
both used for reporting and inquiries DR100 IC130
for activities in the Activity IC141 IC142
Management system. All transactions are IC83.1 MA126
posted to an account category within an MA63.1 MA65.1
activity. You can assign a specific MA68.1 PO135
general ledger account or range of PO136 PO26.1
accounts (company, accounting unit, POIJ.1 RQ11.1
account, and subaccount) that make up RQ12.1 RQ13.1
the transactions posted to an account WH130 WH33.1
category using AC07.1 (Account WH33.2 WH33.3
Assignment). WH33.4 WH33.5
WH33.6 WH33.8
Period-to-date, year-to-date, and WH33.9 WH34.1
life-to-date balances are maintained by WH34.2 WH34.3
account category for activities. Account WH34.4
categories must be assigned to
activities before you do any budgeting
or transaction processing.
MMD-ASSET-TEMPLATE Alpha 10 AP115 AP220
Asset Template A user-defined asset template AP30.2 AP30.4
identifies general asset creation AP305 API1.1
parameters that you can use to quickly DR100 IC130
add assets with minimal keying. Using a IC141 IC142
template lets you default many data IC83.1 MA126
items associated with a new asset. MA63.1 MA65.1
MA68.1 PO135
You can use an asset template to PO136 PO26.1
process quick asset additions in AM20.1 POIJ.1 RQ11.1
(Quick Addition) and to create assets RQ12.1 RQ13.1
and asset books from Accounts Payable WH130 WH33.1
and Activity Management interface WH33.2 WH33.3
information. Asset templates are WH33.4 WH33.5
required if you define new assets as a WH33.6 WH33.8
result of transactions interfaced from WH33.9 WH34.1
the Purchase Order or Accounts Payable WH34.2 WH34.3
systems. WH34.4
MMD-ASSET Numeric 10 AP115 AP220
Asset Number The asset number contains up to ten AP30.2 AP30.4
numeric characters that uniquely AP305 API1.1
identify an asset. Assets are DR100 IC130
automatically numbered system-wide. IC141 IC142
IC83.1 MA126
MA63.1 MA65.1
MA68.1 PO135
PO136 PO26.1
POIJ.1 RQ11.1
RQ12.1 RQ13.1
WH130 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
MMD-DIST-PERCENT Signed 6.3 AP115 AP220
Distribution Percent This field indicates the percent of the AP30.2 AP30.4
extended value of the line that is AP305 API1.1
associated with this account, if the DR100 IC130
breakdown is by percent. IC141 IC142
IC83.1 MA126
MA63.1 MA65.1
MA68.1 PO135
PO136 PO26.1
POIJ.1 RQ11.1
RQ12.1 RQ13.1
WH130 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
MMD-DIST-QTY Signed 13.4 AP115 AP220
Distribution This field indicates the quantity from AP30.2 AP30.4
Quantity the line that is to be posted to this AP305 API1.1
account, if distributed by quantity. The DR100 IC130
total amount distributed would be IC141 IC142
quantity times unit cost. IC83.1 MA126
MA63.1 MA65.1
MA68.1 PO135
PO136 PO26.1
POIJ.1 RQ11.1
RQ12.1 RQ13.1
WH130 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
MMD-DIST-AMOUNT Signed 13.2 AP115 AP220
Distribution Amount This is the total amount posted to the AP30.2 AP30.4
general ledger for this account. This AP305 API1.1
field is used for drillback information DR100 IC130
to transactions from the Inventory IC141 IC142
Control system and inventory and IC83.1 MA126
received not invoiced items from the MA63.1 MA65.1
Purchase Order system. MA68.1 PO135
PO136 PO26.1
POIJ.1 RQ11.1
RQ12.1 RQ13.1
WH130 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
MMD-POSTING-TYPE Alpha 2 AP115 AP220
Posting Type For distribution records posted from AP30.2 AP30.4
Inventory Control, this field indicates AP305 API1.1
if the postings were to the inventory DR100 IC130
account or offset accounts. IC141 IC142
I1 = Inventory IC83.1 MA126
O1 = Offset MA63.1 MA65.1
E1 = RNI Expense Account MA68.1 PO135
RN = Received Not Invoiced PO136 PO26.1
MN = Matched Not Received POIJ.1 RQ11.1
A = Add On Cost RQ12.1 RQ13.1
WH130 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
MMD-STATUS Numeric 1 AP115 AP220
Status This field displays the status of the AP30.2 AP30.4
transaction. AP305 API1.1
0 = Unposted DR100 IC130
1 = Posted IC141 IC142
2 = Not to be Posted IC83.1 MA126
MA63.1 MA65.1
MA68.1 PO135
PO136 PO26.1
POIJ.1 RQ11.1
RQ12.1 RQ13.1
WH130 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
MMD-POSTED-DATE Numeric 8 (yyyymmdd) AP115 AP220
Posted Date Date posted to the General Ledger AP30.2 AP30.4
system. AP305 API1.1
DR100 IC130
IC141 IC142
IC83.1 MA126
MA63.1 MA65.1
MA68.1 PO135
PO136 PO26.1
POIJ.1 RQ11.1
RQ12.1 RQ13.1
WH130 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
MMD-POSTED-TIME Numeric 6 (hhmmss) AP115 AP220
Posted Time Time posted to the General Ledger AP30.2 AP30.4
system. AP305 API1.1
DR100 IC130
IC141 IC142
IC83.1 MA126
MA63.1 MA65.1
MA68.1 PO135
PO136 PO26.1
POIJ.1 RQ11.1
RQ12.1 RQ13.1
WH130 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
MMD-GLT-OBJ-ID Numeric 12 AP115 AP220
Subsystem GL This is a subsystem General Ledger AP30.2 AP30.4
Interface ID interface identification number. It is AP305 API1.1
used for Drill Around purposes. DR100 IC130
IC141 IC142
IC83.1 MA126
MA63.1 MA65.1
MA68.1 PO135
PO136 PO26.1
POIJ.1 RQ11.1
RQ12.1 RQ13.1
WH130 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
MMD-ATN-OBJ-ID Numeric 12 AP115 AP220
Atn Object ID This field is used to link general AP30.2 AP30.4
ledger distributions in the Purchase AP305 API1.1
Order system to activities in the DR100 IC130
Activity Management system. The field IC141 IC142
allows drill backs to the distribution IC83.1 MA126
records from the activities. MA63.1 MA65.1
MA68.1 PO135
PO136 PO26.1
POIF.1 POIJ.1
RQ11.1 RQ12.1
RQ13.1 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
MMD-API-OBJ-ID Numeric 12 AP115 AP220
Api Obj Id AP30.2 AP30.4
AP305 API1.1
DR100 IC130
IC141 IC142
IC83.1 MA126
MA63.1 MA65.1
MA68.1 PO135
PO136 PO26.1
POIJ.1 RQ11.1
RQ12.1 RQ13.1
WH130 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
MMDIST FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MMDSET1 COMPANY AP115 AP220
SYSTEM-CD AP30.2 AP30.4
LOCATION AP305 API1.1
DOC-TYPE API2.1 DR100
DOC-NUMBER IC130 IC141
DOC-NBR-NUM IC142 IC240
PO-CODE IC300 IC83.1
LINE-NBR MA126 MA63.1
COMPONENT-SEQ MA65.1 MA68.1
AOC-CODE PO135 PO136
LINE-SEQ PO220 PO26.1
REQ-LOCATION POIJ.1 RQ11.1
API-OBJ-ID RQ12.1 RQ13.1
RQ230 WH130
WH33.1 WH33.2
...
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
DOC-NUMBER Where SYSTEM-CD = "PO"
DOC-NBR-NUM And DOC-TYPE = "PT"
PO-CODE And LINE-SEQ < 997
LINE-NBR
AOC-CODE
LINE-SEQ
MMDSET5 COMPANY Subset
API-OBJ-ID Where SYSTEM-CD = "AP"
LINE-NBR
AOC-CODE
LINE-SEQ
MMDSET6 COMPANY KeyChange, Subset
SYSTEM-CD Where DOC-TYPE = "IF"
DOC-NUMBER
DOC-NBR-NUM
REQ-LOCATION
LINE-NBR
LINE-SEQ
MMDSET7 COMPANY Subset AP115 AP220
SYSTEM-CD Where STATUS = Zeroes AP30.2 AP30.4
DOC-TYPE And ((SYSTEM-CD = "PO" ) AP305 API1.1
DOC-NUMBER And (DOC-TYPE != "VA" ) DR100 IC130
DOC-NBR-NUM And (DOC-TYPE != "VR" )) IC141 IC142
LINE-NBR Or ((SYSTEM-CD = "RQ" ) IC83.1 MA126
LINE-SEQ And (DOC-TYPE = "IS" ) MA63.1 MA65.1
Or (DOC-TYPE = "RR" )) MA68.1 PO135
PO136 PO26.1
POIJ.1 RQ11.1
RQ12.1 RQ13.1
WH130 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
...
MMDSET8 COMPANY Subset DR100 IC141
DOC-NBR-NUM Where SYSTEM-CD = "RQ" IC142 IC83.1
LINE-NBR And DOC-TYPE = "RQ" POIF.1 RQ11.1
LINE-SEQ RQ111 RQ12.1
RQ13.1 RQ230
RQ300
MMDSET9 COMPANY This index is used for budget checking POIF.1 WH130
SYSTEM-CD and commitment processing when working WH33.1 WH33.2
DOC-TYPE with activities. WH33.3 WH33.4
DOC-NUMBER Subset WH33.5 WH33.6
DOC-NBR-NUM Where (SYSTEM-CD = "PO" WH33.8 WH33.9
PO-CODE And DOC-TYPE = "PT" WH34.1 WH34.2
LINE-NBR And LINE-SEQ < 997 ) WH34.3 WH34.4
AOC-CODE Or (SYSTEM-CD = "RQ"
LINE-SEQ And DOC-TYPE = "RQ" )
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
|