| Field |
Description |
Type |
Size |
Related |
Default Value |
Constraints |
| DocEntry |
Document Internal ID |
Int |
11 |
- |
|
|
|
| DocLineNum |
Row Number in Document |
Int |
11 |
- |
|
|
|
| ItemCode |
Item No. |
nVarChar |
50 |
OITM |
|
|
|
| ItemName |
Item Description |
nVarChar |
200 |
- |
|
|
|
| InvntryUom |
Inventory UoM |
nVarChar |
100 |
- |
|
|
|
| OnHandBef |
Quantity Stored in Warehouse |
Num |
19.6 |
- |
|
|
|
| Price |
Price |
Num |
19.6 |
- |
|
|
|
| Quantity |
Variance |
Num |
19.6 |
- |
|
|
|
| Currency |
Price Currency |
nVarChar |
3 |
- |
|
|
|
| Rate |
Currency Price |
Num |
19.6 |
- |
|
|
|
| IOffIncAcc |
Inventory Offset Increase Acct |
nVarChar |
15 |
OACT |
|
|
|
| DOffDecAcc |
Inventory Offset Decrease Acct |
nVarChar |
15 |
OACT |
|
|
|
| OcrCode |
Distribution Rule |
nVarChar |
8 |
OOCR |
|
|
|
| WhsCode |
Warehouse Code |
nVarChar |
8 |
OWHS |
|
|
|
| DocTotal |
Document Total |
Num |
19.6 |
- |
|
|
|
| DocTotalFC |
Document Total (FC) |
Num |
19.6 |
- |
|
|
|
| DocTotalSy |
Document Total (SC) |
Num |
19.6 |
- |
|
|
|
| OcrCode2 |
Distribution Rule2 |
nVarChar |
8 |
OOCR |
|
|
|
| OcrCode3 |
Distribution Rule3 |
nVarChar |
8 |
OOCR |
|
|
|
| OcrCode4 |
Distribution Rule4 |
nVarChar |
8 |
OOCR |
|
|
|
| OcrCode5 |
Distribution Rule5 |
nVarChar |
8 |
OOCR |
|
|
|
| ObjType |
Object Type |
nVarChar |
20 |
- |
10000071 |
|
|
| Project |
Project Code |
nVarChar |
20 |
OPRJ |
|
|
|
| BarCode |
Bar Code |
nVarChar |
254 |
- |
|
|
|
| InvUoM |
Inventory UoM |
VarChar |
1 |
- |
Y |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| BinEntry |
Bin Location Entry |
Int |
11 |
OBIN |
|
|
|
| FirmCode |
Manufacturer |
Int |
6 |
OMRC |
|
|
|
| SuppCatNum |
Mfr Catalog No. |
nVarChar |
50 |
- |
|
|
|
| CardCode |
Preferred Vendor |
nVarChar |
15 |
OCRD |
|
|
|
| CountDate |
Count Date |
Date |
8 |
- |
|
|
|
| CountTime |
Count Time |
Int |
11 |
- |
|
|
|
| DiffPercnt |
Percentage Difference |
Num |
19.6 |
- |
|
|
|
| BaseRef |
Base Document Reference |
nVarChar |
16 |
- |
|
|
|
| BaseType |
Base Document Type |
Int |
11 |
- |
1470000065 |
-1 |
|
| |
|
|
|
|
|
1470000065 |
Inventory Counting |
| BaseEntry |
Base Document Internal ID |
Int |
11 |
- |
|
|
|
| BaseLine |
Base Row |
Int |
11 |
- |
|
|
|
| CountQty |
Counted Quantity |
Num |
19.6 |
- |
|
|
|
| Remark |
Remarks |
nVarChar |
254 |
- |
|
|
|
| LogInstanc |
Log Instance - History |
Int |
11 |
- |
|
|
|
| CpyCount |
Copied Count |
Int |
11 |
- |
0 |
0 |
|
| |
|
|
|
|
|
1 |
Inventory Taker One |
| |
|
|
|
|
|
2 |
Two Takers - Taker 1 |
| |
|
|
|
|
|
3 |
Two Takers - Taker 2 |
| |
|
|
|
|
|
4 |
Two Takers - Items with Zero Difference |
| BinNegQty |
Allow Bin Negative Quantity |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| VisOrder |
Visual Order |
Int |
11 |
- |
|
|
|
| UgpEntry |
UoM Group Entry |
Int |
11 |
OUGP |
|
|
|
| IUomEntry |
Inventory UoM Entry |
nVarChar |
20 |
OUOM |
|
|
|
| UomCode |
UoM Code for DI |
nVarChar |
20 |
OUOM |
|
|
|
| ItmsPerUnt |
Items per Unit for DI |
Num |
19.6 |
- |
|
|
|
| UomQty |
UoM Counted Qty for DI |
Num |
19.6 |
- |
|
|
|
| ActPrice |
Actual Price |
Num |
19.6 |
- |
|
|
|
| PostValueL |
Posted Value LC |
Num |
19.6 |
- |
|
|
|
| PostValueS |
Posted Value SC |
Num |
19.6 |
- |
|
|
|
| PPTaxExRe |
Plastic Packaging Tax Exemption Reason |
nVarChar |
2 |
- |
|
|
|
| PlPaWght |
Plastic Packaging Weight |
Num |
19.6 |
- |
|
|
|