Class SupaColumn

Holds meta information about a SUPA data column.

Inheritance

object

SupaColumn

Inherited Members

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

object.ReferenceEquals(object, object)

object.ToString()

Namespace: Subsembly.Supa

Assembly: Subsembly.Sepa.dll

Syntax

public class SupaColumn

Constructors

SupaColumn(string, SupaDataType, bool)

Declaration

public SupaColumn(string sName, SupaDataType nDataType = SupaDataType.String, bool fMandatory = false)

Parameters

Type	Name	Description
string	sName
SupaDataType	nDataType
bool	fMandatory

Fields

ACCT_ID

Account ID

Declaration

public const string ACCT_ID = "AcctId"

Field Value

Type	Description
string

AMT

Amount

Declaration

public const string AMT = "Amt"

Field Value

Type	Description
string

AMT_CCY

Amount Currency

Declaration

public const string AMT_CCY = "AmtCcy"

Field Value

Type	Description
string

AMT_PD

Amount Paid

Declaration

public const string AMT_PD = "AmtPd"

Field Value

Type	Description
string

BANK_REF

Bank Reference

Declaration

public const string BANK_REF = "BankRef"

Field Value

Type	Description
string

BK_TX_CD

Bank Transaction Code

Declaration

public const string BK_TX_CD = "BkTxCd"

Field Value

Type	Description
string

BOOKG_DT

Booking Date

Declaration

public const string BOOKG_DT = "BookgDt"

Field Value

Type	Description
string

BOOKG_STS

Booking Status

Declaration

public const string BOOKG_STS = "BookgSts"

Field Value

Type	Description
string

BOOKG_TXT

Booking Text

Declaration

public const string BOOKG_TXT = "BookgTxt"

Field Value

Type	Description
string

BTCH_BOOKG

Batch Booking

Declaration

public const string BTCH_BOOKG = "BtchBookg"

Field Value

Type	Description
string

BTCH_ID

Batch ID

Declaration

public const string BTCH_ID = "BtchId"

Field Value

Type	Description
string

CATEGORY

Category

Declaration

public const string CATEGORY = "Category"

Field Value

Type	Description
string

CATEGORY_DT

Category Date

Declaration

public const string CATEGORY_DT = "CategoryDt"

Field Value

Type	Description
string

CDTR_ID

Creditor ID

Declaration

public const string CDTR_ID = "CdtrId"

Field Value

Type	Description
string

CDT_DBT_IND

Credit Debit Indicator

Declaration

public const string CDT_DBT_IND = "CdtDbtInd"

Field Value

Type	Description
string

CHRGS_ACCT_CCY

Charges Account Currency

Declaration

public const string CHRGS_ACCT_CCY = "ChrgsAcctCcy"

Field Value

Type	Description
string

CHRGS_ACCT_IBAN

Charges Account IBAN

Declaration

public const string CHRGS_ACCT_IBAN = "ChrgsAcctIBAN"

Field Value

Type	Description
string

COST_BEARER

Cost Bearer

Declaration

public const string COST_BEARER = "CostBearer"

Field Value

Type	Description
string

CTGY_PURP_CD

Category Purpose Code

Declaration

public const string CTGY_PURP_CD = "CtgyPurpCd"

Field Value

Type	Description
string

CUST_NB

Customer Number

Declaration

public const string CUST_NB = "CustNb"

Field Value

Type	Description
string

DESC

Description

Declaration

public const string DESC = "Desc"

Field Value

Type	Description
string

DNMTN_CCY

Denomination Currency

Declaration

public const string DNMTN_CCY = "DnmtnCcy"

Field Value

Type	Description
string

DUE_DT

Due Date

Declaration

public const string DUE_DT = "DueDt"

Field Value

Type	Description
string

DUNNING_CHRG

Dunning Charge

Declaration

public const string DUNNING_CHRG = "DunningChrg"

Field Value

Type	Description
string

DUNNING_DT

Dunning Date

Declaration

public const string DUNNING_DT = "DunningDt"

Field Value

Type	Description
string

DUNNING_INTRST

Dunning Interest

Declaration

public const string DUNNING_INTRST = "DunningIntrst"

Field Value

Type	Description
string

DUNNING_LVL

Dunning Level

Declaration

public const string DUNNING_LVL = "DunningLvl"

Field Value

