Field Index | SQL Mapping |
Type | Field Name | Table | Column Name |
---|---|---|---|
base-class | /purchased_product | purchased_product_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* | |
timestamp | PIN_FLD_EFFECTIVE_T | effective_t | |
poid | PIN_FLD_BASE_PRODUCT_OBJ | base_product_obj* | |
decimal | PIN_FLD_CYCLE_DISCOUNT | cycle_discount | |
decimal | PIN_FLD_CYCLE_DISC_AMT | cycle_disc_amt | |
decimal | PIN_FLD_CYCLE_FEE_AMT | cycle_fee_amt | |
timestamp | PIN_FLD_CYCLE_END_T | cycle_end_t | |
timestamp | PIN_FLD_CYCLE_START_T | cycle_start_t | |
poid | PIN_FLD_DEAL_OBJ | deal_obj* | |
string | PIN_FLD_NODE_LOCATION | node_location | |
string | PIN_FLD_DESCR | descr | |
int | PIN_FLD_PACKAGE_ID | package_id | |
int | PIN_FLD_CALENDAR_DOM | calendar_dom | |
int | PIN_FLD_FLAGS | flags | |
int | PIN_FLD_MMC_TYPE | mmc_type | |
poid | PIN_FLD_OFFERING_OVERRIDE_VALUES_OBJ | offering_override_values_obj* | |
array | PIN_FLD_CYCLE_FEES | purchased_product_cycle_fees_t | |
timestamp |
PIN_FLD_CHARGED_FROM_T
|
charged_from_t | |
timestamp |
PIN_FLD_CHARGED_TO_T
|
charged_to_t | |
timestamp |
PIN_FLD_CYCLE_FEE_START_T
|
cycle_fee_start_t | |
timestamp |
PIN_FLD_CYCLE_FEE_END_T
|
cycle_fee_end_t | |
enum |
PIN_FLD_UNIT
|
unit | |
int |
PIN_FLD_COUNT
|
count | |
timestamp |
PIN_FLD_LAST_NOTIFICATION_T
|
last_notification_t | |
string |
PIN_FLD_LAST_NOTIFICATION_OFFSET
|
last_notification_offset | |
poid | PIN_FLD_PLAN_OBJ | plan_obj* | |
poid | PIN_FLD_PRODUCT_OBJ | product_obj* | |
decimal | PIN_FLD_PURCHASE_DISCOUNT | purchase_discount | |
decimal | PIN_FLD_PURCHASE_DISC_AMT | purchase_disc_amt | |
decimal | PIN_FLD_PURCHASE_FEE_AMT | purchase_fee_amt | |
timestamp | PIN_FLD_PURCHASE_END_T | purchase_end_t | |
timestamp | PIN_FLD_PURCHASE_START_T | purchase_start_t | |
decimal | PIN_FLD_QUANTITY | quantity | |
poid | PIN_FLD_SERVICE_OBJ | service_obj* | |
poid | PIN_FLD_SPONSOR_OBJ | sponsor_obj* | |
enum | PIN_FLD_STATUS | status | |
int | PIN_FLD_STATUS_FLAGS | status_flags | |
decimal | PIN_FLD_USAGE_DISCOUNT | usage_discount | |
timestamp | PIN_FLD_USAGE_END_T | usage_end_t | |
timestamp | PIN_FLD_USAGE_START_T | usage_start_t | |
int | PIN_FLD_CYCLE_FEE_FLAGS | cycle_fee_flags | |
enum | PIN_FLD_OBJECT_CACHE_TYPE | object_cache_type | |
timestamp | PIN_FLD_INSTANTIATED_T | instantiated_t | |
int | PIN_FLD_PURCHASE_START_DETAILS | purchase_start_details | |
int | PIN_FLD_CYCLE_START_DETAILS | cycle_start_details | |
int | PIN_FLD_USAGE_START_DETAILS | usage_start_details | |
int | PIN_FLD_PURCHASE_END_DETAILS | purchase_end_details | |
int | PIN_FLD_CYCLE_END_DETAILS | cycle_end_details | |
int | PIN_FLD_USAGE_END_DETAILS | usage_end_details | |
poid | PIN_FLD_OVERRIDDEN_OBJ | overridden_obj* | |
string | PIN_FLD_PRICE_LIST_NAME | price_list_name | |
enum | PIN_FLD_MODE | purchase_mode | |
int | PIN_FLD_RENEWAL_MODE | renewal_mode | |
int | PIN_FLD_GRACE_PERIOD | grace_period | |
int | PIN_FLD_RETRY_COUNT | retry_count | |
timestamp | PIN_FLD_NEXT_RETRY_T | next_retry_t | |
timestamp | PIN_FLD_LAST_NOTIFICATION_T | last_notification_t | |
string | PIN_FLD_LAST_NOTIFICATION_OFFSET | last_notification_offset | |
string | PIN_FLD_UNIQUE_ID | unique_id | 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 |