| Field |
Description |
Type |
Size |
Related |
Default Value |
Constraints |
| AcctCode |
Account Code |
nVarChar |
15 |
- |
|
|
|
| AcctName |
Account Name |
nVarChar |
200 |
- |
|
|
|
| CurrTotal |
Current Balance |
Num |
19.6 |
- |
|
|
|
| EndTotal |
Opening Balance |
Num |
19.6 |
- |
|
|
|
| Finanse |
Cash Account |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| Groups |
Main Group |
nVarChar |
8 |
- |
|
|
|
| Budget |
Budget |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| Frozen |
Account on Hold [Y/N] |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| Free_2 |
Free 2 |
VarChar |
1 |
- |
|
|
|
| Postable |
Account [Active/Title] |
VarChar |
1 |
- |
Y |
Y |
Active Account |
| |
|
|
|
|
|
N |
Title Account |
| Fixed |
Main Account |
VarChar |
1 |
- |
|
|
|
| Levels |
Account Level |
Int |
6 |
- |
2 |
|
|
| ExportCode |
Data Export Code |
nVarChar |
10 |
- |
|
|
|
| GrpLine |
Serial No. in Group |
Int |
11 |
- |
|
|
|
| FatherNum |
Parent Account Key |
nVarChar |
15 |
- |
|
|
|
| AccntntCod |
External Code |
nVarChar |
15 |
- |
|
|
|
| CashBox |
Capital Account [Y/N] |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| GroupMask |
Group Mask |
Int |
6 |
- |
1 |
|
|
| RateTrans |
For Conversion Differences |
VarChar |
1 |
- |
Y |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| TaxIncome |
Tax Definition |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| ExmIncome |
Tax Definition |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| ExtrMatch |
External Reconciliation No. |
Int |
11 |
- |
|
|
|
| IntrMatch |
Internal Reconciliation No. |
Int |
11 |
- |
|
|
|
| ActType |
Account Type |
VarChar |
1 |
- |
N |
I |
Sales |
| |
|
|
|
|
|
E |
Expenditure |
| |
|
|
|
|
|
N |
Other |
| Transfered |
Year Transfer [Y/N] |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| BlncTrnsfr |
Balances Transferred [Y/N] |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| OverType |
Loading Type |
VarChar |
1 |
- |
N |
N |
None |
| |
|
|
|
|
|
Y |
Yes |
| OverCode |
Loading Factor Code |
nVarChar |
8 |
OOCR |
|
|
|
| SysMatch |
System Reconciliation No. |
Int |
11 |
- |
-1 |
|
|
| PrevYear |
There are accounts from the previous year |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| ActCurr |
Account Currency |
nVarChar |
3 |
OCRN |
|
|
|
| RateDifAct |
Rate Differences Account |
nVarChar |
15 |
- |
|
|
|
| SysTotal |
Balance in System Currency |
Num |
19.6 |
- |
|
|
|
| FcTotal |
Balance in Account Currency |
Num |
19.6 |
- |
|
|
|
| Protected |
Confidential Account |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| RealAcct |
Indexed Account |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| Advance |
Advance Payments |
VarChar |
1 |
- |
Y |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| CreateDate |
Creation Date |
Date |
8 |
- |
|
|
|
| UpdateDate |
Date of Update |
Date |
8 |
- |
|
|
|
| FrgnName |
Foreign Name |
nVarChar |
200 |
- |
|
|
|
| Details |
Details |
nVarChar |
254 |
- |
|
|
|
| ExtraSum |
Additional Amount |
Num |
19.6 |
- |
|
|
|
| Project |
Project Code |
nVarChar |
20 |
OPRJ |
|
|
|
| RevalMatch |
Revaluation Coordinated |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| DataSource |
Data Source |
VarChar |
1 |
- |
N |
N |
Unknown |
| |
|
|
|
|
|
I |
Interface |
| |
|
|
|
|
|
U |
Update |
| |
|
|
|
|
|
M |
Import |
| |
|
|
|
|
|
O |
DI API |
| |
|
|
|
|
|
S |
Service Layer |
| |
|
|
|
|
|
W |
Web Client |
| |
|
|
|
|
|
A |
Doc. Generation Wizard |
| |
|
|
|
|
|
D |
Restore Wizard |
| |
|
|
|
|
|
P |
Partner Implementation |
| |
|
|
|
|
|
T |
Year Transfer |
| LocMth |
LC Reconciliation |
VarChar |
1 |
- |
Y |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| MTHCounter |
MTH Counter |
Int |
11 |
- |
|
|
|
| BNKCounter |
BNK Counter |
Int |
11 |
- |
|
|
|
| UserSign |
User Signature |
Int |
6 |
OUSR |
|
|
|
| LocManTran |
Control Account |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| LogInstanc |
Log Instance |
Int |
11 |
- |
0 |
|
|
| ObjType |
Object Type |
nVarChar |
20 |
ADP1 |
1 |
|
|
| ValidFor |
Active |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| ValidFrom |
Active From |
Date |
8 |
- |
|
|
|
| ValidTo |
Active To |
Date |
8 |
- |
|
|
|
| ValidComm |
Active Remarks |
nVarChar |
30 |
- |
|
|
|
| FrozenFor |
Inactive |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| FrozenFrom |
Inactive From |
Date |
8 |
- |
|
|
|
| FrozenTo |
Inactive To |
Date |
8 |
- |
|
|
|
| FrozenComm |
Inactive Remarks |
nVarChar |
30 |
- |
|
|
|
| Counter |
Counter |
Int |
11 |
- |
0 |
|
|
| Segment_0 |
Segment 0 |
nVarChar |
20 |
- |
|
|
|
| Segment_1 |
Segment 1 |
nVarChar |
20 |
- |
|
|
|
| Segment_2 |
Segment 2 |
nVarChar |
20 |
- |
|
|
|
| Segment_3 |
Segment 3 |
nVarChar |
20 |
- |
|
|
|
| Segment_4 |
Segment 4 |
nVarChar |
20 |
- |
|
|
|
| Segment_5 |
Segment 5 |
nVarChar |
20 |
- |
|
|
|
| Segment_6 |
Segment 6 |
nVarChar |
20 |
- |
|
|
|
| Segment_7 |
Segment 7 |
nVarChar |
20 |
- |
|
|
|
| Segment_8 |
Segment 8 |
nVarChar |
20 |
- |
|
|
|
| Segment_9 |
Segment 9 |
nVarChar |
20 |
- |
|
|
|
| FormatCode |
Format Code |
nVarChar |
210 |
- |
|
|
|
| CfwRlvnt |
Cash Flow Relevant [Y/N] |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| ExchRate |
Exchange Rate Differences |
VarChar |
1 |
- |
Y |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| RevalAcct |
Revaluation Account |
nVarChar |
15 |
- |
|
|
|
| LastRevBal |
Last Revaluation Balance |
Num |
19.6 |
- |
|
|
|
| LastRevDat |
Last Revaluation Date |
Date |
8 |
- |
|
|
|
| DfltVat |
Default VAT Group |
nVarChar |
8 |
OVTG |
|
|
|
| VatChange |
Allow Change VAT Group |
VarChar |
1 |
- |
Y |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| Category |
Category |
Int |
11 |
OACG |
|
|
|
| TransCode |
Transaction Code |
nVarChar |
4 |
OTRC |
|
|
|
| OverCode5 |
Loading Factor Code 5 |
nVarChar |
8 |
OOCR |
|
|
|
| OverCode2 |
Loading Factor Code 2 |
nVarChar |
8 |
OOCR |
|
|
|
| OverCode3 |
Loading Factor Code 3 |
nVarChar |
8 |
OOCR |
|
|
|
| OverCode4 |
Loading Factor Code 4 |
nVarChar |
8 |
OOCR |
|
|
|
| DfltTax |
Default Tax Code |
nVarChar |
8 |
OSTC |
|
|
|
| TaxPostAcc |
Default Tax Posting Account |
VarChar |
1 |
- |
N |
N |
|
| |
|
|
|
|
|
R |
Sales Tax Account |
| |
|
|
|
|
|
P |
Purchasing Tax Account |
| AcctStrLe |
Account Structure Level |
nVarChar |
2 |
- |
|
|
|
| MeaUnit |
Measurement Unit |
nVarChar |
10 |
- |
|
|
|
| BalDirect |
Direction of Balance |
nVarChar |
4 |
- |
0 |
0 |
|
| |
|
|
|
|
|
1 |
Credit |
| |
|
|
|
|
|
2 |
Debit |
| UserSign2 |
Updating User |
Int |
6 |
OUSR |
|
|
|
| PlngLevel |
B1i Info for Integration |
nVarChar |
2 |
- |
|
|
|
| MultiLink |
Allow Multiple Linking |
VarChar |
1 |
- |
N |
N |
No |
| |
|
|
|
|
|
Y |
Yes |
| PrjRelvnt |
Project Relevant |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| Dim1Relvnt |
Dimension 1 Relevant |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| Dim2Relvnt |
Dimension 2 Relevant |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| Dim3Relvnt |
Dimension 3 Relevant |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| Dim4Relvnt |
Dimension 4 Relevant |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| Dim5Relvnt |
Dimension 5 Relevant |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| AccrualTyp |
Accrual Type |
VarChar |
1 |
- |
N |
N |
None |
| |
|
|
|
|
|
P |
Posting Account |
| |
|
|
|
|
|
C |
Calculation Account |
| |
|
|
|
|
|
I |
Calculation Interim Account |
| DatevAcct |
DATEV Account |
nVarChar |
8 |
- |
|
|
|
| DatevAutoA |
DATEV Automatic Account |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| DatevFirst |
First Data Entry |
VarChar |
1 |
- |
Y |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| SnapShotId |
Snapshot ID |
Int |
11 |
- |
0 |
|
|
| PCN874Rpt |
PCN 874 Report Relevant |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| SCAdjust |
SC Adjustment |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| BPLId |
Assigned Branch |
Int |
11 |
OBPL |
|
|
|
| BPLName |
Branch Name |
nVarChar |
200 |
- |
|
|
|
| SubLedgerN |
Subledger No. |
nVarChar |
60 |
- |
|
|
|
| VATRegNum |
VAT Reg. Number |
nVarChar |
32 |
- |
|
|
|
| ActId |
Account Identifier |
nVarChar |
210 |
- |
|
|
|
| ClosingAcc |
G/L Account Closing |
nVarChar |
15 |
- |
|
|
|
| PurpCode |
Account Purpose Code |
nVarChar |
2 |
- |
|
01 |
Contas de ativo |
| |
|
|
|
|
|
02 |
Contas de Passivo |
| |
|
|
|
|
|
03 |
Patrim�nio L�quido |
| |
|
|
|
|
|
04 |
Contas de Resultado |
| |
|
|
|
|
|
05 |
Contas de Compensa��o |
| |
|
|
|
|
|
09 |
Outras |
| RefCode |
Referential Account Code |
nVarChar |
30 |
- |
|
|
|
| BlocManPos |
Block Manual Posting |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| PriAccCode |
Primary Closing Account |
nVarChar |
15 |
OACT |
|
|
|
| CstAccOnly |
Cost Account Only |
VarChar |
1 |
- |
N |
Y |
YES |
| |
|
|
|
|
|
N |
NO |
| AlloweFrom |
Account Balance Allowed From |
Num |
19.6 |
- |
|
|
|
| AllowedTo |
Account Balance Allowed To |
Num |
19.6 |
- |
|
|
|
| BalanceA |
Account Balance Allowed |
VarChar |
1 |
- |
N |
N |
NO |
| |
|
|
|
|
|
Y |
YES |
| RmrkTmpt |
Remark Text Template |
Int |
11 |
OTTR |
|
|
|
| CemRelvnt |
Cost Element Relevant |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| CemCode |
Cost Element Code |
nVarChar |
20 |
OCEM |
|
|
|
| StdActCode |
Standard Account Code |
nVarChar |
35 |
- |
|
|
|
| TaxonCode |
Taxonomy Code |
nVarChar |
15 |
- |
|
|
|
| InClassTyp |
Income Class. Type |
Int |
11 |
OICP |
|
|
|
| InClassCat |
Income Class. Category |
Int |
11 |
OICC |
|
|
|
| ExClassTyp |
Expense Class. Type |
Int |
11 |
OECP |
|
|
|
| ExClassCat |
Expense Class. Category |
Int |
11 |
OECC |
|
|
|
| OffcCode |
Official Account Code |
nVarChar |
15 |
- |
|
|
|