| Field |
Description |
Type |
Size |
Related |
Default Value |
Constraints |
| AbsEntry |
Internal Key |
Int |
11 |
PMG1 |
|
|
|
| LineID |
Row No. |
Int |
11 |
- |
|
|
|
| StageID |
Stage ID |
Int |
11 |
- |
|
|
|
| TYP |
Document Type |
Int |
11 |
- |
-1 |
-1 |
Please select |
| |
|
|
|
|
|
112 |
Document Draft |
| |
|
|
|
|
|
30 |
Manual Journal Entry |
| |
|
|
|
|
|
23 |
Sales Quotation |
| |
|
|
|
|
|
17 |
Sales Order |
| |
|
|
|
|
|
15 |
Delivery |
| |
|
|
|
|
|
16 |
Return |
| |
|
|
|
|
|
203002 |
A/R Down Payment Request |
| |
|
|
|
|
|
203 |
A/R Down Payment Invoice |
| |
|
|
|
|
|
13 |
A/R Invoice |
| |
|
|
|
|
|
14 |
A/R Credit Memo |
| |
|
|
|
|
|
13002 |
A/R Reserve Invoice |
| |
|
|
|
|
|
540000006 |
Purchase Quotation |
| |
|
|
|
|
|
22 |
Purchase Order |
| |
|
|
|
|
|
20 |
Goods Receipt PO |
| |
|
|
|
|
|
21 |
Goods Return |
| |
|
|
|
|
|
204002 |
A/P Down Payment Request |
| |
|
|
|
|
|
204 |
A/P Down Payment Invoice |
| |
|
|
|
|
|
18 |
A/P Invoice |
| |
|
|
|
|
|
19 |
A/P Credit Memo |
| |
|
|
|
|
|
18002 |
A/P Reserve Invoice |
| |
|
|
|
|
|
191 |
Service Call |
| |
|
|
|
|
|
59 |
Goods Receipt |
| |
|
|
|
|
|
60 |
Goods Issue |
| |
|
|
|
|
|
165 |
A/R Correction Invoice |
| |
|
|
|
|
|
166 |
A/R Correction Invoice Reversal |
| |
|
|
|
|
|
163 |
A/P Correction Invoice |
| |
|
|
|
|
|
164 |
A/P Correction Invoice Reversal |
| |
|
|
|
|
|
1470000113 |
Purchase Request |
| |
|
|
|
|
|
234000032 |
Goods Return Request |
| |
|
|
|
|
|
234000031 |
Return Request |
| DOCNUM |
Document Number |
Int |
11 |
- |
|
|
|
| DocEntry |
Document Abs. Entry |
Int |
11 |
- |
|
|
|
| DocDate |
Document Date |
Date |
8 |
- |
|
|
|
| Total |
Total |
Num |
19.6 |
- |
|
|
|
| LineNum |
Line Number |
Int |
11 |
- |
|
|
|
| Status |
Line status |
VarChar |
1 |
- |
O |
O |
Open |
| |
|
|
|
|
|
C |
Closed |
| LogInstanc |
Log Instance |
Int |
11 |
- |
0 |
|
|
| AmountCat |
Category to which we will apply the amount from Total |
VarChar |
1 |
- |
|
I |
Invoiced |
| |
|
|
|
|
|
O |
Open |
| Categorize |
Category Open Amount/Invoiced A/R, A/P to which we will apply the amount from journal entry |
nVarChar |
2 |
- |
|
|
Ignore |
| |
|
|
|
|
|
OP |
Open Amount (A/P) |
| |
|
|
|
|
|
OR |
Open Amount (A/R) |
| |
|
|
|
|
|
IP |
Invoiced (A/P) |
| |
|
|
|
|
|
IR |
Invoiced (A/R) |
| Operation |
Operation which we will apply to the amount from the total |
VarChar |
1 |
- |
|
|
Ignore |
| |
|
|
|
|
|
A |
Add |
| |
|
|
|
|
|
S |
Subtract |
| Chargeable |
Chargeable [Yes/No] |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| Charged |
Charged |
Num |
19.6 |
- |
|
|
|
| ChargedQty |
Charged Quantity |
Num |
19.6 |
- |
|
|
|
| DocType |
Document Type |
VarChar |
1 |
- |
I |
I |
Item |
| |
|
|
|
|
|
S |
Service |
| EncryptIV |
Encrypt IV |
nVarChar |
100 |
- |
|
|
|
| PartTotal |
Partially Invoiced Total |
Num |
19.6 |
- |
|
|
|