OCIF - biuan.com SDK Developer - SAP® Business ONE (SBO)

SQL Administration / Configuration of Intrastat Fields

DTW Administration / Setup / Inventory / Shipping Types

API OCIF

OCIF - Configuration of Intrastat Fields Table

SBO SQL database table details

Field	Description	Type	Size	Primary_Key	Unique
AbsEntry ^KEY ^UNIQUE	Internal Key	Int	11	PRIMARY	Yes
ISTable	Intrastat Wizard Table	nVarChar	4
ISField	Intrastat Wizard Field Alias	nVarChar	10
FieldDesc	Field Description	nVarChar	127
FlLocation	Field Location	nVarChar	127
FldSource	Source of the Field Value	nVarChar	127

SELECT statement

SELECT
   OCIF.AbsEntry AS 'Internal Key', 
   OCIF.ISTable AS 'Intrastat Wizard Table', 
   OCIF.ISField AS 'Intrastat Wizard Field Alias', 
   OCIF.FieldDesc AS 'Field Description', 
   OCIF.FlLocation AS 'Field Location', 
   OCIF.FldSource AS 'Source of the Field Value'
FROM OCIF AS OCIF

Related information

OCIF SQL Table

biuan SAP® BUSINESS ONE

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