Class SupaColumn
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
stringnDataType
SupaDataTypefMandatory
bool
Fields
ACCT_ID
Account ID
public const string ACCT_ID = "AcctId"
Field Value
AMT
Amount
public const string AMT = "Amt"
Field Value
AMT_CCY
Amount Currency
public const string AMT_CCY = "AmtCcy"
Field Value
AMT_PD
Amount Paid
public const string AMT_PD = "AmtPd"
Field Value
BANK_REF
Bank Reference
public const string BANK_REF = "BankRef"
Field Value
BK_TX_CD
Bank Transaction Code
public const string BK_TX_CD = "BkTxCd"
Field Value
BOOKG_DT
Booking Date
public const string BOOKG_DT = "BookgDt"
Field Value
BOOKG_STS
Booking Status
public const string BOOKG_STS = "BookgSts"
Field Value
BOOKG_TXT
Booking Text
public const string BOOKG_TXT = "BookgTxt"
Field Value
BTCH_BOOKG
Batch Booking
public const string BTCH_BOOKG = "BtchBookg"
Field Value
BTCH_ID
Batch ID
public const string BTCH_ID = "BtchId"
Field Value
CATEGORY
Category
public const string CATEGORY = "Category"
Field Value
CATEGORY_DT
Category Date
public const string CATEGORY_DT = "CategoryDt"
Field Value
CDTR_ID
Creditor ID
public const string CDTR_ID = "CdtrId"
Field Value
CDT_DBT_IND
Credit Debit Indicator
public const string CDT_DBT_IND = "CdtDbtInd"
Field Value
CHRGS_ACCT_CCY
Charges Account Currency
public const string CHRGS_ACCT_CCY = "ChrgsAcctCcy"
Field Value
CHRGS_ACCT_IBAN
Charges Account IBAN
public const string CHRGS_ACCT_IBAN = "ChrgsAcctIBAN"
Field Value
COST_BEARER
Cost Bearer
public const string COST_BEARER = "CostBearer"
Field Value
CTGY_PURP_CD
Category Purpose Code
public const string CTGY_PURP_CD = "CtgyPurpCd"
Field Value
CUST_NB
Customer Number
public const string CUST_NB = "CustNb"
Field Value
DESC
Description
public const string DESC = "Desc"
Field Value
DNMTN_CCY
Denomination Currency
public const string DNMTN_CCY = "DnmtnCcy"
Field Value
DUE_DT
Due Date
public const string DUE_DT = "DueDt"
Field Value
DUNNING_CHRG
Dunning Charge
public const string DUNNING_CHRG = "DunningChrg"
Field Value
DUNNING_DT
Dunning Date
public const string DUNNING_DT = "DunningDt"
Field Value
DUNNING_INTRST
Dunning Interest
public const string DUNNING_INTRST = "DunningIntrst"
Field Value
DUNNING_LVL
Dunning Level
public const string DUNNING_LVL = "DunningLvl"
Field Value
END_TO_END_ID
End-to-End ID
public const string END_TO_END_ID = "EndToEndId"
Field Value
FLAG
Flag
public const string FLAG = "Flag"
Field Value
GVC
GVC
public const string GVC = "GVC"
Field Value
GVC_EXTENSION
GVC Extension
public const string GVC_EXTENSION = "GVCExtension"
Field Value
ID
ID
public const string ID = "Id"
Field Value
INSTD_AMT
Instructed Amount
public const string INSTD_AMT = "InstdAmt"
Field Value
INSTD_AMT_CCY
Instructed Amount Currency
public const string INSTD_AMT_CCY = "InstdAmtCcy"
Field Value
INSTR_FOR_DBTR_AGT_INF
Instruction for Debtor Agent.
public const string INSTR_FOR_DBTR_AGT_INF = "InstrForDbtrAgtInf"
Field Value
INTRST_RATE
Interest Rate
public const string INTRST_RATE = "IntrstRate"
Field Value
INVC_DT
Invoice Date
public const string INVC_DT = "InvcDt"
Field Value
INVC_NB
Invoice Number
public const string INVC_NB = "InvcNb"
Field Value
INVC_NM
Invoicer/Invoicee Name
public const string INVC_NM = "InvcNm"
Field Value
INVC_STS
Invoice Status
public const string INVC_STS = "InvcSts"
Field Value
INVC_TP
Invoice Type
public const string INVC_TP = "InvcTp"
Field Value
ISIN
ISIN
public const string ISIN = "ISIN"
Field Value
LCL_INSTRM
Local Instrument
public const string LCL_INSTRM = "LclInstrm"
Field Value
MNDT_DT_OF_SGNTR
Mandate Date of Signature
public const string MNDT_DT_OF_SGNTR = "MndtDtOfSgntr"
Field Value
MNDT_ID
Mandate ID
public const string MNDT_ID = "MndtId"
Field Value
MNDT_LCL_INSTRM
Mandate Local Instrument
public const string MNDT_LCL_INSTRM = "MndtLclInstrm"
Field Value
MTRTY_DT
Maturity Date
public const string MTRTY_DT = "MtrtyDt"
Field Value
NOTES
Notes
public const string NOTES = "Notes"
Field Value
OWNR_ACCT_BANK_CODE
Owner Account Bank Code
public const string OWNR_ACCT_BANK_CODE = "OwnrAcctBankCode"
Field Value
OWNR_ACCT_BIC
Owner Account BIC
public const string OWNR_ACCT_BIC = "OwnrAcctBIC"
Field Value
OWNR_ACCT_CCY
Owner Account Currency
public const string OWNR_ACCT_CCY = "OwnrAcctCcy"
Field Value
OWNR_ACCT_CTRY
Owner Account Country
public const string OWNR_ACCT_CTRY = "OwnrAcctCtry"
Field Value
OWNR_ACCT_IBAN
Owner Account IBAN
public const string OWNR_ACCT_IBAN = "OwnrAcctIBAN"
Field Value
OWNR_ACCT_NO
Owner Account Number
public const string OWNR_ACCT_NO = "OwnrAcctNo"
Field Value
OWNR_NM
Owner Name
public const string OWNR_NM = "OwnrNm"
Field Value
PMT_INF_ID
Payment Information ID
public const string PMT_INF_ID = "PmtInfId"
Field Value
PMT_MTD
Payment Method
public const string PMT_MTD = "PmtMtd"
Field Value
PRIC_CUR
Price Current
public const string PRIC_CUR = "PricCur"
Field Value
PRIC_CUR_CCY
Price Current Currency
public const string PRIC_CUR_CCY = "PricCurCcy"
Field Value
PRIC_CUR_DT
Price Current Date
public const string PRIC_CUR_DT = "PricCurDt"
Field Value
PRIC_INVST
Price Invested
public const string PRIC_INVST = "PricInvst"
Field Value
PRIC_INVST_CCY
Price Invested Currency
public const string PRIC_INVST_CCY = "PricInvstCcy"
Field Value
PRIC_INVST_DT
Price Invested Date
public const string PRIC_INVST_DT = "PricInvstDt"
Field Value
PRIC_TP
Price Type
public const string PRIC_TP = "PricTp"
Field Value
PRIMA_NOTA_NO
Prima Nota Number
public const string PRIMA_NOTA_NO = "PrimaNotaNo"
Field Value
PURP_CD
Purpose Code
public const string PURP_CD = "PurpCd"
Field Value
QTY
Quantity
public const string QTY = "Qty"
Field Value
READ_STATUS
Read Status
public const string READ_STATUS = "ReadStatus"
Field Value
REQD_EXCTN_DT
Requested Execution Date
public const string REQD_EXCTN_DT = "ReqdExctnDt"
Field Value
REQD_EXCTN_DT_TM
Requested Execution Date and Time
public const string REQD_EXCTN_DT_TM = "ReqdExctnDtTm"
Field Value
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
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
RMTD_ACCT_BANK_CODE
Remitted Account Bank Code
public const string RMTD_ACCT_BANK_CODE = "RmtdAcctBankCode"
Field Value
RMTD_ACCT_BANK_CTRY
Remitted Account Bank Address
public const string RMTD_ACCT_BANK_CTRY = "RmtdAcctBankCtry"
Field Value
RMTD_ACCT_BANK_NAME
Remitted Account Bank Name
public const string RMTD_ACCT_BANK_NAME = "RmtdAcctBankName"
Field Value
RMTD_ACCT_BIC
Remitted Account BIC
public const string RMTD_ACCT_BIC = "RmtdAcctBIC"
Field Value
RMTD_ACCT_CTRY
Remitted Account Country
public const string RMTD_ACCT_CTRY = "RmtdAcctCtry"
Field Value
RMTD_ACCT_IBAN
Remitted Account IBAN
public const string RMTD_ACCT_IBAN = "RmtdAcctIBAN"
Field Value
RMTD_ACCT_NO
Remitted Account Number
public const string RMTD_ACCT_NO = "RmtdAcctNo"
Field Value
RMTD_ADR_LINE1
Remitted Adress Line 1, aka. Street Name and Building Number
public const string RMTD_ADR_LINE1 = "RmtdAdrLine1"
Field Value
RMTD_ADR_LINE2
Remitted Adress Line 2, aka. Postcode and Town Name
public const string RMTD_ADR_LINE2 = "RmtdAdrLine2"
Field Value
RMTD_NM
Remitted Name
public const string RMTD_NM = "RmtdNm"
Field Value
RMTD_NM_MEMO
Remitted Name Memo
public const string RMTD_NM_MEMO = "RmtdNmMemo"
Field Value
RMTD_PST_CD
Remitted Post Code
public const string RMTD_PST_CD = "RmtdPstCd"
Field Value
RMTD_TWN_NM
Remitted Town Name
public const string RMTD_TWN_NM = "RmtdTwnNm"
Field Value
RMTD_ULTMT_NM
Remitted Ultimate Name
public const string RMTD_ULTMT_NM = "RmtdUltmtNm"
Field Value
RMT_INF
Remittance Info
public const string RMT_INF = "RmtInf"
Field Value
SEQ_TP
Sequence Type
public const string SEQ_TP = "SeqTp"
Field Value
SVC_LVL
Service Level
public const string SVC_LVL = "SvcLvl"
Field Value
TTL_CHRGS_AND_TAX_AMT
Total Changes and Tax Amount
public const string TTL_CHRGS_AND_TAX_AMT = "TtlChrgsAndTaxAmt"
Field Value
TTL_CHRGS_AND_TAX_AMT_CCY
Total Changes and Tax Amount Currency
public const string TTL_CHRGS_AND_TAX_AMT_CCY = "TtlChrgsAndTaxAmtCcy"
Field Value
TX_DT
Transaction Date
public const string TX_DT = "TxDt"
Field Value
VAL_DT
Value Date
public const string VAL_DT = "ValDt"
Field Value
VAT_AMT
VAT Amount
public const string VAT_AMT = "VatAmt"
Field Value
_DEC_VALUE
Pseudo column name: _DecValue
public const string _DEC_VALUE = "_DecValue"
Field Value
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
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
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
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
_VAT_PERCENT
Pseudo column name: _VatPercent
public const string _VAT_PERCENT = "_VatPercent"
Field Value
Properties
DataType
The data type of the values in this column.
public SupaDataType DataType { get; }
Property Value
IsMandatory
Indicates whether the value of this column is mandatory and must be set.
public bool IsMandatory { get; }
Property Value
Name
Name of the column. Used as the JSON field name, or CSV column header value.
public string Name { get; }
Property Value
ReadableName
Get a human readable version of the field name, e.g. "Amount" instead of "Amt".
public string ReadableName { get; }