Checkbook EFT Format Header (CM00103)

azurecurveProductsMicrosoft Dynamics GP (0)FinancialCheckbook EFT Format Header (CM00103)

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
Physical Name: CM00103
Technical Name: cmEFTFormatHdr

Group Display Name: Checkbook Master
Group Technical Name: Checkbook Master

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1EFTFormatID SearchEFT Format IDStringSTR15_EFTFormatID15
2DSCRIPTN SearchDescriptionStringSTR3030
3EFTFormatType SearchEFT Format TypeIntegerEFT_Format_Type0
4EFT_File_Type SearchEFT File TypeIntegerEFT_DDL_File_Type0
5EFTTransferMethod SearchEFT Transfer MethodIntegerEFT_DDL_TransferMethod0
6EFT_AutoSettlement SearchEFT AutoSettlementBooleanEFT_CB_AutoSettlement0
7EFTAddPadBlocks SearchEFT Add Pad BlocksBooleanEFT_CB_AddPadBlocks0
8EFTPadCharacter SearchEFT Pad CharacterStringSTR11
9EFTPadLength SearchEFT Pad LengthIntegerINT3_U03
10EFTMaximumLineLength SearchEFT Maximum Line LengthIntegerINT4_RB_U04
11Number_Of_Lines SearchNumber Of LinesIntegerINT3_U03
12CREATDDT SearchCreated DateDateDT8
13MODIFDT SearchModified DateDateDT8
14NOTEINDX SearchNote IndexCurrencyDLR1414
Key to the Record Notes Master (SY03900).

Click to show/hide

SELECT
       ['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
15SERIES SearchSeriesIntegerDDL_Series0
16MULTIPLE_ADDENDAS SearchMultiple AddendasBooleanCB_Multiple_Addendas0
17EFTDelimitFields SearchEFT Delimit FieldsBooleanCB_EFT_Delimit_Fields0
18EFTDelimiterField SearchEFT Delimiter FieldIntegerGB_EFT_Delimiter_Field0
19EFTDelimiterFieldOther SearchEFT Delimiter Field OtherStringSTR11
20EFTTextQualifier SearchEFT Text QualifierIntegerDDL_EFT_Text_Qualifier0
azurecurveProductsMicrosoft Dynamics GP (0)FinancialCheckbook EFT Format Header (CM00103)

Leave a Reply

Your email address will not be published. Required fields are marked *