| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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
Table relationship mapSELECT statementSELECT
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 informationSales 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. ![]() 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 |