Class SupaColumn

Namespace
Subsembly.Supa
Assembly
Subsembly.Sepa.dll

Holds meta information about a SUPA data column.

public class SupaColumn
Inheritance
SupaColumn
Inherited Members

Constructors

SupaColumn(string, SupaDataType, bool) 

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

Parameters

sName string
nDataType SupaDataType
fMandatory bool

Fields

ACCT_ID

Account ID

public const string ACCT_ID = "AcctId"

Field Value

string

AMT

Amount

public const string AMT = "Amt"

Field Value

string

AMT_CCY

Amount Currency

public const string AMT_CCY = "AmtCcy"

Field Value

string

AMT_PD

Amount Paid

public const string AMT_PD = "AmtPd"

Field Value

string

BANK_REF

Bank Reference

public const string BANK_REF = "BankRef"

Field Value

string

BK_TX_CD

Bank Transaction Code

public const string BK_TX_CD = "BkTxCd"

Field Value

string

BOOKG_DT

Booking Date

public const string BOOKG_DT = "BookgDt"

Field Value

string

BOOKG_STS

Booking Status

public const string BOOKG_STS = "BookgSts"

Field Value

string

BOOKG_TXT

Booking Text

public const string BOOKG_TXT = "BookgTxt"

Field Value

string

BTCH_BOOKG

Batch Booking

public const string BTCH_BOOKG = "BtchBookg"

Field Value

string

BTCH_ID

Batch ID

public const string BTCH_ID = "BtchId"

Field Value

string

CATEGORY

Category

public const string CATEGORY = "Category"

Field Value

string

CATEGORY_DT

Category Date

public const string CATEGORY_DT = "CategoryDt"

Field Value

string

CDTR_ID

Creditor ID

public const string CDTR_ID = "CdtrId"

Field Value

string

CDT_DBT_IND

Credit Debit Indicator

public const string CDT_DBT_IND = "CdtDbtInd"

Field Value

string

CHRGS_ACCT_CCY

Charges Account Currency

public const string CHRGS_ACCT_CCY = "ChrgsAcctCcy"

Field Value

string

CHRGS_ACCT_IBAN

Charges Account IBAN

public const string CHRGS_ACCT_IBAN = "ChrgsAcctIBAN"

Field Value

string

COST_BEARER

Cost Bearer

public const string COST_BEARER = "CostBearer"

Field Value

string

CTGY_PURP_CD

Category Purpose Code

public const string CTGY_PURP_CD = "CtgyPurpCd"

Field Value

string

CUST_NB

Customer Number

public const string CUST_NB = "CustNb"

Field Value

string

DESC

Description

public const string DESC = "Desc"

Field Value

string

DNMTN_CCY

Denomination Currency

public const string DNMTN_CCY = "DnmtnCcy"

Field Value

string

DUE_DT

Due Date

public const string DUE_DT = "DueDt"

Field Value

string

DUNNING_CHRG

Dunning Charge

public const string DUNNING_CHRG = "DunningChrg"

Field Value

string

DUNNING_DT

Dunning Date

public const string DUNNING_DT = "DunningDt"

Field Value

string

DUNNING_INTRST

Dunning Interest

public const string DUNNING_INTRST = "DunningIntrst"

Field Value

string

DUNNING_LVL

Dunning Level

public const string DUNNING_LVL = "DunningLvl"

Field Value

string

END_TO_END_ID

End-to-End ID

public const string END_TO_END_ID = "EndToEndId"

Field Value

string

FLAG

Flag

public const string FLAG = "Flag"

Field Value

string

GVC

GVC

public const string GVC = "GVC"

Field Value

string

GVC_EXTENSION

GVC Extension

public const string GVC_EXTENSION = "GVCExtension"

Field Value

string

ID

ID

public const string ID = "Id"

Field Value

string

INSTD_AMT

Instructed Amount

public const string INSTD_AMT = "InstdAmt"

Field Value

string

INSTD_AMT_CCY

Instructed Amount Currency

public const string INSTD_AMT_CCY = "InstdAmtCcy"

Field Value

string

INSTR_FOR_DBTR_AGT_INF

Instruction for Debtor Agent.

public const string INSTR_FOR_DBTR_AGT_INF = "InstrForDbtrAgtInf"

Field Value

string

INTRST_RATE

Interest Rate

public const string INTRST_RATE = "IntrstRate"

Field Value

