biuan SAP® BUSINESS ONE SDK
DTW Inventory / Item Management / Batches / Business Partner Catalog Numbers
API TCD1
TCD1 - Key Fields for Determination Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsId KEY UNIQUEInternal NumberInt
11
PRIMARYYes
TcdId KEY UNIQUETax Determination CodeInt
11OTCD
Tax Code Determination
TCD1_UNIYes
KeyFld_1Key Fields 1Int
11
0
KeyFld_2Key Fields 2Int
11
0
KeyFld_3Key Fields 3Int
11
0
PriorityPriorityInt
11
0
DescrDescriptionnVarChar
100
KeyFld_4Key Fields 4Int
11
0
UDFTable_1UDF Table Name 1nVarChar
20
UDFAlias_1UDF Field Alias 1nVarChar
18
UDFTable_2UDF Table Name 2nVarChar
20
UDFAlias_2UDF Field Alias 2nVarChar
18
UDFTable_3UDF Table Name 3nVarChar
20
UDFAlias_3UDF Field Alias 3nVarChar
18
UDFTable_4UDF Table Name 4nVarChar
20
UDFAlias_4UDF Field Alias 4nVarChar
18

Table relationship map

SELECT statement

SELECT TCD1.AbsId AS 'Internal Number', TCD1.TcdId AS 'Tax Determination Code', TCD1.KeyFld_1 AS 'Key Fields 1', TCD1.KeyFld_2 AS 'Key Fields 2', TCD1.KeyFld_3 AS 'Key Fields 3', TCD1.Priority AS 'Priority', TCD1.Descr AS 'Description', TCD1.KeyFld_4 AS 'Key Fields 4', TCD1.UDFTable_1 AS 'UDF Table Name 1', TCD1.UDFAlias_1 AS 'UDF Field Alias 1', TCD1.UDFTable_2 AS 'UDF Table Name 2', TCD1.UDFAlias_2 AS 'UDF Field Alias 2', TCD1.UDFTable_3 AS 'UDF Table Name 3', TCD1.UDFAlias_3 AS 'UDF Field Alias 3', TCD1.UDFTable_4 AS 'UDF Table Name 4', TCD1.UDFAlias_4 AS 'UDF Field Alias 4' FROM TCD1 AS TCD1

Related information


TCD1 SQL Table

Tax Code Determination OTCD SQL Table



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