|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Intrastat Expenses
Table Name: RDR20
Table Description: Intrastat Expenses
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| DocEntry | Document Internal ID | Int | 11 | ORDR | Â | Â | Â |
| ExpnsCode | Freight Code | Int | 11 | OEXD | Â | Â | Â |
| TotalLC | Total | Num | 19.6 | - | Â | Â | Â |
| TotalFC | Total (FC) | Num | 19.6 | - | Â | Â | Â |
| TotalSC | Total (SC) | Num | 19.6 | - | Â | Â | Â |
| DistribM | Distribution Method | VarChar | 1 | - | T | Q | Quantity |
| Â | Â | Â | Â | Â | Â | V | Volume |
| Â | Â | Â | Â | Â | Â | W | Weight |
| Â | Â | Â | Â | Â | Â | E | Equally |
| Â | Â | Â | Â | Â | Â | T | Row Total |
| DrawnLC | Drawn Total | Num | 19.6 | - | Â | Â | Â |
| DrawnFC | Drawn Total (FC) | Num | 19.6 | - | Â | Â | Â |
| DrawnSC | Drawn Total (SC) | Num | 19.6 | - | Â | Â | Â |
| LineNum | Line Number | Int | 11 | - | -1 | Â | Â |
| BaseAbsEnt | Base Abs. Entry | Int | 11 | - | -1 | Â | Â |
| BaseType | Base Document Type | Int | 11 | - | -1 | 23 | Sales Quotation |
| Â | Â | Â | Â | Â | Â | 17 | Sales Order |
| Â | Â | Â | Â | Â | Â | 15 | Delivery Notes |
| Â | Â | Â | Â | Â | Â | 16 | Return |
| Â | Â | Â | Â | Â | Â | 13 | A/R Invoice |
| Â | Â | Â | Â | Â | Â | 203 | Down Payment Incoming |
| Â | Â | Â | Â | Â | Â | 204 | Down Payment Outgoing |
| Â | Â | Â | Â | Â | Â | 22 | Purchase Order |
| Â | Â | Â | Â | Â | Â | 20 | Goods Receipt PO |
| Â | Â | Â | Â | Â | Â | 21 | Goods Return |
| Â | Â | Â | Â | Â | Â | 18 | A/P Invoice |
| Â | Â | Â | Â | Â | Â | 540000006 | Purchase Quotation |
| Â | Â | Â | Â | Â | Â | 0 | Â |
| Â | Â | Â | Â | Â | Â | -1 | Â |
| BaseRef | Base Document Reference | Int | 11 | - | Â | Â | Â |
| BaseLnNum | Base Document Row No. | Int | 11 | - | -1 | Â | Â |
| LogInstanc | Log Instance | Int | 11 | - | 0 | Â | Â |
| ObjectType | Object Type | nVarChar | 20 | ADP1 | 17 | Â | Â |
| FixCurr | Fixation Currency | nVarChar | 3 | OCRN | Â | Â | Â |
| AppliedLC | Applied | Num | 19.6 | - | Â | Â | Â |
| AppliedFC | Applied (FC) | Num | 19.6 | - | Â | Â | Â |
| AppliedSC | Applied (SC) | Num | 19.6 | - | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | DocEntry |
| Â | Â | LineNum |