biuan SAP® BUSINESS ONE SDK
SQL Administration / Tax Code Determination / Tax Code Determination
DTW Tax Code Determination
API Tax Code Determinations Service / Tax Code Determination
OTCX - Tax Code Determination Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
DocEntry KEY UNIQUEInternal Document IDInt
11
PRIMARYYes
LineNumRow NumberInt
11
DocTypeDocument TypeInt
0
1) Service
2) Item & Service
11
BusAreaBusiness AreaInt
0
1) Purchase
2) Sales & Purchase
11
Cond1Condition 1Int
0
1) Federal Tax ID
2) Ship-To Address
3) Ship-To Street / PO Box
4) Ship-To City
5) Ship-To ZIP Code
6) Ship-To County
7) Ship-To State
8) Ship-To Country
9) Item
10) Item Group
11) Business Partner
12) Customer Group
13) Vendor Group
14) Warehouse
15) G/L Account
16) Customer Equalization tax
17) Tax Status
18) Freight
19) UDF
20) Branch
11
UDFTable1UDF Table NamenVarChar
20
NumVal1Numeric ValueInt
11
StrVal1String ValuenVarChar
64
MnyVal1Monetary ValueNum
20
Cond2Condition 2Int
0
1) Federal Tax ID
2) Ship-To Address
3) Ship-To Street / PO Box
4) Ship-To City
5) Ship-To ZIP Code
6) Ship-To County
7) Ship-To State
8) Ship-To Country
9) Item
10) Item Group
11) Business Partner
12) Customer Group
13) Vendor Group
14) Warehouse
15) G/L Account
16) Customer Equalization tax
17) Tax Status
18) Freight
19) UDF
20) Branch
11
UDFTable2UDF Table NamenVarChar
20
NumVal2Numeric ValueInt
11
StrVal2String ValuenVarChar
64
MnyVal2Monetary ValueNum
20
Cond3Condition 3Int
0
1) Federal Tax ID
2) Ship-To Address
3) Ship-To Street / PO Box
4) Ship-To City
5) Ship-To ZIP Code
6) Ship-To County
7) Ship-To State
8) Ship-To Country
9) Item
10) Item Group
11) Business Partner
12) Customer Group
13) Vendor Group
14) Warehouse
15) G/L Account
16) Customer Equalization tax
17) Tax Status
18) Freight
19) UDF
20) Branch
11
UdfTable3UDF Table NamenVarChar
20
NumVal3Numeric ValueInt
11
StrVal3String ValuenVarChar
64
MnyVal3Monetary ValueNum
20
Cond4Condition 4Int
0
1) Federal Tax ID
2) Ship-To Address
3) Ship-To Street / PO Box
4) Ship-To City
5) Ship-To ZIP Code
6) Ship-To County
7) Ship-To State
8) Ship-To Country
9) Item
10) Item Group
11) Business Partner
12) Customer Group
13) Vendor Group
14) Warehouse
15) G/L Account
16) Customer Equalization tax
17) Tax Status
18) Freight
19) UDF
20) Branch
11
UdfTable4UDF Table NamenVarChar
20
NumVal4Numeric ValueInt
11
StrVal4String ValuenVarChar
64
MnyVal4Monetary ValueNum
20
Cond5Condition 5Int
0
1) Federal Tax ID
2) Ship-To Address
3) Ship-To Street / PO Box
4) Ship-To City
5) Ship-To ZIP Code
6) Ship-To County
7) Ship-To State
8) Ship-To Country
9) Item
10) Item Group
11) Business Partner
12) Customer Group
13) Vendor Group
14) Warehouse
15) G/L Account
16) Customer Equalization tax
17) Tax Status
18) Freight
19) UDF
20) Branch
11
UdfTable5UDF Table NamenVarChar
20
NumVal5Numeric ValueInt
11
StrVal5String ValuenVarChar
64
MnyVal5Monetary ValueNum
20
DescrDescriptionnVarChar
127
LnTaxCodeLine Tax CodenVarChar
8
FrLnTaxLine Freight TaxnVarChar
8
FrHdrTaxHeader Freight TaxnVarChar
8
UDFAlias1UDF Field AliasnVarChar
18
UDFAlias2UDF Field AliasnVarChar
18
UDFAlias3UDF Field AliasnVarChar
18
UDFAlias4UDF Field AliasnVarChar
18
UDFAlias5UDF Field AliasnVarChar
18

SELECT statement

SELECT OTCX.DocEntry AS 'Internal Document ID', OTCX.LineNum AS 'Row Number', OTCX.DocType AS 'Document Type', OTCX.BusArea AS 'Business Area', OTCX.Cond1 AS 'Condition 1', OTCX.UDFTable1 AS 'UDF Table Name', OTCX.NumVal1 AS 'Numeric Value', OTCX.StrVal1 AS 'String Value', OTCX.MnyVal1 AS 'Monetary Value', OTCX.Cond2 AS 'Condition 2', OTCX.UDFTable2 AS 'UDF Table Name', OTCX.NumVal2 AS 'Numeric Value', OTCX.StrVal2 AS 'String Value', OTCX.MnyVal2 AS 'Monetary Value', OTCX.Cond3 AS 'Condition 3', OTCX.UdfTable3 AS 'UDF Table Name', OTCX.NumVal3 AS 'Numeric Value', OTCX.StrVal3 AS 'String Value', OTCX.MnyVal3 AS 'Monetary Value', OTCX.Cond4 AS 'Condition 4', OTCX.UdfTable4 AS 'UDF Table Name', OTCX.NumVal4 AS 'Numeric Value', OTCX.StrVal4 AS 'String Value', OTCX.MnyVal4 AS 'Monetary Value', OTCX.Cond5 AS 'Condition 5', OTCX.UdfTable5 AS 'UDF Table Name', OTCX.NumVal5 AS 'Numeric Value', OTCX.StrVal5 AS 'String Value', OTCX.MnyVal5 AS 'Monetary Value', OTCX.Descr AS 'Description', OTCX.LnTaxCode AS 'Line Tax Code', OTCX.FrLnTax AS 'Line Freight Tax', OTCX.FrHdrTax AS 'Header Freight Tax', OTCX.UDFAlias1 AS 'UDF Field Alias', OTCX.UDFAlias2 AS 'UDF Field Alias', OTCX.UDFAlias3 AS 'UDF Field Alias', OTCX.UDFAlias4 AS 'UDF Field Alias', OTCX.UDFAlias5 AS 'UDF Field Alias' FROM OTCX AS OTCX

Related information


Tax Code Determination TaxCodeDetermination Object· Table: OTCX
Represents the tax code determination rules according to which the application proposes tax codes in sales and purchasing document lines. Source table: OTCX.
   Parent: Tax Code Determinations Service TaxCodeDeterminationsService Service· Table: OTCX

Tax Code Determinations Service TaxCodeDeterminationsService Service· Table: OTCX
The TaxCodeDeterminationsService service enables you to add, look up, update, and remove tax code determination rules. For all localizations except Brazil, India, Israel and Puerto Rico, you can set up tax code determination rules that take...
SAP® Business One is the trademark(s) or registered trademark(s) of SAP AG in Germany and in several other countries. Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates