MAV PM Distribution (MAV20200)

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

Product: MIS-AMS Extensions (3459)
Series: Purchasing

Display Name: MAV PM Distribution
Physical Name: MAV20200
Technical Name: MAV_PM_Distribution

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1DOCTYPE SearchDocument TypeDDL_Document_TypeInteger20

Click to show/hide Document Types


1	Invoice
2	Finance Charge
3	Miscellaneous Charges
4	Return
5	Credit Memo
2VCHRNMBR SearchVoucher NumberSTR20_LBAUString2220
Partial key to the PM Key Master File (PM00400).

Click to show/hide

SELECT
       ['MAV PM Distribution'].VCHRNMBR AS 'MAV PM Distribution-Voucher Number'
       ,['PM Key Master File'].VCHRNMBR AS 
FROM
       MAV20200 AS ['MAV PM Distribution']
INNER JOIN
       PM00400 AS ['PM Key Master File']
              ON
                     ['MAV PM Distribution'].VCHRNMBR = ['PM Key Master File'].VCHRNMBR
              AND
                     ['MAV PM Distribution'].DOCTYPE = ['PM Key Master File'].DOCTYPE
              AND
                     ['PM Key Master File'].CNTRLTYP = 0
3DSTSQNUM SearchDistribution Sequence NumberLong IntLong Integer48
4CNTRLTYP SearchControl TypeINT1Integer21
5APTVCHNM SearchApply To Voucher NumberSTR20_LBAUString2220
6SPCLDIST SearchSpecialized DistributionINT4Integer24
7DSTINDX SearchDistribution Account IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['MAV PM Distribution'].DSTINDX AS 'MAV PM Distribution-Distribution Account Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       MAV20200 AS ['MAV PM Distribution']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['MAV PM Distribution'].DSTINDX = ['Account Index Master'].ACTINDX
8INTERID SearchIntercompany IDSTR5_IC_IDString65
Key to the Company Master (SY01500).

Click to show/hide

SELECT
       ['MAV PM Distribution'].INTERID AS 'MAV PM Distribution-Intercompany ID'
       ,['Company Master'].INTERID AS 'Company Master-Intercompany ID'
FROM
       MAV20200 AS ['MAV PM Distribution']
INNER JOIN
       DYNAMICS..SY01500 AS ['Company Master']
              ON
                     ['MAV PM Distribution'].INTERID = ['Company Master'].INTERID
9TAXDTLID SearchTax Detail IDSTR15_Tax_Detail_IDString1615
Key to the Sales/Purchases Tax Master (TX00201).

Click to show/hide

SELECT
       ['MAV PM Distribution'].TAXDTLID AS 'MAV PM Distribution-Tax Detail ID'
       ,['Sales/Purchases Tax Master'].TAXDTLID AS 'Sales/Purchases Tax Master-Tax Detail ID'
FROM
       MAV20200 AS ['MAV PM Distribution']
INNER JOIN
       TX00201 AS ['Sales/Purchases Tax Master']
              ON
                     ['MAV PM Distribution'].TAXDTLID = ['Sales/Purchases Tax Master'].TAXDTLID
10MAVTAXID SearchMAV Tax Detail IDSTR15_Tax_Detail_IDString1615
11TOTAMNT SearchMAV Total AmountDLR17_RBS0_UTR$Currency1017
12GRSAMNT SearchMAV Gross AmountDLR17_RBS0_UTR$Currency1017
13GDSAMNT SearchMAV Goods AmountDLR17_RBS0_UTR$Currency1017
14VATAMNT SearchMAV VAT AmountDLR17_RBS0_UTR$Currency1017
15NONREC SearchMAV Non_Recoverable AmountDLR17_RBS0_UTR$Currency1017
16RECVAT SearchMAV_Recoverable_VATCB_MAV_Recoverable_VATBoolean20
17DistRef SearchDistribution ReferenceSTR30String3230
18IVCLINNO SearchInvoice Line NumberLI_Sequence_NumberLong Integer410
19MAVRECNO SearchMAV POP Receipt NumberSTR20_Document_NumberString2220
20MACRECLN SearchMAV Receipt Line NumberLI_Sequence_NumberLong Integer410
21LCLINENUMBER SearchLC Line NumberLI_Sequence_NumberLong Integer410
22MAVACCRIND SearchMAV Accrued Account IndexLI_14Long Integer414
23MAVDISTYP SearchMAV POP Distribution TypeDDLInteger20
24SEQNUMBR SearchSequence NumberLI_Sequence_NumberLong Integer410

Leave a Reply

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