| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | DocEntry | Internal Number | int | 11 | 0 | | | | Allow NULL? |
| 2 | DocNum | Document Number | int | 11 | 0 | | | | Allow NULL? |
| 3 | Series | Series | int | 11 | 0 | NNM1 | | | Allow NULL? |
| 4 | CountDate | Date of Counting | date | 8 | 0 | | | | |
| 5 | Time | Time of Counting | int | 11 | 0 | | | | Allow NULL? |
| 6 | CountType | Counting Type | char | 1 | 0 | | 1 | 1=Single Counter, 2=Multiple Counters | Allow NULL? |
| 7 | Taker1Type | Type of Counter | int | 11 | 0 | | 12 | 12=User, 171=Employee | Allow NULL? |
| 8 | Taker1Id | Counter ID | int | 11 | 0 | | | | Allow NULL? |
| 9 | Taker2Type | - | int | 11 | 0 | | 12 | 12=User, 171=Employee | Allow NULL? |
| 10 | Taker2Id | - | int | 11 | 0 | | | | Allow NULL? |
| 11 | Status | Status | char | 1 | 0 | | O | C=Closed, O=Open | Allow NULL? |
| 12 | Ref2 | Reference 2 | nvarchar | 11 | 0 | | | | Allow NULL? |
| 13 | Remarks | Remarks | text | 16 | 0 | | | | |
| 14 | LogIns | Log Instance - History | int | 11 | 0 | | | | Allow NULL? |
| 15 | UserSign | User Creating - History | int | 6 | 0 | OUSR | | | Allow NULL? |
| 16 | UserSign2 | Updating User - History | int | 6 | 0 | OUSR | | | Allow NULL? |
| 17 | UpdateDate | Date of Update - History | date | 8 | 0 | | | | |
| 18 | CreateDate | Create Date - History | date | 8 | 0 | | | | |
| 19 | ObjType | Object Type | nvarchar | 20 | 0 | | 1470000065 | | Allow NULL? |
| 20 | WddStatus | Authorization Status | char | 1 | 0 | | - | -=Without, A=Generated by Authorizer, C=Approved, N=Rejected, P=Generated, W=Pending, Y=Approved | Allow NULL? |
| 21 | DraftKey | Draft Document Internal ID | int | 11 | 0 | OICD | -1 | | Allow NULL? |
| 22 | Printed | Printed | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 23 | BPLId | Branch | int | 11 | 0 | OBPL | | | Allow NULL? |
| 24 | BPLName | Branch Name | nvarchar | 100 | 0 | | | | Allow NULL? |
| 25 | TeamCount | Count of Team Counters | int | 11 | 0 | | 0 | | Allow NULL? |
| 26 | IndvCount | Count of Individual Counters | int | 11 | 0 | | 0 | | Allow NULL? |
| 27 | DiffQty | Total Difference | num | 19 | 6 | | | | Allow NULL? |
| 28 | DiffPercen | Total Difference (%) | num | 19 | 6 | | | | Allow NULL? |
| 29 | UpdateTS | Update Full Time | int | 11 | 0 | | | | Allow NULL? |
| 30 | CreateTime | Generation Time | int | 6 | 0 | | | | Allow NULL? |
| 31 | PIndicator | Period Indicator | nvarchar | 10 | 0 | OPID | | | Allow NULL? |
| 32 | FinncPriod | Posting Period | int | 11 | 0 | OFPR | | | Allow NULL? |
| 33 | PostDate | Posting Date | date | 8 | 0 | | | | |
| 34 | VersionNum | Version Number | nvarchar | 11 | 0 | | | | Allow NULL? |
| 35 | DataSource | Data Source | char | 1 | 0 | | N | A=Auto Summary, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Upgrade | Allow NULL? |
