Name | Helptext Description | Data Type | Len | Codetable |
---|---|---|---|---|
INR | Internal Unique ID | Text | 8 | |
OBJTYP | Main contract type | Text | 6 | |
OBJINR | INR of main contract | Text | 8 | |
CONSUBTYP | Main contract subtype | Text | 6 | |
ANTETY | allNETT entity | Text | 3 | |
ANTID | allNETT customer id | Text | 24 | |
ANTCSTREF | allNETT customer reference | Text | 20 | |
ANTDELTYP | allNETT contract type | Text | 3 | |
ANTDEALNO | allNETT contract reference | Text | 16 | |
ANTCREDELTYP | allNETT Deal Type of contract creation | Text | 3 | |
ANTLSTAMDNO | allNETT last amendment no | Numeric | 3 | |
ANTLSTSTLNO | allNETT last settlement no | Numeric | 3 | |
ANTLSTPOANO | allNETT last payment of acceptance no | Numeric | 3 | |
ANTLSTMSCNO | allNETT last miscellaneous no | Numeric | 3 | |
ANTLSTTFRNO | allNETT last transfer no | Numeric | 3 | |
ANTLSTTAMNO | allNETT last transfer amendment no | Numeric | 3 | |
ANTLSTBKFNO | allNETT last bookoff no | Numeric | 3 | |
ANTLSTEVTNO | allNETT last event no | Numeric | 3 | |
CSTPTAINR | INR of contract customer party address association | Text | 8 | |
EXTKEY | External Key | Text | 24 | |
NAM | Extkey Description | Text | 40 | |
ANTFINNO | Unique Finance Number | Numeric | 2 | |
ANA2NDFLG | allNETT ANA2ND Record Flag | Text | 1 | |
OBJOWNREF | Reference | Text | 16 | |
ANTGIPURP | Guarantee Purpose | Text | 4 | |
ANTLSTISDNO | allNETT last Draft no | Numeric | 3 | |
VER | Version | Text | 4 | |
ETYEXTKEY | Entity | Text | 8 | |
GETFLDNRM | Field holding the normalized search fields. | Text | 60 |
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.
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.
allNETT contractsubtype that identifies product variants (e.g. sight / deferred payment)
Entity ID in the linked allNETT instance
allNETT reference as assigned by the allNETT customer.
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 DOKA-NG).
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 DOKA-NG 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 DOKA-NG 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 DOKA-NG 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 DOKA-NG to allNETT.
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).
Field to identify an allNETT record. 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.
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.
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.
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 DOKA-NG to allNETT.
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.