| 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.
|