MMDIST – Account Distributions

System
Purchase Order (PO)
Prefix
MMD
Primary key
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
Fields
41
Updated by
264 programs
Referenced by
21 programs

MMDIST is the Account Distributions table in Lawson Purchase Order (prefix MMD). It is indexed by 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 (MMDSET1); alternate indexes: MMDSET10, MMDSET11, MMDSET12, MMDSET13, MMDSET2, MMDSET3, MMDSET4, MMDSET5 and 5 more. It is related 1:1 to GLMASTER, GLNAMES, ICTRANS, POAOCDTL, POLINE, PORECLINE, PORETURNHD, PORETURNLN and 2 more and 1:M to POAUDIT, RQAUDIT and SLTRANS. It is updated by AM17.1, AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1 and 256 more and referenced by IC220, IC231, IC240, IC242, IC280, IC282, IC50.2, IC53.1 and 13 more. The table has 41 fields, 14 indexes and 16 documented relations.

About MMDIST

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.

Fields (41)

Column = COBOL field name without the MMD- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#MMD-UNIQUE-I-D SET13 UID
UNIQUE_I_D		Bad Type 36——
#MMD-COMPANY PK
COMPANY		Numeric 4The company number.AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +52 more (list truncated in source)
#MMD-SYSTEM-CD PK
SYSTEM_CD		Alpha 2This 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 +52 more (list truncated in source)
#MMD-LOCATION PK
LOCATION		Alpha 5This field contains a valid stock location within the company inventory.AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +52 more (list truncated in source)
#MMD-DOC-TYPE PK
DOC_TYPE		Alpha 2This 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 +52 more (list truncated in source)
#MMD-DOC-NUMBER PK
DOC_NUMBER		Alpha 14 (Right Justified)—AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +52 more (list truncated in source)
#MMD-DOC-NBR-NUM PK
DOC_NBR_NUM		Numeric 10This 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 +52 more (list truncated in source)
#MMD-PO-CODE PK
PO_CODE		Alpha 4This is the purchase order code.AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +52 more (list truncated in source)
#MMD-LINE-NBR PK
LINE_NBR		Numeric 6This field contains the line number.AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +52 more (list truncated in source)
#MMD-COMPONENT-SEQ PK
COMPONENT_SEQ		Numeric 3This field contains the record sequence number.AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +52 more (list truncated in source)
#MMD-LINE-SEQ PK
LINE_SEQ		Numeric 3Sequence number within a line number.AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +52 more (list truncated in source)
#MMD-AOC-CODE PK
AOC_CODE		Alpha 2This 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 +52 more (list truncated in source)
#MMD-REQ-LOCATION PK
REQ_LOCATION		Alpha 5The location requisitioning items. This location can be an inventory or noninventory location.AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +52 more (list truncated in source)
#MMD-ACCT-UNIT
ACCT_UNIT		Alpha 15The 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 +52 more (list truncated in source)
#MMD-ACCOUNT
ACCOUNT		Numeric 6This 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 +52 more (list truncated in source)
#MMD-SUB-ACCT
SUB_ACCT		Numeric 4This 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 +52 more (list truncated in source)
#MMD-DIST-COMPANY
DIST_COMPANY		Numeric 4The 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 +52 more (list truncated in source)
#MMD-ACTIVITY
ACTIVITY		Alpha 15Activities 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 +52 more (list truncated in source)
#MMD-ACCT-CATEGORY
ACCT_CATEGORY		Alpha 5Account 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 +52 more (list truncated in source)
#MMD-BILL-CATEGORY
BILL_CATEGORY		Alpha 32—AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +52 more (list truncated in source)
#MMD-ASSET-TEMPLATE
ASSET_TEMPLATE		Alpha 10A 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 +52 more (list truncated in source)
#MMD-ASSET
ASSET		Numeric 10The 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 +52 more (list truncated in source)
#MMD-DIST-PERCENT
DIST_PERCENT		Signed 6.3This 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 +52 more (list truncated in source)
#MMD-DIST-QTY
DIST_QTY		Signed 13.4This field contains the desired quantity.AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +52 more (list truncated in source)
#MMD-DIST-AMOUNT
DIST_AMOUNT		Signed 18.2This 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 +52 more (list truncated in source)
#MMD-POSTING-TYPE
POSTING_TYPE		Alpha 2For 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 +52 more (list truncated in source)
#MMD-STATUS
STATUS		Numeric 1This 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 +52 more (list truncated in source)
#MMD-POSTED-DATE SET13
POSTED_DATE		Numeric 8 (yyyymmdd)Date posted to the General Ledger system.AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +52 more (list truncated in source)
#MMD-POSTED-TIME
POSTED_TIME		Numeric 6 (hhmmss)Time posted to the General Ledger system.AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +52 more (list truncated in source)
#MMD-GLT-OBJ-ID SET3
GLT_OBJ_ID		Numeric 12This 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 +52 more (list truncated in source)
#MMD-ATN-OBJ-ID SET2
ATN_OBJ_ID		Numeric 12This 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 +52 more (list truncated in source)
#MMD-API-OBJ-ID PK
API_OBJ_ID		Numeric 12This 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 +52 more (list truncated in source)
#MMD-PULL-FOR-FR-FL
PULL_FOR_FR_FL		Alpha 1If 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 +52 more (list truncated in source)
#MMD-RNI-OBJ-ID SET12
RNI_OBJ_ID		Numeric 12This 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 +52 more (list truncated in source)
#MMD-SPA-OBJ-ID
SPA_OBJ_ID		Numeric 12This 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 +52 more (list truncated in source)
#MMD-SPG-OBJ-ID
SPG_OBJ_ID		Numeric 12This 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 +52 more (list truncated in source)
#MMD-SPP-OBJ-ID
SPP_OBJ_ID		Numeric 12This 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 +52 more (list truncated in source)
#MMD-CREATED-BY
CREATED_BY		Alpha 10—AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +52 more (list truncated in source)
#MMD-LAST-UPDT-DATE SET13
LAST_UPDT_DATE		Numeric 8 (yyyymmdd)—AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +52 more (list truncated in source)
#MMD-LAST-UPDT-TIME
LAST_UPDT_TIME		Numeric 8—AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +52 more (list truncated in source)
#MMD-LAST-UPDATE-BY
LAST_UPDATE_BY		Alpha 10—AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +52 more (list truncated in source)

