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_DistributionSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 DOCTYPE 
Document Type DDL_Document_Type Integer 0 Click to show/hide Document Types
1 Invoice
2 Finance Charge
3 Miscellaneous Charges
4 Return
5 Credit Memo2 VCHRNMBR Voucher Number STR20_LBAU String 20 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'].DOCTYPE3 DSTSQNUM Distribution Sequence Number Long Int Long Integer 8 4 CNTRLTYP Control Type INT1 Integer 1 5 APTVCHNM Apply To Voucher Number STR20_LBAU String 20 6 SPCLDIST Specialized Distribution INT4 Integer 4 7 DSTINDX Distribution Account Index LI_14 Long Integer 14 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'].ACTINDX8 INTERID Intercompany ID STR5_IC_ID String 5 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'].INTERID9 TAXDTLID Tax Detail ID STR15_Tax_Detail_ID String 15 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'].TAXDTLID10 MAVTAXID MAV Tax Detail ID STR15_Tax_Detail_ID String 15 11 TOTAMNT MAV Total Amount DLR17_RBS0_UTR$ Currency 17 12 GRSAMNT MAV Gross Amount DLR17_RBS0_UTR$ Currency 17 13 GDSAMNT MAV Goods Amount DLR17_RBS0_UTR$ Currency 17 14 VATAMNT MAV VAT Amount DLR17_RBS0_UTR$ Currency 17 15 NONREC MAV Non_Recoverable Amount DLR17_RBS0_UTR$ Currency 17 16 RECVAT MAV_Recoverable_VAT CB_MAV_Recoverable_VAT Boolean 0 17 DistRef Distribution Reference STR30 String 30 18 IVCLINNO Invoice Line Number LI_Sequence_Number Long Integer 10 19 MAVRECNO MAV POP Receipt Number STR20_Document_Number String 20 20 MACRECLN MAV Receipt Line Number LI_Sequence_Number Long Integer 10 21 LCLINENUMBER LC Line Number LI_Sequence_Number Long Integer 10 22 MAVACCRIND MAV Accrued Account Index LI_14 Long Integer 14 23 MAVDISTYP MAV POP Distribution Type DDL Integer 0 24 SEQNUMBR Sequence Number LI_Sequence_Number Long Integer 10