biuan SAP® BUSINESS ONE SDK
API ISW3
ISW3 - Declaration Rows Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
WizAbsEnt KEY UNIQUEWizard Run KeyInt
11OISW
Intrastat Wizard
PRIMARYYes
LineDeclaration LineInt
11
ItemCodeItem CodenVarChar
20OITM
Items
RowStatusRow StatusVarChar
1
O
CardCodeBusiness Partner CodenVarChar
15OCRD
Business Partner
ObjTypeDocument TypeInt
11
DocNumDocument NumberInt
11
DocLineNumDocument Line NumberInt
11
RecpTypeReceipt TypeVarChar
1
DocBillDtDocument Billing DateDate
8
QuantityQuantityNum
20
BPCtrySender/Receiver CountrynVarChar
3
TaxCodeExtTax Code ExtensionnVarChar
12
NetMassSgnNet Mass SignVarChar
+) Positive
-) Negative
1
+
NetMassNet MassNum
20
NetMassUntNet Mass UnitnVarChar
12
SupMassSgnSupplementary Mass SignVarChar
+) Positive
-) Negative
1
+
SupplMassSupplementary MassNum
20
SupplUnitSupplementary UnitnVarChar
50
ValueSgnValue SignVarChar
+) Positive
-) Negative
1
+
ValueValueNum
20
ValueFCValue in Foreign CurrencyNum
20
FCCurrencyForeign CurrencynVarChar
3
StatValSgnStatistical Value SignVarChar
+) Positive
-) Negative
1
StatValStatistical ValueNum
20
ReturnIDReturn IdentifierVarChar
1
IncludeInclude Line in ReportVarChar
Y) Yes
N) No
1
Y
IsChangedChanged Line FlagVarChar
Y) Yes
N) No
1
N
DstRegCryDestination Country - RegionnVarChar
3
DstRegStaDestination Region StatenVarChar
12
OriRegCryOrigin Region CountrynVarChar
3
OriRegStaOrigin Region StatenVarChar
12
BpVATregNoVAT Registration No.nVarChar
32
CtryOrigCountry of OriginnVarChar
3
IncotermsIncotermsnVarChar
12
NatOfTransNature of TransactionnVarChar
50
TransModeTransport ModenVarChar
12
PortEnExPort of Entry or ExitnVarChar
50
CustProcCustom ProcedurenVarChar
50
StatProcStatistical ProcedurenVarChar
50
DomFrgIDDomestic/Foreign IdentifierVarChar
1
ItemTypeItem TypeVarChar
I) Item
S) Service
N) Item Not Relevant to Intrastat
1
I
CommCodeCommodity CodenVarChar
12
SerCodeService CodenVarChar
12
SerSupplMService Supply MethodVarChar
I) Immediate
R) To More Resumptions
1
I
SerPymMethService Payment MethodVarChar
A) Accredited to Bank Account
B) Bank Transfer
X) Other
1
A
CorrDateCorrection DateDate
8
CorrSgnCorrection SignVarChar
+) Positive
-) Negative
1
+
ReferDocReferenced DocumentInt
11
ReferDocNoReferenced Document No.Int
11
ReferItemReferred ItemnVarChar
20OITM
Items
RefDocLineReferenced Document LineInt
11
ChgIDChanged Data Record IDnVarChar
16
ChgUserChanged BynVarChar
50
ChgTimestTime Stamp of ChangeDate
8
DeletedDeleted IndicatorVarChar
N) No
Y) Yes
1
N
CstSecRcCustom SectionnVarChar
6
CorrMonthRef. Mo. of Summary to CorrectInt
6
CorrYearRef. Yr of Summary to CorrectInt
6
CorrDeclNoNo. of Declaration to CorrectInt
11
CorRowNoRow No. Inside Sec. 3 to CorrectInt
11
DeclRowNoDeclaration File Row No.Int
11
CorrTypeReferred Type of ReceiptInt
11
CntryPayState Code for PaymentnVarChar
3
TriangularTriangular TradeVarChar
N) No
Y) Yes
1
N
CardNameBusiness Partner NamenVarChar
100
StatCodeStatistical CodenVarChar
2
DocEntryDocument EntryInt
11
NetValueNet ValueNum
20
NetValueFCNet Value in FCNum
20
FreightFreight SumNum
20
FreighFCFreight Sum in FCNum
20
RateFCCurrency Rate for FCNum
20
RemarksRemarksnVarChar
127
ProtocolNProtocol NumberInt
11

