Transaction Analysis Codes (DTA10200)

azurecurveProductsMicrosoft Dynamics GP (0)FinancialTransaction Analysis Codes (DTA10200)

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

Product: Microsoft Dynamics GP (0)
Series: Financial

Display Name: Transaction Analysis Codes
Physical Name: DTA10200
Technical Name: DTA_Transaction_Codes_WORK

Group Display Name: Transaction Analysis Table Group
Group Technical Name: DTA_Analysis_Table_Group

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1DTASERIES SearchDTA_SeriesIntegerINT2_U02
2DTAREF SearchDTA_ReferenceStringSTR2525
3ACTINDX SearchAccount IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['Transaction Analysis Codes'].ACTINDX AS 'Transaction Analysis Codes-Account Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       DTA10200 AS ['Transaction Analysis Codes']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Transaction Analysis Codes'].ACTINDX = ['Account Index Master'].ACTINDX
4SEQNUMBR SearchSequence NumberLong IntegerLI_Sequence_Number10
5GROUPID SearchDTA_Group_IDStringSTR15_LBAU15
6CODEID SearchDTA_Code_IDStringSTR15_LBAU15
7DOCNUMBR SearchDocument NumberStringSTR20_Document_Number20
8RMDTYPAL SearchRM Document Type-AllIntegerINT22
Document Type records the type of document.

Click to show/hide the Document Types


0	Balance Carried Forward
1	Sales / Invoice
2	Scheduled Payments
3	Debit Memo
4	Finance Charge
5	Service Repairs
6	Warranties
7	Credit Memo
8	Returns
9	Payments
9POSTDESC SearchDTA_Posting_DescrStringSTR5050
10DTAQNTY SearchDTA_QuantityCurrencyDLR1414
11CODEAMT SearchDTA_AmountCurrencyDLR17_RBS0_STR$17
12TRXDATE SearchTRX DateDateDT_Date6
azurecurveProductsMicrosoft Dynamics GP (0)FinancialTransaction Analysis Codes (DTA10200)

Leave a Reply

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