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_PRODUCT_OBJ |
string | PIN_FLD_NAME |
string | PIN_FLD_CODE |
string | PIN_FLD_DESCR |
enum | PIN_FLD_DATE_RANGE_TYPE |
timestamp | PIN_FLD_START_T |
timestamp | PIN_FLD_END_T |
int | PIN_FLD_RELATIVE_START_OFFSET |
int | PIN_FLD_RELATIVE_END_OFFSET |
enum | PIN_FLD_RELATIVE_START_UNIT |
enum | PIN_FLD_RELATIVE_END_UNIT |
array | PIN_FLD_BAL_IMPACTS |
int | |
int | |
string | |
decimal | |
decimal | |
enum | |
int | |
enum | |
enum |
Type | Field Name | Table | Column Name |
---|---|---|---|
base-class | /rollover | rollover_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_PRODUCT_OBJ | product_obj* | |
string | PIN_FLD_NAME | name | |
string | PIN_FLD_CODE | code | |
string | PIN_FLD_DESCR | descr | |
enum | PIN_FLD_DATE_RANGE_TYPE | date_range_type | |
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 | |
array | PIN_FLD_BAL_IMPACTS | rollover_bal_impacts_t | |
int |
PIN_FLD_RESOURCE_ID
|
resource_id | |
int |
PIN_FLD_GL_ID
|
gl_id | |
string |
PIN_FLD_IMPACT_CATEGORY
|
impact_category | |
decimal |
PIN_FLD_ROLLOVER_MAX_UNITS
|
rollover_max_units | |
decimal |
PIN_FLD_ROLLOVER_UNITS
|
rollover_units | |
enum |
PIN_FLD_ROLLOVER_UOM
|
uom | |
int |
PIN_FLD_ROLLOVER_COUNT
|
rollover_count | |
enum |
PIN_FLD_PRORATE_FIRST
|
prorate_first | |
enum |
PIN_FLD_PRORATE_LAST
|
prorate_last | 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 |