| Field |
Description |
Type |
Size |
Related |
Default Value |
Constraints |
| AbsEntry |
Internal ID |
Int |
11 |
- |
|
|
|
| Code |
Code |
nVarChar |
8 |
OECM |
|
|
|
| ParentID |
Parent ID |
Int |
11 |
ECM2 |
|
|
|
| ActType |
Action Type |
Int |
11 |
- |
0 |
1 |
Setup |
| |
|
|
|
|
|
2 |
Report |
| |
|
|
|
|
|
3 |
A/R Document |
| |
|
|
|
|
|
4 |
A/P Document |
| |
|
|
|
|
|
5 |
A/R Draft Document |
| |
|
|
|
|
|
6 |
A/P Draft Document |
| |
|
|
|
|
|
7 |
Other |
| |
|
|
|
|
|
8 |
Skip |
| |
|
|
|
|
|
9 |
Contingency |
| |
|
|
|
|
|
10 |
BP Check |
| |
|
|
|
|
|
11 |
Incoming Payment |
| |
|
|
|
|
|
12 |
Outgoing Payment |
| |
|
|
|
|
|
13 |
Internal Reconciliation |
| |
|
|
|
|
|
14 |
Transportation Document |
| |
|
|
|
|
|
15 |
Inventory Transfer |
| |
|
|
|
|
|
16 |
VAT Obligations |
| |
|
|
|
|
|
17 |
VAT Declarations |
| |
|
|
|
|
|
18 |
VAT Liabilities |
| |
|
|
|
|
|
19 |
VAT Payments |
| |
|
|
|
|
|
20 |
Delivery |
| |
|
|
|
|
|
21 |
Return |
| |
|
|
|
|
|
22 |
A/R Invoice |
| |
|
|
|
|
|
23 |
A/R Credit Memo |
| |
|
|
|
|
|
24 |
Goods Receipt PO |
| |
|
|
|
|
|
25 |
Goods Return |
| |
|
|
|
|
|
26 |
A/P Invoice |
| |
|
|
|
|
|
27 |
A/P Credit Memo |
| |
|
|
|
|
|
28 |
Draft Incoming Payment |
| |
|
|
|
|
|
29 |
Draft Outgoing Payment |
| |
|
|
|
|
|
30 |
Journal Entry |
| |
|
|
|
|
|
31 |
E-Books Expense |
| |
|
|
|
|
|
35 |
Company VAT Calendar |
| |
|
|
|
|
|
36 |
Provisional VAT Returns |
| |
|
|
|
|
|
37 |
Receipts for VAT Returns |
| |
|
|
|
|
|
38 |
A/R Invoice |
| |
|
|
|
|
|
39 |
A/R Credit Memo |
| |
|
|
|
|
|
40 |
Delivery |
| |
|
|
|
|
|
41 |
A/R Invoice Based on Delivery |
| |
|
|
|
|
|
42 |
Series |
| |
|
|
|
|
|
43 |
Invoices |
| |
|
|
|
|
|
44 |
Goods Transfers |
| ActDesc |
Action Description |
nVarChar |
100 |
- |
|
|
|
| ActStatus |
Action Status |
VarChar |
1 |
- |
N |
N |
New |
| |
|
|
|
|
|
P |
Pending |
| |
|
|
|
|
|
E |
Error |
| |
|
|
|
|
|
T |
Temporary Error |
| |
|
|
|
|
|
O |
OK |
| |
|
|
|
|
|
S |
Sent |
| |
|
|
|
|
|
R |
Document Error |
| |
|
|
|
|
|
W |
Waiting |
| |
|
|
|
|
|
A |
Authorized |
| |
|
|
|
|
|
I |
In Process |
| |
|
|
|
|
|
J |
Rejected |
| |
|
|
|
|
|
D |
Denied |
| |
|
|
|
|
|
C |
Canceled |
| |
|
|
|
|
|
B |
Aborted |
| |
|
|
|
|
|
Q |
Queued |
| |
|
|
|
|
|
M |
Imported |
| |
|
|
|
|
|
G |
Warning |
| |
|
|
|
|
|
V |
Approved |
| |
|
|
|
|
|
F |
Approving |
| |
|
|
|
|
|
H |
Rejecting |
| |
|
|
|
|
|
K |
Generated |
| |
|
|
|
|
|
Y |
Ready to Process |
| |
|
|
|
|
|
L |
Determined |
| |
|
|
|
|
|
X |
Importing |
| |
|
|
|
|
|
Z |
Response Updated |
| |
|
|
|
|
|
i |
In Process to Intermediary |
| |
|
|
|
|
|
s |
Sent to Intermediary |
| |
|
|
|
|
|
v |
Approved by Intermediary |
| |
|
|
|
|
|
g |
Not Integrated with Customer |
| |
|
|
|
|
|
c |
Not Sent to Customer |
| |
|
|
|
|
|
x |
Error Sending to Customer |
| |
|
|
|
|
|
t |
Sent to Customer |
| |
|
|
|
|
|
r |
Received by Customer |
| |
|
|
|
|
|
j |
Rejected by Customer |
| |
|
|
|
|
|
p |
Paid by Customer |
| |
|
|
|
|
|
l |
Checking Integration Status |
| IsRemoved |
Is Removed |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| ActMessage |
Action Message |
nVarChar |
254 |
- |
|
|
|
| ActEnv |
Action Environment Type |
Int |
11 |
OBNI |
-1 |
|
|
| BPLId |
Branch ID |
Int |
11 |
OBPL |
-1 |
|
|
| Submits |
Report - Number of Submissions |
Int |
6 |
- |
|
|
|
| ObjectID |
Object ID |
nVarChar |
50 |
- |
|
|
|
| ReportID |
Report ID |
nVarChar |
50 |
- |
|
|
|
| SrcObjType |
Source Object Type |
nVarChar |
20 |
- |
|
|
|
| SrcObjAbs |
Source Object Internal ID |
Int |
11 |
- |
|
|
|
| Cancel |
Cancelation |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| AssignedID |
Assigned ID |
nVarChar |
100 |
- |
|
|
|
| DocBtch |
Document Batch |
nVarChar |
50 |
- |
|
|
|
| DocBtchLn |
Document Batch Line |
Int |
6 |
- |
|
|
|
| GenType |
Generation Type |
VarChar |
1 |
- |
N |
N |
Not Relevant |
| |
|
|
|
|
|
G |
Generate |
| |
|
|
|
|
|
L |
Generate - Later |
| |
|
|
|
|
|
S |
Send |
| |
|
|
|
|
|
R |
Send - Later |
| TestMode |
Test Mode |
VarChar |
1 |
- |
N |
N |
No |
| |
|
|
|
|
|
Y |
Yes |
| PeriodType |
Report Period Type |
VarChar |
1 |
- |
|
|
Ignore |
| |
|
|
|
|
|
Y |
Year |
| |
|
|
|
|
|
Q |
Quarter |
| |
|
|
|
|
|
M |
Month |
| |
|
|
|
|
|
P |
Period |
| PeriodNum |
Report Period Number |
Int |
11 |
- |
|
|
|
| Year |
Report Year |
Int |
6 |
- |
|
|
|
| DateFrom |
Report - Date From |
Date |
8 |
- |
|
|
|
| DateTo |
Report - Date To |
Date |
8 |
- |
|
|
|
| UserSign |
User Signature |
Int |
6 |
OUSR |
|
|
|
| CreateDate |
Creation Date |
Date |
8 |
- |
|
|
|
| CreateTS |
Creation Time - Incl. Secs |
Int |
11 |
- |
|
|
|
| UserSign2 |
Updating User |
Int |
6 |
OUSR |
|
|
|
| UpdateDate |
Update Date |
Date |
8 |
- |
|
|
|
| UpdateTS |
Update Time - Incl. Secs |
Int |
11 |
- |
|
|
|
| LogInstanc |
Log Instance |
Int |
6 |
- |
|
|
|
| SchedJobID |
Scheduled Job ID |
Int |
11 |
OBSJ |
|
|
|
| GUID |
GUID |
nVarChar |
100 |
- |
|
|
|
| Authority |
Authority Code |
nVarChar |
16 |
OPAC |
|
|
|
| CancStatus |
Cancelation Status |
VarChar |
1 |
- |
T |
T |
|
| |
|
|
|
|
|
N |
New Request |
| |
|
|
|
|
|
S |
Request Sent |
| |
|
|
|
|
|
A |
Approved |
| |
|
|
|
|
|
R |
Rejected |
| |
|
|
|
|
|
E |
Error |
| |
|
|
|
|
|
C |
Canceled |
| |
|
|
|
|
|
I |
In Process |
| |
|
|
|
|
|
U |
Sent To Authorities |
| |
|
|
|
|
|
W |
Canceled Without Approval |
| EDocType |
E-Doc Type |
Int |
11 |
OUNCL |
|
|
|
| EDocNum |
E-Doc Number |
nVarChar |
100 |
- |
|
|
|
| ProcTarget |
Processing Target/Source |
nVarChar |
40 |
- |
|
|
|
| Emergency |
Emergency |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| SttsReason |
Status Reason |
nVarChar |
3 |
- |
|
NON |
No Issues |
| |
|
|
|
|
|
REF |
Incorrect references |
| |
|
|
|
|
|
LEG |
Incorrect legal information |
| |
|
|
|
|
|
REC |
Unknown receiver |
| |
|
|
|
|
|
QUA |
Insufficient item quality |
| |
|
|
|
|
|
DEL |
Issues with delivery |
| |
|
|
|
|
|
PRI |
Incorrect prices |
| |
|
|
|
|
|
QTY |
Incorrect quantity |
| |
|
|
|
|
|
ITM |
Incorrect items |
| |
|
|
|
|
|
PAY |
Incorrect payment terms |
| |
|
|
|
|
|
UNR |
Not recognized |
| |
|
|
|
|
|
FIN |
Incorrect financials |
| |
|
|
|
|
|
PPD |
Partially Paid |
| |
|
|
|
|
|
OTH |
Other |
| SttsDescr |
Status Description |
nVarChar |
254 |
- |
|
|
|