aaGLWorkDist (AAG10001)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/AAG10001

Product: Analytical Accounting (3180)
Series: Company

Display Name: aaGLWorkDist
Physical Name: AAG10001
Technical Name: aaGLWorkDist

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1aaGLWorkHdrID SearchaaGLWorkHdrIDaaLONG_INTLong Integer8
2aaGLWorkHdrID SearchaaGLWorkHdrIDLong IntegeraaLONG_INT8
3aaGLWorkDistID SearchaaGLWorkDistIDaaLONG_INTLong Integer8
4aaGLWorkDistID SearchaaGLWorkDistIDLong IntegeraaLONG_INT8
5INTERID SearchIntercompany IDSTR5_IC_IDString5
Key to the Company Master (SY01500).

Click to show/hide

SELECT
       ['aaGLWorkDist'].INTERID AS 'aaGLWorkDist-Intercompany ID'
       ,['Company Master'].INTERID AS 'Company Master-Intercompany ID'
FROM
       AAG10001 AS ['aaGLWorkDist']
INNER JOIN
       DYNAMICS..SY01500 AS ['Company Master']
              ON
                     ['aaGLWorkDist'].INTERID = ['Company Master'].INTERID
6INTERID SearchIntercompany IDStringSTR5_IC_ID5
Key to the Company Master (SY01500).

Click to show/hide

SELECT
       ['aaGLWorkDist'].INTERID AS 'aaGLWorkDist-Intercompany ID'
       ,['Company Master'].INTERID AS 'Company Master-Intercompany ID'
FROM
       AAG10001 AS ['aaGLWorkDist']
INNER JOIN
       DYNAMICS..SY01500 AS ['Company Master']
              ON
                     ['aaGLWorkDist'].INTERID = ['Company Master'].INTERID
7CorrespondingUnit SearchCorrespondingUnitStringSTR5_IC_ID5
8CorrespondingUnit SearchCorrespondingUnitSTR5_IC_IDString5
9ACTINDX SearchAccount IndexLI_14Long Integer14
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['aaGLWorkDist'].ACTINDX AS 'aaGLWorkDist-Account Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       AAG10001 AS ['aaGLWorkDist']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['aaGLWorkDist'].ACTINDX = ['Account Index Master'].ACTINDX
10ACTINDX SearchAccount IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['aaGLWorkDist'].ACTINDX AS 'aaGLWorkDist-Account Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       AAG10001 AS ['aaGLWorkDist']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['aaGLWorkDist'].ACTINDX = ['Account Index Master'].ACTINDX
11ACCTTYPE SearchAccount TypeIntegerDDL_Account_Type0
12ACCTTYPE SearchAccount TypeDDL_Account_TypeInteger0
13aaBrowseType SearchaaBrowseTypeaaBrowseTypeInteger0
14aaBrowseType SearchaaBrowseTypeIntegeraaBrowseType0
15DECPLACS SearchDecimal PlacesIntegerDDL_Decimal_Places0
16DECPLACS SearchDecimal PlacesDDL_Decimal_PlacesInteger0
17FXDORVAR SearchFixed Or VariableLB_Fixed_Or_VariableInteger0
18FXDORVAR SearchFixed Or VariableIntegerLB_Fixed_Or_Variable0
19DEBITAMT SearchDebit AmountCurrencyDLR19_$S219
20DEBITAMT SearchDebit AmountDLR19_$S2Currency19
21CRDTAMNT SearchCredit AmountCurrencyDLR19_$S219
22CRDTAMNT SearchCredit AmountDLR19_$S2Currency19
23ORDBTAMT SearchOriginating Debit AmountDLR19_$S2Currency19
24ORDBTAMT SearchOriginating Debit AmountCurrencyDLR19_$S219
25ORCRDAMT SearchOriginating Credit AmountCurrencyDLR19_$S219
26ORCRDAMT SearchOriginating Credit AmountDLR19_$S2Currency19
27CURNCYID SearchCurrency IDSTR15_Currency_IDString15
Key to the Currency Setup (MC40200).

