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

idempiere9.adempiere contains 452 columns - click on heading to sort:
Table Column Type Size Nulls Auto Default
m_inoutconfirm approvalamt numeric 0  √  null Document Approval Amount
m_inventory approvalamt numeric 0  √  null Document Approval Amount
m_movement approvalamt numeric 0  √  null Document Approval Amount
m_movementconfirm approvalamt numeric 0  √  0 Document Approval Amount
c_invoice chargeamt numeric 0  √  0 Charge Amount
m_inout chargeamt numeric 0  √  0 Charge Amount
m_movement chargeamt numeric 0  √  null Charge Amount
m_inoutline confirmedqty numeric 0  √  0 Confirmation of a received quantity
m_inoutlineconfirm confirmedqty numeric 0 0 Confirmation of a received quantity
m_movementline confirmedqty numeric 0  √  0 Confirmation of a received quantity
m_movementlineconfirm confirmedqty numeric 0 0 Confirmation of a received quantity
c_invoice currencyrate numeric 0  √  null Currency Conversion Rate
m_inventoryline currentcostprice numeric 0  √  (0)::numeric The currently used cost price
m_inoutlineconfirm differenceqty numeric 0  √  null Difference Quantity
m_movementlineconfirm differenceqty numeric 0 0 Difference Quantity
m_inout freightamt numeric 0  √  0 Freight Amount
m_movement freightamt numeric 0  √  null Freight Amount
c_invoice grandtotal numeric 0 0 Total amount of document
c_invoiceline linenetamt numeric 0 0 Line Extended Amount (Quantity * Actual Price) without Freight and Charges
c_invoiceline linetotalamt numeric 0  √  0 Total line amount incl. Tax
m_inoutline movementqty numeric 0 0 Quantity of a product moved.
m_movementline movementqty numeric 0 0 Quantity of a product moved.
m_inventoryline newcostprice numeric 0  √  (0)::numeric New current cost price after processing of M_CostDetail
m_inoutline pickedqty numeric 0  √  0 Picked Quantity
c_invoiceline priceactual numeric 0 0 Actual Price
c_invoiceline priceentered numeric 0 Price Entered - the price based on the selected/base UoM
c_invoiceline pricelimit numeric 0 0 Lowest price for a product
c_invoiceline pricelist numeric 0 0 List Price
c_invoice processedon numeric 0  √  null The date+time (expressed in decimal format) when 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_inventory processedon numeric 0  √  null The date+time (expressed in decimal format) when 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_inventoryline qtybook numeric 0 0 Book Quantity
m_inventoryline qtycount numeric 0 0 Counted Quantity
m_inventoryline qtycsv numeric 0 0 QtyCsv
c_invoiceline qtyentered numeric 0 The Quantity Entered is based on the selected UoM
m_inoutline qtyentered numeric 0 The Quantity Entered is based on the selected UoM
m_inventoryline qtyinternaluse numeric 0  √  null Internal Use Quantity removed from Inventory
c_invoiceline qtyinvoiced numeric 0 0 Invoiced Quantity
m_inoutline qtyoverreceipt numeric 0  √  0 Over Receipt Quantity
c_invoiceline rramt numeric 0  √  null Revenue Recognition Amount
m_inoutline scrappedqty numeric 0  √  0 The Quantity scrapped due to QA issues
m_inoutlineconfirm scrappedqty numeric 0  √  null The Quantity scrapped due to QA issues
m_movementline scrappedqty numeric 0  √  0 The Quantity scrapped due to QA issues
m_movementlineconfirm scrappedqty numeric 0 0 The Quantity scrapped due to QA issues
m_inoutline targetqty numeric 0  √  0 Target Movement Quantity
m_inoutlineconfirm targetqty numeric 0 0 Target Movement Quantity
m_movementline targetqty numeric 0  √  0 Target Movement Quantity
m_movementlineconfirm targetqty numeric 0 0 Target Movement Quantity
c_invoiceline taxamt numeric 0  √  0 Tax Amount for a document
c_invoice totallines numeric 0 0 Total of all document lines
m_inout volume numeric 0  √  null Volume of a product
m_inout weight numeric 0  √  null Weight of a product
c_invoiceline a_createasset bpchar 1  √  'N'::bpchar Create Asset
c_invoiceline a_processed bpchar 1  √  'N'::bpchar Processed
c_invoice copyfrom bpchar 1  √  null Copy From Record
m_inventory costingmethod bpchar 1  √  NULL::bpchar Indicates how Costs will be calculated
m_inout createconfirm bpchar 1  √  null Create Confirm
c_invoice createfrom bpchar 1  √  null Process which will generate a new document lines based on an existing document
m_inout createfrom bpchar 1  √  null Process which will generate a new document lines based on an existing document
m_movement 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_inoutconfirm createpackage bpchar 1  √  null Create Package
m_inout deliveryrule bpchar 1 Defines the timing of Delivery
m_movement deliveryrule bpchar 1  √  null Defines the timing of Delivery
m_inout deliveryviarule bpchar 1 How the order will be delivered
m_movement deliveryviarule bpchar 1  √  null How the order will be delivered
m_inout freightcostrule bpchar 1 Method for charging Freight
m_movement freightcostrule bpchar 1  √  null Method for charging Freight
m_inventory generatelist bpchar 1  √  'Y'::bpchar Generate List
c_invoice generateto bpchar 1  √  null Generate To
m_inout generateto bpchar 1  √  null Generate To
m_inout insurance bpchar 1  √  NULL::bpchar Insurance
m_inventoryline inventorytype bpchar 1 'D'::bpchar Type of inventory difference
c_invoice invoicecollectiontype bpchar 1  √  null Invoice Collection Status
c_invoice isactive bpchar 1 'Y'::bpchar The record is active in the system
c_invoiceline isactive bpchar 1 'Y'::bpchar The record is active in the system
m_inout isactive bpchar 1 'Y'::bpchar The record is active in the system
m_inoutconfirm isactive bpchar 1 'Y'::bpchar The record is active in the system
m_inoutline isactive bpchar 1 'Y'::bpchar The record is active in the system
m_inoutlineconfirm isactive bpchar 1 'Y'::bpchar The record is active in the system
m_inventory isactive bpchar 1 'Y'::bpchar The record is active in the system
m_inventoryline isactive bpchar 1 'Y'::bpchar The record is active in the system
m_movement isactive bpchar 1 'Y'::bpchar The record is active in the system
m_movementconfirm isactive bpchar 1 'Y'::bpchar The record is active in the system
m_movementline isactive bpchar 1 'Y'::bpchar The record is active in the system
m_movementlineconfirm isactive bpchar 1 'Y'::bpchar The record is active in the system
m_inout isalternatereturnaddress bpchar 1 'N'::bpchar Alternate Return Address
c_invoice isapproved bpchar 1 'Y'::bpchar Indicates if this document requires approval
m_inout isapproved bpchar 1 'N'::bpchar Indicates if this document requires approval
m_inoutconfirm isapproved bpchar 1 'N'::bpchar Indicates if this document requires approval
m_inventory isapproved bpchar 1 'N'::bpchar Indicates if this document requires approval
m_movement isapproved bpchar 1 'N'::bpchar Indicates if this document requires approval
m_movementconfirm isapproved bpchar 1 'N'::bpchar Indicates if this document requires approval
m_inoutline isautoproduce bpchar 1  √  'N'::bpchar Auto create production to fulfill shipment
m_inoutconfirm iscancelled bpchar 1 'N'::bpchar The transaction was cancelled
c_invoiceline isdescription bpchar 1 'N'::bpchar if true, the line is just description and no transaction
m_inoutline isdescription bpchar 1 'N'::bpchar if true, the line is just description and no transaction
c_invoice isdiscountprinted bpchar 1 'Y'::bpchar Print Discount on Invoice and Order
m_inout isdropship bpchar 1  √  'N'::bpchar Drop Shipments are sent directly to the Drop Shipment Location
c_invoice isfixedassetinvoice bpchar 1  √  null IsFixedAssetInvoice
c_invoiceline isfixedassetinvoice bpchar 1  √  null IsFixedAssetInvoice
c_invoice isindispute bpchar 1 'N'::bpchar Document is in dispute
m_inout isindispute bpchar 1 'N'::bpchar Document is in dispute
m_inoutconfirm isindispute bpchar 1 'N'::bpchar Document is in dispute
m_inout isintransit bpchar 1 'N'::bpchar Movement is in transit
m_movement isintransit bpchar 1 'N'::bpchar Movement is in transit
m_inoutline isinvoiced bpchar 1 'N'::bpchar Is this invoiced?
c_invoice isoverridecurrencyrate bpchar 1 'N'::bpchar Override Currency Conversion Rate
c_invoice ispaid bpchar 1 'N'::bpchar The document is paid
c_invoice ispayschedulevalid bpchar 1 'N'::bpchar Is the Payment Schedule is valid
c_invoice isprinted bpchar 1 'N'::bpchar Indicates if this document / line is printed
c_invoiceline isprinted bpchar 1 'Y'::bpchar Indicates if this document / line is printed
m_inout isprinted bpchar 1 'N'::bpchar Indicates if this document / line is printed
c_invoice isselfservice bpchar 1 'N'::bpchar This is a Self-Service entry or this entry can be changed via Self-Service
c_invoice issotrx bpchar 1 'Y'::bpchar This is a Sales Transaction
m_inout issotrx bpchar 1 'Y'::bpchar This is a Sales Transaction
c_invoice istaxincluded bpchar 1 'N'::bpchar Tax is included in the price
c_invoice istransferred bpchar 1 'N'::bpchar Transferred to General Ledger (i.e. accounted)
c_invoice paymentrule bpchar 1 How you pay the invoice
c_invoice posted bpchar 1 'N'::bpchar Posting status
m_inout posted bpchar 1 'N'::bpchar Posting status
m_inventory posted bpchar 1 'N'::bpchar Posting status
m_movement posted bpchar 1 'N'::bpchar Posting status
m_inout priorityrule bpchar 1 Priority of a document
m_movement priorityrule bpchar 1  √  null Priority of a document
c_invoice processed bpchar 1 'N'::bpchar The document has been processed
c_invoiceline processed bpchar 1 'N'::bpchar The document has been processed
m_inout processed bpchar 1 'N'::bpchar The document has been processed
m_inoutconfirm processed bpchar 1 'N'::bpchar The document has been processed
m_inoutline processed bpchar 1 'N'::bpchar The document has been processed
m_inoutlineconfirm processed bpchar 1 'N'::bpchar The document has been processed
m_inventory processed bpchar 1 'N'::bpchar The document has been processed
m_inventoryline processed bpchar 1 'N'::bpchar The document has been processed
m_movement processed bpchar 1 'N'::bpchar The document has been processed
m_movementconfirm processed bpchar 1 'N'::bpchar The document has been processed
m_movementline processed bpchar 1 'N'::bpchar The document has been processed
m_movementlineconfirm processed bpchar 1 'N'::bpchar The document has been processed
c_invoice processing bpchar 1  √  null Process Now
m_inout processing bpchar 1  √  null Process Now
m_inoutconfirm processing bpchar 1  √  null Process Now
m_inventory processing bpchar 1  √  null Process Now
m_movement processing bpchar 1  √  null Process Now
m_movementconfirm processing bpchar 1  √  null Process Now
c_invoice sendemail bpchar 1 'N'::bpchar Enable sending Document EMail
m_inout sendemail bpchar 1 'N'::bpchar Enable sending Document EMail
m_inventory updateqty bpchar 1  √  'N'::bpchar Update Quantities
m_inoutconfirm confirmtype bpchar 2 Type of confirmation
c_invoice docaction bpchar 2 The targeted status of the document
m_inout docaction bpchar 2 The targeted status of the document
m_inoutconfirm docaction bpchar 2 The targeted status of the document
m_inventory docaction bpchar 2 The targeted status of the document
m_movement docaction bpchar 2 The targeted status of the document
m_movementconfirm docaction bpchar 2 The targeted status of the document
c_invoice docstatus bpchar 2 The current status of the document
m_inout docstatus bpchar 2 The current status of the document
m_inoutconfirm docstatus bpchar 2 The current status of the document
m_inventory docstatus bpchar 2 The current status of the document
m_movement docstatus bpchar 2 The current status of the document
m_movementconfirm docstatus bpchar 2 The current status of the document
m_inout movementtype bpchar 2 Method of moving the inventory
c_invoiceline a_capvsexp varchar 3  √  null Capital/Expense
c_invoiceline a_asset_group_id numeric 10  √  null Group of Assets
c_invoiceline a_asset_id numeric 10  √  null Asset used internally or by customers
c_invoice ad_client_id numeric 10 Client/Tenant for this installation.
c_invoiceline ad_client_id numeric 10 Client/Tenant for this installation.
m_inout ad_client_id numeric 10 Client/Tenant for this installation.
m_inoutconfirm ad_client_id numeric 10 Client/Tenant for this installation.
m_inoutline ad_client_id numeric 10 Client/Tenant for this installation.
m_inoutlineconfirm ad_client_id numeric 10 Client/Tenant for this installation.
m_inventory ad_client_id numeric 10 Client/Tenant for this installation.
m_inventoryline ad_client_id numeric 10 Client/Tenant for this installation.
m_movement ad_client_id numeric 10 Client/Tenant for this installation.
m_movementconfirm ad_client_id numeric 10 Client/Tenant for this installation.
m_movementline ad_client_id numeric 10 Client/Tenant for this installation.
m_movementlineconfirm ad_client_id numeric 10 Client/Tenant for this installation.
c_invoice ad_org_id numeric 10 Organizational entity within client
c_invoiceline ad_org_id numeric 10 Organizational entity within client
m_inout ad_org_id numeric 10 Organizational entity within client
m_inoutconfirm ad_org_id numeric 10 Organizational entity within client
m_inoutline ad_org_id numeric 10 Organizational entity within client
m_inoutlineconfirm ad_org_id numeric 10 Organizational entity within client
m_inventory ad_org_id numeric 10 Organizational entity within client
m_inventoryline ad_org_id numeric 10 Organizational entity within client
m_movement ad_org_id numeric 10 Organizational entity within client
m_movementconfirm ad_org_id numeric 10 Organizational entity within client
m_movementline ad_org_id numeric 10 Organizational entity within client
m_movementlineconfirm ad_org_id numeric 10 Organizational entity within client
c_invoice ad_orgtrx_id numeric 10  √  null Performing or initiating organization
c_invoiceline ad_orgtrx_id numeric 10  √  null Performing or initiating organization
m_inout ad_orgtrx_id numeric 10  √  null Performing or initiating organization
m_inoutline ad_orgtrx_id numeric 10  √  null Performing or initiating organization
m_inventory ad_orgtrx_id numeric 10  √  null Performing or initiating organization
m_movement ad_orgtrx_id numeric 10  √  null Performing or initiating organization
c_invoice ad_user_id numeric 10  √  null User within the system - Internal or Business Partner Contact
m_inout ad_user_id numeric 10  √  null User within the system - Internal or Business Partner Contact
m_movement ad_user_id numeric 10  √  null User within the system - Internal or Business Partner Contact
c_invoiceline c_1099box_id numeric 10  √  NULL::numeric 1099 Box
c_invoice c_activity_id numeric 10  √  null Business Activity
c_invoiceline c_activity_id numeric 10  √  null Business Activity
m_inout c_activity_id numeric 10  √  null Business Activity
m_inoutline c_activity_id numeric 10  √  null Business Activity
m_inventory c_activity_id numeric 10  √  null Business Activity
m_movement c_activity_id numeric 10  √  null Business Activity
c_invoice c_bpartner_id numeric 10 Identifies a Business Partner
m_inout c_bpartner_id numeric 10 Identifies a Business Partner
m_movement c_bpartner_id numeric 10  √  null Identifies a Business Partner
c_invoice c_bpartner_location_id numeric 10 Identifies the (ship to) address for this Business Partner
m_inout c_bpartner_location_id numeric 10 Identifies the (ship to) address for this Business Partner
m_movement c_bpartner_location_id numeric 10  √  null Identifies the (ship to) address for this Business Partner
c_invoice c_campaign_id numeric 10  √  null Marketing Campaign
c_invoiceline c_campaign_id numeric 10  √  null Marketing Campaign
m_inout c_campaign_id numeric 10  √  null Marketing Campaign
m_inoutline c_campaign_id numeric 10  √  null Marketing Campaign
m_inventory c_campaign_id numeric 10  √  null Marketing Campaign
m_movement c_campaign_id numeric 10  √  null Marketing Campaign
c_invoice c_cashline_id numeric 10  √  null Cash Journal Line
c_invoice c_cashplanline_id numeric 10  √  NULL::numeric Cash Plan Line
c_invoice c_charge_id numeric 10  √  null Additional document charges
c_invoiceline c_charge_id numeric 10  √  null Additional document charges
m_inout c_charge_id numeric 10  √  null Additional document charges
m_inoutline c_charge_id numeric 10  √  null Additional document charges
m_inventoryline c_charge_id numeric 10  √  null Additional document charges
m_movement c_charge_id numeric 10  √  null Additional document charges
c_invoice c_conversiontype_id numeric 10  √  null Currency Conversion Rate Type
m_inventory c_conversiontype_id numeric 10  √  NULL::numeric Currency Conversion Rate Type
c_invoice c_currency_id numeric 10 The Currency for this record
m_inventory c_currency_id numeric 10  √  NULL::numeric The Currency for this record
c_invoice c_doctype_id numeric 10 Document type or rules
m_inout c_doctype_id numeric 10 Document type or rules
m_inventory c_doctype_id numeric 10 Document type or rules
m_movement c_doctype_id numeric 10 Document type or rules
c_invoice c_doctypetarget_id numeric 10 Target document type for conversing documents
c_invoice c_dunninglevel_id numeric 10  √  null Dunning Level
c_invoice c_invoice_id numeric 10 Invoice Identifier
c_invoiceline c_invoice_id numeric 10 Invoice Identifier
m_inout c_invoice_id numeric 10  √  null Invoice Identifier
m_inoutconfirm c_invoice_id numeric 10  √  null Invoice Identifier
c_invoiceline c_invoiceline_id numeric 10 Invoice Detail Line
m_inoutlineconfirm c_invoiceline_id numeric 10  √  null Invoice Detail Line
c_invoice c_order_id numeric 10  √  null Order
m_inout c_order_id numeric 10  √  null Order
c_invoiceline c_orderline_id numeric 10  √  null Sales Order Line
m_inoutline c_orderline_id numeric 10  √  null Sales Order Line
c_invoice c_payment_id numeric 10  √  null Payment identifier
c_invoice c_paymentterm_id numeric 10 The terms of Payment (timing, discount)
c_invoice c_project_id numeric 10  √  null Financial Project
c_invoiceline c_project_id numeric 10  √  null Financial Project
m_inout c_project_id numeric 10  √  null Financial Project
m_inoutline c_project_id numeric 10  √  null Financial Project
m_inventory c_project_id numeric 10  √  null Financial Project
m_movement c_project_id numeric 10  √  null Financial Project
c_invoiceline c_projectphase_id numeric 10  √  null Phase of a Project
m_inoutline c_projectphase_id numeric 10  √  null Phase of a Project
c_invoiceline c_projecttask_id numeric 10  √  null Actual Project Task in a Phase
m_inoutline c_projecttask_id numeric 10  √  null Actual Project Task in a Phase
c_invoiceline c_tax_id numeric 10  √  null Tax identifier
c_invoiceline c_uom_id numeric 10  √  null Unit of Measure
m_inoutline c_uom_id numeric 10 Unit of Measure
c_invoice createdby numeric 10 User who created this records
c_invoiceline createdby numeric 10 User who created this records
m_inout createdby numeric 10 User who created this records
m_inoutconfirm createdby numeric 10 User who created this records
m_inoutline createdby numeric 10 User who created this records
m_inoutlineconfirm createdby numeric 10 User who created this records
m_inventory createdby numeric 10 User who created this records
m_inventoryline createdby numeric 10 User who created this records
m_movement createdby numeric 10 User who created this records
m_movementconfirm createdby numeric 10 User who created this records
m_movementline createdby numeric 10 User who created this records
m_movementlineconfirm createdby numeric 10 User who created this records
m_movement dd_order_id numeric 10  √  null Distribution Order
m_movementline dd_orderline_id numeric 10  √  null Distribution Order Line
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 freightcharges varchar 10  √  NULL::character varying Freight Charges
c_invoiceline line numeric 10 Unique line for this document
m_inoutline line numeric 10 Unique line for this document
m_inventoryline line numeric 10  √  null Unique line for this document
m_movementline line numeric 10  √  null Unique line for this document
c_invoiceline m_attributesetinstance_id numeric 10  √  0 Product Attribute Set Instance
m_inoutline m_attributesetinstance_id numeric 10  √  0 Product Attribute Set Instance
m_inventoryline m_attributesetinstance_id numeric 10  √  0 Product Attribute Set Instance
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_inout m_inout_id numeric 10 Material Shipment Document
m_inoutconfirm m_inout_id numeric 10 Material Shipment Document
m_inoutline m_inout_id numeric 10 Material Shipment Document
m_inoutconfirm m_inoutconfirm_id numeric 10 Material Shipment or Receipt Confirmation
m_inoutlineconfirm m_inoutconfirm_id numeric 10 Material Shipment or Receipt Confirmation
c_invoiceline m_inoutline_id numeric 10  √  null Line on Shipment or Receipt document
m_inoutline m_inoutline_id numeric 10 Line on Shipment or Receipt document
m_inoutlineconfirm m_inoutline_id numeric 10 Line on Shipment or Receipt document
m_inoutlineconfirm m_inoutlineconfirm_id numeric 10 Material Shipment or Receipt Confirmation Line
m_inoutconfirm m_inventory_id numeric 10  √  null Parameters for a Physical Inventory
m_inventory m_inventory_id numeric 10 Parameters for a Physical Inventory
m_inventoryline m_inventory_id numeric 10 Parameters for a Physical Inventory
m_movementconfirm m_inventory_id numeric 10  √  null Parameters for a Physical Inventory
m_inoutlineconfirm m_inventoryline_id numeric 10  √  null Unique line in an Inventory document
m_inventoryline m_inventoryline_id numeric 10 Unique line in an Inventory document
m_movementlineconfirm m_inventoryline_id numeric 10  √  null Unique line in an Inventory document
m_inoutline m_locator_id numeric 10  √  null Warehouse Locator
m_inventoryline m_locator_id numeric 10  √  null Warehouse Locator
m_movementline m_locator_id numeric 10 Warehouse Locator
m_movementline m_locatorto_id numeric 10 Location inventory is moved to
m_movement m_movement_id numeric 10 Movement of Inventory
m_movementconfirm m_movement_id numeric 10 Movement of Inventory
m_movementline m_movement_id numeric 10 Movement of Inventory
m_movementconfirm m_movementconfirm_id numeric 10 Inventory Move Confirmation
m_movementlineconfirm m_movementconfirm_id numeric 10 Inventory Move Confirmation
m_movementline m_movementline_id numeric 10 Inventory Move document Line
m_movementlineconfirm m_movementline_id numeric 10 Inventory Move document Line
m_movementlineconfirm m_movementlineconfirm_id numeric 10 Inventory Move Line Confirmation
m_inventory m_perpetualinv_id numeric 10  √  null Rules for generating physical inventory
c_invoice m_pricelist_id numeric 10 Unique identifier of a Price List
c_invoiceline m_product_id numeric 10  √  null Product, Service, Item
m_inoutline m_product_id numeric 10  √  null Product, Service, Item
m_inventoryline m_product_id numeric 10 Product, Service, Item
m_movementline m_product_id numeric 10 Product, Service, Item
c_invoice m_rma_id numeric 10  √  null Return Material Authorization
m_inout m_rma_id numeric 10  √  null Return Material Authorization
c_invoiceline m_rmaline_id numeric 10  √  null Return Material Authorization Line
m_inoutline m_rmaline_id numeric 10  √  null Return Material Authorization Line
m_inout m_shipper_id numeric 10  √  null Method or manner of product delivery
m_movement 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_inventory m_warehouse_id numeric 10  √  null Storage Warehouse and Service Point
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_inout nopackages numeric 10  √  (1)::numeric Number of packages shipped
m_inout ref_inout_id numeric 10  √  null Referenced Shipment
m_inoutline ref_inoutline_id numeric 10  √  null Referenced Shipment Line
c_invoice ref_invoice_id numeric 10  √  null Referenced Invoice
c_invoiceline ref_invoiceline_id numeric 10  √  null Referenced Invoice Line
c_invoice relatedinvoice_id numeric 10  √  NULL::numeric Related Invoice
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
c_invoice reversal_id numeric 10  √  null ID of document reversal
m_inout reversal_id numeric 10  √  null ID of document reversal
m_inventory reversal_id numeric 10  √  null ID of document reversal
m_movement reversal_id numeric 10  √  null ID of document reversal
m_inoutline reversalline_id numeric 10  √  null Use to keep the reversal line ID for reversing costing purpose
m_inventoryline reversalline_id numeric 10  √  null Use to keep the reversal line ID for reversing costing purpose
m_movementline reversalline_id numeric 10  √  null Use to keep the reversal line ID for reversing costing purpose
c_invoiceline s_resourceassignment_id numeric 10  √  null Resource Assignment
c_invoice salesrep_id numeric 10  √  null Sales Representative or Company Agent
m_inout salesrep_id numeric 10  √  null Sales Representative or Company Agent
m_movement salesrep_id numeric 10  √  null Sales Representative or Company Agent
c_invoice updatedby numeric 10 User who updated this records
c_invoiceline updatedby numeric 10 User who updated this records
m_inout updatedby numeric 10 User who updated this records
m_inoutconfirm updatedby numeric 10 User who updated this records
m_inoutline updatedby numeric 10 User who updated this records
m_inoutlineconfirm updatedby numeric 10 User who updated this records
m_inventory updatedby numeric 10 User who updated this records
m_inventoryline updatedby numeric 10 User who updated this records
m_movement updatedby numeric 10 User who updated this records
m_movementconfirm updatedby numeric 10 User who updated this records
m_movementline updatedby numeric 10 User who updated this records
m_movementlineconfirm updatedby numeric 10 User who updated this records
c_invoice user1_id numeric 10  √  null User defined list element #1
c_invoiceline user1_id numeric 10  √  null User defined list element #1
m_inout user1_id numeric 10  √  null User defined list element #1
m_inoutline user1_id numeric 10  √  null User defined list element #1
m_inventory user1_id numeric 10  √  null User defined list element #1
m_movement user1_id numeric 10  √  null User defined list element #1
c_invoice user2_id numeric 10  √  null User defined list element #2
c_invoiceline user2_id numeric 10  √  null User defined list element #2
m_inout user2_id numeric 10  √  null User defined list element #2
m_inoutline user2_id numeric 10  √  null User defined list element #2
m_inventory user2_id numeric 10  √  null User defined list element #2
m_movement user2_id numeric 10  √  null User defined list element #2
m_inoutconfirm confirmationno varchar 20  √  null Confirmation Number
m_inoutlineconfirm confirmationno varchar 20  √  null Confirmation Number
c_invoice poreference varchar 20  √  null Transaction Reference Number (Sales Order, Purchase Order) of your Business Partner
m_inout poreference varchar 20  √  null Transaction Reference Number (Sales Order, Purchase Order) of your Business Partner
m_movement poreference varchar 20  √  null Transaction Reference Number (Sales Order, Purchase Order) of your Business Partner
c_invoice created timestamp 29,6 now() Date this record was created
c_invoiceline created timestamp 29,6 now() Date this record was created
m_inout created timestamp 29,6 now() Date this record was created
m_inoutconfirm created timestamp 29,6 now() Date this record was created
m_inoutline created timestamp 29,6 now() Date this record was created
m_inoutlineconfirm created timestamp 29,6 now() Date this record was created
m_inventory created timestamp 29,6 now() Date this record was created
m_inventoryline created timestamp 29,6 now() Date this record was created
m_movement created timestamp 29,6 now() Date this record was created
m_movementconfirm created timestamp 29,6 now() Date this record was created
m_movementline created timestamp 29,6 now() Date this record was created
m_movementlineconfirm created timestamp 29,6 now() Date this record was created
c_invoice dateacct timestamp 29,6 Accounting Date
m_inout dateacct timestamp 29,6 Accounting Date
c_invoice dateinvoiced timestamp 29,6 Date printed on Invoice
c_invoice dateordered timestamp 29,6  √  null Date of Order
m_inout dateordered timestamp 29,6  √  null Date of Order
c_invoice dateprinted timestamp 29,6  √  null Date the document was printed.
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_movement datereceived timestamp 29,6  √  null Date a product was received
c_invoice dunninggrace timestamp 29,6  √  null Dunning Grace Date
m_inout movementdate timestamp 29,6 Date a product was moved in or out of inventory
m_inventory movementdate timestamp 29,6 Date a product was moved in or out of inventory
m_movement movementdate timestamp 29,6 Date a product was moved in or out of inventory
m_inout pickdate timestamp 29,6  √  null Date/Time when picked for Shipment
c_invoiceline rrstartdate timestamp 29,6  √  null Revenue Recognition Start Date
m_inout shipdate timestamp 29,6  √  null Shipment Date/Time
c_invoice updated timestamp 29,6 now() Date this record was updated
c_invoiceline updated timestamp 29,6 now() Date this record was updated
m_inout updated timestamp 29,6 now() Date this record was updated
m_inoutconfirm updated timestamp 29,6 now() Date this record was updated
m_inoutline updated timestamp 29,6 now() Date this record was updated
m_inoutlineconfirm updated timestamp 29,6 now() Date this record was updated
m_inventory updated timestamp 29,6 now() Date this record was updated
m_inventoryline updated timestamp 29,6 now() Date this record was updated
m_movement updated timestamp 29,6 now() Date this record was updated
m_movementconfirm updated timestamp 29,6 now() Date this record was updated
m_movementline updated timestamp 29,6 now() Date this record was updated
m_movementlineconfirm updated timestamp 29,6 now() Date this record was updated
c_invoice documentno varchar 30 Document sequence number of the document
m_inout documentno varchar 30 Document sequence number of the document
m_inoutconfirm documentno varchar 30 Document sequence number of the document
m_inventory documentno varchar 30 Document sequence number of the document
m_movement documentno varchar 30 Document sequence number of the document
m_movementconfirm documentno varchar 30 Document sequence number of the document
c_invoice c_invoice_uu varchar 36  √  NULL::character varying C_Invoice_UU
c_invoiceline c_invoiceline_uu varchar 36  √  NULL::character varying C_InvoiceLine_UU
m_inout m_inout_uu varchar 36  √  NULL::character varying M_InOut_UU
m_inoutconfirm m_inoutconfirm_uu varchar 36  √  NULL::character varying M_InOutConfirm_UU
m_inoutline m_inoutline_uu varchar 36  √  NULL::character varying M_InOutLine_UU
m_inoutlineconfirm m_inoutlineconfirm_uu varchar 36  √  NULL::character varying M_InOutLineConfirm_UU
m_inventory m_inventory_uu varchar 36  √  NULL::character varying M_Inventory_UU
m_inventoryline m_inventoryline_uu varchar 36  √  NULL::character varying M_InventoryLine_UU
m_movement m_movement_uu varchar 36  √  NULL::character varying M_Movement_UU
m_movementconfirm m_movementconfirm_uu varchar 36  √  NULL::character varying M_MovementConfirm_UU
m_movementline m_movementline_uu varchar 36  √  NULL::character varying M_MovementLine_UU
m_movementlineconfirm m_movementlineconfirm_uu varchar 36  √  NULL::character varying M_MovementLineConfirm_UU
m_inout shipperaccount varchar 40  √  NULL::character varying Shipper Account Number
m_inout trackingno varchar 60  √  null Number to track the shipment
c_invoice description varchar 255  √  null Optional short description of the record
c_invoiceline description varchar 255  √  null Optional short description of the record
m_inout description varchar 255  √  null Optional short description of the record
m_inoutconfirm description varchar 255  √  null Optional short description of the record
m_inoutline description varchar 255  √  null Optional short description of the record
m_inoutlineconfirm description varchar 255  √  null Optional short description of the record
m_inventory description varchar 255  √  null Optional short description of the record
m_inventoryline description varchar 255  √  null Optional short description of the record
m_movement description varchar 255  √  null Optional short description of the record
m_movementconfirm description varchar 255  √  null Optional short description of the record
m_movementline description varchar 255  √  null Optional short description of the record
m_movementlineconfirm description varchar 255  √  null Optional short description of the record