Field Index | SQL Mapping |
Type | Field Name |
---|---|
poid | PIN_FLD_POID |
timestamp | PIN_FLD_CREATED_T |
timestamp | PIN_FLD_MOD_T |
string | PIN_FLD_READ_ACCESS |
string | PIN_FLD_WRITE_ACCESS |
string | PIN_FLD_CREATE_ACCESS |
poid | PIN_FLD_ACCOUNT_OBJ |
string | PIN_FLD_NAME |
string | PIN_FLD_CODE |
int | PIN_FLD_CURRENCY |
poid | PIN_FLD_PRODUCT_OBJ |
string | PIN_FLD_TAX_CODE |
enum | PIN_FLD_TAX_WHEN |
string | PIN_FLD_EVENT_TYPE |
int | PIN_FLD_CYCLE_FEE_FLAGS |
int | PIN_FLD_BILL_OFFSET |
enum | PIN_FLD_OFFSET_UNIT |
poid | PIN_FLD_SELECTOR_OBJ |
array | PIN_FLD_RATE_TIERS |
string | |
decimal | |
enum | |
poid | |
array | PIN_FLD_DATE_RANGES |
string | |
string | |
timestamp | |
timestamp | |
int | |
int | |
enum | |
enum | |
poid | |
array | PIN_FLD_DAY_RANGES |
string | |
string | |
int | |
int | |
int | |
poid | |
array | PIN_FLD_TOD_RANGES |
string | |
string | |
int | |
int | |
poid |
Type | Field Name | Table | Column Name |
---|---|---|---|
base-class | /rate_plan | rate_plan_t | |
poid | PIN_FLD_POID | poid* | |
timestamp | PIN_FLD_CREATED_T | created_t | |
timestamp | PIN_FLD_MOD_T | mod_t | |
string | PIN_FLD_READ_ACCESS | read_access | |
string | PIN_FLD_WRITE_ACCESS | wrtie_access | |
string | PIN_FLD_CREATE_ACCESS | create_access | |
poid | PIN_FLD_ACCOUNT_OBJ | account_obj* | |
string | PIN_FLD_NAME | name | |
string | PIN_FLD_CODE | code | |
int | PIN_FLD_CURRENCY | currency | |
poid | PIN_FLD_PRODUCT_OBJ | product_obj* | |
string | PIN_FLD_TAX_CODE | tax_code | |
enum | PIN_FLD_TAX_WHEN | tax_when | |
string | PIN_FLD_EVENT_TYPE | event_type | |
int | PIN_FLD_CYCLE_FEE_FLAGS | cycle_fee_flags | |
int | PIN_FLD_BILL_OFFSET | bill_offset | |
enum | PIN_FLD_OFFSET_UNIT | offset_unit | |
poid | PIN_FLD_SELECTOR_OBJ | selector_obj* | |
array | PIN_FLD_RATE_TIERS | rate_tiers_t | |
string |
PIN_FLD_NAME
|
name | |
decimal |
PIN_FLD_PRIORITY
|
priority | |
enum |
PIN_FLD_DATE_RANGE_TYPE
|
date_range_type | |
poid |
PIN_FLD_RATE_OBJ
|
rate_obj* | |
array | PIN_FLD_DATE_RANGES | date_ranges_t | |
string |
PIN_FLD_LINEAGE
|
lineage | |
string |
PIN_FLD_NAME
|
name | |
timestamp |
PIN_FLD_START_T
|
start_t | |
timestamp |
PIN_FLD_END_T
|
end_t | |
int |
PIN_FLD_RELATIVE_START_OFFSET
|
start_offset | |
int |
PIN_FLD_RELATIVE_END_OFFSET
|
end_offset | |
enum |
PIN_FLD_RELATIVE_START_UNIT
|
rel_start_unit | |
enum |
PIN_FLD_RELATIVE_END_UNIT
|
rel_end_unit | |
poid |
PIN_FLD_RATE_OBJ
|
rate_obj* | |
array | PIN_FLD_DAY_RANGES | day_ranges_t | |
string |
PIN_FLD_LINEAGE
|
lineage | |
string |
PIN_FLD_NAME
|
name | |
int |
PIN_FLD_VALID_DOW
|
valid_dow | |
int |
PIN_FLD_VALID_DOM
|
valid_dom | |
int |
PIN_FLD_VALID_MOY
|
valid_moy | |
poid |
PIN_FLD_RATE_OBJ
|
rate_obj* | |
array | PIN_FLD_TOD_RANGES | tod_ranges_t | |
string |
PIN_FLD_LINEAGE
|
lineage | |
string |
PIN_FLD_NAME
|
name | |
int |
PIN_FLD_START_OFFSET
|
start_offset | |
int |
PIN_FLD_END_OFFSET
|
end_offset | |
poid |
PIN_FLD_RATE_OBJ
|
rate_obj* | Column names marked with * are actually column prefixes. For poid type fields, the column prefix is used to create the columns poid_id0, poid_db and poid_type if the prefix is "poid". For PIN_FLD_POID in the base table, an additional column named poid_rev is created to hold the poid revision. For buffer fields, two columns are created - one in the containing table and one in the buffer table. For example if the prefix is "buf", then the column name in the buffer table is buffer_buf and the column name in the containing table is buffer_size. |
Field Index | This Class |