en:app:030bsi:040cp:0900cpd

CPD - Clean Payment Data

Module CPD


Datafields

Name Helptext Description Data Type Len Codetable
INR Internal Unique ID Text 8
OWNREF Own Reference Text 16
NAM Name Text 80
PYENAM Payee Text 40
PYEREF Payee Reference Text 16
PYBNAM Paying Bank Text 40
PYBREF Paying Bank Reference Text 16
ORCNAM Ordering Customer Text 40
ORCREF Ordering Customer Reference Text 16
ORINAM Ordering Institution Text 40
ORIREF Ordering Institution Reference Text 16
OPNTRNINR TRNINR which opened contract Text 8
VALDAT Value Date Date 12
OPNDAT Opening Date Date 12
CLSDAT Date Closed Date 12
CHATO Our fees to be debited to Text 1 CHADET
CREDAT Date Created Date 12
OWNUSR Responsible User Text 8
VER Version Text 4
DETCHGCOD Details of Charges Text 3 Embedded
PAYTYP Payment Type Text 1 Embedded
STAGOD Goods Code (for Statistics) Text 6 GODCOD
STACTY Country Code (for Statistics) Text 2 CTYTXT
ANTINCBENACC Beneficiary Account No. Text 34
SHPFRO Shipment from Text 65
PORLOA Port of Loading Text 65
PORDIS Port of Discharge Text 65
SHPTO For Transportation to Text 65
TRPDOCTYP Transport Document Type Text 6
TRPDOCNUM Transport Document Number Text 40
TRADAT Date of Transport Document Date 12
TRAMOD Mode of Transport Text 6
INCTRMCOD Incoterm Code Text 3 Embedded
INCTRMVER Incoterm Version Text 1 Embedded
SHPFLG Provide Shipment Details Text 1
ETYEXTKEY Entity Text 8
PRDCOD Product Code Text 6 PRDCOD
PRDSUB Product Subtype Text 6 PRDSUB
PRDVAR Product Variant Text 6 PRDVAR

Datafield Description and Properties


Datafield INR Internal Unique ID

Unique internal ID of a record within the table. The INR is a text field, which is created by retrieving the next valid entry from the counter of this table. The field INR is used to enable links from other tables to this table.

For contractdata the INR also links the two tables xxD and xxT as associated entries hold the same INR.


Datafield OWNREF Own Reference

This field contains the reference number of the clean payment


Datafield NAM Name

This field holds the descriptive name displayed in the application to describe and to search for a contract. Within the default configuration this field is set by a default rule based on contract amount and main party and is not modifiable by the user.


Datafield PYENAM Payee

This field contains the descriptive name of the payee


Datafield PYEREF Payee Reference

This field contains the reference number of the payee


Datafield PYBNAM Paying Bank

This field contains the descriptive name of the paying bank


Datafield PYBREF Paying Bank Reference

This field contains the reference number of the paying bank


Datafield ORCNAM Ordering Customer

This field contains the descriptive name of the customer placing the order.


Datafield ORCREF Ordering Customer Reference

This field contains the reference number of the customer placing the order.


Datafield ORINAM Ordering Institution

This field contains the descriptive name of the institution placing the order.


Datafield ORIREF Ordering Institution Reference

This field contains the reference number of the institution placing the order.


Datafield OPNTRNINR TRNINR which opened contract

This field holds the INR of the transaction which opened/issued the contract.


Datafield VALDAT Value Date

This field contains the value date of the clean payment


Datafield OPNDAT Opening Date

The field holds the opening/issuing date of the contract. If this field is set, the contract has been legally established and it might be used for business transactions. This date describes the point in time when this contract became legally binding. This might be a date prior to the creation date, when the contract was legally binding before it was stored in the database.


Datafield CLSDAT Date Closed

This fields indicates the closing date of a contract. If an entry has been made, the contract is closed and may no longer be used to process business transactions except special transactions like Settling Charges or Common Messages.


Datafield CHATO Our fees to be debited to

This field defines whether the fees and commissions of the bank using using the application are to be 'borne by client' (='U'), 'borne by' (='B') or borne by other parties. Depending on the selection made in this field, the roles in the second settlement table (own commission / fees) are proposed.

Meaning of 'borne by client' on incoming payment: If, in the fee settlement field, 'borne by client' was selected or if the field is not completed, then own fees will be proposed in the settlement to the debit of the payee is proposed.

Meaning of 'borne by client' on outgoing or transitory payment: Own fees in the settlement are proposed to the debit of the applicant SIDE

Meaning of 'borne by abroad ' on incoming payment: Own fees in the settlement are proposed to the debit of the applicant SIDE

