Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/PA13204
Product: Project Accounting (258)
Series:
Display Name: PA Distribution Work File
Physical Name: PA13204
Technical Name: PA_Distribution_WORKSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 PADocnumber20 
PA Document No. String STR17_LBAU 17 2 PABILLTRXT PA Biller Trx Type Integer PA_DDL_Biller_Trx_Type 0 3 DISTTYPE Distribution Type Integer DDL 0 4 SEQNUMBR Sequence Number Long Integer LI_Sequence_Number 10 5 PACOSTCATID PA Cost Category ID String STR15_Cost_Category_ID 15 6 CUSTNMBR Customer Number String STR15_RM_Customer_Number 15 Key to the RM Customer MSTR (RM00101).
Click to show/hide
SELECT
['PA Distribution Work File'].CUSTNMBR AS 'PA Distribution Work File-Customer Number'
,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
PA13204 AS ['PA Distribution Work File']
INNER JOIN
RM00101 AS ['RM Customer MSTR']
ON
['PA Distribution Work File'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR7 DSTINDX Distribution Account Index Long Integer LI_14 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['PA Distribution Work File'].DSTINDX AS 'PA Distribution Work File-Distribution Account Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
PA13204 AS ['PA Distribution Work File']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['PA Distribution Work File'].DSTINDX = ['Account Index Master'].ACTINDX8 DEBITAMT Debit Amount Currency DLR19_$S2 19 9 CRDTAMNT Credit Amount Currency DLR19_$S2 19 10 USERID User ID String STR15_User_ID 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['PA Distribution Work File'].USERID AS 'PA Distribution Work File-User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
PA13204 AS ['PA Distribution Work File']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['PA Distribution Work File'].USERID = ['Users Master'].USERID