PM Payment Stub Duplicate (PM10801)

Easily find this page again using the shortlink:

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 TypeLength
1PMNTNMBR SearchPayment NumberSTR20_LBAUString20
2SEQNUMBR SearchSequence NumberLI_Sequence_NumberLong Integer10
3DSTSQNUM SearchDistribution Sequence NumberLong IntLong Integer8
4DiscTknTot SearchDiscount Taken TotalDLR19_RBS0_STR$Currency19
5NetCkAmt SearchNet Check AmountDLR17_RBS0_STR$Currency17
6PdTot SearchPaid TotalDLR17_RBS0_STR$Currency17
7NegTot SearchNegative TotalDLR17_RBS0_STR$Currency17
8CrdDocAmt SearchCredit Document AmountDLR19_$S2Currency19
9TotDocAmt SearchTotal Document AmountDLR19_RBS0_STR$Currency19
10WrOffTot SearchWrite Off TotalDLR19_RBS0_UTR$Currency19
11CrdtDesc SearchCredit DescriptionSTR30String30
12TRXDSCRN SearchTransaction DescriptionSTR30String30
13PrtOnStb SearchPrint On StubBooleanBoolean0
14APTVCHNM SearchApply To Voucher NumberSTR20_LBAUString20
15DOCNUMBR SearchDocument NumberSTR20_Document_NumberString20
16DOCDATE SearchDocument DateDTDate8
17AMNTPAID SearchAmount PaidDLR17_RBS0_STR$Currency17
18CRDTAMNT SearchCredit AmountDLR19_$S2Currency19
19DocDueDate SearchDocument Due DateDATEDate6
20DOCAMNT SearchDocument AmountDLR19_RBSO_UTR$Currency19
21DISCDATE SearchDiscount DateDTDate8
22DISTKNAM SearchDiscount Taken AmountDLR17_RBS0_UTR$Currency17
23WROFAMNT SearchWrite Off AmountDLR17_RBS0_STR$Currency17
24PPSAMDED SearchPPS Amount DeductedDLR17_RBS0_UTR$Currency17
25GSTDSAMT SearchGST Discount AmountDLR17_RBS0_STR$Currency17
26APFVCHNM SearchApply From Voucher NumberSTR20_LBAUString20
27APFRDCTY SearchApply From Document TypeINT2Integer2
28APTODCTY SearchApply To Document TypeDDL_Document_TypeInteger0
29CURNCYID SearchCurrency IDSTR15_Currency_IDString15
Key to the Currency Setup (MC40200).

Click to show/hide

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

Click to show/hide

       ['PM Payment Stub Duplicate'].VCHRNMBR AS 'PM Payment Stub Duplicate-Voucher Number'
       ,['PM Key Master File'].CNTRLNUM AS 'PM Key Master File-Control Number'
       PM10801 AS ['PM Payment Stub Duplicate']
       PM00400 AS ['PM Key Master File']
                     ['PM Payment Stub Duplicate'].VCHRNMBR = ['PM Key Master File'].CNTRLNUM
                     ['PM Payment Stub Duplicate'].DOCTYPE = ['PM Key Master File'].DOCTYPE
33PONUMBER SearchPO NumberSTR17_POP_NumberString17
34DEX_ROW_ID Searchintint10

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 *