TCD2 - biuan.com SDK Developer - SAP® Business ONE (SBO)

SQL

Administration /

Key Field Values

DTW Inventory / Item Management / Batches

API TCD2

TCD2 - Key Field Values Table

SBO SQL database table details

Field	Description	Type	Size	Related	Primary_Key	Unique
AbsId ^KEY ^UNIQUE	Internal Number	Int	11		PRIMARY	Yes
Tcd1Id ^KEY ^UNIQUE	Tax Determination ID	Int	11	TCD1 Key Fields for Determination	TCD2_UNI	Yes
DispOrder	Display Order	Int	11
KeyFld_1_V	Key Fields 1 Value	nVarChar	50
KeyFld_2_V	Key Fields 2 Value	nVarChar	50
KeyFld_3_V	Key Fields 3 Value	nVarChar	50
KeyFld_4_V	Key Fields 4 Value	nVarChar	50

Table relationship map

SELECT statement

SELECT
   TCD2.AbsId AS 'Internal Number', 
   TCD2.Tcd1Id AS 'Tax Determination ID', 
   TCD2.DispOrder AS 'Display Order', 
   TCD2.KeyFld_1_V AS 'Key Fields 1 Value', 
   TCD2.KeyFld_2_V AS 'Key Fields 2 Value', 
   TCD2.KeyFld_3_V AS 'Key Fields 3 Value', 
   TCD2.KeyFld_4_V AS 'Key Fields 4 Value'
FROM TCD2 AS TCD2

Related information

TCD2 SQL Table

TCD1 SQL Table

biuan SAP® BUSINESS ONE

SAP® Business One is the trademark(s) or registered trademark(s) of SAP AG in Germany and in several other countries. Icons by Icons8 Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates