Skip to main content
Solved

Column Names for Invoice_Item

  • August 11, 2025
  • 1 reply
  • 49 views

Forum|alt.badge.img+1
  • Do Gooder (Customer)
  • 2 replies

Hello,

I am looking to see if there are any column level definitions in any of the IFS documentation for fields like C1, C2 and N1, N2 etc that can be found on tables/views like Invoice_Item_Tab.

I found some defitions for Invoice Header and Invoice_Line under the EDI messages page but nothing for the Invoice Item.

https://ifstestcloud.xxxxxxxxx.com/ifsdoc/documentation/en/default.htm?openpage=https://ifstestcloud.xxxxxxxxx.com/ifsdoc/documentation/en/GeneralIFSApplications/AboutEDIMessages.htm (I replaced our local instance name with xxxxx)

Is there a place where I can find these?

Thank you

Best answer by FleStefSc

It depends on the invoice type. For customer order invoices, you can check out the database view definition of customer_order_inv_item. Here you will find the mapping.

 

 

1 reply

Forum|alt.badge.img+6
  • Do Gooder (Partner)
  • 15 replies
  • Answer
  • August 12, 2025

It depends on the invoice type. For customer order invoices, you can check out the database view definition of customer_order_inv_item. Here you will find the mapping.