📚 SAP Business One SDK Help

Table Name: ISW3

Table Description: Declaration Rows

Field Description Type Size Related Default Value Constraints
WizAbsEnt Wizard Run Key Int 11 OISW      
Line Declaration Line Int 11 -      
ItemCode Item Code nVarChar 50 OITM      
RowStatus Row Status VarChar 1 - O    
CardCode Business Partner Code nVarChar 15 OCRD      
ObjType Document Type Int 11 -      
DocNum Document Number Int 11 -      
DocLineNum Document Line Number Int 11 -      
RecpType Receipt Type VarChar 1 -      
DocBillDt Document Billing Date Date 8 -      
Quantity Quantity Num 19.6 -      
BPCtry Sender or Receiver Country/Region nVarChar 3 -      
TaxCodeExt Tax Code Extension nVarChar 12 -      
NetMassSgn Net Mass Sign VarChar 1 - + + Positive
            - Negative
NetMass Net Mass Num 19.6 -      
NetMassUnt Net Mass Unit nVarChar 12 -      
SupMassSgn Supplementary Mass Sign VarChar 1 - + + Positive
            - Negative
SupplMass Supplementary Mass Num 19.6 -      
SupplUnit Supplementary Unit nVarChar 50 -      
ValueSgn Value Sign VarChar 1 - + + Positive
            - Negative
Value Value Num 19.6 -      
ValueFC Value in Foreign Currency Num 19.6 -      
FCCurrency Foreign Currency nVarChar 3 -      
StatValSgn Statistical Value Sign VarChar 1 -   + Positive
            - Negative
StatVal Statistical Value Num 19.6 -      
ReturnID Return Identifier VarChar 1 -      
Include Include Line in Report VarChar 1 - Y Y Yes
            N No
IsChanged Changed Line Flag VarChar 1 - N Y Yes
            N No
DstRegCry Destination Country - Region nVarChar 3 -      
DstRegSta Destination Region State nVarChar 12 -      
OriRegCry Origin Region Country nVarChar 3 -      
OriRegSta Origin Region State nVarChar 12 -      
BpVATregNo VAT Registration No. nVarChar 32 -      
CtryOrig Country/Region of Origin nVarChar 3 -      
Incoterms Incoterms nVarChar 12 -      
NatOfTrans Nature of Transaction nVarChar 50 -      
TransMode Transport Mode nVarChar 12 -      
PortEnEx Port of Entry or Exit nVarChar 50 -      
CustProc Custom Procedure nVarChar 50 -      
StatProc Statistical Procedure nVarChar 50 -      
DomFrgID Domestic/Foreign Identifier VarChar 1 -      
ItemType Item Type VarChar 1 - I I Item
            S Service
            N Item Not Relevant to Intrastat
CommCode Commodity Code nVarChar 12 -      
SerCode Service Code nVarChar 12 -      
SerSupplM Service Supply Method VarChar 1 - I I Immediate
            R To More Resumptions
SerPymMeth Service Payment Method VarChar 1 - A A Accredited to Bank Account
            B Bank Transfer
            X Other
CorrDate Correction Date Date 8 -      
CorrSgn Correction Sign VarChar 1 - + + Positive
            - Negative
ReferDoc Referenced Document Int 11 -      
ReferDocNo Referenced Document No. Int 11 -      
ReferItem Referred Item nVarChar 50 OITM      
RefDocLine Referenced Document Line Int 11 -      
ChgID Changed Data Record ID nVarChar 16 -      
ChgUser Changed By nVarChar 50 -      
ChgTimest Time Stamp of Change Date 8 -      
Deleted Deleted Indicator VarChar 1 - N N No
            Y Yes
CstSecRc Custom Section nVarChar 6 -      
CorrMonth Ref. Mo. of Summary to Correct Int 6 -      
CorrYear Ref. Yr of Summary to Correct Int 6 -      
CorrDeclNo No. of Declaration to Correct Int 11 -      
CorRowNo Row No. Inside Sec. 3 to Correct Int 11 -      
DeclRowNo Declaration File Row No. Int 11 -      
CorrType Referred Type of Receipt Int 11 -      
CntryPay State Code for Payment nVarChar 3 -      
Triangular Triangular Trade VarChar 1 - N N No
            Y Yes
CardName Business Partner Name nVarChar 200 -      
StatCode Statistical Code nVarChar 2 -      
DocEntry Document Entry Int 11 -      
NetValue Net Value Num 19.6 -      
NetValueFC Net Value in FC Num 19.6 -      
Freight Freight Sum Num 19.6 -      
FreighFC Freight Sum in FC Num 19.6 -      
RateFC Currency Rate for FC Num 19.6 -      
Remarks Remarks nVarChar 250 -      
ProtocolN Protocol Number Int 11 -      
DropShip Drop-Ship VarChar 1 - N Y Yes
            N No
WhsZipCode Warehouse Zip Code nVarChar 20 -      
ValBefDsc Value Before Discount Num 19.6 -      
CoOQty Country of Origin Quantity Num 19.6 -      
CoOLineNum CoO Line Number Int 11 -      
Key Unique Field
PRIMARY Yes WizAbsEnt
    Line