Class SupaColumn

Holds meta information about a SUPA data column.

Inheritance

System.Object

SupaColumn

Inherited Members

System.Object.Equals(System.Object)

System.Object.Equals(System.Object, System.Object)

System.Object.GetHashCode()

System.Object.GetType()

System.Object.MemberwiseClone()

System.Object.ReferenceEquals(System.Object, System.Object)

System.Object.ToString()

Namespace: Subsembly.Supa

Assembly: Subsembly.Sepa.dll

Syntax

public class SupaColumn

Constructors

SupaColumn(String, SupaDataType, Boolean)

Declaration

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

Parameters

Type	Name	Description
System.String	sName
SupaDataType	nDataType
System.Boolean	fMandatory

Fields

_DEC_VALUE

Pseudo column name: _DecValue

Declaration

public const string _DEC_VALUE = "_DecValue"

Field Value

Type	Description
System.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
System.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
System.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
System.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
System.String

_VAT_PERCENT

Pseudo column name: _VatPercent

Declaration

public const string _VAT_PERCENT = "_VatPercent"

Field Value

Type	Description
System.String

ACCT_ID

Account ID

Declaration

public const string ACCT_ID = "AcctId"

Field Value

Type	Description
System.String

AMT

Amount

Declaration

public const string AMT = "Amt"

Field Value

Type	Description
System.String

AMT_CCY

Amount Currency

Declaration

public const string AMT_CCY = "AmtCcy"

Field Value

Type	Description
System.String

AMT_PD

Amount Paid

Declaration

public const string AMT_PD = "AmtPd"

Field Value

Type	Description
System.String

BANK_REF

Bank Reference

Declaration

public const string BANK_REF = "BankRef"

Field Value

Type	Description
System.String

BK_TX_CD

Bank Transaction Code

Declaration

public const string BK_TX_CD = "BkTxCd"

Field Value

Type	Description
System.String

BOOKG_DT

Booking Date

Declaration

public const string BOOKG_DT = "BookgDt"

Field Value

Type	Description
System.String

BOOKG_STS

Booking Status

Declaration

public const string BOOKG_STS = "BookgSts"

Field Value

Type	Description
System.String

BOOKG_TXT

Booking Text

Declaration

public const string BOOKG_TXT = "BookgTxt"

Field Value

Type	Description
System.String

BTCH_BOOKG

Batch Booking

Declaration

public const string BTCH_BOOKG = "BtchBookg"

Field Value

Type	Description
System.String

BTCH_ID

Batch ID

Declaration

public const string BTCH_ID = "BtchId"

Field Value

Type	Description
System.String

CATEGORY

Category

Declaration

public const string CATEGORY = "Category"

Field Value

Type	Description
System.String

CATEGORY_DT

Category Date

Declaration

public const string CATEGORY_DT = "CategoryDt"

Field Value

Type	Description
System.String

CDT_DBT_IND

Credit Debit Indicator

Declaration

public const string CDT_DBT_IND = "CdtDbtInd"

Field Value

Type	Description
System.String

CDTR_ID

Creditor ID

Declaration

public const string CDTR_ID = "CdtrId"

Field Value

Type	Description
System.String

CHRGS_ACCT_CCY

Charges Account Currency

Declaration

public const string CHRGS_ACCT_CCY = "ChrgsAcctCcy"

Field Value

Type	Description
System.String

CHRGS_ACCT_IBAN

Charges Account IBAN

Declaration

public const string CHRGS_ACCT_IBAN = "ChrgsAcctIBAN"

Field Value

Type	Description
System.String

COST_BEARER

Cost Bearer

Declaration

public const string COST_BEARER = "CostBearer"

Field Value

Type	Description
System.String

CTGY_PURP_CD

Category Purpose Code

Declaration

public const string CTGY_PURP_CD = "CtgyPurpCd"

Field Value

Type	Description
System.String

CUST_NB

Customer Number

Declaration

public const string CUST_NB = "CustNb"

Field Value

Type	Description
System.String

DUE_DT

Due Date

Declaration

public const string DUE_DT = "DueDt"

Field Value

Type	Description
System.String

DUNNING_CHRG

Dunning Charge

Declaration

public const string DUNNING_CHRG = "DunningChrg"

Field Value

Type	Description
System.String

DUNNING_DT

Dunning Date

Declaration

