Field Mapping for the CAMT Format
Note: We recommend you to refer the CAMT format in parallel
while understanding the below mentioned tags. This will help you to
understand how the tags are nested in the CAMT format.
Tag Name | Table | Field | Comments |
---|---|---|---|
Document | - | - | - |
BkSvcsBllgStmt | - | - | - |
RptHdr | - | - | - |
RptId | - | - | - |
MsgPgntn | - | - | - |
PgNb | - | - | - |
LastPgInd | - | - | - |
BllgStmtGrp | - | - | - |
GrpId | - | - | - |
Sndr | - | - | The sender person is derived from the SENDPER characteristic of the division to which the account belongs. |
Nm | CI_PER_NAME | ENTITY_NAME | The data is derived from the sender's record where NAME_TYPE_FLG='PRIM'. |
LglNm | CI_PER_NAME | ENTITY_NAME | The data is derived from the sender's record where NAME_TYPE_FLG='LGAL'. |
PstlAdr | - | - | - |
AdrTp |
Note: The field
mapping is not done for these tags. The implementation team will have
to map these tags to the appropriate fields.
|
||
Cd | C1_ADDRESS_ENTITY | ADDRESS_ID | - |
Dept |
Note: The field mapping
is not done for these tags. The implementation team will have to map
these tags to the appropriate fields.
|
||
SubDept | |||
StrtNm | |||
BldgNb | |||
BldgNm | |||
Flr | |||
PstBx | |||
Room | |||
PstCd | C1_ADDRESS | POSTAL | - |
TwnNm | C1_ADDRESS | CITY | - |
CtrySubDvsn | CI_STATE_L | STATE | - |
Ctry | C1_ADDRESS | COUNTRY | - |
AdrLine | C1_ADDRESS | ADDRESS 1 to ADDRESS 4 | - |
Id | - | - | - |
FIId | - | - | - |
BICFI | CI_PER_ID | PER_ID_NBR | The data is derived from the sender's record where ID_TYPE_CD='BIC'. |
CtryOfRes | C1_ADDRESS | COUNTRY | - |
CtctDtls | - | - | - |
NmPrfx | - | - | The data is derived from the NAMEPRFX characteristic of the sender's contact person. |
Nm | CI_PER_NAME | ENTITY_NAME | The data is derived from the sender's contact person's record where NAME_TYPE_FLG='PRIM'. |
PhneNb | CI_PER_PHONE | COUNTRY_CODE||PHONE | The data is derived from the sender's contact person's record where PHONE_TYPE_CD='BUS'. |
MobNb | CI_PER_PHONE | COUNTRY_CODE||PHONE | The data is derived from the sender's contact person's record where PHONE_TYPE_CD='MOB'. |
FaxNb | CI_PER_PHONE | COUNTRY_CODE||PHONE | The data is derived from the sender's contact person's record where PHONE_TYPE_CD='FAX'. |
EmailAdr | CI_PER | EMAILID | - |
SndrIndvCtct | - | - | - |
NmPrfx | - | - | The data is derived from the NAMEPRFX characteristic of the sender's individual contact person. |
Nm | CI_PER_NAME | ENTITY_NAME | The data is derived from the sender's individual contact person's record where NAME_TYPE_FLG='PRIM'. |
PhneNb | CI_PER_PHONE | COUNTRY_CODE||PHONE | The data is derived from the sender's individual contact person's record where PHONE_TYPE_CD='BUS'. |
MobNb | CI_PER_PHONE | COUNTRY_CODE||PHONE | The data is derived from the sender's individual contact person's record where PHONE_TYPE_CD='MOB'. |
FaxNb | CI_PER_PHONE | COUNTRY_CODE||PHONE | The data is derived from the sender's individual contact person's record where PHONE_TYPE_CD='FAX'. |
EmailAdr | CI_PER | EMAILID | - |
Rcvr | - | - | The receiver is derived from the account for which the bill is created. The system derives the person who is the main customer of the account. |
Nm | CI_PER_NAME | ENTITY_NAME | The data is derived from the receiver's record where NAME_TYPE_FLG='PRIM'. |
LglNm | CI_PER_NAME | ENTITY_NAME | The data is derived from the receiver's record where NAME_TYPE_FLG='LGAL'. |
PstlAdr | - | - | - |
AdrTp | - | - | If the bill address source is set to PER, then the address type is set to Billing. However, if the bill address source is set to ACOV, then the address type is set to Override. |
Cd | |||
Dept |
Note: The field mapping is not done for these tags. The implementation
team will have to map these tags to the appropriate fields.
|
||
SubDept | |||
StrtNm | |||
BldgNb | |||
BldgNm | |||
Flr | |||
PstBx | |||
Room | |||
PstCd | CI_PER | POSTAL | - |
TwnNm | CI_PER | CITY | - |
CtrySubDvsn | CI_PER | STATE | - |
Ctry | CI_PER | COUNTRY | - |
AdrLine | CI_PER | ADDRESS 1 to ADDRESS 4 | - |
Id | - | - | Depending on the value defined in the ORGORFI characteristic of the receiver, the data appears within the OrgId or FIId tag. If the value is set to ORG, the organization identification appears within the OrgId tag. However, if the value is set to FI, the financial institution identification appears within the FIId tag. |
OrgId | - | - | - |
AnyBIC | CI_PER_ID | PER_ID_NBR | The data is derived from the receiver's record where ID_TYPE_CD='BIC'. |
FIId | - | - | - |
BICFI | CI_PER_ID | PER_ID_NBR | The data is derived from the receiver's record where ID_TYPE_CD='BIC'. |
CtryOfRes | CI_PER | COUNTRY | - |
CtctDtls | - | - | - |
NmPrfx | - | - | The data is derived from the NAMEPRFX characteristic of the receiver's contact person. |
Nm | CI_PER_NAME | ENTITY_NAME | The data is derived from the receiver's contact person's record where NAME_TYPE_FLG='PRIM'. |
PhneNb | CI_PER_PHONE | COUNTRY_CODE||PHONE | The data is derived from the receiver's contact person's record where PHONE_TYPE_CD='BUS'. |
MobNb | CI_PER_PHONE | COUNTRY_CODE||PHONE | The data is derived from the receiver's contact person's record where PHONE_TYPE_CD='MOB'. |
FaxNb | CI_PER_PHONE | COUNTRY_CODE||PHONE | The data is derived from the receiver's contact person's record where PHONE_TYPE_CD='FAX'. |
EmailAdr | CI_PER | EMAILID | - |
RcvrIndvCtct | - | - | - |
NmPrfx | - | - | The data is derived from the NAMEPRFX characteristic of the receiver's individual contact person. |
Nm | CI_PER_NAME | ENTITY_NAME | The data is derived from the receiver's individual contact person's record where NAME_TYPE_FLG='PRIM'. |
PhneNb | CI_PER_PHONE | COUNTRY_CODE||PHONE | The data is derived from the receiver's individual contact person's record where PHONE_TYPE_CD='BUS'. |
MobNb | CI_PER_PHONE | COUNTRY_CODE||PHONE | The data is derived from the receiver's individual contact person's record where PHONE_TYPE_CD='MOB'. |
FaxNb | CI_PER_PHONE | COUNTRY_CODE||PHONE | The data is derived from the receiver's individual contact person's record where PHONE_TYPE_CD='FAX'. |
EmailAdr | CI_PER | EMAILID | - |
BllgStmt | - | - | - |
StmtId | - | - | Stores System Generated Value |
FrToDt | - | - | - |
FrDt | - | - | Stores Bill Extraction From Date |
ToDt | - | - | Stores Bill Extraction To Date |
CreDtTm | - | - | Stores Statement Creation Date and Time |
Sts | - | - | Stores Statement Status; Valid Values are - Original and Regenerated |
AcctChrtcs | - | - | - |
AcctLvl | - | - | - |
CshAcct | - | - | - |
Id | - | - | - |
IBAN | CI_ACCT_NBR | ACCT_NBR | The data is derived from the record where ACCT_NBR_TYPE_CD='IBAN'. |
Tp | - | - | - |
Cd | CI_ACCT | CUST_CL_CD | - |
Prtry | CI_CUST_CL_L | DESCR | - |
Ccy | CI_ACCT | CURRENCY_CD | - |
Nm | |||
AcctSvcr | - | - | The account servicer person is derived from the SRVPER characteristic of the division to which the account belongs. |
FinInstnId | - | - | - |
BICFI | CI_PER_ID | PER_ID_NBR | The data is derived from the account servicer person's record where ID_TYPE_CD='BIC'. |
Nm | CI_PER_NAME | ENTITY_NAME | The data is derived from the account servicer person's record where NAME_TYPE_FLG='PRIM'. |
PstlAdr | - | - | - |
Dept |
Note: The field mapping is not done for these tags. The implementation
team will have to map these tags to the appropriate fields.
|
||
SubDept | |||
StrtNm | |||
BldgNb | |||
PstCd | CI_PER | POSTAL | - |
TwnNm | CI_PER | CITY | - |
CtrySubDvsn | CI_PER | STATE | - |
Ctry | CI_PER | COUNTRY | - |
AdrLine | CI_PER | ADDRESS 1 to ADDRESS 4 | - |
PrntAcct | |||
Lvl | |||
Id | |||
Id | |||
IBAN | |||
Tp | |||
Cd | |||
Prtry | |||
Ccy | |||
Nm | |||
Svcr | |||
FinInstnId | |||
BICFI | |||
Nm | |||
PstlAdr | |||
Dept | |||
SubDept | |||
StrtNm | |||
BldgNb | |||
PstCd | |||
TwnNm | |||
CtrySubDvsn | |||
Ctry | |||
AdrLine | |||
CompstnMtd | - | - | The valid values are INVD, DEBTD, and DDBT. |
DbtAcct | - | - | - |
IBAN | CI_ACCT_APAY | EXT_ACCT_ID | - |
DelydDbtDt | CI_BILL | APAY_CRE_DT | - |
SttlmAdvc | CI_ACCT_MSG | - | The data is derived from the record where BILL_MSG_TYPE_FLG='S'. |
AcctBalCcyCd | CI_ACCT | CURRENCY_CD | - |
SttlmCcyCd | CI_ACCT | CURRENCY_CD | - |
HstCcyCd | CI_CIS_DIVISION | BASE_CURRENCY_CD | - |
Tax | - | - | - |
ClctnMtd | - | - | - |
Rgn | - | - | The data is derived from the TAXREG characteristic of the account. |
AcctSvcrCtct | - | - | - |
NmPrfx | - | - | The data is derived from the NAMEPRFX characteristic of the account servicer's contact person. |
Nm | CI_PER_NAME | ENTITY_NAME | The data is derived from the account servicer's contact person's record where NAME_TYPE_FLG='PRIM'. |
PhneNb | CI_PER_PHONE | COUNTRY_CODE||PHONE | The data is derived from the account servicer's contact person's record where PHONE_TYPE_CD='BUS' or 'HOME'. |
MobNb | CI_PER_PHONE | COUNTRY_CODE||PHONE | The data is derived from the account servicer's contact person's record where PHONE_TYPE_CD='BUS' or 'HOME'. |
FaxNb | CI_PER_PHONE | COUNTRY_CODE||PHONE | The data is derived from the account servicer's contact person's record where PHONE_TYPE_CD='BUS' or 'HOME'. |
EmailAdr | CI_PER | EMAILID | - |
CcyXchg | - | - | - |
SrcCcy | CI_BSEG_CALC_LN, CI_BSEG_CALC | NVL(CI_BSEG_CALC_LN.PRIC_CCY_CD, CI_BSEG_CALC.CURRENCY_CD) | - |
TrgtCcy | CI_BSEG_CALC | CURRENCY_CD | - |
XchgRate | CI_BSEG_CALC_LN | EXCHRATE | - |
UnitCcy | CI_BSEG_CALC | CURRENCY_CD | - |
QtnDt | CI_BILL | NVL(BILL.BILL_DT, BILL.CRE_DTTM) | - |
Compstn | |||
Tp | |||
Cd | |||
Val | |||
Amt | |||
Sgn | |||
CcyTp | |||
Svc | - | - | This section is added multiple times in the statement when different services are billed to the receiver (i.e. customer) in the statement cycle. |
SvcDtl | - | - | - |
BkSvc | - | - | - |
Id | CI_BILL_CHG | PRICEITEM_CD | - |
Desc | CI_PRICEITEM_L | DESCR | - |
Prtry | |||
SvcTp | CI_PRICEITEM_REL | MAX(PRICEITEM_PAR_CD) | The data is derived from the record where the price item is associated with the parent price item using the PRICEITEM_REL_TYPE_FLG='PROD'. |
Vol | CI_BSEG_CALC_LN | BILL_SQ | - |
Pric | - | - | - |
Ccy | CI_BSEG_CALC_LN, CI_BSEG_CALC | NVL(CI_BSEG_CALC_LN.PRIC_CCY_CD, CI_BSEG_CALC.CURRENCY_CD) | - |
UnitPric | - | - | - |
Amt | CI_BSEG_CALC_LN | VALUE_AMT, PRICE_AMT | - |
Sgn | - | - | The data is derived from VALUE_AMT or PRICE_AMT. |
Mtd | - | - | The method is derived. The valid values are - UPRC, FCHG, MCHG, MXRD, TIER and TPRC. |
PmtMtd | - | - | The payment method is derived. The valid values are FLAT, PVCH, INVS, and FREE. |
OrgnlChrgPric | |||
Amt | |||
Sgn | |||
OrgnlChrgSttlmAmt | - | - | - |
Amt | CI_TXN_CALC_LN | CALC_AMT | - |
Sgn | - | - | The data is derived from CALC_AMT. |
TaxRgn | - | - | - |
RgnNb | - | - | The data is derived from the TAXREG characteristic of the account. |
RgnNm | - | - | The data is derived from the TAXREG characteristic of the account. |
CstmrTaxId | - | - | The data is derived from the TAXID characteristic of the account. |
InvcNb | CI_BILL | BILL_ID | - |
MtdC | - | - | - |
SvcDtl | - | - | This section is added multiple times in the statement when different services are billed to the receiver (i.e. customer) in the statement cycle. |
BkSvc | - | - | - |
Id | CI_BILL_CHG | PRICEITEM_CD | - |
Desc | CI_PRICEITEM_L | DESCR | - |
SvcChrgAmt | - | - | - |
Amt | CI_BSEG_CALC_LN | CALC_AMT | Here, the amount is equal to the sum of service charge lines in the bill excluding the service charge lines with a tax distribution code (i.e. a distribution code where the TAXRATE characteristic is defined). The amount is expressed in the invoice currency of the account. |
Sgn | - | - | The data is derived based on the calculated amount. |
TaxClctn | - | - | - |
HstCcy | CI_CIS_DIVISION | BASE_CURRENCY_CD | - |
TaxblSvcChrgConvs | - | - | This section is added multiple times in the statement when different tax distribution codes are used for the service. |
SrcAmt | - | - | - |
Amt | CI_BSEG_CALC_LN | BASE_AMT | Here, the amount is equal to the sum of service charge lines with the same tax distribution code (i.e. a distribution code where the TAXRATE characteristic is defined). The amount is expressed in the invoice currency of the account. This calculated amount is used as a source for calculating the tax. |
Sgn | - | - | The data is derived based on the calculated amount. |
HstAmt | - | - | - |
Amt | CI_BSEG_CALC_LN | BASE_AMT | Here, the amount is equal to the sum of service charge lines with the same tax distribution code (i.e. a distribution code where the TAXRATE characteristic is defined). The amount is expressed in the division's base currency. |
Sgn | - | - | The data is derived based on the calculated amount. |
TtlTaxblSvcChrgHstAmt | - | - | - |
Amt | - | - | Here, the amount is equal to the sum of all taxable service charge lines. The amount is expressed in the division's base currency. |
Sgn | - | - | The data is derived based on the calculated amount. |
TaxId | - | - | This section is added multiple times in the statement when different tax distribution codes are used for the service. |
Nb | CI_BSEG_CALC_LN | DST_ID | - |
Desc | CI_DST_CODE_L | DESCR | - |
Rate | - | - | The data is derived from the TAXRATE characteristic of the distribution code. |
TtlTaxAmt | - | - | - |
Amt | CI_BSEG_CALC_LN | CALC_AMT | Here, the amount is equal to the sum of taxes charged due to the same tax distribution code. The amount is expressed in the division's base currency. |
Sgn | - | - | The data is derived based on the calculated amount. |
TtlTax | - | - | - |
Amt | CI_BSEG_CALC_LN | CALC_AMT | Here, the amount is equal to the sum total of all taxes charged to the receiver (i.e. customer). The amount is expressed in the division's base currency. |
Sgn | - | - | The data is derived based on the calculated amount. |
SttlmAmt | - | - | - |
Amt | CI_BSEG_CALC_LN | CALC_AMT | Here, the amount is equal to the sum total of all service charges and taxes billed to the receiver (i.e. customer). The amount is expressed in the invoice currency of the account. |
Sgn | - | - | The data is derived based on the calculated amount. |
TaxDueToRgn | - | - | - |
Amt | CI_BSEG_CALC_LN | CALC_AMT | Here, the amount is equal to the sum total of all taxes charged to the receiver (i.e. customer). The amount is expressed in the invoice currency of the account. |
Sgn | - | - | The data is derived based on the calculated amount. |
SvcAdjstmnt | - | - | - |
Tp | CI_ADJ_TYPE | ADJ_TYPE_CD | - |
Desc | CI_ADJ_TYPE_L | DESCR | - |
Amt | - | - | - |
Amt | CI_FT | CUR_AMT | - |
Sgn | - | - | The data is derived from CUR_AMT. |
ErrDt | CI_ADJ | CRE_DT | - |
AdjstmntId | CI_ADJ | ADJ_ID | - |
NewChrgAmt | - | - | - |
Amt | CI_FT | CUR_AMT | - |
Sgn | - | - | The data is derived from CUR_AMT. |