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_ITEM_OBJ |
int | PIN_FLD_GL_ID |
int | PIN_FLD_RESOURCE_ID |
timestamp | PIN_FLD_EARNED_START_T |
timestamp | PIN_FLD_EARNED_END_T |
decimal | PIN_FLD_DB_AR_NET_AMT |
decimal | PIN_FLD_DB_AR_DISC_AMT |
decimal | PIN_FLD_DB_AR_TAX_AMT |
decimal | PIN_FLD_CR_AR_NET_AMT |
decimal | PIN_FLD_CR_AR_DISC_AMT |
decimal | PIN_FLD_CR_AR_TAX_AMT |
timestamp | PIN_FLD_EFFECTIVE_T |
enum | PIN_FLD_TYPE |
poid | PIN_FLD_CONTRACT_OBJ |
timestamp | PIN_FLD_CONTRACT_START_T |
timestamp | PIN_FLD_CONTRACT_END_T |
string | PIN_FLD_TAX_CODE |
string | PIN_FLD_TAX_EXEMPTION_CODE |
string | PIN_FLD_TAX_LOCALES |
int | PIN_FLD_TAX_SUPPLIER |
decimal | PIN_FLD_AMOUNT_DEFERRED |
Type | Field Name | Table | Column Name |
---|---|---|---|
base-class | /journal | journal_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_ITEM_OBJ | item_obj* | |
int | PIN_FLD_GL_ID | gl_id | |
int | PIN_FLD_RESOURCE_ID | resource_id | |
timestamp | PIN_FLD_EARNED_START_T | earned_start_t | |
timestamp | PIN_FLD_EARNED_END_T | earned_end_t | |
decimal | PIN_FLD_DB_AR_NET_AMT | db_ar_net_amt | |
decimal | PIN_FLD_DB_AR_DISC_AMT | db_ar_disc_amt | |
decimal | PIN_FLD_DB_AR_TAX_AMT | db_ar_tax_amt | |
decimal | PIN_FLD_CR_AR_NET_AMT | cr_ar_net_amt | |
decimal | PIN_FLD_CR_AR_DISC_AMT | cr_ar_disc_amt | |
decimal | PIN_FLD_CR_AR_TAX_AMT | cr_ar_tax_amt | |
timestamp | PIN_FLD_EFFECTIVE_T | effective_t | |
enum | PIN_FLD_TYPE | type | |
poid | PIN_FLD_CONTRACT_OBJ | contract_obj* | |
timestamp | PIN_FLD_CONTRACT_START_T | contract_start_t | |
timestamp | PIN_FLD_CONTRACT_END_T | contract_end_t | |
string | PIN_FLD_TAX_CODE | tax_code | |
string | PIN_FLD_TAX_EXEMPTION_CODE | tax_exemption_code | |
string | PIN_FLD_TAX_LOCALES | tax_locales | |
int | PIN_FLD_TAX_SUPPLIER | tax_supplier | |
decimal | PIN_FLD_AMOUNT_DEFERRED | amount_deferred | 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 |