What is ValidTo Data field and how to handle it ?

(2) Share

Report

Posted on by Teevo

Hi all,

I'm duplicating Data entity VendVendorsV2, but not changing its structure data source. Currently I'm hit strange error, something like this:

Path: [AxDataEntityView/MyVendorV2Entity/Fields/ValidTo/DataField]:'LogisticsPostalAddressBaseEntity' field not specified.

If I search in the structure and found this table LogisticsPostalAddressBaseEntity are in the sub node of its data source:

With its property is :

But not too sure what to do about it.

Can anyone give me some idea ?

Thanks

I have the same question (0)

All responses (4)

Answers (0)

Andreas Raithel Moderator on at

Like (0)

Report

What is ValidTo Data field and how to handle it ?

Hy,

the LogisticsPostalAddress table holds the current address as well as all historical records.

This means, every address change creates automatically a new line with the changed address and the ValidTo date is set /never/

For the old address line the ValidTo is set to datetime of the change.

So only one address at a time can be the valid one.

Hope this helps.

Was this reply helpful? Yes No
Martin Dráb Most Valuable Professional on at

Like (0)

Report

What is ValidTo Data field and how to handle it ?

Before designing a date-effective data entity, you need to understand date-effective tables. This whitepaper should help. Then you can see the documentation page about date-effictive entities.

Was this reply helpful? Yes No
Teevo on at

Like (0)

Report

What is ValidTo Data field and how to handle it ?

Hi,

Been reading the whitepaper and documentation, unfortunately I cannot understand what it means.

Can I ask for some guidance ? Looking back at the original thread, because I didn't create new entity from scratch but duplicate it, what actually I'm missing and where to check ? In relate to the documentation, I can't find any field with named ValidFrom and ValidTo as per given example.

Thanks.

Was this reply helpful? Yes No
Martin Dráb Most Valuable Professional on at

Like (0)

Report

What is ValidTo Data field and how to handle it ?

The purpose of date-effectivity with addresses is that you may need to know address that was valid at a particular time, e.g. in time of posting. If we simply overwrote the address, we would lose information about the previous address.

Look at LogisticsPostalAddressBaseEntity once more; there indeed are ValidFrom and ValidTo fields.

Was this reply helpful? Yes No