View idempiere9.adempiere.dd_order_header_v
DD_Order_Header_v

Generated by
Quality Systems & Solutions
Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
ad_client_id numeric 10  √  null Client/Tenant for this installation.
ad_org_id numeric 10  √  null Organizational entity within client
isactive bpchar 1  √  null The record is active in the system
created timestamp 29,6  √  null Date this record was created
createdby numeric 10  √  null User who created this records
updated timestamp 29,6  √  null Date this record was updated
updatedby numeric 10  √  null User who updated this records
ad_language varchar 6  √  null Language for this entity
dd_order_id numeric 10  √  null Distribution Order
c_order_id numeric 10  √  null Order
issotrx bpchar 1  √  null This is a Sales Transaction
documentno varchar 30  √  null Document sequence number of the document
docstatus bpchar 2  √  null The current status of the document
c_doctype_id numeric 10  √  null Document type or rules
c_bpartner_id numeric 10  √  null Identifies a Business Partner
bpvalue varchar 40  √  null Business Partner Key Value
bptaxid varchar 20  √  null Tax ID of the Business Partner
naics varchar 6  √  null Standard Industry Code or its successor NAIC - http://www.osha.gov/oshstats/sicser.html
duns varchar 11  √  null Dun & Bradstreet Number
org_location_id numeric 10  √  null Organization Location/Address
taxid varchar 20  √  null Tax Identification
m_warehouse_id numeric 10  √  null Storage Warehouse and Service Point
warehouse_location_id numeric 10  √  null Warehouse Location/Address
documenttype varchar 60  √  null Document Type
documenttypenote varchar 2000  √  null Optional note of a document type
salesrep_id numeric 10  √  null Sales Representative or Company Agent
salesrep_name varchar 2147483647  √  null Sales Representative
dateordered timestamp 29,6  √  null Date of Order
datepromised timestamp 29,6  √  null Date Order was promised
bpgreeting varchar 60  √  null Greeting for Business Partner
name varchar 120  √  null Alphanumeric identifier of the entity
name2 varchar 60  √  null Additional Name
bpcontactgreeting varchar 60  √  null Greeting for Business Partner Contact
title varchar 40  √  null Name this entity is referred to as
phone varchar 40  √  null Identifies a telephone number
contactname text 2147483647  √  null Business Partner Contact Name
c_location_id numeric 10  √  null Location or Address
postal text 2147483647  √  null Postal code
referenceno varchar 40  √  null Your customer or vendor number at the Business Partner's site
description varchar 255  √  null Optional short description of the record
poreference varchar 20  √  null Transaction Reference Number (Sales Order, Purchase Order) of your Business Partner
c_charge_id numeric 10  √  null Additional document charges
chargeamt numeric 0  √  null Charge Amount
volume numeric 0  √  null Volume of a product
weight numeric 0  √  null Weight of a product
c_campaign_id numeric 10  √  null Marketing Campaign
c_project_id numeric 10  √  null Financial Project
c_activity_id numeric 10  √  null Business Activity
m_shipper_id numeric 10  √  null Method or manner of product delivery
deliveryrule bpchar 1  √  null Defines the timing of Delivery
deliveryviarule bpchar 1  √  null How the order will be delivered
priorityrule bpchar 1  √  null Priority of a document
logo_id numeric 10  √  null Logo

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