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 |
string | PIN_FLD_NAME |
string | PIN_FLD_DESCR |
string | PIN_FLD_CODE |
int | PIN_FLD_TERM_LENGTH |
enum | PIN_FLD_TERM_UNIT |
timestamp | PIN_FLD_START_T |
timestamp | PIN_FLD_END_T |
int | PIN_FLD_EARLY_TERMINATION_ALLOWED |
int | PIN_FLD_TERMINATION_GRACE_LENGTH |
enum | PIN_FLD_TERMINATION_GRACE_UNIT |
poid | PIN_FLD_ACCOUNT_OBJ |
poid | PIN_FLD_PENALTY_OBJ |
int | PIN_FLD_RENEW_FLAGS |
poid | PIN_FLD_AUTO_RENEW_PLAN_OBJ |
poid | PIN_FLD_AUTO_RENEW_DEAL_OBJ |
poid | PIN_FLD_AUTO_RENEW_SUBS_TERMS_OBJ |
enum | PIN_FLD_PENALTY_OPTIONS |
decimal | PIN_FLD_PENALTY_AMOUNT |
int | PIN_FLD_RESOURCE_ID |
int | PIN_FLD_REVENUE_GLID |
int | PIN_FLD_MINIMUM_TERM_LENGTH |
enum | PIN_FLD_MINIMUM_TERM_UNIT |
Type | Field Name | Table | Column Name |
---|---|---|---|
base-class | /subscription_terms | subscription_terms_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 | |
string | PIN_FLD_NAME | name | |
string | PIN_FLD_DESCR | descr | |
string | PIN_FLD_CODE | code | |
int | PIN_FLD_TERM_LENGTH | term_length | |
enum | PIN_FLD_TERM_UNIT | term_unit | |
timestamp | PIN_FLD_START_T | start_t | |
timestamp | PIN_FLD_END_T | end_t | |
int | PIN_FLD_EARLY_TERMINATION_ALLOWED | early_term_allowed | |
int | PIN_FLD_TERMINATION_GRACE_LENGTH | term_grace_length | |
enum | PIN_FLD_TERMINATION_GRACE_UNIT | term_grace_unit | |
poid | PIN_FLD_ACCOUNT_OBJ | account_obj* | |
poid | PIN_FLD_PENALTY_OBJ | penalty_obj* | |
int | PIN_FLD_RENEW_FLAGS | renew_flags | |
poid | PIN_FLD_AUTO_RENEW_PLAN_OBJ | auto_renew_plan_obj* | |
poid | PIN_FLD_AUTO_RENEW_DEAL_OBJ | auto_renew_deal_obj* | |
poid | PIN_FLD_AUTO_RENEW_SUBS_TERMS_OBJ | auto_renew_subs_terms_obj* | |
enum | PIN_FLD_PENALTY_OPTIONS | penalty_options | |
decimal | PIN_FLD_PENALTY_AMOUNT | penalty_amount | |
int | PIN_FLD_RESOURCE_ID | resource_id | |
int | PIN_FLD_REVENUE_GLID | revenue_glid | |
int | PIN_FLD_MINIMUM_TERM_LENGTH | minimum_term_length | |
enum | PIN_FLD_MINIMUM_TERM_UNIT | minimum_term_unit | 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 |