api/POReceiptsEntry/Query (POST)
Queries existing PO Receipts using the provided query data.
HTTP Method: POST
Required Fields: At least one field as search criteria
Requires an Authentication Token in the AuthToken HTTP header. Authentication Tokens are obtained from api/Security/Login (POST).
Returns all found PO Receipts.
Request Information
Parameters
| Name | Description | Additional information |
|---|---|---|
| RequestData | This is a JSON object containing PO Receipt query data.
Query Single PO Receipt Using Key Fields Example:
{
"RECNUM": "4001",
"PO_ID": "123456",
"LINE_NUMBER": "1.00",
"ACTION_DATE": "7/10/2015"
}
Returns 1 PO Receipt if successful.
This is like 'Find' in Expandable.
Query Multiple PO Receipts Using Other Fields Example:
{
"PART_ID": "MOTOR003",
"ACTION_TYPE": "PO"
}
Returns 1 or more PO Receipts if successful.
This is like 'QBE' in Expandable.
Query Multiple PO Receipts Using QBE Conditional Notation Example:
{
"QUANTITY": ""> 10",
"ACTION_TYPE": "IN 'PQ','QA'"
}
Returns 1 or more PO Receipts if successful.
This is like 'QBE' in Expandable.
Accepted PO Receipts Entry Fields:
ACCOUNT, ACCRUAL_JV_DATE, ACCRUAL_JV_MO, ACCRUAL_JV_YR,
ACTION_DATE, ACTION_TYPE, AP_BC_RATE, AP_CURR_RATE,
AP_UNIT_COST, BATCH_NUMBER, BC_RATE, BC_TOTAL_STD,
BUY_CONV, BUY_DEC, COMPANY_ID, CREATED_BY,
DATE_CREATED, DATE_LAST_EDI, DATE_LAST_UPDT, DATE_MODIFIED,
DELIVERY_DATE, DEPARTMENT, DM_PRINT_DATE, GL_MONTH,
GL_YEAR, INV_QUANTITY, INVOICE_DATE, INVOICE_ID,
INVOICE_LN_QTY, JOB_ID, LINE_NUMBER, LOT_ID,
MODIFIED_BY, OPER_CODE, OPERATOR_ID, PART_ID,
PART_UM, PO_BC_RATE, PO_CURR_RATE, PO_ID,
PO_UM, PO_UNIT_COST, POFRT_USER_1, POFRT_USER_2,
POFRT_USER_3, POFRT_USER_4, PROGRAM_ID, QTY_INSPECTED,
QUANTITY, REASON_CODE, RECNUM, REFERENCE,
REPORT_FLAG, REQ_DEL_DATE, REV_DEL_DATE, STD_MTL_CST_CUM,
STOCK_LOCATION, STORES_CODE, TIME_LAST_UPDT, TOTAL_STD_COST,
VENDR_SHIP_TIME |
Define this parameter in the request body. |
Response Information
Success:200/OK
Body contains JSON array with found PO Receipts.
Error:
400/Request JSON is invalid.
401/AuthToken was not provided.
401/AuthToken is malformed.
401/AuthToken is expired.
401/AuthToken login failure.
500/(Message)
Body contains JSON object with Message and MessageCode.
Returned PO Receipts Entry Fields:
ACCOUNT, ACCRUAL_JV_DATE, ACCRUAL_JV_MO, ACCRUAL_JV_YR, ACTION_DATE, ACTION_TYPE, AP_BC_RATE, AP_CURR_RATE, AP_UNIT_COST, BATCH_NUMBER, BC_RATE, BC_TOTAL_STD, BUY_CONV, BUY_DEC, COMPANY_ID, CREATED_BY, DATE_CREATED, DATE_LAST_EDI, DATE_LAST_UPDT, DATE_MODIFIED, DELIVERY_DATE, DEPARTMENT, DM_PRINT_DATE, GL_MONTH, GL_YEAR, INV_QUANTITY, INVOICE_DATE, INVOICE_ID, INVOICE_LN_QTY, JOB_ID, LINE_NUMBER, LOT_ID, MODIFIED_BY, OPER_CODE, OPERATOR_ID, PART_ID, PART_UM, PO_BC_RATE, PO_CURR_RATE, PO_ID, PO_UM, PO_UNIT_COST, POFRT_USER_1, POFRT_USER_2, POFRT_USER_3, POFRT_USER_4, PROGRAM_ID, QTY_INSPECTED, QUANTITY, REASON_CODE, RECNUM, REFERENCE, REPORT_FLAG, REQ_DEL_DATE, REV_DEL_DATE, STD_MTL_CST_CUM, STOCK_LOCATION, STORES_CODE, TIME_LAST_UPDT, TOTAL_STD_COST, VENDR_SHIP_TIME