Details
| Name | Data Type | Is Nullable |
|---|---|---|
| Batch_id | Integer | True |
| Source_system | String | False |
| Source_table | String | False |
| View_name | String | False |
| Created_on | DateTime | False |
| Year_no | Integer | True |
| Quarter_no | Integer | True |
| Date_last_modified | DateTime | True |
| Warehousename | String | False |
| Storagename | String | False |
| Isinactive | Boolean | True |
| Fa_type | String | False |
| Prod_cat_name | String | False |
| Faprod_cat_name | String | False |
| Sysfaprod_cat_name | String | False |
| Agency_type | String | False |
| Sysagency_type | String | False |
| QPRSource | String | False |
| QPRColumn | String | False |
| Tot_quantity | Integer | True |
| Tot_value | Decimal | True |
| Tot_weight | Decimal | True |
| Tot_availableqty | Decimal | True |
| Dry | Decimal | True |
| Frozen | Decimal | True |
| Refrigerated | Decimal | True |
| Yellow | Decimal | False |
| Blue | Decimal | False |
| Local_all | Decimal | True |
| Donated | Decimal | True |
| Purchased | Decimal | True |
| Federal | Decimal | True |
| Grand_total | Decimal | True |
| County_name | String | False |
| Tefap | Decimal | True |
| Csfp | Decimal | True |
| Agency_count | Integer | True |
| Mobile_pantry_drops | Integer | True |
Object:
{
Batch_id":####,Source_system":"abcABC123",
Source_table":"abcABC123",
View_name":"abcABC123",
Created_on":"MM-dd-yyyy hh:mm:ss",
Year_no":####,
Quarter_no":####,
Date_last_modified":"MM-dd-yyyy hh:mm:ss",
Warehousename":"abcABC123",
Storagename":"abcABC123",
Isinactive":True/False,
Fa_type":"abcABC123",
Prod_cat_name":"abcABC123",
Faprod_cat_name":"abcABC123",
Sysfaprod_cat_name":"abcABC123",
Agency_type":"abcABC123",
Sysagency_type":"abcABC123",
QPRSource":"abcABC123",
QPRColumn":"abcABC123",
Tot_quantity":####,
Tot_value":###.##,
Tot_weight":###.##,
Tot_availableqty":###.##,
Dry":###.##,
Frozen":###.##,
Refrigerated":###.##,
Yellow":###.##,
Blue":###.##,
Local_all":###.##,
Donated":###.##,
Purchased":###.##,
Federal":###.##,
Grand_total":###.##,
County_name":"abcABC123",
Tefap":###.##,
Csfp":###.##,
Agency_count":####,
Mobile_pantry_drops":####
}