Table relationship map

SELECT statement

SELECT ISW3.WizAbsEnt AS 'Wizard Run Key', ISW3.Line AS 'Declaration Line', ISW3.ItemCode AS 'Item Code', ISW3.RowStatus AS 'Row Status', ISW3.CardCode AS 'Business Partner Code', ISW3.ObjType AS 'Document Type', ISW3.DocNum AS 'Document Number', ISW3.DocLineNum AS 'Document Line Number', ISW3.RecpType AS 'Receipt Type', ISW3.DocBillDt AS 'Document Billing Date', ISW3.Quantity AS 'Quantity', ISW3.BPCtry AS 'Sender/Receiver Country', ISW3.TaxCodeExt AS 'Tax Code Extension', ISW3.NetMassSgn AS 'Net Mass Sign', ISW3.NetMass AS 'Net Mass', ISW3.NetMassUnt AS 'Net Mass Unit', ISW3.SupMassSgn AS 'Supplementary Mass Sign', ISW3.SupplMass AS 'Supplementary Mass', ISW3.SupplUnit AS 'Supplementary Unit', ISW3.ValueSgn AS 'Value Sign', ISW3.Value AS 'Value', ISW3.ValueFC AS 'Value in Foreign Currency', ISW3.FCCurrency AS 'Foreign Currency', ISW3.StatValSgn AS 'Statistical Value Sign', ISW3.StatVal AS 'Statistical Value', ISW3.ReturnID AS 'Return Identifier', ISW3.Include AS 'Include Line in Report', ISW3.IsChanged AS 'Changed Line Flag', ISW3.DstRegCry AS 'Destination Country - Region', ISW3.DstRegSta AS 'Destination Region State', ISW3.OriRegCry AS 'Origin Region Country', ISW3.OriRegSta AS 'Origin Region State', ISW3.BpVATregNo AS 'VAT Registration No.', ISW3.CtryOrig AS 'Country of Origin', ISW3.Incoterms AS 'Incoterms', ISW3.NatOfTrans AS 'Nature of Transaction', ISW3.TransMode AS 'Transport Mode', ISW3.PortEnEx AS 'Port of Entry or Exit', ISW3.CustProc AS 'Custom Procedure', ISW3.StatProc AS 'Statistical Procedure', ISW3.DomFrgID AS 'Domestic/Foreign Identifier', ISW3.ItemType AS 'Item Type', ISW3.CommCode AS 'Commodity Code', ISW3.SerCode AS 'Service Code', ISW3.SerSupplM AS 'Service Supply Method', ISW3.SerPymMeth AS 'Service Payment Method', ISW3.CorrDate AS 'Correction Date', ISW3.CorrSgn AS 'Correction Sign', ISW3.ReferDoc AS 'Referenced Document', ISW3.ReferDocNo AS 'Referenced Document No.', ISW3.ReferItem AS 'Referred Item', ISW3.RefDocLine AS 'Referenced Document Line', ISW3.ChgID AS 'Changed Data Record ID', ISW3.ChgUser AS 'Changed By', ISW3.ChgTimest AS 'Time Stamp of Change', ISW3.Deleted AS 'Deleted Indicator', ISW3.CstSecRc AS 'Custom Section', ISW3.CorrMonth AS 'Ref. Mo. of Summary to Correct', ISW3.CorrYear AS 'Ref. Yr of Summary to Correct', ISW3.CorrDeclNo AS 'No. of Declaration to Correct', ISW3.CorRowNo AS 'Row No. Inside Sec. 3 to Correct', ISW3.DeclRowNo AS 'Declaration File Row No.', ISW3.CorrType AS 'Referred Type of Receipt', ISW3.CntryPay AS 'State Code for Payment', ISW3.Triangular AS 'Triangular Trade', ISW3.CardName AS 'Business Partner Name', ISW3.StatCode AS 'Statistical Code', ISW3.DocEntry AS 'Document Entry', ISW3.NetValue AS 'Net Value', ISW3.NetValueFC AS 'Net Value in FC', ISW3.Freight AS 'Freight Sum', ISW3.FreighFC AS 'Freight Sum in FC', ISW3.RateFC AS 'Currency Rate for FC', ISW3.Remarks AS 'Remarks', ISW3.ProtocolN AS 'Protocol Number' FROM ISW3 AS ISW3

Related information


Business Partner OCRD SQL Table

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