Solved

Customer and Supplier Together

  • 31 December 2020
  • 2 replies
  • 144 views

Userlevel 5
Badge +11

I remember the customers and suppliers are in the same table except for info_tab tables.

Anyone remember the name of the table?

icon

Best answer by ShawnBerk 31 December 2020, 15:22

View original

This topic has been closed for comments

2 replies

Userlevel 7
Badge +28

Depends on what you are looking for.  The Header and General tab info are in separate tables.  customer_info and supplier_info, most of the rest of the information is separated as well.  Some Contact, Person, and Comm Method info is combined, but some sub-tabs are separate.  Invoicing information can cross over as well on the identity_invoice_info table.  Payment is similar, but Order tab info is separate.

For whatever view you are looking at, just use the System Info tab to find the Logical Unit info which will allow deriving the table name.

Userlevel 5
Badge +11

Thanks for the information.