How to get value of column ValidToTZId, ValidFromTZId in LogisticsPostalAddress table use X++ ?

(0) Share

Report

Posted on by Community Member

Can everyone help me, how to get value of colunm ValidToTZId, ValidFromTZId in LogisticsPostalAddress use X++

Normally, I create an object of LogisticsPostalAddress , an I can get value of columns in table that use property of table, but with two column ValidToTZId, ValidFromTZId, I can't apply that way

My code like this:

LogisticsPostalAddress logisticsPostalAddress;
LogisticsPostalAddressContract logisticsPostalAddressObj;

// code successfully run
logisticsPostalAddressObj.paramADDRESS(logisticsPostalAddress.Address);
logisticsPostalAddressObj.paramSTATE(logisticsPostalAddress.State);
...

// not find property VALIDTOTZID
logisticsPostalAddressObj.paramVALIDTOTZID();
// not find property VALIDFROMTZID
logisticsPostalAddressObj.paramVALIDFROMTZID();

Moreover, I found that the structure of table LogisticsPostalAddress has column ValidToTZId and ValidFromTZId

Thank you,

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (1)

Suggested answer

Martin Dráb 237,967 Most Valuable Professional on at

Like (0)

Report

These fields are not accessible directly from AX; it's what AX creates under the hood for UTCDateTime fields.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Is there any way to get value of that column, ex: built-in AX or custom method ?

Thank Martin,

Was this reply helpful? Yes No
Mea_ 60,284 on at

Like (0)

Report

Hi Huan Bui,

No, there is not way, as far as I know, but what are you trying to achieve ?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi ievgen Miroshnikov,

I have a requirement that synchronize data between database AX and a other database,

that I create a service in AX to return data of table, full data of every row in table AX, then consume service to push data to database

Thank ievgen,

Was this reply helpful? Yes No
Verified answer

Mea_ 60,284 on at

Like (0)

Report

Please read this msdn article msdn.microsoft.com/.../cc622312.aspx to get details about *TZId fields.

As you may read in that article there is not way to get this values from x++ (except doing direct SQL query), but it says that 2 fields in SQL are represented by one field in AX that stores UTC datetime and time zone id.

Using DateTimeUtil::getOriginatingTimeZone() method you can get time zone id from ValidFrom field and pass it to your method.

Was this reply helpful? Yes No