2024年1月24日发(作者：)

MTL_MATERIAL_TRANSACTION表字段的解释及和各相关表的关联-可打印MTL_MATERIAL_TRANSACTIONS Primary Key: MTL_MATERIAL_TRANSACTIONS_CTION_IDForeign KeysGL_CODE_COMBINATIONSMTL_ITEM_REVISIONS_BMTL_CYCLE_COUNT_ENTRIESMTL_PHYSICAL_ADJUSTMENTSMTL_TRANSACTION_TYPESMTL_SYSTEM_ITEMS_BCST_COST_GROUPSWIP_DISCRETE_JOBSWIP_REPETITIVE_ITEMSMTL_ITEM_LOCA TIONSORG_ACCT_PERIODSGL_CODE_COMBINATIONSWIP_FLOW_SCHEDULESRCV_TRANSACTIONSWIP_MOVE_TRANSACTIONSMTL_TXN_SOURCE_TYPESMTL_TXN_REQUEST_LINESMTL_TRANSACTION_REASONSGL_CODE_COMBINATIONSGL_CODE_COMBINATIONSCST_COST_GROUPSAHL_WORKORDER_MTL_TXNSCST_AE_HEADERSCST_COMP_SNAPSHOTCST_MGD_INFL_TSF_ORG_ENTRIESMTL_ACTUAL_COST_SUBELEMENTMTL_CST_ACTUAL_COST_DETAILSMTL_CST_TXN_COST_DETAILSMTL_MATERIAL_TXN_ALLOCATIONSMTL_OBJECT_EVENTSMTL_OBJECT_GENEALOGYMTL_ONHAND_QUANTITIESMTL_ONHAND_QUANTITIESMTL_PAC_ACTUAL_COST_DETAILSMTL_PAC_COST_SUBELEMENTSMTL_PAC_TXN_COST_DETAILSMTL_SERIAL_NUMBERS

MTL_TRANSACTION_ACCOUNTSMTL_TRANSACTION_LOT_NUMBERSMTL_UNIT_TRANSACTIONSPJM_BORROW_PAYBACKSPJM_BORROW_TRANSACTIONSPO_ACCRUAL_WRITE_OFFS_ALLRCV_TRANSACTIONSRCV_TRANSACTIONS_INTERFACEWIP_SCRAP_V ALUESWMS_DISPATCHED_TASKS_HISTORYMTL_MATERIAL_TRANSACTIONS stores a record of every material transaction or cost update performed Records are inserted into this table either through the transaction processor or by the standard cost update program. The columnsTRANSACTION_TYPE_ID, TRANSACTION_ACTION_ID, TRANSACTION_SOURCE_TYPE_ID, TRANSACTION_SOURCE_ID andTRANSACTION_SOURCE_NAME describe what the transaction is and against what entity it All accounting journal entries for a given transaction are stored in MTL_TRANSACTION_ACCOUNTS, joined by the column If the item is under lot control then the lot records are stored in MTL_TRANSACTION_LOT_NUMBERS, joined by the column TRANSACTION_ID. If theitem is under serial control then the serial records are stored in MTL_UNIT_TRANSACTIONS, joined by the column TRANSACTION_ID. The Item revisionand locator control are stored in the columns REVISION and LOCATOR_Transfer transactions are represented as two single records in the table. They are related through the column TRANSFER_TRANSACTION_ID, whichcontains the TRANSACTION_ID of the other transaction in The index MTL_MATERIAL_TRANSACTIONS_UPGD is used only during install and upgrade, and will be dropped during the course thereof, but isincluded here for space for table MTL_MATERIAL_TRANSACTIONS is : APPS_TS_TX_IDXColumns

Query TextCut, paste (and edit) the following text to query this object:SELECT TRANSACTION_ID, LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN, REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, INVENTORY_ITEM_ID, REVISION, ORGANIZATION_ID, LOCATOR_ID, TRANSACTION_TYPE_ID, TRANSACTION_ACTION_ID, TRANSACTION_SOURCE_TYPE_ID , TRANSACTION_SOURCE_ID, TRANSACTION_SOURCE_NAME , TRANSACTION_QUANTITY, TRANSACTION_UOM, PRIMARY_QUANTITY, TRANSACTION_DATE, VARIANCE_AMOUNT, ACCT_PERIOD_ID, TRANSACTION_REFERENCE, REASON_ID, DISTRIBUTION_ACCOUNT_ID, ENCUMBRANCE_ACCOUNT, ENCUMBRANCE_AMOUNT, COST_UPDATE_ID, COSTED_FLAG, TRANSACTION_GROUP_ID, INVOICED_FLAG, ACTUAL_COST

