transactionid

MTL_MATERIAL_TRANSACTIONS

PrimaryKey:MTL_MATERIAL_TRANSACTIONS_PK

CTION_ID

ForeignKeys

TableForeignTableForeignKeyColumn

MTL_MATERIAL_TRANSACTIONS

GL_CODE_COMBINATIONS

MTL_MATERIAL_ER_COST_DIST_ACCOUNT

MTL_MATERIAL_TRANSACTIONS

MTL_ITEM_REVISIONS_B

MTL_MATERIAL_ORY_ITEM_ID

MTL_MATERIAL_ZATION_ID

MTL_MATERIAL_ON

MTL_MATERIAL_TRANSACTIONS

MTL_CYCLE_COUNT_ENTRIES

MTL_MATERIAL__COUNT_ID

MTL_MATERIAL_TRANSACTIONS

MTL_PHYSICAL_ADJUSTMENTS

MTL_MATERIAL_AL_ADJUSTMENT_ID

MTL_MATERIAL_TRANSACTIONS

MTL_TRANSACTION_TYPES

MTL_MATERIAL_CTION_TYPE_ID

MTL_MATERIAL_TRANSACTIONS

GL_DAILY_CONVERSION_TYPES

MTL_MATERIAL_CY_CODE

MTL_MATERIAL_TRANSACTIONS

MTL_SYSTEM_ITEMS_B

MTL_MATERIAL_ORY_ITEM_ID

MTL_MATERIAL_ZATION_ID

MTL_MATERIAL_TRANSACTIONS

CST_COST_GROUPS

MTL_MATERIAL_ER_COST_GROUP_ID

MTL_MATERIAL_TRANSACTIONS

WIP_DISCRETE_JOBS

MTL_MATERIAL_CTION_SOURCE_ID

MTL_MATERIAL_TRANSACTIONS

WIP_REPETITIVE_ITEMS

MTL_MATERIAL_CTION_SOURCE_ID

MTL_MATERIAL_TIVE_LINE_ID

MTL_MATERIAL_TRANSACTIONS

MTL_ITEM_LOCATIONS

MTL_MATERIAL_R_ID

MTL_MATERIAL_ZATION_ID

MTL_MATERIAL_TRANSACTIONS

ORG_ACCT_PERIODS

MTL_MATERIAL__PERIOD_ID

MTL_MATERIAL_ZATION_ID

MTL_MATERIAL_TRANSACTIONS

GL_CODE_COMBINATIONS

MTL_MATERIAL_ORTATION_DIST_ACCOUNT

MTL_MATERIAL_TRANSACTIONS

MTL_SECONDARY_INVENTORIES

MTL_MATERIAL_ENTORY_CODE

MTL_MATERIAL_ZATION_ID

MTL_MATERIAL_TRANSACTIONS

WIP_FLOW_SCHEDULES

MTL_MATERIAL_CTION_SOURCE_ID

MTL_MATERIAL_TRANSACTIONS

RCV_TRANSACTIONS

MTL_MATERIAL__TRANSACTION_ID

MTL_MATERIAL_TRANSACTIONS

WIP_MOVE_TRANSACTIONS

MTL_MATERIAL__TRANSACTION_ID

MTL_MATERIAL_TRANSACTIONS

MTL_TXN_SOURCE_TYPES

MTL_MATERIAL_CTION_SOURCE_TYPE_ID

MTL_MATERIAL_TRANSACTIONS

MTL_TXN_REQUEST_LINES

MTL_MATERIAL__ORDER_LINE_ID

MTL_MATERIAL_TRANSACTIONS

MTL_TRANSACTION_REASONS

MTL_MATERIAL__ID

MTL_MATERIAL_TRANSACTIONS

GL_CODE_COMBINATIONS

MTL_MATERIAL_BUTION_ACCOUNT_ID

MTL_MATERIAL_TRANSACTIONS

GL_CODE_COMBINATIONS

MTL_MATERIAL_RANCE_ACCOUNT

MTL_MATERIAL_TRANSACTIONS

CST_COST_GROUPS

MTL_MATERIAL__GROUP_ID

AHL_WORKORDER_MTL_TXNS

MTL_MATERIAL_TRANSACTIONSAHL_WORKORDER_MTL_AL_TRANSACTION_ID

CST_AE_HEADERS

MTL_MATERIAL_TRANSACTIONSCST_AE_TING_EVENT_ID

CST_COMP_SNAPSHOT

MTL_MATERIAL_TRANSACTIONSCST_COMP_CTION_ID

CST_MGD_INFL_TSF_ORG_ENTRIES

MTL_MATERIAL_TRANSACTIONSCST_MGD_INFL_TSF_ORG_CTION_ID

MTL_ACTUAL_COST_SUBELEMENT

MTL_MATERIAL_TRANSACTIONSMTL_ACTUAL_COST_CTION_ID

MTL_CST_ACTUAL_COST_DETAILS

MTL_MATERIAL_TRANSACTIONSMTL_CST_ACTUAL_COST_CTION_ID

MTL_CST_TXN_COST_DETAILS

MTL_MATERIAL_TRANSACTIONSMTL_CST_TXN_COST_CTION_ID

MTL_MATERIAL_TXN_ALLOCATIONS

MTL_MATERIAL_TRANSACTIONSMTL_MATERIAL_TXN_CTION_ID

MTL_OBJECT_EVENTS

MTL_MATERIAL_TRANSACTIONSMTL_OBJECT_CTION_ID

MTL_OBJECT_GENEALOGY

MTL_MATERIAL_TRANSACTIONSMTL_OBJECT__TXN_ID

MTL_ONHAND_QUANTITIES

MTL_MATERIAL_TRANSACTIONSMTL_ONHAND__TRANSACTION_ID

MTL_ONHAND_QUANTITIES

MTL_MATERIAL_TRANSACTIONSMTL_ONHAND__TRANSACTION_ID

MTL_PAC_ACTUAL_COST_DETAILS

MTL_MATERIAL_TRANSACTIONSMTL_PAC_ACTUAL_COST_CTION_ID

MTL_PAC_COST_SUBELEMENTS

MTL_MATERIAL_TRANSACTIONSMTL_PAC_COST_CTION_ID

MTL_PAC_TXN_COST_DETAILS

MTL_MATERIAL_TRANSACTIONSMTL_PAC_TXN_COST_CTION_ID

MTL_SERIAL_NUMBERS

MTL_MATERIAL_TRANSACTIONSMTL_SERIAL__TRANSACTION_ID

MTL_TRANSACTION_ACCOUNTS

MTL_MATERIAL_TRANSACTIONSMTL_TRANSACTION_CTION_ID

MTL_TRANSACTION_LOT_NUMBERS

MTL_MATERIAL_TRANSACTIONSMTL_TRANSACTION_LOT_CTION_ID

MTL_UNIT_TRANSACTIONS

MTL_MATERIAL_TRANSACTIONSMTL_UNIT_CTION_ID

PJM_BORROW_PAYBACKS

MTL_MATERIAL_TRANSACTIONSPJM_BORROW_K_TRANSACTION_ID

PJM_BORROW_TRANSACTIONS

MTL_MATERIAL_TRANSACTIONSPJM_BORROW__TRANSACTION_ID

PO_ACCRUAL_RECONCILE_TEMP_ALL

MTL_MATERIAL_TRANSACTIONSPO_ACCRUAL_RECONCILE_TEMP__TRANSACTION_ID

PO_ACCRUAL_WRITE_OFFS_ALL

MTL_MATERIAL_TRANSACTIONSPO_ACCRUAL_WRITE_OFFS__TRANSACTION_ID

RCV_TRANSACTIONS

MTL_MATERIAL_TRANSACTIONSRCV__TRANSACTION_ID

RCV_TRANSACTIONS_INTERFACE

MTL_MATERIAL_TRANSACTIONSRCV_TRANSACTIONS__TRANSACTION_ID

WIP_SCRAP_VALUES

MTL_MATERIAL_TRANSACTIONSWIP_SCRAP_CTION_ID

WMS_DISPATCHED_TASKS_HISTORY

MTL_MATERIAL_TRANSACTIONSWMS_DISPATCHED_TASKS_CTION_ID

MTL_MATERIAL_TRANSACTIONSstoresarecordofeverymaterialtransactionorcostupdateperformedinInventory.

..

Recordsareinsertedintothistableeitheumns

