View source | Discuss this page | Page history | Printable version   
Toolbox
Main Page
Upload file
What links here
Recent changes
Help

PDF Books
Add page
Show collection (0 pages)
Collections help

Search

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


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.
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.
M_PriceList_ID Yes VARCHAR (32)

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

AD_Client_ID No VARCHAR (32) A Client is a company or a legal entity. You cannot share data between Clients.
AllowNegativeStock No CHAR (1) Allow negative stock
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
Groupacctinvlines No CHAR (1) Group Accounting Invoice Lines
Your_Company_Menu_Image Yes VARCHAR (32)
Your_Company_Big_Image Yes VARCHAR (32)
Your_Company_Document_Image Yes VARCHAR (32)
AD_Tree_Campaign_ID Yes VARCHAR (32)
AD_Tree_Asset_ID Yes VARCHAR (32) Asset Tree
AD_Tree_Product_Category_ID Yes VARCHAR (32) Product Category Tree
AD_Tree_Costcenter_ID Yes VARCHAR (32)
AD_Tree_Obre_Resource_Category 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
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.
M_ProductFreight_ID Yes VARCHAR (32)
AD_Tree_BPartner_ID Yes VARCHAR (32) Business Partner Tree
AD_Tree_Org_ID Yes VARCHAR (32) Organization Tree
AD_Tree_Menu_ID Yes VARCHAR (32) Tree Menu
Updated No TIMESTAMP (7) The Updated field indicates the date that this record was updated.
AD_Tree_Product_ID Yes VARCHAR (32) Product Tree
AD_Tree_SalesRegion_ID Yes VARCHAR (32)
AD_Tree_Project_ID Yes VARCHAR (32) Project Tree
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_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_Weight_ID Yes VARCHAR (32) The Standard UOM for Weight indicates the UOM to use for products referenced by weight 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.
Acct3_Active No CHAR (1) The Third Accounting Schema indicates an alternate set of rules to use for generating reports.
Acct2_Active No CHAR (1) The Second Accounting Schema indicates an alternate set of rules to use for generating reports.
C_AcctSchema3_ID Yes VARCHAR (32) An Accounting Schema defines the rules used in accounting such as costing method, currency and calendar
C_AcctSchema2_ID Yes VARCHAR (32) An Accounting Schema defines the rules used in accounting such as costing method, currency and calendar.
UpdatedBy No VARCHAR (32) The Updated By field indicates the user who updated this record.
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.
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.

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.
C_AcctSchema1_ID Yes VARCHAR (32) An Accounting Schema defines the rules used accounting such as costing method, currency and calendar.

Columns

Discount calculated from Line Amounts



top


Calendar


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

top


Price List


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

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


Allow Negative Stock



top


Check Order Organization



top


Check Shipment Organization



top


Group Invoice Lines in Accounting



top


Your Company Menu Image


Foreign key column to AD_Image table, (column: AD_Image_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


AD_Tree_Campaign_ID


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

top


Primary Tree Asset


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 Cost Center


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 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


Template B.Partner


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

top


Product for Freight


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

top


Primary Tree BPartner


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 Menu


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

top


Updated



top


Primary Tree Product


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 Tree Project


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

top


UOM for Time


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

top


UOM for Length


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


UOM for Volume


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

top


Enable Third Accounting Schema



top


Enable Second Accounting Schema



top


Third Accounting Schema


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

top


Second Accounting Schema


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

top


Updated By


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

top


Created By


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

top


Creation Date



top


Active



top


Organization


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

top


Primary Accounting Schema


Foreign key column to C_AcctSchema table, (column: C_AcctSchema_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 1,306 times. This page was last modified on 1 December 2016, at 02:14. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.