|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Sales Order Rows - Distributed Expenses
Table Name: RDR13
Table Description: Sales Order Rows - Distributed Expenses
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| DocEntry | Document Internal ID | Int | 11 | ORDR | Â | Â | Â |
| LineNum | Row Number | Int | 11 | - | Â | Â | Â |
| GroupNum | Group Number | Int | 11 | - | Â | Â | Â |
| 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 | - | Â | Â | Â |
| ObjType | Object Type | nVarChar | 20 | ADP1 | 17 | Â | Â |
| LogInstanc | Log Instance | Int | 11 | - | 0 | Â | Â |
| 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 | Aquisition Tax | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| TaxCode | Tax Code | nVarChar | 8 | OSTC | Â | Â | Â |
| TaxType | Tax Type | VarChar | 1 | - | Y | Y | Normal Tax |
| Â | Â | Â | Â | Â | Â | N | No Tax |
| Â | Â | Â | Â | Â | Â | U | Use Tax |
| VatApplied | VAT Applied | Num | 19.6 | - | Â | Â | Â |
| VatAppldFC | VAT Applied Frgn | Num | 19.6 | - | Â | Â | Â |
| VatAppldSC | VAT Applied Sys | 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 | - | Â | Â | Â |
| lineVatlF | Net Tax Amount (FC) | Num | 19.6 | - | Â | Â | Â |
| lineVatS | Net Tax Amount (SC) | Num | 19.6 | - | Â | Â | Â |
| WtLiable | WTax Liable | VarChar | 1 | - | Â | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| BaseMethod | Base Method | VarChar | 1 | - | Â | N | None |
| Â | Â | Â | Â | Â | Â | Q | Quantity |
| Â | Â | Â | Â | Â | Â | V | Volume |
| Â | Â | Â | Â | Â | Â | W | Weight |
| Â | Â | Â | Â | Â | Â | T | Total |
| Â | Â | Â | Â | Â | Â | A | All |
| Stock | Stock | VarChar | 1 | - | N | 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 | - | Â | Â | Â |
| BaseRef | Base Document Reference | Int | 11 | - | Â | Â | Â |
| BaseLnNum | Base Document Line No. | Int | 11 | - | Â | Â | Â |
| TrgType | Target Type | Int | 11 | - | Â | Â | Â |
| TrgAbsEnt | Target Abs. Entry | Int | 11 | - | -1 | Â | Â |
| BaseGroup | Base Document Group | Int | 11 | - | -1 | Â | Â |
| Status | Status | VarChar | 1 | - | O | O | Open |
| Â | Â | Â | Â | Â | Â | C | Close |
| TrgGroup | Target Group | Int | 11 | - | -1 | Â | Â |
| VisOrder | Visual Order | Int | 11 | - | Â | Â | Â |
| DistrbMthd | Distribution Method | VarChar | 1 | - | Â | N | None |
| Â | Â | Â | Â | Â | Â | Q | Quantity |
| Â | Â | Â | Â | Â | Â | V | Volume |
| Â | Â | Â | Â | Â | Â | W | Weight |
| Â | Â | Â | Â | Â | Â | E | Equally |
| Â | Â | Â | Â | Â | Â | T | Row Total |
| DistribExp | Distribute Freights | VarChar | 1 | - | Â | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| FixCurr | Fixation Currency | nVarChar | 3 | OCRN | Â | Â | Â |
| VatDscntPr | Tax Discount % | Num | 19.6 | - | Â | Â | Â |
| OcrCode | Distribution Rule | nVarChar | 8 | OOCR | Â | Â | Â |
| 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 | Â | Â | Â |
| DocFreight | Included in Operating Profit | VarChar | 1 | - | Â | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| Key | Unique | Field |
| PRIMARY | Yes | DocEntry |
| Â | Â | LineNum |
| Â | Â | GroupNum |
| LINE | No | DocEntry |
| Â | Â | LineNum |