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
| FIELD NAME | DESCRIPTION/VALID VALUES | UPDATED BY |
|---|---|---|
| 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. |
| 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 |
|
|||||||||||||||||||||||||||||||||||||||||||||||||
| 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 |
|
| ||||||||||||||||||||||||||||||||||||||||||||||||
| MMDSET2 |
ATN-OBJ-ID COMPANY SYSTEM-CD LOCATION DOC-TYPE DOC-NUMBER DOC-NBR-NUM LINE-NBR COMPONENT-SEQ LINE-SEQ |
|
|||||||||||||||||||||||||||||||||||||||||||||||||
| MMDSET3 |
GLT-OBJ-ID COMPANY SYSTEM-CD LOCATION DOC-TYPE DOC-NUMBER DOC-NBR-NUM LINE-NBR COMPONENT-SEQ LINE-SEQ |
|
| ||||||||||||||||||||||||||||||||||||||||||||||||
| MMDSET4 |
COMPANY DOC-NUMBER DOC-NBR-NUM PO-CODE LINE-NBR AOC-CODE LINE-SEQ |
|
|||||||||||||||||||||||||||||||||||||||||||||||||
| MMDSET5 |
COMPANY API-OBJ-ID LINE-NBR AOC-CODE LINE-SEQ |
|
|||||||||||||||||||||||||||||||||||||||||||||||||
| MMDSET6 |
COMPANY SYSTEM-CD DOC-NUMBER DOC-NBR-NUM REQ-LOCATION LINE-NBR LINE-SEQ |
|
|||||||||||||||||||||||||||||||||||||||||||||||||
| MMDSET7 |
COMPANY SYSTEM-CD DOC-TYPE DOC-NUMBER DOC-NBR-NUM LINE-NBR LINE-SEQ COMPONENT-SEQ |
|
|||||||||||||||||||||||||||||||||||||||||||||||||
| MMDSET8 |
COMPANY DOC-NBR-NUM LINE-NBR LINE-SEQ |
|
|||||||||||||||||||||||||||||||||||||||||||||||||
| MMDSET9 |
COMPANY SYSTEM-CD DOC-TYPE DOC-NUMBER DOC-NBR-NUM PO-CODE LINE-NBR AOC-CODE LINE-SEQ |
|
|||||||||||||||||||||||||||||||||||||||||||||||||
| RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Glmaster | GLMASTER |
Required
| ||||||||||||||||||||||||||||||||||||
| Glnames | GLNAMES |
Required
| ||||||||||||||||||||||||||||||||||||
| Ictrans | ICTRANS |
Required
| ||||||||||||||||||||||||||||||||||||
| Poaocdtl | POAOCDTL |
Required
| ||||||||||||||||||||||||||||||||||||
| Poline | POLINE |
Required
| ||||||||||||||||||||||||||||||||||||
| Porecline | PORECLINE |
Required
| ||||||||||||||||||||||||||||||||||||
| Poreturnhd | PORETURNHD |
Required
| ||||||||||||||||||||||||||||||||||||
| Poreturnln | PORETURNLN |
Required
| ||||||||||||||||||||||||||||||||||||
| Purchorder | PURCHORDER |
Required
| ||||||||||||||||||||||||||||||||||||
| Reqline | REQLINE |
Required
| ||||||||||||||||||||||||||||||||||||
| Reqline2 | REQLINE |
Required
| ||||||||||||||||||||||||||||||||||||
| Reqline3 | REQLINE |
Required
| ||||||||||||||||||||||||||||||||||||
| Reqline9 | REQLINE |
Required
|
| RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||
|---|---|---|---|---|---|---|---|---|
| Sltrans | SLTRANS |
|
All trademarks and registered trademarks are the property of their
respective owners.