| Field |
Description |
Type |
Size |
Related |
Default Value |
Constraints |
| DocEntry |
Internal Number |
Int |
11 |
OINC |
|
|
|
| LineNum |
Row Number |
Int |
11 |
- |
|
|
|
| ItemCode |
Item Code |
nVarChar |
50 |
OITM |
|
|
|
| ItemDesc |
Item Description |
nVarChar |
200 |
- |
|
|
|
| Freeze |
Item Freeze Status |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| WhsCode |
Warehouse Code |
nVarChar |
8 |
OWHS |
|
|
|
| InWhsQty |
In-Whse Qty on Count Date |
Num |
19.6 |
- |
|
|
|
| Counted |
Counted |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| CountQty |
Counted Quantity |
Num |
19.6 |
- |
|
|
|
| CountQtyT1 |
Counter 1 - Counted Quantity |
Num |
19.6 |
- |
|
|
|
| CountQtyT2 |
- |
Num |
19.6 |
- |
|
|
|
| Remark |
Remarks |
nVarChar |
254 |
- |
|
|
|
| BarCode |
Bar Code |
nVarChar |
254 |
- |
|
|
|
| InvUoM |
Inventory UoM |
VarChar |
1 |
- |
Y |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| Difference |
Difference |
Num |
19.6 |
- |
|
|
|
| DiffPercen |
Difference % |
Num |
19.6 |
- |
|
|
|
| CountDate |
Count Date |
Date |
8 |
- |
|
|
|
| CountTime |
Count Time |
Int |
11 |
- |
|
|
|
| TargetRef |
Target Document Reference |
nVarChar |
16 |
- |
|
|
|
| TargetType |
Target Document Type |
Int |
11 |
- |
-1 |
-1 |
|
| |
|
|
|
|
|
0 |
|
| |
|
|
|
|
|
10000071 |
Inventory Posting |
| TargetEntr |
Target Document Internal ID |
Int |
11 |
- |
|
|
|
| TargetLine |
Target Document Row |
Int |
11 |
- |
|
|
|
| ProjCode |
Project Code |
nVarChar |
20 |
OPRJ |
|
|
|
| OcrCode |
Distribution Rule Code |
nVarChar |
8 |
OOCR |
|
|
|
| LineStatus |
Row Status |
VarChar |
1 |
- |
O |
O |
Open |
| |
|
|
|
|
|
C |
Closed |
| BinEntry |
Bin Location Entry |
Int |
11 |
OBIN |
|
|
|
| VisOrder |
Visual Order |
Int |
11 |
- |
|
|
|
| OcrCode2 |
Distribution Rule 2 |
nVarChar |
8 |
OOCR |
|
|
|
| OcrCode3 |
Distribution Rule 3 |
nVarChar |
8 |
OOCR |
|
|
|
| OcrCode4 |
Distribution Rule 4 |
nVarChar |
8 |
OOCR |
|
|
|
| OcrCode5 |
Distribution Rule 5 |
nVarChar |
8 |
OOCR |
|
|
|
| FirmCode |
Manufacturer |
Int |
6 |
OMRC |
|
|
|
| SuppCatNum |
Mfr Catalog No. |
nVarChar |
50 |
- |
|
|
|
| PrefVendor |
Preferred Vendor |
nVarChar |
15 |
OCRD |
|
|
|
| LogIns |
Log Instance - History |
Int |
11 |
- |
|
|
|
| UgpEntry |
UoM Group Entry |
Int |
11 |
OUGP |
|
|
|
| IUomEntry |
Inventory UoM Entry |
nVarChar |
20 |
OUOM |
|
|
|
| CountDiff |
Counters' Diff. |
Num |
19.6 |
- |
|
|
|
| CountDiffP |
Counters' Diff. (%) |
Num |
19.6 |
- |
|
|
|
| UomCode |
UoM Code for DI |
nVarChar |
20 |
OUOM |
|
|
|
| UomQty |
UoM Counted Qty for DI |
Num |
19.6 |
- |
|
|
|
| PPTaxExRe |
Plastic Packaging Tax Exemption Reason |
nVarChar |
2 |
- |
|
|
|
| PlPaWght |
Plastic Packaging Weight |
Num |
19.6 |
- |
|
|
|