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

[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 : [phone]
Site projet : http://www.neogia.org/
-------
Société LibrenBerry
Tél : [phone]
Site : http://www.librenberry.net/

[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 : [phone]
Site projet : http://www.neogia.org/
-------
Société LibrenBerry
Tél : [phone]
Site : http://www.librenberry.net/

[Marc von der Brüggen]

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 [phone] - 23
Fax   [phone] - 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/