|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Resources - Prices
Table Name: RSC2
Table Description: Resources - Prices
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| ResCode | Internal Resource ID | nVarChar | 50 | ORSC | Â | Â | Â |
| PriceList | Price List No. | Int | 11 | OPLN | Â | Â | Â |
| Price | List Price | Num | 19.6 | - | Â | Â | Â |
| Currency | Currency for List Price | nVarChar | 3 | OCRN | Â | Â | Â |
| Ovrwritten | Manual Price Entry | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| Factor | Factor | Num | 19.6 | - | Â | Â | Â |
| LogInstanc | Log Instance | Int | 11 | - | 0 | Â | Â |
| ObjType | Object | nVarChar | 20 | ADP1 | 290 | Â | Â |
| AddPrice1 | Additional Price (1) | Num | 19.6 | - | Â | Â | Â |
| Currency1 | Currency for Add. Price 1 | nVarChar | 3 | OCRN | Â | Â | Â |
| AddPrice2 | Additional Price (2) | Num | 19.6 | - | Â | Â | Â |
| Currency2 | Currency for Add. Price 2 | nVarChar | 3 | OCRN | Â | Â | Â |
| Ovrwrite1 | Manual Price Entry (1) | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| Ovrwrite2 | Manual Price Entry (2) | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| Key | Unique | Field |
| PRIMARY | Yes | ResCode |
| Â | Â | PriceList |
| CURRENCY | No | Currency |
| PRICE_LIST | No | PriceList |
| MANUAL | No | Ovrwritten |