biuan SAP® BUSINESS ONE SDK
DTW Administration / Setup / Financials / Tax / Sales Tax Codes
API OSTC / Sales Tax Codes
OSTC - Sales Tax Codes Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
Code KEY UNIQUECodenVarChar
8
PRIMARYYes
NameNamenVarChar
100
RateRateNum
20
FreightFreightVarChar
Y) Yes
N) No
1
N
UserSignUser SignatureInt
6OUSR
Users
ValidForARValid for A/RVarChar
Y) Yes
N) No
1
Y
ValidForAPValid for A/PVarChar
Y) Yes
N) No
1
Y
TfcIdFormula Combination IDInt
11OTFC
Tax Type Combination
LockLock FlagVarChar
Y) Yes
N) No
1
N
TaxIcmsTaxation For ICMSnVarChar
2
IsItmLevelIs Single Item Level TaxVarChar
Y) Yes
N) No
1
N
CfopInCFOP Incoming CodenVarChar
6OCFP
CFOP for Nota Fiscal
CfopOutCFOP Outgoing CodenVarChar
6OCFP
CFOP for Nota Fiscal
LogInstancLog InstanceInt
11
0
UserSign2Updating UserInt
6OUSR
Users
UpdateDateUpdate DateDate
8
FADebitFA DebitVarChar
Y) Yes
N) No
1
N

Table relationship map

SELECT statement

SELECT OSTC.Code AS 'Code', OSTC.Name AS 'Name', OSTC.Rate AS 'Rate', OSTC.Freight AS 'Freight', OSTC.UserSign AS 'User Signature', OSTC.ValidForAR AS 'Valid for A/R', OSTC.ValidForAP AS 'Valid for A/P', OSTC.TfcId AS 'Formula Combination ID', OSTC.Lock AS 'Lock Flag', OSTC.TaxIcms AS 'Taxation For ICMS', OSTC.IsItmLevel AS 'Is Single Item Level Tax', OSTC.CfopIn AS 'CFOP Incoming Code', OSTC.CfopOut AS 'CFOP Outgoing Code', OSTC.LogInstanc AS 'Log Instance', OSTC.UserSign2 AS 'Updating User', OSTC.UpdateDate AS 'Update Date', OSTC.FADebit AS 'FA Debit' FROM OSTC AS OSTC

Related information


Sales Tax Codes SalesTaxCodes Object· Table: OSTC
SalesTaxCodes is a business object that represents the inclusive sales tax codes. Each sales tax code consists of one or more sales taxes as defined in SalesTaxAuthorities object. This object enables you to: Add a sales tax code. Retrieve a...

OSTC SQL Table

CFOP for Nota Fiscal OCFP SQL Table

Tax Type Combination OTFC SQL Table

Users OUSR SQL Table



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