Details
| Name | Data Type | Is Nullable |
|---|---|---|
| Unique_key | String | False |
| Receipt_id | Integer | True |
| Receiptdetail_id | Integer | True |
| Order_id | Integer | True |
| Orderdetail_id | Integer | True |
| Inventoryadjustment_id | Integer | True |
| Inventory_id | Integer | True |
| Product_id | Integer | True |
| Productcategory_id | Integer | True |
| Contributor_id | Integer | True |
| System_record_type_id | Integer | True |
| System_record_type | String | False |
| Agency_id | Integer | True |
| Business_key | Integer | False |
| Item_no | Integer | True |
| Posting_date | DateTime | True |
| CHOPRating | String | False |
| Quantity | Integer | False |
| Total_gross_weight | Decimal | True |
| Date_last_modified | DateTime | True |
| Document_no | String | False |
| Location_code | String | False |
| Lot_no | Integer | True |
| Source_no | String | False |
| Entry_type | String | False |
| Source_type | String | False |
| Unit_of_measure_code | String | False |
| Unit_gross_weight | Decimal | True |
| Fbc_county | String | False |
| Sdo | String | False |
| Food_bank_program | String | False |
| Parent_source_no | Integer | True |
| Unc_food_bank_id | String | False |
| Reason_code | String | False |
| Mobile_pantry | Boolean | False |
| Fbc_agency_category_code | String | False |
| Unc_agency_category_code | String | False |
| Source_table | String | False |
| ConfirmedDate | DateTime | True |
| IsConfirmed | String | False |
| Waste_field | String | False |
| Agency_type | String | False |
| QPRSource | String | False |
| QPRColumn | String | False |
| StorageName | String | False |
| AdjustmentreferenceCode | String | False |
| PickupDeliveryDate | DateTime | True |
| FaProductCategoryid | Integer | True |
| OriginationId | Integer | True |
| ContributorId | Integer | True |
| DonationTypeId | Integer | True |
| QprGroupId | Integer | True |
| QprColumnId | Integer | True |
| Nutritionid | Integer | True |
| Warehouseid | Integer | True |
| AdjustmentReasonid | Integer | True |
| Countyid | Integer | True |
Object:
{
Unique_key":"abcABC123",Receipt_id":####,
Receiptdetail_id":####,
Order_id":####,
Orderdetail_id":####,
Inventoryadjustment_id":####,
Inventory_id":####,
Product_id":####,
Productcategory_id":####,
Contributor_id":####,
System_record_type_id":####,
System_record_type":"abcABC123",
Agency_id":####,
Business_key":####,
Item_no":####,
Posting_date":"MM-dd-yyyy hh:mm:ss",
CHOPRating":"abcABC123",
Quantity":####,
Total_gross_weight":###.##,
Date_last_modified":"MM-dd-yyyy hh:mm:ss",
Document_no":"abcABC123",
Location_code":"abcABC123",
Lot_no":####,
Source_no":"abcABC123",
Entry_type":"abcABC123",
Source_type":"abcABC123",
Unit_of_measure_code":"abcABC123",
Unit_gross_weight":###.##,
Fbc_county":"abcABC123",
Sdo":"abcABC123",
Food_bank_program":"abcABC123",
Parent_source_no":####,
Unc_food_bank_id":"abcABC123",
Reason_code":"abcABC123",
Mobile_pantry":True/False,
Fbc_agency_category_code":"abcABC123",
Unc_agency_category_code":"abcABC123",
Source_table":"abcABC123",
ConfirmedDate":"MM-dd-yyyy hh:mm:ss",
IsConfirmed":"abcABC123",
Waste_field":"abcABC123",
Agency_type":"abcABC123",
QPRSource":"abcABC123",
QPRColumn":"abcABC123",
StorageName":"abcABC123",
AdjustmentreferenceCode":"abcABC123",
PickupDeliveryDate":"MM-dd-yyyy hh:mm:ss",
FaProductCategoryid":####,
OriginationId":####,
ContributorId":####,
DonationTypeId":####,
QprGroupId":####,
QprColumnId":####,
Nutritionid":####,
Warehouseid":####,
AdjustmentReasonid":####,
Countyid":####
}