aaSubLedgerDist (AAG20001)

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

Product: Analytical Accounting (3180)
Series: Company

Display Name: aaSubLedgerDist
Physical Name: AAG20001
Technical Name: aaSubLedgerDist

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1aaSubLedgerHdrID SearchaaSubLedgerHdrIDaaLONG_INTLong Integer8
2aaSubLedgerHdrID SearchaaSubLedgerHdrIDLong IntegeraaLONG_INT8
3aaSubLedgerDistID SearchaaSubLedgerDistIDLong IntegeraaLONG_INT8
4aaSubLedgerDistID SearchaaSubLedgerDistIDaaLONG_INTLong Integer8
5INTERID SearchIntercompany IDStringSTR5_IC_ID5
Key to the Company Master (SY01500).

Click to show/hide

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

Click to show/hide

SELECT
       ['aaSubLedgerDist'].INTERID AS 'aaSubLedgerDist-Intercompany ID'
       ,['Company Master'].INTERID AS 'Company Master-Intercompany ID'
FROM
       AAG20001 AS ['aaSubLedgerDist']
INNER JOIN
       DYNAMICS..SY01500 AS ['Company Master']
              ON
                     ['aaSubLedgerDist'].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
       ['aaSubLedgerDist'].ACTINDX AS 'aaSubLedgerDist-Account Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       AAG20001 AS ['aaSubLedgerDist']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['aaSubLedgerDist'].ACTINDX = ['Account Index Master'].ACTINDX
10ACTINDX SearchAccount IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

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

Click to show/hide

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

Click to show/hide

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

Click to show/hide

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

Click to show/hide

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

Click to show/hide

SELECT
       ['aaSubLedgerDist'].RATETPID AS 'aaSubLedgerDist-Rate Type ID'
       ,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID'
FROM
       AAG20001 AS ['aaSubLedgerDist']
INNER JOIN
       MC40100 AS ['Multicurrency Rate Type Setup']
              ON
                     ['aaSubLedgerDist'].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
       ['aaSubLedgerDist'].RATETPID AS 'aaSubLedgerDist-Rate Type ID'
       ,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID'
FROM
       AAG20001 AS ['aaSubLedgerDist']
INNER JOIN
       MC40100 AS ['Multicurrency Rate Type Setup']
              ON
                     ['aaSubLedgerDist'].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
       ['aaSubLedgerDist'].EXGTBLID AS 'aaSubLedgerDist-Exchange Table ID'
       ,['Multicurrency Exchange Rate Maintenance'].EXGTBLID AS 'Multicurrency Exchange Rate Maintenance-Exchange Table ID'
FROM
       AAG20001 AS ['aaSubLedgerDist']
INNER JOIN
       DYNAMICS..MC00100 AS ['Multicurrency Exchange Rate Maintenance']
              ON
                     ['aaSubLedgerDist'].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
       ['aaSubLedgerDist'].EXGTBLID AS 'aaSubLedgerDist-Exchange Table ID'
       ,['Multicurrency Exchange Rate Maintenance'].EXGTBLID AS 'Multicurrency Exchange Rate Maintenance-Exchange Table ID'
FROM
       AAG20001 AS ['aaSubLedgerDist']
INNER JOIN
       DYNAMICS..MC00100 AS ['Multicurrency Exchange Rate Maintenance']
              ON
                     ['aaSubLedgerDist'].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 SearchTimeTM6Time6
40TIME1 SearchTimeTimeTM66
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 StateIntegerINT11
46MCTRXSTT SearchMC Transaction StateINT1Integer1
47SEQNUMBR SearchSequence NumberLI_Sequence_NumberLong Integer10
48SEQNUMBR SearchSequence NumberLong IntegerLI_Sequence_Number10
49GLPOSTDT SearchGL Posting DateDTDate8
50GLPOSTDT SearchGL Posting DateDateDT8
51aaCustID SearchaaCustIDStringSTR15_RM_Customer_Number15
52aaCustID SearchaaCustIDSTR15_RM_Customer_NumberString15
53aaVendID SearchaaVendIDStringSTR15_Vendor_ID15
54aaVendID SearchaaVendIDSTR15_Vendor_IDString15
55aaSiteID SearchaaSiteIDSTR10_Location_CodeString10
56aaSiteID SearchaaSiteIDStringSTR10_Location_Code10
57aaItemID SearchaaItemIDStringSTR30_Item_Number30
58aaItemID SearchaaItemIDSTR30_Item_NumberString30
59EMPLOYID SearchEmployee IDStringSTR15_Employee_ID15
60EMPLOYID SearchEmployee IDSTR15_Employee_IDString15
61aaAssetID SearchaaAssetIDStringSTR2020
62aaAssetID SearchaaAssetIDSTR20String20
63aaBookID SearchaaBookIDStringSTR1515
64aaBookID SearchaaBookIDSTR15String15
65aaCopyStatus SearchaaCopyStatusaaDDLCopyStatusInteger0
66aaCopyStatus SearchaaCopyStatusIntegeraaDDLCopyStatus0
67aaWinWasOpen SearchaaWinWasOpenaaBooleanBoolean0
68aaWinWasOpen SearchaaWinWasOpenBooleanaaBoolean0
69POSTED SearchPostedTrue/FalseBoolean0
70POSTED SearchPostedBooleanTrue/False0
71HISTORY SearchHistoryBooleanCB_History0
72HISTORY SearchHistoryCB_HistoryBoolean0
73aaDistErrors SearchaaDistErrorsaaDistErrorsLong Integer0
74aaDistErrors SearchaaDistErrorsLong IntegeraaDistErrors0
75APTVCHNM SearchApply To Voucher NumberStringSTR20_LBAU20
76APTVCHNM SearchApply To Voucher NumberSTR20_LBAUString20
77APTODCTY SearchApply To Document TypeDDL_Document_TypeInteger0
78APTODCTY SearchApply To Document TypeIntegerDDL_Document_Type0
79aaFutureDist SearchaaFutureDistLong IntegeraaLONG_INT8
80aaFutureDist SearchaaFutureDistaaLONG_INTLong Integer8
81aaOffsetAcct SearchaaOffsetAccountBooleanaaBoolean0
82aaOffsetAcct SearchaaOffsetAccountaaBooleanBoolean0
83ITEMNMBR SearchItem NumberStringSTR30_Item_Number30
Key to the Item Master (IV00101).

