ZF23INVAI - Addresses of participating partners
This database table consists of the following fields
Column Name | Status | Column definition | Technical term | Description |
|---|---|---|---|---|
AIKEY | required | VARCHAR(15) | Reference to ZF23INVHT.HTKEY | Unique auto generated identifier |
AIREF | required | DECIMAL(5, 0) | Reference ID to the Parent Table | Reference to the Head (“0”) or the line item (<> “0”) |
AITYPE | required | VARCHAR(35) | Code specifying the type of address | One of the codes in the table below to indicated what type of address is contained in this record |
AICNAME | optional | VARCHAR(256) | A contact point for a legal entity or person. | |
AIDNAME | optional | VARCHAR(50) | ||
AIFAX | required | VARCHAR(50) | A fax number for the contact point. | |
AIMAIL | required | VARCHAR(254) | An e-mail address for the contact point. | |
AITC | optional | VARCHAR(50) | The code specifying the type of trade contact | |
AITEL | required | VARCHAR(50) | A phone number for the contact point. |