View source | Discuss this page | Page history | Printable version   

ERP/3.0/Developers Guide/Database Model/org.openbravo.model.ad.system/AD ClientInfo

This article is protected against manual editing because it is automatically generated from Openbravo meta-data. Learn more about writing and translating such documents.
Back button.png   Back to ERP/3.0/Developers Guide/Database Model/org.openbravo.model.ad.system


Contents

AD_ClientInfo

This table contains the following columns:

Name Nullable Data Type Description


AD_Tree_Campaign_ID Yes VARCHAR (32)
IsActive No CHAR (1) There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reporting. There are two reasons for de-activating and not deleting records:

(1) The system requires the record for auditing purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are existing invoices for it. By de-activating the Business Partner you prevent it from being used in future transactions.

AllowNegativeStock No CHAR (1) Allow negative stock
C_Extbp_Config_ID Yes VARCHAR (32) Configuration to connect to the CRM system API, and which also defines the properties and filters used by Openbravo to map with the external system information.
C_Extbp_Enabled No CHAR (1) It allows to configure an integration with an external CRM system
C_Calendar_ID Yes VARCHAR (32) The Calendar uniquely identifies an accounting calendar. Multiple calendars can be used. For example you may need a standard calendar that runs from Jan 1 to Dec 31 and a fiscal calendar that runs from July 1 to June 30.
Checkorderorg No CHAR (1) The checkorderorg identifies the order organization and the business partner organization and makes sure both are the same.
Checkinoutorg No CHAR (1) The Checkinoutorg identifies the shipment organization and the business partner organization and makes sure both are the same
AD_Client_ID No VARCHAR (32) A Client is a company or a legal entity. You cannot share data between Clients.
Company_Logo Yes VARCHAR (32) This logo will be used in the login screen and inside all Openbravo applications
Company_Logo_Dark Yes VARCHAR (32) This logo will be used in the login screen and inside all Openbravo applications when they use

a Dark theme. Note that this logo should have different colors or more contrast than the original logo in order to be seen properly in a dark background.

Company_Logo_For_Docs Yes VARCHAR (32) Company Logo used to be printed in invoices or other documents
Company_Logo_For_Receipts Yes VARCHAR (32) Company Logo used to be printed in receipts. Usually those receipts are printed using only black ink, so this logo should be adapted to be able to print it properly using only one ink.
Company_Logo_Submark Yes VARCHAR (32) The submark logo is a simplified version of the Company Logo which is consistent with your brand and can be used to replace the Company Logo in places where this logo does not fit, such as in an application in a narrow screen where the Company Logo has no room to be showed properly
Company_Logo_Submark_Dark Yes VARCHAR (32) The submark logo is a simplified version of the Company Logo which is consistent with your brand and can be used to replace the Company Logo in places where this logo does not fit, such as in an application on a narrow screen where the Company Logo has no room to be showed properly. Note that this logo should have different colors or more contrast than the original logo in order to be seen properly over a dark background.
CreatedBy No VARCHAR (32) The Created By field indicates the user who created this record.
Created No TIMESTAMP (7) The Created field indicates the date that this record was created.
IsDiscountLineAmt No CHAR (1) If the payment discount is calculated from line amounts only, the tax and charge amounts are not included. This is e.g. business practice in the US. If not selected the total invoice amount is used to calculate the payment discount.
Acct2_Active No CHAR (1) The Second Accounting Schema indicates an alternate set of rules to use for generating reports.
Acct3_Active No CHAR (1) The Third Accounting Schema indicates an alternate set of rules to use for generating reports.
Groupacctinvlines No CHAR (1) Group Accounting Invoice Lines
AD_Org_ID No VARCHAR (32) An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations.
M_PriceList_ID Yes VARCHAR (32)

Price Lists are used to determine the pricing, margin and cost of items purchased or sold.

C_AcctSchema1_ID Yes VARCHAR (32) An Accounting Schema defines the rules used accounting such as costing method, currency and calendar.
AD_Tree_Asset_ID Yes VARCHAR (32) Asset Tree
AD_Tree_BPartner_ID Yes VARCHAR (32) Business Partner Tree
AD_Tree_Costcenter_ID Yes VARCHAR (32)
AD_Tree_Menu_ID Yes VARCHAR (32) Tree Menu
AD_Tree_Org_ID Yes VARCHAR (32) Organization Tree
AD_Tree_Product_ID Yes VARCHAR (32) Product Tree
AD_Tree_Product_Category_ID Yes VARCHAR (32) Product Category Tree
AD_Tree_Project_ID Yes VARCHAR (32) Project Tree
AD_Tree_Obre_Resource_Category Yes VARCHAR (32)
AD_Tree_SalesRegion_ID Yes VARCHAR (32)
AD_Tree_User1_ID Yes VARCHAR (32) Primary User Dimension 1
AD_Tree_User2_ID Yes VARCHAR (32) Primary User Dimension 2
M_ProductFreight_ID Yes VARCHAR (32)
C_AcctSchema2_ID Yes VARCHAR (32) An Accounting Schema defines the rules used in accounting such as costing method, currency and calendar.
C_BPartnerCashTrx_ID Yes VARCHAR (32) When creating a new Business Partner from the Business Partner Search Field (right-click: Create), the selected business partner is used as a template, e.g. to define price list, payment terms, etc.
C_AcctSchema3_ID Yes VARCHAR (32) An Accounting Schema defines the rules used in accounting such as costing method, currency and calendar
C_UOM_Length_ID Yes VARCHAR (32) The Standard UOM for Length indicates the UOM to use for products referenced by length in a document.
C_UOM_Time_ID Yes VARCHAR (32) The Standard UOM for Time indicates the UOM to use for products referenced by time in a document.
C_UOM_Volume_ID Yes VARCHAR (32) The Standard UOM for Volume indicates the UOM to use for products referenced by volume in a document.
C_UOM_Weight_ID Yes VARCHAR (32) The Standard UOM for Weight indicates the UOM to use for products referenced by weight in a document.
Updated No TIMESTAMP (7) The Updated field indicates the date that this record was updated.
UpdatedBy No VARCHAR (32) The Updated By field indicates the user who updated this record.
Your_Company_Big_Image Yes VARCHAR (32)
Your_Company_Document_Image Yes VARCHAR (32)
Your_Company_Menu_Image Yes VARCHAR (32)

Columns

AD_Tree_Campaign_ID


Foreign key column to AD_Tree table, (column: AD_Tree_ID)

top


Active



top


Allow Negative Stock



top


C_Extbp_Config_ID


Foreign key column to C_ExtBP_Config table, (column: C_Extbp_Config_ID)

top


C_Extbp_Enabled



top


Calendar


Foreign key column to C_Calendar table, (column: C_Calendar_ID)

top


Check Order Organization



top


Check Shipment Organization



top


Client

Foreign key column to AD_Client table, (column: AD_Client_ID) It has a validation "AD_Client Security validation", with the following code

AD_Client.AD_Client_ID in (@#User_Client@)

top



Foreign key column to AD_Image table, (column: AD_Image_ID)

top


Company_Logo_Dark


Foreign key column to AD_Image table, (column: AD_Image_ID)

top


Company_Logo_For_Docs


Foreign key column to AD_Image table, (column: AD_Image_ID)

top


Company_Logo_For_Receipts


Foreign key column to AD_Image table, (column: AD_Image_ID)

top


Company_Logo_Submark


Foreign key column to AD_Image table, (column: AD_Image_ID)

top


Company_Logo_Submark_Dark


Foreign key column to AD_Image table, (column: AD_Image_ID)

top


Created By


Foreign key column to AD_User table, (column: AD_User_ID)

top


Creation Date



top


Discount calculated from Line Amounts



top


Enable Second Accounting Schema



top


Enable Third Accounting Schema



top


Group Invoice Lines in Accounting



top


Organization


Foreign key column to AD_Org table, (column: AD_Org_ID)

top


Price List


Foreign key column to M_PriceList table, (column: M_PriceList_ID)

top


Primary Accounting Schema


Foreign key column to C_AcctSchema table, (column: C_AcctSchema_ID)

top


Primary Tree Asset


Foreign key column to AD_Tree table, (column: AD_Tree_ID)

top


Primary Tree BPartner


Foreign key column to AD_Tree table, (column: AD_Tree_ID)

top


Primary Tree Cost Center


Foreign key column to AD_Tree table, (column: AD_Tree_ID)

top


Primary Tree Menu


Foreign key column to AD_Tree table, (column: AD_Tree_ID)

top


Primary Tree Organization


Foreign key column to AD_Tree table, (column: AD_Tree_ID)

top


Primary Tree Product


Foreign key column to AD_Tree table, (column: AD_Tree_ID)

top


Primary Tree Product Category


Foreign key column to AD_Tree table, (column: AD_Tree_ID)

top


Primary Tree Project


Foreign key column to AD_Tree table, (column: AD_Tree_ID)

top


Primary Tree Resource Category


Foreign key column to AD_Tree table, (column: AD_Tree_ID)

top


Primary Tree Sales Region


Foreign key column to AD_Tree table, (column: AD_Tree_ID)

top


Primary User Dimension 1


Foreign key column to AD_Tree table, (column: AD_Tree_ID)

top


Primary User Dimension 2


Foreign key column to AD_Tree table, (column: AD_Tree_ID)

top


Product for Freight


Foreign key column to M_Product table, (column: M_Product_ID)

top


Second Accounting Schema


Foreign key column to C_AcctSchema table, (column: C_AcctSchema_ID)

top


Template B.Partner


Foreign key column to C_BPartner table, (column: C_BPartner_ID)

top


Third Accounting Schema


Foreign key column to C_AcctSchema table, (column: C_AcctSchema_ID)

top


UOM for Length


Foreign key column to C_UOM table, (column: C_UOM_ID)

top


UOM for Time


Foreign key column to C_UOM table, (column: C_UOM_ID)

top


UOM for Volume


Foreign key column to C_UOM table, (column: C_UOM_ID)

top


UOM for Weight


Foreign key column to C_UOM table, (column: C_UOM_ID)

top


Updated



top


Updated By


Foreign key column to AD_User table, (column: AD_User_ID)

top


Your Company Big Image


Foreign key column to AD_Image table, (column: AD_Image_ID)

top


Your Company Document Image


Foreign key column to AD_Image table, (column: AD_Image_ID)

top


Your Company Menu Image


Foreign key column to AD_Image table, (column: AD_Image_ID)

top


Other Info

Check Constraints

These are the check constraints for this table:

top

Back button.png   Back to org.openbravo.model.ad.system

Retrieved from "http://wiki.openbravo.com/wiki/ERP/3.0/Developers_Guide/Database_Model/org.openbravo.model.ad.system/AD_ClientInfo"

This page has been accessed 4,259 times. This page was last modified on 6 February 2023, at 01:40. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.