Name | Helptext Description | Data Type | Len | Codetable |
---|---|---|---|---|
INR | Internal Unique ID | Text | 8 | |
OWNREF | Own Reference | Text | 16 | |
NAM | Name | Text | 80 | |
CREDAT | Date Created | Date | 12 | |
PNTTYP | Parent Contract Type | Text | 6 | |
PNTINR | Parent Contract INR | Text | 8 | |
PNTNAM | Name of Parent Contract | Text | 40 | |
PNTREF | Parent Reference | Text | 16 | |
ISSDAT | Date Issued | Date | 12 | |
MATDAT | Maturity Date | Date | 12 | |
LSTINTDAT | Last Interest Settlement | Date | 12 | |
STTTENDAT | Start Date Tenor | Date | 12 | |
SPDDAT | Start Past-due Date | Date | 12 | |
OPNDAT | Opening Date | Date | 12 | |
CLSDAT | Date Closed | Date | 12 | |
TENDAY | Tenor Days | Numeric | 5 | |
ACTFINDAY | Actual Financed Days | Numeric | 5 | |
INTRAT | Surcharge Applied to Interest Rate | Numeric | 14 | |
OWNUSR | Responsible User | Text | 8 | <fixed-length> |
VER | Version | Text | 4 | |
IRTCOD | Base Rate | Text | 6 | IRTTXT |
EXTNMB | Number of Extensions | Numeric | 4 | |
FINTYP | Type of Financing | Text | 3 | Embedded |
PCTFIN | % Financed | Numeric | 5 | |
STAGOD | Goods Code (for Statistics) | Text | 6 | GODCOD |
STACTY | Country Code (for Statistics) | Text | 2 | CTYTXT |
FINRECFLG | Recourse Flag | Text | 1 | |
FINSUBTYP | Special type of financing | Text | 2 | Embedded |
FINRSKTYP | Type of risk | Text | 2 | Embedded |
BEGINTDAT | Interest Start Date | Date | 12 | |
CSHRAT | Cash Base | Numeric | 14 | |
ENDINTDAT | Interest Due Date | Date | 12 | |
GRADAY | Grace Days | Numeric | 2 | |
LQDRAT | Liquidity costs | Numeric | 14 | |
OPNTRNINR | TRNINR which opened contract | Text | 8 | |
OWNRAT | Our margin | Numeric | 14 | |
ROLOVRFLG | Roll-Over Financing | Text | 1 | |
SHPFRO | Shipment from | Text | 65 | |
SHPFRO23 | Shipment from | Text | 140 | |
PORLOA | Port of Loading | Text | 65 | |
PORLOA23 | Port of Loading | Text | 140 | |
PORDIS | Port of Discharge | Text | 65 | |
PORDIS23 | Port of Discharge | Text | 140 | |
SHPTO | For Transportation to | Text | 65 | |
SHPTO23 | For Transportation to | Text | 140 | |
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 | |
PSTDUESTG | Past Due Stage | Text | 3 | Embedded |
PSTDUEDAT | Past Due Date set in TRTLAT | Date | 12 | |
INTCAPFLG | Interest To Be Capitalized | Text | 1 | |
TRXAMT | Open Interest Amount | Numeric | 18 | |
TRXRFBAMT | Forwarded Refinancing Interest Amount | Numeric | 18 | |
PDURAT | Pastdue Margin | Numeric | 14 | |
TRXCUR | Currency of Open Interest Amount | Text | 3 | |
TRXRFBCUR | Currency of Forwarded Refinancing Interest Amount | Text | 3 | |
ETYEXTKEY | Entity holding Contract | Text | 8 | |
BACRMNDAY | BA remaining financing tenor days | Numeric | 4 | |
BACSTDTEN | Standard tenor | Numeric | 3 | |
BACUSADAT | Bill/ Usance Start Date | Date | 12 | |
BPDINR | INR of corresponding BP contract | Text | 8 | |
DRWVOCNUM | draft serial number | Text | 6 | |
ECRMET | Draw down method for ECR | Text | 3 | Embedded |
ECRTRDDAT | Transport Document Date | Date | 12 | |
FINAMT | Financed amount (bankers acceptance) | Numeric | 18 | |
FINCUR | Currency of the financed amount | Text | 3 | |
INTDAY | Financing period | Numeric | 4 | |
PAYSUPFLG | Pay supplier | Text | 1 | |
RESFLG | Reserved Contract | Text | 1 | Embedded |
PRDCOD | Product Code | Text | 6 | PRDCOD |
PRDSUB | Product Subtype | Text | 6 | PRDSUB |
PRDVAR | Product Variant | Text | 6 | PRDVAR |
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.
Code | Text |
---|---|
TRF | Trust Receipt |
LOA | Clean Loan |
PCL | Packing credit |
BEL | Export Loan |
BAA | Bankers Accept. |
ECR | ECR Financing |
OTH | Other |
RFI | Int.Refinancing |
RFN | Refinancing |
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
Code | Text |
---|---|
BA | Purchase fr. resident |
BB | Purchase fr. non-resident |
BC | Sale to resident |
BD | Sale to non-resident |
OE | Overhead Expenses |
DP | Domestic Purchase |
FP | Foreign Purchase |
BE | Export L/C Documents |
BR | Import L/C Documents |
BI | Import Collection |
BO | Export Collection |
DA | Accepted Draft |
DU | Unaccepted Draft |
IN | Invoice |
OT | Other |
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
Code | Text |
---|---|
BA | Bankaval |
CS | Confirmed Standby LC |
CB | Confirmed Bank Guarantee |
US | Unconfirmed Standby LC |
UB | Unconfirmed Bank Guarantee |
DI | Credit Issuance |
II | Indirect Insurance |
EA | Export Credit Agency |
LI | Import Letter of Credit |
DA | Draft avalized by us |
CE | Confirmed Export LC |
CO | Corporate |
UE | Unconfirmed Export LC |
BR | Bank Risk |
SI | Standby LC issued by us |
GI | Guarantee issued by us |
OT | Other |
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
Code | Text |
---|---|
DLC | ECR-DLC |
DPO | ECR-DPO |
LPO | LPO |
CRS | CRS |
FIP | 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.
Code | Text |
---|---|
Normal Contract | |
X | Reserved Contract |
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.
Code | Text |
---|---|
CIF | CIF |
CFR | CFR |
FOB | FOB |
FCA | FCA |
FAS | FAS |
CPT | CPT |
CIP | CIP |
DAF | DAF |
DDP | DDP |
DDU | DDU |
DES | DES |
DEQ | DEQ |
EXW | EXW |
DPU | DPU |
This field refers to the published version of the Incoterms.
Code | Text |
---|---|
1 | Incoterm Version 2010 |
2 | Incoterm Version 2000 |
3 | Incoterm Version 2020 |
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.
Code | Text |
---|---|
GRA | Grace |
PDU | Past Due |
NPF | Non Performance |
WOF | Write Off |
Not Past Due | |
NPM | Non Performance |
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.