MMDIST

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.
UPDATED BY
AM19.1 AM19.2 AP115 AP125 AP126 AP131
AP20.1 AP20.2 AP20.3 AP20.4 AP20.5 AP20.7
AP21.1 AP220 AP23.1 AP25.1 AP25.2 AP26.1
AP27.1 AP30.2 AP30.4 AP300 AP305 API1.1
API2.1 MA41.1 MA41.2 MA41.4 MA41.7 MA43.1
MA43.2 MA43.3 MA43.4 MA43.6 MA43.7 MAI1.1
PO136 PO190 PO300 PO520 POCP.1 POI3.1
POIF.1 POII.1 POIJ.1 MM280 AM17.1 POIG.1
POIM.1 RQ300

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MMD-COMPANY
Element: Company
Numeric 4
The company number.
AM19.1 AM19.2
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1 POIM.1
MMD-SYSTEM-CD
Element: System Cd
Alpha 2
This field indicates on what system the transaction originated.
IC = INVENTORY-CONTROL
PO = PURCHASE-ORDER
RQ = REQUISITIONS
AP = Accounts Payable
AM19.1 AM19.2
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1 POIM.1
MMD-LOCATION
Element: Location
Alpha 5
This field contains a valid stock location within the company inventory.
AM19.1 AM19.2
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1 POIM.1
MMD-DOC-TYPE
Element: Doc Type
Alpha 2
This field contains the type of transaction.
AJ = Adjustment
AR = Receiving Archive
CA = Cost Adjustment
CR = Customer Return
DT = Direct Transfer
IN = Invoice Details
IS = Issue
IT = Transfer Issue
PA = Price Agreement
PI = Physical Inventory Adjustment
PO = PO Receiving
PT = Purchase Order Template-New PO
RA = Receiving Adjustment
RC = Receipt
RJ = Inspection Reject
RR = Requisition Return
RT = Receiving Transfer
VA = Vendor Return Adjustment
VR = Vendor Return
IF = Interface
RQ = Requisition
AC = Accepted Inspection
AM19.1 AM19.2
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1 POIM.1
MMD-DOC-NUMBER
Element: Doc Number
Alpha 14 (Right Justified)
AM19.1 AM19.2
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1 POIM.1
MMD-DOC-NBR-NUM
Element: Doc Nbr Num
Numeric 10
This field contains the number for the document tied to the distribution if a numeric document.
AM19.1 AM19.2
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1 POIM.1
MMD-PO-CODE
Element: Po Code
Alpha 4
This is the purchase order code.
AM19.1 AM19.2
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1 POIM.1
MMD-LINE-NBR
Element: Line Nbr
Numeric 6
This field contains the line number.
AM19.1 AM19.2
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1 POIM.1
MMD-COMPONENT-SEQ
Element: Seq
Numeric 3
This field contains the record sequence number.
AM19.1 AM19.2
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1 POIM.1
MMD-LINE-SEQ
Element: Seq
Numeric 3
Sequence number within a line number.
AM19.1 AM19.2
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1 POIM.1
MMD-AOC-CODE
Element: Aoc Code
Alpha 2
This field contains the identifier for the add-on cost associated with this line item.
AM19.1 AM19.2
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1 POIM.1
MMD-REQ-LOCATION
Element: Req Location
Alpha 5
The location requisitioning items. This location can be an inventory or noninventory location.
AM19.1 AM19.2
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1 POIM.1
MMD-ACCT-UNIT
Element: Acct Unit
Alpha 15
The accounting unit is a shorthand notation representing the variable level number. When used in the General Ledger account master file, the accounting unit must be defined in the General Ledger names file as a posting accounting unit.
AM19.1 AM19.2
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1 POIM.1
MMD-ACCOUNT
Element: Account
Numeric 6
This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.
AM19.1 AM19.2
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1 POIM.1
MMD-SUB-ACCT
Element: Sub Acct
Numeric 4
This field contains the subaccount from your general ledger chart of accounts that was charged with the amount carried on this record.
AM19.1 AM19.2
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1 POIM.1
MMD-DIST-COMPANY
Element: Company
Numeric 4
The company number used for posting the transaction. A valid intercompany relationship must be defined in General Ledger.
AM19.1 AM19.2
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1 POIM.1
MMD-ACTIVITY
Element: Activity
Alpha 15
Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity. Activities and cost object activities are used synonymously in Project Accounting. Direct costs are posted to activities, and indirect costs are allocated to activities based on activity drivers. Activities are grouped or organized by activity levels. There are two types of activities: "posting allowed" and "summary only." Use posting level activities to budget and maintain all posted transactions. Summary activities or macro activities combine information and balances from lower level activities for reporting and inquiries.
AM19.1 AM19.2
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1 POIM.1
MMD-ACCT-CATEGORY
Element: Acct Category
Alpha 5
Account categories are groupings of costs, revenues, or a combination of both used for reporting and inquiries for activities in Project Accounting. All transactions are posted to an account category within an activity. You can assign a specific general ledger account or range of accounts (company, accounting unit, account, and subaccount) that make up the transactions posted to an account category using Account Assignment (AC07.1). Period-to-date, year-to-date, and life-to-date balances are maintained by account category for activities. Account categories must be assigned to activities before you do any budgeting or transaction processing.
AM19.1 AM19.2
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1 POIM.1
MMD-BILL-CATEGORY
Element: Bill Category
Alpha 32
AM19.1 AM19.2
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1
MMD-ASSET-TEMPLATE
Element: Asset Template
Alpha 10
A user-defined asset template identifies general asset creation parameters that you can use to quickly add assets with minimal keying. Using a template lets you default many data items associated with a new asset. You can use an asset template to process quick asset additions in Quick Addition (AM20.1) and to create assets and asset books from Accounts Payable and Project Accounting interface information. Asset templates are required if you define new assets as a result of transactions interfaced from Purchase Order or Accounts Payable.
AM19.1 AM19.2
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1 POIM.1
MMD-ASSET
Element: Asset
Numeric 10
The asset number contains up to ten numeric characters that uniquely identify an asset. Assets are automatically numbered system-wide.
AM19.1 AM19.2
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1 POIM.1
MMD-DIST-PERCENT
Element: Total Percent
Signed 6.3
This field indicates the percent of the extended value of the line that is associated with this account, if the breakdown is by percent. 100 % is stored as 100.000.
AM19.1 AM19.2
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1 POIM.1
MMD-DIST-QTY
Element: Quantity
Signed 13.4
This field contains the desired quantity.
AM19.1 AM19.2
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1 POIM.1
MMD-DIST-AMOUNT
Element: Intl Amt
Signed 18.2
This is the total amount posted to the general ledger for this account. This field is used for drillback information to transactions from Inventory Control and inventory and received not invoiced items from Purchase Order.
AM19.1 AM19.2
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1 POIM.1
MMD-POSTING-TYPE
Element: Posting Type
Alpha 2
For distribution records posted from Inventory Control, this field indicates if the postings were to the inventory account or offset accounts.
I1 = Inventory
O1 = Offset
E1 = RNI Expense Account
RN = Received Not Invoiced
MN = Matched Not Received
A = Add On Cost
AM19.1 AM19.2
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1 POIM.1
MMD-STATUS
Element: Status
Numeric 1
This field displays the status of the transaction.
0 = Unposted
1 = Posted
2 = Not to be Posted
AM19.1 AM19.2
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1 POIM.1
MMD-POSTED-DATE
Element: Posted Date
Numeric 8 (yyyymmdd)
Date posted to the General Ledger system.
AM19.1 AM19.2
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1 POIM.1
MMD-POSTED-TIME
Element: Sys Time
Numeric 6 (hhmmss)
Time posted to the General Ledger system.
AM19.1 AM19.2
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1 POIM.1
MMD-GLT-OBJ-ID
Element: Obj Id
Numeric 12
This is a subsystem General Ledger interface identification number. It is used for Drill Around purposes. In addition, if a GL Commmitment is written to the GLCOMMITX file from RQ or PO, then the GLT-OBJ-ID assigned by the GL system is placed in the MMDIST record and the GLCOMMITX record. The GLT-OBJ-ID on the MMDIST record is used later via PO and AP as a key to remove a corresponding GLCOMMITX record.
AM19.1 AM19.2
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POIF.1
POII.1 POIJ.1
POIM.1
MMD-ATN-OBJ-ID
Element: Obj Id
Numeric 12
This field is used to link general ledger distributions in the Purchase Order system to activities in the Activity Management system. The field allows drill backs to the distribution records from the activities.
AM19.1 AM19.2
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POIF.1
POII.1 POIJ.1
POIM.1
MMD-API-OBJ-ID
Element: Obj Id
Numeric 12
This is the object identifier. It is used to relate commitments or posted transactions back to the originating subsystems. Each subsystem record that is updated as a commitment or posted transaction is assigned an object identifier. The object identifier is maintained in the subsystem files and in the Activity Commitments Detail and Activity Transaction files. The object identifier is a unique key used to drill back from Activity Management to the subsystems.
AM19.1 AM19.2
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1 POIM.1
MMD-PULL-FOR-FR-FL
Element: Pull For Fr Fl
Alpha 1
If Y-Yes the user has specified to process transactions to a retail financial reporting extract file.
AM19.1 AM19.2
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1 POIM.1
MMD-RNI-OBJ-ID
Element: Obj Id
Numeric 12
This is the object identifier. It is used to relate commitments or posted transactions back to the originating subsystems. Each subsystem record that is updated as a commitment or posted transaction is assigned an object identifier. The object identifier is maintained in the subsystem files and in the Activity Commitments Detail and Activity Transaction files. The object identifier is a unique key used to drill back from Activity Management to the subsystems.
AM19.1 AM19.2
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1 POIM.1
MMD-SPA-OBJ-ID
Element: Obj Id
Numeric 12
This is the object ID that links to the system AC spread commitment transaction record POVACOMMIX.
AM19.1 AM19.2
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1
MMD-SPG-OBJ-ID
Element: Obj Id
Numeric 12
This is the object ID that links to the system GL spread commitment transaction record POVACOMMIX.
AM19.1 AM19.2
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1
MMD-SPP-OBJ-ID
Element: Obj Id
Numeric 12
This is the object ID that links to the system PO non-committed spread transaction record POVACOMMIX.
AM19.1 AM19.2
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1


