| PRIMARY KEY |
|
C_Tax_ID
NUMBER (10, 0) NOT NULL |
| |
|
|
AD_Client_ID
NUMBER (10, 0) NOT NULL |
| |
|
AD_Org_ID
NUMBER (10, 0) NOT NULL |
| |
|
IsActive
CHAR (1) default: 'Y' CHECK ( IsActive in ( 'Y' , 'N' )) NOT NULL |
| |
|
Created
DATE default: SYSDATE NOT NULL |
| |
|
CreatedBy
NUMBER (10, 0) NOT NULL |
| |
|
Updated
DATE default: SYSDATE NOT NULL |
| |
|
UpdatedBy
NUMBER (10, 0) NOT NULL |
| |
|
Name
NVARCHAR2 (60) NOT NULL |
| |
|
Description
NVARCHAR2 (255) |
| |
|
TaxIndicator
VARCHAR2 (5) |
Tax Indicator to print on Invoices, etc.
| |
|
IsDocumentLevel
CHAR (1) default: 'Y' CHECK ( IsDocumentLevel in ( 'Y' , 'N' )) NOT NULL |
| |
|
ValidFrom
DATE NOT NULL |
| |
|
IsSummary
CHAR (1) default: 'N' NOT NULL |
| |
|
RequiresTaxCertificate
CHAR (1) default: 'N' CHECK ( RequiresTaxCertificate in ( 'Y' , 'N' )) NOT NULL |
| |
|
Rate
NUMBER NOT NULL |
| |
|
Parent_Tax_ID
NUMBER (10, 0) |
| C_Tax |
|
C_Country_ID
NUMBER (10, 0) |
| C_Country |
|
C_Region_ID
NUMBER (10, 0) |
| C_Region |
|
To_Country_ID
NUMBER (10, 0) |
| C_Country |
|
To_Region_ID
NUMBER (10, 0) |
| C_Region |
|
C_TaxCategory_ID
NUMBER (10, 0) NOT NULL |
| C_TaxCategory |
|
IsDefault
CHAR (1) default: 'N' CHECK ( IsDefault in ( 'Y' , 'N' )) NOT NULL |
| |
|
IsTaxExempt
CHAR (1) default: 'N' CHECK ( IsTaxExempt in ( 'Y' , 'N' )) NOT NULL |
| |
|
SOPOType
CHAR (1) default: 'B' CHECK ( SOPOType in ( 'S' , 'P' , 'B' )) NOT NULL |
| |
FOREIGN KEY
C_Country_C_Tax: C_Country_ID => C_Country
C_CountryTo_C_Tax: To_Country_ID => C_Country
C_Region_C_Tax: C_Region_ID => C_Region
C_RegionTo_C_Tax: To_Region_ID => C_Region
CTax_Parent: Parent_Tax_ID => C_Tax
CTaxCategory_CTax: C_TaxCategory_ID => C_TaxCategory
|
REFERENCED BY
C_InvoiceLine,
C_InvoiceTax,
C_OrderLine,
C_OrderTax,
C_Tax,
C_Tax_Acct,
C_Tax_Trl,
Fact_Acct,
I_Invoice,
I_Order |
|