Meaning of 'borne by abroad' on outgoing or transitory payment: Own fees in the settlement are proposed to the debit of the payee

Meaning of 'Others': No role is proposed on the fees in the settlement panel.


Datafield CREDAT Date Created

This date field identifies the date the entry was physically added to the database.


Datafield OWNUSR Responsible User

This field holds the User ID of the person responsible for handling this contract.


Datafield VER Version

This field holds the version counter used to keep track of the history of an entry of this table. The individual versions are managed by entries in the SLG table.


Datafield DETCHGCOD Details of Charges

This field defines which side of the clean payment has to pay the charges.

Depending on the selection and the type of the clean payment field 'Our Charges to' is defaulted by the correct party of the bank.

Codetable
Code Text
BEN Beneficiary Customer
OUR Ordering Customer
SHA Shared

Datafield PAYTYP Payment Type

This field contains the payment type of the clean payment

Codetable
Code Text
I Incoming Payment
O Outgoing Payment
T Transit Payment

Datafield STAGOD Goods Code (for Statistics)

This field contains the type of goods shipped. The goods code is used to evaluate contracts by the type of goods. The codetable can be customized by the bank according to their needs.


Datafield STACTY Country Code (for Statistics)

This field can be used for statistical reasons.


Datafield ETYEXTKEY Entity

This field holds the external key of the owning entity to identify the logical owner of this entry.

This field is filled automatically during insert and is used as filter when accessing the database. Without special implementation only entries of the currently active entity are visible to the user.


Datafield PRDCOD Product Code

Initial version to support the differentiation of predefined bank products cross business sectors. This organizational solution is made up of three fields PRDCOD, PRDSUB and PRDVAR providing a bank product, a sub differentiation and individual variants if needed. Here the PRDCOD shall identify the business sector together with some key criteria like confirmed or unconfirmed LC in a cross business sectors unique identification.


Datafield PRDSUB Product Subtype

Initial version to support the differentiation of predefined bank products cross business sectors. This organizational solution is made up of three fields PRDCOD, PRDSUB and PRDVAR providing a bank product, a sub differentiation and individual variants if needed. Here the PRDSUB shall identify the business sector specific bankside defined products adding some key sub criteria in a cross business sectors unique identification.


Datafield PRDVAR Product Variant

Initial version to support the differentiation of predefined bank products cross business sectors. This organizational solution is made up of three fields PRDCOD, PRDSUB and PRDVAR providing a bank product, a sub differentiation and individual variants if needed. Here the product variant is intended as possible extension to setup specific variants below the product and subproduct code.


Datafield ANTINCBENACC Beneficiary Account No.

Beneficiaries Account number as stored in allNETT.


Datafield SHPFRO Shipment from

This field specifies the place of transfer (in the case of a multimodal transport document), the place of receipt (in the case of a road, rail or inland waterway transport document or a courier or express delivery service document), the place of dispatch or the place of shipment to be indicated on the transport document.


Datafield PORLOA Port of Loading

This field specifies the port or airport of departure indicated on the transport document.


Datafield PORDIS Port of Discharge

This field contains the port or airport of destination, where the goods shipped under the L/C are unloaded. This is not necessarily the place of delivery.


Datafield SHPTO For Transportation to

This field specifies the final destination of the goods shipped under the underlying contract.


Datafield TRPDOCTYP Transport Document Type

This field indicates the type of transport document (e.g. bill of lading, air waybill etc).


Datafield TRPDOCNUM Transport Document Number

This field indicates the unique reference number assigned to the transport document (e.g. bill of lading number or air waybill number).


Datafield TRADAT Date of Transport Document

This field indicates the date the transport document (e.g. bill of lading, air waybill) was issued.


Datafield TRAMOD Mode of Transport

This field indicates how the goods have been shipped (e.g. via sea, or air or a combination of different transport modes).


Datafield INCTRMCOD Incoterm Code

To select from the list of available Incoterms

Codetable
Code Text
CIF CIF
CFR CFR
FOB FOB
FCA FCA
FAS FAS
CPT CPT
CIP CIP
DAP DAP
DDP DDP
DDU DDU
DES DES
DEQ DEQ
EXW EXW
DPU DPU
DAF DAF
DAT DAT

Datafield INCTRMVER Incoterm Version

This field refers to the published version of the Incoterms.

Codetable
Code Text
1 Incoterm Version 2010
2 Incoterm Version 2000
3 Incoterm Version 2020

Datafield SHPFLG Provide Shipment Details

Marks, if shipment details have to be provided or not. Only if the flag is ticked panel shipment details is open for entry of any data.

en/app/030bsi/040cp/0900cpd.txt · Last modified: 2022/12/09 15:47 (external edit)