biuan SAP® BUSINESS ONE SDK
API OISW
OISW - Intrastat Wizard Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEY UNIQUEInternal KeyInt
11
PRIMARYYes
DeclDescrDescriptionnVarChar
127
DateFromStarting Date of DeclarationDate
8
DateToEnding Date of DeclarationDate
8
RunDateDate of RunDate
8
ImpExpIndImport Export IndicatorVarChar
I) Import
E) Export
1
I
StatusStatusVarChar
O) Open
C) Closed
D) Deleted
A) Archived
1
MsgTypeMessage TypeInt
0
9) Nil Declaration
3) Correction Declaration
11
0
TtlDocValTotal Document ValueNum
20
DocCountTotal Number of DocumentsInt
11
CompNameCompany NamenVarChar
100
CompDeclIDCompany Declaration IDnVarChar
32
CompStreetCompany StreetnVarChar
100
CompCityCompany CitynVarChar
100
CompZipCompany Zip CodenVarChar
20
CompCntryCompany CountrynVarChar
3OCRY
Countries
DeclCntryDeclaration CountrynVarChar
3OCRY
Countries
CntPersIDContact Person IDInt
11OHEM
Employees
CntPersonContact PersonnVarChar
127
CntEmailContact E-MailnVarChar
100
CntPhoneContact PhonenVarChar
20
CntFaxContact FaxnVarChar
20
VATRegNoVAT Reg. No. of TradernVarChar
100
VATRegExVAT Reg. No. ExtensionnVarChar
10
DeclNumSequential Declaration NumbernVarChar
14
DeclNoExNo. of Declaration in PeriodInt
11
HeaderIdHeader IDInt
11
DeclStatDeclaration StatusVarChar
1
DeclDeptDeclaring DepartmentInt
6
DeclCurrDeclaration CurrencynVarChar
3
ObligLvlDegree of ObligationVarChar
1
TaxStateFederal State of Tax OfficenVarChar
3
CustOffcCustoms Registration OfficenVarChar
100
CustOffIDCustoms Registration Office IDnVarChar
2
DeclSerNoDeclaration Sequence NumbernVarChar
3
IntCtrlRefInterchange Control ReferencenVarChar
99
Addr1_3pThird-Party Address Part 1nVarChar
100
Addr2_3pThird-Party Address Part 2nVarChar
100
Addr3_3pThird-Party Address Part 3nVarChar
100
Addr4_3pThird-Party Address Part 4nVarChar
100
CntPers_3pThird-Party Contact PersonnVarChar
127
CntPhon_3pThird-Party Contact PhonenVarChar
20
CntFax_3pThird-Party Contact FaxnVarChar
20
FreeTxt1Free Text Line 1nVarChar
70
FreeTxt2Free Text Line 2nVarChar
70
FreeTxt3Free Text Line 3nVarChar
70
FreeTxt4Free Text Line 4nVarChar
70
FreeTxt5Free Text Line 5nVarChar
70
ValidKeyValidation Key IdentificationnVarChar
35
ISDeclOffcIntrastat Declaration OfficenVarChar
10
ReleaseVerRelease VersionnVarChar
11
UserSignCreated by UserInt
6
PosCredValPositive Credit Memo ValuesVarChar
Y) Yes
N) No
1
Y
IncPrevDocInclude Previous DocumentsVarChar
Y) Yes
N) No
1
DeclPeriodDeclaration PeriodVarChar
M) Monthly
Q) Quarterly
1
M
Box1Box 1: PeriodicityInt
0
8) First Month of Quarter
9) First and Second Months of Quarter
6
0
Box2Box 2: Company ActivityInt
0
7) First Declaration
8) Stop Activity/Change of Federal Tax ID
9) First Declaration After Federal Tax ID Change
6
0
GroupDataGroup Display DataVarChar
Y) Yes
N) No
1
Y
CstRecStCustom SectionnVarChar
6
TaxCodeExtTax Code ExtensionnVarChar
99
ExportPathExport PathText
16
LLEFMAbsEFM Template IDInt
11
SimpProcSimplified ProcedureVarChar
Y) Yes
N) No
1
DspNMassRequire All DataVarChar
Y) Yes
N) No
1
ExlDocQtExclude Docs W/ Qty Less ThanVarChar
Y) Yes
N) No
1
DocQtLmDocument Quantity LimitNum
20
ExlDocAmExclude Docs W/ Amt Less ThanVarChar
Y) Yes
N) No
1
DocAmLmDocument Amount LimitNum
20
RunTimeTime of RunInt
6
AddonRunUpgraded Add-On RunVarChar
Y) Yes
N) No
1
N
BaseDeclBase DeclarationInt
11ODCI
Intrastat Configuration
GroupTransGroup TransactionsVarChar
Y) Yes
N) No
1
N

