📚 SAP Business One SDK Help

Table Name: SOI3

Table Description: Statement of Import - Invoices

Field Description Type Size Related Default Value Constraints
WizardId Wizard ID Int 11 -      
SOINum Statement No. Int 11 -      
AgrNum Blanket Agreement No. Int 11 -      
AgrNo Blanket Agreement Entry Int 11 OOAT      
CardCode Customer/Vendor Code nVarChar 15 OCRD      
CardName Customer/Vendor Name nVarChar 200 -      
PayToCtry BP Pay-to Country/Region nVarChar 3 -      
PmntNum Payment No. Int 11 -      
PmntEntry Payment Entry Int 11 OVPM      
PmntType Payment Type Int 11 -      
PmntDate Payment Date Date 8 -      
ExcBasSum Sum of Excise Base Amount Num 19.6 -      
ExciseSum Sum of Excise Amount Num 19.6 -      
VatBaseSum Sum of VAT Base Amount Num 19.6 -      
VatSum Total of VAT Num 19.6 -      
RegNo Registration No. nVarChar 18 -      
RegDate Registration Date Date 8 -      
ExecStat Execution Status VarChar 1 - S S Saved
            E Executed
BPLId Branch Int 11 OBPL      
Key Unique Field
PRIMARY Yes WizardId
    SOINum