public const string DUNNING_DT = "DunningDt"

Field Value

Type	Description
System.String

DUNNING_INTRST

Dunning Interest

Declaration

public const string DUNNING_INTRST = "DunningIntrst"

Field Value

Type	Description
System.String

DUNNING_LVL

Dunning Level

Declaration

public const string DUNNING_LVL = "DunningLvl"

Field Value

Type	Description
System.String

END_TO_END_ID

End-to-End ID

Declaration

public const string END_TO_END_ID = "EndToEndId"

Field Value

Type	Description
System.String

FLAG

Flag

Declaration

public const string FLAG = "Flag"

Field Value

Type	Description
System.String

GVC

GVC

Declaration

public const string GVC = "GVC"

Field Value

Type	Description
System.String

GVC_EXTENSION

GVC Extension

Declaration

public const string GVC_EXTENSION = "GVCExtension"

Field Value

Type	Description
System.String

ID

ID

Declaration

public const string ID = "Id"

Field Value

Type	Description
System.String

INSTD_AMT

Instructed Amount

Declaration

public const string INSTD_AMT = "InstdAmt"

Field Value

Type	Description
System.String

INSTD_AMT_CCY

Instructed Amount Currency

Declaration

public const string INSTD_AMT_CCY = "InstdAmtCcy"

Field Value

Type	Description
System.String

INSTR_FOR_DBTR_AGT_INF

Instruction for Debtor Agent.

Declaration

public const string INSTR_FOR_DBTR_AGT_INF = "InstrForDbtrAgtInf"

Field Value

Type	Description
System.String

INVC_DT

Invoice Date

Declaration

public const string INVC_DT = "InvcDt"

Field Value

Type	Description
System.String

INVC_NB

Invoice Number

Declaration

public const string INVC_NB = "InvcNb"

Field Value

Type	Description
System.String

INVC_NM

Invoicer/Invoicee Name

Declaration

public const string INVC_NM = "InvcNm"

Field Value

Type	Description
System.String

INVC_STS

Invoice Status

Declaration

public const string INVC_STS = "InvcSts"

Field Value

Type	Description
System.String

INVC_TP

Invoice Type

Declaration

public const string INVC_TP = "InvcTp"

Field Value

Type	Description
System.String

LCL_INSTRM

Local Instrument

Declaration

public const string LCL_INSTRM = "LclInstrm"

Field Value

Type	Description
System.String

MNDT_DT_OF_SGNTR

Mandate Date of Signature

Declaration

public const string MNDT_DT_OF_SGNTR = "MndtDtOfSgntr"

Field Value

Type	Description
System.String

MNDT_ID

Mandate ID

Declaration

public const string MNDT_ID = "MndtId"

Field Value

Type	Description
System.String

MNDT_LCL_INSTRM

Mandate Local Instrument

Declaration

public const string MNDT_LCL_INSTRM = "MndtLclInstrm"

Field Value

Type	Description
System.String

NOTES

Notes

Declaration

public const string NOTES = "Notes"

Field Value

Type	Description
System.String

OWNR_ACCT_BANK_CODE

Owner Account Bank Code

Declaration

public const string OWNR_ACCT_BANK_CODE = "OwnrAcctBankCode"

Field Value

Type	Description
System.String

OWNR_ACCT_BIC

Owner Account BIC

Declaration

public const string OWNR_ACCT_BIC = "OwnrAcctBIC"

Field Value

Type	Description
System.String

OWNR_ACCT_CCY

Owner Account Currency

Declaration

public const string OWNR_ACCT_CCY = "OwnrAcctCcy"

Field Value

Type	Description
System.String

OWNR_ACCT_CTRY

Owner Account Country

Declaration

public const string OWNR_ACCT_CTRY = "OwnrAcctCtry"

Field Value

Type	Description
System.String

OWNR_ACCT_IBAN

Owner Account IBAN

Declaration

public const string OWNR_ACCT_IBAN = "OwnrAcctIBAN"

Field Value

Type	Description
System.String

OWNR_ACCT_NO

Owner Account Number

Declaration

public const string OWNR_ACCT_NO = "OwnrAcctNo"

Field Value

Type	Description
System.String

OWNR_NM

Owner Name

Declaration

public const string OWNR_NM = "OwnrNm"

Field Value

Type	Description
System.String

PMT_INF_ID

