Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/PP400000
Product: Revenue Expense Deferrals (1045)
Series:
Display Name: Deferral Batch Header
Physical Name: PP400000
Technical Name: PP_Batch_HeadersSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 BCHSOURC 
Batch Source String STR15 15 2 SERIES Series Integer DDL_Series 0 3 BACHNUMB Batch Number String STR15_LBAU 15 4 BCHCOMNT Batch Comment String STR60 60 5 BCHSTTUS Batch Status Integer INT 0 6 MKDTOPST Marked To Post Boolean CB 0 7 NUMOFTRX Number Of TRX Long Integer LI6_U0 6 8 BCHTOTAL Batch Total Currency DLR19_RBS0_STR$ 19 9 CNTRLTRX Control TRX Count Long Integer LI6_U0 6 10 CNTRLTOT Control Total Currency DLR19_RBS0_UTR$ 19 11 NOTEINDX Note Index Currency DLR14 14 Key to the Record Notes Master (SY03900).
Click to show/hide
SELECT
['Deferral Batch Header'].NOTEINDX AS 'Deferral Batch Header-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
PP400000 AS ['Deferral Batch Header']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['Deferral Batch Header'].NOTEINDX = ['Record Notes Master'].NOTEINDX12 CREATDDT Created Date Date DT 8 13 MODIFDT Modified Date Date DT 8 14 USERID User ID String STR15_User_ID 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['Deferral Batch Header'].USERID AS 'Deferral Batch Header-User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
PP400000 AS ['Deferral Batch Header']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['Deferral Batch Header'].USERID = ['Users Master'].USERID15 BCHEMSG1 Batch Error Messages 1 Long Integer ML_Batch_Error_Messages_1 0 16 BCHEMSG2 Batch Error Messages 2 Long Integer ML_Batch_Error_Messages_2 0 17 TRXSORCE TRX Source String STR13 13