Database – Pay Near Me Order Entity (pnm_order_entity)
Description
PayNearMe order information.
Column | Data Type | Column Info | Value Notes | Other |
id | int(10) | The id of the entity | ||
loan_id | int(10) | The id of the associated loan account | ||
customer_id | int(11) | ID for the customer | ||
order_id | varchar(45) | Order ID | ||
short_order_id | varchar(45) | Short Order ID | ||
site_customer_id | varchar(45) | LoanPro Customer ID | ||
status | char(6) | Status code of the entity | ||
slip_url | varchar(255) | order slip URL | ||
created | timestamp | Timestamp of when the entity was created | ||
lastUpdated | timestamp | Timestamp of when the entity was last updated | ||
active | tinyint(1) | Whether or not the entity is active | 1 - yes, 0 - no | |
deleted | tinyint(1) | Whether or not the entity was deleted | 1 - yes, 0 - no |