Name | Helptext Description | Data Type | Len | Codetable |
---|---|---|---|---|
INR | Internal Unique ID | Text | 8 | |
EXTKEY | External Key | Text | 24 | |
NAM | Name | Text | 40 | |
PTYTYP | Type of Party | Text | 15 | |
ACCUSR | User ID of Account Officer | Text | 8 | |
HBKACCFLG | Use Accounting of House Bank | Text | 1 | |
HBKCONFLG | Use Conditions of House Bank | Text | 1 | |
HBKINR | INR of Associated House Bank | Text | 8 | |
HEQACCFLG | Use HQ Account | Text | 1 | |
HEQCONFLG | Use Conditions of Headquarters | Text | 1 | |
HEQINR | INR of Associated Headquarters | Text | 8 | |
PRFCTR | Profit center | Text | 6 | |
RESUSR | Identifies Responsible User | Text | 8 | |
RSKCLS | Risk Class | Text | 6 | |
RSKCTY | Risk Country | Text | 2 | CTYTXT |
RSKTXT | Risk Textual Description | Text | 35 | |
UIL | Default Language for Communication | Text | 2 | |
VER | Version | Text | 4 | |
AKKBRA | AKK Business Area | Text | 3 | |
AKKCOM | AKK Company ID No. | Text | 8 | |
AKKREG | AKK Region Code | Text | 2 | AKKREG |
LIDCNDFLG | Special L/C Conditions for Party | Text | 1 | |
LIDMAXDUR | Maximum Duration of L/C | Numeric | 4 | |
TRDCNDFLG | Special Financing Conditions | Text | 1 | |
TRDTENTOT | Maximum total maturity | Numeric | 5 | |
TRDTENINI | Initial TR Tenor | Numeric | 5 | |
TRDTENEXT | Maximum Extension Tenor | Numeric | 5 | |
TRDEXTNMB | Maximum Number of Extensions | Numeric | 5 | |
BADCNDFLG | Special BA Conditions for Party | Text | 1 | |
BADTENEXT | Maximum maturity for Bankers Acceptance | Numeric | 4 | |
ADRSTA | Address Status | Text | 1 | Embedded |
SELTYP | Customer Specific Selling Rate Type | Text | 1 | RATTYP |
BUYTYP | Customer Specific Buying Rate Type | Text | 1 | RATTYP |
SLA | Service Level Agreement | Text | 6 | |
FNDINR | INR of Funding Party | Text | 8 | |
RSKCTY2 | Additional Risk Country | Text | 2 | CTYTXT |
RSKCTYOTH | Deviating Risk Country | Text | 1 | YESNO |
RSKINF | Further Information | Block | 90 | |
SGPFLG | Sanctioned Party | Text | 1 | |
ALADIMBRFLG | ALADI Member Flag | Text | 1 | |
ETGEXTKEY | Entitygroup | Text | 8 | |
GETFLDNRM | Field holding the normalized search fields. | Text | 100 | |
BILMAXPRC | Percent per Bill | Numeric | 5 | |
CIMCOVPRC | Credit Insurance Coverage Percentage | Numeric | 5 | |
CIMFLG | Credit Insured Flag | Text | 1 | |
CIMTOTAMT | Total Insured Amount | Numeric | 18 | |
CIMTOTCUR | Total Insured Currency | Text | 3 | CURTXT |
LOCINCORP | Location Where Incorporated | Text | 35 | |
MANREPFLG | Manual Repayment | Text | 1 |
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.
External key used to identify a party as unique.
This field contains a descriptive name of up to 40 characters to identify a the party.
A search can usually be done by entering parts of this field. All matches are usually displayed to facilitate selection.
N.B.: Each address in the database is associated with a party. The party refers to a legal entity. Each party has at least one address associated with it, but a party can have several addresses or locations.
This field defines the possible usages of a party
A party might be used as
A = Own address B = Bank C = Client S = Shipper F = Foreign O = Other X = Own Branch
Not all flags are available in all installations. To check which types are really available, see type checkboxes in Party Administration. Additional types may be defined there as well.
This field specifies the user ID of the account manager in charge of all dealings with this party and who negotiates the conditions, etc. with them.
Some parties may wish all transactions with them to be routed through their house banks.
In such a case, it would be more appropriate to use the account relationship we may have with the house bank for transactions involving either the inflow (debits) or outflow (credits) of funds, rather than using a direct account relationship with the client or by a third party institution.
This flag can be used to specify whether, in daily processing, the account relationship with the house bank is to be used.
Some parties may route all business through their house bank. This bank may insist that the special conditions, if any, granted to them should apply to all such transactions.
This flag can be used to specify whether, in daily processing, the special conditions, if any, granted to the house bank are to be applied.
Unique ID of the house bank for this party.
Some parties may wish all transactions with them to be routed through their headquarters.
In such a case, it would be more appropriate to use the accounts we may maintain with the headquarters for transactions involving either the inflow (debits) or outflow (credits) of funds, rather than using a direct account relationship with the particular address or by a third party institution.
This flag is used to specify whether, in daily processing, the HQ account is to be used.
Some parties may insist that the special conditions, if any, granted to them should apply to all such transactions.
This flag is used to specify whether, in daily processing, the special conditions, if any, granted to headquarters are to be applied.
This optional field may be used to specify the ID number of the headquarters of the party's address.
This field is used to assign a party to a profit center within the bank for statistical purposes.
This field is used to define the ID of the user responsible for processing the business related to the client.
This field is used to assign the party to a risk class for the purpose of risk management/limit control etc. The risk classes are freely definable as per user requirements.
This field is used to specify the country, under which the risks taken against this party are to be classified. If this field is not filled in then the risk is classified under the country of location of the party.
This field is used to describe the risk associated with this party.
This field is used to specify the default language used for correspondence generated.
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 is used to specify the Business Area Code of the Party. This information can be used for reporting purposes especially to the central bank.
This field is used to specify the registered company ID number for the Party. This information can be used for reporting purposes especially to the central bank.
This field is used to specify the region code (German: Bundeslandnummer) of the party. This information may be used for reporting purposes especially to the central bank.
Flag for special L/C Conditions for Party
This field sets the maximum allowed lifetime of an import LC for that party. If set to e.g. 100, the time between the issuance and the expiry date of an import L/C for that party must not exceed 100 days.
If the time exceeds the maximum allowed duration an error is displayed, when trying to enter a new import lc.
Using this flag, it can be designated whether the party selected has special financing terms and conditions.
In this field, the maximum financing period can be defined for the selected party. . This setting is independent of the finance type selected in the Loans busines sector and also includes possible financing prolongations.
The value defines the initial tenor in days of a postfinancing transaction.
Defines the maximum extension in days (for each extension of a postfinancing transaction).
Defines the maximum number of extensions to a postfinancing transaction.
Flag for special Bankers Acceptance conditions for Party
This field is used to define the maturity to be added to the start date for the party selected (the earliest date of all invoices submitted) when creating a Bankers Acceptance . Finance Type 'Bankers Acceptance' is available in business sectors Advances and Loans.
This field identifies the IT status of the party. If the field is empty, the party might be used as a normal party. Normally, it is a party loaded from the host system. If this field is not empty, the party is not loaded from the host system and should not be used for accounting purposes. It might be a locally created party (used in many contracts) or a temporarily created party (should normally be used in one contract).
Code | Text |
---|---|
T | Temporary |
Downloaded |
A customer-specific default rate type for credit bookings can be entered in this field .
A customer-specific default rate type for debit bookings can be entered in this field .
Service level for this address. Used in the Queue system to define and control processing times for different actions.
This field holds the external key of the owning entity group 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 group are visible to the user.
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.
INR of the OWN party, which acts as funder for this party.
Maximum percent per bill
Credit Insurance Coverage Percentage
Indicates whether Credit Insurance info is available
Total insurance amount of paired Supplier Buyer contract
Insurance currency of paired Supplier Buyer contract
Where the Party is legally Incorprated e.g. in the US, many companies are incorprated in Delaware. used in outgoing documents.
Flag for manual repayment
Additional risk country, used for compliance.
Deviating Risk Country used for compliance.
Further Information for compliance.
This checkbox can only be set when the 'alternative compliance' is activated in System Maintenance Configuration (DBxSYS). If a party is flagged as a Sanctioned Party, then all changes have to pass compliance checking.
Indicates if the party is a member of the ALADI Interbank Settlement system.
Note, this flag is applicable and enabled only for parties of type 'Bank'.