biuan SAP® BUSINESS ONE SDK
API OBTA
OBTA - Brazil - Tax Adjustment Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEY UNIQUEInternal IDInt
11
PRIMARYYes
StatusStatusVarChar
O) Open
C) Canceled
1
O
CanceledCanceledVarChar
Y) Yes
N) No
1
N
DocNum KEY UNIQUEDocument NumberInt
11
NUMYes
DocRateDocument RateNum
20
TaxCatTax CategoryInt
11
TypeTypeInt
1) Referred Collection Document
2) Other Obligations, Adjustments, and Information Originating from Fiscal Documents
3) Adjustment of ICMS Appraisal
4) Adjustment and Additional Information of ICMS Appraisal
5) Adjustment of ICMS and Identification of Fiscal Documents
6) ICMS Obligations to Pay or Paid - Own Operations
7) Adjustment of ICMS-ST Appraisal
8) Adjustment and Additional Information of ICMS-ST Appraisal
9) Adjustment of ICMS-ST and Identification of Fiscal Documents
10) ICMS-ST Obligations to Pay or Paid - Own Operations
11) Adjustment of IPI Appraisal
12) Adjustment of PIS Appraisal
13) Adjustment of COFINS appraisal
6
1
OperOperationInt
1) Other Debits
2) Chargeback of Debits
3) Other Credits
4) Credit Chargeback
5) Tax Deductions Calculated
6
1
RefVisTypeReferenced Document IDInt
1) A/R Invoices
2) A/P Invoices
3) A/R Credit Memos
4) A/P Credit Memos
5) Deliveries
6) Goods Receipt PO
7) A/R Reserve Invoices
8) A/P Reserve Invoices
9) External Document
11
1
RefObjTypeReferenced Document TypeInt
13) A/R Invoices
18) A/P Invoices
14) A/R Credit Memos
19) A/P Credit Memos
15) Deliveries
20) Goods Receipt PO
-1) External Document
11
RefDocEntReferenced Document EntryInt
11
RefDocNumReferenced Document NumberInt
11
StateUfState - UFnVarChar
2
PostDatePosting DateDate
8
CodDaCollection DocumentVarChar
1) GNRE
2) Other Document
1
1
NumDaDocument NumbernVarChar
20
CodAutBank AuthenticationnVarChar
30
VlDaTotal ValueNum
20
VlDaScTotal Value SCNum
20
DtVctoDue DateDate
8
DtPgtoPayment DateDate
8
CodAjICMS CodenVarChar
10
DescCompAjRemarksnVarChar
120
BcIcmsICMS Base AmountNum
20
BcIcmsScICMS Base Amount SCNum
20
AliqIcmsICMS RateNum
20
VlIcmsICMS ValueNum
20
VlIcmsScICMS Value SCNum
20
VlOutrosOther ValuesNum
20
CodAjApurAdjustment CodenVarChar
10
NumProcProcedure Docket NumbernVarChar
10
IndProcProcedure Docket IndicatorVarChar
1
SerFiscal Document SerialnVarChar
3
SubFiscal Document SubserialnVarChar
3
NumDocFiscal Document NumberInt
11
DtDocFiscal Document Issue DateDate
8
CodModModel Document NumbernVarChar
6
CodPartBP CodenVarChar
15OCRD
Business Partner
CodRecRevenue CodenVarChar
15
GLAcctG/L Account CodenVarChar
15OACT
G/L Accounts
ItemCodeItem CodenVarChar
20OITM
Items
BPLIdBranch IDInt
11OBPL
Business Place
UserSignUser SignatureInt
6
UserSign2Updating UserInt
6
CreateDateCreation DateDate
8
CreateTimeGeneration TimeInt
6
UpdateDateDate of UpdateDate
8
TransIdTransaction NumberInt
11OJDT
Journal Entry

Table relationship map

SELECT statement

SELECT OBTA.AbsEntry AS 'Internal ID', OBTA.Status AS 'Status', OBTA.Canceled AS 'Canceled', OBTA.DocNum AS 'Document Number', OBTA.DocRate AS 'Document Rate', OBTA.TaxCat AS 'Tax Category', OBTA.Type AS 'Type', OBTA.Oper AS 'Operation', OBTA.RefVisType AS 'Referenced Document ID', OBTA.RefObjType AS 'Referenced Document Type', OBTA.RefDocEnt AS 'Referenced Document Entry', OBTA.RefDocNum AS 'Referenced Document Number', OBTA.StateUf AS 'State - UF', OBTA.PostDate AS 'Posting Date', OBTA.CodDa AS 'Collection Document', OBTA.NumDa AS 'Document Number', OBTA.CodAut AS 'Bank Authentication', OBTA.VlDa AS 'Total Value', OBTA.VlDaSc AS 'Total Value SC', OBTA.DtVcto AS 'Due Date', OBTA.DtPgto AS 'Payment Date', OBTA.CodAj AS 'ICMS Code', OBTA.DescCompAj AS 'Remarks', OBTA.BcIcms AS 'ICMS Base Amount', OBTA.BcIcmsSc AS 'ICMS Base Amount SC', OBTA.AliqIcms AS 'ICMS Rate', OBTA.VlIcms AS 'ICMS Value', OBTA.VlIcmsSc AS 'ICMS Value SC', OBTA.VlOutros AS 'Other Values', OBTA.CodAjApur AS 'Adjustment Code', OBTA.NumProc AS 'Procedure Docket Number', OBTA.IndProc AS 'Procedure Docket Indicator', OBTA.Ser AS 'Fiscal Document Serial', OBTA.Sub AS 'Fiscal Document Subserial', OBTA.NumDoc AS 'Fiscal Document Number', OBTA.DtDoc AS 'Fiscal Document Issue Date', OBTA.CodMod AS 'Model Document Number', OBTA.CodPart AS 'BP Code', OBTA.CodRec AS 'Revenue Code', OBTA.GLAcct AS 'G/L Account Code', OBTA.ItemCode AS 'Item Code', OBTA.BPLId AS 'Branch ID', OBTA.UserSign AS 'User Signature', OBTA.UserSign2 AS 'Updating User', OBTA.CreateDate AS 'Creation Date', OBTA.CreateTime AS 'Generation Time', OBTA.UpdateDate AS 'Date of Update', OBTA.TransId AS 'Transaction Number' FROM OBTA AS OBTA

Related information


OBTA SQL Table

Business Place OBPL SQL Table

Business Partner OCRD SQL Table

G/L Accounts OACT SQL Table

Items OITM SQL Table

Journal Entry OJDT 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