Payment Information ID

Declaration

public const string PMT_INF_ID = "PmtInfId"

Field Value

Type	Description
System.String

PMT_MTD

Payment Method

Declaration

public const string PMT_MTD = "PmtMtd"

Field Value

Type	Description
System.String

PRIMA_NOTA_NO

Prima Nota Number

Declaration

public const string PRIMA_NOTA_NO = "PrimaNotaNo"

Field Value

Type	Description
System.String

PURP_CD

Purpose Code

Declaration

public const string PURP_CD = "PurpCd"

Field Value

Type	Description
System.String

READ_STATUS

Read Status

Declaration

public const string READ_STATUS = "ReadStatus"

Field Value

Type	Description
System.String

REQD_EXCTN_DT

Requested Execution Date

Declaration

public const string REQD_EXCTN_DT = "ReqdExctnDt"

Field Value

Type	Description
System.String

RMT_INF

Remittance Info

Declaration

public const string RMT_INF = "RmtInf"

Field Value

Type	Description
System.String

RMTD_ACCT_BANK_ADR_LINE1

Remitted Account Bank Address Line 1

Declaration

public const string RMTD_ACCT_BANK_ADR_LINE1 = "RmtdAcctBankAdrLine1"

Field Value

Type	Description
System.String

RMTD_ACCT_BANK_ADR_LINE2

Remitted Account Bank Address Line 2

Declaration

public const string RMTD_ACCT_BANK_ADR_LINE2 = "RmtdAcctBankAdrLine2"

Field Value

Type	Description
System.String

RMTD_ACCT_BANK_CODE

Remitted Account Bank Code

Declaration

public const string RMTD_ACCT_BANK_CODE = "RmtdAcctBankCode"

Field Value

Type	Description
System.String

RMTD_ACCT_BANK_NAME

Remitted Account Bank Name

Declaration

public const string RMTD_ACCT_BANK_NAME = "RmtdAcctBankName"

Field Value

Type	Description
System.String

RMTD_ACCT_BIC

Remitted Account BIC

Declaration

public const string RMTD_ACCT_BIC = "RmtdAcctBIC"

Field Value

Type	Description
System.String

RMTD_ACCT_CTRY

Remitted Account Country

Declaration

public const string RMTD_ACCT_CTRY = "RmtdAcctCtry"

Field Value

Type	Description
System.String

RMTD_ACCT_IBAN

Remitted Account IBAN

Declaration

public const string RMTD_ACCT_IBAN = "RmtdAcctIBAN"

Field Value

Type	Description
System.String

RMTD_ACCT_NO

Remitted Account Number

Declaration

public const string RMTD_ACCT_NO = "RmtdAcctNo"

Field Value

Type	Description
System.String

RMTD_ADR_LINE1

Remitted Adress Line 1

Declaration

public const string RMTD_ADR_LINE1 = "RmtdAdrLine1"

Field Value

Type	Description
System.String

RMTD_ADR_LINE2

Remitted Adress Line 2

Declaration

public const string RMTD_ADR_LINE2 = "RmtdAdrLine2"

Field Value

Type	Description
System.String

RMTD_NM

Remitted Name

Declaration

public const string RMTD_NM = "RmtdNm"

Field Value

Type	Description
System.String

RMTD_NM_MEMO

Remitted Name Memo

Declaration

public const string RMTD_NM_MEMO = "RmtdNmMemo"

Field Value

Type	Description
System.String

RMTD_ULTMT_NM

Remitted Ultimate Name

Declaration

public const string RMTD_ULTMT_NM = "RmtdUltmtNm"

Field Value

Type	Description
System.String

SEQ_TP

Sequence Type

Declaration

public const string SEQ_TP = "SeqTp"

Field Value

Type	Description
System.String

SVC_LVL

Service Level

Declaration

public const string SVC_LVL = "SvcLvl"

Field Value

Type	Description
System.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
System.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
System.String

TX_DT

Transaction Date

Declaration

public const string TX_DT = "TxDt"

Field Value

Type	Description
System.String

VAL_DT

Value Date

Declaration

public const string VAL_DT = "ValDt"

Field Value

Type	Description
System.String

VAT_AMT

VAT Amount

Declaration

public const string VAT_AMT = "VatAmt"

Field Value

Type	Description
System.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
System.Boolean

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
System.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
System.String