biuan SAP® BUSINESS ONE SDK
SQL Administration / Tax Code by Usage
API TCD5
TCD5 - Tax Code by Usage Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsId KEY UNIQUENumeratorInt
11
PRIMARYYes
Tcd3IdValid Period IDInt
11
UsageCodeUsageInt
11
TaxCodeTax CodenVarChar
8
TypeTax Code TypeVarChar
R) A/R Default Tax Code
P) A/P Default Tax Code
L) Line Item Tax Code
1
L
ExpTaxCodeFreight Tax CodenVarChar
8

SELECT statement

SELECT TCD5.AbsId AS 'Numerator', TCD5.Tcd3Id AS 'Valid Period ID', TCD5.UsageCode AS 'Usage', TCD5.TaxCode AS 'Tax Code', TCD5.Type AS 'Tax Code Type', TCD5.ExpTaxCode AS 'Freight Tax Code' FROM TCD5 AS TCD5

Related information
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