Powered by InfoCaptor


Previous Page   Next Page

Inventory Transactions
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneNone.PMIFG_INVENTORY_TRANSACTIONS_VUnknown
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Company CodeCompany code of the organization.Inventory Transactions.Company CodeCO_CODECO_CODE123979
Created By Inventory Transactions.Created ByCREATED_BYCREATED_BY125191
Creation Date Inventory Transactions.Creation DateCREATION_DATECREATION_DATE126618
Current Fiscal YearFiscal year defined in Inventory calendarInventory Transactions.Current Fiscal YearCURRENT_FISCAL_YEARCURRENT_FISCAL_YEAR127355
Current Period Inventory Transactions.Current PeriodCURRENT_PERIODCURRENT_PERIOD127361
Document IDNot currently used.Inventory Transactions.Document IDDOC_IDDOC_ID130380
Document LineNot currently used.Inventory Transactions.Document LineDOC_LINEDOC_LINE130388
Document TypeNot currently used.Inventory Transactions.Document TypeDOC_TYPEDOC_TYPE130399
General Ledger Posted IndicatorGL posted indicator. 0=Not posted to GL, 1=Posted to GL.Inventory Transactions.General Ledger Posted IndicatorGL_POSTED_INDGL_POSTED_IND135259
Gradegrade of the lot.Inventory Transactions.GradeQC_GRADEQC_GRADE157150
Item DescriptionShort description of the item that is displayed during the item look up.Inventory Transactions.Item DescriptionITEM_DESCRIPTIONITEM_DESCRIPTION137740
Item IDSurrogate key for the item for which results are recorded.Inventory Transactions.Item IDITEM_IDITEM_ID137778
Item NumberName of the item.Inventory Transactions.Item NumberITEM_NOITEM_NO137821
Item UOMUOM of the item by which the inventory balances are maintained.Inventory Transactions.Item UOMITEM_UOMITEM_UOM137934
Last Update Date Inventory Transactions.Last Update DateLAST_UPDATE_DATELAST_UPDATE_DATE141145
Last Updated By Inventory Transactions.Last Updated ByLAST_UPDATED_BYLAST_UPDATED_BY139771
Line IDLine IDInventory Transactions.Line IDLINE_IDLINE_ID144658
Line Type Inventory Transactions.Line TypeLINE_TYPELINE_TYPE144791
Line Type MeaningLine type.Inventory Transactions.Line Type MeaningLINE_TYPE_MEANINGLINE_TYPE_MEANING144804
LocationLocationInventory Transactions.LocationLOCATIONLOCATION145012
Lot IDSurrogate key for the lot/sublot for which results are recorded.Inventory Transactions.Lot IDLOT_IDLOT_ID145867
Lot StatusStatus of the lot.Inventory Transactions.Lot StatusLOT_STATUSLOT_STATUS145920
Operator CodeOperator who created the transaction.Inventory Transactions.Operator CodeOP_CODEOP_CODE149743
Organizations CodeOrganization code.Inventory Transactions.Organizations CodeORGN_CODEORGN_CODE150814
PeriodInventory period for which the balance is stored.Inventory Transactions.PeriodPERIOD_DESCPERIOD152926
Period End DateThe date on which an accounting period ends.Inventory Transactions.Period End DatePERIOD_END_DATEPERIOD_END_DATE153054
Period Start DateThe date on which an accounting period begins.Inventory Transactions.Period Start DatePERIOD_START_DATEPERIOD_START_DATE153259
Reason CodeReason code associated with the transaction.Inventory Transactions.Reason CodeREASON_CODEREASON_CODE157943
Secondary UOMSecondary UOM in which Transaction Quantity is expressed.Inventory Transactions.Secondary UOMTRANS_UM2TRANS_UM2165991
SourceC=from completed transactions, P=from pending transactionsInventory Transactions.SourceSOURCESOURCE162321
Training Event IDID column for Training Events.Inventory Transactions.Training Event IDEVENT_IDEVENT_ID133686
Transaction Date Inventory Transactions.Transaction DateTRANS_DATETRANSACTION_DATE165661
Transaction IDSurrogate key for the item.Inventory Transactions.Transaction IDTRANS_IDTRANS_ID165969
Transaction QuantityQuantity of the transaction in the primary UOM of an item.Inventory Transactions.Transaction QuantityTRANS_QTYTRANS_QTY165974
Transaction Quantity in Secondary UOMQuantity of the transaction in the secodary UOM of an item, if dual UOM controlled.Inventory Transactions.Transaction Quantity in Secondary UOMTRANS_QTY2TRANS_QTY2165976
Transaction StatusNot currently used.Inventory Transactions.Transaction StatusTRANS_STATTRANS_STAT165985
Transaction UOMUOM in which Transaction Quantity is expressed.Inventory Transactions.Transaction UOMTRANS_UMTRANS_UM165990
Warehouse CodeWarehouse from which the item was taken.Inventory Transactions.Warehouse CodeWHSE_CODEWHSE_CODE167774
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto