I was wondering if anyone knew the difference between ShipToNum and MFShipToNum on the ShipDtl table? When you drag both ShipDtl and ShipTo into the BAQ designer it automatically joins on ShipDtl.MFShipToNum = ShipTo.ShipToNum. The descriptions on the field aren’t particularly helpful either. It says MFShipToNum is the ShipToId to be used but then why is MFCustNum not supposed to be used instead of CustNum? And MFCustNum references the “Mark For” but this wouldn’t be relavant unless that feature was being used so why would MFShipToNum be used instead of ShipTo? I’m just a little confused on which fields hold what, and what’s the proper join between ShipDtl and ShipTo. Thanks.
