Can anyone Please explain this table

[kunal aggarwal]

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"


I have understood how   "ITM_SALES_TAX"and "PITM_SALES_TAX"  are used in
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

[BJ Freeman]

you can do the same here
https://demo.hotwaxmedia.com/webtools/control/FindGeneric?entityName=InvoiceItemType&find=true&VIEW_SIZE=50&VIEW_INDEX=0
you can then use the View relationships to find out what Entities uses this
https://demo.hotwaxmedia.com/webtools/control/ViewRelations?entityName=InvoiceItemType
I did a search through the code base and found those in the demo data
so I found this.
https://demo.hotwaxmedia.com/accounting/control/invoiceOverview?invoiceId=demo10001

hope that helps



kunal aggarwal sent the following on 9/12/2008 10:17 AM:

> 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"
>
>
> I have understood how   "ITM_SALES_TAX"and "PITM_SALES_TAX"  are used in
> 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
>

[Jacopo Cappellato-4]

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"
>
>
> I have understood how   "ITM_SALES_TAX"and "PITM_SALES_TAX"  are  
> used in
> 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

[Jacopo Cappellato-4]

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"
>
>
> I have understood how   "ITM_SALES_TAX"and "PITM_SALES_TAX"  are  
> used in
> 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

[kunal aggarwal]

Hi jacopo,

i want to know that how can i apply INV_SALES_TAX on my my orders . whenever
we
make any sales order , then it is always ITM_SALES_TAX is applied and
inserted into the table.
so can you please help me out and tell me how can i make a sales order so
that INV_SALES_TAX will be applied.

regards
kunal


On Sun, Sep 21, 2008 at 1:00 PM, Jacopo Cappellato <
[hidden email]> wrote:

> 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"
>>
>>
>> I have understood how   "ITM_SALES_TAX"and "PITM_SALES_TAX"  are used in
>> 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
>>
>
>

[Jacques Le Roux]

Which table are you speaking about ?

Jacques

From: "kunal aggarwal" <[hidden email]>

> Hi jacopo,
>
> i want to know that how can i apply INV_SALES_TAX on my my orders . whenever
> we
> make any sales order , then it is always ITM_SALES_TAX is applied and
> inserted into the table.
> so can you please help me out and tell me how can i make a sales order so
> that INV_SALES_TAX will be applied.
>
> regards
> kunal
>
>
> On Sun, Sep 21, 2008 at 1:00 PM, Jacopo Cappellato <
> [hidden email]> wrote:
>
>> 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"
>>>
>>>
>>> I have understood how   "ITM_SALES_TAX"and "PITM_SALES_TAX"  are used in
>>> 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
>>>
>>
>>
>

[Scott Gray]

Hi Kunal

That InvoiceItemType doesn't appear to have any support in the system,
what exactly are you trying to achieve?

Regards
Scott

2008/9/23 kunal aggarwal <[hidden email]>:

> Hi jacopo,
>
> i want to know that how can i apply INV_SALES_TAX on my my orders . whenever
> we
> make any sales order , then it is always ITM_SALES_TAX is applied and
> inserted into the table.
> so can you please help me out and tell me how can i make a sales order so
> that INV_SALES_TAX will be applied.
>
> regards
> kunal
>
>
> On Sun, Sep 21, 2008 at 1:00 PM, Jacopo Cappellato <
> [hidden email]> wrote:
>
>> 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"
>>>
>>>
>>> I have understood how   "ITM_SALES_TAX"and "PITM_SALES_TAX"  are used in
>>> 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
>>>
>>
>>
>