biuan SAP® BUSINESS ONE SDK
SQL Administration / Sales Tax Authorities Type
DTW Administration / Setup / Financials / Tax / Sales Tax Authorities Types
API OSTT / Sales Tax Authorities Types
OSTT - 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 OSTT.AbsId AS 'Numerator', OSTT.Name AS 'Type Name', OSTT.UserSign AS 'User Signature', OSTT.IsVat AS 'VAT', OSTT.NfTaxId AS 'ID of Nota Fiscal Tax Category', OSTT.TpsId AS 'ID of Tax Parameter Set', OSTT.PLABalance AS 'PLA Current Balance', OSTT.Locked AS 'Locked', OSTT.LogInstanc AS 'Log Instance', OSTT.UserSign2 AS 'Updating User', OSTT.UpdateDate AS 'Update Date', OSTT.CreditCtrl AS 'Tax Credit Control' FROM OSTT AS OSTT

Related information


Sales Tax Authorities Types SalesTaxAuthoritiesTypes Object· Table: OSTT
SalesTaxAuthoritiesTypes is a business object that represents the type of sales tax authorities. It specifies whether or not the sales tax authority includes also VAT. This object enables you to: Add a sales tax authority type. Retrieve a...

OSTT SQL Table

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