54 lines
2.3 KiB
JavaScript
54 lines
2.3 KiB
JavaScript
'use strict'
|
|
const { Model } = require('sequelize')
|
|
module.exports = (sequelize, DataTypes) => {
|
|
class CreditFinancialInformation extends Model {
|
|
|
|
}
|
|
CreditFinancialInformation.init(
|
|
{
|
|
pd_id: { type: DataTypes.INTEGER },
|
|
financial_info_available: { type: DataTypes.STRING },
|
|
net_profit_rs: { type: DataTypes.INTEGER },
|
|
net_profit_to_sales_percent: { type: DataTypes.STRING },
|
|
sales_amount: { type: DataTypes.STRING },
|
|
is_any_other_working_captial_facility: { type: DataTypes.STRING },
|
|
facility_details_specify: { type: DataTypes.STRING },
|
|
facility_details_other_lender: { type: DataTypes.STRING },
|
|
facility_details_other: { type: DataTypes.STRING },
|
|
broken_period_turnover_percent: { type: DataTypes.STRING },
|
|
broken_period_turnover_py: { type: DataTypes.STRING },
|
|
broken_period_turnover_cy: { type: DataTypes.STRING },
|
|
broken_period_no_of_months: { type: DataTypes.STRING },
|
|
broken_period_to_month: { type: DataTypes.STRING },
|
|
broken_period_from_month: { type: DataTypes.STRING },
|
|
inventory_days_cm: { type: DataTypes.INTEGER },
|
|
creditor_days_cm: { type: DataTypes.INTEGER },
|
|
debtor_days_cm: { type: DataTypes.INTEGER },
|
|
fy: { type: DataTypes.STRING },
|
|
sales_revenue: { type: DataTypes.STRING },
|
|
net_profit: { type: DataTypes.STRING },
|
|
net_profit_sales_percent: { type: DataTypes.STRING },
|
|
sales_py: { type: DataTypes.STRING },
|
|
netprofit_py: { type: DataTypes.STRING },
|
|
netprofit_py_percent: { type: DataTypes.STRING },
|
|
debtor_days_cet: { type: DataTypes.STRING },
|
|
creditor_days_cet: { type: DataTypes.STRING },
|
|
inventory_days_cet: { type: DataTypes.STRING },
|
|
company_name: { type: DataTypes.STRING },
|
|
no_of_financial_years: { type: DataTypes.INTEGER },
|
|
common_remarks: { type: DataTypes.STRING },
|
|
createdby: { type: DataTypes.INTEGER },
|
|
updatedby: { type: DataTypes.INTEGER },
|
|
display_order: { type: DataTypes.INTEGER }
|
|
|
|
},
|
|
{
|
|
sequelize,
|
|
tableName: 'credit_financial_information',
|
|
modelName: 'CreditFinancialInformation',
|
|
}
|
|
)
|
|
|
|
|
|
return CreditFinancialInformation
|
|
} |