|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Goods Issue - Freight
Table Name: IGE3
Table Description: Goods Issue - Freight
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| DocEntry | Document Internal ID | Int | 11 | OIGE | Â | Â | Â |
| ExpnsCode | Freight Code | Int | 11 | OEXD | Â | Â | Â |
| LineTotal | Total | Num | 19.6 | - | Â | Â | Â |
| TotalFrgn | Total (FC) | Num | 19.6 | - | Â | Â | Â |
| TotalSumSy | Total (SC) | Num | 19.6 | - | Â | Â | Â |
| PaidToDate | Paid to Date | Num | 19.6 | - | Â | Â | Â |
| PaidFC | Paid (FC) | Num | 19.6 | - | Â | Â | Â |
| PaidSys | Paid (SC) | Num | 19.6 | - | Â | Â | Â |
| Comments | Remarks | nVarChar | 100 | - | Â | Â | Â |
| ObjType | Object Type | nVarChar | 20 | ADP1 | 60 | Â | Â |
| LogInstanc | Log Instance | Int | 11 | - | 0 | Â | Â |
| DistrbMthd | Distribution Method | VarChar | 1 | - | Â | N | None |
| Â | Â | Â | Â | Â | Â | Q | Quantity |
| Â | Â | Â | Â | Â | Â | V | Volume |
| Â | Â | Â | Â | Â | Â | W | Weight |
| Â | Â | Â | Â | Â | Â | E | Equally |
| Â | Â | Â | Â | Â | Â | T | Row Total |
| TaxStatus | Tax Liable | VarChar | 1 | - | Y | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| VatGroup | Tax Group | nVarChar | 8 | OVTG | Â | Â | Â |
| VatPrcnt | Row Tax % | Num | 19.6 | - | Â | Â | Â |
| VatSum | Tax Amount | Num | 19.6 | - | Â | Â | Â |
| VatSumFrgn | Tax Amount (FC) | Num | 19.6 | - | Â | Â | Â |
| VatSumSy | Tax Amount (SC) | Num | 19.6 | - | Â | Â | Â |
| DedVatSum | Deductible Tax Amount | Num | 19.6 | - | Â | Â | Â |
| DedVatSumF | Deductible Tax Amount (FC) | Num | 19.6 | - | Â | Â | Â |
| DedVatSumS | Deductible Tax Amount (SC) | Num | 19.6 | - | Â | Â | Â |
| IsAcquistn | Acquisition Tax | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| TaxCode | Tax Code | nVarChar | 8 | OSTC | Â | Â | Â |
| TaxType | Tax Type | VarChar | 1 | - | Y | Y | Regular Tax |
| Â | Â | Â | Â | Â | Â | N | No Tax |
| Â | Â | Â | Â | Â | Â | U | Use Tax |
| WTLiable | WTax Liable | VarChar | 1 | - | Â | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| VatApplied | Vat Applied | Num | 19.6 | - | Â | Â | Â |
| VatAppldFC | Applied Tax (FC) | Num | 19.6 | - | Â | Â | Â |
| VatAppldSC | Applied Tax (SC) | Num | 19.6 | - | Â | Â | Â |
| EquVatPer | Equalization Tax % | Num | 19.6 | - | Â | Â | Â |
| EquVatSum | Total Equalization Tax | Num | 19.6 | - | Â | Â | Â |
| EquVatSumF | Total Equalization Tax (FC) | Num | 19.6 | - | Â | Â | Â |
| EquVatSumS | Total Equalization Tax (SC) | Num | 19.6 | - | Â | Â | Â |
| LineVat | Net Tax Amount | Num | 19.6 | - | Â | Â | Â |
| LineVatF | Net Tax Amount (FC) | Num | 19.6 | - | Â | Â | Â |
| LineVatS | Net Tax Amount (SC) | Num | 19.6 | - | Â | Â | Â |
| BaseMethod | Drawing Method | VarChar | 1 | - | Â | N | None |
| Â | Â | Â | Â | Â | Â | Q | Quantity |
| Â | Â | Â | Â | Â | Â | V | Volume |
| Â | Â | Â | Â | Â | Â | W | Weight |
| Â | Â | Â | Â | Â | Â | T | Total |
| Â | Â | Â | Â | Â | Â | A | All |
| Stock | Stock | VarChar | 1 | - | Â | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| LstPchPrce | Last Purchase Price | VarChar | 1 | - | Â | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| AnalysRpt | Analysis Report | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| BaseAbsEnt | Base Abs Entry | Int | 11 | - | -1 | Â | Â |
| BaseType | Base Document Type | Int | 11 | - | -1 | -1 | Â |
| Â | Â | Â | Â | Â | Â | 0 | Â |
| Â | Â | Â | Â | Â | Â | 202 | Production Order |
| BaseRef | Base Document Reference | Int | 11 | - | Â | Â | Â |
| BaseLnNum | Base Document Row No. | Int | 11 | - | Â | Â | Â |
| LineNum | line num | Int | 11 | - | -1 | Â | Â |
| Status | Status | VarChar | 1 | - | O | O | Open |
| Â | Â | Â | Â | Â | Â | C | Closed |
| TrgType | Target Type | Int | 11 | - | Â | Â | Â |
| TrgAbsEnt | Target Doc. Internal No. | Int | 11 | - | -1 | Â | Â |
| StDstr | Stock Distributed Sum | Num | 19.6 | - | Â | Â | Â |
| StDstrSC | Stock Distributed Sum (SC) | Num | 19.6 | - | Â | Â | Â |
| StDstrFC | Stock Distributed Sum (FC) | Num | 19.6 | - | Â | Â | Â |
| FixCurr | Fixation Currency | nVarChar | 3 | OCRN | Â | Â | Â |
| VatDscntPr | Tax Discount % | Num | 19.6 | - | Â | Â | Â |
| OcrCode | Distribution Rule | nVarChar | 8 | OOCR | Â | Â | Â |
| TaxDistMtd | Tax Distribution Method | VarChar | 1 | - | Â | N | None |
| Â | Â | Â | Â | Â | Â | Q | Quantity |
| Â | Â | Â | Â | Â | Â | V | Volume |
| Â | Â | Â | Â | Â | Â | W | Weight |
| Â | Â | Â | Â | Â | Â | E | Equally |
| Â | Â | Â | Â | Â | Â | T | Row Total |
| OcrCode2 | Distribution Rule2 | nVarChar | 8 | OOCR | Â | Â | Â |
| OcrCode3 | Distribution Rule3 | nVarChar | 8 | OOCR | Â | Â | Â |
| OcrCode4 | Distribution Rule4 | nVarChar | 8 | OOCR | Â | Â | Â |
| OcrCode5 | Distribution Rule5 | nVarChar | 8 | OOCR | Â | Â | Â |
| Project | Project Code | nVarChar | 20 | OPRJ | Â | Â | Â |
| VatGrpSrc | VAT Group Source | VarChar | 1 | - | N | N | Not Defined |
| Â | Â | Â | Â | Â | Â | M | Manually Entered |
| Â | Â | Â | Â | Â | Â | D | Determined |
| DrawnTotal | Drawn Total | Num | 19.6 | - | Â | Â | Â |
| DrawnFC | Drawn Total (FC) | Num | 19.6 | - | Â | Â | Â |
| DrawnSC | Drawn Total (SC) | Num | 19.6 | - | Â | Â | Â |
| GrsAmount | Gross Amount | Num | 19.6 | - | Â | Â | Â |
| GrsFC | Gross Amount (FC) | Num | 19.6 | - | Â | Â | Â |
| GrsSC | Gross Amount (SC) | Num | 19.6 | - | Â | Â | Â |
| BaseTotal | Base Total for Calculation | VarChar | 1 | - | N | N | Net Total |
| Â | Â | Â | Â | Â | Â | G | Gross Total |
| RetReqLC | Return Request Amount | Num | 19.6 | - | Â | Â | Â |
| RetReqFC | Return Request Amount (FC) | Num | 19.6 | - | Â | Â | Â |
| RetReqSC | Return Request Amount (SC) | Num | 19.6 | - | Â | Â | Â |
| RRVatLC | Return Request VAT Amount | Num | 19.6 | - | Â | Â | Â |
| RRVatFC | Return Request VAT Amount (FC) | Num | 19.6 | - | Â | Â | Â |
| RRVatSC | Return Request VAT Amount (SC) | Num | 19.6 | - | Â | Â | Â |
| EncryptIV | Encrypt IV | nVarChar | 100 | - | Â | Â | Â |
| ExtTaxRate | External Tax Rate | Num | 19.6 | - | Â | Â | Â |
| ExtTaxSum | External Tax Amount | Num | 19.6 | - | Â | Â | Â |
| TaxAmtSrc | Tax Amount Source | VarChar | 1 | - | S | S | Internal System Calculation |
| Â | Â | Â | Â | Â | Â | E | External Calculation |
| ExtTaxSumF | External Tax Amount (FC) | Num | 19.6 | - | Â | Â | Â |
| ExtTaxSumS | External Tax Amount (SC) | Num | 19.6 | - | Â | Â | Â |
| CUSplit | CU Split | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| DocFreight | Included in Operating Profit | VarChar | 1 | - | Â | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| Key | Unique | Field |
| PRIMARY | Yes | DocEntry |
| Â | Â | LineNum |
| DOCUMENT | No | DocEntry |
| Â | Â | BaseAbsEnt |