|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Inventory Counting - Rows
Table Name: INC1
Table Description: Inventory Counting - Rows
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| DocEntry | Internal Number | Int | 11 | OINC | Â | Â | Â |
| LineNum | Row Number | Int | 11 | - | Â | Â | Â |
| ItemCode | Item Code | nVarChar | 50 | OITM | Â | Â | Â |
| ItemDesc | Item Description | nVarChar | 200 | - | Â | Â | Â |
| Freeze | Item Freeze Status | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| WhsCode | Warehouse Code | nVarChar | 8 | OWHS | Â | Â | Â |
| InWhsQty | In-Whse Qty on Count Date | Num | 19.6 | - | Â | Â | Â |
| Counted | Counted | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| CountQty | Counted Quantity | Num | 19.6 | - | Â | Â | Â |
| CountQtyT1 | Counter 1 - Counted Quantity | Num | 19.6 | - | Â | Â | Â |
| CountQtyT2 | - | Num | 19.6 | - | Â | Â | Â |
| Remark | Remarks | nVarChar | 254 | - | Â | Â | Â |
| BarCode | Bar Code | nVarChar | 254 | - | Â | Â | Â |
| InvUoM | Inventory UoM | VarChar | 1 | - | Y | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| Difference | Difference | Num | 19.6 | - | Â | Â | Â |
| DiffPercen | Difference % | Num | 19.6 | - | Â | Â | Â |
| CountDate | Count Date | Date | 8 | - | Â | Â | Â |
| CountTime | Count Time | Int | 11 | - | Â | Â | Â |
| TargetRef | Target Document Reference | nVarChar | 16 | - | Â | Â | Â |
| TargetType | Target Document Type | Int | 11 | - | -1 | -1 | Â |
| Â | Â | Â | Â | Â | Â | 0 | Â |
| Â | Â | Â | Â | Â | Â | 10000071 | Inventory Posting |
| TargetEntr | Target Document Internal ID | Int | 11 | - | Â | Â | Â |
| TargetLine | Target Document Row | Int | 11 | - | Â | Â | Â |
| ProjCode | Project Code | nVarChar | 20 | OPRJ | Â | Â | Â |
| OcrCode | Distribution Rule Code | nVarChar | 8 | OOCR | Â | Â | Â |
| LineStatus | Row Status | VarChar | 1 | - | O | O | Open |
| Â | Â | Â | Â | Â | Â | C | Closed |
| BinEntry | Bin Location Entry | Int | 11 | OBIN | Â | Â | Â |
| VisOrder | Visual Order | Int | 11 | - | Â | Â | Â |
| OcrCode2 | Distribution Rule 2 | nVarChar | 8 | OOCR | Â | Â | Â |
| OcrCode3 | Distribution Rule 3 | nVarChar | 8 | OOCR | Â | Â | Â |
| OcrCode4 | Distribution Rule 4 | nVarChar | 8 | OOCR | Â | Â | Â |
| OcrCode5 | Distribution Rule 5 | nVarChar | 8 | OOCR | Â | Â | Â |
| FirmCode | Manufacturer | Int | 6 | OMRC | Â | Â | Â |
| SuppCatNum | Mfr Catalog No. | nVarChar | 50 | - | Â | Â | Â |
| PrefVendor | Preferred Vendor | nVarChar | 15 | OCRD | Â | Â | Â |
| LogIns | Log Instance - History | Int | 11 | - | Â | Â | Â |
| UgpEntry | UoM Group Entry | Int | 11 | OUGP | Â | Â | Â |
| IUomEntry | Inventory UoM Entry | nVarChar | 20 | OUOM | Â | Â | Â |
| CountDiff | Counters' Diff. | Num | 19.6 | - | Â | Â | Â |
| CountDiffP | Counters' Diff. (%) | Num | 19.6 | - | Â | Â | Â |
| UomCode | UoM Code for DI | nVarChar | 20 | OUOM | Â | Â | Â |
| UomQty | UoM Counted Qty for DI | Num | 19.6 | - | Â | Â | Â |
| PPTaxExRe | Plastic Packaging Tax Exemption Reason | nVarChar | 2 | - | Â | Â | Â |
| PlPaWght | Plastic Packaging Weight | Num | 19.6 | - | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | DocEntry |
| Â | Â | LineNum |