You are here: Reference Guide > Table Structures > Inventory > IN_SupplierWarehouse

IN_SupplierWarehouse

Purpose    

Records the supplier warehouse details for inventory items - costs, order units and delivery days.

Path       

Inventory Maintenance Supplier Tab

Name

Type

Linked To/Supplied

InvSuppSourceID

Text (20)

 

InvSuppID

Text (20)

IN_Creditor.InvSuppID

InventoryID

Text (20)

IN_Main.InventoryID

WarehouseID

Text (20)

CR_Warehouse.WarehouseID

FreightInID

Text (20)

IN_Freight.FreightInID

OrderUnits

Number (Float)

 

DeliveryDays

Number (Integer)

 

SupplierCost

Number (Float)

 

EstimatedHomeLandedCost

Number (Float)

 

HomeSupplierCost

Number (Float)

 

DutyID

Text (20)

IN_Duty.DutyID

SupplierSOH

float

 

SuppliersCost2

float

 

HomeSuppliersCost2]

Float

 

SpareFloat1

float

 

SpareFloat2

float

 

SpareFloat3

float

 

SpareString1

varchar 255

 

SpareString2

varchar255

 

SpareString3

varchar 255

 

SpareDate1

datetime

 

SpareDate2

datetime

 

SpareDate3

datetime

 

Copyright © 2012 Jiwa Financials. All rights reserved.