Purchase Order Prepayments (POP10170)

azurecurveProductsMicrosoft Dynamics GP (0)PurchasingPurchase Order Prepayments (POP10170)

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

Product: Microsoft Dynamics GP (0)
Series: Purchasing

Display Name: Purchase Order Prepayments
Physical Name: POP10170
Technical Name: popPOPrepaymentWorkHist

Group Display Name: Purchasing Transactions
Group Technical Name: Purchasing Transactions

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1PONUMBER SearchPO NumberSTR17_POP_NumberString1817
2PMNTNMBR SearchPayment NumberSTR20_LBAUString2220
3PrepaymentSource SearchPrepayment SourceGBInteger20
4PYENTTYP SearchPayment Entry TypeGBInteger20

Click to show/hide Payment Entry Type


0	Check
1	Cash
2	Credit Card
5PrepaymentAmount SearchPrepayment AmountDLR19_RBS0_UTR$Currency1019
6OriginatingPrepaymentAmt SearchOriginating Prepayment AmountDLR19_RBS0_UTR$Currency1019
7APPLDAMT SearchApplied AmountDLR17_RBS0_STR$Currency1017
8ORAPPAMT SearchOriginating Applied AmountDLR17_RBS0_STR$Currency1017
9CURTRXAM SearchCurrent Trx AmountDLR17_RBS0_UTR$Currency1017
10ORCTRXAM SearchOriginating Current Trx AmountDLR17_RBS0_UTR$Currency1017
11DISTKNAM SearchDiscount Taken AmountDLR17_RBS0_UTR$Currency1017
12ORDISTKN SearchOriginating Discount Taken AmountDLR17_RBS0_UTR$Currency1017
13CHEKBKID SearchCheckbook IDSTR15_Checkbook_IDString1615
Key to the CM Checkbook Master (CM00100).

Click to show/hide

SELECT
       ['Purchase Order Prepayments'].CHEKBKID AS 'Purchase Order Prepayments-Checkbook ID'
       ,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
       POP10170 AS ['Purchase Order Prepayments']
INNER JOIN
       CM00100 AS ['CM Checkbook Master']
              ON
                     ['Purchase Order Prepayments'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID
14CARDNAME SearchCard NameSTR15_Card_NameString1615
15CHEKNMBR SearchCheck NumberSTR20_Document_NumberString2220
16DOCNUMBR SearchDocument NumberSTR20_Document_NumberString2220
17CNTRLTYP SearchControl TypeINT1Integer21
The Control Type records the type of transaction.

Click to show/hide Control Types

0	Voucher types
1	Payment types
2	Printed alignment forms
18PrepaymentAccountIndex SearchPrepayment Account IndexLI_14Long Integer414
19Cash_Account_Index SearchCash Account IndexLI_14Long Integer414
20PAY_ACCT_IDX SearchAccount Payable Account IndexLI_14Long Integer414
21GLPOSTDT SearchGL Posting DateDTDate48
22BACHNUMB SearchBatch NumberSTR15_LBAUString1615
23BCHSOURC SearchBatch SourceSTR15String1615
Records whether the transaction was entered in a batch or not.

Click to show/hide the Batch Sources

PM_Trxent	Batch
XXPM_Trxent	No batch (real-time)
24TRXSORCE SearchTRX SourceSTR13String1413
25PSTGSTUS SearchPosting StatusINTInteger20
26VOIDED SearchVoidedCBBoolean20
27CURNCYID SearchCurrency IDSTR15_Currency_IDString1615
Key to the Currency Setup (MC40200).

Click to show/hide

SELECT
       ['Purchase Order Prepayments'].CURNCYID AS 'Purchase Order Prepayments-Currency ID'
       ,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
       POP10170 AS ['Purchase Order Prepayments']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['Purchase Order Prepayments'].CURNCYID = ['Currency Setup'].CURNCYID
28CURRNIDX SearchCurrency IndexINT3Integer23
Key to the Currency Setup (MC40200).

Click to show/hide

SELECT
       ['Purchase Order Prepayments'].CURRNIDX AS 'Purchase Order Prepayments-Currency Index'
       ,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
       POP10170 AS ['Purchase Order Prepayments']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['Purchase Order Prepayments'].CURRNIDX = ['Currency Setup'].CURRNIDX
29RATETPID SearchRate Type IDSTR15_Rate_Type_IDString1615
Key to the Multicurrency Rate Type Setup (MC40100).

Click to show/hide

SELECT
       ['Purchase Order Prepayments'].RATETPID AS 'Purchase Order Prepayments-Rate Type ID'
       ,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID'
FROM
       POP10170 AS ['Purchase Order Prepayments']
INNER JOIN
       MC40100 AS ['Multicurrency Rate Type Setup']
              ON
                     ['Purchase Order Prepayments'].RATETPID = ['Multicurrency Rate Type Setup'].RATETPID
30EXGTBLID SearchExchange Table IDSTR15_Exchange_Table_IDString1615
Key to the Multicurrency Exchange Rate Maintenance (MC00100).

Click to show/hide

SELECT
       ['Purchase Order Prepayments'].EXGTBLID AS 'Purchase Order Prepayments-Exchange Table ID'
       ,['Multicurrency Exchange Rate Maintenance'].EXGTBLID AS 'Multicurrency Exchange Rate Maintenance-Exchange Table ID'
FROM
       POP10170 AS ['Purchase Order Prepayments']
INNER JOIN
       DYNAMICS..MC00100 AS ['Multicurrency Exchange Rate Maintenance']
              ON
                     ['Purchase Order Prepayments'].EXGTBLID = ['Multicurrency Exchange Rate Maintenance'].EXGTBLID
31XCHGRATE SearchExchange RateDLR14_Exchange_RateCurrency (Variable)1014
32EXCHDATE SearchExchange DateDT_DateDate46
33TIME1 SearchTimeTM6Time46
34RATECALC SearchRate Calc MethodINTInteger20
Rate Calc Method of the transaction. For non multi-currency transactions, this field will be blank.

Click to show/hide Rate Calc Methods

0	Multiply
1	Divide
35DENXRATE SearchDenomination Exchange RateDLR14_Exchange_RateCurrency (Variable)1014
36MCTRXSTT SearchMC Transaction StateINT1Integer21
MC Transaction State of the transaction. State the transaction was created in. For non multi-currency transactions, this field will be blank.

Click to show/hide MC Transaction States

0	Euro currency is not created or no denomination currencies are enabled.
		1	Originating is not a denomination; Functional is not a denomination
		2	Originating is not a denomination; Functional is the Euro currency.
		3	Originating is not a denomination; Functional is a denomination.
		4	Originating is a denomination; Functional is not a denomination.
		5	Originating is a denomination; Functional is a denomination.
		6	Originating is a denomination; Functional is the Euro currency.
		7	Originating is the Euro currency; Functional is a denomination.
		8	Originating is the Euro currency; Functional is not a denomination.
37DEX_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.

azurecurveProductsMicrosoft Dynamics GP (0)PurchasingPurchase Order Prepayments (POP10170)

Leave a Reply

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