Field Index

SQL Mapping

payment

This event is created for successful payments

Notes

This object can be read by the owner or any billing group leader within the brand who is an ancestor of the owner.
This object can be modified by the owner or any billing group leader within the brand who is an ancestor of the owner.
This object can be created by anyone.

Field Index

Type	Field Name
string	PIN_FLD_NAME
poid	PIN_FLD_USERID
poid	PIN_FLD_SESSION_OBJ
string	PIN_FLD_PROGRAM_NAME
string	PIN_FLD_SYS_DESCR
poid	PIN_FLD_ACCOUNT_OBJ
poid	PIN_FLD_BILLINFO_OBJ
enum	PIN_FLD_PAY_TYPE
int	PIN_FLD_CURRENCY
decimal	PIN_FLD_AMOUNT
array	PIN_FLD_BILLS
string	PIN_FLD_BILL_NO
poid	PIN_FLD_ACCOUNT_OBJ

Field Details

string PIN_FLD_NAME

Name of the event (set to 'Payment Event Log').

Notes

Required on object creation
Can be modified
Maximum length is 255 bytes

poid PIN_FLD_USERID

The unique ID of the user who is running the program that started the event.

Notes

Can be specified on object creation
Cannot be modified

poid PIN_FLD_SESSION_OBJ

Link to the event object (/event/session) that represents the session within which this event occurred.

Notes

Can be specified on object creation
Cannot be modified

string PIN_FLD_PROGRAM_NAME

The name of the program that generated the event.

Notes

Required on object creation
Cannot be modified
Maximum length is 60 bytes

string PIN_FLD_SYS_DESCR

System generated description - describes event programmatically.

Notes

Can be specified on object creation
Can be modified
Maximum length is 255 bytes

poid PIN_FLD_ACCOUNT_OBJ

Poid of the account object for which payment is done.

Notes

Required on object creation
Cannot be modified

poid PIN_FLD_BILLINFO_OBJ

Poid of billunit for which payment is done.

Notes

Can be specified on object creation
Cannot be modified

enum PIN_FLD_PAY_TYPE

Paytype of the Payment.

Notes

Can be specified on object creation
Can be modified

int PIN_FLD_CURRENCY

Currency of the payment

Notes

Required on object creation
Can be modified

decimal PIN_FLD_AMOUNT

Amount of the payment.

Notes

Can be specified on object creation
Can be modified

array PIN_FLD_BILLS

List of Bills for which payment is done

Notes

Can be specified on object creation
Can be modified

string PIN_FLD_BILL_NO

Customer visible bill number

Notes

Required on object creation
Cannot be modified
Maximum length is 255 bytes

poid PIN_FLD_ACCOUNT_OBJ

Poid of the account object of the bill.

Notes

Required on object creation
Cannot be modified

SQL Mapping

Links

/event/notification SQL Mapping

Type	Field Name	Table	Column Name
derived-class	/event/notification/payment
string	PIN_FLD_NAME
poid	PIN_FLD_USERID
poid	PIN_FLD_SESSION_OBJ
string	PIN_FLD_PROGRAM_NAME
string	PIN_FLD_SYS_DESCR
poid	PIN_FLD_ACCOUNT_OBJ
poid	PIN_FLD_BILLINFO_OBJ
enum	PIN_FLD_PAY_TYPE
int	PIN_FLD_CURRENCY
decimal	PIN_FLD_AMOUNT
array	PIN_FLD_BILLS
string	PIN_FLD_BILL_NO
poid	PIN_FLD_ACCOUNT_OBJ
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