biuan SAP® BUSINESS ONE SDK
DTW User Defined Data / Query Categories
API ASTT
ASTT - Sales Tax Authorities Type Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsId KEY UNIQUENumeratorInt
11
PRIMARYYes
Name KEY UNIQUEType NamenVarChar
40
NAMEYes
UserSignUser SignatureInt
6OUSR
Users
IsVatVATVarChar
Y) Yes
N) No
1
N
NfTaxIdID of Nota Fiscal Tax CategoryInt
11ONFT
Nota Fiscal Tax Category (Brazil)
TpsIdID of Tax Parameter SetInt
11OTPS
Tax Parameter
PLABalancePLA Current BalanceNum
20
LockedLockedVarChar
1
N
LogInstancLog InstanceInt
11
0
UserSign2Updating UserInt
6OUSR
Users
UpdateDateUpdate DateDate
8
CreditCtrlTax Credit ControlVarChar
Y) Yes
N) No
1
N

Table relationship map

SELECT statement

SELECT ASTT.AbsId AS 'Numerator', ASTT.Name AS 'Type Name', ASTT.UserSign AS 'User Signature', ASTT.IsVat AS 'VAT', ASTT.NfTaxId AS 'ID of Nota Fiscal Tax Category', ASTT.TpsId AS 'ID of Tax Parameter Set', ASTT.PLABalance AS 'PLA Current Balance', ASTT.Locked AS 'Locked', ASTT.LogInstanc AS 'Log Instance', ASTT.UserSign2 AS 'Updating User', ASTT.UpdateDate AS 'Update Date', ASTT.CreditCtrl AS 'Tax Credit Control' FROM ASTT AS ASTT

Related information


Nota Fiscal Tax Category (Brazil) ONFT SQL Table

Tax Parameter OTPS 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