ALEX_ADDITIONAL_USER_EXPORT (Attributes)

Column Source Data type Null Description
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.