|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Recommendation Data
Table Name: ORCM
Table Description: Recommendation Data
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| DocEntry | Internal Number | Int | 11 | - | Â | Â | Â |
| ObjAbs | Document Internal Number | Int | 11 | - | Â | Â | Â |
| ObjType | Document Number | Int | 11 | - | Â | Â | Â |
| ItemCode | Item No. | nVarChar | 50 | OITM | Â | Â | Â |
| DueDate | Order Due Date | Date | 8 | - | Â | Â | Â |
| OrderType | Order Type | VarChar | 1 | - | P | P | Purchase Order |
| Â | Â | Â | Â | Â | Â | W | Production Order |
| Â | Â | Â | Â | Â | Â | T | Inventory Transfer Request |
| Â | Â | Â | Â | Â | Â | Q | Purchase Quotation |
| Â | Â | Â | Â | Â | Â | R | Purchase Request |
| Quantity | Quantity | Num | 19.6 | - | Â | Â | Â |
| UOM | Buy or Inventory UoM | nVarChar | 100 | - | Â | Â | Â |
| CardCode | Preferred Vendor | nVarChar | 15 | OCRD | Â | Â | Â |
| Warehouse | Warehouse | nVarChar | 8 | OWHS | Â | Â | Â |
| Price | Price After Discount | Num | 19.6 | - | Â | Â | Â |
| Currency | Price Currency | nVarChar | 3 | - | Â | Â | Â |
| Origin | Order Origin | VarChar | 1 | - | M | M | MRP |
| Status | Order Status | VarChar | 1 | - | O | O | Opened |
| Â | Â | Â | Â | Â | Â | A | Accepted |
| Â | Â | Â | Â | Â | Â | P | Processed |
| Â | Â | Â | Â | Â | Â | D | Deleted |
| UserSign | User Signature | Int | 6 | OUSR | Â | Â | Â |
| DocDate | Generation Date | Date | 8 | - | Â | Â | Â |
| DocTime | Generation Time | Int | 6 | - | Â | Â | Â |
| BPLid | Business Place ID | Int | 11 | - | -1 | Â | Â |
| PriceBefDi | Unit Price | Num | 19.6 | - | Â | Â | Â |
| DiscPrcnt | Discount % Per Row | Num | 19.6 | - | Â | Â | Â |
| ReleasDate | Release Date | Date | 8 | - | Â | Â | Â |
| PriceAftV | Price after VAT | Num | 19.6 | - | Â | Â | Â |
| FromWhse | From Warehouse | nVarChar | 8 | - | Â | Â | Â |
| FstReqDate | First Request Date | Date | 8 | - | Â | Â | Â |
| UomEntry | UoM Entry | Int | 11 | - | Â | Â | Â |
| NumPerMsr | UoM Value | Num | 19.6 | - | Â | Â | Â |
| AgrNo | Agreement No. | Int | 11 | OOAT | Â | Â | Â |
| AgrLnNum | Agreement Row Number | Int | 11 | - | Â | Â | Â |
| UseDiscnt | Use BP Special Price | VarChar | 1 | - | Y | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| PriceMode | Price Mode | VarChar | 1 | - | Â | N | Net |
| Â | Â | Â | Â | Â | Â | G | Gross |
| RouDatCalc | Routing Date Calculation | VarChar | 1 | - | Â | S | On Start Date |
| Â | Â | Â | Â | Â | Â | D | On End Date |
| Â | Â | Â | Â | Â | Â | F | Start Date Onwards |
| Â | Â | Â | Â | Â | Â | B | End Date Backwards |
| UoMNum | UoM Item Per Unit Numerator | Num | 19.6 | - | Â | Â | Â |
| UoMDen | UoM Item Per Unit Denominator | Num | 19.6 | - | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | DocEntry |