string

INVC_DT

Invoice Date

public const string INVC_DT = "InvcDt"

Field Value

string

INVC_NB

Invoice Number

public const string INVC_NB = "InvcNb"

Field Value

string

INVC_NM

Invoicer/Invoicee Name

public const string INVC_NM = "InvcNm"

Field Value

string

INVC_STS

Invoice Status

public const string INVC_STS = "InvcSts"

Field Value

string

INVC_TP

Invoice Type

public const string INVC_TP = "InvcTp"

Field Value

string

ISIN

ISIN

public const string ISIN = "ISIN"

Field Value

string

LCL_INSTRM

Local Instrument

public const string LCL_INSTRM = "LclInstrm"

Field Value

string

MNDT_DT_OF_SGNTR

Mandate Date of Signature

public const string MNDT_DT_OF_SGNTR = "MndtDtOfSgntr"

Field Value

string

MNDT_ID

Mandate ID

public const string MNDT_ID = "MndtId"

Field Value

string

MNDT_LCL_INSTRM

Mandate Local Instrument

public const string MNDT_LCL_INSTRM = "MndtLclInstrm"

Field Value

string

MTRTY_DT

Maturity Date

public const string MTRTY_DT = "MtrtyDt"

Field Value

string

NOTES

Notes

public const string NOTES = "Notes"

Field Value

string

OWNR_ACCT_BANK_CODE

Owner Account Bank Code

public const string OWNR_ACCT_BANK_CODE = "OwnrAcctBankCode"

Field Value

string

OWNR_ACCT_BIC

Owner Account BIC

public const string OWNR_ACCT_BIC = "OwnrAcctBIC"

Field Value

string

OWNR_ACCT_CCY

Owner Account Currency

public const string OWNR_ACCT_CCY = "OwnrAcctCcy"

Field Value

string

OWNR_ACCT_CTRY

Owner Account Country

public const string OWNR_ACCT_CTRY = "OwnrAcctCtry"

Field Value

string

OWNR_ACCT_IBAN

Owner Account IBAN

public const string OWNR_ACCT_IBAN = "OwnrAcctIBAN"

Field Value

string

OWNR_ACCT_NO

Owner Account Number

public const string OWNR_ACCT_NO = "OwnrAcctNo"

Field Value

string

OWNR_NM

Owner Name

public const string OWNR_NM = "OwnrNm"

Field Value

string

PMT_INF_ID

Payment Information ID

public const string PMT_INF_ID = "PmtInfId"

Field Value

string

PMT_MTD

Payment Method

public const string PMT_MTD = "PmtMtd"

Field Value

string

PRIC_CUR

Price Current

public const string PRIC_CUR = "PricCur"

Field Value

string

PRIC_CUR_CCY

Price Current Currency

public const string PRIC_CUR_CCY = "PricCurCcy"

Field Value

string

PRIC_CUR_DT

Price Current Date

public const string PRIC_CUR_DT = "PricCurDt"

Field Value

string

PRIC_INVST

Price Invested

public const string PRIC_INVST = "PricInvst"

Field Value

string

PRIC_INVST_CCY

Price Invested Currency

public const string PRIC_INVST_CCY = "PricInvstCcy"

Field Value

string

PRIC_INVST_DT

Price Invested Date

public const string PRIC_INVST_DT = "PricInvstDt"

Field Value

string

PRIC_TP

Price Type

public const string PRIC_TP = "PricTp"

Field Value

string

PRIMA_NOTA_NO

Prima Nota Number

public const string PRIMA_NOTA_NO = "PrimaNotaNo"

Field Value

string

PURP_CD

Purpose Code

public const string PURP_CD = "PurpCd"

Field Value

string

QTY

Quantity

public const string QTY = "Qty"

Field Value

string

READ_STATUS

Read Status

public const string READ_STATUS = "ReadStatus"

Field Value

string

REQD_EXCTN_DT

Requested Execution Date

public const string REQD_EXCTN_DT = "ReqdExctnDt"

Field Value

string

REQD_EXCTN_DT_TM

Requested Execution Date and Time

public const string REQD_EXCTN_DT_TM = "ReqdExctnDtTm"

Field Value

string

RMTD_ACCT_BANK_ADR_LINE1

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

public const string RMTD_ACCT_BANK_ADR_LINE1 = "RmtdAcctBankAdrLine1"

Field Value

string