Type	Description
string

END_TO_END_ID

End-to-End ID

Declaration

public const string END_TO_END_ID = "EndToEndId"

Field Value

Type	Description
string

FLAG

Flag

Declaration

public const string FLAG = "Flag"

Field Value

Type	Description
string

GVC

GVC

Declaration

public const string GVC = "GVC"

Field Value

Type	Description
string

GVC_EXTENSION

GVC Extension

Declaration

public const string GVC_EXTENSION = "GVCExtension"

Field Value

Type	Description
string

ID

ID

Declaration

public const string ID = "Id"

Field Value

Type	Description
string

INSTD_AMT

Instructed Amount

Declaration

public const string INSTD_AMT = "InstdAmt"

Field Value

Type	Description
string

INSTD_AMT_CCY

Instructed Amount Currency

Declaration

public const string INSTD_AMT_CCY = "InstdAmtCcy"

Field Value

Type	Description
string

INSTR_FOR_DBTR_AGT_INF

Instruction for Debtor Agent.

Declaration

public const string INSTR_FOR_DBTR_AGT_INF = "InstrForDbtrAgtInf"

Field Value

Type	Description
string

INTRST_RATE

Interest Rate

Declaration

public const string INTRST_RATE = "IntrstRate"

Field Value

Type	Description
string

INVC_DT

Invoice Date

Declaration

public const string INVC_DT = "InvcDt"

Field Value

Type	Description
string

INVC_NB

Invoice Number

Declaration

public const string INVC_NB = "InvcNb"

Field Value

Type	Description
string

INVC_NM

Invoicer/Invoicee Name

Declaration

public const string INVC_NM = "InvcNm"

Field Value

Type	Description
string

INVC_STS

Invoice Status

Declaration

public const string INVC_STS = "InvcSts"

Field Value

Type	Description
string

INVC_TP

Invoice Type

Declaration

public const string INVC_TP = "InvcTp"

Field Value

Type	Description
string

ISIN

ISIN

Declaration

public const string ISIN = "ISIN"

Field Value

Type	Description
string

LCL_INSTRM

Local Instrument

Declaration

public const string LCL_INSTRM = "LclInstrm"

Field Value

Type	Description
string

MNDT_DT_OF_SGNTR

Mandate Date of Signature

Declaration

public const string MNDT_DT_OF_SGNTR = "MndtDtOfSgntr"

Field Value

Type	Description
string

MNDT_ID

Mandate ID

Declaration

public const string MNDT_ID = "MndtId"

Field Value

Type	Description
string

MNDT_LCL_INSTRM

Mandate Local Instrument

Declaration

public const string MNDT_LCL_INSTRM = "MndtLclInstrm"

Field Value

Type	Description
string

MTRTY_DT

Maturity Date

Declaration

public const string MTRTY_DT = "MtrtyDt"

Field Value

Type	Description
string

NOTES

Notes

Declaration

public const string NOTES = "Notes"

Field Value

Type	Description
string

OWNR_ACCT_BANK_CODE

Owner Account Bank Code

Declaration

public const string OWNR_ACCT_BANK_CODE = "OwnrAcctBankCode"

Field Value

Type	Description
string

OWNR_ACCT_BIC

Owner Account BIC

Declaration

public const string OWNR_ACCT_BIC = "OwnrAcctBIC"

Field Value

Type	Description
string

OWNR_ACCT_CCY

Owner Account Currency

Declaration

public const string OWNR_ACCT_CCY = "OwnrAcctCcy"

Field Value

Type	Description
string

OWNR_ACCT_CTRY

Owner Account Country

Declaration

public const string OWNR_ACCT_CTRY = "OwnrAcctCtry"

Field Value

Type	Description
string

OWNR_ACCT_IBAN

Owner Account IBAN

Declaration

public const string OWNR_ACCT_IBAN = "OwnrAcctIBAN"

Field Value

Type	Description
string

OWNR_ACCT_NO

Owner Account Number

Declaration

public const string OWNR_ACCT_NO = "OwnrAcctNo"

Field Value

Type	Description
string

OWNR_NM

Owner Name

Declaration

public const string OWNR_NM = "OwnrNm"

Field Value

Type	Description
string

PMT_INF_ID

Payment Information ID

Declaration

public const string PMT_INF_ID = "PmtInfId"