TRANSACTION_TYPE_ID,TRANSACTION_ACTION_ID,TRANSACTION_SOURCE_TYPE_ID,TRANSACTION_SOURCE_IDand

TRANSACTION_SOURCE_NAMEdescribewhatthetransactionisandagainstwhatentityitwasperformed.

..

AllaccountingjournalentriesforagiventransactionarestoredinMTL_TRANSACTION_ACCOUNTS,joinedbythecolumnTRANSACTION_ID.

..

IftheitemisunderlotcontrolthenthelotrecordsarestoredinMTL_TRANSACTION_LOT_NUMBERS,joinedbythecolumnTRANSACTION_temisunder

serialcontrolthentheserialrecordsarestoredinMTL_UNIT_TRANSACTIONS,joinedbythecolumnTRANSACTION_mrevisionandlocatorcontrolare

storedinthecolumnsREVISIONandLOCATOR_IDrespectively.

..

erelatedthroughthecolumnTRANSFER_TRANSACTION_ID,whichcontainsthe

TRANSACTION_IDoftheothertransactioninthetransfer.

..

TheindexMTL_MATERIAL_TRANSACTIONS_UPGDisusedonlyduringinstallandupgrade,andwillbedroppedduringthecoursethereof,butisincludedherefor

completeness.

TablespacefortableMTL_MATERIAL_TRANSACTIONSis:APPS_TS_TX_IDX

Columns

NameDatatypeLengthMandatoryComments

TRANSACTION_IDNUMBERYesTransactionidentifier

LAST_UPDATE_DATEDATEYesStandardWhocolumn

LAST_UPDATED_BYNUMBERYesStandardWhocolumn

CREATION_DATEDATEYesStandardWhocolumn

CREATED_BYNUMBERYesStandardWhocolumn

LAST_UPDATE_LOGINNUMBERStandardWhocolumn

REQUEST_IDNUMBERStandardWhocolumn

PROGRAM_APPLICATION_IDNUMBERStandardWhocolumn

PROGRAM_IDNUMBERStandardWhocolumn

PROGRAM_UPDATE_DATEDATEStandardWhocolumn

INVENTORY_ITEM_IDNUMBERYesInventoryitemidentifier

REVISIONVARCHAR2(3)Inventoryitemrevision

ORGANIZATION_IDNUMBERYesOrganizationidentifier

SUBINVENTORY_CODEVARCHAR2(10)Transactionsecondaryinventory

LOCATOR_IDNUMBERLocatoridforstocklocators

TRANSACTION_TYPE_IDNUMBERYesTransactiontypeidentifier

TRANSACTION_ACTION_IDNUMBERYesTransactionactionidentifier

TRANSACTION_SOURCE_TYPE_IDNUMBERYesTransactionsourcetypeidentifier

TRANSACTION_SOURCE_IDNUMBERTransactionsourceidentifier

TRANSACTION_SOURCE_NAMEVARCHAR2(30)Transactionsourceidentfier

TRANSACTION_QUANTITYNUMBERYesTransactionquantity

TRANSACTION_UOMVARCHAR2(3)YesTransactionunitofmeasure

PRIMARY_QUANTITYNUMBERYesTransactionquantityintermsofprimaryuomoftheitem

TRANSACTION_DATEDATEYesTransactiondate

VARIANCE_AMOUNTNUMBERUsedforaveragecostupdatetransactions

ACCT_PERIOD_IDNUMBERAccountingperiodidentifier

TRANSACTION_REFERENCEVARCHAR2(240)Transactionreferencecode

REASON_IDNUMBERTransactionreasonidentifier

DISTRIBUTION_ACCOUNT_IDNUMBERDistributionaccountidentifier

ENCUMBRANCE_ACCOUNTNUMBEREncumbranceaccountidentifierforPOtransactions

ENCUMBRANCE_AMOUNTNUMBERTotalencumbranceamount

COST_UPDATE_IDNUMBERCostidentifier

COSTED_FLAGVARCHAR2(1)Costedflagtomarkifthetransactionsarecostedornot

TRANSACTION_GROUP_IDNUMBERTransactiongroupiIdentifierfordistributionprocessingbythecostprocessor

INVOICED_FLAGVARCHAR2(1)Invoicedflagtomarkifthetransactionsareinvoiced

ACTUAL_COSTNUMBERActualcost