MMDIST FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MMDSET1 COMPANY
SYSTEM-CD
LOCATION
DOC-TYPE
DOC-NUMBER
DOC-NBR-NUM
PO-CODE
LINE-NBR
COMPONENT-SEQ
AOC-CODE
LINE-SEQ
REQ-LOCATION
API-OBJ-ID
...
AM19.1 AM19.2
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MMDSET10 COMPANY
SYSTEM-CD
LOCATION
DOC-TYPE
DOC-NUMBER
DOC-NBR-NUM
PO-CODE
LINE-NBR
COMPONENT-SEQ
AOC-CODE
LINE-SEQ
REQ-LOCATION
API-OBJ-ID
Subset
Where(PULL-FOR-FR-FL ="Y")
MMDSET11 COMPANY
SYSTEM-CD
LOCATION
DOC-TYPE
DOC-NUMBER
DOC-NBR-NUM
PO-CODE
LINE-NBR
COMPONENT-SEQ
AOC-CODE
LINE-SEQ
API-OBJ-ID
REQ-LOCATION
KeyChange
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
MMDSET12 RNI-OBJ-ID
COMPANY
SYSTEM-CD
LOCATION
DOC-TYPE
DOC-NUMBER
DOC-NBR-NUM
LINE-NBR
COMPONENT-SEQ
LINE-SEQ
KeyChange, Subset
WhereRNI-OBJ-ID !=Zeroes
MM280
MMDSET2 ATN-OBJ-ID
COMPANY
SYSTEM-CD
LOCATION
DOC-TYPE
DOC-NUMBER
DOC-NBR-NUM
LINE-NBR
COMPONENT-SEQ
LINE-SEQ
KeyChange, Subset
WhereATN-OBJ-ID !=Zeroes
MMDSET3 GLT-OBJ-ID
COMPANY
SYSTEM-CD
LOCATION
DOC-TYPE
DOC-NUMBER
DOC-NBR-NUM
LINE-NBR
COMPONENT-SEQ
LINE-SEQ
KeyChange, Subset
WhereGLT-OBJ-ID !=Zeroes
MM280
MMDSET4 COMPANY
DOC-NUMBER
DOC-NBR-NUM
PO-CODE
LINE-NBR
AOC-CODE
LINE-SEQ
Subset
WhereSYSTEM-CD ="PO"
AndDOC-TYPE ="PT"
AndLINE-SEQ <997
...
AM17.1 AM19.1
AM19.2 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 API1.1
API2.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MMDSET5 COMPANY
API-OBJ-ID
LINE-NBR
AOC-CODE
LINE-SEQ
Subset
WhereSYSTEM-CD ="AP"
...
AM17.1 AM19.1
AM19.2 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP300 AP305
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MMDSET6 COMPANY
SYSTEM-CD
DOC-NUMBER
DOC-NBR-NUM
REQ-LOCATION
LINE-NBR
LINE-SEQ
KeyChange, Subset
WhereDOC-TYPE ="IF"
MMDSET7 COMPANY
SYSTEM-CD
DOC-TYPE
DOC-NUMBER
DOC-NBR-NUM
LINE-NBR
LINE-SEQ
COMPONENT-SEQ
Subset
WhereSTATUS =Zeroes
And((SYSTEM-CD ="PO")
And(DOC-TYPE !="VA")
And(DOC-TYPE !="VR"))
Or((SYSTEM-CD ="RQ")
And(DOC-TYPE ="IS")
Or(DOC-TYPE ="RR"))
...
AM19.1 AM19.2
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MMDSET8 COMPANY
DOC-NBR-NUM
LINE-NBR
LINE-SEQ
Subset
WhereSYSTEM-CD ="RQ"
AndDOC-TYPE ="RQ"
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
MMDSET9 COMPANY
SYSTEM-CD
DOC-TYPE
DOC-NUMBER
DOC-NBR-NUM
PO-CODE
LINE-NBR
AOC-CODE
LINE-SEQ
Subset
Where(SYSTEM-CD ="PO"
AndDOC-TYPE ="PT"
AndLINE-SEQ <997)
Or(SYSTEM-CD ="RQ"
AndDOC-TYPE ="RQ")
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136


