Table idempiere11.adempiere.i_order
Import Orders

 Generated by
Quality Systems & Solutions
Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
i_order_id numeric 10 Import Orders
ad_client_id numeric 10  √  null Tenant for this installation.
ad_org_id numeric 10  √  null
ad_org.ad_org_id adorg_iorder N
Organizational entity within tenant
ad_orgtrx_id numeric 10  √  null
ad_org.ad_org_id adorgtrx_iorder N
Performing or initiating organization
isactive bpchar 1  √  'Y'::bpchar The record is active in the system
created timestamp 29,6 statement_timestamp() Date this record was created
createdby numeric 10  √  null User who created this records
updated timestamp 29,6 statement_timestamp() Date this record was updated
updatedby numeric 10  √  null User who updated this records
i_isimported bpchar 1 'N'::bpchar Has this import been processed
i_errormsg varchar 2000  √  null Messages generated from import process
processing bpchar 1  √  null Process Now
processed bpchar 1  √  'N'::bpchar The document has been processed
salesrep_id numeric 10  √  null
ad_user.ad_user_id adusersalesrep_iorder N
Sales Representative or Company Agent
m_warehouse_id numeric 10  √  null
m_warehouse.m_warehouse_id mwarehouse_iorder N
Storage Warehouse and Service Point
m_pricelist_id numeric 10  √  null
m_pricelist.m_pricelist_id mpricelist_iorder N
Unique identifier of a Price List
c_currency_id numeric 10  √  null
c_currency.c_currency_id ccurrency_iorder N
The Currency for this record
m_shipper_id numeric 10  √  null
m_shipper.m_shipper_id mshipper_iorder N
Method or manner of product delivery
issotrx bpchar 1  √  'Y'::bpchar This is a Sales Transaction
c_bpartner_id numeric 10  √  null
c_bpartner.c_bpartner_id cbpartner_iorder N
Identifies a Business Partner
bpartnervalue varchar 40  √  null Key of the Business Partner
name varchar 60  √  null Alphanumeric identifier of the entity
c_bpartner_location_id numeric 10  √  null
c_bpartner_location.c_bpartner_location_id cbolocation_iorder N
Identifies the (ship to) address for this Business Partner
billto_id numeric 10  √  null
c_bpartner_location.c_bpartner_location_id cbpartnerlocbillto_iorder N
Bill to Address
c_location_id numeric 10  √  null
c_location.c_location_id clocation_iorder N
Location or Address
address1 varchar 60  √  null Address line 1 for this location
address2 varchar 60  √  null Address line 2 for this location
postal varchar 10  √  null Postal code
city varchar 60  √  null Identifies a City
c_region_id numeric 10  √  null
c_region.c_region_id cregion_iorder N
Identifies a geographical Region
regionname varchar 60  √  null Name of the Region
c_country_id numeric 10  √  null
c_country.c_country_id ccountry_iorder N
Country
countrycode bpchar 2  √  null Upper-case two-letter alphanumeric ISO Country code according to ISO 3166-1 - http://www.chemie.fu-berlin.de/diverse/doc/ISO_3166.html
ad_user_id numeric 10  √  null
ad_user.ad_user_id aduser_iorder N
User within the system - Internal or Business Partner Contact
contactname varchar 60  √  null Business Partner Contact Name
email varchar 60  √  null Electronic Mail Address
phone varchar 40  √  null Identifies a telephone number
c_project_id numeric 10  √  null
c_project.c_project_id cproject_iorder N
Financial Project
c_activity_id numeric 10  √  null
c_activity.c_activity_id cactivity_iorder N
Business Activity
c_doctype_id numeric 10  √  null
c_doctype.c_doctype_id cdoctype_iorder N
Document type or rules
doctypename varchar 60  √  null Name of the Document Type
c_paymentterm_id numeric 10  √  null
c_paymentterm.c_paymentterm_id cpaymentterm_iorder N
The terms of Payment (timing, discount)
paymenttermvalue varchar 40  √  null Key of the Payment Term
c_order_id numeric 10  √  null
c_order.c_order_id corder_iorder N
Order
documentno varchar 30  √  null Document sequence number of the document
dateordered timestamp 29,6  √  null Date of Order
dateacct timestamp 29,6  √  null Accounting Date
description varchar 255  √  null Optional short description of the record
m_product_id numeric 10  √  null
m_product.m_product_id mproduct_iorder N
Product, Service, Item
productvalue varchar 40  √  null Key of the Product
upc varchar 30  √  null Bar Code (Universal Product Code or its superset European Article Number)
sku varchar 30  √  null Stock Keeping Unit
c_tax_id numeric 10  √  null
c_tax.c_tax_id ctax_iorder N
Tax identifier
taxindicator varchar 10  √  null Short form for Tax to be printed on documents
taxamt numeric 0  √  0 Tax Amount for a document
c_orderline_id numeric 10  √  null
c_orderline.c_orderline_id corderline_iorder N
Sales Order Line
linedescription varchar 255  √  null Description of the Line
c_uom_id numeric 10  √  null
c_uom.c_uom_id cuom_iorder N
Unit of Measure
qtyordered numeric 0  √  0 Ordered Quantity
priceactual numeric 0  √  0 Actual Price
freightamt numeric 0  √  0 Freight Amount
c_campaign_id numeric 10  √  null
c_campaign.c_campaign_id ccampaign_iorder N
Marketing Campaign
c_charge_id numeric 10  √  null
c_charge.c_charge_id ccharge_iorder R
Additional document charges
chargename varchar 60  √  null Name of the Charge
c_ordersource_id numeric 10  √  NULL::numeric
c_ordersource.c_ordersource_id cordersource_iorder R
Order Source
c_ordersourcevalue varchar 40  √  NULL::character varying Order Source Key
deliveryrule bpchar 1  √  NULL::bpchar Defines the timing of Delivery
i_order_uu varchar 36  √  NULL::character varying I_Order_UU

Table contained 0 rows at 2024-01-03 13:44 +0100

Indexes:
Column(s) Type Sort Constraint Name
i_order_id Primary key Asc i_order_pkey
i_order_uu Must be unique Asc i_order_uu_idx


SchemaSpy was unable to generate a diagram of table relationships.
SchemaSpy requires Graphviz version 2.2.1 or versions greater than 2.4 from www.graphviz.org.