Indexes (14)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
MMDSET1
  1. COMPANY
  2. SYSTEM-CD
  3. LOCATION
  4. DOC-TYPE
  5. DOC-NUMBER
  6. DOC-NBR-NUM
  7. PO-CODE
  8. LINE-NBR
  9. COMPONENT-SEQ
  10. AOC-CODE
  11. LINE-SEQ
  12. REQ-LOCATION
  13. API-OBJ-ID
PrimaryAM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +22 more (list truncated in source)
MMDSET10
  1. COMPANY
  2. SYSTEM-CD
  3. LOCATION
  4. DOC-TYPE
  5. DOC-NUMBER
  6. DOC-NBR-NUM
  7. PO-CODE
  8. LINE-NBR
  9. COMPONENT-SEQ
  10. AOC-CODE
  11. LINE-SEQ
  12. REQ-LOCATION
  13. API-OBJ-ID
SubsetWhere (PULL-FOR-FR-FL = "Y")IC131
MMDSET11
  1. COMPANY
  2. SYSTEM-CD
  3. LOCATION
  4. DOC-TYPE
  5. DOC-NUMBER
  6. DOC-NBR-NUM
  7. PO-CODE
  8. LINE-NBR
  9. COMPONENT-SEQ
  10. AOC-CODE
  11. LINE-SEQ
  12. API-OBJ-ID
  13. REQ-LOCATION
KeyChangeAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
MMDSET12
  1. RNI-OBJ-ID
  2. COMPANY
  3. SYSTEM-CD
  4. LOCATION
  5. DOC-TYPE
  6. DOC-NUMBER
  7. DOC-NBR-NUM
  8. LINE-NBR
  9. COMPONENT-SEQ
  10. LINE-SEQ
KeyChange, SubsetWhere RNI-OBJ-ID != ZeroesPO278, MM280, MM80.1, MM80.2
MMDSET13
  1. COMPANY
  2. POSTED-DATE
  3. LAST-UPDT-DATE
  4. UNIQUE-I-D
KeyChange—
MMDSET2
  1. ATN-OBJ-ID
  2. COMPANY
  3. SYSTEM-CD
  4. LOCATION
  5. DOC-TYPE
  6. DOC-NUMBER
  7. DOC-NBR-NUM
  8. LINE-NBR
  9. COMPONENT-SEQ
  10. LINE-SEQ
KeyChange, SubsetWhere ATN-OBJ-ID != Zeroes—
MMDSET3
  1. GLT-OBJ-ID
  2. COMPANY
  3. SYSTEM-CD
  4. LOCATION
  5. DOC-TYPE
  6. DOC-NUMBER
  7. DOC-NBR-NUM
  8. LINE-NBR
  9. COMPONENT-SEQ
  10. LINE-SEQ
KeyChange, SubsetWhere GLT-OBJ-ID != ZeroesMM280, MM80.1, MM80.2
MMDSET4
  1. COMPANY
  2. DOC-NUMBER
  3. DOC-NBR-NUM
  4. PO-CODE
  5. LINE-NBR
  6. AOC-CODE
  7. LINE-SEQ
SubsetWhere SYSTEM-CD = "PO" And DOC-TYPE = "PT" And LINE-SEQ < 997AM17.1, AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1 +22 more (list truncated in source)
MMDSET5
  1. COMPANY
  2. API-OBJ-ID
  3. LINE-NBR
  4. AOC-CODE
  5. LINE-SEQ
SubsetWhere SYSTEM-CD = "AP"AM17.1, AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1 +22 more (list truncated in source)
MMDSET6
  1. COMPANY
  2. SYSTEM-CD
  3. DOC-NUMBER
  4. DOC-NBR-NUM
  5. REQ-LOCATION
  6. LINE-NBR
  7. LINE-SEQ
KeyChange, SubsetWhere DOC-TYPE = "IF"PO100, PO23.1, WH20.2, WH20.7
MMDSET7
  1. COMPANY
  2. SYSTEM-CD
  3. DOC-TYPE
  4. DOC-NUMBER
  5. DOC-NBR-NUM
  6. LINE-NBR
  7. LINE-SEQ
  8. COMPONENT-SEQ
SubsetWhere 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"))AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +22 more (list truncated in source)
MMDSET8
  1. COMPANY
  2. DOC-NBR-NUM
  3. LINE-NBR
  4. LINE-SEQ
SubsetWhere SYSTEM-CD = "RQ" And DOC-TYPE = "RQ"AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
MMDSET9
  1. COMPANY
  2. SYSTEM-CD
  3. DOC-TYPE
  4. DOC-NUMBER
  5. DOC-NBR-NUM
  6. PO-CODE
  7. LINE-NBR
  8. AOC-CODE
  9. LINE-SEQ
SubsetWhere (SYSTEM-CD = "PO" And DOC-TYPE = "PT" And LINE-SEQ < 997) Or (SYSTEM-CD = "RQ" And DOC-TYPE = "RQ")AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
MMDUID
  1. UNIQUE-I-D
—

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
GLMASTERGLNAMESICTRANSPOAOCDTLPOLINEPORECLINEPORETURNHDPORETURNLNPURCHORDERREQLINEPOAUDITRQAUDITSLTRANSMMDIST

One to one (13) — lookups and parents