RMTD_ACCT_BANK_ADR_LINE2

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

public const string RMTD_ACCT_BANK_ADR_LINE2 = "RmtdAcctBankAdrLine2"

Field Value

string

RMTD_ACCT_BANK_CODE

Remitted Account Bank Code

public const string RMTD_ACCT_BANK_CODE = "RmtdAcctBankCode"

Field Value

string

RMTD_ACCT_BANK_CTRY

Remitted Account Bank Address

public const string RMTD_ACCT_BANK_CTRY = "RmtdAcctBankCtry"

Field Value

string

RMTD_ACCT_BANK_NAME

Remitted Account Bank Name

public const string RMTD_ACCT_BANK_NAME = "RmtdAcctBankName"

Field Value

string

RMTD_ACCT_BIC

Remitted Account BIC

public const string RMTD_ACCT_BIC = "RmtdAcctBIC"

Field Value

string

RMTD_ACCT_CTRY

Remitted Account Country

public const string RMTD_ACCT_CTRY = "RmtdAcctCtry"

Field Value

string

RMTD_ACCT_IBAN

Remitted Account IBAN

public const string RMTD_ACCT_IBAN = "RmtdAcctIBAN"

Field Value

string

RMTD_ACCT_NO

Remitted Account Number

public const string RMTD_ACCT_NO = "RmtdAcctNo"

Field Value

string

RMTD_ADR_LINE1

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

public const string RMTD_ADR_LINE1 = "RmtdAdrLine1"

Field Value

string

RMTD_ADR_LINE2

Remitted Adress Line 2, aka. Postcode and Town Name

public const string RMTD_ADR_LINE2 = "RmtdAdrLine2"

Field Value

string

RMTD_NM

Remitted Name

public const string RMTD_NM = "RmtdNm"

Field Value

string

RMTD_NM_MEMO

Remitted Name Memo

public const string RMTD_NM_MEMO = "RmtdNmMemo"

Field Value

string

RMTD_PST_CD

Remitted Post Code

public const string RMTD_PST_CD = "RmtdPstCd"

Field Value

string

RMTD_TWN_NM

Remitted Town Name

public const string RMTD_TWN_NM = "RmtdTwnNm"

Field Value

string

RMTD_ULTMT_NM

Remitted Ultimate Name

public const string RMTD_ULTMT_NM = "RmtdUltmtNm"

Field Value

string

RMT_INF

Remittance Info

public const string RMT_INF = "RmtInf"

Field Value

string

SEQ_TP

Sequence Type

public const string SEQ_TP = "SeqTp"

Field Value

string

SVC_LVL

Service Level

public const string SVC_LVL = "SvcLvl"

Field Value

string

TTL_CHRGS_AND_TAX_AMT

Total Changes and Tax Amount

public const string TTL_CHRGS_AND_TAX_AMT = "TtlChrgsAndTaxAmt"

Field Value

string

TTL_CHRGS_AND_TAX_AMT_CCY

Total Changes and Tax Amount Currency

public const string TTL_CHRGS_AND_TAX_AMT_CCY = "TtlChrgsAndTaxAmtCcy"

Field Value

string

TX_DT

Transaction Date

public const string TX_DT = "TxDt"

Field Value

string

VAL_DT

Value Date

public const string VAL_DT = "ValDt"

Field Value

string

VAT_AMT

VAT Amount

public const string VAT_AMT = "VatAmt"

Field Value

string

_DEC_VALUE

Pseudo column name: _DecValue

public const string _DEC_VALUE = "_DecValue"

Field Value

string

Remarks

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

_FEE_AMT

Pseudo column name: _FeeAmt

public const string _FEE_AMT = "_FeeAmt"

Field Value

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

public const string _NEG_DEC_VALUE = "_NegDecValue"

Field Value

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

public const string _SOLL_HABEN = "_SollHaben"

Field Value

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

public const string _SUB_CATEGORY = "_SubCategory"

Field Value

string

_VAT_PERCENT

Pseudo column name: _VatPercent

public const string _VAT_PERCENT = "_VatPercent"

Field Value

string

Properties

DataType

The data type of the values in this column.

public SupaDataType DataType { get; }

Property Value

SupaDataType

IsMandatory

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

public bool IsMandatory { get; }

Property Value

bool

Name

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

public string Name { get; }

Property Value

string

ReadableName

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

public string ReadableName { get; }

Property Value

string