Invoice table in SNC

[Former Member]

Hi,

In which table in SNC is the invoice data saved e.g. the invoice no, the internal reference number..etc

[Former Member]

Hi Harshad,

PFB Invoice table name.(these tables are client sepcific)

If your client number is 800 then table name will be /1OM/INVO1HDR800

Table Name	Description
/1OM/INVO1HDR<Client Number>	ODM: Order Document Header
/1OM/INVO1NOT<Client Number>	ODM: Note (Extension)
/1OM/INVO1PRA<Client Number>	ODM: Partner (Extension)
/1OM/INVO1PRC<Client Number>	ODM: Partner - Contact Person (Extension)
/1OM/INVO2IT2<Client Number>	ODM: Order Item (Double-Level Document Typ
/1OM/INVO2NOT<Client Number>	ODM: Note (Extension)
/1OM/INVO7MP2<Client Number>	ODM: Mapping (Double-Level Document Type)
/1OM/INVODLI3<Client Number>	Delivery Item Data References
/1OM/INVOHMSG<Client Number>	ODM: Header Data of a Message
/1OM/INVOIVH1<Client Number>	SNC Invoice: Enhancement at Header Level
/1OM/INVOIVI1<Client Number>	SNC Invoice: Enhancement at Item Level
/1OM/INVOIVI2<Client Number>	SNC Invoice: Taxes on Item Level

In table /1OM/INVO7MP2<Client Number> Invoice number is saved.(Order Number)

Regards,

Nikhil

[Former Member]

Hi Nikhil,

Thanks for the reply, I have already tried those tables. But I need the "external reference no" field as shown in the below screen shot. In which table is this field saved.