biuan SAP® BUSINESS ONE SDK
SQL Administration / Sales Tax Codes / Sales Tax Codes - Rows
DTW Administration / Setup / Financials / Tax / Sales Tax Codes / Sales Tax Codes - Rows
API Sales Tax Codes / Sales Tax Codes Lines
STC1 - Sales Tax Codes - Rows Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
STCCode KEY UNIQUESTC CodenVarChar
8OSTC
Sales Tax Codes		PRIMARYYes
Line_IDRow NumberInt
11
0
STACode KEYSTA CodenVarChar
8OSTA
Sales Tax Authorities		STACodeNo
STATypeSTA TypeInt
11OSTA
Sales Tax Authorities
TaxOnTCodeSTA Tax on Tax CodenVarChar
8OSTA
Sales Tax Authorities
TaxOnTTypeSTA Tax On Tax TypeInt
11OSTA
Sales Tax Authorities
EfctivRateEffective RateNum
20
FmlIdTax Formula IDInt
11OFML
Tax Formula Master Table
CstCodeInCST Code IncomingnVarChar
20
CstSuffixCST Suffix for ICMSnVarChar
2
LogInstancLog InstanceInt
11
0

Table relationship map

SELECT statement

SELECT STC1.STCCode AS 'STC Code', STC1.Line_ID AS 'Row Number', STC1.STACode AS 'STA Code', STC1.STAType AS 'STA Type', STC1.TaxOnTCode AS 'STA Tax on Tax Code', STC1.TaxOnTType AS 'STA Tax On Tax Type', STC1.EfctivRate AS 'Effective Rate', STC1.FmlId AS 'Tax Formula ID', STC1.CstCodeIn AS 'CST Code Incoming', STC1.CstSuffix AS 'CST Suffix for ICMS', STC1.LogInstanc AS 'Log Instance' FROM STC1 AS STC1

Related information


Sales Tax Codes Lines SalesTaxCodes_Lines Object· Table: STC1
TaxCodes_Lines is a child object of the SalesTaxCodes object and represents the tax authorities/types from which the tax code is combined. Source table: STC1.
   Parent: Sales Tax Codes SalesTaxCodes Object· Table: OSTC
Tax Formula Master Table OFML SQL Table

Sales Tax Authorities OSTA SQL Table

Sales Tax Codes OSTC 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