<?php
global $runnerDbTableInfo;
$runnerDbTableInfo['vw_augmentation_request_item_allocation_summary'] = array(
	'type' => 0,
	'foreignKeys' => array( 
		 
	),
	'fields' => array( 
		array(
			'name' => 'augmentation_request_item_id',
			'type' => 20,
			'size' => 20,
			'scale' => 0,
			'typeName' => 'bigint(20)',
			'nullable' => false,
			'autoinc' => false,
			'defaultValueSQL' => '0',
			'defaultValue' => '0' 
		),
		array(
			'name' => 'augmentation_request_id',
			'type' => 20,
			'size' => 20,
			'scale' => 0,
			'typeName' => 'bigint(20)',
			'nullable' => false,
			'autoinc' => false,
			'defaultValueSQL' => null,
			'defaultValue' => '' 
		),
		array(
			'name' => 'line_no',
			'type' => 3,
			'size' => 11,
			'scale' => 0,
			'typeName' => 'int(11)',
			'nullable' => false,
			'autoinc' => false,
			'defaultValueSQL' => '1',
			'defaultValue' => '1' 
		),
		array(
			'name' => 'dromic_category',
			'type' => 200,
			'size' => 100,
			'scale' => 0,
			'typeName' => 'varchar(100)',
			'nullable' => true,
			'autoinc' => false,
			'defaultValueSQL' => null,
			'defaultValue' => '' 
		),
		array(
			'name' => 'requested_description',
			'type' => 200,
			'size' => 255,
			'scale' => 0,
			'typeName' => 'varchar(255)',
			'nullable' => true,
			'autoinc' => false,
			'defaultValueSQL' => null,
			'defaultValue' => '' 
		),
		array(
			'name' => 'requested_unit',
			'type' => 200,
			'size' => 50,
			'scale' => 0,
			'typeName' => 'varchar(50)',
			'nullable' => true,
			'autoinc' => false,
			'defaultValueSQL' => null,
			'defaultValue' => '' 
		),
		array(
			'name' => 'requested_qty',
			'type' => 14,
			'size' => 14,
			'scale' => 2,
			'typeName' => 'decimal(14,2)',
			'nullable' => true,
			'autoinc' => false,
			'defaultValueSQL' => null,
			'defaultValue' => '' 
		),
		array(
			'name' => 'allocated_qty',
			'type' => 14,
			'size' => 14,
			'scale' => 2,
			'typeName' => 'decimal(14,2)',
			'nullable' => true,
			'autoinc' => false,
			'defaultValueSQL' => null,
			'defaultValue' => '' 
		),
		array(
			'name' => 'remaining_qty',
			'type' => 14,
			'size' => 14,
			'scale' => 2,
			'typeName' => 'decimal(14,2)',
			'nullable' => true,
			'autoinc' => false,
			'defaultValueSQL' => null,
			'defaultValue' => '' 
		),
		array(
			'name' => 'stock_available_status',
			'type' => 129,
			'size' => 0,
			'scale' => 0,
			'typeName' => 'enum(\'YES\',\'NO\',\'PARTIAL\')',
			'enumValues' => array( 
				'YES',
				'NO',
				'PARTIAL' 
			),
			'nullable' => true,
			'autoinc' => false,
			'defaultValueSQL' => null,
			'defaultValue' => '' 
		),
		array(
			'name' => 'item_status',
			'type' => 129,
			'size' => 0,
			'scale' => 0,
			'typeName' => 'enum(\'REQUESTED\',\'AVAILABLE\',\'PARTIAL\',\'NOT_AVAILABLE\',\'APPROVED\',\'PARTIALLY_APPROVED\',\'DISAPPROVED\',\'ISSUED\',\'CANCELLED\',\'RETURNED\')',
			'enumValues' => array( 
				'REQUESTED',
				'AVAILABLE',
				'PARTIAL',
				'NOT_AVAILABLE',
				'APPROVED',
				'PARTIALLY_APPROVED',
				'DISAPPROVED',
				'ISSUED',
				'CANCELLED',
				'RETURNED' 
			),
			'nullable' => false,
			'autoinc' => false,
			'defaultValueSQL' => 'REQUESTED',
			'defaultValue' => '' 
		),
		array(
			'name' => 'remarks',
			'type' => 200,
			'size' => 255,
			'scale' => 0,
			'typeName' => 'varchar(255)',
			'nullable' => true,
			'autoinc' => false,
			'defaultValueSQL' => null,
			'defaultValue' => '' 
		) 
	),
	'primaryKeys' => array( 
		 
	),
	'uniqueFields' => array( 
		 
	),
	'name' => 'vw_augmentation_request_item_allocation_summary' 
);
?>