| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | DocEntry | Document Internal ID | int | 11 | 0 | | | | Allow NULL? |
| 2 | CreateDate | Creation Date | date | 8 | 0 | | | | |
| 3 | DocTime | Generation Time | int | 6 | 0 | | | | Allow NULL? |
| 4 | IOffIncAcc | Inventory Offset Increase Acct | nvarchar | 15 | 0 | OACT | | | Allow NULL? |
| 5 | DOffDecAcc | Inventory Offset Decrease Acct | nvarchar | 15 | 0 | OACT | | | Allow NULL? |
| 6 | DocDate | Posting Date | date | 8 | 0 | | | | |
| 7 | Reference | Reference | nvarchar | 11 | 0 | | | | Allow NULL? |
| 8 | Comments | Remarks | nvarchar | 254 | 0 | | | | Allow NULL? |
| 9 | DocDueDate | Due Date | date | 8 | 0 | | | | |
| 10 | DataSource | Data Source | char | 1 | 0 | | N | | Allow NULL? |
| 11 | UserSign | User Signature | int | 6 | 0 | OUSR | | | Allow NULL? |
| 12 | VersionNum | Version Number | nvarchar | 11 | 0 | | | | Allow NULL? |
| 13 | JdtNum | Journal Number | int | 11 | 0 | OJDT | | | Allow NULL? |
| 14 | Reference2 | Reference 2 | nvarchar | 11 | 0 | | | | Allow NULL? |
| 15 | ObjType | Object Type | nvarchar | 20 | 0 | | 10000071 | | Allow NULL? |
| 16 | DocNum | Document Number | int | 11 | 0 | | | | Allow NULL? |
| 17 | Series | Series | int | 11 | 0 | NNM1 | | | Allow NULL? |
| 18 | PriceSrc | Price Source | int | 11 | 0 | | 3 | 1=By Price List, 2=Last Evaluated Price, 3=Item Cost | Allow NULL? |
| 19 | PriceList | Price List | int | 11 | 0 | | | | Allow NULL? |
| 20 | JrnlMemo | Journal Remarks | nvarchar | 50 | 0 | | | | Allow NULL? |
| 21 | Status | Status | char | 1 | 0 | | O | C=Close, O=Open | Allow NULL? |
| 22 | LogIns | Log Instance - History | int | 11 | 0 | | | | Allow NULL? |
| 23 | UserSign2 | Updating User - History | int | 6 | 0 | OUSR | | | Allow NULL? |
| 24 | UpdateDate | Date of Update - History | date | 8 | 0 | | | | |
| 25 | CountDate | Date of Counting | date | 8 | 0 | | | | |
| 26 | CountTime | Time of Counting | int | 11 | 0 | | | | Allow NULL? |
| 27 | WddStatus | Authorization Status | char | 1 | 0 | | - | -=Without, A=Generated by Authorizer, C=Canceled, N=Rejected, P=Generated, W=Pending, Y=Approved | Allow NULL? |
| 28 | DraftKey | Draft Document Internal ID | int | 11 | 0 | OIPD | -1 | | Allow NULL? |
| 29 | Printed | Printed | char | 1 | 0 | | N | | Allow NULL? |
| 30 | DocTotal | Document Total | num | 19 | 6 | | | | Allow NULL? |
| 31 | BPLId | Branch | int | 11 | 0 | OBPL | | | Allow NULL? |
| 32 | BPLName | Branch Name | nvarchar | 100 | 0 | | | | Allow NULL? |
| 33 | UpdateTS | Update Full Time | int | 11 | 0 | | | | Allow NULL? |
| 34 | CopyOption | DI Copy from Option | char | 1 | 0 | | 0 | 0=No Counters Diff., 1=Individual 1, 2=Individual 2, 3=Individual 3, 4=Individual 4, 5=Individual 5, 6=Team Counted Quantity | Allow NULL? |
| 35 | BaseEntry | Base Counting Doc. Entry | int | 11 | 0 | | | | Allow NULL? |
| 36 | PIndicator | Period Indicator | nvarchar | 10 | 0 | | | | Allow NULL? |
| 37 | FinncPriod | Posting Period | int | 11 | 0 | | | | Allow NULL? |
