📚 SAP Business One SDK Help

Table Name: OBTA

Table Description: Brazil - Tax Adjustment

Field Description Type Size Related Default Value Constraints
AbsEntry Internal ID Int 11 -      
Status Status VarChar 1 - O O Open
            C Canceled
Canceled Canceled VarChar 1 - N Y Yes
            N No
DocNum Document Number Int 11 -      
DocRate Document Rate Num 19.6 -      
TaxCat Tax Category Int 11 -      
Type Type Int 6 - 1 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
Oper Operation Int 6 - 1 1 Other Debits
            2 Chargeback of Debits
            3 Other Credits
            4 Credit Chargeback
            5 Tax Deductions Calculated
RefVisType Referenced Document ID Int 11 - 1 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
RefObjType Referenced Document Type Int 11 -   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
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 - 1 1 GNRE
            2 Other Document
NumDa Document Number nVarChar 20 -      
CodAut Bank Authentication nVarChar 30 -      
VlDa Total Value Num 19.6 -      
VlDaSc Total Value SC Num 19.6 -      
DtVcto Due Date Date 8 -      
DtPgto Payment Date Date 8 -      
CodAj ICMS Code nVarChar 10 -      
DescCompAj Remarks nVarChar 120 -      
BcIcms ICMS Base Amount Num 19.6 -      
BcIcmsSc ICMS Base Amount SC Num 19.6 -      
AliqIcms ICMS Rate Num 19.6 -      
VlIcms ICMS Value Num 19.6 -      
VlIcmsSc ICMS Value SC Num 19.6 -      
VlOutros Other Values Num 19.6 -      
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      
CodRec Revenue Code nVarChar 15 -      
GLAcct G/L Account Code nVarChar 15 OACT      
ItemCode Item Code nVarChar 50 OITM      
BPLId Branch ID Int 11 OBPL      
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      
Key Unique Field
PRIMARY Yes AbsEntry
NUM Yes DocNum