|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Sls Ord. - Drawn Dpm Detail
Table Name: RDR11
Table Description: Sls Ord. - Drawn Dpm Detail
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| DocEntry | Document Internal ID | Int | 11 | ORDR | Â | Â | Â |
| LineNum | Row Number | Int | 11 | - | Â | Â | Â |
| LineSeq | Sequence Number | Int | 11 | - | Â | Â | Â |
| BaseAbs | Base Document Internal ID | Int | 11 | - | Â | Â | Â |
| BaseType | Base Object Type | Int | 11 | - | -1 | -1 | Â |
| VatGroup | VAT Group Code | nVarChar | 8 | OVTG | Â | Â | Â |
| VatPrcnt | VAT Percent | Num | 19.6 | - | Â | Â | Â |
| LineTotal | Net LC | Num | 19.6 | - | Â | Â | Â |
| TotalFrgn | Net FC | Num | 19.6 | - | Â | Â | Â |
| TotalSumSy | Net SC | Num | 19.6 | - | Â | Â | Â |
| VatSum | Tax LC | Num | 19.6 | - | Â | Â | Â |
| VatSumFrgn | Tax FC | Num | 19.6 | - | Â | Â | Â |
| VatSumSys | Tax SC | Num | 19.6 | - | Â | Â | Â |
| ObjType | Object Type | nVarChar | 20 | ADP1 | 17 | Â | Â |
| LogInstanc | Log Instance | Int | 11 | - | Â | Â | Â |
| IsAcq | Acquisition Tax-Liable | VarChar | 1 | - | N | N | No |
| Â | Â | Â | Â | Â | Â | Y | Yes |
| IsAllDrawn | Remaining Amount Drawn | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| IsGross | Is Gross Line | VarChar | 1 | - | N | N | Net Line |
| Â | Â | Â | Â | Â | Â | Y | Gross Line |
| Gross | Gross LC | Num | 19.6 | - | Â | Â | Â |
| GrossFc | Gross FC | Num | 19.6 | - | Â | Â | Â |
| GrossSc | Gross SC | Num | 19.6 | - | Â | Â | Â |
| ApplNet | Applied Net LC | Num | 19.6 | - | Â | Â | Â |
| ApplNetFc | Applied Net FC | Num | 19.6 | - | Â | Â | Â |
| ApplNetSc | Applied Net SC | Num | 19.6 | - | Â | Â | Â |
| ApplVat | Applied Tax LC | Num | 19.6 | - | Â | Â | Â |
| ApplVatFc | Applied Tax FC | Num | 19.6 | - | Â | Â | Â |
| ApplVatSc | Applied Tax SC | Num | 19.6 | - | Â | Â | Â |
| BaseNet | Base Net LC | Num | 19.6 | - | Â | Â | Â |
| BaseNetFc | Base Net FC | Num | 19.6 | - | Â | Â | Â |
| BaseNetSc | Base Net SC | Num | 19.6 | - | Â | Â | Â |
| BaseVat | Base Tax LC | Num | 19.6 | - | Â | Â | Â |
| BaseVatFc | Base Tax FC | Num | 19.6 | - | Â | Â | Â |
| BaseVatSc | Base Tax SC | Num | 19.6 | - | Â | Â | Â |
| BaseGross | Base Gross LC | Num | 19.6 | - | Â | Â | Â |
| BaseGrossF | Base Gross FC | Num | 19.6 | - | Â | Â | Â |
| BaseGrossS | Base Gross SC | Num | 19.6 | - | Â | Â | Â |
| LineType | Line Type | VarChar | 1 | - | D | D | Document Row |
| Â | Â | Â | Â | Â | Â | R | Currency Rounding |
| Â | Â | Â | Â | Â | Â | H | Down Payment Document Rounding |
| DctSum | Deductible Sum LC | Num | 19.6 | - | Â | Â | Â |
| DctSumFc | Deductible Sum FC | Num | 19.6 | - | Â | Â | Â |
| DctSumSc | Deductible Sum SC | Num | 19.6 | - | Â | Â | Â |
| EqSum | Equalization Sum LC | Num | 19.6 | - | Â | Â | Â |
| EqSumFc | Equalization Sum FC | Num | 19.6 | - | Â | Â | Â |
| EqSumSc | Equalization Sum SC | Num | 19.6 | - | Â | Â | Â |
| ApplDct | Applied Deductible Sum LC | Num | 19.6 | - | Â | Â | Â |
| ApplDctFc | Applied Deductible Sum FC | Num | 19.6 | - | Â | Â | Â |
| ApplDctSc | Applied Deductible Sum SC | Num | 19.6 | - | Â | Â | Â |
| ApplEq | Applied Equalization Sum LC | Num | 19.6 | - | Â | Â | Â |
| ApplEqFc | Applied Equalization Sum FC | Num | 19.6 | - | Â | Â | Â |
| ApplEqSc | Applied Equalization Sum SC | Num | 19.6 | - | Â | Â | Â |
| BaseDct | Base Deductible Sum LC | Num | 19.6 | - | Â | Â | Â |
| BaseDctFc | Base Deductible Sum FC | Num | 19.6 | - | Â | Â | Â |
| BaseDctSc | Base Deductible Sum SC | Num | 19.6 | - | Â | Â | Â |
| BaseEq | Base Equalization Sum LC | Num | 19.6 | - | Â | Â | Â |
| BaseEqFc | Base Equalization Sum FC | Num | 19.6 | - | Â | Â | Â |
| BaseEqSc | Base Equalization Sum SC | Num | 19.6 | - | Â | Â | Â |
| TaxCode | Tax Code | nVarChar | 8 | OSTC | Â | Â | Â |
| ApplGross | Applied Gross LC | Num | 19.6 | - | Â | Â | Â |
| ApplGrossF | Applied Gross FC | Num | 19.6 | - | Â | Â | Â |
| ApplGrossS | Applied Gross SC | Num | 19.6 | - | Â | Â | Â |
| TaxAdjust | Manual Tax Adjustment | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| RvsChrgSum | Reverse Charge Sum LC | Num | 19.6 | - | Â | Â | Â |
| RvsChrgFc | Reverse Charge Sum FC | Num | 19.6 | - | Â | Â | Â |
| RvsChrgSc | Reverse Charge Sum SC | Num | 19.6 | - | Â | Â | Â |
| BasRvsChrg | Base Reverse Charge LC | Num | 19.6 | - | Â | Â | Â |
| BasRvsFc | Base Reverse Charge FC | Num | 19.6 | - | Â | Â | Â |
| BasRvsSc | Base Reverse Charge SC | Num | 19.6 | - | Â | Â | Â |
| ApplRvs | Applied Reverse Charge LC | Num | 19.6 | - | Â | Â | Â |
| ApplRvsFc | Applied Reverse Charge FC | Num | 19.6 | - | Â | Â | Â |
| ApplRvsSc | Applied Reverse Charge SC | Num | 19.6 | - | Â | Â | Â |
| IsCstmAct | Apply Customer Accounting Tax Rule | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| Key | Unique | Field |
| PRIMARY | Yes | DocEntry |
| Â | Â | LineNum |
| Â | Â | LineSeq |