| Field |
Description |
Type |
Size |
Related |
Default Value |
Constraints |
| DocEntry |
Document Internal ID |
Int |
11 |
- |
|
|
|
| CreateDate |
Creation Date |
Date |
8 |
- |
|
|
|
| DocTime |
Generation Time |
Int |
6 |
- |
|
|
|
| IOffIncAcc |
Inventory Offset - Increase Ac |
nVarChar |
15 |
OACT |
|
|
|
| DOffDecAcc |
Inventory Offset Decrease Acct |
nVarChar |
15 |
OACT |
|
|
|
| DocDate |
Posting Date |
Date |
8 |
- |
|
|
|
| Reference |
Reference |
nVarChar |
11 |
- |
|
|
|
| Comments |
Remarks |
nVarChar |
254 |
- |
|
|
|
| DocDueDate |
Due Date |
Date |
8 |
- |
|
|
|
| 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 |
|
|
|
| VersionNum |
Version Number |
nVarChar |
13 |
- |
|
|
|
| JdtNum |
Journal Number |
Int |
11 |
OJDT |
|
|
|
| Reference2 |
Reference 2 |
nVarChar |
11 |
- |
|
|
|
| ObjType |
Object Type |
nVarChar |
20 |
- |
10000071 |
|
|
| DocNum |
Document Number |
Int |
11 |
- |
|
|
|
| Series |
Series |
Int |
11 |
NNM1 |
|
|
|
| PriceSrc |
Price Source |
Int |
11 |
- |
3 |
1 |
By Price List |
| |
|
|
|
|
|
2 |
Last Evaluated Price |
| |
|
|
|
|
|
3 |
Item Cost |
| PriceList |
Price List |
Int |
11 |
- |
|
|
|
| JrnlMemo |
Journal Remarks |
nVarChar |
254 |
- |
|
|
|
| Status |
Status |
VarChar |
1 |
- |
O |
O |
Open |
| |
|
|
|
|
|
C |
Close |
| LogIns |
Log Instance - History |
Int |
11 |
- |
|
|
|
| UserSign2 |
Updating User - History |
Int |
6 |
OUSR |
|
|
|
| UpdateDate |
Date of Update - History |
Date |
8 |
- |
|
|
|
| CountDate |
Date of Counting |
Date |
8 |
- |
|
|
|
| CountTime |
Time of Counting |
Int |
11 |
- |
|
|
|
| WddStatus |
Authorization Status |
VarChar |
1 |
- |
- |
- |
Without |
| |
|
|
|
|
|
W |
Pending |
| |
|
|
|
|
|
Y |
Approved |
| |
|
|
|
|
|
N |
Rejected |
| |
|
|
|
|
|
P |
Generated |
| |
|
|
|
|
|
A |
Generated by Authorizer |
| |
|
|
|
|
|
C |
Canceled |
| DraftKey |
Draft Document Internal ID |
Int |
11 |
OIPD |
-1 |
|
|
| Printed |
Printed |
VarChar |
1 |
- |
N |
|
|
| DocTotal |
Document Total |
Num |
19.6 |
- |
|
|
|
| BPLId |
Branch |
Int |
11 |
OBPL |
|
|
|
| BPLName |
Branch Name |
nVarChar |
200 |
- |
|
|
|
| UpdateTS |
Update Full Time |
Int |
11 |
- |
|
|
|
| CopyOption |
DI Copy from Option |
VarChar |
1 |
- |
0 |
0 |
No Counters Diff. |
| |
|
|
|
|
|
1 |
Individual 1 |
| |
|
|
|
|
|
2 |
Individual 2 |
| |
|
|
|
|
|
3 |
Individual 3 |
| |
|
|
|
|
|
4 |
Individual 4 |
| |
|
|
|
|
|
5 |
Individual 5 |
| |
|
|
|
|
|
6 |
Team Counted Quantity |
| BaseEntry |
Base Counting Doc. Entry |
Int |
11 |
- |
|
|
|
| PIndicator |
Period Indicator |
nVarChar |
10 |
OPID |
' ' |
|
|
| FinncPriod |
Posting Period |
Int |
11 |
OFPR |
|
|
|
| AtcEntry |
Attachment Entry |
Int |
11 |
OATC |
|
|
|
| Attachment |
Attachment |
Text |
16 |
- |
|
|
|
| YearEndDt |
End of Fiscal Year |
Date |
8 |
- |
|
|
|