PM Payment Stub Duplicate (PM10801)

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

Product: Microsoft Dynamics GP (0)
Series: Purchasing

Display Name: PM Payment Stub Duplicate
Physical Name: PM10801
Technical Name: PM_Payment_Stub_Duplicate

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1PMNTNMBR SearchPayment NumberSTR20_LBAUString2220
2SEQNUMBR SearchSequence NumberLI_Sequence_NumberLong Integer410
3DSTSQNUM SearchDistribution Sequence NumberLong IntLong Integer48
4DiscTknTot SearchDiscount Taken TotalDLR19_RBS0_STR$Currency1019
5NetCkAmt SearchNet Check AmountDLR17_RBS0_STR$Currency1017
6PdTot SearchPaid TotalDLR17_RBS0_STR$Currency1017
7NegTot SearchNegative TotalDLR17_RBS0_STR$Currency1017
8CrdDocAmt SearchCredit Document AmountDLR19_$S2Currency1019
9TotDocAmt SearchTotal Document AmountDLR19_RBS0_STR$Currency1019
10WrOffTot SearchWrite Off TotalDLR19_RBS0_UTR$Currency1019
11CrdtDesc SearchCredit DescriptionSTR30String3230
12TRXDSCRN SearchTransaction DescriptionSTR30String3230
13PrtOnStb SearchPrint On StubBooleanBoolean20
14APTVCHNM SearchApply To Voucher NumberSTR20_LBAUString2220
15DOCNUMBR SearchDocument NumberSTR20_Document_NumberString2220
16DOCDATE SearchDocument DateDTDate48
17AMNTPAID SearchAmount PaidDLR17_RBS0_STR$Currency1017
18CRDTAMNT SearchCredit AmountDLR19_$S2Currency1019
19DocDueDate SearchDocument Due DateDATEDate46
20DOCAMNT SearchDocument AmountDLR19_RBSO_UTR$Currency1019
21DISCDATE SearchDiscount DateDTDate48
22DISTKNAM SearchDiscount Taken AmountDLR17_RBS0_UTR$Currency1017
23WROFAMNT SearchWrite Off AmountDLR17_RBS0_STR$Currency1017
24PPSAMDED SearchPPS Amount DeductedDLR17_RBS0_UTR$Currency1017
25GSTDSAMT SearchGST Discount AmountDLR17_RBS0_STR$Currency1017
26APFVCHNM SearchApply From Voucher NumberSTR20_LBAUString2220
27APFRDCTY SearchApply From Document TypeINT2Integer22
28APTODCTY SearchApply To Document TypeDDL_Document_TypeInteger20
29CURNCYID SearchCurrency IDSTR15_Currency_IDString1615
Key to the Currency Setup (MC40200).

Click to show/hide

SELECT
       ['PM Payment Stub Duplicate'].CURNCYID AS 'PM Payment Stub Duplicate-Currency ID'
       ,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
       PM10801 AS ['PM Payment Stub Duplicate']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['PM Payment Stub Duplicate'].CURNCYID = ['Currency Setup'].CURNCYID
30Outstanding_Amount SearchOutstanding AmountDLR19_RBS0_UTR$Currency1019
31Net_Paid_Amount SearchNet Paid AmountDLR19_RBS0_UTR$Currency1019
32VCHRNMBR SearchVoucher NumberSTR20_LBAUString2220
Partial key to the PM Key Master File (PM00400).

Click to show/hide

SELECT
       ['PM Payment Stub Duplicate'].VCHRNMBR AS 'PM Payment Stub Duplicate-Voucher Number'
       ,['PM Key Master File'].VCHRNMBR AS 
FROM
       PM10801 AS ['PM Payment Stub Duplicate']
INNER JOIN
       PM00400 AS ['PM Key Master File']
              ON
                     ['PM Payment Stub Duplicate'].VCHRNMBR = ['PM Key Master File'].VCHRNMBR
              AND
                     ['PM Payment Stub Duplicate'].DOCTYPE = ['PM Key Master File'].DOCTYPE
              AND
                     ['PM Key Master File'].CNTRLTYP = 0
33PONUMBER SearchPO NumberSTR17_POP_NumberString1817
34DEX_ROW_ID Searchintint1010

DEX_ROW_ID is an auto-numbered IDENTITY column used internally by Dexterity for lock management; it should not be used by developers to identify any particular piece of information.

Microsoft MVP Mariano Gomez has a good write up on the DEX_ROW_ID column.

Leave a Reply

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