PayableItemTable::getMap

static function getMap()
{
	global $DB;

	return [
		'ID' => [
			'data_type' => 'integer',
			'primary' => true,
			'autocomplete' => true,
		],
		'ENTITY_ID' => [
			'data_type' => 'integer',
			'required' => true,
		],
		'ENTITY_TYPE' => [
			'data_type' => 'enum',
			'required' => true,
			'values' => [
				SaleRegistry::ENTITY_BASKET_ITEM,
				SaleRegistry::ENTITY_SHIPMENT,
			]
		],
		'PAYMENT_ID' => [
			'data_type' => 'integer',
			'required' => true,
		],
		'DATE_INSERT' => [
			'data_type' => 'datetime'
		],
		'DATE_INSERT_SHORT' => [
			'data_type' => 'datetime',
			'expression' => [
				$DB->datetimeToDateFunction('%s'), 'DATE_INSERT'
			]
		],
		'QUANTITY' => [
			'data_type' => 'float',
			'required' => true,
		],
		'XML_ID' => [
			'data_type' => 'string'
		],
		//
		'PAYMENT' => new Reference(
			'PAYMENT',
			PaymentTable::class,
			Join::on('this.PAYMENT_ID', 'ref.ID')
		),
		'BASKET' => new Reference(
			'BASKET',
			BasketTable::class,
			Join::on('this.ENTITY_ID', 'ref.ID')->where('this.ENTITY_TYPE', SaleRegistry::ENTITY_BASKET_ITEM)
		),
		'SHIPMENT' => new Reference(
			'SHIPMENT',
			ShipmentTable::class,
			Join::on('this.ENTITY_ID', 'ref.ID')->where('this.ENTITY_TYPE', SaleRegistry::ENTITY_SHIPMENT)
		),
	];
}