📚 SAP Business One SDK Help

Table Name: ELS1

Table Description: Vat Report Declaration Lines

Field Description Type Size Related Default Value Constraints
RunId Run Number Int 11 OELS      
VatViewAbs Vat View Abs Entry Int 11 -      
Code Code nVarChar 8 -      
Name Name nVarChar 50 -      
SrcObjType Source Object Type nVarChar 20 -      
DocNum Document Number Int 11 -      
Category Category VarChar 1 -      
IsEC EU VarChar 1 -      
IsAcq Acquisition Tax Liable VarChar 1 -      
VatPercent VAT Percent Num 19.6 -      
EqPercent Equalization Percent Num 19.6 -      
DocDate Posting Date Date 8 -      
TaxDate Document Date Date 8 -      
CANCELLED CANCELLED VarChar 1 -      
BaseSum Base Sum Num 19.6 -      
VatSum VAT Sum Num 19.6 -      
EqSum Equalization Sum Num 19.6 -      
DeductSum Deduct VAT Sum Num 19.6 -      
SrcObjAbs Source Object Internal ID Int 11 -      
BaseObjTyp Base Object Type nVarChar 20 -      
TaxAbs Internal Number Int 11 -      
InvNum Invoice Document Number Int 11 -      
InvDate Invoice Date Date 8 -      
InvAmnt Invoice Amount Num 19.6 -      
InvVatAmnt Invoice Vat Amount Num 19.6 -      
VendorRef BP Name nVarChar 200 -      
BaseSumSc Base Sum (SC) Num 19.6 -      
VatSumSc VAT Sum (SC) Num 19.6 -      
EqSumSC Equalization Sum (SC) Num 19.6 -      
DedctSumSC Deduct VAT Sum (SC) Num 19.6 -      
TaxType Tax Type VarChar 1 -      
CrditDebit Credit Or Debit Transaction VarChar 1 -      
CardCode BP Code nVarChar 15 -      
CardName BP Name nVarChar 200 -      
ReportType Report Type Int 11 -      
SrcLineNum Source Row Number Int 11 -      
VatDate VAT Date Date 8 -      
VatIdUnCmp Unified Federal Tax ID nVarChar 32 -      
DocLicTrad Document Federal Tax ID nVarChar 32 -      
BPLicTrad BP Federal Tax ID nVarChar 32 -      
AddID ID No. 2 nVarChar 64 -      
OrdinLNum Ordial Num (BTF & Canceled) Int 11 -      
EqBaseSum Equalization Base Sum Num 19.6 -      
IsSplitPay Split Payment VarChar 1 -      
CAOutCode Custom Acct Output Tax Code nVarChar 8 -      
CABasSum Custom Acct Reverse Base Sum Num 19.6 -      
CABasSumSc Custom Acct Reverse Base SumSC Num 19.6 -      
CAVatSum Custom Acct Reverse VAT Sum Num 19.6 -      
CAVatSumSc Custom Acct Reverse VAT SumSC Num 19.6 -      
VatSumSrc VAT Sum Source VarChar 1 -      
VatType Type of VAT Int 11 -      
GoddsShip Goods Shipment VarChar 1 -      
ServSupply Service Supply VarChar 1 -      
Key Unique Field
PRIMARY Yes RunId
    VatViewAbs
    Code
    Category