TRANSACTION_COSTNUMBERThecostenteredbytheuserduringatransaction

PRIOR_COSTNUMBERItemcostbeforethetransaction

NEW_COSTNUMBERItemcostafterthetransactionprocessing

CURRENCY_CODEVARCHAR2(10)Currencyconversioncode

CURRENCY_CONVERSION_RATENUMBERCurrencyconversionrate

CURRENCY_CONVERSION_TYPEVARCHAR2(30)Currencyconversiontype

CURRENCY_CONVERSION_DATEDATECurrencyconversiondate

USSGL_TRANSACTION_CODEVARCHAR2(30)ussgltransactioncode

QUANTITY_ADJUSTEDNUMBERStandardcostquantityadjusted

EMPLOYEE_CODEVARCHAR2(10)Transactionrequestor

DEPARTMENT_IDNUMBERDepartmentidentifier

OPERATION_SEQ_NUMNUMBEROperationsequencenumberwithinarouting

MASTER_SCHEDULE_UPDATE_CODEVARCHAR2(10)Masterscheduleupdatecode

RECEIVING_DOCUMENTVARCHAR2(10)Receivingdocument

PICKING_LINE_IDNUMBERPickinglineid

TRX_SOURCE_LINE_IDNUMBERLineleveltransactionsourceid

TRX_SOURCE_DELIVERY_IDNUMBERSalesorderdeliveryidentifier

REPETITIVE_LINE_IDNUMBERRepetitivelineid

PHYSICAL_ADJUSTMENT_IDNUMBERPhysicaladjustmentidentifier

CYCLE_COUNT_IDNUMBERCyclecountidentifier

RMA_LINE_IDNUMBERRmalineidentifier

TRANSFER_TRANSACTION_IDNUMBERTransactionidoftheopposingtransfertransaction

TRANSACTION_SET_IDNUMBERTransactiongroupidentifier

RCV_TRANSACTION_IDNUMBERReceivingtransactioncrossreference

MOVE_TRANSACTION_IDNUMBERMovetransactioncrossreference

COMPLETION_TRANSACTION_IDNUMBERCompletiontransactioncrossreference

SHORTAGE_PROCESS_CODENUMBER

Flagindicatingworkflownotificationsshouldbeprovidedforthistransactionifshortage

exists

SOURCE_CODEVARCHAR2(30)User-enteredsourcecodeforoutsidetransactions

SOURCE_LINE_IDNUMBERUserenteredsourcelineidentifierforoutsidetransactions

VENDOR_LOT_NUMBERVARCHAR2(30)Supplierlotnumber

TRANSFER_ORGANIZATION_IDNUMBERTransferopposingorganizationid

TRANSFER_SUBINVENTORYVARCHAR2(10)Transfertransactionopposingsubinventory

TRANSFER_LOCATOR_IDNUMBERTransfertransactionopposinglocatorid

SHIPMENT_NUMBERVARCHAR2(30)Intransitshipmentidentifier

TRANSFER_COSTNUMBERTransfercostspecifiedforinter-orgtransfers

TRANSPORTATION_DIST_ACCOUNTNUMBERTransfertransportationdistributionaccount

TRANSPORTATION_COSTNUMBERTransfertransportationcost

TRANSFER_COST_DIST_ACCOUNTNUMBERTransactiontransfercostdistributionaccount

WAYBILL_AIRBILLVARCHAR2(20)Airbill/waybillnumber

FREIGHT_CODEVARCHAR2(30)Intransitshipmentfreightcode

NUMBER_OF_CONTAINERSNUMBERNumberofcontainers

VALUE_CHANGENUMBERTotalvaluechangeforaveragecostupdate

PERCENTAGE_CHANGENUMBERPercentageaveragecostchangeforaveragecostupdate

ATTRIBUTE_CATEGORYVARCHAR2(30)Descriptiveflexfieldstructuredefiningcolumn

ATTRIBUTE1VARCHAR2(150)Descriptiveflexfieldsegment

ATTRIBUTE2VARCHAR2(150)Descriptiveflexfieldsegment

ATTRIBUTE3VARCHAR2(150)Descriptiveflexfieldsegment

ATTRIBUTE4VARCHAR2(150)Descriptiveflexfieldsegment

