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 SupaColumnConstructors
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, aka. Street Name and Building Number
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, aka. Postcode and Town Name
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_CTRY
Remitted Account Bank Address
Declaration
public const string RMTD_ACCT_BANK_CTRY = "RmtdAcctBankCtry"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, aka. Street Name and Building Number
Declaration
public const string RMTD_ADR_LINE1 = "RmtdAdrLine1"Field Value
| Type | Description |
|---|---|
| System.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 |
|---|---|
| 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 |