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_BILL_OBJ |
string | PIN_FLD_BILL_NO |
timestamp | PIN_FLD_BILL_DATE_T |
int64 | PIN_FLD_HEADER_NUM |
string | PIN_FLD_HEADER_STR |
int | PIN_FLD_INV_FLAGS |
int | PIN_FLD_CHECK_SPLIT_FLAGS |
array | PIN_FLD_STATUSES |
enum | |
timestamp | |
array | PIN_FLD_FORMATS |
buffer | |
int64 | |
decimal | |
string | |
string | |
string | |
timestamp | |
enum | PIN_FLD_STATUS |
poid | PIN_FLD_BILLINFO_OBJ |
string | PIN_FLD_REPORT_NAME |
string | PIN_FLD_TEMPLATE_NAME |
array | PIN_FLD_BILLS |
timestamp | |
timestamp | |
poid | |
decimal | |
decimal | |
decimal | |
decimal | |
decimal |
Type | Field Name | Table | Column Name |
---|---|---|---|
base-class | /invoice | invoice_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_BILL_OBJ | bill_obj* | |
string | PIN_FLD_BILL_NO | bill_no | |
timestamp | PIN_FLD_BILL_DATE_T | bill_date_t | |
string | PIN_FLD_HEADER_STR | header_string | |
int | PIN_FLD_INV_FLAGS | inv_flags | |
int | PIN_FLD_CHECK_SPLIT_FLAGS | check_split_flags | |
array | PIN_FLD_STATUSES | invoice_statuses_t | |
enum |
PIN_FLD_STATUS
|
status | |
timestamp |
PIN_FLD_EFFECTIVE_T
|
effective_t | |
array | PIN_FLD_FORMATS | invoice_formats_t | |
buffer |
PIN_FLD_BUFFER
|
invoice_formats_buf_t | buffer* |
decimal |
PIN_FLD_INV_SIZE
|
inv_size | |
string |
PIN_FLD_HEADER_STR
|
header_str_arr | |
string |
PIN_FLD_LOCALE
|
locale | |
string |
PIN_FLD_TYPE_STR
|
type_str | |
timestamp |
PIN_FLD_EFFECTIVE_T
|
effective_t | |
enum | PIN_FLD_STATUS | status | |
poid | PIN_FLD_BILLINFO_OBJ | billinfo_obj* | |
string | PIN_FLD_REPORT_NAME | report_name | |
string | PIN_FLD_TEMPLATE_NAME | template_name | |
array | PIN_FLD_BILLS | invoice_bills_t | |
timestamp |
PIN_FLD_START_T
|
start_t | |
timestamp |
PIN_FLD_END_T
|
end_t | |
poid |
PIN_FLD_AR_BILLINFO_OBJ
|
ar_billinfo_obj* | |
decimal |
PIN_FLD_DUE
|
due | |
decimal |
PIN_FLD_ADJUSTED
|
adjusted | |
decimal |
PIN_FLD_WRITEOFF
|
writeoff | |
decimal |
PIN_FLD_DISPUTED
|
disputed | |
decimal |
PIN_FLD_RECVD
|
recvd | 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 |