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.

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      
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      
Column Name Column Type Length Default Value Description Enumeration
BuyerPlannerID nvarchar 10      
Description pDescription        
CF xml -1      
ts timestamp 8      
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      
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      
Column Name Column Type Length Default Value Description Enumeration
HMRef int 4      
HMCode nvarchar 6      
Descr nvarchar 300      
ts timestamp 8      
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
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      
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      
Column Name Column Type Length Default Value Description Enumeration
ItemId pItemID 24      
AddlDescr text 16      
CF xml -1      
ts timestamp 8      
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      
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      
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      
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      
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      
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      
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      
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      
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      
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      
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      
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      
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      
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    
Email pEmail 255      
Internet pWeb 255      
CF xml -1      
ts timestamp 8      
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      
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      
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      
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      
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    
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      
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      
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      
Column Name Column Type Length Default Value Description Enumeration
ProductLine nvarchar 12      
Descr nvarchar 35      
CF xml -1      
ts timestamp 8      
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      
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    
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      
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      
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      
Column Name Column Type Length Default Value Description Enumeration
SalesCat char 2      
Descr nvarchar 35      
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
ShipToId pCustID 10      
ShipToName nvarchar 30      
ShipToAddr1 nvarchar 30      
ShipToAddr2 nvarchar 60      
Email pEmail 255      
Internet pWeb 255      
CF xml -1      
ts timestamp 8      

tblInSourceType -- IN Source Type 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      
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      
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      
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      
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      
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