ERP 2.50:Developers Guide/Database Model/org.openbravo.model.ad.system/AD ClientInfo
AD_ClientInfo
The Client Info Tab defines the details for each client. The accounting rules and high level defaults are defined here. The Calendar is used to determine if a period is open or closed.
- Name:ClientInformation
- Classname:ClientInformation
This table contains the following columns:
Name | Nullable | Data Type | Description |
AD_Client_ID | N | VARCHAR2(32) | Client for this installation. |
AD_Org_ID | N | VARCHAR2(32) | Organizational entity within client |
IsActive | N | CHAR(1) | A flag indicating whether this record is available for use or de-activated. |
Created | N | DATE | The date that this record is completed. |
CreatedBy | N | VARCHAR2(32) | User who created this records |
Updated | N | DATE | x not implemented |
UpdatedBy | N | VARCHAR2(32) | User who updated this records |
IsDiscountLineAmt | N | CHAR(1) | Payment Discount calculation does not include Taxes and Charges |
C_Calendar_ID | Y | VARCHAR2(32) | A table showing the days of the week for each month of the year. |
C_AcctSchema1_ID | Y | VARCHAR2(32) | Primary rules for accounting |
Acct2_Active | N | CHAR(1) | For parallel reporting using different accounting currency or field selection |
C_AcctSchema2_ID | Y | VARCHAR2(32) | Secondary rules for accounting |
Acct3_Active | N | CHAR(1) | For parallel reporting using different accounting currency or field selection |
C_AcctSchema3_ID | Y | VARCHAR2(32) | Terceary rules for accounting |
C_UOM_Volume_ID | Y | VARCHAR2(32) | Standard Unit of Measure for Volume |
C_UOM_Weight_ID | Y | VARCHAR2(32) | Standard Unit of Measure for Weight |
C_UOM_Length_ID | Y | VARCHAR2(32) | Standard Unit of Measure for Length |
C_UOM_Time_ID | Y | VARCHAR2(32) | Standard Unit of Measure for Time |
AD_Tree_Menu_ID | Y | VARCHAR2(32) | Tree Menu |
AD_Tree_Org_ID | Y | VARCHAR2(32) | Organization Tree |
AD_Tree_BPartner_ID | Y | VARCHAR2(32) | Business Partner Tree |
AD_Tree_Project_ID | Y | VARCHAR2(32) | Project Tree |
AD_Tree_SalesRegion_ID | Y | VARCHAR2(32) | null |
AD_Tree_Product_ID | Y | VARCHAR2(32) | Product Tree |
M_ProductFreight_ID | Y | VARCHAR2(32) | null |
C_BPartnerCashTrx_ID | Y | VARCHAR2(32) | Business Partner used for creating new Business Partners on the fly |
M_PriceList_ID | Y | VARCHAR2(32) | A catalog of selected items with prices defined generally or for a specific partner. |
AllowNegativeStock | N | CHAR(1) | Allow negative stock |
Checkorderorg | N | CHAR(1) | The checkorderorg identifies the order organization and the business partner organization |
Checkinoutorg | N | CHAR(1) | The Checkinoutorg identifies the shipment organization and the business partner organization. |
Groupacctinvlines | N | CHAR(1) | Group Accounting Invoice Lines |
Your_Company_Menu_Image | Y | VARCHAR2(32) | null |
Your_Company_Big_Image | Y | VARCHAR2(32) | null |
Your_Company_Document_Image | Y | VARCHAR2(32) | null |
Other Info
Check constraints
These are the check constraints for this table:
- AD_CLIENTINFO_ACCT2_ACTIVE_CHK: ACCT2_ACTIVE IN ('Y', 'N')
- AD_CLIENTINFO_ACCT3_ACTIVE_CHK: ACCT3_ACTIVE IN ('Y', 'N')
- AD_CLIENTINFO_ALLOWNEGATIV_CHK: ALLOWNEGATIVESTOCK IN ('Y', 'N')
- AD_CLIENTINFO_CHECKINOUTOR_CHK: CHECKINOUTORG IN ('Y', 'N')
- AD_CLIENTINFO_CHECKORDEROR_CHK: CHECKORDERORG IN ('Y', 'N')
- AD_CLIENTINFO_ISACTIVE_CHK: ISACTIVE IN ('Y', 'N')
- AD_CLIENTINFO_ISDISCOUNTLI_CHK: ISDISCOUNTLINEAMT IN ('Y', 'N')
Indexes
These are the indexes for this table (for each index there is a list of all the columns included within it):
Unique
- AD_CLIENTINFO_KEY
Columns
Client
- Physical column name: AD_Client_ID
- Property Name: client
- Reference: TableDir
- Default value: @AD_Client_ID@
- This column is part of the table's identifier
- This column is a child for a buisiness object (is Parent)
Foreign key column to AD_Client table, (column: AD_Client_ID)
Validation Rule AD_Client Security validation: Clients with user access rights. With the following code:
AD_Client.AD_Client_ID IN (@#User_Client@)
Organization
- Physical column name: AD_Org_ID
- Property Name: organization
- Reference: TableDir
- Default value: @AD_Org_ID@
Foreign key column to AD_Org table, (column: AD_Org_ID)
Active
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.
- Physical column name: IsActive
- Property Name: active
- Reference: YesNo
- Default value: Y
Creation Date
The Created field indicates the date that this record was created.
- Physical column name: Created
- Property Name: creationDate
- Reference: DateTime
Created By
- Physical column name: CreatedBy
- Property Name: createdBy
- Reference: Search
Foreign key column to AD_User table, (column: AD_User_ID)
Updated
The Updated field indicates the date that this record was updated.
- Physical column name: Updated
- Property Name: updated
- Reference: DateTime
Updated By
- Physical column name: UpdatedBy
- Property Name: updatedBy
- Reference: Search
Foreign key column to AD_User table, (column: AD_User_ID)
Discount calculated from Line Amounts
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.
- Physical column name: IsDiscountLineAmt
- Property Name: discountCalculatedFromLineAmounts
- Reference: YesNo
Calendar
- Physical column name: C_Calendar_ID
- Property Name: calendar
- Reference: TableDir
Foreign key column to C_Calendar table, (column: C_Calendar_ID)
Primary Accounting Schema
- Physical column name: C_AcctSchema1_ID
- Property Name: primaryAccountingSchema
- Reference: Table
Foreign key column to C_AcctSchema table, (column: C_AcctSchema_ID)
Reference Table C_AcctSchema
Enable Second Accounting Schema
The Second Accounting Schema indicates an alternate set of rules to use for generating reports.
- Physical column name: Acct2_Active
- Property Name: enableSecondAccountingSchema
- Reference: YesNo
Second Accounting Schema
- Physical column name: C_AcctSchema2_ID
- Property Name: secondAccountingSchema
- Reference: Table
Foreign key column to C_AcctSchema table, (column: C_AcctSchema_ID)
Reference Table C_AcctSchema
Enable Third Accounting Schema
The Third Accounting Schema indicates an alternate set of rules to use for generating reports.
- Physical column name: Acct3_Active
- Property Name: enableThirdAccountingSchema
- Reference: YesNo
Third Accounting Schema
- Physical column name: C_AcctSchema3_ID
- Property Name: thirdAccountingSchema
- Reference: Table
Foreign key column to C_AcctSchema table, (column: C_AcctSchema_ID)
Reference Table C_AcctSchema
UOM for Volume
- Physical column name: C_UOM_Volume_ID
- Property Name: uOMForVolume
- Reference: Table
Foreign key column to C_UOM table, (column: C_UOM_ID)
Reference Table C_UOM
UOM for Weight
- Physical column name: C_UOM_Weight_ID
- Property Name: uOMForWeight
- Reference: Table
Foreign key column to C_UOM table, (column: C_UOM_ID)
Reference Table C_UOM
UOM for Length
- Physical column name: C_UOM_Length_ID
- Property Name: uOMForLength
- Reference: Table
Foreign key column to C_UOM table, (column: C_UOM_ID)
Reference Table C_UOM
UOM for Time
- Physical column name: C_UOM_Time_ID
- Property Name: uOMForTime
- Reference: Table
Foreign key column to C_UOM table, (column: C_UOM_ID)
Reference Table C_UOM
Primary Tree Menu
- Physical column name: AD_Tree_Menu_ID
- Property Name: primaryTreeMenu
- Reference: Table
Foreign key column to AD_Tree table, (column: AD_Tree_ID)
Reference Table AD_Tree
Primary Tree Organization
- Physical column name: AD_Tree_Org_ID
- Property Name: primaryTreeOrganization
- Reference: Table
Foreign key column to AD_Tree table, (column: AD_Tree_ID)
Reference Table AD_Tree
Primary Tree BPartner
- Physical column name: AD_Tree_BPartner_ID
- Property Name: primaryTreeBPartner
- Reference: Table
Foreign key column to AD_Tree table, (column: AD_Tree_ID)
Reference Table AD_Tree
Primary Tree Project
- Physical column name: AD_Tree_Project_ID
- Property Name: primaryTreeProject
- Reference: Table
Foreign key column to AD_Tree table, (column: AD_Tree_ID)
Reference Table AD_Tree
Primary Tree Sales Region
- Physical column name: AD_Tree_SalesRegion_ID
- Property Name: primaryTreeSalesRegion
- Reference: Table
Foreign key column to AD_Tree table, (column: AD_Tree_ID)
Reference Table AD_Tree
Primary Tree Product
- Physical column name: AD_Tree_Product_ID
- Property Name: primaryTreeProduct
- Reference: Table
Foreign key column to AD_Tree table, (column: AD_Tree_ID)
Reference Table AD_Tree
Product for Freight
- Physical column name: M_ProductFreight_ID
- Property Name: productForFreight
- Reference: Table
Foreign key column to M_Product table, (column: M_Product_ID)
Reference Table M_Product (no summary) With the following where clause:
M_Product.IsSummary='N'
Template B.Partner
- Physical column name: C_BPartnerCashTrx_ID
- Property Name: templateBPartner
- Reference: Table
Foreign key column to C_BPartner table, (column: C_BPartner_ID)
Reference Table C_BPartner With the following where clause:
C_BPartner.IsSummary='N'
Price List
- Physical column name: M_PriceList_ID
- Property Name: priceList
- Reference: TableDir
Foreign key column to M_PriceList table, (column: M_PriceList_ID)
Allow Negative Stock
Allow negative stock
- Physical column name: AllowNegativeStock
- Property Name: allowNegativeStock
- Reference: YesNo
- Default value: Y
Check Order Organization
The checkorderorg identifies the order organization and the business partner organization and makes sure both are the same.
- Physical column name: Checkorderorg
- Property Name: checkOrderOrganization
- Reference: YesNo
- Default value: Y
Check Shipment Organization
The Checkinoutorg identifies the shipment organization and the business partner organization and makes sure both are the same
- Physical column name: Checkinoutorg
- Property Name: checkShipmentOrganization
- Reference: YesNo
- Default value: Y
Group Invoice Lines in Accounting
Group Accounting Invoice Lines
- Physical column name: Groupacctinvlines
- Property Name: groupInvoiceLinesInAccounting
- Reference: YesNo
- Default value: N
Your Company Menu Image
- Physical column name: Your_Company_Menu_Image
- Property Name: yourCompanyMenuImage
- Reference: Image BLOB
Your Company Big Image
- Physical column name: Your_Company_Big_Image
- Property Name: yourCompanyBigImage
- Reference: Image BLOB
Your Company Document Image
- Physical column name: Your_Company_Document_Image
- Property Name: yourCompanyDocumentImage
- Reference: Image BLOB