| Field |
Description |
Type |
Size |
Related |
Default Value |
Constraints |
| LogEntry |
Log Internal ID |
Int |
11 |
- |
|
|
|
| TransId |
Transaction ID |
Int |
11 |
- |
|
|
|
| ItemCode |
Item Code |
nVarChar |
50 |
OITM |
|
|
|
| ItemName |
Item Description |
nVarChar |
200 |
- |
|
|
|
| ManagedBy |
Management Method |
Int |
11 |
- |
4 |
10000044 |
BTN |
| |
|
|
|
|
|
10000045 |
SRN |
| |
|
|
|
|
|
4 |
ITM |
| DocEntry |
Document Internal ID |
Int |
11 |
- |
|
|
|
| DocLine |
Doc. Row Number |
Int |
11 |
- |
|
|
|
| DocType |
Transact. Type |
Int |
11 |
- |
-1 |
|
|
| DocNum |
Doc. Number |
Int |
11 |
- |
|
|
|
| BaseEntry |
Base Document Internal ID |
Int |
11 |
- |
-1 |
|
|
| BaseLine |
Base Document Row Number |
Int |
11 |
- |
-1 |
|
|
| BaseType |
Base Document Type |
Int |
11 |
- |
-1 |
-1 |
|
| |
|
|
|
|
|
0 |
|
| |
|
|
|
|
|
13 |
A/R Invoice |
| |
|
|
|
|
|
15 |
Delivery |
| |
|
|
|
|
|
16 |
Returns |
| |
|
|
|
|
|
17 |
Sales Order |
| |
|
|
|
|
|
18 |
A/P Invoice |
| |
|
|
|
|
|
20 |
Goods Receipt PO |
| |
|
|
|
|
|
21 |
Goods Return |
| |
|
|
|
|
|
22 |
Purchase Order |
| |
|
|
|
|
|
23 |
Sales Quotation |
| |
|
|
|
|
|
59 |
Goods Receipt |
| |
|
|
|
|
|
67 |
Inventory Transfer |
| |
|
|
|
|
|
69 |
Landed Costs |
| |
|
|
|
|
|
163 |
A/P Correction Invoice |
| |
|
|
|
|
|
164 |
A/P Correction Invoice Reversal |
| |
|
|
|
|
|
165 |
A/R Correction Invoice |
| |
|
|
|
|
|
166 |
A/R Correction Invoice Reversal |
| |
|
|
|
|
|
202 |
Production Order |
| |
|
|
|
|
|
203 |
A/R Down Payment |
| |
|
|
|
|
|
204 |
A/P Down Payment |
| ApplyEntry |
Applied Document Internal ID |
Int |
11 |
- |
|
|
|
| ApplyLine |
Applied Document Line Number |
Int |
11 |
- |
|
|
|
| ApplyType |
Applied Document Type |
Int |
11 |
- |
-1 |
|
|
| DocDate |
Doc. Posting Date |
Date |
8 |
- |
|
|
|
| CardCode |
BP Code |
nVarChar |
15 |
OCRD |
|
|
|
| CardName |
BP Name |
nVarChar |
200 |
- |
|
|
|
| DocQty |
Doc. Quantity |
Num |
19.6 |
- |
|
|
|
| StockQty |
Stock Affecting Quantity |
Num |
19.6 |
- |
|
|
|
| DefinedQty |
SnB Defined Quantity |
Num |
19.6 |
- |
|
|
|
| StockEff |
Stock Effect |
Int |
11 |
- |
0 |
0 |
ACCUM_EMPTY |
| |
|
|
|
|
|
1 |
ACCUM_ON_HAND |
| |
|
|
|
|
|
2 |
ACCUM_COMMITTED |
| |
|
|
|
|
|
3 |
ACCUM_ON_ORDER |
| CreateDate |
Creation Date |
Date |
8 |
- |
|
|
|
| LocType |
Location Type |
Int |
6 |
- |
|
|
|
| LocCode |
Location Code |
nVarChar |
8 |
- |
|
|
|
| AppDocNum |
Applied Document Number |
Int |
11 |
- |
|
|
|
| VersionNum |
Version Number |
nVarChar |
13 |
- |
|
|
|
| Transfered |
Year Tranfer |
VarChar |
1 |
- |
N |
|
|
| Instance |
INSTANCE |
Int |
6 |
- |
0 |
|
|
| SubLineNum |
Subrow Number |
Int |
11 |
- |
-1 |
|
|
| BSubLineNo |
Base Subrow Number |
Int |
11 |
- |
-1 |
|
|
| AppSubLine |
Applied Subrow Number |
Int |
11 |
- |
-1 |
|
|
| ActBaseTp |
Actual Base Type |
Int |
11 |
- |
-1 |
|
|
| ActBaseEnt |
Actual Base Entry |
Int |
11 |
- |
|
|
|
| ActBaseLn |
Actual Base Line |
Int |
11 |
- |
-1 |
|
|
| ActBasSubL |
Actual Base Subline |
Int |
11 |
- |
-1 |
|
|
| AllocateTp |
Allocate Document Type |
Int |
11 |
- |
-1 |
|
|
| AllocatEnt |
Allocate Document Entry |
Int |
11 |
- |
-1 |
|
|
| AllocateLn |
Allocate Document Line |
Int |
11 |
- |
-1 |
|
|
| CreateTime |
Creation Time |
Int |
6 |
- |
0 |
|
|