| Field |
Description |
Type |
Size |
Related |
Default Value |
Constraints |
| ItemCode |
Item No. |
nVarChar |
50 |
- |
|
|
|
| ItemName |
Item Description |
nVarChar |
200 |
- |
|
|
|
| FrgnName |
Foreign Name |
nVarChar |
200 |
- |
|
|
|
| ItmsGrpCod |
Item Group |
Int |
6 |
OITB |
100 |
|
|
| CstGrpCode |
Customs Group |
Int |
6 |
OARG |
-1 |
|
|
| VatGourpSa |
Sales Tax Definition |
nVarChar |
8 |
OVTG |
|
|
|
| CodeBars |
Bar Code |
nVarChar |
254 |
- |
|
|
|
| VATLiable |
Tax Liable |
VarChar |
1 |
- |
Y |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| PrchseItem |
Purchasing Item |
VarChar |
1 |
- |
Y |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| SellItem |
Sales Item |
VarChar |
1 |
- |
Y |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| InvntItem |
Inventory Item |
VarChar |
1 |
- |
Y |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| OnHand |
In Stock |
Num |
19.6 |
- |
|
|
|
| IsCommited |
Qty Ordered by Customers |
Num |
19.6 |
- |
|
|
|
| OnOrder |
Qty Ordered from Vendors |
Num |
19.6 |
- |
|
|
|
| IncomeAcct |
Revenue Account |
nVarChar |
15 |
OACT |
|
|
|
| ExmptIncom |
Exempt Revenue Account |
nVarChar |
15 |
OACT |
|
|
|
| MaxLevel |
Maximum Inventory Level |
Num |
19.6 |
- |
|
|
|
| DfltWH |
Default Warehouse |
nVarChar |
8 |
- |
|
|
|
| CardCode |
Preferred Vendor |
nVarChar |
15 |
OCRD |
|
|
|
| SuppCatNum |
Mfr Catalog No. |
nVarChar |
50 |
- |
|
|
|
| BuyUnitMsr |
Purchasing UoM |
nVarChar |
100 |
- |
|
|
|
| NumInBuy |
Items per Purchasing Unit |
Num |
19.6 |
- |
|
|
|
| ReorderQty |
Required (Purchasing UoM) |
Num |
19.6 |
- |
|
|
|
| MinLevel |
Minimum Inventory Level |
Num |
19.6 |
- |
|
|
|
| LstEvlPric |
Last Evaluated Price |
Num |
19.6 |
- |
|
|
|
| LstEvlDate |
Date of Last Reval. Price |
Date |
8 |
- |
|
|
|
| CustomPer |
Customs Rate |
Num |
19.6 |
- |
|
|
|
| Canceled |
Canceled Item [Yes/No] |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| MnufctTime |
Production Date in Days |
Int |
11 |
- |
|
|
|
| WholSlsTax |
Tax Rate for Wholesaler |
VarChar |
1 |
- |
|
|
|
| RetilrTax |
Sales Tax in % |
VarChar |
1 |
- |
|
|
|
| SpcialDisc |
Special Discount % |
Num |
19.6 |
- |
|
|
|
| DscountCod |
Discount Code |
Int |
6 |
- |
|
|
|
| TrackSales |
Follow-Up [Yes/No] |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| SalUnitMsr |
Sales UoM |
nVarChar |
100 |
- |
|
|
|
| NumInSale |
No. of Items per Sales Unit |
Num |
19.6 |
- |
|
|
|
| Consig |
Consignment Goods Whse |
Num |
19.6 |
- |
|
|
|
| QueryGroup |
Properties |
Int |
11 |
- |
0 |
|
|
| Counted |
Quantity Counted in Inventory |
Num |
19.6 |
- |
|
|
|
| OpenBlnc |
Initial Stock |
Num |
19.6 |
- |
|
|
|
| EvalSystem |
Valuation Method |
VarChar |
1 |
- |
|
A |
Moving Average |
| |
|
|
|
|
|
S |
Standard |
| |
|
|
|
|
|
F |
FIFO |
| |
|
|
|
|
|
B |
Serial/Batch |
| UserSign |
User Signature |
Int |
6 |
OUSR |
|
|
|
| FREE |
Free [Yes/No] |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| PicturName |
Picture |
nVarChar |
200 |
- |
|
|
|
| Transfered |
Year Transfer [Y/N] |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| BlncTrnsfr |
Balances transferred [Yes/No] |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| UserText |
Item Remarks |
Text |
16 |
- |
|
|
|
| SerialNum |
Serial Number |
nVarChar |
17 |
- |
|
|
|
| CommisPcnt |
% Commission for Item |
Num |
19.6 |
- |
|
|
|
| CommisSum |
Total Commission for Item |
Num |
19.6 |
- |
|
|
|
| CommisGrp |
Commission Group |
Int |
6 |
OCOG |
0 |
|
|
| TreeType |
BOM Type |
VarChar |
1 |
- |
N |
N |
Not a BOM |
| |
|
|
|
|
|
A |
Assembly |
| |
|
|
|
|
|
S |
Sales |
| |
|
|
|
|
|
P |
Production |
| |
|
|
|
|
|
T |
Template |
| TreeQty |
No. of Units |
Num |
19.6 |
- |
|
|
|
| LastPurPrc |
Last Purchase Price |
Num |
19.6 |
- |
|
|
|
| LastPurCur |
Last Purchase Currency |
nVarChar |
3 |
- |
|
|
|
| LastPurDat |
Last Purchase Date |
Date |
8 |
- |
|
|
|
| ExitCur |
Issue Currency |
nVarChar |
3 |
- |
|
|
|
| ExitPrice |
Issue Price |
Num |
19.6 |
- |
|
|
|
| ExitWH |
Release Warehouse |
nVarChar |
8 |
- |
|
|
|
| AssetItem |
Fixed Asset Indicator |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| WasCounted |
Counted |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| ManSerNum |
Serial No. Management |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| SHeight1 |
Height 1 - Sales Unit |
Num |
19.6 |
- |
|
|
|
| SHght1Unit |
Height 1 - UoM for Sales |
Int |
6 |
- |
|
|
|
| SHeight2 |
Height 2 - Sales Unit |
Num |
19.6 |
- |
|
|
|
| SHght2Unit |
Height 2 - UoM for Sales |
Int |
6 |
- |
|
|
|
| SWidth1 |
Width 1 - Sales Unit |
Num |
19.6 |
- |
|
|
|
| SWdth1Unit |
Width 1 - UoM for Sales |
Int |
6 |
- |
|
|
|
| SWidth2 |
Width 2 - Sales Unit |
Num |
19.6 |
- |
|
|
|
| SWdth2Unit |
Width 2 - UoM for Sales |
Int |
6 |
- |
|
|
|
| SLength1 |
Length 1 - Sales Unit |
Num |
19.6 |
- |
|
|
|
| SLen1Unit |
Length 1 - UoM for Sales |
Int |
6 |
- |
|
|
|
| Slength2 |
Length 2 - Sales Unit |
Num |
19.6 |
- |
|
|
|
| SLen2Unit |
Length 2 - UoM for Sales |
Int |
6 |
- |
|
|
|
| SVolume |
Volume - Sales Unit |
Num |
19.6 |
- |
|
|
|
| SVolUnit |
Volume - UoM for Sales |
Int |
6 |
- |
|
|
|
| SWeight1 |
Weight 1 - Sales Unit |
Num |
19.6 |
- |
|
|
|
| SWght1Unit |
Weight 1 - UoM for Sales |
Int |
6 |
- |
|
|
|
| SWeight2 |
Weight 2 - Sales Unit |
Num |
19.6 |
- |
|
|
|
| SWght2Unit |
Weight 2 - UoM for Sales |
Int |
6 |
- |
|
|
|
| BHeight1 |
Height 1 - Purchasing Unit |
Num |
19.6 |
- |
|
|
|
| BHght1Unit |
Height 1 - UoM for Purchasing |
Int |
6 |
- |
|
|
|
| BHeight2 |
Height 2 - Purchasing Unit |
Num |
19.6 |
- |
|
|
|
| BHght2Unit |
Height 2 - UoM for Purchasing |
Int |
6 |
- |
|
|
|
| BWidth1 |
Width 1 - Purchasing Unit |
Num |
19.6 |
- |
|
|
|
| BWdth1Unit |
Width 1 - UoM for Purchasing |
Int |
6 |
- |
|
|
|
| BWidth2 |
Width 2 - Purchasing Unit |
Num |
19.6 |
- |
|
|
|
| BWdth2Unit |
Width 2 - UoM for Purchasing |
Int |
6 |
- |
|
|
|
| BLength1 |
Length 1 - Purchase Unit |
Num |
19.6 |
- |
|
|
|
| BLen1Unit |
Length 1 - UoM for Purchasing |
Int |
6 |
- |
|
|
|
| Blength2 |
Length 2 - Purchasing Unit |
Num |
19.6 |
- |
|
|
|
| BLen2Unit |
Length 2 - UoM for Purchasing |
Int |
6 |
- |
|
|
|
| BVolume |
Volume - Purchasing Unit |
Num |
19.6 |
- |
|
|
|
| BVolUnit |
Volume - UoM for Purchasing |
Int |
6 |
- |
|
|
|
| BWeight1 |
Weight 1 - Purchasing Unit |
Num |
19.6 |
- |
|
|
|
| BWght1Unit |
Weight 1 - UoM for Purchasing |
Int |
6 |
- |
|
|
|
| BWeight2 |
Weight 2 - Purchasing Unit |
Num |
19.6 |
- |
|
|
|
| BWght2Unit |
Weight 2 - UoM for Purchasing |
Int |
6 |
- |
|
|
|
| FixCurrCms |
Currency of Fixed Commission |
nVarChar |
3 |
- |
|
|
|
| FirmCode |
Manufacturer |
Int |
6 |
OMRC |
-1 |
|
|
| LstSalDate |
Last Sale Date |
Date |
8 |
- |
|
|
|
| QryGroup1 |
Property 1 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup2 |
Property 2 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup3 |
Property 3 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup4 |
Property 4 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup5 |
Property 5 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup6 |
Property 6 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup7 |
Property 7 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup8 |
Property 8 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup9 |
Property 9 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup10 |
Property 10 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup11 |
Property 11 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup12 |
Property 12 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup13 |
Property 13 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup14 |
Property 14 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup15 |
Property 15 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup16 |
Property 16 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup17 |
Property 17 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup18 |
Property 18 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup19 |
Property 19 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup20 |
Property 20 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup21 |
Property 21 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup22 |
Property 22 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup23 |
Property 23 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup24 |
Property 24 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup25 |
Property 25 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup26 |
Property 26 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup27 |
Property 27 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup28 |
Property 28 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup29 |
Property 29 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup30 |
Property 30 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup31 |
Property 31 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup32 |
Property 32 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup33 |
Property 33 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup34 |
Property 34 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup35 |
Property 35 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup36 |
Property 36 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup37 |
Property 37 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup38 |
Property 38 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup39 |
Property 39 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup40 |
Property 40 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup41 |
Property 41 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup42 |
Property 42 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup43 |
Property 43 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup44 |
Property 44 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup45 |
Property 45 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup46 |
Property 46 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup47 |
Property 47 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup48 |
Property 48 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup49 |
Property 49 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup50 |
Property 50 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup51 |
Property 51 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup52 |
Property 52 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup53 |
Property 53 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup54 |
Property 54 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup55 |
Property 55 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup56 |
Property 56 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup57 |
Property 57 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup58 |
Property 58 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup59 |
Property 59 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup60 |
Property 60 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup61 |
Property 61 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup62 |
Property 62 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup63 |
Property 63 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup64 |
Property 64 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| CreateDate |
Production Date |
Date |
8 |
- |
|
|
|
| UpdateDate |
Date of Update |
Date |
8 |
- |
|
|
|
| ExportCode |
Data Export Code |
nVarChar |
20 |
- |
|
|
|
| SalFactor1 |
Sales Factor 1 |
Num |
19.6 |
- |
|
|
|
| SalFactor2 |
Sales Factor 2 |
Num |
19.6 |
- |
|
|
|
| SalFactor3 |
Sales Factor 3 |
Num |
19.6 |
- |
|
|
|
| SalFactor4 |
Sales Factor 4 |
Num |
19.6 |
- |
|
|
|
| PurFactor1 |
Purchasing Factor 1 |
Num |
19.6 |
- |
|
|
|
| PurFactor2 |
Purchasing Factor 2 |
Num |
19.6 |
- |
|
|
|
| PurFactor3 |
Purchasing Factor 3 |
Num |
19.6 |
- |
|
|
|
| PurFactor4 |
Purchasing Factor 4 |
Num |
19.6 |
- |
|
|
|
| SalFormula |
Sales Formula |
nVarChar |
40 |
- |
|
|
|
| PurFormula |
Purchasing Formula |
nVarChar |
40 |
- |
|
|
|
| VatGroupPu |
Purchasing Tax Definition |
nVarChar |
8 |
OVTG |
|
|
|
| AvgPrice |
Item Cost |
Num |
19.6 |
- |
|
|
|
| PurPackMsr |
Packaging UoM (Purchasing) |
nVarChar |
30 |
- |
|
|
|
| PurPackUn |
Quantity per Package (Purchasing) |
Num |
19.6 |
- |
|
|
|
| SalPackMsr |
Packaging UoM (Sales) |
nVarChar |
30 |
- |
|
|
|
| SalPackUn |
Quantity per Package (Sales) |
Num |
19.6 |
- |
|
|
|
| SCNCounter |
SCN Counter |
Int |
6 |
- |
|
|
|
| ManBtchNum |
Manage Batch No. [Yes/No] |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| ManOutOnly |
Manage SN Only on Exit |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| DataSource |
Data Source |
VarChar |
1 |
- |
N |
N |
Unknown |
| |
|
|
|
|
|
I |
Interface |
| |
|
|
|
|
|
U |
Update |
| |
|
|
|
|
|
M |
Import |
| |
|
|
|
|
|
O |
DI API |
| |
|
|
|
|
|
S |
Service Layer |
| |
|
|
|
|
|
W |
Web Client |
| |
|
|
|
|
|
A |
Doc. Generation Wizard |
| |
|
|
|
|
|
D |
Restore Wizard |
| |
|
|
|
|
|
P |
Partner Implementation |
| |
|
|
|
|
|
T |
Year Transfer |
| |
|
|
|
|
|
G |
Fixed Assets Migration |
| validFor |
Active |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| validFrom |
Active From |
Date |
8 |
- |
|
|
|
| validTo |
Active To |
Date |
8 |
- |
|
|
|
| frozenFor |
Inactive |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| frozenFrom |
Inactive From |
Date |
8 |
- |
|
|
|
| frozenTo |
Inactive To |
Date |
8 |
- |
|
|
|
| BlockOut |
Force selection of serial no. |
VarChar |
1 |
- |
Y |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| ValidComm |
Active Remarks |
nVarChar |
30 |
- |
|
|
|
| FrozenComm |
Inactive Remarks |
nVarChar |
30 |
- |
|
|
|
| LogInstanc |
Log Instance |
Int |
11 |
- |
0 |
|
|
| ObjType |
Object Type |
nVarChar |
20 |
ADP1 |
4 |
|
|
| SWW |
Additional Identifier |
nVarChar |
16 |
- |
|
|
|
| Deleted |
Deleted |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| DocEntry |
Internal Number |
Int |
11 |
- |
|
|
|
| ExpensAcct |
Expense Account |
nVarChar |
15 |
OACT |
|
|
|
| FrgnInAcct |
Revenue Account - Foreign |
nVarChar |
15 |
OACT |
|
|
|
| ShipType |
Shipping Type |
Int |
6 |
OSHP |
|
|
|
| GLMethod |
Set G/L Accounts By |
VarChar |
1 |
- |
W |
W |
Warehouse |
| |
|
|
|
|
|
C |
Item Group |
| |
|
|
|
|
|
L |
Item Level |
| ECInAcct |
Revenue Account - EU |
nVarChar |
15 |
- |
|
|
|
| FrgnExpAcc |
Expense Account - Foreign |
nVarChar |
15 |
- |
|
|
|
| ECExpAcc |
Expense Account - EU |
nVarChar |
15 |
- |
|
|
|
| TaxType |
Tax Type |
VarChar |
1 |
- |
Y |
Y |
Regular Tax |
| |
|
|
|
|
|
U |
Use Tax |
| |
|
|
|
|
|
N |
No Tax |
| ByWh |
Manage Inventory by Warehouse |
VarChar |
1 |
- |
|
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| WTLiable |
WTax Liable |
VarChar |
1 |
- |
Y |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| ItemType |
Item Type |
VarChar |
1 |
- |
I |
I |
Items |
| |
|
|
|
|
|
L |
Labor |
| |
|
|
|
|
|
T |
Travel |
| |
|
|
|
|
|
F |
Fixed Assets |
| WarrntTmpl |
Warranty Template |
nVarChar |
20 |
OCTT |
|
|
|
| BaseUnit |
Base Unit Name |
nVarChar |
20 |
- |
|
|
|
| CountryOrg |
Country/Region of Origin |
nVarChar |
3 |
- |
|
|
|
| StockValue |
Inventory Value |
Num |
19.6 |
- |
|
|
|
| Phantom |
Phantom Item |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| IssueMthd |
Issue Method |
VarChar |
1 |
- |
|
B |
Backflush |
| |
|
|
|
|
|
M |
Manual |
| FREE1 |
Yield in % |
VarChar |
1 |
- |
|
|
|
| PricingPrc |
Pricing Percentage |
Num |
19.6 |
- |
|
|
|
| MngMethod |
Management Method |
VarChar |
1 |
- |
R |
A |
On Every Transaction |
| |
|
|
|
|
|
R |
On Release Only |
| ReorderPnt |
Reorder Point |
Num |
19.6 |
- |
|
|
|
| InvntryUom |
Inventory UoM |
nVarChar |
100 |
- |
|
|
|
| PlaningSys |
Planning Method |
VarChar |
1 |
- |
N |
M |
MRP |
| |
|
|
|
|
|
N |
None |
| PrcrmntMtd |
Procurement Method |
VarChar |
1 |
- |
B |
B |
Buy |
| |
|
|
|
|
|
M |
Make |
| OrdrIntrvl |
Order Interval |
Int |
6 |
OCYC |
|
|
|
| OrdrMulti |
Order Multiple |
Num |
19.6 |
- |
|
|
|
| MinOrdrQty |
Minimum Order Quantity |
Num |
19.6 |
- |
|
|
|
| LeadTime |
Lead Time |
Int |
11 |
- |
|
|
|
| IndirctTax |
Indirect Tax |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| TaxCodeAR |
Tax Code (A/R) |
nVarChar |
8 |
OSTC |
|
|
|
| TaxCodeAP |
Tax Code (A/P) |
nVarChar |
8 |
OSTC |
|
|
|
| OSvcCode |
Outgoing Service Code |
Int |
11 |
OSCD |
-1 |
|
|
| ISvcCode |
Incoming Service Code |
Int |
11 |
OSCD |
-1 |
|
|
| ServiceGrp |
Service Group |
Int |
11 |
OSGP |
-1 |
|
|
| NCMCode |
NCM Code |
Int |
11 |
ONCM |
-1 |
|
|
| MatType |
Material Type |
nVarChar |
3 |
OMTP |
1 |
|
|
| MatGrp |
Material Group |
Int |
11 |
OMGP |
-1 |
|
|
| ProductSrc |
Product Source |
nVarChar |
2 |
OPSC |
0 |
|
|
| ServiceCtg |
Service Category |
Int |
11 |
OSCG |
-1 |
|
|
| ItemClass |
Service or Material |
VarChar |
1 |
- |
2 |
2 |
Material |
| |
|
|
|
|
|
1 |
Service |
| Excisable |
Excisable [Yes/No] |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| ChapterID |
Chapter ID |
Int |
11 |
OCHP |
-1 |
|
|
| NotifyASN |
Notification Availed SN. |
nVarChar |
40 |
- |
|
|
|
| ProAssNum |
Provisional Assessment No. |
nVarChar |
20 |
- |
|
|
|
| AssblValue |
Assessable Value |
Num |
19.6 |
- |
|
|
|
| DNFEntry |
DNF Code Entry |
Int |
11 |
ODNF |
-1 |
|
|
| UserSign2 |
Updating User |
Int |
6 |
OUSR |
|
|
|
| Spec |
Item Specification |
nVarChar |
30 |
- |
|
|
|
| TaxCtg |
Tax Category |
nVarChar |
4 |
- |
|
|
|
| Series |
Series |
Int |
11 |
NNM1 |
|
|
|
| Number |
Number |
Int |
11 |
- |
|
|
|
| FuelCode |
Fuel |
Int |
11 |
OBFI |
-1 |
|
|
| BeverTblC |
Beverage Table |
nVarChar |
2 |
OBSI |
|
|
|
| BeverGrpC |
Beverage Group |
nVarChar |
2 |
OBSI |
|
|
|
| BeverTM |
Beverage Brand |
Int |
11 |
OBNI |
-1 |
|
|
| Attachment |
Attachment |
Text |
16 |
- |
|
|
|
| AtcEntry |
Attachment Entry |
Int |
11 |
- |
|
|
|
| ToleranDay |
Tolerance Days |
Int |
11 |
- |
|
|
|
| UgpEntry |
UoM Group |
Int |
11 |
OUGP |
|
|
|
| PUoMEntry |
Default Purchasing UoM |
Int |
11 |
OUOM |
|
|
|
| SUoMEntry |
Default Sales UoM |
Int |
11 |
OUOM |
|
|
|
| IUoMEntry |
Inventory UoM |
Int |
11 |
OUOM |
|
|
|
| IssuePriBy |
Issue Primarily By SnB or Bin |
Int |
6 |
- |
|
0 |
Issue Primarily by Serial/Batch Number |
| |
|
|
|
|
|
1 |
Issue Primarily by Bin Location |
| AssetClass |
Asset Class |
nVarChar |
20 |
OACS |
|
|
|
| AssetGroup |
Asset Group |
nVarChar |
15 |
OAGS |
|
|
|
| InventryNo |
Inventory Number of Asset |
nVarChar |
12 |
- |
|
|
|
| Technician |
Technician of Fixed Asset |
Int |
11 |
OHEM |
|
|
|
| Employee |
Employee of Fixed Asset |
Int |
11 |
OHEM |
|
|
|
| Location |
Location |
Int |
11 |
OLCT |
|
|
|
| StatAsset |
Owned by Company |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| Cession |
Cession |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| DeacAftUL |
Deactivate After Useful Life |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| AsstStatus |
Asset Status |
VarChar |
1 |
- |
N |
N |
New |
| |
|
|
|
|
|
A |
Active |
| |
|
|
|
|
|
I |
Inactive |
| CapDate |
Capitalization Date |
Date |
8 |
- |
|
|
|
| AcqDate |
Acquisition Date |
Date |
8 |
- |
|
|
|
| RetDate |
Retirement Date |
Date |
8 |
- |
|
|
|
| GLPickMeth |
G/L Account Pick Method |
VarChar |
1 |
- |
A |
A |
General |
| |
|
|
|
|
|
W |
Warehouse |
| |
|
|
|
|
|
C |
Item Group |
| NoDiscount |
No Discounts |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| MgrByQty |
Manage Asset by Quantity |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| AssetRmk1 |
Asset Remark 1 |
nVarChar |
100 |
- |
|
|
|
| AssetRmk2 |
Asset Remark 2 |
nVarChar |
100 |
- |
|
|
|
| AssetAmnt1 |
Asset Amount 1 |
Num |
19.6 |
- |
|
|
|
| AssetAmnt2 |
Asset Amount 2 |
Num |
19.6 |
- |
|
|
|
| DeprGroup |
Depreciation Group |
nVarChar |
15 |
OADG |
|
|
|
| AssetSerNo |
Asset Serial Number |
nVarChar |
32 |
- |
|
|
|
| CntUnitMsr |
Inventory Counting UoM Name |
nVarChar |
100 |
- |
|
|
|
| NumInCnt |
No. of Items per Counting Unit |
Num |
19.6 |
- |
|
|
|
| INUoMEntry |
Inventory Counting UoM Entry |
Int |
11 |
OUOM |
|
|
|
| OneBOneRec |
One Batch One Receipt |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| RuleCode |
Checking Rule Code |
nVarChar |
2 |
ODCR |
|
|
|
| ScsCode |
SCS Code |
nVarChar |
10 |
- |
|
|
|
| SpProdType |
Special Product Type |
nVarChar |
2 |
- |
|
MT |
Cellular Phones |
| |
|
|
|
|
|
IO |
Integrated Circuits |
| IWeight1 |
Weight 1 - Inventory |
Num |
19.6 |
- |
|
|
|
| IWght1Unit |
Weight 1 - Inventory Unit |
Int |
6 |
- |
|
|
|
| IWeight2 |
Weight 2 - Inventory |
Num |
19.6 |
- |
|
|
|
| IWght2Unit |
Weight 2 - Inventory Unit |
Int |
6 |
- |
|
|
|
| CompoWH |
Component Warehouse |
VarChar |
1 |
- |
B |
B |
From Bill of Materials Line |
| |
|
|
|
|
|
P |
From Parent Item Document Line |
| CreateTS |
Creatn Time - Incl. Secs |
Int |
11 |
- |
|
|
|
| UpdateTS |
Update Full Time |
Int |
11 |
- |
|
|
|
| VirtAstItm |
Virtual Asset Item |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| SouVirAsst |
Source Virtual Asset Item |
nVarChar |
50 |
OITM |
|
|
|
| InCostRoll |
Include in Prod. Cost Rollup |
VarChar |
1 |
- |
Y |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| PrdStdCst |
Production Std Cost |
Num |
19.6 |
- |
|
|
|
| EnAstSeri |
Enforce Asset Serial Numbers |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| LinkRsc |
Linked Resource |
nVarChar |
50 |
ORSC |
|
|
|
| OnHldPert |
Capital Goods On Hold Percent |
Num |
19.6 |
- |
|
|
|
| onHldLimt |
Capital Goods on Hold Limit |
Num |
19.6 |
- |
|
|
|
| PriceUnit |
Pricing Unit |
Int |
11 |
OUOM |
|
|
|
| GSTRelevnt |
GST Relevant |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| SACEntry |
SAC Entry |
Int |
11 |
OSAC |
-1 |
|
|
| GstTaxCtg |
GST Tax Category |
VarChar |
1 |
- |
R |
R |
Regular |
| |
|
|
|
|
|
N |
Nil Rated |
| |
|
|
|
|
|
E |
Exempt |
| AssVal4WTR |
Assessable Value for WTR |
Num |
19.6 |
- |
|
|
|
| ExcImpQUoM |
Default Excise Imported Quantity UoM |
Int |
11 |
- |
|
|
|
| |
|
|
|
|
|
112 |
Liters, m3 |
| |
|
|
|
|
|
168 |
Tonne, metric ton (1000 kg) |
| |
|
|
|
|
|
251 |
Horsepower (1 hp = 0.75 kW) |
| |
|
|
|
|
|
831 |
Liters of anhydrous (pure) alcohol |
| ExcFixAmnt |
Default Excise Fixed Amount |
Num |
19.6 |
- |
|
|
|
| ExcRate |
Default Excise Rate |
Num |
19.6 |
- |
|
|
|
| SOIExc |
SOI Excisable |
VarChar |
1 |
- |
4 |
1 |
Excisable |
| |
|
|
|
|
|
2 |
Exemption of excises |
| |
|
|
|
|
|
3 |
Excises are paid to another authority |
| |
|
|
|
|
|
4 |
Not Excisable |
| TNVED |
TNVED Code |
nVarChar |
10 |
- |
|
|
|
| Imported |
Imported Item |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| AutoBatch |
Automatic Batches [Yes/No] |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| CstmActing |
Customer Accounting |
VarChar |
1 |
- |
N |
N |
No |
| |
|
|
|
|
|
Y |
Yes |
| StdItemId |
Standard Item Identification |
Int |
11 |
OUNCL |
|
|
|
| CommClass |
Commodity Classification |
Int |
11 |
OUNCL |
|
|
|
| TaxCatCode |
Tax Category Code for GTS |
nVarChar |
50 |
OTCC |
|
|
|
| DataVers |
Data Version |
Int |
11 |
- |
1 |
|
|
| NVECode |
NVE Code |
nVarChar |
6 |
- |
|
|
|
| CESTCode |
CEST Code |
Int |
11 |
OCEST |
-1 |
|
|
| CtrSealQty |
Control Seal Qty |
Num |
19.6 |
- |
|
|
|
| LegalText |
Legal Text |
nVarChar |
250 |
- |
|
|
|
| QRCodeSrc |
QR Code Source |
Text |
16 |
- |
|
|
|
| Traceable |
Traceable |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| IfrsPsRev |
IFRS Posting for Revaluation |
VarChar |
1 |
- |
N |
N |
No |
| |
|
|
|
|
|
Y |
Yes |
| PlPaTaxCat |
Plastic Packaging Tax Category |
nVarChar |
2 |
- |
|
|
|
| PlPaWght |
Plastic Packaging Weight |
Num |
19.6 |
- |
|
|
|
| PPTExReSa |
Plastic Packaging Tax Exemption Reason for A/P or A/R |
nVarChar |
2 |
OBSI |
|
|
|
| PPTExRePr |
Plastic Package Tax Exemption Reason for Production |
nVarChar |
2 |
OBSI |
|
|
|
| ProdctType |
SAF-T Product Type |
VarChar |
1 |
- |
P |
P |
Products |
| |
|
|
|
|
|
S |
Services |
| |
|
|
|
|
|
O |
Other |
| |
|
|
|
|
|
I |
Taxes |
| ProdTypeEx |
SAF-T Product Type |
nVarChar |
10 |
OSPT |
P |
|
|