HCL Commerce Version 9.1.12.0 or later

SELLER_ORG_REQUEST

This table holds the details of the approval record.

Column Descriptions:

Name  Type  Description 
APPROVAL_ID INT4 NOT NULL Reference to the unique identifier for the approval record
ORGANIZATION_NAME TEXT Name of the seller organization
STORE_ID INT4 NOT NULL Store Id of the e-site against which the seller organization request is created
STORE_IDENTIFIER TEXT Identifier of the store against which the seller organization request is created.
SUBMITTER_EMAIL VARCHAR(50) Email of the submitted who created the seller organization request from store
ORGANIZATION_ADDRESS JSONB
Street address of the organization. The structure of jsonb : 
"organizationAddress": {
    "address1": Street address 1 for the seller organization,
    "address2": Street address 2 for the seller organization,
    "country": Country for the seller organization address,
    "city": City for the seller organization address,
    "state": State for the seller organization address,
    "zipCode": Zipcode for the seller organization address,
    "email1": Contact email of the seller organization
  }
ADMINISTRATORS JSONB
List of administrators who would manage the seller organization. Structure of jsonb : 
[    {
      "address": {
        "firstName": First name for the seller administrator,
        "lastName": Lastname for the seller administrator,
        "phone1": Contact phone for the seller administrator,
        "email1": Contact email for the seller administrator
      },
      "logonId": LogonId for the seller administrator,
      "password": Password for the seller administrator. The password will be encrypted before storing in the database
    }
 ]
DESCRIPTIONS JSONB
List of language translated descriptions for the seller organization. Structure of jsonb : 
:      [
    {
      "languageId": Language Id for the description,
      "displayName": Name of the seller,
      "description": Description of the seller
    }
]
MARKETPLACES JSONB
List of marketplaces mapped for the seller organization. Structure of jsonb : 
:       [
    {
      "id": Store Id,
      "identifier": Identifier for the store
    }
  ]
CATEGORIES JSONB
List of catalog filter Ids applicable for the seller organization. Structure of jsonb: 
[
   {
     "id": Catalog filter id
   }
]
CREATED_TIME TIMESTAMP Time when the seller organization request record is created.
UPDATED_TIME TIMESTAMP Time when the seller organization request record is updated. (Seller organization request details are updated).

Indexes:

Name  Column Names  Type 
SELLER_ORG_REQUEST_PKEY APPROVAL_ID Primary Key 

Constrained by parent tables:

Constraint Columns Parent Table Parent Columns Type
SELLER_ORG_REQUEST_APPROVAL_ID_FKEY APPROVAL_ID APPROVAL APPROVAL_ID Simple