biuan SAP® BUSINESS ONE SDK
DTW A/R Invoice - Tax Extension
API Tax Extension / Import Or Export
INV12 - A/R Invoice - Tax Extension Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
DocEntry KEY UNIQUEDocument Internal IDInt
11OINV
A/R Invoice
PRIMARYYes
TaxId0Tax ID 0nVarChar
100
TaxId1Tax ID 1nVarChar
100
TaxId2Tax ID 2nVarChar
100
TaxId3Tax ID 3nVarChar
100
TaxId4Tax ID 4nVarChar
100
TaxId5Tax ID 5nVarChar
100
TaxId6Tax ID 6nVarChar
100
TaxId7Tax ID 7nVarChar
100
TaxId8Tax ID 8nVarChar
100
TaxId9Tax ID 9nVarChar
100
StateState CodenVarChar
3
CountyCounty CodenVarChar
7
IncotermsIncotermsnVarChar
3
VehicleVehicle IDnVarChar
10
VidStateVehicle ID (State)nVarChar
3
NfRefNF ReferencenVarChar
127
CarrierCarrier CodenVarChar
15OCRD
Business Partner
QoPQuantity of PacksInt
11
PackDescPack DescriptionnVarChar
10
BrandBrandnVarChar
20
NoSUNumber of Shipping UnitInt
11
NetWeightNet WeightNum
20
GrsWeightGross WeightNum
20
LogInstancLog InstanceInt
11
0
ObjectTypeObject TypenVarChar
20ADP1
Object Settings - History
13
TaxId10Tax ID 10nVarChar
100
TransCatTransaction CategorynVarChar
100
FormNoForm No.nVarChar
100
TaxId11Tax ID 11nVarChar
100
StreetSStreetnVarChar
100
BlockSBlocknVarChar
100
BuildingSBuilding/Floor/RoomText
16
CitySCitynVarChar
100
ZipCodeSZip CodenVarChar
20
CountySCountynVarChar
100
StateSStatenVarChar
3OCST
States
CountrySCountrynVarChar
3OCRY
Countries
AddrTypeSAddress TypenVarChar
100
StreetNoSStreet No.nVarChar
100
StreetBStreetnVarChar
100
BlockBBlocknVarChar
100
BuildingBBuilding/Floor/RoomText
16
CityBCitynVarChar
100
ZipCodeBZip CodenVarChar
20
CountyBCountynVarChar
100
StateBStatenVarChar
3OCST
States
CountryBCountrynVarChar
3OCRY
Countries
AddrTypeBAddress TypenVarChar
100
StreetNoBStreet No.nVarChar
100
ImpORExpImport or ExportVarChar
N)
Y)
1
VatVATVarChar
N) No VAT Support
Y) VAT Support
1
N
AltCrdNamBAlternative BP NamenVarChar
100
AltTaxIdBAlternative Tax IDnVarChar
32
Address2SAddress Name 2nVarChar
50
Address3SAddress Name 3nVarChar
50
Address2BAddress Name 2nVarChar
50
Address3BAddress Name 3nVarChar
50
MainUsageMain Usage Code of DocumentInt
11OUSG
Usage of Nota Fiscal
GlbLocNumSGlobal Location NumbernVarChar
50
GlbLocNumBGlobal Location NumbernVarChar
50
CollectDTDate and Time of CollectionnVarChar
20
TransprtDTTransport Starting DateDate
8
TransprtRSTransport ReasonnVarChar
100
TaxId12Tax ID 12nVarChar
50
TaxId13Deductee Ref. No. in IndianVarChar
100

Table relationship map

SELECT statement

SELECT INV12.DocEntry AS 'Document Internal ID', INV12.TaxId0 AS 'Tax ID 0', INV12.TaxId1 AS 'Tax ID 1', INV12.TaxId2 AS 'Tax ID 2', INV12.TaxId3 AS 'Tax ID 3', INV12.TaxId4 AS 'Tax ID 4', INV12.TaxId5 AS 'Tax ID 5', INV12.TaxId6 AS 'Tax ID 6', INV12.TaxId7 AS 'Tax ID 7', INV12.TaxId8 AS 'Tax ID 8', INV12.TaxId9 AS 'Tax ID 9', INV12.State AS 'State Code', INV12.County AS 'County Code', INV12.Incoterms AS 'Incoterms', INV12.Vehicle AS 'Vehicle ID', INV12.VidState AS 'Vehicle ID (State)', INV12.NfRef AS 'NF Reference', INV12.Carrier AS 'Carrier Code', INV12.QoP AS 'Quantity of Packs', INV12.PackDesc AS 'Pack Description', INV12.Brand AS 'Brand', INV12.NoSU AS 'Number of Shipping Unit', INV12.NetWeight AS 'Net Weight', INV12.GrsWeight AS 'Gross Weight', INV12.LogInstanc AS 'Log Instance', INV12.ObjectType AS 'Object Type', INV12.TaxId10 AS 'Tax ID 10', INV12.TransCat AS 'Transaction Category', INV12.FormNo AS 'Form No.', INV12.TaxId11 AS 'Tax ID 11', INV12.StreetS AS 'Street', INV12.BlockS AS 'Block', INV12.BuildingS AS 'Building/Floor/Room', INV12.CityS AS 'City', INV12.ZipCodeS AS 'Zip Code', INV12.CountyS AS 'County', INV12.StateS AS 'State', INV12.CountryS AS 'Country', INV12.AddrTypeS AS 'Address Type', INV12.StreetNoS AS 'Street No.', INV12.StreetB AS 'Street', INV12.BlockB AS 'Block', INV12.BuildingB AS 'Building/Floor/Room', INV12.CityB AS 'City', INV12.ZipCodeB AS 'Zip Code', INV12.CountyB AS 'County', INV12.StateB AS 'State', INV12.CountryB AS 'Country', INV12.AddrTypeB AS 'Address Type', INV12.StreetNoB AS 'Street No.', INV12.ImpORExp AS 'Import or Export', INV12.Vat AS 'VAT', INV12.AltCrdNamB AS 'Alternative BP Name', INV12.AltTaxIdB AS 'Alternative Tax ID', INV12.Address2S AS 'Address Name 2', INV12.Address3S AS 'Address Name 3', INV12.Address2B AS 'Address Name 2', INV12.Address3B AS 'Address Name 3', INV12.MainUsage AS 'Main Usage Code of Document', INV12.GlbLocNumS AS 'Global Location Number', INV12.GlbLocNumB AS 'Global Location Number', INV12.CollectDT AS 'Date and Time of Collection', INV12.TransprtDT AS 'Transport Starting Date', INV12.TransprtRS AS 'Transport Reason', INV12.TaxId12 AS 'Tax ID 12', INV12.TaxId13 AS 'Deductee Ref. No. in India' FROM INV12 AS INV12

Related information


Import Or Export ImportOrExport Property· Table: INV12
Sets or returns a valid value that specifies whether the Sales Tax Invoice is for import or export. Applicable for cluster B (country-specific for India). Field name: ImpOrExp (INV12).
· Table: IGE12 IGN12    Parent: Tax Extension TaxExtension Object· Table: IGE12 IGN12
Business Partner OCRD SQL Table

Countries OCRY SQL Table

A/R Invoice OINV SQL Table

Usage of Nota Fiscal OUSG SQL Table

Object Settings - History ADP1 SQL Table

States OCST SQL Table



SAP® Business One is the trademark(s) or registered trademark(s) of SAP AG in Germany and in several other countries. Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates