SchemaSpy Analysis of idempiere9.adempiere - ColumnsMaterial Management Generated by
Quality Systems & Solutions
Generated on 2021-12-25 14:52 +0100
Legend:
Primary key columns
Columns with indexes
 

idempiere9.adempiere contains 1093 columns - click on heading to sort:
Table Column Type Size Nulls Auto Default
c_charge ad_client_id numeric 10 Client/Tenant for this installation.
c_charge ad_org_id numeric 10 Organizational entity within client
c_charge c_bpartner_id numeric 10  √  null Identifies a Business Partner
c_charge c_charge_id numeric 10 Additional document charges
c_charge c_charge_uu varchar 36  √  NULL::character varying C_Charge_UU
c_charge c_chargetype_id numeric 10  √  null Charge Type
c_charge c_taxcategory_id numeric 10  √  null Tax Category
c_charge chargeamt numeric 0 0 Charge Amount
c_charge created timestamp 29,6 now() Date this record was created
c_charge createdby numeric 10 User who created this records
c_charge description varchar 255  √  null Optional short description of the record
c_charge isactive bpchar 1 'Y'::bpchar The record is active in the system
c_charge issamecurrency bpchar 1 'N'::bpchar Same Currency
c_charge issametax bpchar 1 'N'::bpchar Use the same tax as the main transaction
c_charge istaxincluded bpchar 1 'N'::bpchar Tax is included in the price
c_charge name varchar 60 Alphanumeric identifier of the entity
c_charge updated timestamp 29,6 now() Date this record was updated
c_charge updatedby numeric 10 User who updated this records
c_doctype ad_client_id numeric 10 Client/Tenant for this installation.
c_doctype ad_org_id numeric 10 Organizational entity within client
c_doctype ad_printformat_id numeric 10  √  null Data Print Format
c_doctype c_doctype_id numeric 10 Document type or rules
c_doctype c_doctype_uu varchar 36  √  NULL::character varying C_DocType_UU
c_doctype c_doctypedifference_id numeric 10  √  null Document type for generating in dispute Shipments
c_doctype c_doctypeinvoice_id numeric 10  √  null Document type used for invoices generated from this sales document
c_doctype c_doctypeproforma_id numeric 10  √  null Document type used for pro forma invoices generated from this sales document
c_doctype c_doctypeshipment_id numeric 10  √  null Document type used for shipments generated from this sales document
c_doctype created timestamp 29,6 now() Date this record was created
c_doctype createdby numeric 10 User who created this records
c_doctype definitesequence_id numeric 10  √  null Definite Sequence
c_doctype description varchar 255  √  null Optional short description of the record
c_doctype docbasetype bpchar 3 Logical type of document
c_doctype docnosequence_id numeric 10  √  null Document sequence determines the numbering of documents
c_doctype docsubtypeinv varchar 2  √  NULL::character varying Inventory Sub Type
c_doctype docsubtypeso bpchar 2  √  null Sales Order Sub Type
c_doctype documentcopies numeric 10 Number of copies to be printed
c_doctype documentnote varchar 2000  √  null Additional information for a Document
c_doctype gl_category_id numeric 10 General Ledger Category
c_doctype hascharges bpchar 1 'N'::bpchar Charges can be added to the document
c_doctype hasproforma bpchar 1  √  'N'::bpchar Indicates if Pro Forma Invoices can be generated from this document
c_doctype isactive bpchar 1 'Y'::bpchar The record is active in the system
c_doctype ischargeorproductmandatory bpchar 1  √  'N'::bpchar Mandatory Charge or Product
c_doctype iscreatecounter bpchar 1 'Y'::bpchar Create Counter Document
c_doctype isdefault bpchar 1 'N'::bpchar Default value
c_doctype isdefaultcounterdoc bpchar 1 'N'::bpchar The document type is the default counter document type
c_doctype isdocnocontrolled bpchar 1 'N'::bpchar The document has a document sequence
c_doctype isindexed bpchar 1 'Y'::bpchar Index the document for the internal search engine
c_doctype isintransit bpchar 1 'N'::bpchar Movement is in transit
c_doctype isnopricelistcheck bpchar 1  √  'N'::bpchar Allow Product Without Pricelist
c_doctype isoverwritedateoncomplete bpchar 1  √  'N'::bpchar Overwrite Date on Complete
c_doctype isoverwriteseqoncomplete bpchar 1  √  'N'::bpchar Overwrite Sequence on Complete
c_doctype ispickqaconfirm bpchar 1 'N'::bpchar Require Pick or QA Confirmation before processing
c_doctype ispreparesplitdocument bpchar 1 'Y'::bpchar Prepare generated split shipment/receipt document
c_doctype isshipconfirm bpchar 1 'N'::bpchar Require Ship or Receipt Confirmation before processing
c_doctype issotrx bpchar 1 'Y'::bpchar This is a Sales Transaction
c_doctype issplitwhendifference bpchar 1 'N'::bpchar Split document when there is a difference
c_doctype name varchar 60 Alphanumeric identifier of the entity
c_doctype printname varchar 60 The label text to be printed on a document or correspondence.
c_doctype updated timestamp 29,6 now() Date this record was updated
c_doctype updatedby numeric 10 User who updated this records
c_projectissue ad_client_id numeric 10 Client/Tenant for this installation.
c_projectissue ad_org_id numeric 10 Organizational entity within client
c_projectissue c_project_id numeric 10 Financial Project
c_projectissue c_projectissue_id numeric 10 Project Issues (Material, Labor)
c_projectissue c_projectissue_uu varchar 36  √  NULL::character varying C_ProjectIssue_UU
c_projectissue created timestamp 29,6 now() Date this record was created
c_projectissue createdby numeric 10 User who created this records
c_projectissue description varchar 255  √  null Optional short description of the record
c_projectissue docaction bpchar 2 'CO'::bpchar The targeted status of the document
c_projectissue docstatus varchar 2 'DR'::character varying The current status of the document
c_projectissue isactive bpchar 1 'Y'::bpchar The record is active in the system
c_projectissue isapproved bpchar 1 'N'::bpchar Indicates if this document requires approval
c_projectissue line numeric 10 Unique line for this document
c_projectissue m_attributesetinstance_id numeric 10  √  0 Product Attribute Set Instance
c_projectissue m_inoutline_id numeric 10  √  null Line on Shipment or Receipt document
c_projectissue m_locator_id numeric 10 Warehouse Locator
c_projectissue m_product_id numeric 10 Product, Service, Item
c_projectissue movementdate timestamp 29,6 Date a product was moved in or out of inventory
c_projectissue movementqty numeric 0 0 Quantity of a product moved.
c_projectissue posted bpchar 1 'N'::bpchar Posting status
c_projectissue processed bpchar 1 'N'::bpchar The document has been processed
c_projectissue processedon numeric 0  √  null The date+time (expressed in decimal format) when the document has been processed
c_projectissue processing bpchar 1  √  null Process Now
c_projectissue reversal_id numeric 10  √  null ID of document reversal
c_projectissue s_timeexpenseline_id numeric 10  √  null Time and Expense Report Line
c_projectissue updated timestamp 29,6 now() Date this record was updated
c_projectissue updatedby numeric 10 User who updated this records
c_projectissuema ad_client_id numeric 10 Client/Tenant for this installation.
c_projectissuema ad_org_id numeric 10 Organizational entity within client
c_projectissuema c_projectissue_id numeric 10 Project Issues (Material, Labor)
c_projectissuema c_projectissuema_uu varchar 36  √  NULL::character varying C_ProjectIssueMA_UU
c_projectissuema created timestamp 29,6 now() Date this record was created
c_projectissuema createdby numeric 10 User who created this records
c_projectissuema isactive bpchar 1 'Y'::bpchar The record is active in the system
c_projectissuema m_attributesetinstance_id numeric 10 Product Attribute Set Instance
c_projectissuema movementqty numeric 0 0 Quantity of a product moved.
c_projectissuema updated timestamp 29,6 now() Date this record was updated
c_projectissuema updatedby numeric 10 User who updated this records
c_uom ad_client_id numeric 10 Client/Tenant for this installation.
c_uom ad_org_id numeric 10 Organizational entity within client
c_uom c_uom_id numeric 10 Unit of Measure
c_uom c_uom_uu varchar 36  √  NULL::character varying C_UOM_UU
c_uom costingprecision numeric 10 Rounding used costing calculations
c_uom created timestamp 29,6 now() Date this record was created
c_uom createdby numeric 10 User who created this records
c_uom description varchar 255  √  null Optional short description of the record
c_uom isactive bpchar 1 'Y'::bpchar The record is active in the system
c_uom isdefault bpchar 1 'N'::bpchar Default value
c_uom name varchar 60 Alphanumeric identifier of the entity
c_uom stdprecision numeric 10 Rule for rounding calculated amounts
c_uom uomsymbol varchar 10  √  null Symbol for a Unit of Measure
c_uom uomtype varchar 2  √  NULL::character varying UOM Type
c_uom updated timestamp 29,6 now() Date this record was updated
c_uom updatedby numeric 10 User who updated this records
c_uom x12de355 varchar 4 UOM EDI X12 Code
c_uom_conversion ad_client_id numeric 10 Client/Tenant for this installation.
c_uom_conversion ad_org_id numeric 10 Organizational entity within client
c_uom_conversion c_uom_conversion_id numeric 10 Unit of Measure Conversion
c_uom_conversion c_uom_conversion_uu varchar 36  √  NULL::character varying C_UOM_Conversion_UU
c_uom_conversion c_uom_id numeric 10 Unit of Measure
c_uom_conversion c_uom_to_id numeric 10 Target or destination Unit of Measure
c_uom_conversion created timestamp 29,6 now() Date this record was created
c_uom_conversion createdby numeric 10 User who created this records
c_uom_conversion dividerate numeric 0 0 To convert Source number to Target number, the Source is divided
c_uom_conversion isactive bpchar 1 'Y'::bpchar The record is active in the system
c_uom_conversion m_product_id numeric 10  √  null Product, Service, Item
c_uom_conversion multiplyrate numeric 0 0 Rate to multiple the source by to calculate the target.
c_uom_conversion updated timestamp 29,6 now() Date this record was updated
c_uom_conversion updatedby numeric 10 User who updated this records
m_attributesetinstance ad_client_id numeric 10 Client/Tenant for this installation.
m_attributesetinstance ad_org_id numeric 10 Organizational entity within client
m_attributesetinstance created timestamp 29,6 now() Date this record was created
m_attributesetinstance createdby numeric 10 User who created this records
m_attributesetinstance description varchar 255  √  null Optional short description of the record
m_attributesetinstance guaranteedate timestamp 29,6  √  null Date when guarantee expires
m_attributesetinstance isactive bpchar 1 'Y'::bpchar The record is active in the system
m_attributesetinstance lot varchar 40  √  null Lot number (alphanumeric)
m_attributesetinstance m_attributeset_id numeric 10  √  null Product Attribute Set
m_attributesetinstance m_attributesetinstance_id numeric 10 Product Attribute Set Instance
m_attributesetinstance m_attributesetinstance_uu varchar 36  √  NULL::character varying M_AttributeSetInstance_UU
m_attributesetinstance m_lot_id numeric 10  √  null Product Lot Definition
m_attributesetinstance serno varchar 40  √  null Product Serial Number
m_attributesetinstance updated timestamp 29,6 now() Date this record was updated
m_attributesetinstance updatedby numeric 10 User who updated this records
m_inout ad_client_id numeric 10 Client/Tenant for this installation.
m_inout ad_org_id numeric 10 Organizational entity within client
m_inout ad_orgtrx_id numeric 10  √  null Performing or initiating organization
m_inout ad_user_id numeric 10  √  null User within the system - Internal or Business Partner Contact
m_inout c_activity_id numeric 10  √  null Business Activity
m_inout c_bpartner_id numeric 10 Identifies a Business Partner
m_inout c_bpartner_location_id numeric 10 Identifies the (ship to) address for this Business Partner
m_inout c_campaign_id numeric 10  √  null Marketing Campaign
m_inout c_charge_id numeric 10  √  null Additional document charges
m_inout c_doctype_id numeric 10 Document type or rules
m_inout c_invoice_id numeric 10  √  null Invoice Identifier
m_inout c_order_id numeric 10  √  null Order
m_inout c_project_id numeric 10  √  null Financial Project
m_inout chargeamt numeric 0  √  0 Charge Amount
m_inout createconfirm bpchar 1  √  null Create Confirm
m_inout created timestamp 29,6 now() Date this record was created
m_inout createdby numeric 10 User who created this records
m_inout createfrom bpchar 1  √  null Process which will generate a new document lines based on an existing document
m_inout createpackage bpchar 1  √  null Create Package
m_inout dateacct timestamp 29,6 Accounting Date
m_inout dateordered timestamp 29,6  √  null Date of Order
m_inout dateprinted timestamp 29,6  √  null Date the document was printed.
m_inout datereceived timestamp 29,6  √  null Date a product was received
m_inout deliveryrule bpchar 1 Defines the timing of Delivery
m_inout deliveryviarule bpchar 1 How the order will be delivered
m_inout description varchar 255  √  null Optional short description of the record
m_inout docaction bpchar 2 The targeted status of the document
m_inout docstatus bpchar 2 The current status of the document
m_inout documentno varchar 30 Document sequence number of the document
m_inout dropship_bpartner_id numeric 10  √  null Business Partner to ship to
m_inout dropship_location_id numeric 10  √  null Business Partner Location for shipping to
m_inout dropship_user_id numeric 10  √  null Business Partner Contact for drop shipment
m_inout fob varchar 10  √  NULL::character varying Freight Terms
m_inout freightamt numeric 0  √  0 Freight Amount
m_inout freightcharges varchar 10  √  NULL::character varying Freight Charges
m_inout freightcostrule bpchar 1 Method for charging Freight
m_inout generateto bpchar 1  √  null Generate To
m_inout insurance bpchar 1  √  NULL::bpchar Insurance
m_inout isactive bpchar 1 'Y'::bpchar The record is active in the system
m_inout isalternatereturnaddress bpchar 1 'N'::bpchar Alternate Return Address
m_inout isapproved bpchar 1 'N'::bpchar Indicates if this document requires approval
m_inout isdropship bpchar 1  √  'N'::bpchar Drop Shipments are sent directly to the Drop Shipment Location
m_inout isindispute bpchar 1 'N'::bpchar Document is in dispute
m_inout isintransit bpchar 1 'N'::bpchar Movement is in transit
m_inout isprinted bpchar 1 'N'::bpchar Indicates if this document / line is printed
m_inout issotrx bpchar 1 'Y'::bpchar This is a Sales Transaction
m_inout m_inout_id numeric 10 Material Shipment Document
m_inout m_inout_uu varchar 36  √  NULL::character varying M_InOut_UU
m_inout m_rma_id numeric 10  √  null Return Material Authorization
m_inout m_shipper_id numeric 10  √  null Method or manner of product delivery
m_inout m_warehouse_id numeric 10 Storage Warehouse and Service Point
m_inout movementdate timestamp 29,6 Date a product was moved in or out of inventory
m_inout movementtype bpchar 2 Method of moving the inventory
m_inout nopackages numeric 10  √  (1)::numeric Number of packages shipped
m_inout pickdate timestamp 29,6  √  null Date/Time when picked for Shipment
m_inout poreference varchar 20  √  null Transaction Reference Number (Sales Order, Purchase Order) of your Business Partner
m_inout posted bpchar 1 'N'::bpchar Posting status
m_inout priorityrule bpchar 1 Priority of a document
m_inout processed bpchar 1 'N'::bpchar The document has been processed
m_inout processedon numeric 0  √  null The date+time (expressed in decimal format) when the document has been processed
m_inout processing bpchar 1  √  null Process Now
m_inout ref_inout_id numeric 10  √  null Referenced Shipment
m_inout returnbpartner_id numeric 10  √  NULL::numeric Return Partner
m_inout returnlocation_id numeric 10  √  NULL::numeric Return Location
m_inout returnuser_id numeric 10  √  NULL::numeric Return User/Contact
m_inout reversal_id numeric 10  √  null ID of document reversal
m_inout salesrep_id numeric 10  √  null Sales Representative or Company Agent
m_inout sendemail bpchar 1 'N'::bpchar Enable sending Document EMail
m_inout shipdate timestamp 29,6  √  null Shipment Date/Time
m_inout shipperaccount varchar 40  √  NULL::character varying Shipper Account Number
m_inout trackingno varchar 60  √  null Number to track the shipment
m_inout updated timestamp 29,6 now() Date this record was updated
m_inout updatedby numeric 10 User who updated this records
m_inout user1_id numeric 10  √  null User defined list element #1
m_inout user2_id numeric 10  √  null User defined list element #2
m_inout volume numeric 0  √  null Volume of a product
m_inout weight numeric 0  √  null Weight of a product
m_inoutline ad_client_id numeric 10 Client/Tenant for this installation.
m_inoutline ad_org_id numeric 10 Organizational entity within client
m_inoutline ad_orgtrx_id numeric 10  √  null Performing or initiating organization
m_inoutline c_activity_id numeric 10  √  null Business Activity
m_inoutline c_campaign_id numeric 10  √  null Marketing Campaign
m_inoutline c_charge_id numeric 10  √  null Additional document charges
m_inoutline c_orderline_id numeric 10  √  null Sales Order Line
m_inoutline c_project_id numeric 10  √  null Financial Project
m_inoutline c_projectphase_id numeric 10  √  null Phase of a Project
m_inoutline c_projecttask_id numeric 10  √  null Actual Project Task in a Phase
m_inoutline c_uom_id numeric 10 Unit of Measure
m_inoutline confirmedqty numeric 0  √  0 Confirmation of a received quantity
m_inoutline created timestamp 29,6 now() Date this record was created
m_inoutline createdby numeric 10 User who created this records
m_inoutline description varchar 255  √  null Optional short description of the record
m_inoutline isactive bpchar 1 'Y'::bpchar The record is active in the system
m_inoutline isautoproduce bpchar 1  √  'N'::bpchar Auto create production to fulfill shipment
m_inoutline isdescription bpchar 1 'N'::bpchar if true, the line is just description and no transaction
m_inoutline isinvoiced bpchar 1 'N'::bpchar Is this invoiced?
m_inoutline line numeric 10 Unique line for this document
m_inoutline m_attributesetinstance_id numeric 10  √  0 Product Attribute Set Instance
m_inoutline m_inout_id numeric 10 Material Shipment Document
m_inoutline m_inoutline_id numeric 10 Line on Shipment or Receipt document
m_inoutline m_inoutline_uu varchar 36  √  NULL::character varying M_InOutLine_UU
m_inoutline m_locator_id numeric 10  √  null Warehouse Locator
m_inoutline m_product_id numeric 10  √  null Product, Service, Item
m_inoutline m_rmaline_id numeric 10  √  null Return Material Authorization Line
m_inoutline movementqty numeric 0 0 Quantity of a product moved.
m_inoutline pickedqty numeric 0  √  0 Picked Quantity
m_inoutline processed bpchar 1 'N'::bpchar The document has been processed
m_inoutline qtyentered numeric 0 The Quantity Entered is based on the selected UoM
m_inoutline qtyoverreceipt numeric 0  √  0 Over Receipt Quantity
m_inoutline ref_inoutline_id numeric 10  √  null Referenced Shipment Line
m_inoutline reversalline_id numeric 10  √  null Use to keep the reversal line ID for reversing costing purpose
m_inoutline scrappedqty numeric 0  √  0 The Quantity scrapped due to QA issues
m_inoutline targetqty numeric 0  √  0 Target Movement Quantity
m_inoutline updated timestamp 29,6 now() Date this record was updated
m_inoutline updatedby numeric 10 User who updated this records
m_inoutline user1_id numeric 10  √  null User defined list element #1
m_inoutline user2_id numeric 10  √  null User defined list element #2
m_inoutlinema ad_client_id numeric 10 Client/Tenant for this installation.
m_inoutlinema ad_org_id numeric 10 Organizational entity within client
m_inoutlinema created timestamp 29,6 now() Date this record was created
m_inoutlinema createdby numeric 10 User who created this records
m_inoutlinema datematerialpolicy timestamp 29,6 Time used for LIFO and FIFO Material Policy
m_inoutlinema isactive bpchar 1 'Y'::bpchar The record is active in the system
m_inoutlinema isautogenerated bpchar 1  √  'N'::bpchar Auto Generated
m_inoutlinema m_attributesetinstance_id numeric 10 Product Attribute Set Instance
m_inoutlinema m_inoutline_id numeric 10 Line on Shipment or Receipt document
m_inoutlinema m_inoutlinema_uu varchar 36  √  NULL::character varying M_InOutLineMA_UU
m_inoutlinema movementqty numeric 0 (1)::numeric Quantity of a product moved.
m_inoutlinema updated timestamp 29,6 now() Date this record was updated
m_inoutlinema updatedby numeric 10 User who updated this records
m_inoutlinema_returned ad_client_id numeric 10  √  null
m_inoutlinema_returned ad_org_id numeric 10  √  null
m_inoutlinema_returned created timestamp 29,6  √  null
m_inoutlinema_returned createdby numeric 10  √  null
m_inoutlinema_returned datematerialpolicy timestamp 29,6  √  null
m_inoutlinema_returned isactive bpchar 1  √  null
m_inoutlinema_returned isautogenerated bpchar 1  √  null
m_inoutlinema_returned m_attributesetinstance_id numeric 10  √  null
m_inoutlinema_returned m_inoutline_id numeric 10  √  null
m_inoutlinema_returned m_inoutlinema_uu varchar 36  √  null
m_inoutlinema_returned movementqty numeric 0  √  null
m_inoutlinema_returned returnedqty numeric 0  √  null
m_inoutlinema_returned updated timestamp 29,6  √  null
m_inoutlinema_returned updatedby numeric 10  √  null
m_inventory ad_client_id numeric 10 Client/Tenant for this installation.
m_inventory ad_org_id numeric 10 Organizational entity within client
m_inventory ad_orgtrx_id numeric 10  √  null Performing or initiating organization
m_inventory approvalamt numeric 0  √  null Document Approval Amount
m_inventory c_activity_id numeric 10  √  null Business Activity
m_inventory c_campaign_id numeric 10  √  null Marketing Campaign
m_inventory c_conversiontype_id numeric 10  √  NULL::numeric Currency Conversion Rate Type
m_inventory c_currency_id numeric 10  √  NULL::numeric The Currency for this record
m_inventory c_doctype_id numeric 10 Document type or rules
m_inventory c_project_id numeric 10  √  null Financial Project
m_inventory costingmethod bpchar 1  √  NULL::bpchar Indicates how Costs will be calculated
m_inventory created timestamp 29,6 now() Date this record was created
m_inventory createdby numeric 10 User who created this records
m_inventory description varchar 255  √  null Optional short description of the record
m_inventory docaction bpchar 2 The targeted status of the document
m_inventory docstatus bpchar 2 The current status of the document
m_inventory documentno varchar 30 Document sequence number of the document
m_inventory generatelist bpchar 1  √  'Y'::bpchar Generate List
m_inventory isactive bpchar 1 'Y'::bpchar The record is active in the system
m_inventory isapproved bpchar 1 'N'::bpchar Indicates if this document requires approval
m_inventory m_inventory_id numeric 10 Parameters for a Physical Inventory
m_inventory m_inventory_uu varchar 36  √  NULL::character varying M_Inventory_UU
m_inventory m_perpetualinv_id numeric 10  √  null Rules for generating physical inventory
m_inventory m_warehouse_id numeric 10  √  null Storage Warehouse and Service Point
m_inventory movementdate timestamp 29,6 Date a product was moved in or out of inventory
m_inventory posted bpchar 1 'N'::bpchar Posting status
m_inventory processed bpchar 1 'N'::bpchar The document has been processed
m_inventory processedon numeric 0  √  null The date+time (expressed in decimal format) when the document has been processed
m_inventory processing bpchar 1  √  null Process Now
m_inventory reversal_id numeric 10  √  null ID of document reversal
m_inventory updated timestamp 29,6 now() Date this record was updated
m_inventory updatedby numeric 10 User who updated this records
m_inventory updateqty bpchar 1  √  'N'::bpchar Update Quantities
m_inventory user1_id numeric 10  √  null User defined list element #1
m_inventory user2_id numeric 10  √  null User defined list element #2
m_inventoryline ad_client_id numeric 10 Client/Tenant for this installation.
m_inventoryline ad_org_id numeric 10 Organizational entity within client
m_inventoryline c_charge_id numeric 10  √  null Additional document charges
m_inventoryline created timestamp 29,6 now() Date this record was created
m_inventoryline createdby numeric 10 User who created this records
m_inventoryline currentcostprice numeric 0  √  (0)::numeric The currently used cost price
m_inventoryline description varchar 255  √  null Optional short description of the record
m_inventoryline inventorytype bpchar 1 'D'::bpchar Type of inventory difference
m_inventoryline isactive bpchar 1 'Y'::bpchar The record is active in the system
m_inventoryline line numeric 10  √  null Unique line for this document
m_inventoryline m_attributesetinstance_id numeric 10  √  0 Product Attribute Set Instance
m_inventoryline m_inventory_id numeric 10 Parameters for a Physical Inventory
m_inventoryline m_inventoryline_id numeric 10 Unique line in an Inventory document
m_inventoryline m_inventoryline_uu varchar 36  √  NULL::character varying M_InventoryLine_UU
m_inventoryline m_locator_id numeric 10  √  null Warehouse Locator
m_inventoryline m_product_id numeric 10 Product, Service, Item
m_inventoryline newcostprice numeric 0  √  (0)::numeric New current cost price after processing of M_CostDetail
m_inventoryline processed bpchar 1 'N'::bpchar The document has been processed
m_inventoryline qtybook numeric 0 0 Book Quantity
m_inventoryline qtycount numeric 0 0 Counted Quantity
m_inventoryline qtycsv numeric 0 0 QtyCsv
m_inventoryline qtyinternaluse numeric 0  √  null Internal Use Quantity removed from Inventory
m_inventoryline reversalline_id numeric 10  √  null Use to keep the reversal line ID for reversing costing purpose
m_inventoryline updated timestamp 29,6 now() Date this record was updated
m_inventoryline updatedby numeric 10 User who updated this records
m_inventorylinema ad_client_id numeric 10 Client/Tenant for this installation.
m_inventorylinema ad_org_id numeric 10 Organizational entity within client
m_inventorylinema created timestamp 29,6 now() Date this record was created
m_inventorylinema createdby numeric 10 User who created this records
m_inventorylinema datematerialpolicy timestamp 29,6 Time used for LIFO and FIFO Material Policy
m_inventorylinema isactive bpchar 1 'Y'::bpchar The record is active in the system
m_inventorylinema isautogenerated bpchar 1  √  'N'::bpchar Auto Generated
m_inventorylinema m_attributesetinstance_id numeric 10 Product Attribute Set Instance
m_inventorylinema m_inventoryline_id numeric 10 Unique line in an Inventory document
m_inventorylinema m_inventorylinema_uu varchar 36  √  NULL::character varying M_InventoryLineMA_UU
m_inventorylinema movementqty numeric 0 (1)::numeric Quantity of a product moved.
m_inventorylinema updated timestamp 29,6 now() Date this record was updated
m_inventorylinema updatedby numeric 10 User who updated this records
m_locator ad_client_id numeric 10 Client/Tenant for this installation.
m_locator ad_org_id numeric 10 Organizational entity within client
m_locator created timestamp 29,6 now() Date this record was created
m_locator createdby numeric 10 User who created this records
m_locator isactive bpchar 1 'Y'::bpchar The record is active in the system
m_locator isdefault bpchar 1 'N'::bpchar Default value
m_locator m_locator_id numeric 10 Warehouse Locator
m_locator m_locator_uu varchar 36  √  NULL::character varying M_Locator_UU
m_locator m_locatortype_id numeric 10  √  NULL::numeric Locator Type
m_locator m_warehouse_id numeric 10 Storage Warehouse and Service Point
m_locator priorityno numeric 10 Where inventory should be picked from first
m_locator updated timestamp 29,6 now() Date this record was updated
m_locator updatedby numeric 10 User who updated this records
m_locator value varchar 40 Search key for the record in the format required - must be unique
m_locator x varchar 60  √  null X dimension, e.g., Aisle
m_locator y varchar 60  √  null Y dimension, e.g., Bin
m_locator z varchar 60  √  null Z dimension, e.g., Level
m_locatortype ad_client_id numeric 10 Client/Tenant for this installation.
m_locatortype ad_org_id numeric 10 Organizational entity within client
m_locatortype created timestamp 29,6 statement_timestamp() Date this record was created
m_locatortype createdby numeric 10 User who created this records
m_locatortype description varchar 255  √  NULL::character varying Optional short description of the record
m_locatortype help varchar 2000  √  NULL::character varying Comment or Hint
m_locatortype isactive bpchar 1 'Y'::bpchar The record is active in the system
m_locatortype isavailableforreplenishment bpchar 1 'Y'::bpchar Available for Replenishment
m_locatortype isavailableforreservation bpchar 1 'Y'::bpchar Available for Reservation
m_locatortype isavailableforshipping bpchar 1 'Y'::bpchar Available for Shipping
m_locatortype m_locatortype_id numeric 10 Locator Type
m_locatortype m_locatortype_uu varchar 36  √  NULL::character varying M_LocatorType_UU
m_locatortype name varchar 60 Alphanumeric identifier of the entity
m_locatortype updated timestamp 29,6 statement_timestamp() Date this record was updated
m_locatortype updatedby numeric 10 User who updated this records
m_movement ad_client_id numeric 10 Client/Tenant for this installation.
m_movement ad_org_id numeric 10 Organizational entity within client
m_movement ad_orgtrx_id numeric 10  √  null Performing or initiating organization
m_movement ad_user_id numeric 10  √  null User within the system - Internal or Business Partner Contact
m_movement approvalamt numeric 0  √  null Document Approval Amount
m_movement c_activity_id numeric 10  √  null Business Activity
m_movement c_bpartner_id numeric 10  √  null Identifies a Business Partner
m_movement c_bpartner_location_id numeric 10  √  null Identifies the (ship to) address for this Business Partner
m_movement c_campaign_id numeric 10  √  null Marketing Campaign
m_movement c_charge_id numeric 10  √  null Additional document charges
m_movement c_doctype_id numeric 10 Document type or rules
m_movement c_project_id numeric 10  √  null Financial Project
m_movement chargeamt numeric 0  √  null Charge Amount
m_movement created timestamp 29,6 now() Date this record was created
m_movement createdby numeric 10 User who created this records
m_movement createfrom bpchar 1  √  null Process which will generate a new document lines based on an existing document
m_movement datereceived timestamp 29,6  √  null Date a product was received
m_movement dd_order_id numeric 10  √  null Distribution Order
m_movement deliveryrule bpchar 1  √  null Defines the timing of Delivery
m_movement deliveryviarule bpchar 1  √  null How the order will be delivered
m_movement description varchar 255  √  null Optional short description of the record
m_movement docaction bpchar 2 The targeted status of the document
m_movement docstatus bpchar 2 The current status of the document
m_movement documentno varchar 30 Document sequence number of the document
m_movement freightamt numeric 0  √  null Freight Amount
m_movement freightcostrule bpchar 1  √  null Method for charging Freight
m_movement isactive bpchar 1 'Y'::bpchar The record is active in the system
m_movement isapproved bpchar 1 'N'::bpchar Indicates if this document requires approval
m_movement isintransit bpchar 1 'N'::bpchar Movement is in transit
m_movement m_movement_id numeric 10 Movement of Inventory
m_movement m_movement_uu varchar 36  √  NULL::character varying M_Movement_UU
m_movement m_shipper_id numeric 10  √  null Method or manner of product delivery
m_movement m_warehouse_id numeric 10  √  NULL::numeric Storage Warehouse and Service Point
m_movement m_warehouseto_id numeric 10  √  NULL::numeric To Storage Warehouse and Service Point
m_movement movementdate timestamp 29,6 Date a product was moved in or out of inventory
m_movement poreference varchar 20  √  null Transaction Reference Number (Sales Order, Purchase Order) of your Business Partner
m_movement posted bpchar 1 'N'::bpchar Posting status
m_movement priorityrule bpchar 1  √  null Priority of a document
m_movement processed bpchar 1 'N'::bpchar The document has been processed
m_movement processedon numeric 0  √  null The date+time (expressed in decimal format) when the document has been processed
m_movement processing bpchar 1  √  null Process Now
m_movement reversal_id numeric 10  √  null ID of document reversal
m_movement salesrep_id numeric 10  √  null Sales Representative or Company Agent
m_movement updated timestamp 29,6 now() Date this record was updated
m_movement updatedby numeric 10 User who updated this records
m_movement user1_id numeric 10  √  null User defined list element #1
m_movement user2_id numeric 10  √  null User defined list element #2
m_movementline ad_client_id numeric 10 Client/Tenant for this installation.
m_movementline ad_org_id numeric 10 Organizational entity within client
m_movementline confirmedqty numeric 0  √  0 Confirmation of a received quantity
m_movementline created timestamp 29,6 now() Date this record was created
m_movementline createdby numeric 10 User who created this records
m_movementline dd_orderline_id numeric 10  √  null Distribution Order Line
m_movementline description varchar 255  √  null Optional short description of the record
m_movementline isactive bpchar 1 'Y'::bpchar The record is active in the system
m_movementline line numeric 10  √  null Unique line for this document
m_movementline m_attributesetinstance_id numeric 10  √  null Product Attribute Set Instance
m_movementline m_attributesetinstanceto_id numeric 10  √  null Target Product Attribute Set Instance
m_movementline m_locator_id numeric 10 Warehouse Locator
m_movementline m_locatorto_id numeric 10 Location inventory is moved to
m_movementline m_movement_id numeric 10 Movement of Inventory
m_movementline m_movementline_id numeric 10 Inventory Move document Line
m_movementline m_movementline_uu varchar 36  √  NULL::character varying M_MovementLine_UU
m_movementline m_product_id numeric 10 Product, Service, Item
m_movementline movementqty numeric 0 0 Quantity of a product moved.
m_movementline processed bpchar 1 'N'::bpchar The document has been processed
m_movementline reversalline_id numeric 10  √  null Use to keep the reversal line ID for reversing costing purpose
m_movementline scrappedqty numeric 0  √  0 The Quantity scrapped due to QA issues
m_movementline targetqty numeric 0  √  0 Target Movement Quantity
m_movementline updated timestamp 29,6 now() Date this record was updated
m_movementline updatedby numeric 10 User who updated this records
m_movementlinema ad_client_id numeric 10 Client/Tenant for this installation.
m_movementlinema ad_org_id numeric 10 Organizational entity within client
m_movementlinema created timestamp 29,6 now() Date this record was created
m_movementlinema createdby numeric 10 User who created this records
m_movementlinema datematerialpolicy timestamp 29,6 Time used for LIFO and FIFO Material Policy
m_movementlinema isactive bpchar 1 'Y'::bpchar The record is active in the system
m_movementlinema isautogenerated bpchar 1  √  'N'::bpchar Auto Generated
m_movementlinema m_attributesetinstance_id numeric 10 Product Attribute Set Instance
m_movementlinema m_movementline_id numeric 10 Inventory Move document Line
m_movementlinema m_movementlinema_uu varchar 36  √  NULL::character varying M_MovementLineMA_UU
m_movementlinema movementqty numeric 0  √  (1)::numeric Quantity of a product moved.
m_movementlinema updated timestamp 29,6 now() Date this record was updated
m_movementlinema updatedby numeric 10 User who updated this records
m_parttype ad_client_id numeric 10 Client/Tenant for this installation.
m_parttype ad_org_id numeric 10 Organizational entity within client
m_parttype created timestamp 29,6 statement_timestamp() Date this record was created
m_parttype createdby numeric 10 User who created this records
m_parttype description varchar 255  √  NULL::character varying Optional short description of the record
m_parttype isactive bpchar 1 'Y'::bpchar The record is active in the system
m_parttype m_parttype_id numeric 10 Part Type
m_parttype m_parttype_uu varchar 36  √  NULL::character varying M_PartType_UU
m_parttype name varchar 255 Alphanumeric identifier of the entity
m_parttype updated timestamp 29,6 statement_timestamp() Date this record was updated
m_parttype updatedby numeric 10 User who updated this records
m_perpetualinv ad_client_id numeric 10 Client/Tenant for this installation.
m_perpetualinv ad_org_id numeric 10 Organizational entity within client
m_perpetualinv counthighmovement bpchar 1 'N'::bpchar Count High Movement products
m_perpetualinv created timestamp 29,6 now() Date this record was created
m_perpetualinv createdby numeric 10 User who created this records
m_perpetualinv datelastrun timestamp 29,6  √  null Date the process was last run.
m_perpetualinv datenextrun timestamp 29,6 Date the process will run next
m_perpetualinv description varchar 255  √  null Optional short description of the record
m_perpetualinv isactive bpchar 1 'Y'::bpchar The record is active in the system
m_perpetualinv m_perpetualinv_id numeric 10 Rules for generating physical inventory
m_perpetualinv m_perpetualinv_uu varchar 36  √  NULL::character varying M_PerpetualInv_UU
m_perpetualinv m_product_category_id numeric 10  √  null Category of a Product
m_perpetualinv m_warehouse_id numeric 10  √  null Storage Warehouse and Service Point
m_perpetualinv name varchar 60 Alphanumeric identifier of the entity
m_perpetualinv noinventorycount numeric 10 Frequency of inventory counts per year
m_perpetualinv noproductcount numeric 10 Frequency of product counts per year
m_perpetualinv numberofruns numeric 10 Frequency of processing Perpetual Inventory
m_perpetualinv processing bpchar 1  √  null Process Now
m_perpetualinv updated timestamp 29,6 now() Date this record was updated
m_perpetualinv updatedby numeric 10 User who updated this records
m_pricelist ad_client_id numeric 10 Client/Tenant for this installation.
m_pricelist ad_org_id numeric 10 Organizational entity within client
m_pricelist basepricelist_id numeric 10  √  null Pricelist to be used, if product not found on this pricelist
m_pricelist c_currency_id numeric 10 The Currency for this record
m_pricelist created timestamp 29,6 now() Date this record was created
m_pricelist createdby numeric 10 User who created this records
m_pricelist description varchar 255  √  null Optional short description of the record
m_pricelist enforcepricelimit bpchar 1 'N'::bpchar Do not allow prices below the limit price
m_pricelist isactive bpchar 1 'Y'::bpchar The record is active in the system
m_pricelist isdefault bpchar 1 'N'::bpchar Default value
m_pricelist ismandatory bpchar 1  √  'N'::bpchar Data entry is required in this column
m_pricelist ispresentforproduct bpchar 1  √  'N'::bpchar isPresentForProduct
m_pricelist issopricelist bpchar 1 'Y'::bpchar This is a Sales Price List
m_pricelist istaxincluded bpchar 1 'N'::bpchar Tax is included in the price
m_pricelist m_pricelist_id numeric 10 Unique identifier of a Price List
m_pricelist m_pricelist_uu varchar 36  √  NULL::character varying M_PriceList_UU
m_pricelist name varchar 60 Alphanumeric identifier of the entity
m_pricelist priceprecision numeric 10 2 Precision (number of decimals) for the Price
m_pricelist updated timestamp 29,6 now() Date this record was updated
m_pricelist updatedby numeric 10 User who updated this records
m_pricelist_version ad_client_id numeric 10 Client/Tenant for this installation.
m_pricelist_version ad_org_id numeric 10 Organizational entity within client
m_pricelist_version created timestamp 29,6 now() Date this record was created
m_pricelist_version createdby numeric 10 User who created this records
m_pricelist_version description varchar 255  √  null Optional short description of the record
m_pricelist_version isactive bpchar 1 'Y'::bpchar The record is active in the system
m_pricelist_version m_discountschema_id numeric 10 Schema to calculate the trade discount percentage
m_pricelist_version m_pricelist_id numeric 10 Unique identifier of a Price List
m_pricelist_version m_pricelist_version_base_id numeric 10  √  null Source for Price list calculations
m_pricelist_version m_pricelist_version_id numeric 10 Identifies a unique instance of a Price List
m_pricelist_version m_pricelist_version_uu varchar 36  √  NULL::character varying M_PriceList_Version_UU
m_pricelist_version name varchar 60 Alphanumeric identifier of the entity
m_pricelist_version proccreate bpchar 1  √  null Create
m_pricelist_version updated timestamp 29,6 now() Date this record was updated
m_pricelist_version updatedby numeric 10 User who updated this records
m_pricelist_version validfrom timestamp 29,6 Valid from including this date (first day)
m_product ad_client_id numeric 10 Client/Tenant for this installation.
m_product ad_org_id numeric 10 Organizational entity within client
m_product c_revenuerecognition_id numeric 10  √  null Method for recording revenue
m_product c_subscriptiontype_id numeric 10  √  null Type of subscription
m_product c_taxcategory_id numeric 10 Tax Category
m_product c_uom_id numeric 10 Unit of Measure
m_product classification varchar 12  √  null Classification for grouping
m_product copyfrom bpchar 1  √  NULL::bpchar Copy From Record
m_product created timestamp 29,6 now() Date this record was created
m_product createdby numeric 10 User who created this records
m_product customstariffnumber varchar 20  √  null Customs Tariff Number, usually the HS-Code
m_product description varchar 255  √  null Optional short description of the record
m_product descriptionurl varchar 120  √  null URL for the description
m_product discontinued bpchar 1  √  'N'::bpchar This product is no longer available
m_product discontinuedat timestamp 29,6  √  null Discontinued At indicates Date when product was discontinued
m_product discontinuedby timestamp 29,6  √  null
m_product documentnote varchar 2000  √  null Additional information for a Document
m_product downloadurl varchar 120  √  null
m_product group1 varchar 255  √  null Group1
m_product group2 varchar 255  √  null Group2
m_product guaranteedays numeric 10  √  null Number of days the product is guaranteed or available
m_product guaranteedaysmin numeric 10  √  null Minimum number of guarantee days
m_product help varchar 2000  √  null Comment or Hint
m_product imageurl varchar 120  √  null URL of image
m_product isactive bpchar 1 'Y'::bpchar The record is active in the system
m_product isautoproduce bpchar 1 'N'::bpchar Auto create production to fulfill shipment
m_product isbom bpchar 1 'N'::bpchar Bill of Materials
m_product isdropship bpchar 1 'N'::bpchar Drop Shipments are sent directly to the Drop Shipment Location
m_product isexcludeautodelivery bpchar 1 'N'::bpchar Exclude from automatic Delivery
m_product isinvoiceprintdetails bpchar 1 'N'::bpchar Print detail BOM elements on the invoice
m_product iskanban bpchar 1 'N'::bpchar This part is Kanban controlled
m_product ismanufactured bpchar 1 'N'::bpchar This product is manufactured
m_product isownbox bpchar 1 'N'::bpchar Own Box
m_product isphantom bpchar 1  √  'N'::bpchar Phantom Component
m_product ispicklistprintdetails bpchar 1 'N'::bpchar Print detail BOM elements on the pick list
m_product ispurchased bpchar 1 'Y'::bpchar Organization purchases this product
m_product isselfservice bpchar 1 'Y'::bpchar This is a Self-Service entry or this entry can be changed via Self-Service
m_product issold bpchar 1 'Y'::bpchar Organization sells this product
m_product isstocked bpchar 1 'Y'::bpchar Organization stocks this product
m_product issummary bpchar 1 'N'::bpchar This is a summary entity
m_product istoformule bpchar 1  √  null
m_product isverified bpchar 1 'N'::bpchar The BOM configuration has been verified
m_product iswebstorefeatured bpchar 1 'N'::bpchar If selected, the product is displayed in the initial or any empty search
m_product lowlevel numeric 10 (0)::numeric 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_attributesetinstance_id numeric 10  √  0 Product Attribute Set Instance
m_product m_freightcategory_id numeric 10  √  null Category of the Freight
m_product m_locator_id numeric 10  √  null Warehouse Locator
m_product m_parttype_id numeric 10  √  NULL::numeric Part Type
m_product m_product_category_id numeric 10 Category of a Product
m_product m_product_id numeric 10 Product, Service, Item
m_product m_product_uu varchar 36  √  NULL::character varying M_Product_UU
m_product name varchar 255 Alphanumeric identifier of the entity
m_product processing bpchar 1  √  null Process Now
m_product producttype bpchar 1 'I'::bpchar Type of product
m_product r_mailtext_id numeric 10  √  null Text templates for mailings
m_product s_expensetype_id numeric 10  √  null Expense report type
m_product s_resource_id numeric 10  √  null Resource
m_product salesrep_id numeric 10  √  null Sales Representative or Company Agent
m_product shelfdepth numeric 10  √  null Shelf depth required
m_product shelfheight numeric 0  √  null Shelf height required
m_product shelfwidth numeric 10  √  null Shelf width required
m_product sku varchar 30  √  null Stock Keeping Unit
m_product unitsperpack numeric 10 1 The Units Per Pack indicates the no of units of a product packed together.
m_product unitsperpallet numeric 0  √  null Units Per Pallet
m_product upc varchar 30  √  null Bar Code (Universal Product Code or its superset European Article Number)
m_product updated timestamp 29,6 now() Date this record was updated
m_product updatedby numeric 10 User who updated this records
m_product value varchar 40 Search key for the record in the format required - must be unique
m_product versionno varchar 20  √  null Version Number
m_product volume numeric 0  √  0 Volume of a product
m_product weight numeric 0  √  0 Weight of a product
m_product_bom ad_client_id numeric 10  √  null Client/Tenant for this installation.
m_product_bom ad_org_id numeric 10  √  null Organizational entity within client
m_product_bom bomqty numeric 0  √  null Bill of Materials Quantity
m_product_bom bomtype varchar 2147483647  √  null Type of BOM
m_product_bom created timestamp 29,6  √  null Date this record was created
m_product_bom createdby numeric 10  √  null User who created this records
m_product_bom description varchar 255  √  null Optional short description of the record
m_product_bom isactive bpchar 1  √  null The record is active in the system
m_product_bom line numeric 10  √  null Unique line for this document
m_product_bom m_product_bom_id numeric 10  √  null BOM Line
m_product_bom m_product_bom_uu varchar 36  √  null M_Product_BOM_UU
m_product_bom m_product_id numeric 10  √  null Product, Service, Item
m_product_bom m_productbom_id numeric 10  √  null Bill of Material Component Product
m_product_bom updated timestamp 29,6  √  null Date this record was updated
m_product_bom updatedby numeric 10  √  null User who updated this records
m_product_category a_asset_group_id numeric 10  √  null Group of Assets
m_product_category ad_client_id numeric 10 Client/Tenant for this installation.
m_product_category ad_org_id numeric 10 Organizational entity within client
m_product_category ad_printcolor_id numeric 10  √  null Color used for printing and display
m_product_category created timestamp 29,6 now() Date this record was created
m_product_category createdby numeric 10 User who created this records
m_product_category description varchar 255  √  null Optional short description of the record
m_product_category isactive bpchar 1 'Y'::bpchar The record is active in the system
m_product_category isdefault bpchar 1 'N'::bpchar Default value
m_product_category isselfservice bpchar 1 'Y'::bpchar This is a Self-Service entry or this entry can be changed via Self-Service
m_product_category m_product_category_id numeric 10 Category of a Product
m_product_category m_product_category_parent_id numeric 10  √  null Parent Product Category
m_product_category m_product_category_uu varchar 36  √  NULL::character varying M_Product_Category_UU
m_product_category mmpolicy bpchar 1 'F'::bpchar Material Movement Policy
m_product_category name varchar 60 Alphanumeric identifier of the entity
m_product_category plannedmargin numeric 0 Project's planned margin as a percentage
m_product_category updated timestamp 29,6 now() Date this record was updated
m_product_category updatedby numeric 10 User who updated this records
m_product_category value varchar 40 Search key for the record in the format required - must be unique
m_product_po ad_client_id numeric 10 Client/Tenant for this installation.
m_product_po ad_org_id numeric 10 Organizational entity within client
m_product_po c_bpartner_id numeric 10 Identifies a Business Partner
m_product_po c_currency_id numeric 10  √  null The Currency for this record
m_product_po c_uom_id numeric 10  √  null Unit of Measure
m_product_po costperorder numeric 0  √  0 Fixed Cost Per Order
m_product_po created timestamp 29,6 now() Date this record was created
m_product_po createdby numeric 10 User who created this records
m_product_po deliverytime_actual numeric 10  √  null Actual days between order and delivery
m_product_po deliverytime_promised numeric 10  √  null Promised days between order and delivery
m_product_po discontinued bpchar 1  √  'N'::bpchar This product is no longer available
m_product_po discontinuedat timestamp 29,6  √  null Discontinued At indicates Date when product was discontinued
m_product_po discontinuedby timestamp 29,6  √  null
m_product_po isactive bpchar 1 'Y'::bpchar The record is active in the system
m_product_po iscurrentvendor bpchar 1 'Y'::bpchar Use this Vendor for pricing and stock replenishment
m_product_po m_product_id numeric 10 Product, Service, Item
m_product_po m_product_po_uu varchar 36  √  NULL::character varying M_Product_PO_UU
m_product_po manufacturer varchar 30  √  null Manufacturer of the Product
m_product_po order_min numeric 0  √  0 Minimum order quantity in UOM
m_product_po order_pack numeric 0  √  0 Package order size in UOM (e.g. order set of 5 units)
m_product_po priceeffective timestamp 29,6  √  null Effective Date of Price
m_product_po pricelastinv numeric 0  √  0 Price of the last invoice for the product
m_product_po pricelastpo numeric 0  √  0 Price of the last purchase order for the product
m_product_po pricelist numeric 0  √  0 List Price
m_product_po pricepo numeric 0  √  0 Price based on a purchase order
m_product_po qualityrating numeric 0  √  null Method for rating vendors
m_product_po royaltyamt numeric 0  √  0 (Included) Amount for copyright, etc.
m_product_po upc varchar 20  √  null Bar Code (Universal Product Code or its superset European Article Number)
m_product_po updated timestamp 29,6 now() Date this record was updated
m_product_po updatedby numeric 10 User who updated this records
m_product_po vendorcategory varchar 30  √  null Product Category of the Business Partner
m_product_po vendorproductno varchar 40 Product Key of the Business Partner
m_product_qualitytest ad_client_id numeric 10 Client/Tenant for this installation.
m_product_qualitytest ad_org_id numeric 10 Organizational entity within client
m_product_qualitytest created timestamp 29,6 statement_timestamp() Date this record was created
m_product_qualitytest createdby numeric 10 User who created this records
m_product_qualitytest expectedresult varchar 255 Expected Result
m_product_qualitytest isactive bpchar 1 'Y'::bpchar The record is active in the system
m_product_qualitytest m_product_id numeric 10 Product, Service, Item
m_product_qualitytest m_product_qualitytest_id numeric 10 Product Quality Test
m_product_qualitytest m_product_qualitytest_uu varchar 36  √  NULL::character varying M_Product_QualityTest_UU
m_product_qualitytest m_qualitytest_id numeric 10 Quality Test
m_product_qualitytest updated timestamp 29,6 statement_timestamp() Date this record was updated
m_product_qualitytest updatedby numeric 10 User who updated this records
m_production ad_client_id numeric 10 Client/Tenant for this installation.
m_production ad_org_id numeric 10 Organizational entity within client
m_production ad_orgtrx_id numeric 10  √  null Performing or initiating organization
m_production c_activity_id numeric 10  √  null Business Activity
m_production c_bpartner_id numeric 10  √  NULL::numeric Identifies a Business Partner
m_production c_campaign_id numeric 10  √  null Marketing Campaign
m_production c_orderline_id numeric 10  √  NULL::numeric Sales Order Line
m_production c_project_id numeric 10  √  null Financial Project
m_production c_projectphase_id numeric 10  √  NULL::numeric Phase of a Project
m_production c_projecttask_id numeric 10  √  NULL::numeric Actual Project Task in a Phase
m_production created timestamp 29,6 now() Date this record was created
m_production createdby numeric 10 User who created this records
m_production createfrom bpchar 1  √  'N'::bpchar Process which will generate a new document lines based on an existing document
m_production datepromised timestamp 29,6  √  null Date Order was promised
m_production description varchar 255  √  null Optional short description of the record
m_production docaction bpchar 2 'CO'::bpchar The targeted status of the document
m_production docstatus varchar 2 'DR'::character varying The current status of the document
m_production documentno varchar 30 Document sequence number of the document
m_production isactive bpchar 1 'Y'::bpchar The record is active in the system
m_production iscomplete bpchar 1  √  NULL::bpchar It is complete
m_production iscreated bpchar 1 'N'::bpchar Records created
m_production isuseproductionplan bpchar 1 'N'::bpchar Use Production Plan
m_production m_inoutline_id numeric 10  √  NULL::numeric Line on Shipment or Receipt document
m_production m_locator_id numeric 10  √  null Warehouse Locator
m_production m_product_id numeric 10  √  null Product, Service, Item
m_production m_production_id numeric 10 Plan for producing a product
m_production m_production_uu varchar 36  √  NULL::character varying M_Production_UU
m_production movementdate timestamp 29,6 Date a product was moved in or out of inventory
m_production name varchar 60  √  null Alphanumeric identifier of the entity
m_production posted bpchar 1 'N'::bpchar Posting status
m_production pp_product_bom_id numeric 10  √  NULL::numeric BOM & Formula
m_production processed bpchar 1 'N'::bpchar The document has been processed
m_production processedon numeric 0  √  null The date+time (expressed in decimal format) when the document has been processed
m_production processing bpchar 1  √  null Process Now
m_production productionqty numeric 0 0 Quantity of products to produce
m_production reversal_id numeric 10  √  NULL::numeric ID of document reversal
m_production updated timestamp 29,6 now() Date this record was updated
m_production updatedby numeric 10 User who updated this records
m_production user1_id numeric 10  √  null User defined list element #1
m_production user2_id numeric 10  √  null User defined list element #2
m_productionline ad_client_id numeric 10 Client/Tenant for this installation.
m_productionline ad_org_id numeric 10 Organizational entity within client
m_productionline created timestamp 29,6 now() Date this record was created
m_productionline createdby numeric 10 User who created this records
m_productionline description varchar 255  √  null Optional short description of the record
m_productionline isactive bpchar 1 'Y'::bpchar The record is active in the system
m_productionline isendproduct bpchar 1  √  NULL::bpchar End Product of production
m_productionline line numeric 10 Unique line for this document
m_productionline m_attributesetinstance_id numeric 10  √  0 Product Attribute Set Instance
m_productionline m_locator_id numeric 10 Warehouse Locator
m_productionline m_product_id numeric 10 Product, Service, Item
m_productionline m_production_id numeric 10  √  null Plan for producing a product
m_productionline m_productionline_id numeric 10 Document Line representing a production
m_productionline m_productionline_uu varchar 36  √  NULL::character varying M_ProductionLine_UU
m_productionline m_productionplan_id numeric 10  √  null Plan for how a product is produced
m_productionline movementqty numeric 0 0 Quantity of a product moved.
m_productionline plannedqty numeric 0  √  null Planned quantity for this project
m_productionline processed bpchar 1 'N'::bpchar The document has been processed
m_productionline qtyused numeric 0  √  null Quantity Used
m_productionline updated timestamp 29,6 now() Date this record was updated
m_productionline updatedby numeric 10 User who updated this records
m_productionlinema ad_client_id numeric 10 Client/Tenant for this installation.
m_productionlinema ad_org_id numeric 10 Organizational entity within client
m_productionlinema created timestamp 29,6 now() Date this record was created
m_productionlinema createdby numeric 10 User who created this records
m_productionlinema datematerialpolicy timestamp 29,6 Time used for LIFO and FIFO Material Policy
m_productionlinema isactive bpchar 1 'Y'::bpchar The record is active in the system
m_productionlinema m_attributesetinstance_id numeric 10 Product Attribute Set Instance
m_productionlinema m_productionline_id numeric 10 Document Line representing a production
m_productionlinema m_productionlinema_uu varchar 36  √  NULL::character varying M_ProductionLineMA_UU
m_productionlinema movementqty numeric 0 0 Quantity of a product moved.
m_productionlinema updated timestamp 29,6 now() Date this record was updated
m_productionlinema updatedby numeric 10 User who updated this records
m_productionplan ad_client_id numeric 10 Client/Tenant for this installation.
m_productionplan ad_org_id numeric 10 Organizational entity within client
m_productionplan created timestamp 29,6 now() Date this record was created
m_productionplan createdby numeric 10 User who created this records
m_productionplan description varchar 255  √  null Optional short description of the record
m_productionplan isactive bpchar 1 'Y'::bpchar The record is active in the system
m_productionplan line numeric 10 Unique line for this document
m_productionplan m_locator_id numeric 10 Warehouse Locator
m_productionplan m_product_id numeric 10 Product, Service, Item
m_productionplan m_production_id numeric 10 Plan for producing a product
m_productionplan m_productionplan_id numeric 10 Plan for how a product is produced
m_productionplan m_productionplan_uu varchar 36  √  NULL::character varying M_ProductionPlan_UU
m_productionplan processed bpchar 1 'N'::bpchar The document has been processed
m_productionplan productionqty numeric 0 0 Quantity of products to produce
m_productionplan updated timestamp 29,6 now() Date this record was updated
m_productionplan updatedby numeric 10 User who updated this records
m_productprice ad_client_id numeric 10 Client/Tenant for this installation.
m_productprice ad_org_id numeric 10 Organizational entity within client
m_productprice created timestamp 29,6 now() Date this record was created
m_productprice createdby numeric 10 User who created this records
m_productprice isactive bpchar 1 'Y'::bpchar The record is active in the system
m_productprice m_pricelist_version_id numeric 10 Identifies a unique instance of a Price List
m_productprice m_product_id numeric 10 Product, Service, Item
m_productprice m_productprice_id numeric 10 NULL::numeric Intersection between a Product and a Price List Version
m_productprice m_productprice_uu varchar 36  √  NULL::character varying M_ProductPrice_UU
m_productprice pricelimit numeric 0 0 Lowest price for a product
m_productprice pricelist numeric 0 0 List Price
m_productprice pricestd numeric 0 0 Standard Price
m_productprice updated timestamp 29,6 now() Date this record was updated
m_productprice updatedby numeric 10 User who updated this records
m_productpricevendorbreak ad_client_id numeric 10 Client/Tenant for this installation.
m_productpricevendorbreak ad_org_id numeric 10 Organizational entity within client
m_productpricevendorbreak breakvalue numeric 0 Low Value of trade discount break level
m_productpricevendorbreak c_bpartner_id numeric 10  √  null Identifies a Business Partner
m_productpricevendorbreak created timestamp 29,6 statement_timestamp() Date this record was created
m_productpricevendorbreak createdby numeric 10 User who created this records
m_productpricevendorbreak isactive bpchar 1 'Y'::bpchar The record is active in the system
m_productpricevendorbreak m_pricelist_version_id numeric 10 Identifies a unique instance of a Price List
m_productpricevendorbreak m_product_id numeric 10 Product, Service, Item
m_productpricevendorbreak m_productpricevendorbreak_id numeric 10 Product Price Break
m_productpricevendorbreak m_productpricevendorbreak_uu varchar 36  √  NULL::character varying M_ProductPriceVendorBreak_UU
m_productpricevendorbreak pricelimit numeric 0 Lowest price for a product
m_productpricevendorbreak pricelist numeric 0 List Price
m_productpricevendorbreak pricestd numeric 0 Standard Price
m_productpricevendorbreak updated timestamp 29,6 statement_timestamp() Date this record was updated
m_productpricevendorbreak updatedby numeric 10 User who updated this records
m_qualitytest ad_client_id numeric 10 Client/Tenant for this installation.
m_qualitytest ad_org_id numeric 10 Organizational entity within client
m_qualitytest created timestamp 29,6 statement_timestamp() Date this record was created
m_qualitytest createdby numeric 10 User who created this records
m_qualitytest description varchar 255  √  NULL::character varying Optional short description of the record
m_qualitytest help varchar 2000  √  NULL::character varying Comment or Hint
m_qualitytest isactive bpchar 1 'Y'::bpchar The record is active in the system
m_qualitytest m_qualitytest_id numeric 10 Quality Test
m_qualitytest m_qualitytest_uu varchar 36  √  NULL::character varying M_QualityTest_UU
m_qualitytest name varchar 60 Alphanumeric identifier of the entity
m_qualitytest updated timestamp 29,6 statement_timestamp() Date this record was updated
m_qualitytest updatedby numeric 10 User who updated this records
m_qualitytestresult ad_client_id numeric 10 Client/Tenant for this installation.
m_qualitytestresult ad_org_id numeric 10 Organizational entity within client
m_qualitytestresult created timestamp 29,6 statement_timestamp() Date this record was created
m_qualitytestresult createdby numeric 10 User who created this records
m_qualitytestresult isactive bpchar 1 'Y'::bpchar The record is active in the system
m_qualitytestresult isqcpass bpchar 1 'N'::bpchar QC Pass
m_qualitytestresult m_attributesetinstance_id numeric 10 Product Attribute Set Instance
m_qualitytestresult m_qualitytest_id numeric 10 Quality Test
m_qualitytestresult m_qualitytestresult_id numeric 10 Quality Test Result
m_qualitytestresult m_qualitytestresult_uu varchar 36  √  NULL::character varying M_QualityTestResult_UU
m_qualitytestresult processed bpchar 1 'N'::bpchar The document has been processed
m_qualitytestresult result varchar 255  √  NULL::character varying Result of the action taken
m_qualitytestresult updated timestamp 29,6 statement_timestamp() Date this record was updated
m_qualitytestresult updatedby numeric 10 User who updated this records
m_replenish ad_client_id numeric 10 Client/Tenant for this installation.
m_replenish ad_org_id numeric 10 Organizational entity within client
m_replenish created timestamp 29,6 now() Date this record was created
m_replenish createdby numeric 10 User who created this records
m_replenish isactive bpchar 1 'Y'::bpchar The record is active in the system
m_replenish level_max numeric 0 0 Maximum Inventory level for this product
m_replenish level_min numeric 0 0 Minimum Inventory level for this product
m_replenish m_locator_id numeric 10  √  null Warehouse Locator
m_replenish m_product_id numeric 10 Product, Service, Item
m_replenish m_replenish_uu varchar 36  √  NULL::character varying M_Replenish_UU
m_replenish m_warehouse_id numeric 10 Storage Warehouse and Service Point
m_replenish m_warehousesource_id numeric 10  √  null Optional Warehouse to replenish from
m_replenish qtybatchsize numeric 0  √  null Qty Batch Size
m_replenish replenishtype bpchar 1 Method for re-ordering a product
m_replenish updated timestamp 29,6 now() Date this record was updated
m_replenish updatedby numeric 10 User who updated this records
m_shipper ad_client_id numeric 10 Client/Tenant for this installation.
m_shipper ad_org_id numeric 10 Organizational entity within client
m_shipper c_bpartner_id numeric 10  √  null Identifies a Business Partner
m_shipper created timestamp 29,6 now() Date this record was created
m_shipper createdby numeric 10 User who created this records
m_shipper createfrom bpchar 1  √  NULL::bpchar Process which will generate a new document lines based on an existing document
m_shipper isactive bpchar 1 'Y'::bpchar The record is active in the system
m_shipper m_shipper_id numeric 10 Method or manner of product delivery
m_shipper m_shipper_uu varchar 36  √  NULL::character varying M_Shipper_UU
m_shipper m_shippercfg_id numeric 10  √  NULL::numeric Shipper Configuration
m_shipper m_shippingprocessor_id numeric 10  √  NULL::numeric Shipping Processor
m_shipper name varchar 60 NULL::character varying Alphanumeric identifier of the entity
m_shipper updated timestamp 29,6 now() Date this record was updated
m_shipper updatedby numeric 10 User who updated this records
m_storage ad_client_id numeric 10  √  null Client/Tenant for this installation.
m_storage ad_org_id numeric 10  √  null Organizational entity within client
m_storage created timestamp 29,6  √  null Date this record was created
m_storage createdby numeric 10  √  null User who created this records
m_storage datelastinventory timestamp 29,6  √  null Date of Last Inventory Count
m_storage datematerialpolicy timestamp 29,6  √  null Time used for LIFO and FIFO Material Policy
m_storage isactive bpchar 1  √  null The record is active in the system
m_storage m_attributesetinstance_id numeric 10  √  null Product Attribute Set Instance
m_storage m_locator_id numeric 10  √  null Warehouse Locator
m_storage m_product_id numeric 10  √  null Product, Service, Item
m_storage m_storage_uu varchar 36  √  null M_Storage_UU
m_storage qtyonhand numeric 0  √  null On Hand Quantity
m_storage qtyordered numeric 0  √  null Ordered Quantity
m_storage qtyreserved numeric 0  √  null Reserved Quantity
m_storage updated timestamp 29,6  √  null Date this record was updated
m_storage updatedby numeric 10  √  null User who updated this records
m_storageonhand ad_client_id numeric 10 Client/Tenant for this installation.
m_storageonhand ad_org_id numeric 10 Organizational entity within client
m_storageonhand created timestamp 29,6 statement_timestamp() Date this record was created
m_storageonhand createdby numeric 10 User who created this records
m_storageonhand datelastinventory timestamp 29,6  √  null Date of Last Inventory Count
m_storageonhand datematerialpolicy timestamp 29,6 Time used for LIFO and FIFO Material Policy
m_storageonhand isactive bpchar 1 'Y'::bpchar The record is active in the system
m_storageonhand m_attributesetinstance_id numeric 10 Product Attribute Set Instance
m_storageonhand m_locator_id numeric 10 Warehouse Locator
m_storageonhand m_product_id numeric 10 Product, Service, Item
m_storageonhand m_storageonhand_uu varchar 36  √  NULL::character varying M_StorageOnHand_UU
m_storageonhand qtyonhand numeric 0 On Hand Quantity
m_storageonhand updated timestamp 29,6 statement_timestamp() Date this record was updated
m_storageonhand updatedby numeric 10 User who updated this records
m_storagereservation ad_client_id numeric 10 Client/Tenant for this installation.
m_storagereservation ad_org_id numeric 10 Organizational entity within client
m_storagereservation created timestamp 29,6 statement_timestamp() Date this record was created
m_storagereservation createdby numeric 10 User who created this records
m_storagereservation datelastinventory timestamp 29,6  √  null Date of Last Inventory Count
m_storagereservation isactive bpchar 1 'Y'::bpchar The record is active in the system
m_storagereservation issotrx bpchar 1 'Y'::bpchar This is a Sales Transaction
m_storagereservation m_attributesetinstance_id numeric 10 Product Attribute Set Instance
m_storagereservation m_product_id numeric 10 Product, Service, Item
m_storagereservation m_storagereservation_uu varchar 36  √  NULL::character varying M_StorageReservation_UU
m_storagereservation m_warehouse_id numeric 10 Storage Warehouse and Service Point
m_storagereservation qty numeric 0 Quantity
m_storagereservation updated timestamp 29,6 statement_timestamp() Date this record was updated
m_storagereservation updatedby numeric 10 User who updated this records
m_storagereservationlog ad_client_id numeric 10 Client/Tenant for this installation.
m_storagereservationlog ad_org_id numeric 10 Organizational entity within client
m_storagereservationlog ad_table_id numeric 10 Database Table information
m_storagereservationlog c_doctype_id numeric 10  √  null Document type or rules
m_storagereservationlog created timestamp 29,6 Date this record was created
m_storagereservationlog createdby numeric 10 User who created this records
m_storagereservationlog deltaqty numeric 0 Quantity Difference
m_storagereservationlog documentno varchar 255  √  null Document sequence number of the document
m_storagereservationlog isactive bpchar 1 'Y'::bpchar The record is active in the system
m_storagereservationlog issotrx bpchar 1 This is a Sales Transaction
m_storagereservationlog lineno numeric 10  √  NULL::numeric Line No
m_storagereservationlog m_attributesetinstance_id numeric 10 Product Attribute Set Instance
m_storagereservationlog m_product_id numeric 10 Product, Service, Item
m_storagereservationlog m_storagereservationlog_id numeric 10 Log for every storage reservation quantity change
m_storagereservationlog m_storagereservationlog_uu varchar 36 M_StorageReservationLog_UU
m_storagereservationlog m_warehouse_id numeric 10 Storage Warehouse and Service Point
m_storagereservationlog newqty numeric 0 New current quantity after processing of M_CostDetail
m_storagereservationlog oldqty numeric 0 Old current quantity before the processing of M_CostDetail
m_storagereservationlog record_id numeric 10 Direct internal record ID
m_storagereservationlog updated timestamp 29,6 Date this record was updated
m_storagereservationlog updatedby numeric 10 User who updated this records
m_substitute ad_client_id numeric 10 Client/Tenant for this installation.
m_substitute ad_org_id numeric 10 Organizational entity within client
m_substitute created timestamp 29,6 now() Date this record was created
m_substitute createdby numeric 10 User who created this records
m_substitute description varchar 255  √  null Optional short description of the record
m_substitute isactive bpchar 1 'Y'::bpchar The record is active in the system
m_substitute m_product_id numeric 10 Product, Service, Item
m_substitute m_substitute_uu varchar 36  √  NULL::character varying M_Substitute_UU
m_substitute name varchar 60  √  null Alphanumeric identifier of the entity
m_substitute substitute_id numeric 10 Entity which can be used in place of this entity
m_substitute updated timestamp 29,6 now() Date this record was updated
m_substitute updatedby numeric 10 User who updated this records
m_transaction ad_client_id numeric 10 Client/Tenant for this installation.
m_transaction ad_org_id numeric 10 Organizational entity within client
m_transaction c_projectissue_id numeric 10  √  null Project Issues (Material, Labor)
m_transaction created timestamp 29,6 now() Date this record was created
m_transaction createdby numeric 10 User who created this records
m_transaction isactive bpchar 1 'Y'::bpchar The record is active in the system
m_transaction m_attributesetinstance_id numeric 10 0 Product Attribute Set Instance
m_transaction m_inoutline_id numeric 10  √  null Line on Shipment or Receipt document
m_transaction m_inventoryline_id numeric 10  √  null Unique line in an Inventory document
m_transaction m_locator_id numeric 10 Warehouse Locator
m_transaction m_movementline_id numeric 10  √  null Inventory Move document Line
m_transaction m_product_id numeric 10 Product, Service, Item
m_transaction m_productionline_id numeric 10  √  null Document Line representing a production
m_transaction m_transaction_id numeric 10 Inventory Transaction
m_transaction m_transaction_uu varchar 36  √  NULL::character varying M_Transaction_UU
m_transaction movementdate timestamp 29,6 Date a product was moved in or out of inventory
m_transaction movementqty numeric 0 0 Quantity of a product moved.
m_transaction movementtype bpchar 2 Method of moving the inventory
m_transaction pp_cost_collector_id numeric 10  √  null Manufacturing Cost Collector
m_transaction updated timestamp 29,6 now() Date this record was updated
m_transaction updatedby numeric 10 User who updated this records
m_transactionallocation ad_client_id numeric 10 Client/Tenant for this installation.
m_transactionallocation ad_org_id numeric 10 Organizational entity within client
m_transactionallocation allocationstrategytype bpchar 1 Allocation Strategy
m_transactionallocation created timestamp 29,6 now() Date this record was created
m_transactionallocation createdby numeric 10 User who created this records
m_transactionallocation isactive bpchar 1 'Y'::bpchar The record is active in the system
m_transactionallocation isallocated bpchar 1 'N'::bpchar Indicates if the payment has been allocated
m_transactionallocation ismanual bpchar 1 'N'::bpchar This is a manual process
m_transactionallocation m_attributesetinstance_id numeric 10 0 Product Attribute Set Instance
m_transactionallocation m_inoutline_id numeric 10  √  null Line on Shipment or Receipt document
m_transactionallocation m_inventoryline_id numeric 10  √  null Unique line in an Inventory document
m_transactionallocation m_product_id numeric 10 Product, Service, Item
m_transactionallocation m_productionline_id numeric 10  √  null Document Line representing a production
m_transactionallocation m_transaction_id numeric 10 Inventory Transaction
m_transactionallocation m_transactionallocation_uu varchar 36  √  NULL::character varying M_TransactionAllocation_UU
m_transactionallocation out_m_inoutline_id numeric 10  √  null Outgoing Shipment/Receipt
m_transactionallocation out_m_inventoryline_id numeric 10  √  null Outgoing Inventory Line
m_transactionallocation out_m_productionline_id numeric 10  √  null Outgoing Production Line
m_transactionallocation out_m_transaction_id numeric 10  √  null Outgoing Transaction
m_transactionallocation qty numeric 0 0 Quantity
m_transactionallocation updated timestamp 29,6 now() Date this record was updated
m_transactionallocation updatedby numeric 10 User who updated this records
m_warehouse ad_client_id numeric 10 Client/Tenant for this installation.
m_warehouse ad_org_id numeric 10 Organizational entity within client
m_warehouse c_location_id numeric 10 Location or Address
m_warehouse created timestamp 29,6 now() Date this record was created
m_warehouse createdby numeric 10 User who created this records
m_warehouse description varchar 255  √  null Optional short description of the record
m_warehouse isactive bpchar 1 'Y'::bpchar The record is active in the system
m_warehouse isdisallownegativeinv bpchar 1 'N'::bpchar Negative Inventory is not allowed in this warehouse
m_warehouse isintransit bpchar 1  √  'N'::bpchar Movement is in transit
m_warehouse m_reservelocator_id numeric 10  √  NULL::numeric Reservation Locator (just for reporting purposes)
m_warehouse m_warehouse_id numeric 10 Storage Warehouse and Service Point
m_warehouse m_warehouse_uu varchar 36  √  NULL::character varying M_Warehouse_UU
m_warehouse m_warehousesource_id numeric 10  √  null Optional Warehouse to replenish from
m_warehouse name varchar 60 Alphanumeric identifier of the entity
m_warehouse replenishmentclass varchar 60  √  null Custom class to calculate Quantity to Order
m_warehouse separator bpchar 1 Element Separator
m_warehouse updated timestamp 29,6 now() Date this record was updated
m_warehouse updatedby numeric 10 User who updated this records
m_warehouse value varchar 40 Search key for the record in the format required - must be unique
qm_specification ad_client_id numeric 10 Client/Tenant for this installation.
qm_specification ad_org_id numeric 10 Organizational entity within client
qm_specification ad_workflow_id numeric 10  √  null Workflow or combination of tasks
qm_specification created timestamp 29,6 statement_timestamp() Date this record was created
qm_specification createdby numeric 10 User who created this records
qm_specification description varchar 255  √  null Optional short description of the record
qm_specification isactive bpchar 1 The record is active in the system
qm_specification m_attributeset_id numeric 10 Product Attribute Set
qm_specification m_product_id numeric 10 Product, Service, Item
qm_specification name varchar 60  √  null Alphanumeric identifier of the entity
qm_specification pp_product_bom_id numeric 10  √  null BOM & Formula
qm_specification qm_specification_id numeric 10 Quality Specification
qm_specification qm_specification_uu varchar 36  √  NULL::character varying QM_Specification_UU
qm_specification updated timestamp 29,6 statement_timestamp() Date this record was updated
qm_specification updatedby numeric 10 User who updated this records
qm_specification validfrom timestamp 29,6  √  null Valid from including this date (first day)
qm_specification validto timestamp 29,6  √  null Valid to including this date (last day)
qm_specification value varchar 40  √  null Search key for the record in the format required - must be unique
qm_specificationline ad_client_id numeric 10 Client/Tenant for this installation.
qm_specificationline ad_org_id numeric 10 Organizational entity within client
qm_specificationline andor bpchar 1 Logical operation: AND or OR
qm_specificationline created timestamp 29,6 statement_timestamp() Date this record was created
qm_specificationline createdby numeric 10 User who created this records
qm_specificationline isactive bpchar 1 The record is active in the system
qm_specificationline m_attribute_id numeric 10 Product Attribute
qm_specificationline operation bpchar 2 Compare Operation
qm_specificationline qm_specification_id numeric 10  √  null Quality Specification
qm_specificationline qm_specificationline_id numeric 10 QM Specification Line
qm_specificationline qm_specificationline_uu varchar 36  √  NULL::character varying QM_SpecificationLine_UU
qm_specificationline seqno numeric 10  √  null Method of ordering records; lowest number comes first
qm_specificationline updated timestamp 29,6 statement_timestamp() Date this record was updated
qm_specificationline updatedby numeric 10 User who updated this records
qm_specificationline validfrom varchar 22  √  null Valid from including this date (first day)
qm_specificationline validto timestamp 29,6  √  null Valid to including this date (last day)
qm_specificationline value varchar 40  √  null Search key for the record in the format required - must be unique
t_replenish ad_client_id numeric 10 Client/Tenant for this installation.
t_replenish ad_org_id numeric 10 Organizational entity within client
t_replenish ad_pinstance_id numeric 10 Instance of the process
t_replenish c_bpartner_id numeric 10 Identifies a Business Partner
t_replenish c_doctype_id numeric 10  √  null Document type or rules
t_replenish level_max numeric 0 0 Maximum Inventory level for this product
t_replenish level_min numeric 0 0 Minimum Inventory level for this product
t_replenish m_product_id numeric 10 Product, Service, Item
t_replenish m_warehouse_id numeric 10 Storage Warehouse and Service Point
t_replenish m_warehousesource_id numeric 10  √  null Optional Warehouse to replenish from
t_replenish order_min numeric 0 0 Minimum order quantity in UOM
t_replenish order_pack numeric 0 0 Package order size in UOM (e.g. order set of 5 units)
t_replenish qtyonhand numeric 0 0 On Hand Quantity
t_replenish qtyordered numeric 0 0 Ordered Quantity
t_replenish qtyreserved numeric 0 0 Reserved Quantity
t_replenish qtytoorder numeric 0 0 Quantity to Order
t_replenish replenishmentcreate bpchar 3  √  null Create from Replenishment
t_replenish replenishtype bpchar 1 Method for re-ordering a product
t_replenish t_replenish_uu varchar 36  √  NULL::character varying T_Replenish_UU
t_replenish updated timestamp 29,6 statement_timestamp() Date this record was updated
t_replenish updatedby numeric 10  √  null User who updated this records
t_transaction ad_client_id numeric 10 Client/Tenant for this installation.
t_transaction ad_org_id numeric 10 Organizational entity within client
t_transaction ad_pinstance_id numeric 10 Instance of the process
t_transaction c_project_id numeric 10  √  null Financial Project
t_transaction c_projectissue_id numeric 10  √  null Project Issues (Material, Labor)
t_transaction created timestamp 29,6 now() Date this record was created
t_transaction createdby numeric 10 User who created this records
t_transaction isactive bpchar 1 'Y'::bpchar The record is active in the system
t_transaction m_attributesetinstance_id numeric 10 Product Attribute Set Instance
t_transaction m_inout_id numeric 10  √  null Material Shipment Document
t_transaction m_inoutline_id numeric 10  √  null Line on Shipment or Receipt document
t_transaction m_inventory_id numeric 10  √  null Parameters for a Physical Inventory
t_transaction m_inventoryline_id numeric 10  √  null Unique line in an Inventory document
t_transaction m_locator_id numeric 10 Warehouse Locator
t_transaction m_movement_id numeric 10  √  null Movement of Inventory
t_transaction m_movementline_id numeric 10  √  null Inventory Move document Line
t_transaction m_product_id numeric 10 Product, Service, Item
t_transaction m_production_id numeric 10  √  null Plan for producing a product
t_transaction m_productionline_id numeric 10  √  null Document Line representing a production
t_transaction m_transaction_id numeric 10 Inventory Transaction
t_transaction movementdate timestamp 29,6 Date a product was moved in or out of inventory
t_transaction movementqty numeric 0 0 Quantity of a product moved.
t_transaction movementtype bpchar 2 Method of moving the inventory
t_transaction search_inout_id numeric 10  √  null Material Shipment Document
t_transaction search_invoice_id numeric 10  √  null Search Invoice Identifier
t_transaction search_order_id numeric 10  √  null Order Identifier
t_transaction t_transaction_uu varchar 36  √  NULL::character varying T_Transaction_UU
t_transaction updated timestamp 29,6 now() Date this record was updated
t_transaction updatedby numeric 10 User who updated this records