Inventory Tables
Note: Rows and/or Tables marked with an asterisk (*) are added to Traverse Global. Rows and/or Tables marked with a negative asterisk (-*) refer to tables and/or rows that are removed in Traverse Global.
*tblInABCClass -- IN ABC Class table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
ABCClassCode | nvarchar | 10 | |||
Description | pDescription | ||||
SeqNum | int | 0 | |||
QtyPct | pDecimal | 0 | |||
CountPerYear | int | 0 | |||
ResetYn | bit | 1 | 0 | ||
AlwaysCountYn | bit | 1 | 0 | ||
CF | xml | -1 | |||
ts | timestamp | 8 |
*tblInABCClassSettings -- IN ABC Class Settings table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
ID | bigint | ||||
ABCClassCode | nvarchar | 10 | |||
ABCType | tinyint | 1 | 0 | 0 = Product Line, 1 = Sales Category, 2 = Account Code | |
RefID | nvarchar | 255 | |||
CF | xml | -1 | |||
ts | timestamp | 8 |
*tblInBuyerPlanner -- IN Buyer-Planner table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
BuyerPlannerID | nvarchar | 10 | |||
Description | pDescription | ||||
CF | xml | -1 | |||
ts | timestamp | 8 |
*tblInCOGSAdjustment -- IN COGS Adjustment table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
SeqNum | int | ||||
ItemId | pItemID | 24 | |||
LocId | pLocID | 10 | |||
LotNum | pLotNum | 16 | |||
FunctionID | uniqueidentifier | ID to identify a function that updates inventory | |||
TransKey | nvarchar | 255 | key to identify an ITransaction | ||
GroupKey | nvarchar | 255 | group key for generating GL entry | ||
AdjustAmount | pDecimal | 28,10 | 0 | functional currency | |
AdjustAmountACV | pDecimal | 28,10 | 0 | ACV currency | |
TransDate | datetime | 8 | getdate() | ||
FiscalYear | smallint | ||||
FiscalPeriod | smallint | ||||
TransID | nvarchar | 255 | |||
SourceID | nvarchar | 10 | for Inventory history | ||
AppID | nvarchar | 2 | for Inventory history | ||
IsTransDeleted | bit | 1 | |||
CF | xml | -1 | |||
ts | timestamp | 8 |
tblInGLAcct -- IN GL Account table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
GLAcctCode | pGLAcctCode | 2 | |||
Descr | nvarchar | 35 | |||
GLAcctSales | pGlAcct | 40 | |||
GLAcctCogs | pGlAcct | 40 | |||
GLAcctInv | pGlAcct | 40 | |||
GLAcctWip | pGlAcct | 40 | |||
GLAcctInvAdj | pGlAcct | 40 | |||
GLAcctCogsAdj | pGlAcct | 40 | |||
GLAcctPurchPriceVar | pGlAcct | 40 | |||
GLAcctStandCostVar | pGlAcct | 40 | |||
GLAcctPhyCountAdj | pGlAcct | 40 | |||
GLAcctXferCost | pGlAcct | 40 | |||
GLAcctInTransit | pGlAcct | 40 | |||
CF | xml | -1 | |||
ts | timestamp | 8 | |||
GLAcctAccrual | pGlAcct | 40 |
tblInHazMat -- IN Hazardous Material table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
HMRef | int | 4 | |||
HMCode | nvarchar | 6 | |||
Descr | nvarchar | 300 | |||
ts | timestamp | 8 |
tblInHistDetail -- IN Detail History table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
HistSeqNum | int | 4 | |||
HistSeqNum_Rcpt | int | 4 | 0 | ||
ItemId | pItemID | 24 | |||
LocId | pLocID | 10 | |||
ItemType | tinyint | 1 | 0 | Item Type | 1 = Nonserialized, 2 = Serialized Item, 3 = Service Item |
LottedYN | bit | 1 | 0 | ||
TransType | tinyint | 1 | -1 | Transaction Type | 1 = Purchase, 2 = Purchase Return, 3 = Sale, 4 = Sale Return, 5 = Material Requisition, 6 = Transfer In, 7 = Transfer Out, 8 = Produced, 9 = Adj Increase, 10 = Adj Decrease, 15 = Material Req Ret, 16 = Consumed, 17 = Move In, 18 = Move Out, 19 = COGS Adjustment, 20 = Purchase Price Variance |
SumYear | smallint | 2 | 0 | ||
SumPeriod | smallint | 2 | 0 | ||
GLPeriod | smallint | 2 | 0 | ||
AppId | char | 2 | 'in' | ||
BatchId | pBatchID | 6 | |||
TransId | pTransID | 8 | |||
RefId | nvarchar | 15 | |||
SrceID | nvarchar | 10 | |||
TransDate | datetime | 8 | getdate() | ||
Uom | pUom | 5 | |||
UomBase | pUom | 5 | |||
ConvFactor | pDecimal | 13 | -1 | ||
Qty | pDecimal | 13 | 0 | ||
CostExt | pDecimal | 13 | 0 | ||
CostStd | pDecimal | 13 | 0 | ||
PriceExt | pDecimal | 13 | 0 | ||
CostUnit | pDecimal | 13 | 0 | ||
PriceUnit | pDecimal | 13 | 0 | ||
Source | tinyint | 1 | 0 | Source | 0 = None, 10 = PO Receipt, 11 = IN Receipt, 12 = AP Invoice, 13 = PO Invoice, 14 = IN Invoice Purchase, 15 = Increase, 16 = Transfer To, 17 = Material Req Return, 18 = MP Build Assembly, 19 = Move In, 20 = WM Increase, 21 = WM Transfer To, 22 = WM Material Req Return, 30 = AR Credit, 31 = SO Credit, 32 = IN Credit, 33 = BM Build Assembly, 34 = BM Unbuild Component, 70 = AP Debit, 71 = Return, 72 = IN Debit, 73 = Decrease, 74 = Transfer From, 75 = Material Req, 76 = MP Build Component, 77 = Move Out, 78 = WM Decrease, 79 = WM Transfer From, 80 = AR Invoice, 81 = SO Verify, 82 = SO Invoice, 83 = IN Verify, 84 = IN Invoice Sale, 85 = BM Build Component, 86 = BM Unbuild Assembly, 87 = WM Material Req, 88 = PO Debit, 200 = COGS Adjustment, 201 = PPV |
Qty_Invc | pDecimal | 13 | 0 | ||
CostExt_Invc | pDecimal | 13 | 0 | ||
DropShipYn | bit | 1 | 0 | ||
LotNum | pLotNum | 16 | |||
CF | xml | -1 | |||
EntryDate | datetime | 8 | |||
*CostExtACV | pDecimal | 13 | |||
*CostUnitACV | pDecimal | 13 | |||
*PostRun | pPostRun | 1 | |||
Status | tinyint | 1 | 0 | 0 = Default, 1 = Reversal |
tblInHistSer -- IN Serial Number History table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
SeqNum | int | 4 | |||
HistSeqNum | int | 4 | |||
LotNum | pLotNum | 16 | |||
SerNum | pSerNum | 35 | |||
SumYear | smallint | 2 | 0 | ||
SumPeriod | smallint | 2 | 0 | ||
GLPeriod | smallint | 2 | 0 | ||
InvcNum | pInvoiceNum | 15 | |||
DateOrder | datetime | 8 | |||
DateInvc | datetime | 8 | |||
DateRcpt | datetime | 8 | |||
DateShip | datetime | 8 | |||
CostUnit | pDecimal | 13 | 0 | ||
PriceUnit | pDecimal | 13 | 0 | ||
Cmnt | nvarchar | 35 | |||
CF | xml | -1 | |||
*CostUnitACV | pDecimal | 13 |
tblInItem -- IN Item table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
ItemId | pItemID | 24 | |||
Descr | nvarchar | 35 | |||
SuperId | pItemID | 24 | |||
ItemType | tinyint | 1 | -1 | Item Type | 1 = Nonserialized, 2 = Serialized, 3 = Service |
ItemStatus | tinyint | 1 | -1 | Item Status | 1 = Active, 2 = Discontinued, 3 = Superseded, 4 = Obsolete |
ProductLine | nvarchar | 12 | |||
SalesCat | nvarchar | 2 | |||
PriceId | nvarchar | 10 | |||
TaxClass | tinyint | 1 | 0 | ||
UomBase | pUom | 5 | |||
UomDflt | pUom | 5 | |||
LottedYN | bit | 1 | 0 | ||
AutoReorderYN | bit | 1 | 0 | ||
KittedYN | smallint | 2 | 0 | ||
ResaleYN | bit | 1 | -1 | ||
PictId | nvarchar | 10 | |||
UsrFld1 | nvarchar | 12 | |||
UsrFld2 | nvarchar | 12 | |||
UsrFld3 | nvarchar | 12 | |||
UsrFld4 | nvarchar | 12 | |||
HMRef | int | 4 | |||
CostMethodOverride | tinyint | 1 | 0 | Cost Method Override | 0 = N / A (non-serial), 1 = Specific Item, 2 = General |
CF | xml | -1 | |||
ts | timestamp | 8 | |||
CommodityCode | nvarchar | 25 |
tblInItemAddlDescr -- IN Item Additional Description table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
ItemId | pItemID | 24 | |||
AddlDescr | text | 16 | |||
CF | xml | -1 | |||
ts | timestamp | 8 |
tblInItemAlias -- IN Item Alias table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
Id | int | 4 | |||
AliasID | nvarchar | 24 | |||
AliasType | tinyint | 1 | 0 | Alias Type | 0 = User, 1 = Customer, 2 = Vendor |
RefID | nvarchar | 20 | |||
ItemID | nvarchar | 24 | |||
CF | xml | -1 | |||
ts | timestamp | 8 |
tblInItemAlt -- IN Alternate Item table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
AltItemId | pItemID | 24 | |||
ItemId | pItemID | 24 | |||
DateStart | datetime | 8 | |||
DateEnd | datetime | 8 | |||
CF | xml | -1 | |||
ts | timestamp | 8 |
*
tblInItemLabel -- IN Item Label table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
Id | bigint | 4 | |||
LabelType | tinyint | 1 | 0 = Default, 1 = WMReceiving | ||
ItemID | pItemID | 24 | |||
Uom | pUom | ||||
LabelID | nvarchar | 255 | |||
CF | xml | -1 | |||
ts | timestamp | 8 |
tblInItemLoc -- IN Item Location table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
ItemId | pItemID | 24 | |||
LocId | pLocID | 10 | |||
GLAcctCode | pGLAcctCode | 2 | |||
ItemLocStatus | tinyint | 1 | -1 | Item Location Status | 1 = Active, 2 = Discontinued, 3 = Superseded, 4 = Obsolete |
CostStd | pDecimal | 13 | 0 | ||
CostAvg | pDecimal | 13 | 0 | ||
CostBase | pDecimal | 13 | 0 | ||
CostLast | pDecimal | 13 | 0 | ||
CostLandedLast | pDecimal | 13 | 0 | ||
CarrCostPct | pDecimal | 13 | 0 | ||
OrderCostAmt | pDecimal | 13 | 0 | ||
QtySafetyStock | pDecimal | 13 | 0 | ||
QtyOrderPoint | pDecimal | 13 | 0 | ||
QtyOnHandMax | pDecimal | 13 | 0 | ||
QtyOrderMin | pDecimal | 13 | 0 | ||
Eoq | pDecimal | 13 | 0 | ||
EoqType | tinyint | 1 | 0 | Economic Order Quantity | 0 = Manual, 1 = Calculated, 2 = Frozen |
ForecastId | nvarchar | 10 | |||
SafetyStockType | tinyint | 1 | 0 | Safety Stock Type | 0 = Manual, 1 = Calculated, 2 = Frozen |
OrderPointType | tinyint | 1 | 0 | Order Point Type | 0 = Manual, 1 = Calculated, 2 = Frozen |
DateLastSale | datetime | 8 | |||
DateLastPurch | datetime | 8 | |||
DateLastSaleRet | datetime | 8 | |||
DateLastPurchRet | datetime | 8 | |||
DateLastXfer | datetime | 8 | |||
DateLastAdj | datetime | 8 | |||
DateLastBuild | datetime | 8 | |||
DateLastMatReq | datetime | 8 | |||
DfltLeadTime | pDecimal | 13 | 0 | ||
DfltBinNum | nvarchar | 10 | |||
DfltVendId | nvarchar | 10 | |||
DfltPriceId | nvarchar | 10 | |||
PriceAdjType | tinyint | 1 | 0 | ||
PriceAdjBase | tinyint | 1 | 0 | ||
PriceAdjAmt | pDecimal | 13 | 0 | ||
OrderQtyUom | pUom | 5 | |||
ABCClass | nvarchar | 10 | |||
CF | xml | -1 | |||
ts | timestamp | 8 | |||
*CurrencyIDACV | pCurrency | 6 | |||
*CostStdACV | pDecimal | 13 | |||
*CostAvgACV | pDecimal | 13 | |||
*CostBaseACV | pDecimal | 13 | |||
*CostLastACV | pDecimal | 13 | |||
*CostLandedLastACV | pDecimal | 13 | |||
*COGSAdjPosted | pDecimal | 13 | 0 | ||
*COGSAdjPostedACV | pDecimal | 13 | 0 | ||
*PrepLeadTime | pDecimal | 13 | |||
*ProcurMethod | tinyint | 1 | 0 = NA, 1 = Make, 2 = Buy | ||
*BuyerPlanner | nvarchar | 10 |
tblInItemLocBin -- IN Item Location Bin table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
ItemId | pItemID | 24 | |||
LocId | pLocID | 10 | |||
BinNum | nvarchar | 10 | |||
LastCountBatchId | pBatchID | 6 | |||
LastCountQty | pDecimal | 13 | 0 | ||
LastCountUom | pUom | 5 | |||
LastCountDate | datetime | 8 | |||
LastCountTagNum | nvarchar | 10 | |||
CF | xml | -1 | |||
ts | timestamp | 8 |
* tblInItemLocABCCalc -- IN Item Location ABC Calculations table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
ItemId | pItemID | 24 | |||
LocId | pLocID | 10 | |||
UomDflt | pUom | ||||
QtyOnHand | pDecimal | 13 | 0 | ||
OriginalABCClass | nvarchar | 10 | |||
ABCClass | nvarchar | 10 | |||
YTDQtyConsumed | pDecimal | 13 | 0 | ||
YTDHitsConsumed | pDecimal | 13 | 0 | ||
YTDValueConsumed | pDecimal | 13 | 0 | ||
TotalQtyConsumed | pDecimal | 13 | 0 | ||
TotalHitsConsumed | pDecimal | 13 | 0 | ||
TotalValueConsumed | pDecimal | 13 | 0 | ||
TotalOnHandValue | pDecimal | 13 | 0 | ||
TotalQtyPct | pDecimal | 13 | 0 | ||
TotalHitsPct | pDecimal | 13 | 0 | ||
TotalValuePct | pDecimal | 13 | 0 | ||
CF | xml | -1 | |||
ts | timestamp | 8 |
tblInItemLocLot -- IN Item Lot Location table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
ItemId | pItemID | 24 | |||
LocId | pLocID | 10 | |||
LotNum | pLotNum | 16 | |||
LotStatus | tinyint | 1 | -1 | Lot Status | 1 = Active, 2 = Sold, 3 = Expired |
InitialDate | datetime | 8 | |||
ExpDate | datetime | 8 | |||
VendID | pVendorID | 10 | |||
Cmnt | nvarchar | 35 | |||
CF | xml | -1 | |||
ts | timestamp | 8 |
tblInItemLocUomPrice -- IN Item Location Unit of Measure Price table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
ItemId | pItemID | 24 | |||
LocId | pLocID | 10 | |||
Uom | pUom | 5 | |||
BrkId | nvarchar | 10 | |||
PriceAvg | pDecimal | 13 | 0 | ||
PriceMin | pDecimal | 13 | 0 | ||
PriceList | pDecimal | 13 | 0 | ||
PriceBase | pDecimal | 13 | 0 | ||
CF | xml | -1 | |||
ts | timestamp | 8 | |||
*CurrencyID | pCurrency | 6 |
tblInItemLocVend -- IN Item Location Vender table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
ItemId | pItemID | 24 | |||
LocId | pLocID | 10 | |||
VendId | pVendorID | 10 | |||
VendName | nvarchar | 30 | |||
VendItemId | pItemID | 24 | |||
LastPOUnitCost | pDecimal | 13 | 0 | ||
LastPODate | datetime | 8 | |||
LastPOQty | pDecimal | 13 | 0 | ||
LastPOConvFactor | pDecimal | 13 | -1 | ||
LastPOOrderNum | nvarchar | 25 | |||
LastPOUom | pUom | 5 | |||
LeadTime | pDecimal | 13 | 0 | ||
BrkId | nvarchar | 10 | |||
CurrencyID | pCurrency | 6 | |||
ExchRate | pDecimal | 13 | -1 | ||
LandedCostID | nvarchar | 10 | |||
CF | xml | -1 | |||
ts | timestamp | 8 |
tblInItemPict -- IN Item Picture table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
PictId | nvarchar | 10 | |||
PictType | tinyint | 1 | 0 | Inventory Picture Type | 0 = Image, 1 = Link |
PictItem | image | 16 | |||
ImageURL | nvarchar | 255 | |||
Descr | nvarchar | 35 | |||
CF | xml | -1 | |||
ts | timestamp | 8 |
tblInItemSer -- IN Item Serial Number table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
ItemId | pItemID | 24 | |||
SerNum | pSerNum | 35 | |||
LocId | pLocID | 10 | |||
LotNum | pLotNum | 16 | |||
ExtLocA | int | 4 | |||
ExtLocB | int | 4 | |||
SerNumStatus | tinyint | 1 | -1 | Serial Number Status | 1 = Available, 2 = In Use, 3 = Sold, 4 = Lost, 5 = Sale Returned, 6 = Purchase Returned, 7 = In-Transit |
CostUnit | pDecimal | 13 | 0 | ||
PriceUnit | pDecimal | 13 | 0 | ||
InitialDate | datetime | 8 | |||
Cmnt | nvarchar | 35 | |||
Source | tinyint | 1 | 0 | Source | 0 = None, 10 = PO Receipt, 11 = IN Receipt, 12 = AP Invoice, 13 = PO Invoice, 14 = IN Invoice Purchase, 15 = Increase, 16 = Transfer To, 17 = Material Req Return, 18 = MP Build Assembly, 19 = Move In, 20 = WM Increase, 21 = WM Transfer To, 22 = WM Material Req Return, 30 = AR Credit, 31 = SO Credit, 32 = IN Credit, 33 = BM Build Assembly, 34 = BM Unbuild Component, 70 = AP Debit, 71 = Return, 72 = IN Debit, 73 = Decrease, 74 = Transfer From, 75 = Material Req, 76 = MP Build Component, 77 = Move Out, 78 = WM Decrease, 79 = WM Transfer From, 80 = AR Invoice, 81 = SO Verify, 82 = SO Invoice, 83 = IN Verify, 84 = IN Invoice Sale, 85 = BM Build Component, 86 = BM Unbuild Assembly, 87 = WM Material Req, 88 = PO Debit |
CostSell | pDecimal | 13 | 0 | ||
CostAdjPosted | pDecimal | 13 | 0 | ||
CF | xml | -1 | |||
ts | timestamp | 8 | |||
*CostUnitACV | pDecimal | 13 | |||
*CostSellACV | pDecimal | 13 | |||
*CostAdjPostedACV | pDecimal | 13 |
tblInItemUom -- IN Item Unit of Measure table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
ItemId | pItemID | 24 | |||
Uom | pUom | 5 | |||
ConvFactor | pDecimal | 13 | -1 | ||
PenaltyType | tinyint | 1 | 0 | Penalty Type | 0 = Amount, 1 = Percent |
PenaltyAmt | pDecimal | 13 | 0 | ||
UPCcode | nvarchar | 24 | |||
MinSaleQty | pDecimal | 13 | 0 | ||
Weight | pDecimal | 13 | 0 | ||
CF | xml | -1 | |||
ts | timestamp | 8 |
tblInItemUomDflt -- IN Item Unit of Measure Default table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
ItemId | pItemID | 24 | |||
DfltType | smallint | 2 | Default Type | 0 = NA - Use Default, 1 = Reporting, 2 = Sales, 4 = Purchases, 8 = Manufacturing, 16 = Service, 32 = Count | |
Uom | pUom | 5 | |||
CF | xml | -1 | |||
ts | timestamp | 8 |
tblInLoc -- IN Location table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
LocId | pLocID | 10 | |||
Descr | nvarchar | 35 | |||
Addr1 | nvarchar | 30 | |||
Addr2 | nvarchar | 60 | |||
City | nvarchar | 30 | |||
Region | nvarchar | 10 | |||
PostalCode | nvarchar | 10 | |||
Country | pCountry | 6 | |||
Contact | nvarchar | 25 | |||
zzIntlPreFix | nvarchar | 6 | |||
Phone | nvarchar | 15 | |||
Fax | nvarchar | 15 | |||
CarrCostPct | pDecimal | 13 | 0 | ||
OrderCostAmt | pDecimal | 13 | 0 | ||
pEmail | 255 | ||||
Internet | pWeb | 255 | |||
CF | xml | -1 | |||
ts | timestamp | 8 |
tblInMatReqDetail -- IN Material Requisition Detail table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
TransId | int | 4 | |||
LineNum | smallint | 2 | |||
ItemId | pItemID | 24 | |||
LocId | pLocID | 10 | |||
Descr | nvarchar | 35 | |||
UomBase | pUom | 5 | |||
UomSelling | pUom | 5 | |||
ConvFactor | pDecimal | 13 | -1 | ||
ItemType | tinyint | 1 | -1 | Item Type | 1 = Nonserialized, 2 = Serialized, 3 = Service |
GLAcctNum | pGlAcct | 40 | |||
GLDescr | pGLDesc | 30 | |||
QtyReqstd | pDecimal | 13 | -1 | ||
QtyFilled | pDecimal | 13 | -1 | ||
QtyBkord | pDecimal | 13 | 0 | ||
CostUnitStd | pDecimal | 13 | 0 | ||
JOJobId | nvarchar | 10 | |||
JOPhaseId | nvarchar | 10 | |||
JOCostCode | nvarchar | 3 | |||
HistSeqNum | int | 4 | |||
Status | nvarchar | 15 | |||
CustId | pCustID | 10 | |||
ProjId | nvarchar | 10 | |||
PhaseId | nvarchar | 10 | |||
ProjName | nvarchar | 30 | |||
PhaseName | nvarchar | 30 | |||
TaskName | nvarchar | 30 | |||
TaskId | nvarchar | 10 | |||
QtySeqNum | int | 4 | |||
CF | xml | -1 | |||
LineSeq | int | 4 | |||
ts | timestamp | 8 |
tblInMatReqHeader -- IN Material Requisition Header table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
TransId | int | 4 | |||
ReqType | smallint | 2 | -1 | Requisition Type | 1 = Material Req, -1 = Material Req Return |
ReqNum | nvarchar | 10 | |||
DatePlaced | datetime | 8 | getdate() | ||
DateShipped | datetime | 8 | getdate() | ||
DateNeeded | datetime | 8 | getdate() | ||
SumYear | smallint | 2 | 0 | ||
SumPeriod | smallint | 2 | 0 | ||
GLPeriod | smallint | 2 | 0 | ||
LocID | pLocID | 10 | |||
ShipToId | pCustID | 10 | |||
ShipVia | nvarchar | 20 | |||
ReqstdBy | nvarchar | 25 | |||
ReqTotal | pDecimal | 13 | 0 | ||
Notes | text | 16 | |||
CF | xml | -1 | |||
ts | timestamp | 8 |
tblInMatReqLot -- IN Material Requisition Lot table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
TransId | int | 4 | |||
LineNum | smallint | 2 | |||
SeqNum | int | 4 | |||
LotNum | pLotNum | 16 | |||
QtyOrder | pDecimal | 13 | 0 | ||
QtyFilled | pDecimal | 13 | 0 | ||
QtyBkord | pDecimal | 13 | 0 | ||
CostUnit | pDecimal | 13 | 0 | ||
CostUnitFgn | pDecimal | 13 | 0 | ||
HistSeqNum | int | 4 | |||
Cmnt | nvarchar | 35 | |||
QtySeqNum | int | 4 | 0 | ||
CF | xml | -1 | |||
ts | timestamp | 8 |
tblInMatReqSer -- IN Material Requisition Serial Numbers table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
TransId | int | 4 | |||
LineNum | smallint | 2 | |||
SeqNum | int | 4 | |||
LotNum | pLotNum | 16 | |||
SerNum | pSerNum | 35 | |||
CostUnit | pDecimal | 13 | 0 | ||
CostUnitFgn | pDecimal | 13 | 0 | ||
HistSeqNum | int | 4 | |||
Cmnt | nvarchar | 35 | |||
QtySeqNum | int | 4 | 0 | ||
CF | xml | -1 | |||
ts | timestamp | 8 | |||
ExtLocA | int | 4 | |||
ExtLocB | int | 4 | |||
*CostUnitACV | pDecimal | 13 |
tblInPhysCount -- IN Physical Count table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
SeqNum | int | 4 | |||
BatchId | pBatchID | 6 | |||
ItemId | pItemID | 24 | |||
LocId | pLocID | 10 | |||
LotNum | pLotNum | 16 | |||
SerNum | pSerNum | 35 | |||
BinNum | nvarchar | 10 | |||
ExtLocBId | nvarchar | 10 | |||
DfltBinNum | nvarchar | 10 | |||
ProductLine | nvarchar | 12 | |||
UsrFld1 | nvarchar | 12 | |||
UsrFld2 | nvarchar | 12 | |||
QtyFrozen | pDecimal | 13 | 0 | ||
QtyCounted | pDecimal | 13 | 0 | ||
CountedUom | pUom | 5 | |||
CountedUomConvFactor | pDecimal | 13 | -1 | ||
TagNum | int | 4 | |||
VerifyYn | bit | 1 | 0 | ||
CostFrozen | pDecimal | 13 | 0 | ||
CF | xml | -1 | |||
ts | timestamp | 8 | |||
TotalQtyFrozen | pDecimal | 13 | 0 | ||
TotalQtyCounted | pDecimal | 13 | 0 |
tblInPhysCountBatch -- IN Physical Count Batch table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
BatchId | pBatchID | 6 | |||
Descr | nvarchar | 35 | |||
LocIdFrom | pLocID | 10 | |||
LocIdThru | pLocID | 10 | |||
BinNumFrom | nvarchar | 10 | |||
BinNumThru | nvarchar | 10 | |||
ItemIdFrom | pItemID | 24 | |||
ItemIdThru | pItemID | 24 | |||
ProductLineFrom | nvarchar | 12 | |||
ProductLineThru | nvarchar | 12 | |||
UsrFld1From | nvarchar | 12 | |||
UsrFld1Thru | nvarchar | 12 | |||
UsrFld2From | nvarchar | 12 | |||
UsrFld2Thru | nvarchar | 12 | |||
UseTagNumbersYN | bit | 1 | 0 | ||
ZeroQtyTagsYN | bit | 1 | 0 | ||
DisplayFrozenQtyYN | bit | 1 | 0 | ||
DfltCountedQtyYN | bit | 1 | 0 | ||
EnterExceptionOnlyYN | bit | 1 | 0 | ||
EnteredCountYN | bit | 1 | 0 | ||
PrintVarReportYN | bit | 1 | 0 | ||
PrintWorksheetYN | bit | 1 | 0 | ||
PrintTagsYN | bit | 1 | 0 | ||
FreezeDateTime | datetime | 8 | |||
CountDate | datetime | 8 | |||
SumYear | smallint | 2 | 0 | ||
SumPeriod | smallint | 2 | 0 | ||
GLPeriod | smallint | 2 | 0 | ||
LockedYn | int | 4 | 0 | ||
zzEndingSequenceNumber | pDecimal | 13 | |||
PreparedYn | bit | 1 | 0 | ||
RptUom | tinyint | 1 | |||
ABCClassFrom | nvarchar | 10 | |||
ABCClassThru | nvarchar | 10 | |||
CF | xml | -1 | |||
ts | timestamp | 8 |
tblInPhysCountDetail -- IN Physical Count Detail table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
CostFrozen | pDecimal | 13 | |||
CountedUom | pUom | 5 | |||
DtlSeqNum | int | 4 | |||
ExtLocAId | varchar | 10 | |||
ExtLocBId | varchar | 10 | |||
QtyCounted | pDecimal | 13 | |||
QtyFrozen | pDecimal | 13 | |||
SeqNum | int | 4 | |||
SerNum | pSerNum | 35 | |||
TagNum | int | 4 | |||
CF | xml | -1 | |||
ts | timestamp | 8 |
tblInPriceBreaks -- IN Price Breaks table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
SeqNum | int | 4 | |||
BrkId | nvarchar | 10 | |||
BrkQty | pDecimal | 13 | 0 | ||
BrkAdj | pDecimal | 13 | 0 | ||
BrkAdjType | tinyint | 1 | 0 | Break Adjustment Type | 0 = Amount, 1 = Percent |
CF | xml | -1 | |||
ts | timestamp | 8 |
tblInProductLine -- IN Product Line table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
ProductLine | nvarchar | 12 | |||
Descr | nvarchar | 35 | |||
CF | xml | -1 | |||
ts | timestamp | 8 |
tblInQty -- IN Quantity table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
SeqNum | int | 4 | |||
ItemId | char | 24 | |||
LocId | char | 10 | |||
LotNum | char | 16 | |||
TransType | tinyint | 1 | Inventory Quantity Type | 0 = Committed, 1 = In Use, 2 = On Order | |
Qty | pDecimal | 13 | 0 | ||
LinkID | char | 2 | |||
LinkIDSub | char | 8 | |||
LinkIDSubLine | char | 8 |
tblInQty_Ext -- IN Extended Quantity table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
ExtSeqNum | int | 4 | |||
SeqNum | int | 4 | |||
ItemId | char | 24 | |||
LocId | char | 10 | |||
LotNum | char | 16 | |||
ExtLocA | int | 4 | |||
ExtLocB | int | 4 | |||
TransType | tinyint | 1 | |||
Qty | pDecimal | 13 | 0 |
tblInQtyOnHand -- IN On Hand Quantity table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
SeqNum | int | 4 | |||
EntryDate | datetime | 8 | getdate() | ||
EntryID | int | 4 | 0 | ||
ItemId | char | 24 | |||
LocId | char | 10 | |||
LotNum | char | 16 | |||
Source | tinyint | 1 | 0 | Source | 0 = None, 10 = PO Receipt, 11 = IN Receipt, 12 = AP Invoice, 13 = PO Invoice, 14 = IN Invoice Purchase, 15 = Increase, 16 = Transfer To, 17 = Material Req Return, 18 = MP Build Assembly, 19 = Move In, 20 = WM Increase, 21 = WM Transfer To, 22 = WM Material Req Return, 30 = AR Credit, 31 = SO Credit, 32 = IN Credit, 33 = BM Build Assembly, 34 = BM Unbuild Component, 70 = AP Debit, 71 = Return, 72 = IN Debit, 73 = Decrease, 74 = Transfer From, 75 = Material Req, 76 = MP Build Component, 77 = Move Out, 78 = WM Decrease, 79 = WM Transfer From, 80 = AR Invoice, 81 = SO Verify, 82 = SO Invoice, 83 = IN Verify, 84 = IN Invoice Sale, 85 = BM Build Component, 86 = BM Unbuild Assembly, 87 = WM Material Req, 88 = PO Debit |
Qty | pDecimal | 13 | |||
Cost | pDecimal | 13 | |||
InvoicedQty | pDecimal | 13 | 0 | ||
RcptLink | int | 4 | |||
RemoveQty | pDecimal | 13 | 0 | ||
LinkID | char | 8 | |||
LinkIDSub | char | 8 | |||
LinkIDSubLine | int | 4 | |||
PostedYn | bit | 1 | 0 | ||
DeletedYn | bit | 1 | 0 | ||
*CostACV | pDecimal | 13 |
tblInQtyOnHand_Ext -- IN On Hand Quantity Extended table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
ExtSeqNum | int | 4 | |||
ItemId | char | 24 | |||
LocId | char | 10 | |||
LotNum | char | 16 | |||
ExtLocA | int | 4 | |||
ExtLocB | int | 4 | |||
Qty | pDecimal | 13 |
tblInQtyOnHand_Offset -- IN On Hand Quantity Offset table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
SeqNum | int | 4 | |||
GrpID | int | 4 | |||
EntryDate | datetime | 8 | getdate() | ||
Source | tinyint | 1 | 0 | Source | 0 = None, 10 = PO Receipt, 11 = IN Receipt, 12 = AP Invoice, 13 = PO Invoice, 14 = IN Invoice Purchase, 15 = Increase, 16 = Transfer To, 17 = Material Req Return, 18 = MP Build Assembly, 19 = Move In, 20 = WM Increase, 21 = WM Transfer To, 22 = WM Material Req Return, 30 = AR Credit, 31 = SO Credit, 32 = IN Credit, 33 = BM Build Assembly, 34 = BM Unbuild Component, 70 = AP Debit, 71 = Return, 72 = IN Debit, 73 = Decrease, 74 = Transfer From, 75 = Material Req, 76 = MP Build Component, 77 = Move Out, 78 = WM Decrease, 79 = WM Transfer From, 80 = AR Invoice, 81 = SO Verify, 82 = SO Invoice, 83 = IN Verify, 84 = IN Invoice Sale, 85 = BM Build Component, 86 = BM Unbuild Assembly, 87 = WM Material Req, 88 = PO Debit |
Qty | pDecimal | 13 | |||
Cost | pDecimal | 13 | |||
OnHandLink | int | 4 | |||
LinkID | char | 8 | |||
LinkIDSub | char | 8 | |||
LinkIDSubLine | int | 4 | |||
-*CostActual | pDecimal | 13 | 0 | ||
-*CostAdj | pDecimal | 13 | 0 | ||
CostAdjPosted | pDecimal | 13 | 0 | ||
PostedYn | bit | 1 | 0 | ||
DeletedYn | bit | 1 | 0 | ||
*CostACV | pDecimal | 13 | |||
*CostAdjPostedACV | pDecimal | 13 |
tblInSalesCat -- IN Sales Category table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
SalesCat | char | 2 | |||
Descr | nvarchar | 35 | |||
CF | xml | -1 | |||
ts | timestamp | 8 |
tblInShipTo -- IN Ship To table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
ShipToId | pCustID | 10 | |||
ShipToName | nvarchar | 30 | |||
ShipToAddr1 | nvarchar | 30 | |||
ShipToAddr2 | nvarchar | 60 | |||
pEmail | 255 | ||||
Internet | pWeb | 255 | |||
CF | xml | -1 | |||
ts | timestamp | 8 |
tblInSourceType -- IN Source Type table
tblInTrans -- IN Transaction table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
TransId | int | 4 | |||
TransType | tinyint | 1 | Transaction Type | 11 = PO New Order, 12 = PO Goods Received, 14 = PO Invoice, 15 = PO Miscellaneous Debit, 21 = SO New Order, 23 = SO Verified Order, 24 = SO Invoice, 25 = SO Miscellaneous Credit, 31 = Adjustment Increase, 32 = Adjustment Decrease; IncreaseWM = 20; TransferToWM = 21; MaterialReqReturnWM = 22; DecreaseWM = 78; TransferFrom = 79; MaterialReqWM = 87; | |
BatchId | pBatchID | 6 | '######' | ||
ItemId | pItemID | 24 | |||
LocId | pLocID | 10 | |||
TransDate | datetime | 8 | getdate() | ||
Qty | pDecimal | 13 | 0 | ||
Uom | pUom | 5 | |||
ConvFactor | pDecimal | 13 | -1 | ||
CustLevelId | nvarchar | 10 | |||
PriceId | nvarchar | 10 | |||
SumYear | smallint | 2 | 0 | ||
SumPeriod | smallint | 2 | 0 | ||
GLPeriod | smallint | 2 | 0 | ||
PriceUnit | pDecimal | 13 | 0 | ||
CostUnitTrans | pDecimal | 13 | 0 | ||
CostUnitStd | pDecimal | 13 | 0 | ||
CostUnitXfer | pDecimal | 13 | 0 | ||
HistSeqNum | int | 4 | |||
GLAcctOffset | pGlAcct | 40 | |||
PromoId | nvarchar | 10 | |||
Cmnt | nvarchar | 35 | |||
QtySeqNum | int | 4 | 0 | ||
CF | xml | -1 | |||
ts | timestamp | 8 |
tblInTransLot -- IN Lot Transaction table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
TransId | int | 4 | |||
SeqNum | int | 4 | |||
ItemId | pItemID | 24 | |||
LocId | pLocID | 10 | |||
LotNum | pLotNum | 16 | |||
QtyOrder | pDecimal | 13 | 0 | ||
QtyFilled | pDecimal | 13 | 0 | ||
QtyBkord | pDecimal | 13 | 0 | ||
CostUnit | pDecimal | 13 | 0 | ||
CostUnitFgn | pDecimal | 13 | 0 | ||
HistSeqNum | int | 4 | |||
Cmnt | nvarchar | 35 | |||
QtySeqNum | int | 4 | 0 | ||
CF | xml | -1 | |||
ts | timestamp | 8 |
tblInTransSer -- IN Serial Number Transaction table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
TransId | int | 4 | |||
SeqNum | int | 4 | |||
ItemId | pItemID | 24 | |||
LocId | pLocID | 10 | |||
LotNum | pLotNum | 16 | |||
SerNum | pSerNum | 35 | |||
CostUnit | pDecimal | 13 | 0 | ||
CostUnitFgn | pDecimal | 13 | 0 | ||
PriceUnit | pDecimal | 13 | 0 | ||
PriceUnitFgn | pDecimal | 13 | 0 | ||
HistSeqNum | int | 4 | |||
Cmnt | nvarchar | 35 | |||
QtySeqNum | int | 4 | 0 | ||
CF | xml | -1 | |||
ts | timestamp | 8 | |||
ExtLocA | int | 4 | |||
ExtLocB | int | 4 | |||
*CostUnitACV | pDecimal | 13 |
tblInXferLot -- IN Lot Transfer table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
HistSeqNumTo | int | 4 | |||
TransId | int | 4 | |||
SeqNum | int | 4 | |||
ItemId | pItemID | 24 | |||
LocId | pLocID | 10 | |||
LotNumFrom | pLotNum | 16 | |||
LotNumTo | pLotNum | 16 | |||
QtyOrder | pDecimal | 13 | 0 | ||
QtyFilled | pDecimal | 13 | 0 | ||
QtyBkord | pDecimal | 13 | 0 | ||
CostUnit | pDecimal | 13 | 0 | ||
CostXfer | pDecimal | 13 | 0 | ||
HistSeqNum | int | 4 | |||
Cmnt | nvarchar | 35 | |||
QtySeqNumFrom | int | 4 | 0 | ||
QtySeqNumTo | int | 4 | 0 | ||
CF | xml | -1 | |||
ts | timestamp | 8 |
tblInXfers -- IN Transfers table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
TransId | int | 4 | |||
BatchId | pBatchID | 6 | '######' | ||
ItemIdFrom | pItemID | 24 | |||
ItemIdTo | pItemID | 24 | |||
LocIdFrom | pLocID | 10 | |||
LocIdTo | pLocID | 10 | |||
XferDate | datetime | 8 | getdate() | ||
SumYear | smallint | 2 | 0 | ||
SumPeriod | smallint | 2 | 0 | ||
GLPeriod | smallint | 2 | 0 | ||
Qty | pDecimal | 13 | 0 | ||
HistSeqNumFrom | int | 4 | 0 | ||
HistSeqNumTo | int | 4 | 0 | ||
Uom | pUom | 5 | |||
ConvFactor | pDecimal | 13 | -1 | ||
CostUnit | pDecimal | 13 | 0 | ||
CostUnitXfer | pDecimal | 13 | 0 | ||
GLAcctCodeFrom | pGLAcctCode | 2 | |||
GLAcctCodeTo | pGLAcctCode | 2 | |||
Cmnt | nvarchar | 35 | |||
zzCostUnitStd | pDecimal | 13 | 0 | ||
BaseQtyBefore | pDecimal | 13 | 0 | ||
BaseQtyAfter | pDecimal | 13 | 0 | ||
QtySeqNumFrom | int | 4 | 0 | ||
QtySeqNumTo | int | 4 | 0 | ||
CF | xml | -1 | |||
ts | timestamp | 8 |
tblInXferSer -- IN Serial Number Transfer table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
HistSeqNumTo | int | 4 | |||
TransId | int | 4 | |||
SeqNum | int | 4 | |||
ItemId | pItemID | 24 | |||
LocId | pLocID | 10 | |||
LotNumFrom | pLotNum | 16 | |||
LotNumTo | pLotNum | 16 | |||
SerNum | pSerNum | 35 | |||
CostUnit | pDecimal | 13 | 0 | ||
CostXfer | pDecimal | 13 | 0 | ||
PriceUnit | pDecimal | 13 | 0 | ||
HistSeqNum | int | 4 | |||
Cmnt | nvarchar | 35 | |||
QtySeqNumFrom | int | 4 | 0 | ||
QtySeqNumTo | int | 4 | 0 | ||
CF | xml | -1 | |||
ts | timestamp | 8 | |||
ExtLocAFrom | int | 4 | |||
ExtLocBFrom | int | 4 | |||
ExtLocATo | int | 4 | |||
ExtLocBTo | int | 4 | |||
*CostUnitACV | pDecimal | 13 |