Telebank Import Header

    API Details

    Property Value
    Endpoint /tablesFinance/telebankImportHeaders
    Table name Telebank Import Header
    Table id 11024480
    Table caption Telebank Import Header
    Data per company True
    Group Finance

    Schema

    erd

    Properties

    Property Table Fieldname Type Max.Length Key Options Table relation Version introduced Version removed Obsolete state Obsolete reason
    id System Id GUID 16
    no No. Code 20 *
    createDate Created Date Date 4
    duplicateCode Duplicate Code Option 4 Unicaat, Duplicaat
    multifileCode Multifile Code Option 4 Geen multifile, Wel multifile
    productCode Product Code Option 4 Produktie, Test met produktiegegevens, Test met gefingeerde posten
    lastCreateDate Previous Creation Date Date 4
    volumeSequenceNo Volume Sequence No. Code 5
    iban IBAN Code 34
    sequenceNo Sequence No. Code 3
    sequenceIndicator Sequence Indicator Code 1
    journalTemplateName Journal Template Name Code 10 Gen. Journal Template
    journalTemplateBatchName Journal Template Batch Name Code 10
    blocked Blocked Boolean 4
    totalNoOfPosts Total No. of Entries Decimal 12
    accountNoBatch Account No. Batch Code 10
    documentNoBankJournal Document No. Bank Journal Code 20
    noSeries No. Series Code 20 No. Series
    typeImportFile Import File Type Option 4 , GMU, SWIFT, CAMT053, SWIFTSEPA
    importBy Import By Code 50
    importDate Import Date Date 4
    lastProcessBy Last Processed By Code 50
    lastProcessDate Last Processed Date Date 4
    noProcessed No. of Times Processed Integer 4
    bankJournal Bank Journal Code 10
    donationCode Donation Code Code 10
    fileName File Name Text 50
    messageIdentifier Message Identifier Text 35
    systemId System ID GUID 16
    systemCreatedAt Created At DateTime 8
    systemCreatedBy Created By GUID 16 User
    systemModifiedAt Modified At DateTime 8
    systemModifiedBy Modified By GUID 16 User
    lastModifiedDateTime Last Modified Date Time DateTime 8