| 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_BILLINFO_OBJ |
| array | PIN_FLD_CHARGES |
| poid | |
| string | PIN_FLD_CODE |
| string | PIN_FLD_DESCR |
| decimal | PIN_FLD_DUE |
| timestamp | PIN_FLD_END_T |
| int | PIN_FLD_FLAGS |
| array | PIN_FLD_INSTALLMENTS |
| decimal | |
| timestamp | |
| poid | |
| timestamp | |
| string | |
| enum | |
| timestamp | |
| poid | PIN_FLD_INSTALLMENT_SPEC_OBJ |
| enum | PIN_FLD_INSTALLMENT_TYPE |
| timestamp | PIN_FLD_LAST_NOTIFICATION_T |
| string | PIN_FLD_LAST_NOTIFICATION_OFFSET |
| string | PIN_FLD_NAME |
| timestamp | PIN_FLD_START_T |
| enum | PIN_FLD_STATUS |
| int | PIN_FLD_TERM |
| decimal | PIN_FLD_TOTAL_AMOUNT |
| Type | Field Name | Table | Column Name |
|---|---|---|---|
| base-class | /installment_schedule | installment_schedule_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_BILLINFO_OBJ | billinfo_obj* | |
| array | PIN_FLD_CHARGES | installment_source_t | |
| poid |
PIN_FLD_CHARGE_OBJ
|
charge_obj* | |
| string | PIN_FLD_CODE | code | |
| string | PIN_FLD_DESCR | descr | |
| decimal | PIN_FLD_DUE | due | |
| timestamp | PIN_FLD_END_T | end_t | |
| int | PIN_FLD_FLAGS | flags | |
| array | PIN_FLD_INSTALLMENTS | installment_sch_installment_t | |
| decimal |
PIN_FLD_AMOUNT
|
amount | |
| timestamp |
PIN_FLD_EFFECTIVE_T
|
effective_t | |
| poid |
PIN_FLD_ITEM_OBJ
|
item_obj* | |
| timestamp |
PIN_FLD_LAST_NOTIFICATION_T
|
last_notification_t | |
| string |
PIN_FLD_LAST_NOTIFICATION_OFFSET
|
last_notification_offset | |
| enum |
PIN_FLD_STATUS
|
status | |
| timestamp |
PIN_FLD_NOTIFICATION_DUE_T
|
notification_due_t | |
| poid | PIN_FLD_INSTALLMENT_SPEC_OBJ | installment_spec_obj* | |
| enum | PIN_FLD_INSTALLMENT_TYPE | installment_type | |
| timestamp | PIN_FLD_LAST_NOTIFICATION_T | last_notification_t | |
| string | PIN_FLD_LAST_NOTIFICATION_OFFSET | last_notification_offset | |
| string | PIN_FLD_NAME | name | |
| timestamp | PIN_FLD_START_T | start_t | |
| enum | PIN_FLD_STATUS | status | |
| int | PIN_FLD_TERM | term | |
| decimal | PIN_FLD_TOTAL_AMOUNT | 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 |