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.
| FIELD NAME |
DESCRIPTION/VALID VALUES |
UPDATED BY |
MMD-UNIQUE-I-D
Element: Unique I D | Bad Type 36
|
|
MMD-COMPANY
Element: Company | Numeric 4
The company number.
|
|
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 |
|
MMD-LOCATION
Element: Location | Alpha 5
This field contains a valid stock
location within the company inventory.
|
|
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 |
|
MMD-DOC-NUMBER
Element: Doc Number | Alpha 14 (Right Justified)
|
|
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.
|
|
MMD-PO-CODE
Element: Po Code | Alpha 4
This is the purchase order code.
|
|
MMD-LINE-NBR
Element: Line Nbr | Numeric 6
This field contains the line number.
|
|
MMD-COMPONENT-SEQ
Element: Seq | Numeric 3
This field contains the record sequence
number.
|
|
MMD-LINE-SEQ
Element: Seq | Numeric 3
Sequence number within a line number.
|
|
MMD-AOC-CODE
Element: Aoc Code | Alpha 2
This field contains the identifier for
the add-on cost associated with this
line item.
|
|
MMD-REQ-LOCATION
Element: Req Location | Alpha 5
The location requisitioning items.
This location can be an inventory or
noninventory location.
|
|
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.
|
|
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.
|
|
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.
|
|
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.
|
|
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.
|
|
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.
|
|
MMD-BILL-CATEGORY
Element: Bill Category | Alpha 32
|
|
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.
|
|
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.
|
|
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.
|
|
MMD-DIST-QTY
Element: Quantity | Signed 13.4
This field contains the desired
quantity.
|
|
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.
|
|
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 |
|
MMD-STATUS
Element: Status | Numeric 1
This field displays the status of the
transaction.
0 = Unposted
1 = Posted
2 = Not to be Posted |
|
MMD-POSTED-DATE
Element: Posted Date | Numeric 8 (yyyymmdd)
Date posted to the General Ledger
system.
|
|
MMD-POSTED-TIME
Element: Sys Time | Numeric 6 (hhmmss)
Time posted to the General Ledger
system.
|
|
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.
|
|
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.
|
|
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.
|
|
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.
|
|
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.
|
|
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.
|
|
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.
|
|
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.
|
|
MMD-CREATED-BY
Element: Operator | Alpha 10
|
|
MMD-LAST-UPDT-DATE
Element: Date | Numeric 8 (yyyymmdd)
|
|
MMD-LAST-UPDT-TIME
Element: Time | Numeric 8
|
|
MMD-LAST-UPDATE-BY
Element: Operator | Alpha 10
|
|
| 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
|
|
|
| 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
|
|
|
| MMDSET12 |
RNI-OBJ-ID
COMPANY
SYSTEM-CD
LOCATION
DOC-TYPE
DOC-NUMBER
DOC-NBR-NUM
LINE-NBR
COMPONENT-SEQ
LINE-SEQ
|
|
KeyChange, Subset |
| Where | | RNI-OBJ-ID |
!= | Zeroes | |
|
|
| MMDSET13 |
COMPANY
POSTED-DATE
LAST-UPDT-DATE
UNIQUE-I-D
|
|
|
| MMDSET2 |
ATN-OBJ-ID
COMPANY
SYSTEM-CD
LOCATION
DOC-TYPE
DOC-NUMBER
DOC-NBR-NUM
LINE-NBR
COMPONENT-SEQ
LINE-SEQ
|
|
KeyChange, Subset |
| Where | | ATN-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 |
| Where | | GLT-OBJ-ID |
!= | Zeroes | |
|
|
| MMDSET4 |
COMPANY
DOC-NUMBER
DOC-NBR-NUM
PO-CODE
LINE-NBR
AOC-CODE
LINE-SEQ
|
|
Subset |
| Where | | SYSTEM-CD |
= | "PO" | |
| And | | DOC-TYPE |
= | "PT" | |
| And | | LINE-SEQ |
< | 997 | |
|
|
| MMDSET5 |
COMPANY
API-OBJ-ID
LINE-NBR
AOC-CODE
LINE-SEQ
|
|
Subset |
| Where | | SYSTEM-CD |
= | "AP" | |
|
|
| MMDSET6 |
COMPANY
SYSTEM-CD
DOC-NUMBER
DOC-NBR-NUM
REQ-LOCATION
LINE-NBR
LINE-SEQ
|
|
KeyChange, Subset |
| Where | | DOC-TYPE |
= | "IF" | |
|
|
| MMDSET7 |
COMPANY
SYSTEM-CD
DOC-TYPE
DOC-NUMBER
DOC-NBR-NUM
LINE-NBR
LINE-SEQ
COMPONENT-SEQ
|
|
Subset |
| Where | | STATUS |
= | 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" | )) |
|
|
| MMDSET8 |
COMPANY
DOC-NBR-NUM
LINE-NBR
LINE-SEQ
|
|
Subset |
| Where | | SYSTEM-CD |
= | "RQ" | |
| And | | DOC-TYPE |
= | "RQ" | |
|
|
| MMDSET9 |
COMPANY
SYSTEM-CD
DOC-TYPE
DOC-NUMBER
DOC-NBR-NUM
PO-CODE
LINE-NBR
AOC-CODE
LINE-SEQ
|
|
Subset |
| Where | ( | SYSTEM-CD |
= | "PO" | |
| And | | DOC-TYPE |
= | "PT" | |
| And | | LINE-SEQ |
< | 997 | ) |
| Or | ( | SYSTEM-CD |
= | "RQ" | |
| And | | DOC-TYPE |
= | "RQ" | ) |
|
|
| MMDUID |
UNIQUE-I-D
|
|
|
RELATION
NAME |
RELATED 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 |
|
| Glnames |
GLNAMES |
Required
| MMD-COMPANY | -> | GLN-COMPANY |
| MMD-ACCT-UNIT | -> | GLN-ACCT-UNIT |
|
| 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-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" | |
| And | | MMD-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" | |
| 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
| MMD-COMPANY | -> | PTH-COMPANY |
| MMD-DOC-NBR-NUM | -> | PTH-RETURN-NUMBER |
|
| Poreturnln |
PORETURNLN |
Required
| 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 |
|
| 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 |
|