Table relationship map

SELECT statement

SELECT OISW.AbsEntry AS 'Internal Key', OISW.DeclDescr AS 'Description', OISW.DateFrom AS 'Starting Date of Declaration', OISW.DateTo AS 'Ending Date of Declaration', OISW.RunDate AS 'Date of Run', OISW.ImpExpInd AS 'Import Export Indicator', OISW.Status AS 'Status', OISW.MsgType AS 'Message Type', OISW.TtlDocVal AS 'Total Document Value', OISW.DocCount AS 'Total Number of Documents', OISW.CompName AS 'Company Name', OISW.CompDeclID AS 'Company Declaration ID', OISW.CompStreet AS 'Company Street', OISW.CompCity AS 'Company City', OISW.CompZip AS 'Company Zip Code', OISW.CompCntry AS 'Company Country', OISW.DeclCntry AS 'Declaration Country', OISW.CntPersID AS 'Contact Person ID', OISW.CntPerson AS 'Contact Person', OISW.CntEmail AS 'Contact E-Mail', OISW.CntPhone AS 'Contact Phone', OISW.CntFax AS 'Contact Fax', OISW.VATRegNo AS 'VAT Reg. No. of Trader', OISW.VATRegEx AS 'VAT Reg. No. Extension', OISW.DeclNum AS 'Sequential Declaration Number', OISW.DeclNoEx AS 'No. of Declaration in Period', OISW.HeaderId AS 'Header ID', OISW.DeclStat AS 'Declaration Status', OISW.DeclDept AS 'Declaring Department', OISW.DeclCurr AS 'Declaration Currency', OISW.ObligLvl AS 'Degree of Obligation', OISW.TaxState AS 'Federal State of Tax Office', OISW.CustOffc AS 'Customs Registration Office', OISW.CustOffID AS 'Customs Registration Office ID', OISW.DeclSerNo AS 'Declaration Sequence Number', OISW.IntCtrlRef AS 'Interchange Control Reference', OISW.Addr1_3p AS 'Third-Party Address Part 1', OISW.Addr2_3p AS 'Third-Party Address Part 2', OISW.Addr3_3p AS 'Third-Party Address Part 3', OISW.Addr4_3p AS 'Third-Party Address Part 4', OISW.CntPers_3p AS 'Third-Party Contact Person', OISW.CntPhon_3p AS 'Third-Party Contact Phone', OISW.CntFax_3p AS 'Third-Party Contact Fax', OISW.FreeTxt1 AS 'Free Text Line 1', OISW.FreeTxt2 AS 'Free Text Line 2', OISW.FreeTxt3 AS 'Free Text Line 3', OISW.FreeTxt4 AS 'Free Text Line 4', OISW.FreeTxt5 AS 'Free Text Line 5', OISW.ValidKey AS 'Validation Key Identification', OISW.ISDeclOffc AS 'Intrastat Declaration Office', OISW.ReleaseVer AS 'Release Version', OISW.UserSign AS 'Created by User', OISW.PosCredVal AS 'Positive Credit Memo Values', OISW.IncPrevDoc AS 'Include Previous Documents', OISW.DeclPeriod AS 'Declaration Period', OISW.Box1 AS 'Box 1: Periodicity', OISW.Box2 AS 'Box 2: Company Activity', OISW.GroupData AS 'Group Display Data', OISW.CstRecSt AS 'Custom Section', OISW.TaxCodeExt AS 'Tax Code Extension', OISW.ExportPath AS 'Export Path', OISW.LLEFMAbs AS 'EFM Template ID', OISW.SimpProc AS 'Simplified Procedure', OISW.DspNMass AS 'Require All Data', OISW.ExlDocQt AS 'Exclude Docs W/ Qty Less Than', OISW.DocQtLm AS 'Document Quantity Limit', OISW.ExlDocAm AS 'Exclude Docs W/ Amt Less Than', OISW.DocAmLm AS 'Document Amount Limit', OISW.RunTime AS 'Time of Run', OISW.AddonRun AS 'Upgraded Add-On Run', OISW.BaseDecl AS 'Base Declaration', OISW.GroupTrans AS 'Group Transactions' FROM OISW AS OISW

Related information


OISW SQL Table

Intrastat Configuration ODCI SQL Table

Employees OHEM SQL Table

Countries OCRY 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