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 TypeLength
1DOCTYPE SearchDocument TypeDDL_Document_TypeInteger0

Click to show/hide Document Types


1	Invoice
2	Finance Charge
3	Miscellaneous Charges
4	Return
5	Credit Memo
2VCHRNMBR SearchVoucher NumberSTR20_LBAUString20
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'].CNTRLNUM AS 'PM Key Master File-Control Number'
FROM
       MAV20200 AS ['MAV PM Distribution']
INNER JOIN
       PM00400 AS ['PM Key Master File']
              ON
                     ['MAV PM Distribution'].VCHRNMBR = ['PM Key Master File'].CNTRLNUM
              AND
                     ['MAV PM Distribution'].DOCTYPE = ['PM Key Master File'].DOCTYPE
3DSTSQNUM SearchDistribution Sequence NumberLong IntLong Integer8
4CNTRLTYP SearchControl TypeINT1Integer1
5APTVCHNM SearchApply To Voucher NumberSTR20_LBAUString20
6SPCLDIST SearchSpecialized DistributionINT4Integer4
7DSTINDX SearchDistribution Account IndexLI_14Long Integer14
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_IDString5
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_IDString15
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_IDString15
11TOTAMNT SearchMAV Total AmountDLR17_RBS0_UTR$Currency17
12GRSAMNT SearchMAV Gross AmountDLR17_RBS0_UTR$Currency17
13GDSAMNT SearchMAV Goods AmountDLR17_RBS0_UTR$Currency17
14VATAMNT SearchMAV VAT AmountDLR17_RBS0_UTR$Currency17
15NONREC SearchMAV Non_Recoverable AmountDLR17_RBS0_UTR$Currency17
16RECVAT SearchMAV_Recoverable_VATCB_MAV_Recoverable_VATBoolean0
17DistRef SearchDistribution ReferenceSTR30String30
18IVCLINNO SearchInvoice Line NumberLI_Sequence_NumberLong Integer10
19MAVRECNO SearchMAV POP Receipt NumberSTR20_Document_NumberString20
20MACRECLN SearchMAV Receipt Line NumberLI_Sequence_NumberLong Integer10
21LCLINENUMBER SearchLC Line NumberLI_Sequence_NumberLong Integer10
22MAVACCRIND SearchMAV Accrued Account IndexLI_14Long Integer14
23MAVDISTYP SearchMAV POP Distribution TypeDDLInteger0
24SEQNUMBR SearchSequence NumberLI_Sequence_NumberLong Integer10

Leave a Reply

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