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.

This field contains the reference number of the trust receipt. The reference number can contain up to 16 characters. and should be defined as a database key field to optimize performance. The field can also be used to search for a bill received from the database.

This field holds the name of the trust receipt loan displayed externally. The name can contain up to 40 characters and should be defined as a database key field to optimize performance.

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

This field contains the type of the parent contract.

This field contains the unique identifcation number of the parent contract.

This field holds the descriptive name of the parent contract.

This is the reference number of the parent contract.

This field holds the date a trust receipt loan was issued.

This field contains the date a trust receipt loan matures. Interest is charged until the maturity date.

This field contains the date of the last interest settlement.

This field holds the starting date of the trust receipt loan.

This field contains the date on which the past-due date is to start.

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.

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.

This field contains the tenure of the loan in figures.

This field displays the total number of days financed.

This field contains the surcharge on interest applied to a loan/financing contract.

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

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.

This field contains the base rate used to calculate interest.

This field contains the maximum number of extensions allowed under the financed contract.

This field contains the type of financing.

This field contains the financed portion in percent of the parent contract amount. If no parent contract is financed, this field is empty.

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.

This field indicates the risk country of the loan / financing. It is used for statistical reasons and allows the bank to evaluate the country risks it may have entered by issuing the financing.

This field specifies whether recourse can be claimed from the financing party.

This field specifies the special type of financing. Examples are: BA = purchase from reside, BB = purchase from non-reside, BC = Sale to resident, BD = Sale to non-resident

This field specifies the type of risk on which this financing is based. Examples are: BA = bank guarantee, CS = confirmed Standby L/C, CB = confirmed bank guarantee

The date from which the interest is calculated.

Costs of procuring the funds on the money market.

Date until which interest are calculated.

Additional Grace Days used for interest calculation.

The liquidity costs refer to the costs of the bank which occur in order to provide the neccessary liquidity.

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

The share of the overall interest rate booked as income in the bank's books. Is pre-defined and noted by rate type possible special terms and conditions.

Indicates whether the selected contract is a roll-over financing or not.

This table is defined on entity level with separate entries for each entity. This field holds the EXTKEY 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. 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.

This is the number of days computed from business date (today) to maturity/due date

Standard tenor of the party to the financing.

The Start Date of a Bankers Acceptance is calculated as the earliest invoice date of all registered invoices.

This field contains the internal unique ID of the corresponding BP contract.

Optional field, used for ECR financings.

This is the 6-digit number on the BA draft.

Possible draw down methods are: ECR-DLC ECR-DPO LPO CRS FIP

Date of the Transport Document

This field contains the converted total amount in local currency. If the conversion currency exists, then the conversion will be based on the middle rate. If no conversion currency exists, then this field will be set to zero.

This field contains the currency of the converted amount. The currency is normally determined by the system currency. This field is optional and may be blank.

The Financing period indicates the duration of the finance / loan.

The duration / period commences on the Financing Start Date and ends on the Financing Due Date. In case Grace days have been given, these will be added to the duration / period. If the calculated Financing Due Date falls on a holiday or a non-working day, the next working day would be considered as the End date for the financing period calculation. Both the start date and the calculated Financing Due Date date are taken into account for the calculation of the financing period.

If checkbox is checked, the costumer wants the bank to pay the supplier on their behalf.

Contract status flag. If not empty, the contract has been reserved and only a few basic fields have to be filled in.

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.

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.

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.

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.

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

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.

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

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

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

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

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

To select from the list of available Incoterms.

This field refers to the published version of the Incoterms.

If the checkbox is selected, it opens the shipment details panel where details of the shipment are to be provided.

This field contains the past due stage of the loan as specified in the ETG / ETY setting for the finance type.

This field specifies the date when the loan becomes past due according to the ETG/ ETY settings.

This field specifies the interest of a past due loan that has to be capitalized.

Open Interest Amount: Pending TRCX commission amount which is yet to be settled.

Open Past Due Interest: Pending TRCXPD commission amount which are yet to be settled.

The share of Past due total interest if contract moves to Past due status. It is/ can be pre-defined from fee setup of past due commission.

Currency of the converted amount. This currency is usually set from SYSCUR. This field is an optional field and may be empty, if no converted amount of the specific balance is known.

Currency of the converted amount. This currency is usually set from SYSCUR. This field is an optional field and may be empty, if no converted amount of the specific balance is known.