biuan SAP® BUSINESS ONE SDK
API ISW2
ISW2 - Intrastat Reported Items Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
WizAbsEnt KEY UNIQUEWizard Run KeyInt
11OISW
Intrastat Wizard
PRIMARYYes
ItemCodeItem CodenVarChar
20OITM
Items
CommCodeCommodity CodenVarChar
12
SerCodeService CodenVarChar
12
AddMUnitAdditional Measure UnitnVarChar
50
FactorAMFactor Additional MeasureNum
20
OriRegStaRegion of Origin (for Export)nVarChar
12
DstRegStaDestination Region (Import)nVarChar
12
CtryOrigCountry of OriginnVarChar
3
SerSupplMService Supply MethodnVarChar
I) Immediate
R) To More Resumptions
12
I
SerPymMethService Payment MethodnVarChar
A) Accredited to Bank Account
B) Bank Transfer
X) Other
12
X
ItemTypeItem TypeVarChar
I) Item
S) Service
N) Item not relevant to Intrastat
1
I
ItemNameItem NamenVarChar
100
DestRegCryDestination Country - RegionnVarChar
3
OrigRegCryOrigin Region CountrynVarChar
3
UseWeightUse Wt in Add. Measure Calc.VarChar
Y) Yes
N) No
1
Y
StatCodeStatistical CodenVarChar
2
NatOfTransNature of TransactionnVarChar
50
StatProcStatistical ProcedurenVarChar
50

Table relationship map

SELECT statement

SELECT ISW2.WizAbsEnt AS 'Wizard Run Key', ISW2.ItemCode AS 'Item Code', ISW2.CommCode AS 'Commodity Code', ISW2.SerCode AS 'Service Code', ISW2.AddMUnit AS 'Additional Measure Unit', ISW2.FactorAM AS 'Factor Additional Measure', ISW2.OriRegSta AS 'Region of Origin (for Export)', ISW2.DstRegSta AS 'Destination Region (Import)', ISW2.CtryOrig AS 'Country of Origin', ISW2.SerSupplM AS 'Service Supply Method', ISW2.SerPymMeth AS 'Service Payment Method', ISW2.ItemType AS 'Item Type', ISW2.ItemName AS 'Item Name', ISW2.DestRegCry AS 'Destination Country - Region', ISW2.OrigRegCry AS 'Origin Region Country', ISW2.UseWeight AS 'Use Wt in Add. Measure Calc.', ISW2.StatCode AS 'Statistical Code', ISW2.NatOfTrans AS 'Nature of Transaction', ISW2.StatProc AS 'Statistical Procedure' FROM ISW2 AS ISW2

Related information


Items OITM SQL Table

Intrastat Wizard OISW 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