Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
---|---|---|---|---|---|---|---|---|
ad_client_id | numeric | 10 | null |
|
|
|||
ad_org_id | numeric | 10 | null |
|
|
|||
created | timestamp | 29,6 | statement_timestamp() |
|
|
|||
createdby | numeric | 10 | null |
|
|
|||
description | varchar | 255 | √ | NULL::character varying |
|
|
||
hostaddress | varchar | 60 | null |
|
|
|||
hostport | numeric | 10 | null |
|
|
|||
isactive | bpchar | 1 | 'Y'::bpchar |
|
|
|||
name | varchar | 60 | null |
|
|
|||
proxyaddress | varchar | 60 | √ | NULL::character varying |
|
|
Constraint Name | Type | Sort | Column(s) |
---|---|---|---|
x_shippingprocessor_key | Primary key | Asc | m_shippingprocessorcfg_id |
m_shippingprocessorcfg_uu_idx | Must be unique | Asc | m_shippingprocessorcfg_uu |
x_shippingproc_unique_columns | Must be unique | Asc/Asc/Asc | ad_client_id + ad_org_id + name |