Field Value

Type	Description
string

PMT_MTD

Payment Method

Declaration

public const string PMT_MTD = "PmtMtd"

Field Value

Type	Description
string

PRIC_CUR

Price Current

Declaration

public const string PRIC_CUR = "PricCur"

Field Value

Type	Description
string

PRIC_CUR_CCY

Price Current Currency

Declaration

public const string PRIC_CUR_CCY = "PricCurCcy"

Field Value

Type	Description
string

PRIC_CUR_DT

Price Current Date

Declaration

public const string PRIC_CUR_DT = "PricCurDt"

Field Value

Type	Description
string

PRIC_INVST

Price Invested

Declaration

public const string PRIC_INVST = "PricInvst"

Field Value

Type	Description
string

PRIC_INVST_CCY

Price Invested Currency

Declaration

public const string PRIC_INVST_CCY = "PricInvstCcy"

Field Value

Type	Description
string

PRIC_INVST_DT

Price Invested Date

Declaration

public const string PRIC_INVST_DT = "PricInvstDt"

Field Value

Type	Description
string

PRIC_TP

Price Type

Declaration

public const string PRIC_TP = "PricTp"

Field Value

Type	Description
string

PRIMA_NOTA_NO

Prima Nota Number

Declaration

public const string PRIMA_NOTA_NO = "PrimaNotaNo"

Field Value

Type	Description
string

PURP_CD

Purpose Code

Declaration

public const string PURP_CD = "PurpCd"

Field Value

Type	Description
string

QTY

Quantity

Declaration

public const string QTY = "Qty"

Field Value

Type	Description
string

READ_STATUS

Read Status

Declaration

public const string READ_STATUS = "ReadStatus"

Field Value

Type	Description
string

REQD_EXCTN_DT

Requested Execution Date

Declaration

public const string REQD_EXCTN_DT = "ReqdExctnDt"

Field Value

Type	Description
string

REQD_EXCTN_DT_TM

Requested Execution Date and Time

Declaration

public const string REQD_EXCTN_DT_TM = "ReqdExctnDtTm"

Field Value

Type	Description
string

RMTD_ACCT_BANK_ADR_LINE1

Remitted Account Bank Address Line 1, aka. Street Name and Building Number

Declaration

public const string RMTD_ACCT_BANK_ADR_LINE1 = "RmtdAcctBankAdrLine1"

Field Value

Type	Description
string

RMTD_ACCT_BANK_ADR_LINE2

Remitted Account Bank Address Line 2, aka. Postcode and Town Name

Declaration

public const string RMTD_ACCT_BANK_ADR_LINE2 = "RmtdAcctBankAdrLine2"

Field Value

Type	Description
string

RMTD_ACCT_BANK_CODE

Remitted Account Bank Code

Declaration

public const string RMTD_ACCT_BANK_CODE = "RmtdAcctBankCode"

Field Value

Type	Description
string

RMTD_ACCT_BANK_CTRY

Remitted Account Bank Address

Declaration

public const string RMTD_ACCT_BANK_CTRY = "RmtdAcctBankCtry"

Field Value

Type	Description
string

RMTD_ACCT_BANK_NAME

Remitted Account Bank Name

Declaration

public const string RMTD_ACCT_BANK_NAME = "RmtdAcctBankName"

Field Value

Type	Description
string

RMTD_ACCT_BIC

Remitted Account BIC

Declaration

public const string RMTD_ACCT_BIC = "RmtdAcctBIC"

Field Value

Type	Description
string

RMTD_ACCT_CTRY

Remitted Account Country

Declaration

public const string RMTD_ACCT_CTRY = "RmtdAcctCtry"

Field Value

Type	Description
string

RMTD_ACCT_IBAN

Remitted Account IBAN

Declaration

public const string RMTD_ACCT_IBAN = "RmtdAcctIBAN"

Field Value

Type	Description
string

RMTD_ACCT_NO

Remitted Account Number

Declaration

public const string RMTD_ACCT_NO = "RmtdAcctNo"

Field Value

Type	Description
string

RMTD_ADR_LINE1

Remitted Adress Line 1, aka. Street Name and Building Number

Declaration

public const string RMTD_ADR_LINE1 = "RmtdAdrLine1"

Field Value

Type	Description
string

RMTD_ADR_LINE2

