| 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 | DocDate | Posting Date | date | 8 | 0 | | | | |
| 4 | Ref1 | Reference 1 | nvarchar | 11 | 0 | | | | Allow NULL? |
| 5 | Ref2 | Reference 2 | nvarchar | 11 | 0 | | | | Allow NULL? |
| 6 | Comments | Remarks | nvarchar | 254 | 0 | | | | Allow NULL? |
| 7 | JrnlMemo | Journal Remarks | nvarchar | 50 | 0 | | | | Allow NULL? |
| 8 | TransId | Transaction Number | int | 11 | 0 | OJDT | | | Allow NULL? |
| 9 | DocTime | Generation Time | int | 6 | 0 | | | | Allow NULL? |
| 10 | RevalType | Inventory Valuation Type | char | 1 | 0 | | P | M=Inventory Debit/Credit, P=Price Change | Allow NULL? |
| 11 | UpdateDate | Date of Update | date | 8 | 0 | | | | |
| 12 | CreateDate | Creation Date | date | 8 | 0 | | | | |
| 13 | Series | Series | int | 11 | 0 | NNM1 | | | Allow NULL? |
| 14 | TaxDate | Document Date | date | 8 | 0 | | | | |
| 15 | DataSource | Data Source | char | 1 | 0 | | N | A=Doc. Generation Wizard, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Upgrade | Allow NULL? |
| 16 | UserSign | User Signature | int | 6 | 0 | OUSR | | | Allow NULL? |
| 17 | UserSign2 | Updating User | int | 6 | 0 | OUSR | | | Allow NULL? |
| 18 | StationID | Workstation ID | int | 11 | 0 | CSTN | | | Allow NULL? |
| 19 | RIncmAcct | Invent. Reval. Expense Account | nvarchar | 15 | 0 | | | | Allow NULL? |
| 20 | RExpnAcct | Invent. Reval. Expense Account | nvarchar | 15 | 0 | | | | Allow NULL? |
| 21 | LogInstanc | Log Instance | int | 11 | 0 | | 0 | | Allow NULL? |
| 22 | ObjType | Object Type | nvarchar | 20 | 0 | | 162 | | Allow NULL? |
| 23 | SeqCode | Sequence Code | int | 6 | 0 | | | | Allow NULL? |
| 24 | Serial | Serial Number | int | 11 | 0 | | | | Allow NULL? |
| 25 | SeriesStr | Series String | nvarchar | 3 | 0 | | | | Allow NULL? |
| 26 | SubStr | Subseries String | nvarchar | 3 | 0 | | | | Allow NULL? |
| 27 | VersionNum | Version Number | nvarchar | 11 | 0 | | | | Allow NULL? |
| 28 | InflaReval | Inflation-Based Revaluation | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 29 | SupplCode | Supplementary Code | nvarchar | 254 | 0 | | | | Allow NULL? |
| 30 | CardCode | Customer/Vendor Code | nvarchar | 15 | 0 | OCRD | | | Allow NULL? |
| 31 | CardName | Customer/Vendor Name | nvarchar | 100 | 0 | | | | Allow NULL? |
| 32 | CreatedBy | Entry Creation Origin | char | 1 | 0 | | M | M=Created Manually by User, W=Created by Production Cost Recalculation Wizard | Allow NULL? |
