Wednesday, December 18, 2024

ax - How to find type used for specified Number Sequence ?

Searching for the data type for the sequence Time_6:
select datatypeid from NUMBERSEQUENCEDATATYPE
where
recid = 
  (
    select NUMBERSEQUENCEDATATYPE from NumberSequenceReference
    where
    NUMBERSEQUENCEID =
    (
      select recid from NumberSequencetable
      where
      NUMBERSEQUENCE = 'Time_6'
    )
)
Output:
datatypeid
-----------
8374
Then job in AX:
static void Job8(Args _args)
{
    info( extendedTypeId2name( 8374 ) );
}
Output:

No comments:

Post a Comment