Remitted Adress Line 2, aka. Postcode and Town Name

Declaration

public const string RMTD_ADR_LINE2 = "RmtdAdrLine2"

Field Value

Type	Description
string

RMTD_NM

Remitted Name

Declaration

public const string RMTD_NM = "RmtdNm"

Field Value

Type	Description
string

RMTD_NM_MEMO

Remitted Name Memo

Declaration

public const string RMTD_NM_MEMO = "RmtdNmMemo"

Field Value

Type	Description
string

RMTD_PST_CD

Remitted Post Code

Declaration

public const string RMTD_PST_CD = "RmtdPstCd"

Field Value

Type	Description
string

RMTD_TWN_NM

Remitted Town Name

Declaration

public const string RMTD_TWN_NM = "RmtdTwnNm"

Field Value

Type	Description
string

RMTD_ULTMT_NM

Remitted Ultimate Name

Declaration

public const string RMTD_ULTMT_NM = "RmtdUltmtNm"

Field Value

Type	Description
string

RMT_INF

Remittance Info

Declaration

public const string RMT_INF = "RmtInf"

Field Value

Type	Description
string

SEQ_TP

Sequence Type

Declaration

public const string SEQ_TP = "SeqTp"

Field Value

Type	Description
string

SVC_LVL

Service Level

Declaration

public const string SVC_LVL = "SvcLvl"

Field Value

Type	Description
string

TTL_CHRGS_AND_TAX_AMT

Total Changes and Tax Amount

Declaration

public const string TTL_CHRGS_AND_TAX_AMT = "TtlChrgsAndTaxAmt"

Field Value

Type	Description
string

TTL_CHRGS_AND_TAX_AMT_CCY

Total Changes and Tax Amount Currency

Declaration

public const string TTL_CHRGS_AND_TAX_AMT_CCY = "TtlChrgsAndTaxAmtCcy"

Field Value

Type	Description
string

TX_DT

Transaction Date

Declaration

public const string TX_DT = "TxDt"

Field Value

Type	Description
string

VAL_DT

Value Date

Declaration

public const string VAL_DT = "ValDt"

Field Value

Type	Description
string

VAT_AMT

VAT Amount

Declaration

public const string VAT_AMT = "VatAmt"

Field Value

Type	Description
string

_DEC_VALUE

Pseudo column name: _DecValue

Declaration

public const string _DEC_VALUE = "_DecValue"

Field Value

Type	Description
string

Remarks

This can be used to represent a signed Amount with implicit CdtDbtInd.

_FEE_AMT

Pseudo column name: _FeeAmt

Declaration

public const string _FEE_AMT = "_FeeAmt"

Field Value

Type	Description
string

Remarks

This can be used for additional fee amounts that must be deducted from the booking value.

_NEG_DEC_VALUE

Pseudo column name: _NegDecValue

Declaration

public const string _NEG_DEC_VALUE = "_NegDecValue"

Field Value

Type	Description
string

Remarks

This can be used to represent a signed Amount with inverse CdtDbtInd logic, i.e. negative values are actually credited to the account, positive values are debited from the account.

_SOLL_HABEN

Pseudo column name: _SollHaben

Declaration

public const string _SOLL_HABEN = "_SollHaben"

Field Value

Type	Description
string

Remarks

As an alternative to CdtDbtInd, this column expects the values "S" for Soll/Debit and "H" for Haben/Credit.

_SUB_CATEGORY

Pseudo column name: _SubCategory

Declaration

public const string _SUB_CATEGORY = "_SubCategory"

Field Value

Type	Description
string

_VAT_PERCENT

Pseudo column name: _VatPercent

Declaration

public const string _VAT_PERCENT = "_VatPercent"

Field Value

Type	Description
string

Properties

DataType

The data type of the values in this column.

Declaration

public SupaDataType DataType { get; }

Property Value

Type	Description
SupaDataType

IsMandatory

Indicates whether the value of this column is mandatory and must be set.

Declaration

public bool IsMandatory { get; }

Property Value

Type	Description
bool

Name

Name of the column. Used as the JSON field name, or CSV column header value.

Declaration

public string Name { get; }

Property Value

Type	Description
string

ReadableName

Get a human readable version of the field name, e.g. "Amount" instead of "Amt".

Declaration

public string ReadableName { get; }

Property Value

Type	Description
string