| 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 |
| timestamp | PIN_FLD_EFFECTIVE_T |
| string | PIN_FLD_HEADER_STR |
| timestamp | PIN_FLD_CLOSED_T |
| int | PIN_FLD_REASON_DOMAIN_ID |
| int | PIN_FLD_REASON_ID |
| decimal | PIN_FLD_AMOUNT |
| poid | PIN_FLD_ITEM_OBJ |
| poid | PIN_FLD_EVENT_OBJ |
| poid | PIN_FLD_SERVICE_OBJ |
| poid | PIN_FLD_BILL_OBJ |
| poid | PIN_FLD_BILLINFO_OBJ |
| poid | PIN_FLD_ACCOUNT_OBJ |
| enum | PIN_FLD_NOTE_TYPE |
| enum | PIN_FLD_NOTE_SUB_TYPE |
| enum | PIN_FLD_STATUS |
| int | PIN_FLD_COUNT |
| array | PIN_FLD_DATA_ARRAY |
| poid | |
| string | |
| timestamp | |
| string | |
| string |
| Type | Field Name | Table | Column Name |
|---|---|---|---|
| base-class | /note | note_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 | |
| timestamp | PIN_FLD_EFFECTIVE_T | effective_t | |
| string | PIN_FLD_HEADER_STR | header_str | |
| timestamp | PIN_FLD_CLOSED_T | closed_t | |
| int | PIN_FLD_REASON_DOMAIN_ID | reason_domain_id | |
| int | PIN_FLD_REASON_ID | reason_id | |
| decimal | PIN_FLD_AMOUNT | amount | |
| poid | PIN_FLD_ITEM_OBJ | item_obj* | |
| poid | PIN_FLD_EVENT_OBJ | event_obj* | |
| poid | PIN_FLD_SERVICE_OBJ | service_obj* | |
| poid | PIN_FLD_BILL_OBJ | bill_obj* | |
| poid | PIN_FLD_BILLINFO_OBJ | billinfo_obj* | |
| poid | PIN_FLD_ACCOUNT_OBJ | account_obj* | |
| enum | PIN_FLD_NOTE_TYPE | note_type | |
| enum | PIN_FLD_NOTE_SUB_TYPE | note_sub_type | |
| enum | PIN_FLD_STATUS | status | |
| int | PIN_FLD_COUNT | count | |
| array | PIN_FLD_DATA_ARRAY | note_data_t | |
| poid |
PIN_FLD_CSR_ACCOUNT_OBJ
|
csr_account_obj* | |
| string |
PIN_FLD_TRACKING_ID
|
tracking_id | |
| timestamp |
PIN_FLD_ENTRY_T
|
entry_t | |
| string |
PIN_FLD_NOTE_STR
|
note_str | |
| string |
PIN_FLD_EXTERNAL_USER
|
external_user_name | 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 |