| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | AcctCode | Account Code | nvarchar | 15 | 0 | | | | Allow NULL? |
| 2 | AcctName | Account Name | nvarchar | 100 | 0 | | | | Allow NULL? |
| 3 | CurrTotal | Current Balance | num | 19 | 6 | | | | Allow NULL? |
| 4 | EndTotal | Opening Balance | num | 19 | 6 | | | | Allow NULL? |
| 5 | Finanse | Cash Account [Y/N] | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 6 | Groups | Main Group | nvarchar | 8 | 0 | | | | Allow NULL? |
| 7 | Budget | Budget | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 8 | Frozen | Account on Hold [Y/N] | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 9 | Free_2 | Free2 | char | 1 | 0 | | | | Allow NULL? |
| 10 | Postable | Account Type [Active/Title] | char | 1 | 0 | | Y | N=Title Account, Y=Active Account | Allow NULL? |
| 11 | Fixed | Primary Account | char | 1 | 0 | | | | Allow NULL? |
| 12 | Levels | Account Level | int | 6 | 0 | | 2 | | Allow NULL? |
| 13 | ExportCode | Data Export Code | nvarchar | 10 | 0 | | | | Allow NULL? |
| 14 | GrpLine | Account Location in Group | int | 11 | 0 | | | | Allow NULL? |
| 15 | FatherNum | Parent Account Key | nvarchar | 15 | 0 | | | | Allow NULL? |
| 16 | AccntntCod | External Code | nvarchar | 12 | 0 | | | | Allow NULL? |
| 17 | CashBox | Primary Account [Y/N] | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 18 | GroupMask | Group Mask | int | 6 | 0 | | 1 | | Allow NULL? |
| 19 | RateTrans | Conversion Differences | char | 1 | 0 | | Y | N=No, Y=Yes | Allow NULL? |
| 20 | TaxIncome | Tax Definition | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 21 | ExmIncome | Tax Definition | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 22 | ExtrMatch | External Reconciliation No. | int | 11 | 0 | | | | Allow NULL? |
| 23 | IntrMatch | Internal Reconciliation No. | int | 11 | 0 | | | | Allow NULL? |
| 24 | ActType | Account Category | char | 1 | 0 | | N | E=Expenditure, I=Sales, N=Other | Allow NULL? |
| 25 | Transfered | Year Transferred [Y/N] | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 26 | BlncTrnsfr | Balances Transferred [Y/N] | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 27 | OverType | Distribution Rule | char | 1 | 0 | | N | N=None, Y=Yes | Allow NULL? |
| 28 | OverCode | Distribution Rule Code | nvarchar | 8 | 0 | OOCR | | | Allow NULL? |
| 29 | SysMatch | System Reconciliation No. | int | 11 | 0 | | -1 | | Allow NULL? |
| 30 | PrevYear | Transferred from Prev. Year | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 31 | ActCurr | Account Currency | nvarchar | 3 | 0 | | | | Allow NULL? |
| 32 | RateDifAct | Rate Differences Acct | nvarchar | 15 | 0 | | | | Allow NULL? |
| 33 | SysTotal | Balance (SC) | num | 19 | 6 | | | | Allow NULL? |
| 34 | FcTotal | Balance (Account Currency) | num | 19 | 6 | | | | Allow NULL? |
| 35 | Protected | Protected Account [Y/N] | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 36 | RealAcct | Indexed Account [Y/N] | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 37 | Advance | Liable for Advances | char | 1 | 0 | | Y | N=No, Y=Yes | Allow NULL? |
| 38 | CreateDate | Creation Date | date | 8 | 0 | | | | |
| 39 | UpdateDate | Date of Update | date | 8 | 0 | | | | |
| 40 | FrgnName | Foreign Name | nvarchar | 100 | 0 | | | | Allow NULL? |
| 41 | Details | Details - History | nvarchar | 254 | 0 | | | | Allow NULL? |
| 42 | ExtraSum | Additional Amount | num | 19 | 6 | | | | Allow NULL? |
| 43 | Project | Project Code | nvarchar | 8 | 0 | OPRJ | | | Allow NULL? |
| 44 | RevalMatch | Revaluation Coordinated [Yes/NoÌRevalMatch | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 45 | 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? |
| 46 | LocMth | Reconciliation in LC | char | 1 | 0 | | Y | N=No, Y=Yes | Allow NULL? |
| 47 | MTHCounter | MTH Counter | int | 11 | 0 | | | | Allow NULL? |
| 48 | BNKCounter | BNK Counter | int | 11 | 0 | | | | Allow NULL? |
| 49 | UserSign | User Signature | int | 6 | 0 | OUSR | | | Allow NULL? |
| 50 | LocManTran | Lock Manual Transaction | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 51 | LogInstanc | Log Instance | int | 6 | 0 | | 0 | | Allow NULL? |
| 52 | ObjType | Object Type | nvarchar | 20 | 0 | | | | Allow NULL? |
| 53 | ValidFor | Active | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 54 | ValidFrom | Active From | date | 8 | 0 | | | | |
| 55 | ValidTo | Active To | date | 8 | 0 | | | | |
| 56 | ValidComm | Active Remarks | nvarchar | 30 | 0 | | | | Allow NULL? |
| 57 | FrozenFor | Inactive | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 58 | FrozenFrom | Inactive From | date | 8 | 0 | | | | |
| 59 | FrozenTo | Inactive To | date | 8 | 0 | | | | |
| 60 | FrozenComm | Inactive Remarks | nvarchar | 30 | 0 | | | | Allow NULL? |
| 61 | Counter | BP Bank Account | int | 11 | 0 | | 0 | | Allow NULL? |
| 62 | Segment_0 | Segment 0 | nvarchar | 20 | 0 | | | | Allow NULL? |
| 63 | Segment_1 | Segment 1 | nvarchar | 20 | 0 | | | | Allow NULL? |
| 64 | Segment_2 | Segment 2 | nvarchar | 20 | 0 | | | | Allow NULL? |
| 65 | Segment_3 | Segment 3 | nvarchar | 20 | 0 | | | | Allow NULL? |
| 66 | Segment_4 | Segment 4 | nvarchar | 20 | 0 | | | | Allow NULL? |
| 67 | Segment_5 | Segment 5 | nvarchar | 20 | 0 | | | | Allow NULL? |
| 68 | Segment_6 | Segment 6 | nvarchar | 20 | 0 | | | | Allow NULL? |
| 69 | Segment_7 | Segment 7 | nvarchar | 20 | 0 | | | | Allow NULL? |
| 70 | Segment_8 | Segment 8 | nvarchar | 20 | 0 | | | | Allow NULL? |
| 71 | Segment_9 | Segment 9 | nvarchar | 20 | 0 | | | | Allow NULL? |
| 72 | FormatCode | Format Code | nvarchar | 210 | 0 | | | | Allow NULL? |
| 73 | CfwRlvnt | Cash Flow Relevant [Y/N] | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 74 | ExchRate | Exchange Rate Differences | char | 1 | 0 | | Y | N=No, Y=Yes | Allow NULL? |
| 75 | RevalAcct | Revaluation Account | nvarchar | 15 | 0 | | | | Allow NULL? |
| 76 | LastRevBal | Last Revaluation Balance | num | 19 | 6 | | | | Allow NULL? |
| 77 | LastRevDat | Last Revaluation Date | date | 8 | 0 | | | | |
| 78 | DfltVat | Default VAT Group | nvarchar | 8 | 0 | OVTG | | | Allow NULL? |
| 79 | VatChange | Allow Change VAT Group | char | 1 | 0 | | Y | N=No, Y=Yes | Allow NULL? |
| 80 | Category | Category | int | 11 | 0 | OACG | | | Allow NULL? |
| 81 | TransCode | Transaction Code | nvarchar | 4 | 0 | OTRC | | | Allow NULL? |
| 82 | OverCode5 | Loading Factor Code 5 | nvarchar | 8 | 0 | OOCR | | | Allow NULL? |
| 83 | OverCode2 | Loading Factor Code 2 | nvarchar | 8 | 0 | OOCR | | | Allow NULL? |
| 84 | OverCode3 | Loading Factor Code 3 | nvarchar | 8 | 0 | OOCR | | | Allow NULL? |
| 85 | OverCode4 | Loading Factor Code 4 | nvarchar | 8 | 0 | OOCR | | | Allow NULL? |
| 86 | DfltTax | Default Tax Code | nvarchar | 8 | 0 | OSTC | | | Allow NULL? |
| 87 | TaxPostAcc | Default Tax Posting Account | char | 1 | 0 | | N | N, P=Purchasing Tax Account, R=Sales Tax Account | Allow NULL? |
| 88 | AcctStrLe | Account Structure Level | nvarchar | 2 | 0 | | | | Allow NULL? |
| 89 | MeaUnit | Measurement Unit | nvarchar | 10 | 0 | | | | Allow NULL? |
| 90 | BalDirect | Direction of Balance | nvarchar | 4 | 0 | | 0 | 0, 1=Credit, 2=Debit | Allow NULL? |
| 91 | UserSign2 | Updating User | int | 6 | 0 | OUSR | | | Allow NULL? |
| 92 | PlngLevel | B1i Info for Integration | nvarchar | 2 | 0 | | | | Allow NULL? |