Click to show/hide

SELECT
       ['aaGLWorkDist'].CURNCYID AS 'aaGLWorkDist-Currency ID'
       ,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
       AAG10001 AS ['aaGLWorkDist']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['aaGLWorkDist'].CURNCYID = ['Currency Setup'].CURNCYID
28CURNCYID SearchCurrency IDStringSTR15_Currency_ID15
Key to the Currency Setup (MC40200).

Click to show/hide

SELECT
       ['aaGLWorkDist'].CURNCYID AS 'aaGLWorkDist-Currency ID'
       ,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
       AAG10001 AS ['aaGLWorkDist']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['aaGLWorkDist'].CURNCYID = ['Currency Setup'].CURNCYID
29CURRNIDX SearchCurrency IndexIntegerINT33
Key to the Currency Setup (MC40200).

Click to show/hide

SELECT
       ['aaGLWorkDist'].CURRNIDX AS 'aaGLWorkDist-Currency Index'
       ,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
       AAG10001 AS ['aaGLWorkDist']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['aaGLWorkDist'].CURRNIDX = ['Currency Setup'].CURRNIDX
30CURRNIDX SearchCurrency IndexINT3Integer3
Key to the Currency Setup (MC40200).

Click to show/hide

SELECT
       ['aaGLWorkDist'].CURRNIDX AS 'aaGLWorkDist-Currency Index'
       ,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
       AAG10001 AS ['aaGLWorkDist']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['aaGLWorkDist'].CURRNIDX = ['Currency Setup'].CURRNIDX
31RATETPID SearchRate Type IDSTR15_Rate_Type_IDString15
Key to the Multicurrency Rate Type Setup (MC40100).

Click to show/hide

SELECT
       ['aaGLWorkDist'].RATETPID AS 'aaGLWorkDist-Rate Type ID'
       ,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID'
FROM
       AAG10001 AS ['aaGLWorkDist']
INNER JOIN
       MC40100 AS ['Multicurrency Rate Type Setup']
              ON
                     ['aaGLWorkDist'].RATETPID = ['Multicurrency Rate Type Setup'].RATETPID
32RATETPID SearchRate Type IDStringSTR15_Rate_Type_ID15
Key to the Multicurrency Rate Type Setup (MC40100).

Click to show/hide

SELECT
       ['aaGLWorkDist'].RATETPID AS 'aaGLWorkDist-Rate Type ID'
       ,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID'
FROM
       AAG10001 AS ['aaGLWorkDist']
INNER JOIN
       MC40100 AS ['Multicurrency Rate Type Setup']
              ON
                     ['aaGLWorkDist'].RATETPID = ['Multicurrency Rate Type Setup'].RATETPID
33EXGTBLID SearchExchange Table IDStringSTR15_Exchange_Table_ID15
Key to the Multicurrency Exchange Rate Maintenance (MC00100).

Click to show/hide

SELECT
       ['aaGLWorkDist'].EXGTBLID AS 'aaGLWorkDist-Exchange Table ID'
       ,['Multicurrency Exchange Rate Maintenance'].EXGTBLID AS 'Multicurrency Exchange Rate Maintenance-Exchange Table ID'
FROM
       AAG10001 AS ['aaGLWorkDist']
INNER JOIN
       DYNAMICS..MC00100 AS ['Multicurrency Exchange Rate Maintenance']
              ON
                     ['aaGLWorkDist'].EXGTBLID = ['Multicurrency Exchange Rate Maintenance'].EXGTBLID
34EXGTBLID SearchExchange Table IDSTR15_Exchange_Table_IDString15
Key to the Multicurrency Exchange Rate Maintenance (MC00100).

Click to show/hide

SELECT
       ['aaGLWorkDist'].EXGTBLID AS 'aaGLWorkDist-Exchange Table ID'
       ,['Multicurrency Exchange Rate Maintenance'].EXGTBLID AS 'Multicurrency Exchange Rate Maintenance-Exchange Table ID'