ATTRIBUTE5VARCHAR2(150)Descriptiveflexfieldsegment

ATTRIBUTE6VARCHAR2(150)Descriptiveflexfieldsegment

ATTRIBUTE7VARCHAR2(150)Descriptiveflexfieldsegment

ATTRIBUTE8VARCHAR2(150)Descriptiveflexfieldsegment

ATTRIBUTE9VARCHAR2(150)Descriptiveflexfieldsegment

ATTRIBUTE10VARCHAR2(150)Descriptiveflexfieldsegment

ATTRIBUTE11VARCHAR2(150)Descriptiveflexfieldsegment

ATTRIBUTE12VARCHAR2(150)Descriptiveflexfieldsegment

ATTRIBUTE13VARCHAR2(150)Descriptiveflexfieldsegment

ATTRIBUTE14VARCHAR2(150)Descriptiveflexfieldsegment

ATTRIBUTE15VARCHAR2(150)Descriptiveflexfieldsegment

MOVEMENT_IDNUMBERMovementstatisticscrossreference

TASK_IDNUMBER(15)Taskidentifier

TO_TASK_IDNUMBER(15)"To"taskidentifier

PROJECT_IDNUMBER(15)projectidentifier

TO_PROJECT_IDNUMBER(15)"To"projectidentifier

SOURCE_PROJECT_IDNUMBERSourceprojectidentifier

PA_EXPENDITURE_ORG_IDNUMBEROracleProjectsrelatedexpenditureorganizationidentifier

SOURCE_TASK_IDNUMBERSourcetaskidentifier

EXPENDITURE_TYPEVARCHAR2(30)OracleProjectsrelatedexpendituretype

ERROR_CODEVARCHAR2(240)ErrorCode

ERROR_EXPLANATIONVARCHAR2(240)Errorexplanation

PRIOR_COSTED_QUANTITYNUMBERCostedquantitybeforethistransaction

TRANSFER_PRIOR_COSTED_QUANTITYNUMBERTransferquantitycostedbeforethistransaction

FINAL_COMPLETION_FLAGVARCHAR2(1)Indicatesifjobcostsneedtobeflushedoutforthisdiscretejobcompletion

PM_COST_COLLECTEDVARCHAR2(1)SpecifieswhethertherowhasbeeninterfacedtoOracleProjects

PM_COST_COLLECTOR_GROUP_IDNUMBERGroupidentifierusedbycostcollectortoprocessgroupofrecords.

SHIPMENT_COSTEDVARCHAR2(1)Indicatesiftheshipmenttransactionhasbeenprocessedbythecostworker

TRANSFER_PERCENTAGENUMBERPercentageofvaluetoattributetotransfercostsinanInter-Orgtransfer

MATERIAL_ACCOUNTNUMBERSpecifiesthematerialaccount

MATERIAL_OVERHEAD_ACCOUNTNUMBERSpecifiesthematerialoverheadaccount

RESOURCE_ACCOUNTNUMBERSpecifiestheresourceaccount

OUTSIDE_PROCESSING_ACCOUNTNUMBERSpecifiestheacounttobechargedforoutsideprocessing

OVERHEAD_ACCOUNTNUMBERSpecifiestheoverheadaccount

COST_GROUP_IDNUMBERCostgroupidentifier

TRANSFER_COST_GROUP_IDNUMBERTransfercostgroupidentifier

FLOW_SCHEDULEVARCHAR2(1)SpecifieswhethertheWIPtransactionisafloworascheduletypetransaction

QA_COLLECTION_IDNUMBERQualityResultsIdentifier

OVERCOMPLETION_TRANSACTION_QTYNUMBEROvercompletiontransactionquantity

OVERCOMPLETION_PRIMARY_QTYNUMBEROvercompletionPrimaryquantity

OVERCOMPLETION_TRANSACTION_IDNUMBEROvercompletiontransactionIdentifier

MVT_STAT_STATUSVARCHAR2(240)Flagtoindicatethatthetransactionisupdated/processed/new

COMMON_BOM_SEQ_IDNUMBERBOMidentifierofcommonbill

COMMON_ROUTING_SEQ_IDNUMBERRoutingidentifierofcommonrouting

ORG_COST_GROUP_IDNUMBERorganization'scostgroupid

