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 |
poid | PIN_FLD_RATE_PLAN_OBJ |
string | PIN_FLD_DESCR |
enum | PIN_FLD_PRORATE_FIRST |
enum | PIN_FLD_PRORATE_LAST |
int | PIN_FLD_PRORATE_QUANTITY |
enum | PIN_FLD_TYPE |
enum | PIN_FLD_STEP_TYPE |
int | PIN_FLD_STEP_RESOURCE_ID |
string | PIN_FLD_TAILORMADE_DATA |
int | PIN_FLD_PRORATION_FLAG |
array | PIN_FLD_QUANTITY_TIERS |
decimal | |
decimal | |
array | |
int | |
int | |
decimal | |
decimal | |
enum | |
decimal | |
int | |
string | |
timestamp | |
timestamp | |
int | |
int | |
int | |
string | |
string | |
decimal |
Type | Field Name | Table | Column Name |
---|---|---|---|
base-class | /rate | rate_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* | |
poid | PIN_FLD_RATE_PLAN_OBJ | rate_plan_obj* | |
string | PIN_FLD_DESCR | descr | |
enum | PIN_FLD_PRORATE_FIRST | prorate_first | |
enum | PIN_FLD_PRORATE_LAST | prorate_last | |
int | PIN_FLD_PRORATE_QUANTITY | prorate_quantity | |
enum | PIN_FLD_TYPE | type | |
enum | PIN_FLD_STEP_TYPE | step_type | |
int | PIN_FLD_STEP_RESOURCE_ID | step_resource | |
string | PIN_FLD_TAILORMADE_DATA | tailormade_data | |
int | PIN_FLD_PRORATION_FLAG | proration_flag | |
array | PIN_FLD_QUANTITY_TIERS | rate_quantity_tiers_t | |
decimal |
PIN_FLD_STEP_MIN
|
step_min | |
decimal |
PIN_FLD_STEP_MAX
|
step_max | |
array |
PIN_FLD_BAL_IMPACTS
|
rate_bal_impacts_t | |
int |
PIN_FLD_ELEMENT_ID
|
element_id | |
int |
PIN_FLD_FLAGS
|
flags | |
decimal |
PIN_FLD_FIXED_AMOUNT
|
fix_amount | |
decimal |
PIN_FLD_SCALED_AMOUNT
|
scaled_amount | |
enum |
PIN_FLD_SCALED_UNIT
|
scaled_unit | |
decimal |
PIN_FLD_TAXABLE_AMOUNT
|
taxable_amount | |
int |
PIN_FLD_GL_ID
|
gl_id | |
string |
PIN_FLD_IMPACT_CATEGORY
|
impact_category | |
timestamp |
PIN_FLD_START_T
|
start_t | |
timestamp |
PIN_FLD_END_T
|
end_t | |
int |
PIN_FLD_START_DETAILS
|
start_details | |
int |
PIN_FLD_END_DETAILS
|
end_details | |
int |
PIN_FLD_SPLIT_DETAILS
|
split_details | |
string |
PIN_FLD_FIXED_PRICE_TAG
|
fixed_price_tag | |
string |
PIN_FLD_SCALED_PRICE_TAG
|
scaled_price_tag | |
decimal |
PIN_FLD_MINIMUM_SCALED_AMOUNT
|
minimum_scaled_amount | 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 |