Module List > Module IV tables IV00102
You are currently viewing the COMPANY database.
Change

COMPANY..IV00102 Table Definition

(COMPANY..Item Quantity Master)

The Item Qty Master stores the quantities of the items.  It consists of an 'overall' record that holds the totals for all the sites as well as a record for each site that this item is assigned to.  The two types are differentiated by the Location Code & Record type.  We recommend that you not import any quantities (except Reorder Level, Maximum Qty Level, and QTY Sold) into this file.  The reason for that is an inventory reconcile will compare receipts for the item against the quantities and correct them to match.  This would cancel any beginning balances for the item that was imported here.  A better way would be to import inventory transactions and post the beginning balances for the items.  Reconciling does not impact the following fields:  Committed (not used yet), Sold, or Requisitioned.


4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
ITEMNMBR char(31)
''
Item Numbe...(more) Join Now
join ... more text available
LOCNCODE char(11)
''
Location C...(more) Join Now
join ... more text available
BINNMBR char(21)
''
Bin Number...(more) Join Now
RCRDTYPE smallint
0
Record Typ...(more) Join Now
PRIMVNDR char(15)
''
Primary Ve...(more) Join Now
ITMFRFLG tinyint
0
Item Freez...(more) Join Now
BGNGQTY numeric(19,5)
0.00
Beginning ...(more) Join Now
LSORDQTY numeric(19,5)
0.00
Last ORD Q...(more) Join Now
LRCPTQTY numeric(19,5)
0.00
Last RCPT ...(more) Join Now
LSTORDDT datetime
'1/1/1900'
Last ORD D...(more) Join Now
LSORDVND char(15)
''
Last ORD V...(more) Join Now
LSRCPTDT datetime
'1/1/1900'
Last RCPT ...(more) Join Now
QTYRQSTN numeric(19,5)
0.00
QTY Requis...(more) Join Now
QTYONORD numeric(19,5)
0.00
QTY On Ord...(more) Join Now
QTYBKORD numeric(19,5)
0.00
QTY Back O...(more) Join Now
QTY_Drop_Shipped numeric(19,5)
0.00
QTY Drop S...(more) Join Now
QTYINUSE numeric(19,5)
0.00
QTY In Use...(more) Join Now
QTYINSVC numeric(19,5)
0.00
QTY In Ser...(more) Join Now
QTYRTRND numeric(19,5)
0.00
QTY Return...(more) Join Now
QTYDMGED numeric(19,5)
0.00
QTY Damage...(more) Join Now
QTYONHND numeric(19,5)
0.00
QTY On Han...(more) Join Now
ATYALLOC numeric(19,5)
0.00
QTY Alloca...(more) Join Now
QTYCOMTD numeric(19,5)
0.00
QTY Commit...(more) Join Now
QTYSOLD numeric(19,5)
0.00
QTY Sold: ...(more) Join Now
NXTCNTDT datetime
'1/1/1900'
Next Count...(more) Join Now
NXTCNTTM datetime
'1/1/1900'
Next Count...(more) Join Now
LSTCNTDT datetime
'1/1/1900'
Last Count...(more) Join Now
LSTCNTTM datetime
'1/1/1900'
Last Count...(more) Join Now
STCKCNTINTRVL smallint
0
Stock Coun...(more) Join Now
Landed_Cost_Group_ID char(15)
''
Landed Cos...(more) Join Now
BUYERID char(15)
''
Buyer ID:...(more) Join Now
PLANNERID char(15)
''
Planner ID...(more) Join Now
ORDERPOLICY smallint
0
Order Poli...(more) Join Now
FXDORDRQTY numeric(19,5)
0.00
Fixed Orde...(more) Join Now
ORDRPNTQTY numeric(19,5)
0.00
Order Poin...(more) Join Now
NMBROFDYS smallint
0
Number of ...(more) Join Now
MNMMORDRQTY numeric(19,5)
0.00
Minimum Or...(more) Join Now
MXMMORDRQTY numeric(19,5)
0.00
Maximum Or...(more) Join Now
ORDERMULTIPLE numeric(19,5)
0.00
Order Mult...(more) Join Now
REPLENISHMENTMETHOD smallint
0
Replenishm...(more) Join Now
SHRINKAGEFACTOR numeric(19,5)
0.00
Shrinkage ...(more) Join Now
PRCHSNGLDTM numeric(19,5)
0.00
Purchasing...(more) Join Now
MNFCTRNGFXDLDTM numeric(19,5)
0.00
Manufactur...(more) Join Now
MNFCTRNGVRBLLDTM numeric(19,5)
0.00
Manufactur...(more) Join Now
STAGINGLDTME numeric(19,5)
0.00
Staging Le...(more) Join Now
PLNNNGTMFNCDYS smallint
0
Planning T...(more) Join Now
DMNDTMFNCPRDS smallint
0
Demand Tim...(more) Join Now
INCLDDINPLNNNG tinyint
0
Included i...(more) Join Now
CALCULATEATP tinyint
0
Calculate ...(more) Join Now
AUTOCHKATP tinyint
0
Auto Check...(more) Join Now
PLNFNLPAB tinyint
0
Plan Final...(more) Join Now
FRCSTCNSMPTNPRD smallint
0
Forecast C...(more) Join Now
ORDRUPTOLVL numeric(19,5)
0.00
Order Up T...(more) Join Now
SFTYSTCKQTY numeric(19,5)
0.00
Safety Sto...(more) Join Now
REORDERVARIANCE numeric(19,5)
0.00
Reorder Va...(more) Join Now
PORECEIPTBIN char(15)
''
Purchase R...(more) Join Now
PORETRNBIN char(15)
''
Purchase R...(more) Join Now
SOFULFILLMENTBIN char(15)
''
SO Fulfill...(more) Join Now
SORETURNBIN char(15)
''
SO Return ...(more) Join Now
BOMRCPTBIN char(15)
''
BOM Receip...(more) Join Now
MATERIALISSUEBIN char(15)
''
Material I...(more) Join Now
MORECEIPTBIN char(15)
''
MO Receipt...(more) Join Now
REPAIRISSUESBIN char(15)
''
Repair Iss...(more) Join Now
ReplenishmentLevel smallint
0
Replenishm...(more) Join Now
POPOrderMethod smallint
0
POP Order ...(more) Join Now
MasterLocationCode char(11)
''
Master Loc...(more) Join Now
POPVendorSelection smallint
0
POP Vendor...(more) Join Now
POPPricingSelection smallint
0
POP Pricin...(more) Join Now
PurchasePrice numeric(19,5)
0.00
Purchase P...(more) Join Now
IncludeAllocations tinyint
0
Include Al...(more) Join Now
IncludeBackorders tinyint
0
Include Ba...(more) Join Now
IncludeRequisitions tinyint
0
Include Re...(more) Join Now
PICKTICKETITEMOPT smallint
0
Picking Ti...(more) Join Now
INCLDMRPMOVEIN tinyint
0
IncludeMRP...(more) Join Now
INCLDMRPMOVEOUT tinyint
0
IncludeMRP...(more) Join Now
INCLDMRPCANCEL tinyint
0
IncludeMRP...(more) Join Now
Move_Out_Fence smallint
0

INACTIVE tinyint
0

DEX_ROW_ID int
auto number (1,1)
Unique ide...(more) Join Now
Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3