| Field |
Description |
Type |
Size |
Related |
Default Value |
Constraints |
| WhsCode |
Warehouse Code |
nVarChar |
8 |
- |
|
|
|
| WhsName |
Warehouse Name |
nVarChar |
100 |
- |
|
|
|
| IntrnalKey |
Internal Key |
Int |
11 |
- |
|
|
|
| Grp_Code |
Group Code |
nVarChar |
4 |
- |
|
|
|
| BalInvntAc |
Inventory Account |
nVarChar |
15 |
OACT |
|
|
|
| SaleCostAc |
Cost of Goods Sold Account |
nVarChar |
15 |
OACT |
|
|
|
| TransferAc |
Allocation Account |
nVarChar |
15 |
OACT |
|
|
|
| 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 |
|
|
|
| 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 |
|
|
|
| VatGroup |
Tax Group |
nVarChar |
8 |
OSTC |
|
|
|
| Street |
Street |
nVarChar |
100 |
- |
|
|
|
| Block |
Block |
nVarChar |
100 |
- |
|
|
|
| ZipCode |
Zip Code |
nVarChar |
20 |
- |
|
|
|
| City |
City |
nVarChar |
100 |
- |
|
|
|
| County |
County |
nVarChar |
100 |
OCNT |
|
|
|
| Country |
Country/Region |
nVarChar |
3 |
OCRY |
|
|
|
| State |
State |
nVarChar |
3 |
OCST |
|
|
|
| Location |
Location |
Int |
11 |
OLCT |
|
|
|
| DropShip |
Drop-Ship |
VarChar |
1 |
- |
N |
N |
No |
| |
|
|
|
|
|
Y |
Yes |
| ExmptIncom |
Exempt Revenue Account |
nVarChar |
15 |
OACT |
|
|
|
| UseTax |
Allow Use Tax |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| 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 |
|
|
|
| FedTaxID |
Federal Tax ID |
nVarChar |
32 |
- |
|
|
|
| Building |
Building/Floor/Room |
Text |
16 |
- |
|
|
|
| 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 |
|
|
|
| Nettable |
Nettable |
VarChar |
1 |
- |
Y |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| 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 |
|
|
|
| objType |
Object Type - History |
nVarChar |
20 |
- |
64 |
|
|
| 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 |
|
|
|
| BPLid |
Business Place ID |
Int |
11 |
OBPL |
|
|
|
| OwnerCode |
Owner Code |
VarChar |
1 |
- |
1 |
1 |
Company Item Property |
| |
|
|
|
|
|
2 |
Third-Party Warehouse |
| |
|
|
|
|
|
3 |
Third-Party Item in my Property |
| NegStckAct |
Negative Inventory Adjustment Acct |
nVarChar |
15 |
OACT |
|
|
|
| StkInTnAct |
Stock In Transit Account |
nVarChar |
15 |
OACT |
|
|
|
| AddrType |
Address Type |
nVarChar |
100 |
- |
|
|
|
| StreetNo |
Street No. |
nVarChar |
100 |
- |
|
|
|
| PurBalAct |
Purchase Balance Account |
nVarChar |
15 |
OACT |
|
|
|
| Excisable |
Excisable [Yes/No] |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| WhICenAct |
Incoming CENVAT Account (WH) |
nVarChar |
15 |
OACT |
|
|
|
| WhOCenAct |
Outgoing CENVAT Account (WH) |
nVarChar |
15 |
OACT |
|
|
|
| WhShipTo |
Ship-to Name (WH) |
nVarChar |
100 |
- |
|
|
|
| WipOffset |
WIP Offset P&L Account |
nVarChar |
15 |
OACT |
|
|
|
| StockOffst |
Inventory Offset P&L Account |
nVarChar |
15 |
OACT |
|
|
|
| StorKeeper |
Storekeeper |
Int |
11 |
OHEM |
|
|
|
| Shipper |
Shipper |
nVarChar |
15 |
OCRD |
|
|
|
| BinActivat |
Bin Activated [Y/N] |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| BinSeptor |
Bin Separator |
nVarChar |
5 |
- |
- |
|
|
| DftBinAbs |
Default Bin Internal Number |
Int |
11 |
OBIN |
|
|
|
| DftBinEnfd |
Default Bin Enforced [Y/N] |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| AutoIssMtd |
Auto. Issue Method |
Int |
6 |
- |
0 |
0 |
Single Choice |
| |
|
|
|
|
|
1 |
Bin Location Code Order |
| |
|
|
|
|
|
2 |
Alternative Sort Code Order |
| |
|
|
|
|
|
3 |
Descending Quantity |
| |
|
|
|
|
|
4 |
Ascending Quantity |
| |
|
|
|
|
|
7 |
Ascending Quantity - Single Bin Preferred |
| |
|
|
|
|
|
5 |
FIFO |
| |
|
|
|
|
|
6 |
LIFO |
| ManageSnB |
Drop-Ship Manage SnB |
VarChar |
1 |
- |
N |
N |
No |
| |
|
|
|
|
|
Y |
Yes |
| RecItemsBy |
Receiving Bin Locations Method |
Int |
6 |
- |
0 |
0 |
Bin Location Code Order |
| |
|
|
|
|
|
1 |
Alternative Sort Code Order |
| RecBinEnab |
Enable Receiving Bin Locations |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| GlblLocNum |
Global Location Number |
nVarChar |
50 |
- |
|
|
|
| RecvEmpBin |
Restrict Receipts to Empty Bin |
VarChar |
1 |
- |
Y |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| Inactive |
Inactive |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| RecvMaxQty |
Recv. up to Max. Qty |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| AutoRecvMd |
Auto. Receipt Method |
Int |
6 |
- |
0 |
0 |
Default Bin Location |
| |
|
|
|
|
|
1 |
Last Bin Location That Received Item |
| |
|
|
|
|
|
2 |
Item's Current Bin Locations |
| |
|
|
|
|
|
3 |
Item's Current and Historical Bin Locations |
| RecvMaxWT |
Recv. up to Max. Weight |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| RecvUpTo |
Receive up to |
nVarChar |
6 |
- |
0 |
0 |
Maximum Qty |
| |
|
|
|
|
|
1 |
Maximum Weight |
| |
|
|
|
|
|
2 |
Max. Qty and Weight |
| FreeChrgSA |
Free of Charge Sales Account |
nVarChar |
15 |
OACT |
|
|
|
| FreeChrgPU |
Free of Charge Purchase Account |
nVarChar |
15 |
OACT |
|
|
|
| TaxOffice |
Tax Office |
nVarChar |
50 |
- |
|
|
|
| Address2 |
Address Name 2 |
nVarChar |
50 |
- |
|
|
|
| Address3 |
Address Name 3 |
nVarChar |
50 |
- |
|
|
|
| External |
External |
VarChar |
1 |
- |
N |
N |
No |
| |
|
|
|
|
|
Y |
Yes |
| LegalText |
Legal Text |
nVarChar |
250 |
- |
|
|
|