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
  • 1 = Active
  • 0 = Inactive

*System required field

** Combination of (pr_vendor_type_ekey, address_ekey) must be unique