biuan SAP® BUSINESS ONE SDK
DTW Administration / Setup / Purchasing / Landed Costs
API CIF1
CIF1 - Country Specific Information Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
FldAbsEnt KEY UNIQUEField IDInt
11OCIF
Configuration of Intrastat Fields
PRIMARYYes
CountryCountry CodenVarChar
3OCRY
Countries
IsMandImpField is mandatory for importVarChar
Y) Yes
N) No
1
IsMandExpField is mandatory for exportVarChar
Y) Yes
N) No
1
IsReqAllImField is required for importVarChar
Y) Yes
N) No
1
N
IsReqAllExField is required for exportVarChar
Y) Yes
N) No
1
N

Table relationship map

SELECT statement

SELECT CIF1.FldAbsEnt AS 'Field ID', CIF1.Country AS 'Country Code', CIF1.IsMandImp AS 'Field is mandatory for import', CIF1.IsMandExp AS 'Field is mandatory for export', CIF1.IsReqAllIm AS 'Field is required for import', CIF1.IsReqAllEx AS 'Field is required for export' FROM CIF1 AS CIF1

Related information


Countries OCRY SQL Table

Configuration of Intrastat Fields OCIF SQL Table



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