Name | Description | Data Type | Len | Dec. | View lines | View type | Inst. | Visible | Codetable |
---|---|---|---|---|---|---|---|---|---|
INR | Internal unique id of allNETT/RIVO contract record | Text | 8 | 1 | Edit | Yes | Public | ||
OBJTYP | Main contract type | Text | 6 | 1 | Edit | Yes | Public | ||
OBJINR | INR of main contract | Text | 8 | 1 | Edit | Yes | Public | ||
CONSUBTYP | Main contract subtype | Text | 6 | 1 | Edit | Yes | Public | ||
ANTETY | allNETT/RIVO entity | Text | 3 | 1 | Edit | Yes | Public | ||
ANTID | allNETT/RIVO customer id | Text | 24 | 1 | Edit | Yes | Public | ||
ANTCSTREF | allNETT/RIVO customer reference | Text | 20 | 1 | Edit | Yes | Public | ||
ANTDELTYP | allNETT/RIVO contract type | Text | 3 | 1 | Edit | Yes | Public | ||
ANTDEALNO | allNETT/RIVO contract reference | Text | 16 | 1 | Edit | Yes | Public | ||
ANTCREDELTYP | allNETT/RIVO Deal Type of contract creation | Text | 3 | 1 | Edit | Yes | Public | ||
ANTLSTAMDNO | allNETT/RIVO last amendment no | Numeric | 3 | 0 | Edit | Yes | Public | ||
ANTLSTSTLNO | allNETT/RIVO last settlement no | Numeric | 3 | 0 | Edit | Yes | Public | ||
ANTLSTPOANO | allNETT/RIVO last payment of acceptance no | Numeric | 3 | 0 | Edit | Yes | Public | ||
ANTLSTMSCNO | allNETT/RIVO last miscellaneous no | Numeric | 3 | 0 | Edit | Yes | Public | ||
ANTLSTTFRNO | allNETT/RIVO last transfer no | Numeric | 3 | 0 | Edit | Yes | Public | ||
ANTLSTTAMNO | allNETT/RIVO last transfer amendment no | Numeric | 3 | 0 | Edit | Yes | Public | ||
ANTLSTBKFNO | allNETT/RIVO last bookoff no | Numeric | 3 | 0 | Edit | Yes | Public | ||
ANTLSTEVTNO | allNETT/RIVO last event no | Numeric | 3 | 0 | Edit | Yes | Public | ||
CSTPTAINR | INR of relevant allNETT/RIVO customer | Text | 8 | 1 | Edit | Yes | Public | ||
EXTKEY | External Key | Text | 24 | 1 | Edit | Yes | Public | ||
NAM | Extkey Description | Text | 40 | 1 | Edit | Yes | Public | ||
ANTFINNO | Unique Finance Number | Numeric | 2 | 0 | Edit | Yes | Public | ||
ANA2NDFLG | allNETT/RIVO ANA2ND Record Flag | Text | 1 | 1 | Edit | Yes | Public | ||
OBJOWNREF | Reference | Text | 16 | 1 | Edit | Yes | Public | ||
ANTGIPURP | Guarantee Purpose | Text | 4 | 1 | Edit | Yes | Public | ||
ANTLSTISDNO | allNETT/RIVO last Draft no | Numeric | 3 | 0 | Edit | Yes | Public | ||
VER | Version Counter | Text | 4 | 1 | Edit | Yes | Public | ||
ETYEXTKEY | Main contract entity | Text | 8 | 1 | Edit | Yes | Public | ||
GETFLDNRM | Field holding the normalized search fields | Text | 60 | 1 | Edit | Yes | Public |
Name | Fields | Properties |
---|---|---|
ANA_ANTDEALTYP | ANTETY, ANTID, ANTCSTREF, ANTDELTYP, ANTDEALNO | |
ANA_INR | INR | Unique |
ANA_OBJINR | OBJTYP, OBJINR, CONSUBTYP |
/
INR
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 ANA. The field INR is used to maintain links from other tables into this table.
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.
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 ANA. The field INR is used to maintain links from other tables into this table.
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 ANA. The field INR is used to maintain links from other tables into this table.
Type of contract the ANA entry refers to. This is the table the contract is stored in.
Type of contract the ANA entry refers to. This is the table the contract is stored in.
INR of the contract within the table, defined in OBJTYP.
INR of the contract within the table, defined in OBJTYP.
allNETT contractsubtype that identifies product variants (e.g. sight / deferred payment)
allNETT contractsubtype that identifies product variants (e.g. sight / deferred payment)
Entity ID in the linked allNETT instance
Entity ID in the linked allNETT instance
allNETT reference as assigned by the allNETT customer.
allNETT reference as assigned by the allNETT customer.
ID of the business sector in allNETT (e.g. import L/C in allNETT is “01”).
ID of the business sector in allNETT: 01 = Import LC 02 = Outgoing Guarantee (suffix: I = International, D = Domestic, S = Standby) 03 = Import collection 06 = Outgoing Remittance 11 = Export LC 12 = Incoming Guarantee 13 = Export Collection 16 = Incoming Remitance 22 = Shipping Guarantee
Contract reference in allNETT as assigned by the back end (i.e. OWNREF from DNG).
Contract reference in allNETT as assigned by the back end (i.e. OWNREF from DOKA-NG).
allNETT deal amendment no. counter. Is raised with every xxAME message send from DNG to allNETT.
allNETT deal amendment no. counter. Is raised with every xxAME message send from DOKA-NG to allNETT.
allNETT deal sight settlement no. counter. Is raised with every xxPAY message send from DNG to allNETT.
allNETT deal sight settlement no. counter. Is raised with every xxPAY message send from DOKA-NG to allNETT.
allNETT deal deferred payment no. counter. Is raised with every xxPOA message send from DNG to allNETT.
allNETT deal deferred payment no. counter. Is raised with every xxPOA message send from DOKA-NG to allNETT.
allNETT deal freeformat message counter. Is raised with every xxMSC message send from DNG to allNETT.
allNETT deal freeformat message counter. Is raised with every xxMSC message send from DOKA-NG to allNETT.
allNETT deal transfer no. counter. Is raised with every xxTRF message send from DNG to allNETT.
allNETT deal transfer no. counter. Is raised with every xxTRF message send from DOKA-NG to allNETT.
allNETT deal transfer amendment no. counter. Is raised with every transfer xxAME message send from DNG to allNETT.
allNETT deal transfer amendment no. counter. Is raised with every transfer xxAME message send from DOKA-NG to allNETT.
allNETT deal bookoff counter. Is raised with every xxBKF message send from DNG to allNETT.
allNETT deal bookoff counter. Is raised with every xxBKF message send from DOKA-NG to allNETT.
allNETT deal event no. counter. Is raised with every xxEVT message send from DNG to allNETT.
allNETT deal event no. counter. Is raised with every xxEVT message send from DOKA-NG to allNETT.
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.
allNETT customer main ID (as stored in ADR\ANTID).
allNETT customer main ID (as stored in ADR\ANTID).
Field to identify an allNETT record. This field is set from ANTDEALNO.
Field to identify an allNETT record. This field is set from ANTDEALNO.
Long readable description of the EXTKEY. This field is set from ANTDEALNO.
Long readable description of the EXTKEY. This field is set from ANTDEALNO.
Field holding the concatenated and normalized sum of all search fields used by quick search. This is one of the fields set in a SdbSetNRMFields method defined in the table definition module.
Field holding the concatenated and normalized sum of all search fields used by quick search. This is one of the fields set in a SdbSetNRMFields method defined in the table definition module.
ID to uniquely idetntif each finance sub deal within each deal.
ID to uniquely idetntif each finance sub deal within each deal.
If set, the ANA Record is a 2nd ANA record for an existing DOKA Contract.
Used in Sector Guarantees where Applicant AND Beneficiary are both allNETT customers of the Bank.
In this case two ANA records pointing to the same record (via OBJINR / OBJTYP) exists. With flag being empty is the ANA Record for the Applicant. With Flag being set is the ANA Record for the Beneficiary.
If set, the ANA Record is a 2nd ANA record for an existing DOKA Contract.
Used in Sector Guarantees where Applicant AND Beneficiary are both allNETT customers of the Bank.
In this case two ANA records pointing to the same record (via OBJINR / OBJTYP) exists. With flag being empty is the ANA Record for the Applicant. With Flag being set is the ANA Record for the Beneficiary.
This field contains the reference number of the guarantee being established. The reference number can have a maximum size of 16 characters. This field can be used to search for any guarantee from the database.
This field contains the reference number of the guarantee being established. The reference number can have a maximum size of 16 characters. This field can be used to search for any guarantee from the database.
Filled with Guarantee Purpose. ISSU or ISCO when ANA record is initially being created (either by incoming allNETT Message or from GITOPN.
Filled with Guarantee Purpose. ISSU or ISCO when ANA record is initially being created (either by incoming allNETT Message or from GITOPN.
ID of the business sector in allNETT (e.g. import L/C in allNETT is “01”) upon contract creation.
Normally ANTCREDELTYP and ANTDELTYP are equal.
But in case a shipping guarantee is requested for a not yet received import collection, the ANTDELTYP is 03 and CREDELTYP is 22.
ID of the business sector in allNETT (e.g. import L/C in allNETT is “01”) upon contract creation.
Normally ANTCREDELTYP and ANTDELTYP are equal.
But in case a shipping guarantee is requested for a not yet received import collection, the ANTDELTYP is 03 and CREDELTYP is 22.
allNETT draft no. counter. Is raised with every draft message send from DNG to allNETT.
allNETT draft no. counter. Is raised with every draft message send from DOKA-NG to allNETT.
This field holds the version counter to keep track of the version history of an ANA entry. The individual versions are controlled by entries in the SLG table.
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.