|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Inventory Counting - History
Table Name: AINC
Table Description: Inventory Counting - History
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| DocEntry | Internal Number | Int | 11 | - | Â | Â | Â |
| DocNum | Document Number | Int | 11 | - | Â | Â | Â |
| Series | Series | Int | 11 | NNM1 | Â | Â | Â |
| CountDate | Date of Counting | Date | 8 | - | Â | Â | Â |
| Time | Time of Counting | Int | 11 | - | Â | Â | Â |
| CountType | Counting Type | VarChar | 1 | - | 1 | 1 | Single Counter |
| Â | Â | Â | Â | Â | Â | 2 | Multiple Counters |
| Taker1Type | Type of Counter | Int | 11 | - | 12 | 12 | User |
| Â | Â | Â | Â | Â | Â | 171 | Employee |
| Taker1Id | Counter ID | Int | 11 | - | Â | Â | Â |
| Taker2Type | - | Int | 11 | - | 12 | Â | Â |
| Taker2Id | - | Int | 11 | - | Â | Â | Â |
| Status | Status | VarChar | 1 | - | O | O | Open |
| Â | Â | Â | Â | Â | Â | C | Closed |
| Ref2 | Reference 2 | nVarChar | 11 | - | Â | Â | Â |
| Remarks | Remarks | Text | 16 | - | Â | Â | Â |
| LogIns | Log Instance - History | Int | 11 | - | Â | Â | Â |
| UserSign | User Creating - History | Int | 6 | OUSR | Â | Â | Â |
| UserSign2 | Updating User - History | Int | 6 | OUSR | Â | Â | Â |
| UpdateDate | Date of Update - History | Date | 8 | - | Â | Â | Â |
| CreateDate | Create Date - History | Date | 8 | - | Â | Â | Â |
| ObjType | Object Type | nVarChar | 20 | - | 1470000065 | Â | Â |
| WddStatus | Authorization Status | VarChar | 1 | - | - | - | Without |
| Â | Â | Â | Â | Â | Â | W | Pending |
| Â | Â | Â | Â | Â | Â | Y | Approved |
| Â | Â | Â | Â | Â | Â | N | Rejected |
| Â | Â | Â | Â | Â | Â | P | Approved |
| Â | Â | Â | Â | Â | Â | A | Generated by Authorizer |
| Â | Â | Â | Â | Â | Â | C | Canceled |
| DraftKey | Draft Document Internal ID | Int | 11 | OICD | -1 | Â | Â |
| Printed | Printed | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| BPLId | Branch | Int | 11 | OBPL | Â | Â | Â |
| BPLName | Branch Name | nVarChar | 200 | - | Â | Â | Â |
| TeamCount | Count of Team Counters | Int | 11 | - | 0 | Â | Â |
| IndvCount | Count of Individual Counters | Int | 11 | - | 0 | Â | Â |
| DiffQty | Total Difference | Num | 19.6 | - | Â | Â | Â |
| DiffPercen | Total Difference (%) | Num | 19.6 | - | Â | Â | Â |
| UpdateTS | Update Full Time | Int | 11 | - | Â | Â | Â |
| CreateTime | Generation Time | Int | 6 | - | Â | Â | Â |
| PIndicator | Period Indicator | nVarChar | 10 | - | ' ' | Â | Â |
| FinncPriod | Posting Period | Int | 11 | - | Â | Â | Â |
| PostDate | Posting Date | Date | 8 | - | Â | Â | Â |
| VersionNum | Version Number | nVarChar | 13 | - | Â | Â | Â |
| DataSource | Data Source | VarChar | 1 | - | N | N | Unknown |
| Â | Â | Â | Â | Â | Â | I | Interface |
| Â | Â | Â | Â | Â | Â | U | Upgrade |
| Â | Â | Â | Â | Â | Â | M | Import |
| Â | Â | Â | Â | Â | Â | O | DI API |
| Â | Â | Â | Â | Â | Â | S | Service Layer |
| Â | Â | Â | Â | Â | Â | W | Web Client |
| Â | Â | Â | Â | Â | Â | A | Auto Summary |
| Â | Â | Â | Â | Â | Â | D | Restore Wizard |
| Â | Â | Â | Â | Â | Â | P | Partner Implementation |
| Â | Â | Â | Â | Â | Â | T | Year Transfer |
| AtcEntry | Attachment Entry | Int | 11 | OATC | Â | Â | Â |
| Attachment | Attachment | Text | 16 | - | Â | Â | Â |
| YearEndDt | End of Fiscal Year | Date | 8 | - | Â | Â | Â |
| UpdateTime | Update Time | Int | 11 | - | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | DocEntry |
| Â | Â | LogIns |
| SERIES | Yes | Series |
| Â | Â | DocNum |
| Â | Â | LogIns |