ATP in Database

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

ATP in Database

Marc von der Brüggen
Hi,

in which table can I find the 'available to promise'-value for products
and product variants in the database?

Thank you very much!


bye
Marc




Reply | Threaded
Open this post in threaded view
|

Re: ATP in Database

Malin Nicolas
Check on InventoryItem entity

Nicolas

Le 14/08/2012 15:19, Marc von der Brüggen a écrit :

> Hi,
>
> in which table can I find the 'available to promise'-value for
> products and product variants in the database?
>
> Thank you very much!
>
>
> bye
> Marc
>
>
>
>


--
Nicolas MALIN
Consultant
Tél : 06.17.66.40.06
Site projet : http://www.neogia.org/
-------
Société LibrenBerry
Tél : 02.48.02.56.12
Site : http://www.librenberry.net/

Tom
Reply | Threaded
Open this post in threaded view
|

Re: ATP in Database

Tom
From postgres info schema
select table_name, column_name from information_schema.columns where column_name like ('%available_to_promise%') order by table_name, column_name;


Table                                                    Column
ebay_product_store_inventory             available_to_promise_listing
inventory_item                                     available_to_promise
inventory_item                                     available_to_promise_total
inventory_item_detail                          available_to_promise_diff
inventory_item_variance                      available_to_promise_var

Tom


________________________________
 From: Nicolas Malin <[hidden email]>
To: [hidden email]
Sent: Tuesday, August 14, 2012 10:02 AM
Subject: Re: ATP in Database
 
Check on InventoryItem entity

Nicolas

Le 14/08/2012 15:19, Marc von der Brüggen a écrit :

> Hi,
>
> in which table can I find the 'available to promise'-value for
> products and product variants in the database?
>
> Thank you very much!
>
>
> bye
> Marc
>
>
>
>


--
Nicolas MALIN
Consultant
Tél : 06.17.66.40.06
Site projet : http://www.neogia.org/
-------
Société LibrenBerry
Tél : 02.48.02.56.12
Site : http://www.librenberry.net/
Reply | Threaded
Open this post in threaded view
|

Re: ATP in Database

Marc von der Brüggen
In reply to this post by Malin Nicolas
Thank you very much!


Am 14.08.2012 16:02, schrieb Nicolas Malin:

> Check on InventoryItem entity
>
> Nicolas
>
> Le 14/08/2012 15:19, Marc von der Brüggen a écrit :
>> Hi,
>>
>> in which table can I find the 'available to promise'-value for
>> products and product variants in the database?
>>
>> Thank you very much!
>>
>>
>> bye
>> Marc
>>
>>
>>
>>
>
>


--
Marc von der Brüggen
Software-Entwickler
   
ZYRES digital media systems GmbH
Eschersheimer Landstr. 5-7 60322 Frankfurt am   Main
Phone +49 (0)69 98 55 99 - 23
Fax   +49 (0)69 98 55 99 - 11

Firmensitz: Eschersheimer Landstr. 5-7 60322 Frankfurt am Main
Registergericht: Amtsgericht Frankfurt am Main, HRB 76374
Geschäftsführer: Sebastian Schirmer

http://www.zyres.com/