, TRANSACTION_COST, PRIOR_COST, NEW_COST, CURRENCY_CODE, CURRENCY_CONVERSION_RATE , CURRENCY_CONVERSION_TYPE , CURRENCY_CONVERSION_DATE , USSGL_TRANSACTION_CODE, EMPLOYEE_CODE, DEPARTMENT_ID, OPERATION_SEQ_NUM, MASTER_SCHEDULE_UPDATE_CODE , RECEIVING_DOCUMENT, PICKING_LINE_ID, TRX_SOURCE_LINE_ID, TRX_SOURCE_DELIVERY_ID, REPETITIVE_LINE_ID, PHYSICAL_ADJUSTMENT_ID, CYCLE_COUNT_ID, RMA_LINE_ID, TRANSFER_TRANSACTION_ID, TRANSACTION_SET_ID, RCV_TRANSACTION_ID, MOVE_TRANSACTION_ID, COMPLETION_TRANSACTION_ID, SHORTAGE_PROCESS_CODE, SOURCE_CODE, SOURCE_LINE_ID, VENDOR_LOT_NUMBER, TRANSFER_ORGANIZATION_ID, TRANSFER_SUBINVENTORY, TRANSFER_LOCATOR_ID, SHIPMENT_NUMBER, TRANSFER_COST, TRANSPORTATION_DIST_ACCOUNT , TRANSPORTATION_COST, TRANSFER_COST_DIST_ACCOUNT, WAYBILL_AIRBILL, FREIGHT_CODE, NUMBER_OF_CONTAINERS , VALUE_CHANGE, PERCENTAGE_CHANGE, ATTRIBUTE_CATEGORY, ATTRIBUTE1, ATTRIBUTE2, ATTRIBUTE3, ATTRIBUTE4, ATTRIBUTE5, ATTRIBUTE6, ATTRIBUTE7

, ATTRIBUTE8, ATTRIBUTE9, ATTRIBUTE10, ATTRIBUTE11, ATTRIBUTE12, ATTRIBUTE13, ATTRIBUTE14, ATTRIBUTE15, MOVEMENT_ID, TASK_ID, TO_TASK_ID, PROJECT_ID, TO_PROJECT_ID, SOURCE_PROJECT_ID, PA_EXPENDITURE_ORG_ID , SOURCE_TASK_ID, EXPENDITURE_TYPE, ERROR_CODE, ERROR_EXPLANATION, PRIOR_COSTED_QUANTITY, TRANSFER_PRIOR_COSTED_QUANTITY , FINAL_COMPLETION_FLAG, PM_COST_COLLECTED, PM_COST_COLLECTOR_GROUP_ID, SHIPMENT_COSTED, TRANSFER_PERCENTAGE, MATERIAL_ACCOUNT, MATERIAL_OVERHEAD_ACCOUNT, RESOURCE_ACCOUNT, OUTSIDE_PROCESSING_ACCOUNT, OVERHEAD_ACCOUNT, COST_GROUP_ID, TRANSFER_COST_GROUP_ID, FLOW_SCHEDULE, QA_COLLECTION_ID, OVERCOMPLETION_TRANSACTION_QTY , OVERCOMPLETION_PRIMARY_QTY, OVERCOMPLETION_TRANSACTION_ID , MVT_STAT_STATUS, COMMON_BOM_SEQ_ID, COMMON_ROUTING_SEQ_ID, ORG_COST_GROUP_ID, COST_TYPE_ID, PERIODIC_PRIMARY_QUANTITY, MOVE_ORDER_LINE_ID, TASK_GROUP_ID, PICK_SLIP_NUMBER, LPN_ID

, TRANSFER_LPN_ID, PICK_STRATEGY_ID, PICK_RULE_ID, PUT_AWAY_STRATEGY_ID, PUT_AWAY_RULE_ID, CONTENT_LPN_ID, PICK_SLIP_DATE, COST_CATEGORY_ID, ORGANIZATION_TYPE, TRANSFER_ORGANIZATION_TYPE, OWNING_ORGANIZATION_ID, OWNING_TP_TYPE, XFR_OWNING_ORGANIZATION_ID, TRANSFER_OWNING_TP_TYPE, PLANNING_ORGANIZATION_ID, PLANNING_TP_TYPE, XFR_PLANNING_ORGANIZATION_ID, TRANSFER_PLANNING_TP_TYPE, SECONDARY_UOM_CODE, SECONDARY_TRANSACTION_QUANTITY , TRANSACTION_GROUP_SEQ, SHIP_TO_LOCATION_ID, RESERVATION_ID, TRANSACTION_MODE, TRANSACTION_BATCH_ID, TRANSACTION_BATCH_SEQ, INTRANSIT_ACCOUNT, FOB_POINT, PARENT_TRANSACTION_ID, LOGICAL_TRX_TYPE_CODE, TRX_FLOW_HEADER_ID, LOGICAL_TRANSACTIONS_CREATED, LOGICAL_TRANSACTION, INTERCOMPANY_COST, INTERCOMPANY_PRICING_OPTION, INTERCOMPANY_CURRENCY_CODE , ORIGINAL_TRANSACTION_TEMP_ID FROM _MATERIAL_TRANSACTIONS;