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_ADDRESS |
decimal | PIN_FLD_BAL_OPERAND |
string | PIN_FLD_BULKACCT_EFILE |
string | PIN_FLD_BULKACCT_SFILE |
string | PIN_FLD_BULKACCT_SLP |
string | PIN_FLD_CITY |
timestamp | PIN_FLD_CLOSE_WHEN_T |
int | PIN_FLD_COUNT |
string | PIN_FLD_COUNTRY |
string | PIN_FLD_FIRST_NAME |
int | PIN_FLD_FLAGS |
string | PIN_FLD_LAST_NAME |
string | PIN_FLD_LOGIN_PREFIX |
string | PIN_FLD_LOGIN_SUFFIX |
string | PIN_FLD_MIDDLE_NAME |
string | PIN_FLD_NAME |
string | PIN_FLD_PASSWD_PATTERN |
poid | PIN_FLD_PLAN_OBJ |
int | PIN_FLD_RESOURCE_ID |
int | PIN_FLD_START_SEQ |
string | PIN_FLD_STATE |
enum | PIN_FLD_STATUS |
string | PIN_FLD_TRACKING_ID |
poid | PIN_FLD_USERID |
string | PIN_FLD_ZIP |
Type | Field Name | Table | Column Name |
---|---|---|---|
base-class | /bulkacct | bulkacct_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_ADDRESS | address | |
decimal | PIN_FLD_BAL_OPERAND | bal_operand | |
string | PIN_FLD_BULKACCT_EFILE | bulkacct_efile | |
string | PIN_FLD_BULKACCT_SFILE | bulkacct_sfile | |
string | PIN_FLD_BULKACCT_SLP | bulkacct_slp | |
string | PIN_FLD_CITY | city | |
timestamp | PIN_FLD_CLOSE_WHEN_T | close_when_t | |
int | PIN_FLD_COUNT | count | |
string | PIN_FLD_COUNTRY | country | |
string | PIN_FLD_FIRST_NAME | first_name | |
int | PIN_FLD_FLAGS | flags | |
string | PIN_FLD_LAST_NAME | last_name | |
string | PIN_FLD_LOGIN_PREFIX | login_prefix | |
string | PIN_FLD_LOGIN_SUFFIX | login_suffix | |
string | PIN_FLD_MIDDLE_NAME | middle_name | |
string | PIN_FLD_NAME | name | |
string | PIN_FLD_PASSWD_PATTERN | passwd_pattern | |
poid | PIN_FLD_PLAN_OBJ | plan_obj* | |
int | PIN_FLD_RESOURCE_ID | resource_id | |
int | PIN_FLD_START_SEQ | start_seq | |
string | PIN_FLD_STATE | state | |
enum | PIN_FLD_STATUS | status | |
string | PIN_FLD_TRACKING_ID | tracking_id | |
poid | PIN_FLD_USERID | userid* | |
string | PIN_FLD_ZIP | zip | 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 |