LogisticsElectronicAddress phone ,fax details:
static void phonefax(Args _args)
{
InventLocation inventLocation;
InventSite inventSite;
LogisticsEntityPostalAddressView logisticsEntityPostalAddressView;
LogisticsLocation logisticsLocation;
LogisticsElectronicAddress logisticsElectronicAddress;
int64 siteid;
select * from inventSite where inventSite.SiteId == "1";
select * from logisticsEntityPostalAddressView where logisticsEntityPostalAddressView.Entity == inventSite.RecId;
// && logisticsEntityPostalAddressView.IsPrimary == NoYes::Yes;
//info(strFmt("%1",logisticsEntityPostalAddressView.Address));
select * from logisticsLocation where logisticsLocation.RecId == logisticsEntityPostalAddressView.Location;
siteid = logisticsLocation.RecId + 1;
while select logisticsElectronicAddress where logisticsElectronicAddress.Location == siteid
&& logisticsElectronicAddress.Type == 1//LogisticsElectronicAddressMethodType::Phone//1
// && logisticsElectronicAddress.IsPrimary == NoYes::No//LogisticsElectronicAddressTypes::Phone
{
info(strFmt("%1 %2 %3",logisticsElectronicAddress.Type,logisticsElectronicAddress.LocatorExtension,logisticsElectronicAddress.Locator));
info("hi");
}
info("bye");
}
{
InventLocation inventLocation;
InventSite inventSite;
LogisticsEntityPostalAddressView logisticsEntityPostalAddressView;
LogisticsLocation logisticsLocation;
LogisticsElectronicAddress logisticsElectronicAddress;
int64 siteid;
select * from inventSite where inventSite.SiteId == "1";
select * from logisticsEntityPostalAddressView where logisticsEntityPostalAddressView.Entity == inventSite.RecId;
// && logisticsEntityPostalAddressView.IsPrimary == NoYes::Yes;
//info(strFmt("%1",logisticsEntityPostalAddressView.Address));
select * from logisticsLocation where logisticsLocation.RecId == logisticsEntityPostalAddressView.Location;
siteid = logisticsLocation.RecId + 1;
while select logisticsElectronicAddress where logisticsElectronicAddress.Location == siteid
&& logisticsElectronicAddress.Type == 1//LogisticsElectronicAddressMethodType::Phone//1
// && logisticsElectronicAddress.IsPrimary == NoYes::No//LogisticsElectronicAddressTypes::Phone
{
info(strFmt("%1 %2 %3",logisticsElectronicAddress.Type,logisticsElectronicAddress.LocatorExtension,logisticsElectronicAddress.Locator));
info("hi");
}
info("bye");
}
No comments:
Post a Comment