Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/gpPayWork
Product: Technical Service Tools (1838)
Series:
Display Name: PM Payment WORK Temp
Physical Name: gpPayWork
Technical Name: gpPM_Payment_WORKSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 BACHNUMB 
Batch Number String STR15_LBAU 15 2 BCHSOURC Batch Source String STR15 15 3 PMNTNMBR Payment Number String STR20_LBAU 20 4 CHEKBKID Checkbook ID String STR15_Checkbook_ID 15 Key to the CM Checkbook Master (CM00100).
Click to show/hide
SELECT
['PM Payment WORK Temp'].CHEKBKID AS 'PM Payment WORK Temp-Checkbook ID'
,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
gpPayWork AS ['PM Payment WORK Temp']
INNER JOIN
CM00100 AS ['CM Checkbook Master']
ON
['PM Payment WORK Temp'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID5 DOCDATE Document Date Date DT 8 6 DOCNUMBR Document Number String STR20_Document_Number 20 7 APPLDAMT Applied Amount Currency DLR17_RBS0_STR$ 17 8 CURTRXAM Current Trx Amount Currency DLR17_RBS0_UTR$ 17 9 CHEKTOTL Check Total Currency DLR19_RBS0_UTR$ 19 10 VENDORID Vendor ID String STR_15_Vendor_ID 15 Key to the PM Vendor Master File (PM00200).
Click to show/hide
SELECT
['PM Payment WORK Temp'].VENDORID AS 'PM Payment WORK Temp-Vendor ID'
,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
gpPayWork AS ['PM Payment WORK Temp']
INNER JOIN
PM00200 AS ['PM Vendor Master File']
ON
['PM Payment WORK Temp'].VENDORID = ['PM Vendor Master File'].VENDORID11 VENDNAME Vendor Name String STR64_Vendor_Name 64 12 COMMENT1 Comment1 String STR30 30 13 ADDRESS1 Address 1 String STR60 60 14 ADDRESS2 Address 2 String STR60 60 15 ADDRESS3 Address 3 String STR60 60 16 CITY City String STR35 35 17 STATE State String STR30_State 29 18 ZIPCODE Zip Code String STR10 10 19 COUNTRY Country String STR60 60 20 VNDCHKNM Vendor Check Name String STR64_Vendor_Name 64 21 SOURCDOC Source Document String STR10_Source_Document 10 Key to the Source Document Master (SY00900).
Click to show/hide
SELECT
['PM Payment WORK Temp'].SOURCDOC AS 'PM Payment WORK Temp-Source Document'
,['Source Document Master'].SOURCDOC AS 'Source Document Master-Source Document'
FROM
gpPayWork AS ['PM Payment WORK Temp']
INNER JOIN
SY00900 AS ['Source Document Master']
ON
['PM Payment WORK Temp'].SOURCDOC = ['Source Document Master'].SOURCDOC22 DISTKNAM Discount Taken Amount Currency DLR17_RBS0_UTR$ 17 23 DISAMTAV Discount Amount Available Currency DLR17_RBS0_UTR$ 17 24 WROFAMNT Write Off Amount Currency DLR17_RBS0_STR$ 17 25 CURNCYID Currency ID String STR15_Currency_ID 15 Key to the Currency Setup (MC40200).
Click to show/hide
SELECT
['PM Payment WORK Temp'].CURNCYID AS 'PM Payment WORK Temp-Currency ID'
,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
gpPayWork AS ['PM Payment WORK Temp']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['PM Payment WORK Temp'].CURNCYID = ['Currency Setup'].CURNCYID26 VOIDED Voided Boolean CB 0 27 REPRNTED Reprinted Integer INT2 2 28 GSTDSAMT GST Discount Amount Currency DLR17_RBS0_STR$ 17 29 PGRAMSBJ Percent Of Gross Amount Subject Integer INT5_RBS2_U% 5 30 PPSTAXRT PPS Tax Rate Integer INT5_%2 5 31 PPSAMDED PPS Amount Deducted Currency DLR17_RBS0_UTR$ 17 32 LDOCRMTC List Documents on Remittance Integer DDL_List_Documents_On_Remittance 0 33 SDORMBY Sort Documents on Remittance By Integer GB 0 34 KEYFIELD Key Field String STR20 20 35 AMWDSNBR Amount in Words and Numbers String STR60 60 36 NOTEINDX Note Index Currency DLR14 14 Key to the Record Notes Master (SY03900).
Click to show/hide
SELECT
['PM Payment WORK Temp'].NOTEINDX AS 'PM Payment WORK Temp-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
gpPayWork AS ['PM Payment WORK Temp']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['PM Payment WORK Temp'].NOTEINDX = ['Record Notes Master'].NOTEINDX37 VCHRNMBR Voucher Number String STR20_LBAU 20 Partial key to the PM Key Master File (PM00400).
Click to show/hide
SELECT
['PM Payment WORK Temp'].VCHRNMBR AS 'PM Payment WORK Temp-Voucher Number'
,['PM Key Master File'].CNTRLNUM AS 'PM Key Master File-Control Number'
FROM
gpPayWork AS ['PM Payment WORK Temp']
INNER JOIN
PM00400 AS ['PM Key Master File']
ON
['PM Payment WORK Temp'].VCHRNMBR = ['PM Key Master File'].CNTRLNUM
AND
['PM Payment WORK Temp'].DOCTYPE = ['PM Key Master File'].DOCTYPE38 CNTRLTYP Control Type Integer INT1 1 39 DOCTYPE Document Type Integer DDL_Document_Type 0 Click to show/hide Document Types
1 Invoice
2 Finance Charge
3 Miscellaneous Charges
4 Return
5 Credit Memo40 MODIFDT Modified Date Date DT 8 41 MDFUSRID Modified User ID String STR15 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['PM Payment WORK Temp'].MDFUSRID AS 'PM Payment WORK Temp-Modified User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
gpPayWork AS ['PM Payment WORK Temp']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['PM Payment WORK Temp'].MDFUSRID = ['Users Master'].USERID42 PSTGSTUS Posting Status Integer INT 0 43 POSTEDDT Posted Date Date DATE 6 44 PTDUSRID Posted User ID String STR15 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['PM Payment WORK Temp'].PTDUSRID AS 'PM Payment WORK Temp-Posted User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
gpPayWork AS ['PM Payment WORK Temp']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['PM Payment WORK Temp'].PTDUSRID = ['Users Master'].USERID45 PMWRKMSG PM WORK Messages Long Integer ML_PM_WORK_Messages 0 46 PMDSTMSG PM Distribution Messages Long Integer ML_PM_Distribution_Messages 0 47 CHKCOMNT Check Comment String STR60 60 48 PSTGDATE Posting Date Date DT 8 49 STRGA255 String A 255 String STR255 255 50 STRGB255 String B 255 String STR255 255 51 SEPRMTNC Seperate Remittance Boolean CB_Seperate_Remittance 0 52 STBOVRFL Stub Overflow Boolean CB 0 53 CTYSTZIP City-State-Zip Code String STR47 47 54 TotDocAmt Total Document Amount Currency DLR19_RBS0_STR$ 19 55 TotAmtPaid Total Amount Paid Currency DLR19_RBS0_UTR$ 19 56 TotCrdAmt Total Credit Amount Currency DLR19_RBS0_UTR$ 19 57 TotalPaidTot Total Paid Total Currency DLR19_RBS0_UTR$ 19 58 TotNegTot Total Negative Total Currency DLR19_RBS0_UTR$ 19 59 TotCrdDocAmt Total Credit Document Amount Currency DLR19_RBS0_UTR$ 19 60 TotTotDocAmt Total Total Document Amount Currency DLR19_RBS0_UTR$ 19 61 TotDiscTknAmt Total Discount Taken Amount Currency DLR19_RBS0_UTR$ 19 62 TotWOAmt Total Write Off Amount Currency DLR19_RBS0_UTR$ 19 63 TotPPSAmtDed Total PPS Amount Deducted Currency DLR19_RBS0_UTR$ 19 64 TotGSTDiscAmt Total GST Discount Amount Currency DLR19_RBS0_UTR$ 19 65 TotDiscTknTot Total Discount Taken Total Currency DLR19_RBS0_UTR$ 19 66 TotWOTot Total Write Off Total Currency DLR19_RBS0_UTR$ 19 67 Outstanding_Amount Outstanding Amount Currency DLR19_RBS0_UTR$ 19 68 Net_Paid_Amount Net Paid Amount Currency DLR19_RBS0_UTR$ 19 69 AMTINWDS Amount in Words Text TX500 500