| Field |
Description |
Type |
Size |
Related |
Default Value |
Constraints |
| ItemCode |
Item No. |
nVarChar |
50 |
OITM |
|
|
|
| WhsCode |
Warehouse Code |
nVarChar |
8 |
OWHS |
|
|
|
| OnHand |
In Stock |
Num |
19.6 |
- |
|
|
|
| IsCommited |
Defined |
Num |
19.6 |
- |
|
|
|
| OnOrder |
Ordered |
Num |
19.6 |
- |
|
|
|
| Consig |
Consignment Goods Whse |
Num |
19.6 |
- |
|
|
|
| Counted |
Counted Quantity |
Num |
19.6 |
- |
|
|
|
| WasCounted |
Counted Yes/No |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| UserSign |
User Signature |
Int |
6 |
OUSR |
|
|
|
| MinStock |
Minimum Inventory |
Num |
19.6 |
- |
|
|
|
| MaxStock |
Maximum Inventory |
Num |
19.6 |
- |
|
|
|
| MinOrder |
Min. Order |
Num |
19.6 |
- |
|
|
|
| AvgPrice |
Average Price |
Num |
19.6 |
- |
|
|
|
| Locked |
Locked |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| BalInvntAc |
Inventory Account |
nVarChar |
15 |
OACT |
|
|
|
| SaleCostAc |
Cost of Goods Sold Account |
nVarChar |
15 |
OACT |
|
|
|
| TransferAc |
Transfer Acct |
nVarChar |
15 |
OACT |
|
|
|
| RevenuesAc |
Revenue Account |
nVarChar |
15 |
OACT |
|
|
|
| VarianceAc |
Variance Account |
nVarChar |
15 |
OACT |
|
|
|
| DecreasAc |
Inventory Offset - Decrease Account |
nVarChar |
15 |
OACT |
|
|
|
| IncreasAc |
Inventory Offset - Increase Account |
nVarChar |
15 |
OACT |
|
|
|
| ReturnAc |
Sales Returns Account |
nVarChar |
15 |
OACT |
|
|
|
| ExpensesAc |
Expense Account |
nVarChar |
15 |
OACT |
|
|
|
| EURevenuAc |
Revenue Account - EU |
nVarChar |
15 |
OACT |
|
|
|
| EUExpensAc |
Expense Account - EU |
nVarChar |
15 |
OACT |
|
|
|
| FrRevenuAc |
Revenue Account - Foreign |
nVarChar |
15 |
OACT |
|
|
|
| FrExpensAc |
Expense Account - Foreign |
nVarChar |
15 |
OACT |
|
|
|
| ExmptIncom |
Exempt Revenue Account |
nVarChar |
15 |
OACT |
|
|
|
| PriceDifAc |
Price Differences Account |
nVarChar |
15 |
- |
|
|
|
| ExchangeAc |
Exchange Rate Differences Account |
nVarChar |
15 |
- |
|
|
|
| BalanceAcc |
Goods Clearing Account |
nVarChar |
15 |
- |
|
|
|
| PurchaseAc |
Purchase Account |
nVarChar |
15 |
- |
|
|
|
| PAReturnAc |
Purchase Return Account |
nVarChar |
15 |
- |
|
|
|
| PurchOfsAc |
Purchase Offset Account |
nVarChar |
15 |
- |
|
|
|
| ShpdGdsAct |
Shipped Goods Account |
nVarChar |
15 |
- |
|
|
|
| VatRevAct |
VAT in Revenue Account |
nVarChar |
15 |
- |
|
|
|
| StockValue |
Inventory Value |
Num |
19.6 |
- |
|
|
|
| DecresGlAc |
G/L Decrease Account |
nVarChar |
15 |
- |
|
|
|
| IncresGlAc |
G/L Increase Account |
nVarChar |
15 |
- |
|
|
|
| StokRvlAct |
Stock Inflation Adjust Account |
nVarChar |
15 |
- |
|
|
|
| StkOffsAct |
Stock Inflation Offset Account |
nVarChar |
15 |
- |
|
|
|
| WipAcct |
WIP Inventory Account |
nVarChar |
15 |
- |
|
|
|
| WipVarAcct |
WIP Inventory Variance Account |
nVarChar |
15 |
- |
|
|
|
| CostRvlAct |
Cost Inflation Account |
nVarChar |
15 |
- |
|
|
|
| CstOffsAct |
Cost Inflation Offset Account |
nVarChar |
15 |
- |
|
|
|
| ExpClrAct |
Expense Clearing Account |
nVarChar |
15 |
OACT |
|
|
|
| ExpOfstAct |
Expense Offset Account |
nVarChar |
15 |
OACT |
|
|
|
| Object |
Object Type - History |
nVarChar |
20 |
- |
31 |
|
|
| logInstanc |
Log Instance - History |
Int |
11 |
- |
|
|
|
| createDate |
Creation Date - History |
Date |
8 |
- |
|
|
|
| userSign2 |
Updating User - History |
Int |
6 |
OUSR |
|
|
|
| updateDate |
Date of Update - History |
Date |
8 |
- |
|
|
|
| ARCMAct |
Sales Credit Account |
nVarChar |
15 |
- |
|
|
|
| ARCMFrnAct |
Sales Credit Account - Foreign |
nVarChar |
15 |
- |
|
|
|
| ARCMEUAct |
Sales Credit Account - EU |
nVarChar |
15 |
- |
|
|
|
| ARCMExpAct |
Tax Exempt Credit Account |
nVarChar |
15 |
- |
|
|
|
| APCMAct |
Purchase Credit Account |
nVarChar |
15 |
- |
|
|
|
| APCMFrnAct |
Purchase Credit Account - Foreign |
nVarChar |
15 |
- |
|
|
|
| APCMEUAct |
Purchase Credit Account - EU |
nVarChar |
15 |
- |
|
|
|
| RevRetAct |
Revenue Returns Account |
nVarChar |
15 |
- |
|
|
|
| NegStckAct |
Negative Inventory Adj. Acct |
nVarChar |
15 |
OACT |
|
|
|
| StkInTnAct |
Stock In Transit Account |
nVarChar |
15 |
- |
|
|
|
| PurBalAct |
Purchase Balance Account |
nVarChar |
15 |
- |
|
|
|
| WhICenAct |
Incoming CENVAT Account (WH) |
nVarChar |
15 |
OACT |
|
|
|
| WhOCenAct |
Outgoing CENVAT Account (WH) |
nVarChar |
15 |
OACT |
|
|
|
| WipOffset |
WIP Offset P&L Account |
nVarChar |
15 |
OACT |
|
|
|
| StockOffst |
Inventory Offset P&L Account |
nVarChar |
15 |
OACT |
|
|
|
| DftBinAbs |
Default Bin Internal Number |
Int |
11 |
OBIN |
|
|
|
| DftBinEnfd |
Default Bin Enforced [Y/N] |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| Freezed |
Item Frozen in Warehouse |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| FreezeDoc |
INC Document Frozen By |
Int |
11 |
OINC |
|
|
|
| FreeChrgSA |
Free of Charge Sales Account |
nVarChar |
15 |
OACT |
|
|
|
| FreeChrgPU |
Free of Charge Purchase Account |
nVarChar |
15 |
OACT |
|
|
|
| IndEscala |
Indicator for Relevant Scale |
VarChar |
1 |
- |
Y |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| CNJPMan |
CNPJ of Manufacturer |
nVarChar |
14 |
- |
|
|
|