| Field |
Description |
Type |
Size |
Related |
Default Value |
Constraints |
| ItmsGrpCod |
Number |
Int |
6 |
- |
|
|
|
| ItmsGrpNam |
Group Name |
nVarChar |
100 |
- |
|
|
|
| Locked |
Locked |
VarChar |
1 |
- |
N |
N |
Changeable |
| |
|
|
|
|
|
Y |
Locked |
| 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 |
| UserSign |
User Signature |
Int |
6 |
OUSR |
|
|
|
| BalInvntAc |
Inventory Account |
nVarChar |
15 |
OACT |
|
|
|
| SaleCostAc |
Cost of Goods Sold Account |
nVarChar |
15 |
OACT |
|
|
|
| TransferAc |
Allocation Account |
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 |
|
|
|
| CycleCode |
Cycle Code |
Int |
6 |
OCYC |
|
|
|
| Alert |
Alert |
VarChar |
1 |
- |
N |
N |
No |
| |
|
|
|
|
|
Y |
Yes |
| PriceDifAc |
Price Difference Account |
nVarChar |
15 |
OACT |
|
|
|
| ExchangeAc |
Exchange Rate Differences Account |
nVarChar |
15 |
OACT |
|
|
|
| BalanceAcc |
Goods Clearing Account |
nVarChar |
15 |
OACT |
|
|
|
| PurchaseAc |
Purchase Account |
nVarChar |
15 |
OACT |
|
|
|
| PAReturnAc |
Purchase Return Account |
nVarChar |
15 |
OACT |
|
|
|
| PurchOfsAc |
Purchase Offset Account |
nVarChar |
15 |
OACT |
|
|
|
| ShpdGdsAct |
Shipped Goods Account |
nVarChar |
15 |
OACT |
|
|
|
| VatRevAct |
VAT in Revenue Account |
nVarChar |
15 |
OACT |
|
|
|
| DecresGlAc |
G/L Decrease Account |
nVarChar |
15 |
OACT |
|
|
|
| IncresGlAc |
G/L Increase Account |
nVarChar |
15 |
OACT |
|
|
|
| InvntSys |
Inventory System |
VarChar |
1 |
- |
|
A |
Moving Average |
| |
|
|
|
|
|
S |
Standard |
| |
|
|
|
|
|
F |
FIFO |
| 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 |
- |
|
|
|
| StokRvlAct |
Inventory Revaluation Account |
nVarChar |
15 |
OACT |
|
|
|
| StkOffsAct |
Inventory Revaluation Offset Account |
nVarChar |
15 |
OACT |
|
|
|
| WipAcct |
WIP Inventory Account |
nVarChar |
15 |
OACT |
|
|
|
| WipVarAcct |
WIP Inventory Variance Account |
nVarChar |
15 |
OACT |
|
|
|
| CostRvlAct |
COGS Revaluation Account |
nVarChar |
15 |
OACT |
|
|
|
| CstOffsAct |
COGS Revaluation Offset Acct |
nVarChar |
15 |
OACT |
|
|
|
| ExpClrAct |
Expense Clearing Account |
nVarChar |
15 |
OACT |
|
|
|
| ExpOfstAct |
Expense Offset Account |
nVarChar |
15 |
OACT |
|
|
|
| Object |
Object Type - History |
nVarChar |
20 |
- |
52 |
|
|
| 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 |
OACT |
|
|
|
| ARCMFrnAct |
Sales Credit Account - Foreign |
nVarChar |
15 |
OACT |
|
|
|
| ARCMEUAct |
Sales Credit Account - EU |
nVarChar |
15 |
OACT |
|
|
|
| ARCMExpAct |
Tax Exempt Credit Account |
nVarChar |
15 |
OACT |
|
|
|
| APCMAct |
Purchase Credit Account |
nVarChar |
15 |
OACT |
|
|
|
| APCMFrnAct |
Purchase Credit Account - Foreign |
nVarChar |
15 |
OACT |
|
|
|
| APCMEUAct |
Purchase Credit Account - EU |
nVarChar |
15 |
OACT |
|
|
|
| RevRetAct |
Revenue Returns Account |
nVarChar |
15 |
OACT |
|
|
|
| ItemClass |
Service or Material |
VarChar |
1 |
- |
2 |
1 |
Service |
| |
|
|
|
|
|
2 |
Material |
| 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 |
|
|
| NegStckAct |
Negative Inventory Adjustment Acct |
nVarChar |
15 |
OACT |
|
|
|
| StkInTnAct |
Stock In Transit Account |
nVarChar |
15 |
OACT |
|
|
|
| PurBalAct |
Purchase Balance Account |
nVarChar |
15 |
OACT |
|
|
|
| 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 |
|
|
|
| UgpEntry |
Default UoM Group Entry |
Int |
11 |
OUGP |
|
|
|
| IUoMEntry |
Default Inventory UoM |
Int |
11 |
OUOM |
|
|
|
| ToleranDay |
Tolerance Days |
Int |
11 |
- |
|
|
|
| RuleCode |
Checking Rule Code |
nVarChar |
2 |
ODCR |
|
|
|
| CompoWH |
Component Warehouse |
VarChar |
1 |
- |
B |
B |
From Bill of Materials Line |
| |
|
|
|
|
|
P |
From Parent Item Document Line |
| FreeChrgSA |
Free of Charge Sales Account |
nVarChar |
15 |
OACT |
|
|
|
| FreeChrgPU |
Free of Charge Purchase Account |
nVarChar |
15 |
OACT |
|
|
|
| RawMtrl |
Raw Material |
VarChar |
1 |
- |
N |
N |
No |
| |
|
|
|
|
|
Y |
Yes |