biuan SAP® BUSINESS ONE SDK
API ITM10
ITM10 - OITM Extension Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
ItemCode KEY UNIQUEItem No.nVarChar
20OITM
Items
PRIMARYYes
ISCommCodeCommodity CodeInt
11ODCI
Intrastat Configuration
ISSubMasUnIntrastat Additional MeasureInt
11ODCI
Intrastat Configuration
ISFactorIS Factor Additional MeasureNum
20
ISOrCSTImpIS Destination State for Impor.Int
11ODCI
Intrastat Configuration
ISOrCSTExpIS State of Origin for ExportInt
11ODCI
Intrastat Configuration
ISNaTraImpIS Nature of Trans. ImportInt
11ODCI
Intrastat Configuration
ISNaTraExpIS Nature of Trans. ExportInt
11ODCI
Intrastat Configuration
ISStProImpIS Statistical Procedure Imp.Int
11ODCI
Intrastat Configuration
ISStProExpIS Statistical Procedure Exp.Int
11ODCI
Intrastat Configuration
ISOriCntryIntrastat Country of OriginnVarChar
3OCRY
Countries
ISSerCodeIntrastat Service CodeInt
11ODCI
Intrastat Configuration
ISItemTypeIntrastat Item TypeVarChar
I) Item
S) Service
1
I
ISSerSupMtIS Service Supply MethodnVarChar
I) Immediate
R) To More Resumptions
12
I
ISSerPayMtIS Service Payment MethodnVarChar
A) Accredited to Bank Account
B) Bank Transfer
X) Other
12
X
ISOrCRYImpIS Destination Country for Imp.nVarChar
3OCRY
Countries
ISOrCRYExpIS Origin Country for ExportnVarChar
3OCRY
Countries
ISUseWeighUse Wt in Add. Measure Calc.VarChar
Y) Yes
N) No
1
Y
ISRelevantIntrastat RelevantVarChar
Y) Yes
N) No
1
N
ISStatCodeStatistical CodenVarChar
2

Table relationship map

SELECT statement

SELECT ITM10.ItemCode AS 'Item No.', ITM10.ISCommCode AS 'Commodity Code', ITM10.ISSubMasUn AS 'Intrastat Additional Measure', ITM10.ISFactor AS 'IS Factor Additional Measure', ITM10.ISOrCSTImp AS 'IS Destination State for Impor.', ITM10.ISOrCSTExp AS 'IS State of Origin for Export', ITM10.ISNaTraImp AS 'IS Nature of Trans. Import', ITM10.ISNaTraExp AS 'IS Nature of Trans. Export', ITM10.ISStProImp AS 'IS Statistical Procedure Imp.', ITM10.ISStProExp AS 'IS Statistical Procedure Exp.', ITM10.ISOriCntry AS 'Intrastat Country of Origin', ITM10.ISSerCode AS 'Intrastat Service Code', ITM10.ISItemType AS 'Intrastat Item Type', ITM10.ISSerSupMt AS 'IS Service Supply Method', ITM10.ISSerPayMt AS 'IS Service Payment Method', ITM10.ISOrCRYImp AS 'IS Destination Country for Imp.', ITM10.ISOrCRYExp AS 'IS Origin Country for Export', ITM10.ISUseWeigh AS 'Use Wt in Add. Measure Calc.', ITM10.ISRelevant AS 'Intrastat Relevant', ITM10.ISStatCode AS 'Statistical Code' FROM ITM10 AS ITM10

Related information


Intrastat Configuration ODCI SQL Table

Countries OCRY SQL Table

Items OITM 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