AX2012 常用表关系(客户地址,联系信息)
来源:互联网 发布:ntfs for mac 破解 编辑:程序博客网 时间:2024/03/29 22:42
//客户地址信息static void CustAddressInformation(Args _args){ CustTable custTable; DirPartyTable dirPartyTable; DirPartyLocation dirPartyLocation; LogisticsLocation logisticsLocation; LogisticsPostalAddress logisticsPostalAddress; TransDate dateFrom,dateTo; ; dateFrom = dateNull(); dateTo = dateMax(); while select validTimeState(dateFrom,dateTo) custTable where custTable.AccountNum == 'US-027' join dirPartyTable where dirPartyTable.RecId == custTable.Party join dirPartyLocation where dirPartyLocation.Party == dirPartyTable.RecId join logisticsLocation where logisticsLocation.RecId == dirPartyLocation.Location join logisticsPostalAddress where logisticsPostalAddress.Location == logisticsLocation.RecId { print strFmt("ACC:%1,ADD:%2,DES:%3",custTable.AccountNum,logisticsPostalAddress.Address,logisticsLocation.Description); } pause; /* SELECT C.ACCOUNTNUM,LP.ADDRESS AS 'Address',L.DESCRIPTION,lp.RECID,c.RECID FROM CUSTTABLE C JOIN DIRPARTYTABLE D ON D.RECID = C.PARTY JOIN DIRPARTYLOCATION DL ON DL.PARTY = D.RECID JOIN LOGISTICSLOCATION L ON L.RECID = DL.LOCATION JOIN LOGISTICSPOSTALADDRESS LP ON LP.LOCATION = L.RECID WHERE C.DATAAREAID ='LYDI' AND C.ACCOUNTNUM ='US-027' AND LP.VALIDFROM > '2013/4/1' */}客户联系信息
//客户联系信息static void CustContuctInformation(Args _args){ CustTable custTable; DirPartyTable dirPartyTable; ContactPerson contactPerson; DirPerson dirPerson; DirPersonName dirPersonName; LogisticsElectronicAddress logisticsElectronicAddress; DirPartyLocation dirPartyLocation; LogisticsLocation logisticsLocation; LogisticsPostalAddress logisticsPostalAddress; TransDate dateFrom,dateTo; ; //Email select * from custTable join dirPartyTable where dirPartyTable.RecId == custTable.Party join logisticsElectronicAddress where logisticsElectronicAddress.RecId == dirPartyTable.PrimaryContactEmail; //Email select * from custTable join dirPartyTable where dirPartyTable.RecId == custTable.Party join logisticsElectronicAddress where logisticsElectronicAddress.RecId == dirPartyTable.PrimaryContactEmail; //Phone select * from custTable join dirPartyTable where dirPartyTable.RecId == custTable.Party join logisticsElectronicAddress where logisticsElectronicAddress.RecId == dirPartyTable.PrimaryContactPhone; //URL select * from custTable join dirPartyTable where dirPartyTable.RecId == custTable.Party join logisticsElectronicAddress where logisticsElectronicAddress.RecId == dirPartyTable.PrimaryContactURL; //Telex select * from custTable join dirPartyTable where dirPartyTable.RecId == custTable.Party join logisticsElectronicAddress where logisticsElectronicAddress.RecId == dirPartyTable.PrimaryContactTelex; //Fax select * from custTable join dirPartyTable where dirPartyTable.RecId == custTable.Party join logisticsElectronicAddress where logisticsElectronicAddress.RecId == dirPartyTable.PrimaryContactFax; //ContactPerson information select validTimeState(dateFrom,dateTo) custTable where custTable.AccountNum == 'US-027' join contactPerson where contactPerson.CustAccount == custTable.AccountNum join dirPartyTable where dirPartyTable.RecId == contactPerson.Party join dirPerson where dirPerson.RecId == dirPartyTable.RecId join dirPersonName where dirPersonName.Person == dirPerson.RecId join dirPartyLocation where dirPartyLocation.Party == dirPartyTable.RecId join logisticsLocation where logisticsLocation.RecId == dirPartyLocation.Location join logisticsPostalAddress where logisticsPostalAddress.Location == logisticsLocation.RecId; /* SELECT C.ACCOUNTNUM,C.DATAAREAID,L.LOCATOR,L.DESCRIPTION FROM CUSTTABLE C JOIN DIRPARTYTABLE D ON D.RECID = C.PARTY JOIN LOGISTICSELECTRONICADDRESS L ON (L.RECID = D.PRIMARYCONTACTPHONE OR L.RECID = D.PRIMARYCONTACTFAX) WHERE C.DATAAREAID ='LYDI' AND C.ACCOUNTNUM ='US-027' */}
阅读全文
0 0
- AX2012 常用表关系(客户地址,联系信息)
- EBS客户表的联系
- 客户主数据常用表
- 客户主数据常用表
- EBS中客户表的关系
- 客户合作伙伴关系研究
- 客户合作伙伴关系问题
- 客户合作伙伴关系研究
- 客户,用户等常用的表
- Oracle ERP 常用查询:R12客户表
- 取客户IP地址
- TCA客户地址查询
- 数据仓库客户信息整合
- 客户信息获取
- 获取客户信息SQL
- EBS R12客户信息
- 客户信息全SQL
- 更新客户信息
- Sublime Text 3 增加 Open Recent 个数
- Crypto++应用:非对称加密RSA
- dSYM介绍
- MTK codegen.dws文件---GPIO口的定制
- JS去除字符串中空格的方法
- AX2012 常用表关系(客户地址,联系信息)
- 集合之--LinkedList操作
- Android studio 自定义apk打包名称
- linux之旅——关于虚拟内存
- 数据分析两场NBA比赛结果!大数据+NBA=?
- java可变长字符串
- linux动态库与静态库的编译与加载
- 简介Retrofiit
- xxxx.so : text relocations 问题解决方法 (最新)