📚 SAP Business One SDK Help

Table Name: OISW

Table Description: Intrastat Wizard

Field Description Type Size Related Default Value Constraints
AbsEntry Internal Key Int 11 -      
DeclDescr Description nVarChar 200 -      
DateFrom Starting Date of Declaration Date 8 -      
DateTo Ending Date of Declaration Date 8 -      
RunDate Date of Run Date 8 -      
ImpExpInd Import Export Indicator VarChar 1 - I I Import
            E Export
Status Status VarChar 1 -   O Open
            C Closed
            D Deleted
            A Archived
MsgType Message Type Int 11 - 0 0 New Declaration
            9 Nil Declaration
            3 Correction Declaration
TtlDocVal Total Document Value Num 19.6 -      
DocCount Total Number of Documents Int 11 -      
CompName Company Name nVarChar 200 -      
CompDeclID Company Declaration ID nVarChar 32 -      
CompStreet Company Street nVarChar 100 -      
CompCity Company City nVarChar 100 -      
CompZip Company Zip Code nVarChar 20 -      
CompCntry Company Country/Region nVarChar 3 OCRY      
DeclCntry Declaration Country/Region nVarChar 3 OCRY      
CntPersID Contact Person ID Int 11 OHEM      
CntPerson Contact Person nVarChar 250 -      
CntEmail Contact E-Mail nVarChar 100 -      
CntPhone Contact Phone nVarChar 50 -      
CntFax Contact Fax nVarChar 50 -      
VATRegNo VAT Reg. No. of Trader nVarChar 100 -      
VATRegEx VAT Reg. No. Extension nVarChar 10 -      
DeclNum Sequential Declaration Number nVarChar 14 -      
DeclNoEx No. of Declaration in Period Int 11 -      
HeaderId Header ID Int 11 -      
DeclStat Declaration Status VarChar 1 -      
DeclDept Declaring Department Int 6 -      
DeclCurr Declaration Currency nVarChar 3 -      
ObligLvl Degree of Obligation VarChar 1 -      
TaxState Federal State of Tax Office nVarChar 3 -      
CustOffc Customs Registration Office nVarChar 100 -      
CustOffID Customs Registration Office ID nVarChar 2 -      
DeclSerNo Declaration Sequence Number nVarChar 3 -      
IntCtrlRef Interchange Control Reference nVarChar 99 -      
Addr1_3p Third-Party Address Part 1 nVarChar 100 -      
Addr2_3p Third-Party Address Part 2 nVarChar 100 -      
Addr3_3p Third-Party Address Part 3 nVarChar 100 -      
Addr4_3p Third-Party Address Part 4 nVarChar 100 -      
CntPers_3p Third-Party Contact Person nVarChar 250 -      
CntPhon_3p Third-Party Contact Phone nVarChar 20 -      
CntFax_3p Third-Party Contact Fax nVarChar 20 -      
FreeTxt1 Free Text Line 1 nVarChar 70 -      
FreeTxt2 Free Text Line 2 nVarChar 70 -      
FreeTxt3 Free Text Line 3 nVarChar 70 -      
FreeTxt4 Free Text Line 4 nVarChar 70 -      
FreeTxt5 Free Text Line 5 nVarChar 70 -      
ValidKey Validation Key Identification nVarChar 35 -      
ISDeclOffc Intrastat Declaration Office nVarChar 10 -      
ReleaseVer Release Version nVarChar 13 -      
UserSign Created by User Int 6 -      
PosCredVal Positive Credit Memo Values VarChar 1 - Y Y Yes
            N No
IncPrevDoc Include Previous Documents VarChar 1 -   Y Yes
            N No
DeclPeriod Declaration Period VarChar 1 - M M Monthly
            Q Quarterly
Box1 Box 1: Periodicity Int 6 - 0 0 None of the Other Cases
            8 First Month of Quarter
            9 First and Second Months of Quarter
Box2 Box 2: Company Activity Int 6 - 0 0 None of the Other Cases
            7 First Declaration
            8 Stop Activity/Change of Federal Tax ID
            9 First Declaration After Federal Tax ID Change
GroupData Group Display Data VarChar 1 - Y Y Yes
            N No
CstRecSt Custom Section nVarChar 6 -      
TaxCodeExt Tax Code Extension nVarChar 99 -      
ExportPath Export Path Text 16 -      
LLEFMAbs EFM Template ID Int 11 -      
SimpProc Simplified Procedure VarChar 1 -   Y Yes
            N No
DspNMass Require All Data VarChar 1 -   Y Yes
            N No
ExlDocQt Exclude Docs W/ Qty Less Than VarChar 1 -   Y Yes
            N No
DocQtLm Document Quantity Limit Num 19.6 -      
ExlDocAm Exclude Docs W/ Amt Less Than VarChar 1 -   Y Yes
            N No
DocAmLm Document Amount Limit Num 19.6 -      
RunTime Time of Run Int 6 -      
AddonRun Upgraded Add-On Run VarChar 1 - N Y Yes
            N No
BaseDecl Base Declaration Int 11 ODCI      
GroupTrans Group Transactions VarChar 1 - N Y Yes
            N No
IncGRandDL Include Goods Receipt and Deliveries VarChar 1 - Y Y Yes
            N No
Key Unique Field
PRIMARY Yes AbsEntry