View idempiere9.adempiere.rv_m_transaction
With Product_PO info

 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
ad_client_id numeric 10  √  null Client/Tenant for this installation.
ad_org_id numeric 10  √  null Organizational entity within client
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_product_id numeric 10  √  null Product, Service, Item
m_locator_id numeric 10  √  null Warehouse Locator
m_attributesetinstance_id numeric 10  √  null Product Attribute Set Instance
m_product_category_id numeric 10  √  null Category of a Product
value varchar 40  √  null Search key for the record in the format required - must be unique
c_bpartner_id numeric 10  √  null Identifies a Business Partner
pricepo numeric 0  √  null Price based on a purchase order
pricelastpo numeric 0  √  null Price of the last purchase order for the product
pricelist numeric 0  √  null List Price
c_projectissue_id numeric 10  √  null Project Issues (Material, Labor)
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
m_inoutline_id numeric 10  √  null Line on Shipment or Receipt document
movementtype bpchar 2  √  null Method of moving the inventory
m_productionline_id numeric 10  √  null Document Line representing a production
m_transaction_id numeric 10  √  null Inventory Transaction
pp_cost_collector_id numeric 10  √  null Manufacturing Cost Collector
m_transation_updated timestamp 29,6  √  null m_transation_updated
m_transation_updatedby numeric 10  √  null m_transation_updatedby
m_product_ad_org_id numeric 10  √  null m_product_ad_org_id
classification varchar 12  √  null Classification for grouping
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
m_product_c_uom_id numeric 10  √  null m_product_c_uom_id
m_product_description varchar 255  √  null m_product_description
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
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_name varchar 255  √  null m_product_name
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
sku varchar 30  √  null Stock Keeping Unit
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_upc varchar 30  √  null m_product_upc
m_product_updated timestamp 29,6  √  null m_product_updated
m_product_updatedby numeric 10  √  null m_product_updatedby
versionno varchar 20  √  null Version Number
volume numeric 0  √  null Volume of a product
weight numeric 0  √  null Weight of a product
m_product_po_ad_org_id numeric 10  √  null m_product_po_ad_org_id
m_product_po_c_currency_id numeric 10  √  null m_product_po_c_currency_id
costperorder numeric 0  √  null Fixed Cost Per Order
m_product_po_created timestamp 29,6  √  null m_product_po_created
m_product_po_createdby numeric 10  √  null m_product_po_createdby
m_product_po_c_uom_id numeric 10  √  null m_product_po_c_uom_id
deliverytime_actual numeric 10  √  null Actual days between order and delivery
deliverytime_promised numeric 10  √  null Promised days between order and delivery
m_product_po_discontinued bpchar 1  √  null m_product_po_discontinued
m_product_po_discontinuedat timestamp 29,6  √  null m_product_po_discontinuedat
m_product_po_isactive bpchar 1  √  null m_product_po_isactive
iscurrentvendor bpchar 1  √  null Use this Vendor for pricing and stock replenishment
manufacturer varchar 30  √  null Manufacturer of the Product
m_product_po_m_product_id numeric 10  √  null m_product_po_m_product_id
order_min numeric 0  √  null Minimum order quantity in UOM
order_pack numeric 0  √  null Package order size in UOM (e.g. order set of 5 units)
priceeffective timestamp 29,6  √  null Effective Date of Price
pricelastinv numeric 0  √  null Price of the last invoice for the product
qualityrating numeric 0  √  null Method for rating vendors
royaltyamt numeric 0  √  null (Included) Amount for copyright, etc.
m_product_po_upc varchar 20  √  null m_product_po_upc
m_product_po_updated timestamp 29,6  √  null m_product_po_updated
m_product_po_updatedby numeric 10  √  null m_product_po_updatedby
vendorcategory varchar 30  √  null Product Category of the Business Partner
vendorproductno varchar 40  √  null Product Key of the Business Partner

Analyzed at 2021-12-25 14:43 +0100