FROM
       AAG10001 AS ['aaGLWorkDist']
INNER JOIN
       DYNAMICS..MC00100 AS ['Multicurrency Exchange Rate Maintenance']
              ON
                     ['aaGLWorkDist'].EXGTBLID = ['Multicurrency Exchange Rate Maintenance'].EXGTBLID
35XCHGRATE SearchExchange RateDLR14_Exchange_RateCurrency (Variable)14
36XCHGRATE SearchExchange RateCurrency (Variable)DLR14_Exchange_Rate14
37EXCHDATE SearchExchange DateDT_DateDate6
38EXCHDATE SearchExchange DateDateDT_Date6
39TIME1 SearchTimeTimeTM66
40TIME1 SearchTimeTM6Time6
41RTCLCMTD SearchRate Calculation MethodIntegerGB0
42RTCLCMTD SearchRate Calculation MethodGBInteger0
43DENXRATE SearchDenomination Exchange RateDLR14_Exchange_RateCurrency (Variable)14
44DENXRATE SearchDenomination Exchange RateCurrency (Variable)DLR14_Exchange_Rate14
45MCTRXSTT SearchMC Transaction StateINT1Integer1
46MCTRXSTT SearchMC Transaction StateIntegerINT11
47SQNCLINE SearchSequence LineDLR19_$S2Currency19
48SQNCLINE SearchSequence LineCurrencyDLR19_$S219
49aaCustID SearchaaCustIDStringSTR15_RM_Customer_Number15
50aaCustID SearchaaCustIDSTR15_RM_Customer_NumberString15
51aaVendID SearchaaVendIDStringSTR15_Vendor_ID15
52aaVendID SearchaaVendIDSTR15_Vendor_IDString15
53aaSiteID SearchaaSiteIDSTR10_Location_CodeString10
54aaSiteID SearchaaSiteIDStringSTR10_Location_Code10
55aaItemID SearchaaItemIDSTR30_Item_NumberString30
56aaItemID SearchaaItemIDStringSTR30_Item_Number30
57EMPLOYID SearchEmployee IDSTR15_Employee_IDString15
58EMPLOYID SearchEmployee IDStringSTR15_Employee_ID15
59aaAssetID SearchaaAssetIDStringSTR2020
60aaAssetID SearchaaAssetIDSTR20String20
61aaBookID SearchaaBookIDStringSTR1515
62aaBookID SearchaaBookIDSTR15String15
63aaCopyStatus SearchaaCopyStatusIntegeraaDDLCopyStatus0
64aaCopyStatus SearchaaCopyStatusaaDDLCopyStatusInteger0
65aaWinWasOpen SearchaaWinWasOpenaaBooleanBoolean0
66aaWinWasOpen SearchaaWinWasOpenBooleanaaBoolean0
67aaOFFSETAcct SearchaaOFFSETAcctIntegeraaINT5
68aaOFFSETAcct SearchaaOFFSETAcctaaINTInteger5
69aaDistErrors SearchaaDistErrorsLong IntegeraaDistErrors0
70aaDistErrors SearchaaDistErrorsaaDistErrorsLong Integer0
71aaChangeDate SearchaaChangeDateDateaaDATE6
72aaChangeDate SearchaaChangeDateaaDATEDate6
73aaChangeTime SearchaaChangeTimeaaTMETime6
74aaChangeTime SearchaaChangeTimeTimeaaTME6
75AA_CL_Status SearchAA_CL_StatusBooleanBoolean0
76DEX_ROW_TS Searchdatetimedatetime3
DEX_ROW_TS records the time the record was last changed; often used with integration tools to identify which records have changed and need to be synchronised.
77DEX_ROW_ID Searchintint10

DEX_ROW_ID is an auto-numbered IDENTITY column used internally by Dexterity for lock management; it should not be used by developers to identify any particular piece of information.

Microsoft MVP Mariano Gomez has a good write up on the DEX_ROW_ID column.

Leave a Reply

Your email address will not be published. Required fields are marked *