|
|
API OBTA
OBTA - Brazil - Tax Adjustment Table
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
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | AbsEntry KEY UNIQUE | Internal ID | Int | 11 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| Status | Status | VarChar | O) Open C) Canceled | 1 | O | |||
| Canceled | Canceled | VarChar | Y) Yes N) No | 1 | N | |||
| DocNum KEY UNIQUE | Document Number | Int | 11 | NUM | Yes | |||
| DocRate | Document Rate | Num | 20 | |||||
| TaxCat | Tax Category | Int | 11 | |||||
| Type | Type | Int | 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 | |||
| Oper | Operation | Int | 1) Other Debits 2) Chargeback of Debits 3) Other Credits 4) Credit Chargeback 5) Tax Deductions Calculated | 6 | 1 | |||
| RefVisType | Referenced Document ID | Int | 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 | |||
| RefObjType | Referenced Document Type | Int | 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 | ||||
| RefDocEnt | Referenced Document Entry | Int | 11 | |||||
| RefDocNum | Referenced Document Number | Int | 11 | |||||
| StateUf | State - UF | nVarChar | 2 | |||||
| PostDate | Posting Date | Date | 8 | |||||
| CodDa | Collection Document | VarChar | 1) GNRE 2) Other Document | 1 | 1 | |||
| NumDa | Document Number | nVarChar | 20 | |||||
| CodAut | Bank Authentication | nVarChar | 30 | |||||
| VlDa | Total Value | Num | 20 | |||||
| VlDaSc | Total Value SC | Num | 20 | |||||
| DtVcto | Due Date | Date | 8 | |||||
| DtPgto | Payment Date | Date | 8 | |||||
| CodAj | ICMS Code | nVarChar | 10 | |||||
| DescCompAj | Remarks | nVarChar | 120 | |||||
| BcIcms | ICMS Base Amount | Num | 20 | |||||
| BcIcmsSc | ICMS Base Amount SC | Num | 20 | |||||
| AliqIcms | ICMS Rate | Num | 20 | |||||
| VlIcms | ICMS Value | Num | 20 | |||||
| VlIcmsSc | ICMS Value SC | Num | 20 | |||||
| VlOutros | Other Values | Num | 20 | |||||
| CodAjApur | Adjustment Code | nVarChar | 10 | |||||
| NumProc | Procedure Docket Number | nVarChar | 10 | |||||
| IndProc | Procedure Docket Indicator | VarChar | 1 | |||||
| Ser | Fiscal Document Serial | nVarChar | 3 | |||||
| Sub | Fiscal Document Subserial | nVarChar | 3 | |||||
| NumDoc | Fiscal Document Number | Int | 11 | |||||
| DtDoc | Fiscal Document Issue Date | Date | 8 | |||||
| CodMod | Model Document Number | nVarChar | 6 | |||||
| CodPart | BP Code | nVarChar | 15 | OCRD Business Partner | ||||
| CodRec | Revenue Code | nVarChar | 15 | |||||
| GLAcct | G/L Account Code | nVarChar | 15 | OACT G/L Accounts | ||||
| ItemCode | Item Code | nVarChar | 20 | OITM Items | ||||
| BPLId | Branch ID | Int | 11 | OBPL Business Place | ||||
| UserSign | User Signature | Int | 6 | |||||
| UserSign2 | Updating User | Int | 6 | |||||
| CreateDate | Creation Date | Date | 8 | |||||
| CreateTime | Generation Time | Int | 6 | |||||
| UpdateDate | Date of Update | Date | 8 | |||||
| TransId | Transaction Number | Int | 11 | OJDT 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
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
