biuan SAP® BUSINESS ONE SDK
DTW Administration / System Initialization
API OTSC / Nota Fiscal CST
OTSC - CST Code for Nota Fiscal Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
ID KEY UNIQUECST Internal KeyInt
11
PRIMARYYes
CODE KEY UNIQUECST Code IncomingnVarChar
20
CST_CODEYes
SituationDescription IncomingText
16
LockedLockedVarChar
Y)
N)
1
N
DataSourceData SourceVarChar
N) Unknown
I) Interface
U) Update
M) Import
O) OBServer
A) Auto Incr.
D) Data Doc.
P) Partner Implementation
T) Year Transfer
1
N
UserSignUser SignatureInt
6OUSR
Users
CategoryTax CategoryInt
6ONFT
Nota Fiscal Tax Category (Brazil)
-6
CodeOutCST Code OutgoingnVarChar
20
OutDescDescription OutgoingText
16
LogInstancLog InstanceInt
11
0
UserSign2Updating UserInt
6OUSR
Users
UpdateDateUpdate DateDate
8

Table relationship map

SELECT statement

SELECT OTSC.ID AS 'CST Internal Key', OTSC.CODE AS 'CST Code Incoming', OTSC.Situation AS 'Description Incoming', OTSC.Locked AS 'Locked', OTSC.DataSource AS 'Data Source', OTSC.UserSign AS 'User Signature', OTSC.Category AS 'Tax Category', OTSC.CodeOut AS 'CST Code Outgoing', OTSC.OutDesc AS 'Description Outgoing', OTSC.LogInstanc AS 'Log Instance', OTSC.UserSign2 AS 'Updating User', OTSC.UpdateDate AS 'Update Date' FROM OTSC AS OTSC

Related information


Nota Fiscal CST NotaFiscalCST Object· Table: OTSC
Represents CST codes for Nota Fiscal documents. Source table: OTSC

OTSC SQL Table

Nota Fiscal Tax Category (Brazil) ONFT 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