Skip to main content

Window: Tax Category

[Created: 09/08/1999 - Updated: 02/01/2000 ]
Description: Maintain Tax Categories
Help: The Tax Category Window is used to enter and maintain Tax Categories. Each product is associated with a tax category which facilitates reacting changing tax rates.

Tab: Tax Category

[Created: 09/08/1999 - Updated: 03/03/2008 ]
Description: Tax Category
Help: The Tax Category Tab is used to define and maintain Tax Categories. Each Product is associated with a Tax Category. This facilitates adapting to changes in taxation.
Tab Level: 0

Table 10: Tax Category - Fields

Table: Report Parameters

NameDescriptionHelpTechnical Info
TenantTenant for this installation.A Tenant is a company or a legal entity. You cannot share data between Tenants.c_taxcategory.AD_Client_ID numeric(10)
Table Direct
OrganizationOrganizational entity within tenantAn organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations.c_taxcategory.AD_Org_ID numeric(10)
Table Direct
NameAlphanumeric identifier of the entityThe name of an entity (record) is used as an default search option in addition to the search key. The name is up to 60 characters in length.c_taxcategory.Name character varying(60)
String
DescriptionOptional short description of the recordA description is limited to 255 characters.c_taxcategory.Description character varying(255)
String
ActiveThe record is active in the systemThere 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 reports.There are two reasons for de-activating and not deleting records:(1) The system requires the record for audit purposes.(2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries.c_taxcategory.IsActive character(1)
Yes-No
DefaultDefault valueThe Default Checkbox indicates if this record will be used as a default value.c_taxcategory.IsDefault character(1)
Yes-No

Tab: Tax Rate

[Created: 18/10/2023 - Updated: 18/10/2023 ]
Description:
Help:
Tab Level: 1

Table 15: Tax Rate - Fields

Table: Report Parameters

NameDescriptionHelpTechnical Info
TenantTenant for this installation.A Tenant is a company or a legal entity. You cannot share data between Tenants.c_tax.AD_Client_ID numeric(10)
Table Direct
OrganizationOrganizational entity within tenantAn organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations.c_tax.AD_Org_ID numeric(10)
Table Direct
NameAlphanumeric identifier of the entityThe name of an entity (record) is used as an default search option in addition to the search key. The name is up to 60 characters in length.c_tax.Name character varying(60)
String
DescriptionOptional short description of the recordA description is limited to 255 characters.c_tax.Description character varying(255)
String
ActiveThe record is active in the systemThere 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 reports.There are two reasons for de-activating and not deleting records:(1) The system requires the record for audit purposes.(2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries.c_tax.IsActive character(1)
Yes-No
DefaultDefault valueThe Default Checkbox indicates if this record will be used as a default value.c_tax.IsDefault character(1)
Yes-No
Tax CategoryTax CategoryThe Tax Category provides a method of grouping similar taxes. For example, Sales Tax or Value Added Tax.c_tax.C_TaxCategory_ID numeric(10)
Table Direct
Valid fromValid from including this date (first day)The Valid From date indicates the first day of a date rangec_tax.ValidFrom timestamp without time zone
Date
SO Tax exemptBusiness partner is exempt from tax on salesIf a business partner is exempt from tax on sales, the exempt tax rate is used. For this, you need to set up a tax rate with a 0% rate and indicate that this is your tax exempt rate. This is required for tax reporting, so that you can track tax exempt transactions.c_tax.IsTaxExempt character(1)
Yes-No
Requires Tax CertificateThis tax rate requires the Business Partner to be tax exemptThe Requires Tax Certificate indicates that a tax certificate is required for a Business Partner to be tax exempt.c_tax.RequiresTaxCertificate character(1)
Yes-No
Document LevelTax is calculated on document level (rather than line by line)If the tax is calculated on document level, all lines with that tax rate are added before calculating the total tax for the document.Otherwise the tax is calculated per line and then added.Due to rounding, the tax amount can differ.c_tax.IsDocumentLevel character(1)
Yes-No
Sales TaxThis is a sales tax (i.e. not a value added tax)If selected AP tax is handled as expense, otherwise it is handled as a VAT credit.c_tax.IsSalesTax character(1)
Yes-No
Summary LevelThis is a summary entityA summary entity represents a branch in a tree rather than an end-node. Summary entities are used for reporting and do not have own values.c_tax.IsSummary character(1)
Yes-No
Parent TaxParent Tax indicates a tax that is made up of multiple taxesThe Parent Tax indicates a tax that is a reference for multiple taxes. This allows you to charge multiple taxes on a document by entering the Parent Taxc_tax.Parent_Tax_ID numeric(10)
Table
SO/PO TypeSales Tax applies to sales situations, Purchase Tax to purchase situationsSales Tax: charged when selling - examples: Sales Tax, Output VAT (payable)Purchase Tax: tax charged when purchasing - examples: Use Tax, Input VAT (receivable)c_tax.SOPOType character(1)
List
Tax IndicatorShort form for Tax to be printed on documentsThe Tax Indicator identifies the short name that will print on documents referencing this tax.c_tax.TaxIndicator character varying(10)
String
RateRate or Tax or ExchangeThe Rate indicates the percentage to be multiplied by the source to arrive at the tax or exchange amount.c_tax.Rate numeric
Number
Posting IndicatorType of input tax (deductible and non deductible)Separate Tax Posting: Tax is calculated on the full amount of the item and posted separately.Distribute Tax with Relevant Expense: Tax amount is added to the item amount during account posting time and for updating of Product Cost.c_tax.TaxPostingIndicator character(1)
List
Country Groupc_tax.C_CountryGroupFrom_ID numeric(10)
Table
Toc_tax.C_CountryGroupTo_ID numeric(10)
Table
CountryCountryThe Country defines a Country. Each Country must be defined before it can be used in any document.c_tax.C_Country_ID numeric(10)
Table
ToReceiving CountryThe To Country indicates the receiving country on a documentc_tax.To_Country_ID numeric(10)
Table
RegionIdentifies a geographical RegionThe Region identifies a unique Region for this Country.c_tax.C_Region_ID numeric(10)
Table
ToReceiving RegionThe To Region indicates the receiving region on a documentc_tax.To_Region_ID numeric(10)
Table
Tax Providerc_tax.C_TaxProvider_ID numeric(10)
Table Direct

Tab: Translation

[Created: 19/03/2000 - Updated: 27/10/2024 ]
Description:
Help:
Tab Level: 1

Table 20: Translation - Fields

Table: Report Parameters

NameDescriptionHelpTechnical Info
TenantTenant for this installation.A Tenant is a company or a legal entity. You cannot share data between Tenants.c_taxcategory_trl.AD_Client_ID numeric(10)
Table Direct
OrganizationOrganizational entity within tenantAn organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations.c_taxcategory_trl.AD_Org_ID numeric(10)
Table Direct
Tax CategoryTax CategoryThe Tax Category provides a method of grouping similar taxes. For example, Sales Tax or Value Added Tax.c_taxcategory_trl.C_TaxCategory_ID numeric(10)
Table Direct
LanguageLanguage for this entityThe Language identifies the language to use for display and formattingc_taxcategory_trl.AD_Language character varying(6)
Table
ActiveThe record is active in the systemThere 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 reports.There are two reasons for de-activating and not deleting records:(1) The system requires the record for audit purposes.(2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries.c_taxcategory_trl.IsActive character(1)
Yes-No
TranslatedThis column is translatedThe Translated checkbox indicates if this column is translated.c_taxcategory_trl.IsTranslated character(1)
Yes-No
NameAlphanumeric identifier of the entityThe name of an entity (record) is used as an default search option in addition to the search key. The name is up to 60 characters in length.c_taxcategory_trl.Name character varying(60)
String
DescriptionOptional short description of the recordA description is limited to 255 characters.c_taxcategory_trl.Description character varying(255)
String