Re: [Openledger-developer] Questions

[Ang T. C. <at...@ew...>]

thanks a lot

Tony Fraser wrote:

>On Wed, 2005-07-27 at 10:05, Ang Tun CHek wrote:
>  
>
>>To All
>>i have few question about sql-ledger
>>
>>1) what is the purpose of status table
>>    
>>
>
>Don't know off hand.
>
>  
>
>>2) what is the price break in customer price matrix
>>    
>>
>
>pricebreak is for quantity pricing. If the customer orders pricebreak or
>more of the part the sellprice will be the one used:
> e.g.
>parts_id  customer_id  pricebreak sellprice
>1003      1001                  0     10.00
>1003      1001                 10      9.50
>
>If customer 1001 orders 9 of part 1003 the price is $10.00 each. If he
>orders 10 (or more) the price is $9.50.
>
> 
>  
>
>>3) what does function  do in IS.pm -> price_matrix
>>    
>>
>
>IS->price_matrix() is where all the SQL and stuff for the partscustomer
>and partsvendor tables are. It summarizes the info into
>$form->{"pricematrix_$x"}. Say using the partscustomer data above an
>invoice is created for customer 1001 and part 1003 is added to line 3.
>IS->price_matrix() would create a $form->{"pricematrix_3"} that contains
>the string "0:10.00 10:9.50".
>
>  
>