Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/CM00103
Product: Microsoft Dynamics GP (0)
Series: Financial
Display Name: Checkbook EFT Format Header Group Display Name: Checkbook Master
Physical Name: CM00103
Technical Name: cmEFTFormatHdr
Group Technical Name: Checkbook Master
Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
---|---|---|---|---|---|---|
1 | EFTFormatID | EFT Format ID | String | STR15_EFTFormatID | 15 | |
2 | DSCRIPTN | Description | String | STR30 | 30 | |
3 | EFTFormatType | EFT Format Type | Integer | EFT_Format_Type | 0 | |
4 | EFT_File_Type | EFT File Type | Integer | EFT_DDL_File_Type | 0 | |
5 | EFTTransferMethod | EFT Transfer Method | Integer | EFT_DDL_TransferMethod | 0 | |
6 | EFT_AutoSettlement | EFT AutoSettlement | Boolean | EFT_CB_AutoSettlement | 0 | |
7 | EFTAddPadBlocks | EFT Add Pad Blocks | Boolean | EFT_CB_AddPadBlocks | 0 | |
8 | EFTPadCharacter | EFT Pad Character | String | STR1 | 1 | |
9 | EFTPadLength | EFT Pad Length | Integer | INT3_U0 | 3 | |
10 | EFTMaximumLineLength | EFT Maximum Line Length | Integer | INT4_RB_U0 | 4 | |
11 | Number_Of_Lines | Number Of Lines | Integer | INT3_U0 | 3 | |
12 | CREATDDT | Created Date | Date | DT | 8 | |
13 | MODIFDT | Modified Date | Date | DT | 8 | |
14 | NOTEINDX | Note Index | Currency | DLR14 | 14 | |
Key to the Record Notes Master (SY03900).
Click to show/hideSELECT
['Checkbook EFT Format Header'].NOTEINDX AS 'Checkbook EFT Format Header-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
CM00103 AS ['Checkbook EFT Format Header']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['Checkbook EFT Format Header'].NOTEINDX = ['Record Notes Master'].NOTEINDX | ||||||
15 | SERIES | Series | Integer | DDL_Series | 0 | |
16 | MULTIPLE_ADDENDAS | Multiple Addendas | Boolean | CB_Multiple_Addendas | 0 | |
17 | EFTDelimitFields | EFT Delimit Fields | Boolean | CB_EFT_Delimit_Fields | 0 | |
18 | EFTDelimiterField | EFT Delimiter Field | Integer | GB_EFT_Delimiter_Field | 0 | |
19 | EFTDelimiterFieldOther | EFT Delimiter Field Other | String | STR1 | 1 | |
20 | EFTTextQualifier | EFT Text Qualifier | Integer | DDL_EFT_Text_Qualifier | 0 |