You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by kunal aggarwal <ku...@gmail.com> on 2008/09/12 19:17:55 UTC
Can anyone Please explain this table
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
Re: Can anyone Please explain this table
Posted by Scott Gray <le...@gmail.com>.
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 <ku...@gmail.com>:
> 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 <
> jacopo.cappellato@hotwaxmedia.com> 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
>>>
>>
>>
>
Re: Can anyone Please explain this table
Posted by Jacques Le Roux <ja...@les7arts.com>.
Which table are you speaking about ?
Jacques
From: "kunal aggarwal" <ku...@gmail.com>
> 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 <
> jacopo.cappellato@hotwaxmedia.com> 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
>>>
>>
>>
>
Re: Can anyone Please explain this table
Posted by kunal aggarwal <ku...@gmail.com>.
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 <
jacopo.cappellato@hotwaxmedia.com> 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
>>
>
>
Re: Can anyone Please explain this table
Posted by Jacopo Cappellato <ja...@hotwaxmedia.com>.
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
Re: Can anyone Please explain this table
Posted by Jacopo Cappellato <ja...@hotwaxmedia.com>.
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
Re: Can anyone Please explain this table
Posted by BJ Freeman <bj...@free-man.net>.
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
>