MMDIST FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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
Glnames GLNAMES Required
MMD-COMPANY->GLN-COMPANY
MMD-ACCT-UNIT->GLN-ACCT-UNIT
Ictrans ICTRANS Required
When MMD-SYSTEM-CD ="IC"
MMD-COMPANY->ICT-COMPANY
MMD-LOCATION->ICT-LOCATION
MMD-DOC-TYPE->ICT-DOC-TYPE
MMD-SYSTEM-CD->ICT-SYSTEM-CD
MMD-DOC-NUMBER->ICT-DOCUMENT
MMD-DOC-NBR-NUM->ICT-SHIPMENT-NBR
MMD-LINE-NBR->ICT-LINE-NBR
MMD-COMPONENT-SEQ->ICT-COMPONENT-SEQ
Poaocdtl POAOCDTL Required
When MMD-SYSTEM-CD ="PO"
AndMMD-DOC-TYPE ="PT"
MMD-COMPANY->PAO-COMPANY
Spaces->PAO-PROCURE-GROUP
Spaces->PAO-VEN-AGRMT-REF
MMD-DOC-NUMBER->PAO-PO-NUMBER
MMD-DOC-NBR-NUM->PAO-PO-RELEASE
MMD-PO-CODE->PAO-PO-CODE
MMD-LINE-NBR->PAO-LINE-NBR
MMD-AOC-CODE->PAO-AOC-CODE
Poline POLINE Required
When MMD-SYSTEM-CD ="PO"
AndMMD-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"
AndMMD-DOC-TYPE ="PT"
MMD-COMPANY->PCR-COMPANY
MMD-PO-CODE->PCR-PO-CODE
MMD-DOC-NUMBER->PCR-PO-NUMBER
MMD-DOC-NBR-NUM->PCR-PO-RELEASE
Reqline REQLINE Required
MMD-COMPANY->RLN-COMPANY
MMD-DOC-NBR-NUM->RLN-REQ-NUMBER
MMD-LINE-NBR->RLN-LINE-NBR
Reqline2 REQLINE Required
MMD-COMPANY->RLN-COMPANY
MMD-DOC-NUMBER->RLN-REQ-NUMBER-A
MMD-LINE-NBR->RLN-LINE-NBR
Reqline3 REQLINE Required
When MMD-COMPANY !=MMD-DIST-COMPANY
MMD-DIST-COMPANY->RLN-COMPANY
MMD-DOC-NUMBER->RLN-REQ-NUMBER-A
MMD-LINE-NBR->RLN-LINE-NBR
Reqline9 REQLINE Required
MMD-COMPANY->RLN-FROM-COMPANY
MMD-DOC-NUMBER->RLN-REQ-NUMBER-A
MMD-LINE-NBR->RLN-LINE-NBR


MMDIST FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Sltrans SLTRANS
MMD-GLT-OBJ-ID->SLT-GLT-OBJ-ID
  SLT-OBJ-ID


File created: Wed Jun 08 20:50:42 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.