Skip to main content
Answer

ShpVia_Carrier_description

  • October 24, 2023
  • 2 replies
  • 61 views

Forum|alt.badge.img+1

Other than the SOOrder table, what other table(s) contain the ShipVia_Carrier_description? I am modifying the invoice (AR641000) to match what we need for emailing out and one of the fields that needs to be on the form is the Ship Via description. If possible, I would like to not use the SOOrder and feel that if it is on the SOOrder, then it should be somewhere on the ARInvoice, which appears to be not the case. I have combed over the following tables in the hope of finding it rather than mapping additional tables to the form:

Branch, Address, ARTran, Contact, Customer, ARAddress, Terms, Note, EPEmployee, Location, ARInvoice, ARContact, PreferencesGeneral, BAccountNoMask, and CCPayLink which are the standard tables within AR641000.

Best answer by dcomerford

Afraid not the field is not stored on the ARTran or ARInvoice so you would have to join the SOOrder table to get it or else get it from the SOShipment table

2 replies

dcomerford
Captain II
Forum|alt.badge.img+15
  • Captain II
  • Answer
  • October 24, 2023

Afraid not the field is not stored on the ARTran or ARInvoice so you would have to join the SOOrder table to get it or else get it from the SOShipment table


Forum|alt.badge.img+1
  • Author
  • Semi-Pro I
  • October 24, 2023

I thought as much. Thank you for your help.