View idempiere9.adempiere.rv_asset_delivery
Asset Delivery

 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
a_asset_delivery_id numeric 10  √  null Delivery of Asset
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
a_asset_id numeric 10  √  null Asset used internally or by customers
a_asset_group_id numeric 10  √  null Group of Assets
m_product_id numeric 10  √  null Product, Service, Item
guaranteedate timestamp 29,6  √  null Date when guarantee expires
assetservicedate timestamp 29,6  √  null Date when Asset was put into service
c_bpartner_id numeric 10  √  null Identifies a Business Partner
ad_user_id numeric 10  √  null User within the system - Internal or Business Partner Contact
movementdate timestamp 29,6  √  null Date a product was moved in or out of inventory
serno varchar 40  √  null Product Serial Number
lot varchar 40  √  null Lot number (alphanumeric)
versionno varchar 20  √  null Version Number
m_inoutline_id numeric 10  √  null Line on Shipment or Receipt document
email varchar 60  √  null Electronic Mail Address
messageid varchar 120  √  null EMail Message ID
deliveryconfirmation varchar 120  √  null EMail Delivery confirmation
url varchar 120  √  null Full URL address - e.g. http://www.idempiere.org
remote_addr varchar 60  √  null Remote Address
remote_host varchar 60  √  null Remote host Info
referrer varchar 255  √  null Referring web address
description varchar 255  √  null Optional short description of the record

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