COST_TYPE_IDNUMBERcosttypeid

PERIODIC_PRIMARY_QUANTITYNUMBER

transactionquantityconvertedtoprimaryuomofthetransferorganizationincaseof

periodiccosting

MOVE_ORDER_LINE_IDNUMBERThemoveorderlinethatthistransactionlineistiedto

TASK_GROUP_IDNUMBERTaskgroupidentifierforthistask

PICK_SLIP_NUMBERNUMBERPickSlipnumberforthetransactionline

LPN_IDNUMBERLicensePlateNumberIdentifier-usedbyWMSonly

TRANSFER_LPN_IDNUMBERTransferLicensePlateNumberIdentifier

PICK_STRATEGY_IDNUMBERWMSstrategyusedforpicking

PICK_RULE_IDNUMBERWMSruleusedforpicking

PUT_AWAY_STRATEGY_IDNUMBERWMSstrategyusedforputaway

PUT_AWAY_RULE_IDNUMBERWMSruleusedforputaway

CONTENT_LPN_IDNUMBERTransferLicensePlateNumberIdentifier-usedbyWMSonly

PICK_SLIP_DATEDATEPickSlipDate

COST_CATEGORY_IDNUMBERCostCategory

ORGANIZATION_uesarebasedonMTL_TP_TYPESlookup.

TRANSFER_ORGANIZATION_uesarebasedonMTL_TP_TYPESlookup.

OWNING_ORGANIZATION_IDNUMBEROwningorganizationidentifier

OWNING_TP_uesarebasedonMTL_TP_TYPESlookup.

XFR_OWNING_ORGANIZATION_IDNUMBERTransferowningorganizationidentifier

TRANSFER_OWNING_TP_TYPENUMBER

uesarebasedonMTL_TP_TYPES

lookup.

PLANNING_ORGANIZATION_IDNUMBERPlanningorganizationidentifier

PLANNING_TP_uesarebasedonMTL_TP_TYPESlookup.

XFR_PLANNING_ORGANIZATION_IDNUMBERTransferplanningorganizationidentifier

TRANSFER_PLANNING_TP_TYPENUMBER

uesarebasedonMTL_TP_TYPES

lookup.

SECONDARY_UOM_CODEVARCHAR2(3)Secondaryunitofmeasurethatmayhavebeenusedtodothematerialtransaction

SECONDARY_TRANSACTION_QUANTITYNUMBERSecondaryquantity

TRANSACTION_GROUP_SEQNUMBER

SHIP_TO_LOCATION_IDNUMBERLocationidentifier

RESERVATION_IDNUMBERReservationidentifier

TRANSACTION_MODENUMBERTransactionMode

TRANSACTION_BATCH_IDNUMBERBatchIDforTransactions

TRANSACTION_BATCH_SEQNUMBERBatchSequenceforTransactions

INTRANSIT_ACCOUNTNUMBER

INTRANSIT_ACCOUNTcorrespondstoINV_INTRANSIT_ACCOUNTfrom

mtl_interorg_parameters

FOB_POINTNUMBER

FOB_POINTcorrespondstoFOB_POINTbetweentwoOrganizationsin

mtl_interorg_parameters

PARENT_TRANSACTION_IDNUMBERParentTransactionIdentifier

LOGICAL_TRX_TYPE_CODENUMBERLogicalTransactionTypeIdentifier

TRX_FLOW_HEADER_IDNUMBERTransactionFlowIdentifier

LOGICAL_TRANSACTIONS_CREATEDNUMBERIdentifiesDeferredTransactions

LOGICAL_TRANSACTIONNUMBERLogicalTransactionIdentifier

INTERCOMPANY_COSTNUMBERIntercompanyCost

INTERCOMPANY_PRICING_OPTIONNUMBERIntercompanyPricingOptionIdentifier

INTERCOMPANY_CURRENCY_CODEVARCHAR2(15)

ORIGINAL_TRANSACTION_TEMP_IDNUMBERRequiredforelectronicrecordstokeeptheoriginaltransaction'stempID

QueryText

Cut,paste(andedit)thefollowingtexttoquerythisobject:

SELECTTRANSACTION_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

,SUBINVENTORY_CODE

,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

,QUANTITY_ADJUSTED

,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

_MATERIAL_TRANSACTIONS;