| Field |
Description |
Type |
Size |
Related |
Default Value |
Constraints |
| DocEntry |
Internal Number |
Int |
11 |
- |
|
|
|
| DocNum |
Document Number |
Int |
11 |
- |
|
|
|
| Series |
Series |
Int |
11 |
NNM1 |
|
|
|
| PeriodCat |
Period Category |
nVarChar |
10 |
- |
|
|
|
| FinncPriod |
Posting Period |
Int |
11 |
OFPR |
|
|
|
| PostDate |
Posting Date |
Date |
8 |
- |
|
|
|
| DocDate |
Document Date |
Date |
8 |
- |
|
|
|
| DocStatus |
Document Status |
VarChar |
1 |
- |
P |
P |
Posted |
| |
|
|
|
|
|
D |
Draft |
| |
|
|
|
|
|
C |
Canceled |
| TransId |
Transaction Number |
Int |
11 |
OJDT |
|
|
|
| Comments |
Remarks |
nVarChar |
254 |
- |
|
|
|
| Reference |
Reference |
nVarChar |
32 |
- |
|
|
|
| ObjType |
Object Type |
nVarChar |
20 |
- |
|
|
|
| Currency |
Currency |
nVarChar |
3 |
OCRN |
|
|
|
| DocRate |
Document Rate |
Num |
19.6 |
- |
|
|
|
| SysRate |
System Rate |
Num |
19.6 |
- |
|
|
|
| PIndicator |
Period Indicator |
nVarChar |
10 |
OPID |
|
|
|
| DocTotal |
Document Total |
Num |
19.6 |
- |
|
|
|
| DocTotalFC |
Document Total (FC) |
Num |
19.6 |
- |
|
|
|
| DocTotalSy |
Document Total (SC) |
Num |
19.6 |
- |
|
|
|
| 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 |
| UserSign |
User Signature |
Int |
6 |
OUSR |
|
|
|
| LogInstanc |
Log Instance |
Int |
11 |
- |
0 |
|
|
| CreateDate |
Create Date |
Date |
8 |
- |
|
|
|
| UserSign2 |
Updating User |
Int |
6 |
OUSR |
|
|
|
| UpdateDate |
Date of Update |
Date |
8 |
- |
|
|
|
| TransType |
Original Document |
nVarChar |
20 |
- |
-1 |
13 |
A/R Invoice |
| |
|
|
|
|
|
19 |
A/P Credit Memo |
| |
|
|
|
|
|
18 |
A/P Invoice |
| |
|
|
|
|
|
46 |
Outgoing Payment |
| |
|
|
|
|
|
163 |
A/P Correction Invoice |
| |
|
|
|
|
|
1470000049 |
Capitalization |
| |
|
|
|
|
|
1470000060 |
Fixed Assets Credit Memo |
| |
|
|
|
|
|
-1 |
All Transactions |
| |
|
|
|
|
|
1470000075 |
Manual Depreciation |
| |
|
|
|
|
|
1470000090 |
Fixed Assets Transfer |
| |
|
|
|
|
|
1470000094 |
Retirement |
| CreatedBy |
Original |
Int |
11 |
- |
|
|
|
| JrnlMemo |
Journal Remarks |
nVarChar |
254 |
- |
|
|
|
| AssetDate |
Asset Value Date |
Date |
8 |
- |
|
|
|
| CurSource |
Base Currency |
VarChar |
1 |
- |
L |
L |
Local Currency |
| |
|
|
|
|
|
S |
System Currency |
| |
|
|
|
|
|
F |
Foreign Currency |
| DocType |
Document Type |
nVarChar |
15 |
- |
PL |
PL |
Ordinary Depreciation |
| |
|
|
|
|
|
UP |
Unplanned Depreciation |
| |
|
|
|
|
|
SD |
Special Depreciation |
| |
|
|
|
|
|
AP |
Appreciation |
| |
|
|
|
|
|
TR |
Asset Transfer |
| |
|
|
|
|
|
NC |
Sales |
| |
|
|
|
|
|
SC |
Scrapping |
| |
|
|
|
|
|
TC |
Asset Class Transfer |
| PrjSmarz |
Summarize by Project |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| DstRlSmarz |
Summarize by Distribution Rule |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| ManDprType |
Manual Depreciation Type |
nVarChar |
15 |
ODTP |
|
|
|
| Handwrtten |
Manual Numbering |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| CancelDate |
Cancelation Date |
Date |
8 |
- |
|
|
|
| DprArea |
Depreciation Area |
nVarChar |
15 |
ODPA |
|
|
|
| BPLId |
Branch |
Int |
11 |
OBPL |
|
|
|
| BaseRef |
Base Reference |
nVarChar |
11 |
- |
|
|
|
| LVARetire |
Low Value Asset Retirement |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| CancelOpt |
Cancelation Option |
Int |
6 |
- |
1 |
|
|
| BPLName |
Branch Name |
nVarChar |
200 |
- |
|
|
|
| VatRegNum |
VAT Reg. Number |
nVarChar |
32 |
- |
|
|
|
| GdsMovType |
Goods Movement Type |
nVarChar |
2 |
- |
|
|
|
| |
|
|
|
|
|
SI |
Opening Balance of Fixed Assets |
| |
|
|
|
|
|
IM |
Initialization of Fixed Assets |
| |
|
|
|
|
|
IP |
FA Use in Progress |
| |
|
|
|
|
|
CI |
End of Fixed Assets Use |
| |
|
|
|
|
|
MC |
Immobilization from Current Assets |
| PTICode |
POI Code |
nVarChar |
5 |
OPTI |
|
|
|
| Letter |
Letter |
VarChar |
1 |
- |
|
|
|
| FolNumFrom |
Folio Number From |
Int |
11 |
- |
|
|
|
| FolNumTo |
Folio Number To |
Int |
11 |
- |
|
|
|
| FolSeries |
Folio Series |
Int |
11 |
OFNS |
|
|
|
| VersionNum |
Version Number |
nVarChar |
13 |
- |
|
|
|