Re: Can anyone Please explain this table

[Jacopo Cappellato]

Hi Kunal,

if I am not wrong:

ITM_SALES_TAX is for tax adjustments for a sales invoice item
PITM_SALES_TAX is for tax adjustments for a purchase invoice item
INV_SALES_TAX  is for tax adjustments for a sales invoice header
PINV_SALES_TAX  is for tax adjustments for a purchase invoice header

Jacopo

On Sep 12, 2008, at 7:17 PM, kunal aggarwal wrote:

Hi all

I have queried table *invoice_item_type* using following query *
*

SELECT invoice_item_type_id, parent_type_id, has_table, description,
    default_gl_account_id, last_updated_stamp, last_updated_tx_stamp,
    created_stamp, created_tx_stamp
FROM invoice_item_type
where
invoice_item_type_id like '%TAX'


I found the following result

*invoice_item_type_id     *                   *    description*

"PINV_SALES_TAX"                            "Sales Tax"
"INV_SALES_TAX"                                sales tax
"ITM_SALES_TAX"                              "Sales Tax"
"PITM_SALES_TAX"                            "Sales Tax"



invoice generation.

However can anyone tell me the purpose of "PINV_SALES_TAX"   and
"INV_SALES_TAX"
types ?


Please reply if anyone have this idea


regards
kunal

I have understood how "ITM_SALES_TAX"and "PITM_SALES_TAX" are used in

smime.p7s
Description: S/MIME cryptographic signature