a33ik: AX 2012 Number sequence export

[Blog bot]

Источник: http://daxonline.org/1934-ax-2012-nu...ce-export.html
==============

Number sequence code V2
SELECT T1.allowchangedown AS TOALOWERNUMBER, T1.allowchangeup AS TOAHIGHERNUMBER,
T1.blocked AS STOPPED,
T1.cleanataccess AS CLEANUP,
T1.cleaninterval AS INTERVAL,
T1.continuous AS CONTINUOUS,
T1.cyclic AS CYCLICAL,
T1.fetchahead AS PREALLOCATION,
T1.fetchaheadqty AS QUANTITYOFNUMBERS,
T1.format AS FORMAT,
T1.highest AS LARGEST,
T1.inuse AS INUSE,
T1.latestcleandatetime AS DATETIME,
T1.lowest AS SMALLEST,
T1.manual AS MANUAL,
T1.nextrec AS NEXT,
T1.noincrement AS SKIPCOUNTING,
T1.numbersequence AS NUMBERSEQUENCECODE,
T1.numbersequencescope AS NUMBERSEQUENCESCOPERECID,
T1.txt AS NAME,
T1.annotatedformat AS ANNOTATEDFORMAT,
T1.modifiedtransactionid AS MODIFIEDTRANSACTIONID,
T1.recversion AS RECVERSION,
T1.recid AS RECID,
T2.dataarea AS COMPANY,
T2.fiscalcalendarperiod AS FISCALCALENDARPERIOD,
T2.legalentity AS LEGALENTITY,
T2.operatingunit AS OPERATINGUNIT,
T2.recversion AS RECVERSION#2,
T2.recid AS RECID#2,
( Cast (( CASE
WHEN T2.dataarea ''
AND T2.fiscalcalendarperiod 0 THEN 1
WHEN T2.dataarea '' THEN 0
WHEN T2.legalentity 0
AND T2.fiscalcalendarperiod 0 THEN 3
WHEN T2.legalentity 0 THEN 2
WHEN T2.operatingunit 0 THEN 4
ELSE ''
END ) AS INT) ) AS SCOPETYPE
FROM numbersequencetable T1
LEFT OUTER JOIN numbersequencescope T2
ON( ( T1.numbersequencescope = T2.recid )
)


Number sequence references V2


SELECT T1.allowsameas AS REUSENUMBERS, T1.numbersequencedatatype AS NUMBERSEQUENCEDATATYPE,
T1.numbersequenceid AS NUMBERSEQUENCECODERECID,
T1.numbersequencescope AS NUMBERSEQUENCESCOPE,
T1.recversion AS RECVERSION,
T1.recid AS RECID,
T2.recversion AS RECVERSION#2,
T2.recid AS RECID#2,
T4.DATATYPE AS DATATYPE,
T4.REFERENCE AS DATATYPEREFERENCE,
T4.DESCRIPTION AS DATATYPEDESCRIPTION,
T4.recversion AS RECVERSION#4,
T4.recid AS RECID#4,
T5.numbersequencecode AS NUMBERSEQUENCECODE,
T5.recversion AS RECVERSION#5,
T5.recid AS RECID#5,

( Cast (( CASE
WHEN T2.dataarea ''
AND T2.fiscalcalendarperiod 0 THEN 1
WHEN T2.dataarea '' THEN 0
WHEN T2.legalentity 0
AND T2.fiscalcalendarperiod 0 THEN 3
WHEN T2.legalentity 0 THEN 2
WHEN T2.operatingunit 0 THEN 4
ELSE ''
END ) AS INT) ) AS SCOPETYPE
FROM numbersequencereference T1
LEFT OUTER JOIN numbersequencescope T2
ON( ( T1.numbersequencescope = T2.recid )
)
CROSS JOIN ( SELECT T1.configurationkeyid AS ID,
T1.datatypeid AS DATATYPE,
T1.datatypesameasid AS TYPEID,
T1.groupenabled AS GROUP_,
T1.referencehelp AS DESCRIPTION,
T1.referencelabel AS REFERENCE,
T1.scopetype AS SCOPETYPE,
T1.sortfield AS SORTING,
T1.wizardallowchangedown AS TOALOWERNUMBER,
T1.wizardallowchangeup AS TOAHIGHERNUMBER,
T1.wizardcontinuous AS CONTINUOUS,
T1.wizardfetchaheadqty AS QUANTITYOFNUMBERS,
T1.wizardhighest AS HIGHEST,
T1.wizardlowest AS LOWEST,
T1.wizardmanual AS MANUAL,
T1.module AS NUMBERSEQUENCEAREA,
T1.recversion AS RECVERSION,
T1.recid AS RECID
FROM numbersequencedatatype T1) T4
LEFT OUTER JOIN ( SELECT T1.allowchangedown AS TOALOWERNUMBER,
T1.allowchangeup AS TOAHIGHERNUMBER,
T1.blocked AS STOPPED,
T1.cleanataccess AS CLEANUP,
T1.cleaninterval AS INTERVAL,
T1.continuous AS CONTINUOUS,
T1.cyclic AS CYCLICAL,
T1.fetchahead AS PREALLOCATION,
T1.fetchaheadqty AS QUANTITYOFNUMBERS,
T1.format AS FORMAT,
T1.highest AS LARGEST,
T1.inuse AS INUSE,
T1.latestcleandatetime AS DATETIME,
T1.lowest AS SMALLEST,
T1.manual AS MANUAL,
T1.nextrec AS NEXT,
T1.noincrement AS SKIPCOUNTING,
T1.numbersequence AS NUMBERSEQUENCECODE,
T1.numbersequencescope AS NUMBERSEQUENCESCOPERECID,
T1.txt AS NAME,
T1.annotatedformat AS ANNOTATEDFORMAT,
T1.modifiedtransactionid AS MODIFIEDTRANSACTIONID,
T1.recversion AS RECVERSION,
T1.recid AS RECID,
T2.dataarea AS COMPANY,
T2.fiscalcalendarperiod AS FISCALCALENDARPERIOD,
T2.legalentity AS LEGALENTITY,
T2.operatingunit AS OPERATINGUNIT,
T2.recversion AS RECVERSION#2,
T2.recid AS RECID#2,
( Cast (( CASE
WHEN T2.dataarea ''
AND T2.fiscalcalendarperiod 0 THEN 1
WHEN T2.dataarea '' THEN 0
WHEN T2.legalentity 0
AND T2.fiscalcalendarperiod 0 THEN 3
WHEN T2.legalentity 0 THEN 2
WHEN T2.operatingunit 0 THEN 4
ELSE ''
END ) AS INT) ) AS SCOPETYPE
FROM numbersequencetable T1
LEFT OUTER JOIN numbersequencescope T2
ON( ( T1.numbersequencescope = T2.recid )
)
) T5
ON( ( T1.numbersequenceid = T5.recid )
)
WHERE ( ( T1.numbersequencedatatype = T4.recid )
)


Источник: http://daxonline.org/1934-ax-2012-nu...ce-export.html