39 lines
1.4 KiB
JavaScript
39 lines
1.4 KiB
JavaScript
'use strict'
|
|
const { Model } = require('sequelize')
|
|
module.exports = (sequelize, DataTypes) => {
|
|
class SupplierDetail extends Model {
|
|
|
|
}
|
|
SupplierDetail.init(
|
|
{
|
|
pd_id: { type: DataTypes.INTEGER },
|
|
supplier_info_available: { type: DataTypes.STRING },
|
|
supplier_not_available_reason: { type: DataTypes.STRING },
|
|
provider_name: { type: DataTypes.STRING },
|
|
supplier_name: { type: DataTypes.STRING },
|
|
contact_person_name: { type: DataTypes.STRING },
|
|
contact_person_designation: { type: DataTypes.INTEGER },
|
|
contact_person_mobile_no: { type: DataTypes.STRING },
|
|
person_stdcode: { type: DataTypes.INTEGER },
|
|
person_landline: { type: DataTypes.INTEGER },
|
|
type_of_payment : { type: DataTypes.STRING }, // new
|
|
payment_mode: { type: DataTypes.STRING },
|
|
credit_period_no: { type: DataTypes.INTEGER },
|
|
credit_total_purchase: { type: DataTypes.INTEGER },
|
|
company_name: { type: DataTypes.INTEGER },
|
|
name_of_the_company: { type: DataTypes.STRING }, // new
|
|
common_remarks: { type: DataTypes.STRING },
|
|
createdby: { type: DataTypes.INTEGER },
|
|
updatedby: { type: DataTypes.INTEGER }
|
|
|
|
},
|
|
{
|
|
sequelize,
|
|
tableName: 'credit_supplier_details',
|
|
modelName: 'SupplierDetail',
|
|
}
|
|
)
|
|
|
|
|
|
return SupplierDetail
|
|
} |