Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/palbInvc
Product: Microsoft Dynamics GP (0)
Series: Sales
Display Name: Lockbox Invoice Work
Physical Name: palbInvc
Technical Name: paRMInvoiceWORKSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 DOCNUMBR 
Document Number String STR20_Document_Number 20 2 SEQNUMBR Sequence Number Long Integer LI_Sequence_Number 10 3 APTODCTY Apply To Document Type Integer DDL_Document_Type 0 4 APTODCNM Apply To Document Number String STR20_Document_Number 20 5 APPTOAMT Apply To Amount Currency DLR17_RBS0_UTR$ 17 6 CUSTNMBR Customer Number String STR15_RM_Customer_Number 15 Key to the RM Customer MSTR (RM00101).
Click to show/hide
SELECT
['Lockbox Invoice Work'].CUSTNMBR AS 'Lockbox Invoice Work-Customer Number'
,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
palbInvc AS ['Lockbox Invoice Work']
INNER JOIN
RM00101 AS ['RM Customer MSTR']
ON
['Lockbox Invoice Work'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR7 CUSTNAME Customer Name String STR64_Customer_Name 64