Statement of Import - Lines

Table Name: SOI5

Table Description: Statement of Import - Lines

Field	Description	Type	Size	Related	Default Value	Constraints
WizardId	Wizard ID	Int	11	-
SOINum	Statement No.	Int	11	-
DocType	Document Type	Int	11	-
DocEntry	Document Abs Entry	Int	11	-
SOILineNum	SOI Line No.	Int	11	-
DocLineNum	Line No.	Int	11	-
ItemCode	Item No.	nVarChar	50	OITM
ItemName	Item Description	nVarChar	200	-
unitMsr	UoM Name	nVarChar	100	-
Quantity	Quantity	Num	19.6	-
TotalFrgn	Total (Doc.)	Num	19.6	-
LineTotal	Total (LC)	Num	19.6	-
Currency	Currency	nVarChar	3	OCRN
Rate	Line Rate	Num	19.6	-
BaseRate	Base Currency Rate	Num	19.6	-
BasNumAtCr	Base Ref. Vendor Ref. No.	nVarChar	200	-
BaseDocNum	Base Ref. No.	Int	11	-
BaseEntry	Base Entry	Int	11	-
BasTaxDate	Base Ref. Document Date	Date	8	-
FExcBasSum	Fixed Excise Base Amount	Num	19.6	-
AExcBasSum	Ad Valorem Excise Base Amount	Num	19.6	-
ExciseUoM	Excise Units of Measure	Int	11	-
						112	Liters (m3)
						168	Tons, metric tons (1000 kg)
						251	Horsepower (1 hp = 0.75 kW)
						831	Liters of anhydrous (pure) alcohol
ExcRateUoM	Excise Rate Units of Measure	Num	19.6	-
ExcRateAdV	Excise Rate Ad Valorem	Num	19.6	-
ExciseSum	Excise Amount	Num	19.6	-
VatBaseSum	VAT Base Amount	Num	19.6	-
VatPrcnt	VAT Rate per Row	Num	19.6	-
VatSum	VAT Amount	Num	19.6	-
TaxCtgr	Tax Type (Annual List)	nVarChar	6	-
VatGroup	VAT Code	nVarChar	8	-