Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/MAV20390
Product: MIS-AMS Extensions (3459)
Series: Purchasing
Display Name: MAV POP Distribution
Physical Name: MAV20390
Technical Name: MAV_POP_DistributionSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 POPRCTNM 
POP Receipt Number STR17_POP_Number String 17 2 SEQNUMBR Sequence Number LI_Sequence_Number Long Integer 10 3 IVCLINNO Invoice Line Number LI_Sequence_Number Long Integer 10 4 MAVRECNO MAV POP Receipt Number STR20_Document_Number String 20 5 MACRECLN MAV Receipt Line Number LI_Sequence_Number Long Integer 10 6 LCLINENUMBER LC Line Number LI_Sequence_Number Long Integer 10 7 TAXDTLID Tax Detail ID STR15_Tax_Detail_ID String 15 Key to the Sales/Purchases Tax Master (TX00201).
Click to show/hide
SELECT
['MAV POP Distribution'].TAXDTLID AS 'MAV POP Distribution-Tax Detail ID'
,['Sales/Purchases Tax Master'].TAXDTLID AS 'Sales/Purchases Tax Master-Tax Detail ID'
FROM
MAV20390 AS ['MAV POP Distribution']
INNER JOIN
TX00201 AS ['Sales/Purchases Tax Master']
ON
['MAV POP Distribution'].TAXDTLID = ['Sales/Purchases Tax Master'].TAXDTLID8 MAVTAXID MAV Tax Detail ID STR15_Tax_Detail_ID String 15 9 TOTAMNT MAV Total Amount DLR17_RBS0_UTR$ Currency 17 10 GRSAMNT MAV Gross Amount DLR17_RBS0_UTR$ Currency 17 11 GDSAMNT MAV Goods Amount DLR17_RBS0_UTR$ Currency 17 12 VATAMNT MAV VAT Amount DLR17_RBS0_UTR$ Currency 17 13 NONREC MAV Non_Recoverable Amount DLR17_RBS0_UTR$ Currency 17 14 RECVAT MAV_Recoverable_VAT CB_MAV_Recoverable_VAT Boolean 0 15 DistRef Distribution Reference STR30 String 30 16 ACTINDX Account Index LI_14 Long Integer 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['MAV POP Distribution'].ACTINDX AS 'MAV POP Distribution-Account Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
MAV20390 AS ['MAV POP Distribution']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['MAV POP Distribution'].ACTINDX = ['Account Index Master'].ACTINDX17 MAVACCRIND MAV Accrued Account Index LI_14 Long Integer 14 18 MAVDISTYP MAV POP Distribution Type DDL Integer 0 19 DSTSQNUM Distribution Sequence Number Long Int Long Integer 8