| 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 | PeriodCat | Period Category | nvarchar | 10 | 0 | | | | Allow NULL? |
| 5 | FinncPriod | Posting Period | int | 11 | 0 | OFPR | | | Allow NULL? |
| 6 | PostDate | Posting Date | date | 8 | 0 | | | | |
| 7 | DocDate | Document Date | date | 8 | 0 | | | | |
| 8 | DocStatus | Document Status | char | 1 | 0 | | P | C=Canceled, D=Draft, P=Posted | Allow NULL? |
| 9 | TransId | Transaction Number | int | 11 | 0 | OJDT | | | Allow NULL? |
| 10 | Comments | Remarks | nvarchar | 254 | 0 | | | | Allow NULL? |
| 11 | Reference | Reference | nvarchar | 32 | 0 | | | | Allow NULL? |
| 12 | ObjType | Object Type | nvarchar | 20 | 0 | | | | Allow NULL? |
| 13 | Currency | Currency | nvarchar | 3 | 0 | OCRN | | | Allow NULL? |
| 14 | DocRate | Document Rate | num | 19 | 6 | | | | Allow NULL? |
| 15 | SysRate | System Rate | num | 19 | 6 | | | | Allow NULL? |
| 16 | PIndicator | Period Indicator | nvarchar | 10 | 0 | OPID | | | Allow NULL? |
| 17 | DocTotal | Document Total | num | 19 | 6 | | | | Allow NULL? |
| 18 | DocTotalFC | Document Total (FC) | num | 19 | 6 | | | | Allow NULL? |
| 19 | DocTotalSy | Document Total (SC) | num | 19 | 6 | | | | Allow NULL? |
| 20 | 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=Update | Allow NULL? |
| 21 | UserSign | User Signature | int | 6 | 0 | OUSR | | | Allow NULL? |
| 22 | LogInstanc | Log Instance | int | 11 | 0 | | 0 | | Allow NULL? |
| 23 | CreateDate | Create Date | date | 8 | 0 | | | | |
| 24 | UserSign2 | Updating User | int | 6 | 0 | OUSR | | | Allow NULL? |
| 25 | UpdateDate | Date of Update | date | 8 | 0 | | | | |
| 26 | TransType | Original Document | nvarchar | 20 | 0 | | -1 | -1=All Transactions, 13=A/R Invoice, 1470000049=Capitalization, 1470000060=Fixed Assets Credit Memo, 1470000075=Manual Depreciation, 1470000090=Fixed Assets Transfer, 1470000094=Retirement, 163=A/P Correction Invoice, 18=A/P Invoice, 19=A/P Credit Memo, 46=Outgoing Payment | Allow NULL? |
| 27 | CreatedBy | Original | int | 11 | 0 | | | | Allow NULL? |
| 28 | JrnlMemo | Journal Remarks | nvarchar | 50 | 0 | | | | Allow NULL? |
| 29 | AssetDate | Asset Value Date | date | 8 | 0 | | | | |
| 30 | CurSource | Base Currency | char | 1 | 0 | | L | F=Foreign Currency, L=Local Currency, S=System Currency | Allow NULL? |
| 31 | DocType | Document Type | nvarchar | 15 | 0 | | PL | AP=Appreciation, NC=Sales, PL=Ordinary Depreciation, SC=Scrapping, SD=Special Depreciation, TC=Asset Class Transfer, TR=Asset Transfer, UP=Unplanned Depreciation | Allow NULL? |
| 32 | PrjSmarz | Summarize by Project | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 33 | DstRlSmarz | Summarize by Distribution Rule | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 34 | ManDprType | Manual Depreciation Type | nvarchar | 15 | 0 | ODTP | | | Allow NULL? |
| 35 | Handwrtten | Manual Numbering | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 36 | CancelDate | Cancelation Date | date | 8 | 0 | | | | |
| 37 | DprArea | Depreciation Area | nvarchar | 15 | 0 | ODPA | | | Allow NULL? |
| 38 | BPLId | Branch | int | 11 | 0 | OBPL | | | Allow NULL? |
| 39 | BaseRef | Base Reference | nvarchar | 11 | 0 | | | | Allow NULL? |
| 40 | LVARetire | Low Value Asset Retirement | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 41 | CancelOpt | Cancelation Option | int | 6 | 0 | | 1 | | Allow NULL? |
| 42 | BPLName | Branch Name | nvarchar | 100 | 0 | | | | Allow NULL? |
| 43 | VatRegNum | VAT Reg. Number | nvarchar | 32 | 0 | | | | Allow NULL? |
| 44 | GdsMovType | Goods Movement Type | nvarchar | 2 | 0 | | | CI=End of Fixed Assets Use, IM=Initialization of Fixed Assets, IP=FA Use in Progress, MC=Immobilization from Current Assets, SI=Opening Balance of Fixed Assets | Allow NULL? |
