MAV POP Distribution (MAV20390)

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_Distribution

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1POPRCTNM SearchPOP Receipt NumberSTR17_POP_NumberString1817
2SEQNUMBR SearchSequence NumberLI_Sequence_NumberLong Integer410
3IVCLINNO SearchInvoice Line NumberLI_Sequence_NumberLong Integer410
4MAVRECNO SearchMAV POP Receipt NumberSTR20_Document_NumberString2220
5MACRECLN SearchMAV Receipt Line NumberLI_Sequence_NumberLong Integer410
6LCLINENUMBER SearchLC Line NumberLI_Sequence_NumberLong Integer410
7TAXDTLID SearchTax Detail IDSTR15_Tax_Detail_IDString1615
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'].TAXDTLID
8MAVTAXID SearchMAV Tax Detail IDSTR15_Tax_Detail_IDString1615
9TOTAMNT SearchMAV Total AmountDLR17_RBS0_UTR$Currency1017
10GRSAMNT SearchMAV Gross AmountDLR17_RBS0_UTR$Currency1017
11GDSAMNT SearchMAV Goods AmountDLR17_RBS0_UTR$Currency1017
12VATAMNT SearchMAV VAT AmountDLR17_RBS0_UTR$Currency1017
13NONREC SearchMAV Non_Recoverable AmountDLR17_RBS0_UTR$Currency1017
14RECVAT SearchMAV_Recoverable_VATCB_MAV_Recoverable_VATBoolean20
15DistRef SearchDistribution ReferenceSTR30String3230
16ACTINDX SearchAccount IndexLI_14Long Integer414
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'].ACTINDX
17MAVACCRIND SearchMAV Accrued Account IndexLI_14Long Integer414
18MAVDISTYP SearchMAV POP Distribution TypeDDLInteger20
19DSTSQNUM SearchDistribution Sequence NumberLong IntLong Integer48

Leave a Reply

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