View idempiere11.adempiere.rv_transaction
Mat Transaction

 Generated by
Quality Systems & Solutions
Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
m_transaction_id numeric 10  √  null Inventory Transaction
ad_client_id numeric 10  √  null Tenant for this installation.
ad_org_id numeric 10  √  null Organizational entity within tenant
movementtype bpchar 2  √  null Method of moving the inventory
movementdate timestamp 29,6  √  null Date a product was moved in or out of inventory
movementqty numeric 0  √  null Quantity of a product moved.
m_attributesetinstance_id numeric 10  √  null Product Attribute Set Instance
m_attributeset_id numeric 10  √  null Product Attribute Set
serno varchar 40  √  null Product Serial Number
lot varchar 40  √  null Lot number (alphanumeric)
m_lot_id numeric 10  √  null Product Lot Definition
guaranteedate timestamp 29,6  √  null Date when guarantee expires
m_product_id numeric 10  √  null Product, Service, Item
value varchar 510  √  null Search key for the record in the format required - must be unique
name varchar 255  √  null Alphanumeric identifier of the entity
description varchar 255  √  null Optional short description of the record
upc varchar 30  √  null Bar Code (Universal Product Code or its superset European Article Number)
sku varchar 30  √  null Stock Keeping Unit
c_uom_id numeric 10  √  null Unit of Measure
m_product_category_id numeric 10  √  null Category of a Product
classification varchar 12  √  null Classification for grouping
weight numeric 0  √  null Weight of a product
volume numeric 0  √  null Volume of a product
versionno varchar 20  √  null Version Number
m_locator_id numeric 10  √  null Warehouse Locator
m_warehouse_id numeric 10  √  null Storage Warehouse and Service Point
x varchar 60  √  null X dimension, e.g., Aisle
y varchar 60  √  null Y dimension, e.g., Bin
z varchar 60  √  null Z dimension, e.g., Level
m_inventoryline_id numeric 10  √  null Unique line in an Inventory document
m_inventory_id numeric 10  √  null Parameters for a Physical Inventory
m_movementline_id numeric 10  √  null Inventory Move document Line
m_movement_id numeric 10  √  null Movement of Inventory
m_inoutline_id numeric 10  √  null Line on Shipment or Receipt document
m_inout_id numeric 10  √  null Material Shipment Document
m_productionline_id numeric 10  √  null Document Line representing a production
m_productionplan_id numeric 10  √  null Plan for how a product is produced
m_production_id numeric 10  √  null Plan for producing a product
c_projectissue_id numeric 10  √  null Project Issues (Material, Labor)
c_project_id numeric 10  √  null Financial Project
line numeric 10  √  null Unique line for this document
m_transaction_created timestamp 29,6  √  null m_transaction_created
m_transaction_createdby numeric 10  √  null m_transaction_createdby
m_transaction_isactive bpchar 1  √  null m_transaction_isactive
pp_cost_collector_id numeric 10  √  null Manufacturing Cost Collector
m_transaction_updated timestamp 29,6  √  null m_transaction_updated
m_transction_updatedby numeric 10  √  null m_transction_updatedby
m_locator_ad_org_id numeric 10  √  null m_locator_ad_org_id
m_locator_isactive bpchar 1  √  null m_locator_isactive
isdefault bpchar 1  √  null Default value
priorityno numeric 10  √  null Where inventory should be picked from first
m_locator_value varchar 40  √  null m_locator_value
m_product_ad_org_id numeric 10  √  null m_product_ad_org_id
m_product_copyfrom bpchar 1  √  null m_product_copyfrom
m_product_created timestamp 29,6  √  null m_product_created
m_product_createdby numeric 10  √  null m_product_createdby
c_revenuerecognition_id numeric 10  √  null Method for recording revenue
c_subscriptiontype_id numeric 10  √  null Type of subscription
c_taxcategory_id numeric 10  √  null Tax Category
descriptionurl varchar 120  √  null URL for the description
m_product_discontinued bpchar 1  √  null m_product_discontinued
m_product_discontinuedat timestamp 29,6  √  null m_product_discontinuedat
documentnote varchar 2000  √  null Additional information for a Document
group1 varchar 255  √  null Group1
group2 varchar 255  √  null Group2
guaranteedays numeric 10  √  null Number of days the product is guaranteed or available
guaranteedaysmin numeric 10  √  null Minimum number of guarantee days
help varchar 2000  √  null Comment or Hint
imageurl varchar 120  √  null URL of image
m_product_isactive bpchar 1  √  null m_product_isactive
isbom bpchar 1  √  null Bill of Materials
isdropship bpchar 1  √  null Drop Shipments are sent directly to the Drop Shipment Location
isexcludeautodelivery bpchar 1  √  null Exclude from automatic Delivery
isinvoiceprintdetails bpchar 1  √  null Print detail BOM elements on the invoice
ispicklistprintdetails bpchar 1  √  null Print detail BOM elements on the pick list
ispurchased bpchar 1  √  null Organization purchases this product
isselfservice bpchar 1  √  null This is a Self-Service entry or this entry can be changed via Self-Service
issold bpchar 1  √  null Organization sells this product
isstocked bpchar 1  √  null Organization stocks this product
m_product_issummary bpchar 1  √  null m_product_issummary
isverified bpchar 1  √  null The BOM configuration has been verified
iswebstorefeatured bpchar 1  √  null If selected, the product is displayed in the initial or any empty search
lowlevel numeric 10  √  null The Low Level is used to calculate the material plan and determines if a net requirement should be exploited
m_product_m_attributeset_id numeric 10  √  null Product Attribute Set
m_product_m_asi_id numeric 10  √  null M_Product_M_ASI_ID
m_freightcategory_id numeric 10  √  null Category of the Freight
m_product_m_locator_id numeric 10  √  null m_product_m_locator_id
m_product_processing bpchar 1  √  null m_product_processing
producttype bpchar 1  √  null Type of product
r_mailtext_id numeric 10  √  null Text templates for mailings
m_product_salesrep_id numeric 10  √  null m_product_salesrep_id
s_expensetype_id numeric 10  √  null Expense report type
shelfdepth numeric 10  √  null Shelf depth required
shelfheight numeric 0  √  null Shelf height required
shelfwidth numeric 10  √  null Shelf width required
s_resource_id numeric 10  √  null Resource
unitsperpack numeric 10  √  null The Units Per Pack indicates the no of units of a product packed together.
unitsperpallet numeric 0  √  null Units Per Pallet
m_product_updated timestamp 29,6  √  null m_product_updated
m_product_updatedby numeric 10  √  null m_product_updatedby
m_inventoryline_ad_org_id numeric 10  √  null m_inventoryline_ad_org_id
m_inventoryline_c_charge_id numeric 10  √  null m_inventoryline_c_charge_id
m_inventoryline_created timestamp 29,6  √  null m_inventoryline_created
m_inventoryline_createdby numeric 10  √  null m_inventoryline_createdby
m_inventoryline_description varchar 255  √  null m_inventoryline_description
inventorytype bpchar 1  √  null Type of inventory difference
m_inventoryline_isactive bpchar 1  √  null m_inventoryline_isactive
m_inventoryline_m_asi_id numeric 10  √  null M_InventoryLine_M_ASI_ID
m_inventoryline_m_locator_id numeric 10  √  null m_inventoryline_m_locator_id
m_inventoryline_m_product_id numeric 10  √  null m_inventoryline_m_product_id
m_inventoryline_processed bpchar 1  √  null m_inventoryline_processed
qtybook numeric 0  √  null Book Quantity
qtycount numeric 0  √  null Counted Quantity
qtycsv numeric 0  √  null Qty Csv
qtyinternaluse numeric 0  √  null Internal Use Quantity removed from Inventory
m_inventoryline_revline_id numeric 10  √  null m_inventoryline_revline_id
m_inventoryline_updated timestamp 29,6  √  null m_inventoryline_updated
m_inventoryline_updatedby numeric 10  √  null m_inventoryline_updatedby
m_movementline_ad_org_id numeric 10  √  null m_movementline_ad_org_id
m_movementline_confirmedqty numeric 0  √  null m_movementline_confirmedqty
m_movementline_created timestamp 29,6  √  null m_movementline_created
m_movementline_createdby numeric 10  √  null m_movementline_createdby
dd_orderline_id numeric 10  √  null Distribution Order Line
m_movementline_description varchar 255  √  null m_movementline_description
m_movementline_isactive bpchar 1  √  null m_movementline_isactive
m_movementline_m_asi_id numeric 10  √  null M_MovementLine_M_ASI_ID
m_attributesetinstanceto_id numeric 10  √  null Target Product Attribute Set Instance
m_movementline_m_locator_id numeric 10  √  null m_movementline_m_locator_id
m_locatorto_id numeric 10  √  null Location inventory is moved to
m_movementline_movementqty numeric 0  √  null m_movementline_movementqty
m_movementline_m_product_id numeric 10  √  null m_movementline_m_product_id
m_movementline_processed bpchar 1  √  null m_movementline_processed
m_movementline_reversalln_id numeric 10  √  null m_movementline_reversalline_id
m_movementline_scrappedqty numeric 0  √  null m_movementline_scrappedqty
m_movementline_targetqty numeric 0  √  null m_movementline_targetqty
m_movementline_updated timestamp 29,6  √  null m_movementline_updated
m_movementline_updatedby numeric 10  √  null m_movementline_updatedby
m_inoutline_ad_org_id numeric 10  √  null m_inoutline_ad_org_id
m_inoutline_ad_orgtrx_id numeric 10  √  null m_inoutline_ad_orgtrx_id
m_inoutline_c_activity_id numeric 10  √  null m_inoutline_c_activity_id
m_inoutline_c_campaign_id numeric 10  √  null m_inoutline_c_campaign_id
m_inoutline_c_charge_id numeric 10  √  null m_inoutline_c_charge_id
m_inoutline_confirmedqty numeric 0  √  null m_inoutline_confirmedqty
m_inoutline_c_orderline_id numeric 10  √  null m_inoutline_c_orderline_id
m_inoutline_c_project_id numeric 10  √  null m_inoutline_c_project_id
c_projectphase_id numeric 10  √  null Phase of a Project
c_projecttask_id numeric 10  √  null Actual Project Task in a Phase
m_inoutline_created timestamp 29,6  √  null m_inoutline_created
m_inoutline_createdby numeric 10  √  null m_inoutline_createdby
m_inoutline_c_uom_id numeric 10  √  null m_inoutline_c_uom_id
m_inoutline_description varchar 255  √  null m_inoutline_description
m_inoutline_isactive bpchar 1  √  null m_inoutline_isactive
isdescription bpchar 1  √  null if true, the line is just description and no transaction
isinvoiced bpchar 1  √  null Is this invoiced?
m_inoutline_line numeric 10  √  null m_inoutline_line
m_inoutline_m_asi_id numeric 10  √  null M_InOutLine_M_ASI_ID
m_inoutline_m_inout_id numeric 10  √  null m_inoutline_m_inout_id
m_inoutline_movementqty numeric 0  √  null m_inoutline_movementqty
m_inoutline_m_product_id numeric 10  √  null m_inoutline_m_product_id
m_inoutline_m_rmaline_id numeric 10  √  null m_inoutline_m_rmaline_id
m_inoutline_pickedqty numeric 0  √  null m_inoutline_pickedqty
m_inoutline_processed bpchar 1  √  null m_inoutline_processed
m_inoutline_qtyentered numeric 0  √  null m_inoutline_qtyentered
ref_inoutline_id numeric 10  √  null Referenced Shipment Line
m_inoutline_reversalline_id numeric 10  √  null m_inoutline_reversalline_id
m_inoutline_scrappedqty numeric 0  √  null m_inoutline_scrappedqty
m_inoutline_targetqty numeric 0  √  null m_inoutline_targetqty
m_inoutline_updated timestamp 29,6  √  null m_inoutline_updated
m_inoutline_updatedby numeric 10  √  null m_inoutline_updatedby
m_inoutline_user1_id numeric 10  √  null m_inoutline_user1_id
m_inoutline_user2_id numeric 10  √  null m_inoutline_user2_id
m_productionline_ad_org_id numeric 10  √  null m_productionline_ad_org_id
m_productionline_created timestamp 29,6  √  null m_productionline_created
m_productionline_createdby numeric 10  √  null m_productionline_createdby
m_productionline_description varchar 255  √  null m_productionline_description
m_productionline_isactive bpchar 1  √  null m_productionline_isactive
m_productionline_m_asi_id numeric 10  √  null M_ProductionLine_M_ASI_ID
m_productionline_m_locator_id numeric 10  √  null m_productionline_m_locator_id
m_productionline_movementqty numeric 0  √  null m_productionline_movementqty
m_productionline_m_product_id numeric 10  √  null m_productionline_m_product_id
m_productionl_m_productionl_id numeric 10  √  null m_productionl_m_productionl_id
m_productionline_processed bpchar 1  √  null m_productionline_processed
m_productionline_updated timestamp 29,6  √  null m_productionline_updated
m_productionline_updatedby numeric 10  √  null m_productionline_updatedby
m_productionplan_ad_org_id numeric 10  √  null m_productionplan_ad_org_id
m_productionplan_created timestamp 29,6  √  null m_productionplan_created
m_productionplan_createdby numeric 10  √  null m_productionplan_createdby
m_productionplan_description varchar 255  √  null m_productionplan_description
m_productionplan_isactive bpchar 1  √  null m_productionplan_isactive
m_productionplan_line numeric 10  √  null m_productionplan_line
m_productionplan_m_locator_id numeric 10  √  null m_productionplan_m_locator_id
m_productionplan_m_product_id numeric 10  √  null m_productionplan_m_product_id
m_productionplan_processed bpchar 1  √  null m_productionplan_processed
m_productionplan_productionqt numeric 0  √  null m_productionplan_productionqty
m_productionplan_updated timestamp 29,6  √  null m_productionplan_updated
m_productionplan_updatedby numeric 10  √  null m_productionplan_updatedby
c_prjctissue_ad_org_id numeric 10  √  null c_prjctissue_ad_org_id
c_prjctissue_c_projectissue_id numeric 10  √  null c_prjctissue_c_projectissue_id
c_prjctissue_created timestamp 29,6  √  null c_prjctissue_created
c_prjctissue_createdby numeric 10  √  null c_prjctissue_createdby
c_prjctissue_description varchar 255  √  null c_prjctissue_description
c_prjctissue_isactive bpchar 1  √  null c_prjctissue_isactive
c_prjctissue_m_asi_id numeric 10  √  null C_PrjctIssue_M_ASI_ID
c_prjctissue_m_inoutline_id numeric 10  √  null c_prjctissue_m_inoutline_id
c_prjctissue_m_locator_id numeric 10  √  null c_prjctissue_m_locator_id
c_prjctissue_movementdate timestamp 29,6  √  null c_prjctissue_movementdate
c_prjctissue_movementqty numeric 0  √  null c_prjctissue_movementqty
c_prjctissue_m_product_id numeric 10  √  null c_prjctissue_m_product_id
c_prjctissue_posted bpchar 1  √  null c_prjctissue_posted
c_prjctissue_processed bpchar 1  √  null c_prjctissue_processed
c_prjctissue_processedon numeric 0  √  null c_prjctissue_processedon
c_prjctissue_processing bpchar 1  √  null c_prjctissue_processing
c_prjctissue_s_timeexpline_id numeric 10  √  null C_PrjctIssue_S_TimeExpLine_ID
c_prjctissue_updated timestamp 29,6  √  null c_prjctissue_updated
c_prjctissue_updatedby numeric 10  √  null c_prjctissue_updatedby

Analyzed at 2024-01-03 13:44 +0100