RelationTableRulesConditionField map
GlmasterGLMASTERRequired
MMD-COMPANY→GLM-COMPANY (GLMSET2)
MMD-ACCT-UNIT→GLM-ACCT-UNIT
MMD-ACCOUNT→GLM-ACCOUNT
MMD-SUB-ACCT→GLM-SUB-ACCOUNT
GlnamesGLNAMESRequired
MMD-COMPANY→GLN-COMPANY
MMD-ACCT-UNIT→GLN-ACCT-UNIT
IctransICTRANSRequiredWhen 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
PoaocdtlPOAOCDTLRequiredWhen 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
PolinePOLINERequiredWhen 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
PoreclinePORECLINERequiredWhen (MMD-DOC-TYPE = "PO")
MMD-COMPANY→PRL-COMPANY
MMD-DOC-NUMBER→PRL-REC-NUMBER-A
MMD-LINE-NBR→PRL-LINE-NBR
PoreturnhdPORETURNHDRequiredWhen MMD-DOC-TYPE = "VR"
MMD-COMPANY→PTH-COMPANY
MMD-DOC-NBR-NUM→PTH-RETURN-NUMBER
PoreturnlnPORETURNLNRequiredWhen MMD-DOC-TYPE = "VR"
MMD-COMPANY→PTL-COMPANY
MMD-DOC-NBR-NUM→PTL-RETURN-NUMBER
MMD-LINE-NBR→PTL-RET-LINE-NBR
PurchorderPURCHORDERRequiredWhen 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
ReqlineREQLINERequired
MMD-COMPANY→RLN-COMPANY
MMD-DOC-NBR-NUM→RLN-REQ-NUMBER
MMD-LINE-NBR→RLN-LINE-NBR
Reqline2REQLINERequired
MMD-COMPANY→RLN-COMPANY
MMD-DOC-NUMBER→RLN-REQ-NUMBER-A
MMD-LINE-NBR→RLN-LINE-NBR
Reqline3REQLINERequiredWhen MMD-COMPANY != MMD-DIST-COMPANY
MMD-DIST-COMPANY→RLN-COMPANY
MMD-DOC-NUMBER→RLN-REQ-NUMBER-A
MMD-LINE-NBR→RLN-LINE-NBR
Reqline9REQLINERequired
MMD-COMPANY→RLN-FROM-COMPANY
MMD-DOC-NUMBER→RLN-REQ-NUMBER-A
MMD-LINE-NBR→RLN-LINE-NBR

One to many (3) — child tables

RelationTableRulesConditionField map
PoauditPOAUDITValid When MMD-SYSTEM-CD = "PO" And ((MMD-DOC-TYPE = "PO" Or MMD-DOC-TYPE = "PT"))
MMD-COMPANY→PAU-COMPANY
MMD-DOC-NUMBER→PAU-PO-NUMBER
MMD-DOC-NBR-NUM→PAU-PO-RELEASE
MMD-PO-CODE→PAU-PO-CODE
MMD-LINE-NBR→PAU-PO-LINE-NBR
MMD-AOC-CODE→PAU-AOC-CODE
MMD-LINE-SEQ→PAU-LINE-SEQ
—→PAU-PO-REVISION
—→PAU-UPDATE-DATE
—→PAU-UPDATE-TIME
—→PAU-FLD-NBR
—→PAU-AUDIT-TYPE
—→PAU-AUDIT-ACTION
RqauditRQAUDIT
"DS"→RHA-AUDIT-TYPE
MMD-COMPANY→RHA-COMPANY
MMD-DOC-NBR-NUM→RHA-REQ-NUMBER
MMD-LINE-NBR→RHA-LINE-NBR
MMD-LINE-SEQ→RHA-LINE-SEQ
—→RHA-BIN
—→RHA-LOT-SERIAL
—→RHA-UOM
—→RHA-DATE
—→RHA-TIME
—→RHA-FLD-NBR
SltransSLTRANS
MMD-GLT-OBJ-ID→SLT-GLT-OBJ-ID
—→SLT-OBJ-ID

Programs

Updated by (264)

Referenced by (21)