biuan SAP® BUSINESS ONE SDK
DTW Inventory / Item Management
API ODCI
ODCI - Intrastat Configuration Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEY UNIQUEConfiguration Entry IDInt
11
PRIMARYYes
ConfTypeConfiguration TypeVarChar
M) Additional Measurement Unit
C) Commodity Codes
P) Custom Procedures
I) Incoterms
N) Nature of Transactions
E) Ports of Entry and Exit
R) Service Codes
S) Statistical Procedures
T) Transport Modes
G) Regions
1
CodeCodenVarChar
50
DescrDescriptionnVarChar
127
PrcstValPercentage ValueNum
20
SuppUnitSupplementary UnitInt
11ODCI
Intrastat Configuration
ExportValid for ExportVarChar
Y) Yes
N) No
1
Y
ImportValid for ImportVarChar
Y) Yes
N) No
1
Y
StatCodeStatistical CodenVarChar
2
DateFromValid FromDate
8
DateToValid ToDate
8
TextValText ValuenVarChar
12
ConfID KEYConfiguration IDnVarChar
127
CONF_IDNo

SELECT statement

SELECT ODCI.AbsEntry AS 'Configuration Entry ID', ODCI.ConfType AS 'Configuration Type', ODCI.Code AS 'Code', ODCI.Descr AS 'Description', ODCI.PrcstVal AS 'Percentage Value', ODCI.SuppUnit AS 'Supplementary Unit', ODCI.Export AS 'Valid for Export', ODCI.Import AS 'Valid for Import', ODCI.StatCode AS 'Statistical Code', ODCI.DateFrom AS 'Valid From', ODCI.DateTo AS 'Valid To', ODCI.TextVal AS 'Text Value', ODCI.ConfID AS 'Configuration ID' FROM ODCI AS ODCI

Related information


Intrastat Configuration ODCI 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