UserTransactTable::getMap

static function getMap()
{
	return [
		'ID' =>
			(new IntegerField('ID'))
				->configurePrimary(true)
				->configureAutocomplete(true)
		,
		'USER_ID' =>
			(new IntegerField('USER_ID'))
				->configureRequired(true)
		,
		'TIMESTAMP_X' =>
			(new DatetimeField('TIMESTAMP_X'))
				->configureDefaultValue(
					static function()
					{
						return new DateTime();
					}
				)
		,
		'TRANSACT_DATE' =>
			(new DatetimeField('TRANSACT_DATE'))
				->configureRequired(true)
		,
		'AMOUNT' =>
			(new FloatField('AMOUNT'))
				->configureDefaultValue(0.0000)
		,
		'CURRENCY' =>
			(new StringField('CURRENCY'))
				->configureRequired(true)
				->addValidator([__CLASS__, 'validateCurrency'])
		,
		'DEBIT' => (new BooleanField('DEBIT'))
			->configureValues('N', 'Y')
			->configureDefaultValue('N')
		,
		'ORDER_ID' => (new IntegerField('ORDER_ID')),
		'DESCRIPTION' =>
			(new StringField('DESCRIPTION'))
				->configureRequired(true)
				->addValidator([__CLASS__, 'validateDescription'])
		,
		'NOTES' => (new TextField('NOTES')),
		'PAYMENT_ID' => (new IntegerField('PAYMENT_ID')),
		'EMPLOYEE_ID' => (new IntegerField('EMPLOYEE_ID')),
		//
		new Reference(
			'ORDER',
			OrderTable::class,
			Join::on('this.ORDER_ID', 'ref.ID')
		),
		new Reference(
			'PAYMENT',
			PaymentTable::class,
			Join::on('this.PAYMENT_ID', 'ref.ID')
		),
	];
}