|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Delivery - Drawn Dpm Applied
Table Name: DLN15
Table Description: Delivery - Drawn Dpm Applied
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| DocEntry | Document Internal ID | Int | 11 | ODLN | Â | Â | Â |
| LineNum | Row Number | Int | 11 | - | Â | Â | Â |
| ObjType | object type | nVarChar | 20 | ADP1 | 15 | Â | Â |
| LogInstanc | Log Instance | Int | 11 | - | 0 | Â | Â |
| VatGroup | VAT Group Code | nVarChar | 8 | OVTG | Â | Â | Â |
| StaCode | Tax Authority Code | nVarChar | 8 | - | Â | Â | Â |
| StaType | Tax Authority Type | Int | 11 | - | Â | Â | Â |
| StaIndex | Tax Authority Seq Index | Int | 11 | - | Â | Â | Â |
| BaseNet | Net LC | Num | 19.6 | - | Â | Â | Â |
| BaseNetFc | Net FC | Num | 19.6 | - | Â | Â | Â |
| BaseNetSc | Net SC | Num | 19.6 | - | Â | Â | Â |
| VatSum | Tax LC | Num | 19.6 | - | Â | Â | Â |
| VatSumFc | Tax FC | Num | 19.6 | - | Â | Â | Â |
| VatSumSc | Tax SC | Num | 19.6 | - | Â | Â | Â |
| 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 | - | Â | Â | Â |
| 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 | - | Â | Â | Â |
| 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 | - | Â | Â | Â |
| PaidNet | Paid Net LC | Num | 19.6 | - | Â | Â | Â |
| PaidNetFc | Paid Net FC | Num | 19.6 | - | Â | Â | Â |
| PaidNetSc | Paid Net SC | Num | 19.6 | - | Â | Â | Â |
| PaidVat | Paid Tax LC | Num | 19.6 | - | Â | Â | Â |
| PaidVatFc | Paid Tax FC | Num | 19.6 | - | Â | Â | Â |
| PaidVatSc | Paid Tax SC | Num | 19.6 | - | Â | Â | Â |
| PaidDct | Paid Deductible Sum LC | Num | 19.6 | - | Â | Â | Â |
| PaidDctFc | Paid Deductible Sum FC | Num | 19.6 | - | Â | Â | Â |
| PaidDctSc | Paid Deductible Sum SC | Num | 19.6 | - | Â | Â | Â |
| PaidEq | Paid Equalization Sum LC | Num | 19.6 | - | Â | Â | Â |
| PaidEqFc | Paid Equalization Sum FC | Num | 19.6 | - | Â | Â | Â |
| PaidEqSc | Paid Equalization Sum SC | Num | 19.6 | - | Â | Â | Â |
| DpApplNet | Dpm Appl Net LC | Num | 19.6 | - | Â | Â | Â |
| DpApplNetF | Dpm Appl Net FC | Num | 19.6 | - | Â | Â | Â |
| DpApplNetS | Dpm Appl Net SC | Num | 19.6 | - | Â | Â | Â |
| DpApplVat | Dpm Appl Tax LC | Num | 19.6 | - | Â | Â | Â |
| DpApplVatF | Dpm Appl Tax FC | Num | 19.6 | - | Â | Â | Â |
| DpApplVatS | Dpm Appl Tax SC | Num | 19.6 | - | Â | Â | Â |
| DpApplDct | Dpm Appl Deductible Sum LC | Num | 19.6 | - | Â | Â | Â |
| DpApplDctF | Dpm Appl Deductible Sum FC | Num | 19.6 | - | Â | Â | Â |
| DpApplDctS | Dpm Appl Deductible Sum SC | Num | 19.6 | - | Â | Â | Â |
| DpApplEq | Dpm Appl Equalization Sum LC | Num | 19.6 | - | Â | Â | Â |
| DpApplEqFc | Dpm Appl Equalization Sum FC | Num | 19.6 | - | Â | Â | Â |
| DpApplEqSc | Dpm Appl Equalization Sum SC | Num | 19.6 | - | Â | Â | Â |
| TaxCode | Tax Code | nVarChar | 8 | OSTC | Â | Â | Â |
| LineType | Row Type | VarChar | 1 | - | D | D | Document |
| Â | Â | Â | Â | Â | Â | R | Exchange Rate Rounding |
| Â | Â | Â | Â | Â | Â | H | Document Header Rounding |
| BaseGrs | Gross LC | Num | 19.6 | - | Â | Â | Â |
| BaseGrsFc | Gross FC | Num | 19.6 | - | Â | Â | Â |
| BaseGrsSc | Gross SC | Num | 19.6 | - | Â | Â | Â |
| ApplGrs | Applied Gross LC | Num | 19.6 | - | Â | Â | Â |
| ApplGrsFc | Applied Gross FC | Num | 19.6 | - | Â | Â | Â |
| ApplGrsSc | Applied Gross SC | Num | 19.6 | - | Â | Â | Â |
| PaidGrs | Paid Gross LC | Num | 19.6 | - | Â | Â | Â |
| PaidGrsFc | Paid Gross FC | Num | 19.6 | - | Â | Â | Â |
| PaidGrsSc | Paid Gross SC | Num | 19.6 | - | Â | Â | Â |
| DpApplGrs | Dpm Appl Gross LC | Num | 19.6 | - | Â | Â | Â |
| DpApplGrsF | Dpm Appl Gross FC | Num | 19.6 | - | Â | Â | Â |
| DpApplGrsS | Dpm Appl Gross SC | Num | 19.6 | - | Â | Â | Â |
| RvsChrgSum | Reverse Charge Sum | Num | 19.6 | - | Â | Â | Â |
| RvsChrgSc | Reverse Charge Sum (SC) | Num | 19.6 | - | Â | Â | Â |
| RvsChrgFc | Reverse Charge Sum (FC) | Num | 19.6 | - | Â | Â | Â |
| ApplRvs | Applied Reverse Charge Sum LC | Num | 19.6 | - | Â | Â | Â |
| ApplRvsSc | Applied Reverse Charge Sum SC | Num | 19.6 | - | Â | Â | Â |
| ApplRvsFc | Applied Reverse Charge Sum FC | Num | 19.6 | - | Â | Â | Â |
| PaidRvs | Paid Reverse Charge Sum LC | Num | 19.6 | - | Â | Â | Â |
| PaidRvsSc | Paid Reverse Charge Sum SC | Num | 19.6 | - | Â | Â | Â |
| PaidRvsFc | Paid Reverse Charge Sum FC | Num | 19.6 | - | Â | Â | Â |
| DpApplRvs | Dpm Applied Reverse Charge LC | Num | 19.6 | - | Â | Â | Â |
| DpApplRvsS | Dpm Applied Reverse Charge SC | Num | 19.6 | - | Â | Â | Â |
| DpApplRvsF | Dpm Applied Reverse Charge FC | Num | 19.6 | - | Â | Â | Â |
| IsPrscGood | Is Prescribed Goods | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| IsCstmAct | Apply Customer Accounting Tax Rule | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| Key | Unique | Field |
| PRIMARY | Yes | DocEntry |
| Â | Â | LineNum |