Click to show/hide

SELECT
       ['aaSubLedgerDist'].ITEMNMBR AS 'aaSubLedgerDist-Item Number'
       ,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
       AAG20001 AS ['aaSubLedgerDist']
INNER JOIN
       IV00101 AS ['Item Master']
              ON
                     ['aaSubLedgerDist'].ITEMNMBR = ['Item Master'].ITEMNMBR
84ITEMNMBR SearchItem NumberSTR30_Item_NumberString30
Key to the Item Master (IV00101).

Click to show/hide

SELECT
       ['aaSubLedgerDist'].ITEMNMBR AS 'aaSubLedgerDist-Item Number'
       ,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
       AAG20001 AS ['aaSubLedgerDist']
INNER JOIN
       IV00101 AS ['Item Master']
              ON
                     ['aaSubLedgerDist'].ITEMNMBR = ['Item Master'].ITEMNMBR
85TRXLOCTN SearchTRX LocationSTR10_Location_CodeString10
Key to the Site Setup (IV40700).

Click to show/hide

SELECT
       ['aaSubLedgerDist'].TRXLOCTN AS 'aaSubLedgerDist-TRX Location'
       ,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code'
FROM
       AAG20001 AS ['aaSubLedgerDist']
INNER JOIN
       IV40700 AS ['Site Setup']
              ON
                     ['aaSubLedgerDist'].TRXLOCTN = ['Site Setup'].LOCNCODE
86TRXLOCTN SearchTRX LocationStringSTR10_Location_Code10
Key to the Site Setup (IV40700).

Click to show/hide

SELECT
       ['aaSubLedgerDist'].TRXLOCTN AS 'aaSubLedgerDist-TRX Location'
       ,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code'
FROM
       AAG20001 AS ['aaSubLedgerDist']
INNER JOIN
       IV40700 AS ['Site Setup']
              ON
                     ['aaSubLedgerDist'].TRXLOCTN = ['Site Setup'].LOCNCODE
87BINNMBR SearchBin NumberStringSTR2020
88BINNMBR SearchBin NumberSTR20String20
89TRNSTLOC SearchTransfer To LocationSTR10_Location_CodeString10
Key to the Site Setup (IV40700).

Click to show/hide

SELECT
       ['aaSubLedgerDist'].TRNSTLOC AS 'aaSubLedgerDist-Transfer To Location'
       ,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code'
FROM
       AAG20001 AS ['aaSubLedgerDist']
INNER JOIN
       IV40700 AS ['Site Setup']
              ON
                     ['aaSubLedgerDist'].TRNSTLOC = ['Site Setup'].LOCNCODE
90TRNSTLOC SearchTransfer To LocationStringSTR10_Location_Code10
Key to the Site Setup (IV40700).

Click to show/hide

SELECT
       ['aaSubLedgerDist'].TRNSTLOC AS 'aaSubLedgerDist-Transfer To Location'
       ,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code'
FROM
       AAG20001 AS ['aaSubLedgerDist']
INNER JOIN
       IV40700 AS ['Site Setup']
              ON
                     ['aaSubLedgerDist'].TRNSTLOC = ['Site Setup'].LOCNCODE
91TRXQTY SearchTRX QTYCurrencyDLR17_QTY_RBS0_STR17
92TRXQTY SearchTRX QTYDLR17_QTY_RBS0_STRCurrency17
93PYRLRTYP SearchPayroll Record TypeIntegerDDL_Payroll_Record_Type0
94PYRLRTYP SearchPayroll Record TypeDDL_Payroll_Record_TypeInteger0
95TRXNUMBER SearchTRX NumberLI8_U0Long Integer8
96TRXNUMBER SearchTRX NumberLong IntegerLI8_U08
97aaChangeDate SearchaaChangeDateDateaaDATE6
98aaChangeDate SearchaaChangeDateaaDATEDate6
99aaChangeTime SearchaaChangeTimeTimeaaTME6
100aaChangeTime SearchaaChangeTimeaaTMETime6
101DEX_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 *