| exau_fields_export_id |
|
int |
N |
A unique Bob ID to use as PK. |
| Exau_export_hdr_id |
|
int |
Y |
FK reference to the corresponding header ID. |
| Exau_export_hdr_type |
|
SMALLINT |
N |
One of the following four values: 1 = ER Export Header 2 = TP Export Header 3 = TS Export Header 5 = Payment Request Export Header |
| exau_auth_amount |
alco_user - auth_amount |
NUMERIC (20,10) |
Y |
Signing authority amount used by the routing rules. Based on auth_amount column of alco_user table. |
| Exau_auth_amount_ currency |
|
VARCHAR (10) |
Y |
The ISO code of the currency used for the er_user_auth_ mount. |
| Exau_pr_auth_amount |
alco_user - pr_auth_amount |
Numeric (20,10) |
Y |
PR signing authority amount. Based on pr_auth_amount column of alco_user table. |
| Exau_pr_auth_amount_currency |
|
VARCHAR (10) |
Y |
The ISO code of the currency used for the pr_auth_amount. |
| Exau_system_code_1 |
alco_user - system_code_1 |
VARCHAR (255) |
Y |
System code 1 (can be user defined). From column system_code_1 in table alco_user. |
| Exau_system_code_2 |
alco_user - system_code_2 |
VARCHAR (255) |
Y |
System code 2 (can be user defined) From column system_code_2 in table alco_user. |
| Exau_system_code_3 |
alco_user - system_code_3 |
VARCHAR (255) |
Y |
System code 3 (can be user defined) From column system_code_3 in table alco_user. |
| Exau_system_code_4 |
alco_user - system_code_4 |
VARCHAR (255) |
Y |
System code 4 (can be user defined) From column system_code_4 in table alco_user. |
| Exau_system_code_5 |
alco_user - system_code_5 |
VARCHAR (255) |
Y |
System code 5 (can be user defined) From column system_code_5 in table alco_user. |
| Exau_system_code_6 |
alco_user - system_code_6 |
VARCHAR (255) |
Y |
System code 6 (can be user defined) From column system_code_6 in table alco_user. |
| Exau_system_code_7 |
alco_user - system_code_7 |
VARCHAR (255) |
Y |
System code 7 (can be user defined) From column system_code_7 in table alco_user. |
| Exau_system_code_8 |
alco_user - system_code_8 |
VARCHAR (255) |
Y |
System code 8 (can be user defined). From column system_code_8 in table alco_user. |
| Exau_start_date |
alco_user - start_date |
datetime |
Y |
User start date (hiring date). From column start_date in table alco_user. |
| Exau_end_date |
alco_user - end_date |
datetime |
Y |
User end date (termination date). From column end_date in table alco_user. |
| Exau_system_date_1 |
alco_user - system_date_1 |
datetime |
Y |
System date 1 (can be user defined). From column system_date_1 in table alco_user. |
| EXAU_SYStEM_DATE_2 |
alco_user - system_date_2 |
datetime |
Y |
System date 2 (can be user defined). From column system_date_2 in table alco_user. |
| AUTH_AMOUNT_ CURRENCY_EKEY |
alco_user - auth_amount_id |
VARCHAR (255) |
Y |
External key identifying the authorized amount currency for the user. |
| PR_AUTH_AMOUNT_ CURRENCY_EKEY |
alco_user - pr_auth_ amount_id |
VARCHAR (255) |
Y |
External key identifying the PR authorized amount currency for the user. |