biuan SAP® BUSINESS ONE SDK
SQL Administration / Sales Tax Codes
API ASTC
ASTC - 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 ASTC.Code AS 'Code', ASTC.Name AS 'Name', ASTC.Rate AS 'Rate', ASTC.Freight AS 'Freight', ASTC.UserSign AS 'User Signature', ASTC.ValidForAR AS 'Valid for A/R', ASTC.ValidForAP AS 'Valid for A/P', ASTC.TfcId AS 'Formula Combination ID', ASTC.Lock AS 'Lock Flag', ASTC.TaxIcms AS 'Taxation For ICMS', ASTC.IsItmLevel AS 'Is Single Item Level Tax', ASTC.CfopIn AS 'CFOP Incoming Code', ASTC.CfopOut AS 'CFOP Outgoing Code', ASTC.LogInstanc AS 'Log Instance', ASTC.UserSign2 AS 'Updating User', ASTC.UpdateDate AS 'Update Date', ASTC.FADebit AS 'FA Debit' FROM ASTC AS ASTC

Related information


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. Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates