ALEX_PR_VENDOR (Staging table)
| Column name | Data type | Required | Default update able | Data target | Comments |
|---|---|---|---|---|---|
| PR_VENDOR_TYPE_EKEY** | VARCHAR (255) | Yes* | No | ALPR_VENDOR.VENDOR_TYPE_ID | Payment Request vendor type external key |
| ADDRESS_EKEY** | VARCHAR (255) | Yes* | No | ALPR_VENDOR.ADDRESS_ID | Address external key |
| ACTIVE_STATUS | SMALLINT | Yes* | Yes | ALPR_VENDOR.VENDOR_ACTIVE_STATUS | Determines whether vendor address is active
|
*System required field
** Combination of (pr_vendor_type_ekey, address_ekey) must be unique