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

IN_SpecificPrice

Purpose    

This table records customer specific pricing details for inventory items.

Path        

Inventory Maintenance Prices Form Tab

Name

Type

Linked To

RecID

Text (20)

 

InventoryID

Text (20)

IN_Main.InventoryID

ConnectType

Number (Integer)

0 = Debtor Specific Prices
1 = Debtor Classification Specific Prices

ConnectID

Text (20)

DB_Main.DebtorID
DB_Classification.DebtorClassificationID

Source

Number (Integer)

 

OPMode

Number (Integer)

 

Amount

Number (Float)

 

StartDate

Date/Time

 

EndDate

Date/Time

 

UseQuantityBreak

Bit

 

QuantityBreak

Number (Float)

 

Copyright © 2012 Jiwa Financials. All rights reserved.