PM Setup File (PM40100)

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

Product: Microsoft Dynamics GP (0)
Series: Purchasing

Display Name: PM Setup File
Physical Name: PM40100
Technical Name: PM_SETP

Group Display Name: Payables Setup Logical File
Group Technical Name: PM_Setup_Logical_File

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1UNIQKEY SearchKeyStringSTR11
2ADUPINNM SearchAllow Duplicate Invoice NumbersIntegerGB0
3OVVCHNUM SearchOverride Voucher NumberBooleanCB_Override_Voucher_NO_at_TRX_Entry0
4TRKDISAV SearchTrack Discounts AvailableBooleanCB_Track_Discounts_Available0
5PRTHATRB SearchPrint Historical Aged Trial BalanceBooleanCB_Print_Historical_Aged_Trial_Balance0
6AGEBY SearchAge ByIntegerGB_Age_By0
7APPLYBY SearchApply ByIntegerGB0
8RMVNDHPW SearchRemove Vendor Holds PasswordStringPassword10
9RMVTRHPW SearchRemove Trx Hold PasswordStringPassword10
10XCDMINPW SearchExceed Max Invoice PasswordStringPassword10
11WROFPSWD SearchWrite Off PasswordStringPassword10
12NTVCHNUM SearchNext Voucher NumberStringSTR17_LBAU17
13PMNPYNBR SearchPM Next Payment NumberStringSTR20_LBAU20
14NXTVNDID SearchNext Temporary Vendor IDStringSTR15_LBU15
15USRDFPR1 SearchUser Defined Prompt 1StringSTR1515
16USRDRPR2 SearchUser Defined Prompt 2StringSTR1515
17PMTRXDSC SearchPM Transaction DescriptionSTR20String20
18PMTRXDSC_1 SearchPM Transaction Description[1]StringSTR2020
19PMTRXDSC_2 SearchPM Transaction Description[2]StringSTR2020
20PMTRXDSC_3 SearchPM Transaction Description[3]StringSTR2020
21PMTRXDSC_4 SearchPM Transaction Description[4]StringSTR2020
22PMTRXDSC_5 SearchPM Transaction Description[5]StringSTR2020
23PMTRXDSC_6 SearchPM Transaction Description[6]StringSTR2020
24PMTRXDSC_7 SearchPM Transaction Description[7]StringSTR2020
25PMTRXDSC_8 SearchPM Transaction Description[8]StringSTR2020
26PMTRXABR_1 SearchPM Transaction Abbreviation[1]StringSTR33
27PMTRXABR_2 SearchPM Transaction Abbreviation[2]StringSTR33
28PMTRXABR SearchPM Transaction AbbreviationSTR3String3
29PMTRXABR_3 SearchPM Transaction Abbreviation[3]StringSTR33
30PMTRXABR_4 SearchPM Transaction Abbreviation[4]StringSTR33
31PMTRXABR_5 SearchPM Transaction Abbreviation[5]StringSTR33
32PMTRXABR_6 SearchPM Transaction Abbreviation[6]StringSTR33
33PMTRXABR_7 SearchPM Transaction Abbreviation[7]StringSTR33
34PMTRXABR_8 SearchPM Transaction Abbreviation[8]StringSTR33
35CHEKBKID SearchCheckbook IDStringSTR15_Checkbook_ID15
Key to the CM Checkbook Master (CM00100).

Click to show/hide

SELECT
       ['PM Setup File'].CHEKBKID AS 'PM Setup File-Checkbook ID'
       ,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
       PM40100 AS ['PM Setup File']
INNER JOIN
       CM00100 AS ['CM Checkbook Master']
              ON
                     ['PM Setup File'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID
36PCHSCHID SearchPurchase Schedule IDStringSTR15_LBAU15
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).

Click to show/hide

SELECT
       ['PM Setup File'].PCHSCHID AS 'PM Setup File-Purchase Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       PM40100 AS ['PM Setup File']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['PM Setup File'].PCHSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
37FRTSCHID SearchFreight Schedule IDStringSTR15_LBAU15
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).

Click to show/hide

SELECT
       ['PM Setup File'].FRTSCHID AS 'PM Setup File-Freight Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       PM40100 AS ['PM Setup File']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['PM Setup File'].FRTSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
38MSCSCHID SearchMisc Schedule IDStringSTR15_LBAU15
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).

Click to show/hide

SELECT
       ['PM Setup File'].MSCSCHID AS 'PM Setup File-Misc Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       PM40100 AS ['PM Setup File']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['PM Setup File'].MSCSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
39LSTYECAL SearchLast Year End CalendarDateDT8
40LSTYEFSC SearchLast Year End FiscalDateDT8
41Check_Format_Default SearchCheck Format DefaultIntegerDDL_Check_Formats0
42Check_Stub_Default SearchCheck Stub DefaultIntegerDDL_List_Documents_On_Remittance0
43PRNTPRVSLYAPPLDDCS SearchPrint Previously Applied DocsBooleanCB_Print_Previously_Applied_Docs0
44DelUPDoc SearchDelete Unposted Printed DocsBooleanCB_Delete_Unposted_Printed_Docs0
45PrntTaxDetDoc SearchPrint Tax Details On DocumentsBooleanCB_Print_Tax_Details0
46DateSensitivitySumView SearchDate Sensitivity Summary ViewIntegerDDL_Date_Sensitivity_Summary_View0
47PRNTDCUR SearchPrint Dual CurrenciesBooleanCB_Print_Dual_Currencies0
48AGEUNAPPLDCR SearchAge Unapplied Credit AmountsBooleanCB_AgeUnappliedCreditAmounts0
49PMNXTSCHDNBR SearchPM Next Schedule NumberStringSTR20_Schedule_Number17
50ExcludeExprdDiscntsPymnt SearchExclude Expired Discounts from PaymentsBooleanCB_ExcludeExpiredDiscountsfromPayments0
51PMDefaultCheckSort SearchPMDefaultCheckSortIntegerPMDefaultCheckSort0
52WarnIfVenHasExistingPO SearchWarn If Vendor Has Existing Purchase OrderBooleanCB_WarnIfVendorHasExistingPO0
53ENBLNGDESC SearchEnable Long DescriptionBooleanCB_LongDescription0

Leave a Reply

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