MTL_MATERIAL_TRANSACTION表字段的解释及和各相关表的关联-可打印.doc

MTL_MATERIAL_TRANSACTIONSPrimary Key: MTL_MATERIAL_TRANSACTIONS_PK1. TRANSACTION_IDForeign KeysTableForeign TableForeign Key ColumnMTL_MATERIAL_TRANSACTIONSGL_CODE_COMBINATIONS MTL_MATERIAL_TRANSACTIONS.TRANSFER_COST_DIST_ACCOUNT MTL_MATERIAL_TRANSACTIONSMTL_ITEM_REVISIONS_B MTL_MATERIAL_TRANSACTIONS.INVENTORY_ITEM_ID MTL_MATERIAL_TRANSACTIONS.ORGANIZATION_ID MTL_MATERIAL_TRANSACTIONS.REVISION MTL_MATERIAL_TRANSACTIONSMTL_CYCLE_COUNT_ENTRIES MTL_MATERIAL_TRANSACTIONS.CYCLE_COUNT_ID MTL_MATERIAL_TRANSACTIONSMTL_PHYSICAL_ADJUSTMENTS MTL_MATERIAL_TRANSACTIONS.PHYSICAL_ADJUSTMENT_ID MTL_MATERIAL_TRANSACTIONSMTL_TRANSACTION_TYPES MTL_MATERIAL_TRANSACTIONS.TRANSACTION_TYPE_ID MTL_MATERIAL_TRANSACTIONSGL_DAILY_CONVERSION_TYPES MTL_MATERIAL_TRANSACTIONS.CURRENCY_CODE MTL_MATERIAL_TRANSACTIONSMTL_SYSTEM_ITEMS_B MTL_MATERIAL_TRANSACTIONS.INVENTORY_ITEM_ID MTL_MATERIAL_TRANSACTIONS.ORGANIZATION_ID MTL_MATERIAL_TRANSACTIONSCST_COST_GROUPS MTL_MATERIAL_TRANSACTIONS.TRANSFER_COST_GROUP_ID MTL_MATERIAL_TRANSACTIONSWIP_DISCRETE_JOBS MTL_MATERIAL_TRANSACTIONS.TRANSACTION_SOURCE_ID MTL_MATERIAL_TRANSACTIONSWIP_REPETITIVE_ITEMS MTL_MATERIAL_TRANSACTIONS.TRANSACTION_SOURCE_ID MTL_MATERIAL_TRANSACTIONS.REPETITIVE_LINE_ID MTL_MATERIAL_TRANSACTIONSMTL_ITEM_LOCATIONS MTL_MATERIAL_TRANSACTIONS.LOCATOR_ID MTL_MATERIAL_TRANSACTIONS.ORGANIZATION_ID MTL_MATERIAL_TRANSACTIONSORG_ACCT_PERIODS MTL_MATERIAL_TRANSACTIONS.ACCT_PERIOD_ID MTL_MATERIAL_TRANSACTIONS.ORGANIZATION_ID MTL_MATERIAL_TRANSACTIONSGL_CODE_COMBINATIONS MTL_MATERIAL_TRANSACTIONS.TRANSPORTATION_DIST_ACCOUNT MTL_MATERIAL_TRANSACTIONSMTL_SECONDARY_INVENTORIES MTL_MATERIAL_TRANSACTIONS.SUBINVENTORY_CODE MTL_MATERIAL_TRANSACTIONS.ORGANIZATION_ID MTL_MATERIAL_TRANSACTIONSWIP_FLOW_SCHEDULES MTL_MATERIAL_TRANSACTIONS.TRANSACTION_SOURCE_ID MTL_MATERIAL_TRANSACTIONSRCV_TRANSACTIONS MTL_MATERIAL_TRANSACTIONS.RCV_TRANSACTION_ID MTL_MATERIAL_TRANSACTIONSWIP_MOVE_TRANSACTIONS MTL_MATERIAL_TRANSACTIONS.MOVE_TRANSACTION_ID MTL_MATERIAL_TRANSACTIONSMTL_TXN_SOURCE_TYPES MTL_MATERIAL_TRANSACTIONS.TRANSACTION_SOURCE_TYPE_ID MTL_MATERIAL_TRANSACTIONSMTL_TXN_REQUEST_LINES MTL_MATERIAL_TRANSACTIONS.MOVE_ORDER_LINE_ID MTL_MATERIAL_TRANSACTIONSMTL_TRANSACTION_REASONS MTL_MATERIAL_TRANSACTIONS.REASON_ID MTL_MATERIAL_TRANSACTIONSGL_CODE_COMBINATIONS MTL_MATERIAL_TRANSACTIONS.DISTRIBUTION_ACCOUNT_ID MTL_MATERIAL_TRANSACTIONSGL_CODE_COMBINATIONS MTL_MATERIAL_TRANSACTIONS.ENCUMBRANCE_ACCOUNT MTL_MATERIAL_TRANSACTIONSCST_COST_GROUPS MTL_MATERIAL_TRANSACTIONS.COST_GROUP_ID AHL_WORKORDER_MTL_TXNS MTL_MATERIAL_TRANSACTIONSAHL_WORKORDER_MTL_TXNS.MATERIAL_TRANSACTION_ID CST_AE_HEADERS MTL_MATERIAL_TRANSACTIONSCST_AE_HEADERS.ACCOUNTING_EVENT_ID CST_COMP_SNAPSHOT MTL_MATERIAL_TRANSACTIONSCST_COMP_SNAPSHOT.TRANSACTION_ID CST_MGD_INFL_TSF_ORG_ENTRIES MTL_MATERIAL_TRANSACTIONSCST_MGD_INFL_TSF_ORG_ENTRIES.TRANSACTION_ID MTL_ACTUAL_COST_SUBELEMENT MTL_MATERIAL_TRANSACTIONSMTL_ACTUAL_COST_SUBELEMENT.TRANSACTION_ID MTL_CST_ACTUAL_COST_DETAILS MTL_MATERIAL_TRANSACTIONSMTL_CST_ACTUAL_COST_DETAILS.TRANSACTION_ID MTL_CST_TXN_COST_DETAILS MTL_MATERIAL_TRANSACTIONSMTL_CST_TXN_COST_DETAILS.TRANSACTION_ID MTL_MATERIAL_TXN_ALLOCATIONS MTL_MATERIAL_TRANSACTIONSMTL_MATERIAL_TXN_ALLOCATIONS.TRANSACTION_ID MTL_OBJECT_EVENTS MTL_MATERIAL_TRANSACTIONSMTL_OBJECT_EVENTS.TRANSACTION_ID MTL_OBJECT_GENEALOGY MTL_MATERIAL_TRANSACTIONSMTL_OBJECT_GENEALOGY.ORIGIN_TXN_ID MTL_ONHAND_QUANTITIES MTL_MATERIAL_TRANSACTIONSMTL_ONHAND_QUANTITIES.CREATE_TRANSACTION_ID MTL_ONHAND_QUANTITIES MTL_MATERIAL_TRANSACTIONSMTL_ONHAND_QUANTITIES.UPDATE_TRANSACTION_ID MTL_PAC_ACTUAL_COST_DETAILS MTL_MATERIAL_TRANSACTIONSMTL_PAC_ACTUAL_COST_DETAILS.TRANSACTION_ID MTL_PAC_COST_SUBELEMENTS MTL_MATERIAL_TRANSACTIONSMTL_PAC_COST_SUBELEMENTS.TRANSACTION_ID MTL_PAC_TXN_COST_DETAILS MTL_MATERIAL_TRANSACTIONSMTL_PAC_TXN_COST_DETAILS.TRANSACTION_ID MTL_SERIAL_NUMBERS MTL_MATERIAL_TRANSACTIONSMTL_SERIAL_NUMBERS.LAST_TRANSACTION_ID MTL_TRANSACTION_ACCOUNTS MTL_MATERIAL_TRANSACTIONSMTL_TRANSACTION_ACCOUNTS.TRANSACTION_ID MTL_TRANSACTION_LOT_NUMBERS MTL_MATERIAL_TRANSACTIONSMTL_TRANSACTION_LOT_NUMBERS.TRANSACTION_ID MTL_UNIT_TRANSACTIONS MTL_MATERIAL_TRANSACTIONSMTL_UNIT_TRANSACTIONS.TRANSACTION_ID PJM_BORROW_PAYBACKS MTL_MATERIAL_TRANSACTIONSPJM_BORROW_PAYBACKS.PAYBACK_TRANSACTION_ID PJM_BORROW_TRANSACTIONS MTL_MATERIAL_TRANSACTIONSPJM_BORROW_TRANSACTIONS.BORROW_TRANSACTION_ID PO_ACCRUAL_RECONCILE_TEMP_ALL MTL_MATERIAL_TRANSACTIONSPO_ACCRUAL_RECONCILE_TEMP_ALL.INV_TRANSACTION_ID PO_ACCRUAL_WRITE_OFFS_ALL MTL_MATERIAL_TRANSACTIONSPO_ACCRUAL_WRITE_OFFS_ALL.INV_TRANSACTION_ID RCV_TRANSACTIONS MTL_MATERIAL_TRANSACTIONSRCV_TRANSACTIONS.INV_TRANSACTION_ID RCV_TRANSACTIONS_INTERFACE MTL_MATERIAL_TRANSACTIONSRCV_TRANSACTIONS_INTERFACE.INV_TRANSACTION_ID WIP_SCRAP_VALUES MTL_MATERIAL_TRANSACTIONSWIP_SCRAP_VALUES.TRANSACTION_ID WMS_DISPATCHED_TASKS_HISTORY MTL_MATERIAL_TRANSACTIONSWMS_DISPATCHED_TASKS_HISTORY.TRANSACTION_IDMTL_MATERIAL_TRANSACTIONS stores a record of every material transaction or cost update performed in Inventory.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 was performed.All accounting journal entries for a given transaction are stored in MTL_TRANSACTION_ACCOUNTS, joined by the column TRANSACTION_ID.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 the item is under serial control then the serial records are stored in MTL_UNIT_TRANSACTIONS, joined by the column TRANSACTION_ID. The Item revision and locator control are stored in the columns REVISION and LOCATOR_ID respectively.Transfer transactions are represented as two single records in the table. They are related through the column TRANSFER_TRANSACTION_ID, which contains the TRANSACTION_ID of the other transaction in the transfer.The index MTL_MATERIAL_TRANSACTIONS_UPGD is used only during install and upgrade, and will be dropped during the course thereof, but is included here for completeness.Table space for table MTL_MATERIAL_TRANSACTIONS is : APPS_TS_TX_IDXColumnsNameDatatypeLengthMandatoryCommentsTRANSACTION_IDNUMBERYesTransaction identifierLAST_UPDATE_DATEDATEYesStandard Who columnLAST_UPDATED_BYNUMBERYesStandard Who columnCREATION_DATEDATEYesStandard Who columnCREATED_BYNUMBERYesStandard Who columnLAST_UPDATE_LOGINNUMBERStandard Who columnREQUEST_IDNUMBERStandard Who columnPROGRAM_APPLICATION_IDNUMBERStandard Who columnPROGRAM_IDNUMBERStandard Who columnPROGRAM_UPDATE_DATEDATEStandard Who columnINVENTORY_ITEM_IDNUMBERYesInventory item identifierREVISIONVARCHAR2(3)Inventory item revisionORGANIZATION_IDNUMBERYesOrganization identifierSUBINVENTORY_CODEVARCHAR2(10)Transaction secondary inventoryLOCATOR_IDNUMBERLocator id for stock locatorsTRANSACTION_TYPE_IDNUMBERYesTransaction type identifierTRANSACTION_ACTION_IDNUMBERYesTransaction action identifierTRANSACTION_SOURCE_TYPE_IDNUMBERYesTransaction source type identifierTRANSACTION_SOURCE_IDNUMBERTransaction source identifierTRANSACTION_SOURCE_NAMEVARCHAR2(30)Transaction source identfierTRANSACTION_QUANTITYNUMBERYesTransaction quantityTRANSACTION_UOMVARCHAR2(3)YesTransaction unit of measurePRIMARY_QUANTITYNUMBERYesTransaction quantity in terms of primary uom of the itemTRANSACTION_DATEDATEYesTransaction dateVARIANCE_AMOUNTNUMBERUsed for average cost update transactionsACCT_PERIOD_IDNUMBERAccounting period identifierTRANSACTION_REFERENCEVARCHAR2(240)Transaction reference codeREASON_IDNUMBERTransaction reason identifierDISTRIBUTION_ACCOUNT_IDNUMBERDistribution account identifierENCUMBRANCE_ACCOUNTNUMBEREncumbrance account identifier for PO transactionsENCUMBRANCE_AMOUNTNUMBERTotal encumbrance amountCOST_UPDATE_IDNUMBERCost identifierCOSTED_FLAGVARCHAR2(1)Costed flag to mark if the transactions are costed or notTRANSACTION_GROUP_IDNUMBERTransaction group iIdentifier for distribution processing by the cost processorINVOICED_FLAGVARCHAR2(1)Invoiced flag to mark if the transactions are invoicedACTUAL_COSTNUMBERActual costTRANSACTION_COSTNUMBERThe cost entered by the user during a transactionPRIOR_COSTNUMBERItem cost before the transactionNEW_COSTNUMBERItem cost after the transaction processingCURRENCY_CODEVARCHAR2(10)Currency conversion codeCURRENCY_CONVERSION_RATENUMBERCurrency conversion rateCURRENCY_CONVERSION_TYPEVARCHAR2(30)Currency conversion typeCURRENCY_CONVERSION_DATEDATECurrency conversion dateUSSGL_TRANSACTION_CODEVARCHAR2(30)ussgl transaction codeQUANTITY_ADJUSTEDNUMBERStandard cost quantity adjustedEMPLOYEE_CODEVARCHAR2(10)Transaction requestorDEPARTMENT_IDNUMBERDepartment identifierOPERATION_SEQ_NUMNUMBEROperation sequence number within a routingMASTER_SCHEDULE_UPDATE_CODEVARCHAR2(10)Master schedule update codeRECEIVING_DOCUMENTVARCHAR2(10)Receiving documentPICKING_LINE_IDNUMBERPicking line idTRX_SOURCE_LINE_IDNUMBERLine level transaction source idTRX_SOURCE_DELIVERY_IDNUMBERSales order delivery identifierREPETITIVE_LINE_IDNUMBERRepetitive line idPHYSICAL_ADJUSTMENT_IDNUMBERPhysical adjustment identifierCYCLE_COUNT_IDNUMBERCycle count identifierRMA_LINE_IDNUMBERRma line identifierTRANSFER_TRANSACTION_IDNUMBERTransaction id of the opposing transfer transactionTRANSACTION_SET_IDNUMBERTransaction group identifierRCV_TRANSACTION_IDNUMBERReceiving transaction cross referenceMOVE_TRANSACTION_IDNUMBERMove transaction cross referenceCOMPLETION_TRANSACTION_IDNUMBERCompletion transaction cross referenceSHORTAGE_PROCESS_CODENUMBERFlag indicating workflow notifications should be provided for this transaction if shortage existsSOURCE_CODEVARCHAR2(30)User- entered source code for outside transactionsSOURCE_LINE_IDNUMBERUser entered source line identifier for outside transactionsVENDOR_LOT_NUMBERVARCHAR2(30)Supplier lot numberTRANSFER_ORGANIZATION_IDNUMBERTransfer opposing organization idTRANSFER_SUBINVENTORYVARCHAR2(10)Transfer transaction opposing subinventoryTRANSFER_LOCATOR_IDNUMBERTransfer transaction opposing locator idSHIPMENT_NUMBERVARCHAR2(30)Intransit shipment identifierTRANSFER_COSTNUMBERTransfer cost specified for inter-org transfersTRANSPORTATION_DIST_ACCOUNTNUMBERTransfer transportation distribution accountTRANSPORTATION_COSTNUMBERTransfer transportation costTRANSFER_COST_DIST_ACCOUNTNUMBERTransaction transfer cost distribution accountWAYBILL_AIRBILLVARCHAR2(20)Airbill / waybill numberFREIGHT_CODEVARCHAR2(30)Intransit shipment freight codeNUMBER_OF_CONTAINERSNUMBERNumber of containersVALUE_CHANGENUMBERTotal value change for average cost updatePERCENTAGE_CHANGENUMBERPercentage average cost change for average cost updateATTRIBUTE_CATEGORYVARCHAR2(30)Descriptive flexfield structure defining columnATTRIBUTE1VARCHAR2(150)Descriptive flexfield segmentATTRIBUTE2VARCHAR2(150)Descriptive flexfield segmentATTRIBUTE3VARCHAR2(150)Descriptive flexfield segmentATTRIBUTE4VARCHAR2(150)Descriptive flexfield segmentATTRIBUTE5VARCHAR2(150)Descriptive flexfield segmentATTRIBUTE6VARCHAR2(150)Descriptive flexfield segmentATTRIBUTE7VARCHAR2(150)Descriptive flexfield segmentATTRIBUTE8VARCHAR2(150)Descriptive flexfield segmentATTRIBUTE9VARCHAR2(150)Descriptive flexfield segmentATTRIBUTE10VARCHAR2(150)Descriptive flexfield segmentATTRIBUTE11VARCHAR2(150)Descriptive flexfield segmentATTRIBUTE12VARCHAR2(150)Descriptive flexfield segmentATTRIBUTE13VARCHAR2(150)Descriptive flexfield segmentATTRIBUTE14VARCHAR2(150)Descriptive flexfield segmentATTRIBUTE15VARCHAR2(150)Descriptive flexfield segmentMOVEMENT_IDNUMBERMovement statistics cross referenceTASK_IDNUMBER(15)Task identifierTO_TASK_IDNUMBER(15)To task identifierPROJECT_IDNUMBER(15)project identifierTO_PROJECT_IDNUMBER(15)To project identifierSOURCE_PROJECT_IDNUMBERSource project identifierPA_EXPENDITURE_ORG_IDNUMBEROracle Projects related expenditure organization identifierSOURCE_TASK_IDNUMBERSource task identifierEXPENDITURE_TYPEVARCHAR2(30)Oracle Projects related expenditure typeERROR_CODEVARCHAR2(240)Error CodeERROR_EXPLANATIONVARCHAR2(240)Error explanationPRIOR_COSTED_QUANTITYNUMBERCosted quantity before this transactionTRANSFER_PRIOR_COSTED_QUANTITYNUMBERTransfer quantity costed before this transactionFINAL_COMPLETION_FLAGVARCHAR2(1)Indicates if job costs need to be flushed out for this discrete jobcompletionPM_COST_COLLECTEDVARCHAR2(1)Specifies whether the row has been interfaced to Oracle ProjectsPM_COST_COLLECTOR_GROUP_IDNUMBERGroup identifier used by cost collector to process group of records.SHIPMENT_COSTEDVARCHAR2(1)Indicates if the shipment transaction has been processed by the cost workerTRANSFER_PERCENTAGENUMBERPercentage of value to attribute to transfer costs in an Inter-OrgtransferMATERIAL_ACCOUNTNUMBERSpecifies the material accountMATERIAL_OVERHEAD_ACCOUNTNUMBERSpecifies the material overhead accountRESOURCE_ACCOUNTNUMBERSpecifies the resource accountOUTSIDE_PROCESSING_ACCOUNTNUMBERSpecifies the acount to be charged for outside processingOVERHEAD_ACCOUNTNUMBERSpecifies the overhead accountCOST_GROUP_IDNUMBERCost group identifierTRANSFER_COST_GROUP_IDNUMBERTransfer cost group identifierFLOW_SCHEDULEVARCHAR2(1)Specifies whether the WIP transaction is a flow or a schedule type transactionQA_COLLECTION_IDNUMBERQuality Results IdentifierOVERCOMPLETION_TRANSACTION_QTYNUMBEROvercompletion transaction quantityOVERCOMPLETION_PRIMARY_QTYNUMBEROvercompletion Primary quantityOVERCOMPLETION_TRANSACTION_IDNUMBEROvercompletion transaction IdentifierMVT_STAT_STATUSVARCHAR2(240)Flag to indicate that the transaction is updated/processed/newCOMMON_BOM_SEQ_IDNUMBERBOM identifier of common billCOMMON_ROUTING_SEQ_IDNUMBERRouting identifier of common routingORG_COST_GROUP_IDNUMBERorganizations cost group idCOST_TYPE_IDNUMBERcost type idPERIODIC_PRIMARY_QUANTITYNUMBERtransaction quantity converted to primary uom of the transfer organization in case of periodic costingMOVE_ORDER_LINE_IDNUMBERThe move order line that this transaction line is tied toTASK_GROUP_IDNUMBERTask group identifier for this taskPICK_SLIP_NUMBERNUMBERPick Slip number for the transaction lineLPN_IDNUMBERLicense Plate Number Identifier - used by WMS onlyTRANSFER_LPN_IDNUMBERTransfer License Plate Number IdentifierPICK_STRATEGY_IDNUMBERWMS strategy used for pickingPICK_RULE_IDNUMBERWMS rule used for pickingPUT_AWAY_STRATEGY_IDNUMBERWMS strategy used for put awayPUT_AWAY_RULE_IDNUMBERWMS rule used for put awayCONTENT_LPN_IDNUMBERTransfer License Plate Number Identifier - used by WMS onlyPICK_SLIP_DATEDATEPick Slip DateCOST_CATEGORY_IDNUMBERCost CategoryORGANIZATION_TYPENUMBEROrganization Type. The values are based on MTL_TP_TYPES lookup.TRANSFER_ORGANIZATION_TYPENUMBERTransfer Organization Type. The values are based on MTL_TP_TYPES lookup.OWNING_ORGANIZATION_IDNUMBEROwning organization identifierOWNING_TP_TYPENUMBEROwning Trading Partner Type. The values are based on MTL_TP_TYPES lookup.XFR_OWNING_ORGANIZATION_IDNUMBERTransfer owning organization identifierTRANSFER_OWNING_TP_TYPENUMBERTransfer Owning Trading Partner Type. The values are based on MTL_TP_TYPES lookup.PLANNING_ORGANIZATION_IDNUMBERPlanning organization identifierPLANNING_TP_TYPENUMBERPlanning Trading Partner Type. The values are based on MTL_TP_TYPES lookup.XFR_PLANNING_ORGANIZATION_IDNUMBERTransfer planning organization identifierTRANSFER_PLANNING_TP_TYPENUMBERTransfer Planning Trading Partner Type. The values are based on MTL_TP_TYPES lookup.SECONDARY_UOM_CODEVARCHAR2(3)Secondary unit of measure that may have been used to do the material transactionSECONDARY_TRANSACTION_QUANTITYNUMBERSecondary quantityTRANSACTION_GROUP_SEQNUMBERSHIP_TO_LOCATION_IDNUMBERLocation identifierRESERVATION_IDNUM