| Field |
Description |
Type |
Size |
Related |
Default Value |
Constraints |
| DocEntry |
Internal Number |
Int |
11 |
- |
|
|
|
| DocNum |
Document Number |
Int |
11 |
- |
|
|
|
| DocDate |
Posting Date |
Date |
8 |
- |
|
|
|
| Ref1 |
Reference 1 |
nVarChar |
11 |
- |
|
|
|
| Ref2 |
Reference 2 |
nVarChar |
11 |
- |
|
|
|
| Comments |
Remarks |
nVarChar |
254 |
- |
|
|
|
| JrnlMemo |
Journal Remarks |
nVarChar |
254 |
- |
|
|
|
| TransId |
Transaction Number |
Int |
11 |
OJDT |
|
|
|
| DocTime |
Generation Time |
Int |
6 |
- |
|
|
|
| RevalType |
Inventory Valuation Type |
VarChar |
1 |
- |
P |
P |
Price Change |
| |
|
|
|
|
|
M |
Inventory Debit/Credit |
| UpdateDate |
Date of Update |
Date |
8 |
- |
|
|
|
| CreateDate |
Creation Date |
Date |
8 |
- |
|
|
|
| Series |
Series |
Int |
11 |
NNM1 |
|
|
|
| TaxDate |
Document Date |
Date |
8 |
- |
|
|
|
| DataSource |
Data Source |
VarChar |
1 |
- |
N |
N |
Unknown |
| |
|
|
|
|
|
I |
Interface |
| |
|
|
|
|
|
U |
Upgrade |
| |
|
|
|
|
|
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 |
|
|
|
| UserSign2 |
Updating User |
Int |
6 |
OUSR |
|
|
|
| StationID |
Workstation ID |
Int |
11 |
CSTN |
|
|
|
| RIncmAcct |
Invent. Reval. Expense Account |
nVarChar |
15 |
- |
|
|
|
| RExpnAcct |
Invent. Reval. Expense Account |
nVarChar |
15 |
- |
|
|
|
| LogInstanc |
Log Instance |
Int |
11 |
- |
0 |
|
|
| ObjType |
Object Type |
nVarChar |
20 |
- |
162 |
|
|
| SeqCode |
Sequence Code |
Int |
6 |
- |
|
|
|
| Serial |
Serial Number |
Int |
11 |
- |
|
|
|
| SeriesStr |
Series String |
nVarChar |
3 |
- |
|
|
|
| SubStr |
Subseries String |
nVarChar |
3 |
- |
|
|
|
| VersionNum |
Version Number |
nVarChar |
13 |
- |
|
|
|
| InflaReval |
Inflation-Based Revaluation |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| SupplCode |
Supplementary Code |
nVarChar |
254 |
- |
|
|
|
| CardCode |
Customer/Vendor Code |
nVarChar |
15 |
OCRD |
|
|
|
| CardName |
Customer/Vendor Name |
nVarChar |
200 |
- |
|
|
|
| CreatedBy |
Entry Creation Origin |
VarChar |
1 |
- |
M |
M |
Created Manually by User |
| |
|
|
|
|
|
W |
Created by Production Cost Recalculation Wizard |