api/ARInvoiceEntry/Query (POST)

Queries existing AR Invoices 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 AR Invoices.

Request Information

Parameters

NameDescriptionAdditional information
RequestData 
This is a JSON object containing AR Invoice query data.

Query Single AR Invoice Using Key Fields Example:
{
  "INVOICE_NUMBER": "821"
}
Returns 1 AR Invoice if successful.
This is like 'Find' in Expandable.

Query Multiple AR Invoices Using Other Fields Example:
{
  "INVOICE_TYPE": "SI",
  "CUSTOMER_ID": "ABCCORP"
}
Returns 1 or more AR Invoices if successful.
This is like 'QBE' in Expandable.

Query Multiple AR Invoices Using QBE Conditional Notation Example:
{
  "INVOICE_TAX_AMT": ""> 0",
  "SALES_REGION": "IN 'EAST','WEST'"
}
Returns 1 or more AR Invoices if successful.
This is like 'QBE' in Expandable.

Accepted AR Invoice Entry Fields:
AR_COMPANY_ID, AR_REMIT_TO, ARFIM_USER_1, ARFIM_USER_10, 
ARFIM_USER_11, ARFIM_USER_12, ARFIM_USER_13, ARFIM_USER_14, 
ARFIM_USER_15, ARFIM_USER_16, ARFIM_USER_17, ARFIM_USER_18, 
ARFIM_USER_19, ARFIM_USER_2, ARFIM_USER_20, ARFIM_USER_21, 
ARFIM_USER_22, ARFIM_USER_23, ARFIM_USER_24, ARFIM_USER_3, 
ARFIM_USER_4, ARFIM_USER_5, ARFIM_USER_6, ARFIM_USER_7, 
ARFIM_USER_8, ARFIM_USER_9, AUTH_CODE, BANK_CARD_GUID, 
BANK_CARD_ID, BANK_CODE, BANK_CONTROL_ID, BATCH_NUMBER, 
BC_RATE, CARD_NAME, CARD_PHONE_NO, CARD_TYPE, 
CC_AUTH_AMT, CC_RTG_ID, CC_SECURITY_ID, CCVERIFY_MMYY, 
CREATED_BY, CURR_CODE, CURR_RATE, CURRENT_BALANCE, 
CUST_PO_ID, CUSTOMER_ID, DATE_BANK_PRINT, DATE_CREATED, 
DATE_LAST_EDI, DATE_LAST_PRINT, DATE_LAST_UPDT, DATE_MODIFIED, 
DISCOUNT_AMT, DISCOUNT_DATE, DUE_DATE, E_MAIL, 
E_MAIL_DATE, EXPIRATION, FOB, FREIGHT_CODE, 
GL_MONTH, GL_YEAR, INVOICE_AMT, INVOICE_AMT_OLD, 
INVOICE_DATE, INVOICE_FRT_AMT, INVOICE_LC_AMT, INVOICE_NUMBER, 
INVOICE_ORIG, INVOICE_STATUS, INVOICE_TAX_10, INVOICE_TAX_2, 
INVOICE_TAX_3, INVOICE_TAX_4, INVOICE_TAX_5, INVOICE_TAX_6, 
INVOICE_TAX_7, INVOICE_TAX_8, INVOICE_TAX_9, INVOICE_TAX_AMT, 
INVOICE_TYPE, INVOICE_VAT, LC_AMT_PAID, LC_CURRENT_BAL, 
LC_DISC_LOST, LC_DISC_USED, LC_MEMO_AMT, MODIFIED_BY, 
NEXT_PAY_AMT, NEXT_PAY_DATE, NEXT_PAY_DISC, NO_HOLD_FLAG, 
OPERATOR_ID, ORDER_CLASS, ORDER_DISC_PCT, ORDER_TAKER, 
PAYMENT_TYPE, REFERENCE, REMARK, REPRINT_FLAG, 
SALES_REGION, SALESMAN_ID, SHIP_METHOD, SHIP_TO_CUST, 
SO_ID, SO_TYPE, SOLD_TO_CUST, TAX_CODE, 
TERMS_CODE, TIME_LAST_UPDT, TOTAL_AMT_PAID, TOTAL_DISC_LOST, 
TOTAL_DISC_USED, TOTAL_MEMO_AMT

Define this parameter in the request body.

Response Information

Success:
200/OK
Body contains JSON array with found AR Invoices.

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 AR Invoice Entry Fields:
AR_COMPANY_ID, AR_REMIT_TO, ARFIM_USER_1, ARFIM_USER_10, ARFIM_USER_11, ARFIM_USER_12, ARFIM_USER_13, ARFIM_USER_14, ARFIM_USER_15, ARFIM_USER_16, ARFIM_USER_17, ARFIM_USER_18, ARFIM_USER_19, ARFIM_USER_2, ARFIM_USER_20, ARFIM_USER_21, ARFIM_USER_22, ARFIM_USER_23, ARFIM_USER_24, ARFIM_USER_3, ARFIM_USER_4, ARFIM_USER_5, ARFIM_USER_6, ARFIM_USER_7, ARFIM_USER_8, ARFIM_USER_9, AUTH_CODE, BANK_CARD_GUID, BANK_CARD_ID, BANK_CODE, BANK_CONTROL_ID, BATCH_NUMBER, BC_RATE, CARD_NAME, CARD_PHONE_NO, CARD_TYPE, CC_AUTH_AMT, CC_RTG_ID, CC_SECURITY_ID, CCVERIFY_MMYY, CREATED_BY, CURR_CODE, CURR_RATE, CURRENT_BALANCE, CUST_PO_ID, CUSTOMER_ID, DATE_BANK_PRINT, DATE_CREATED, DATE_LAST_EDI, DATE_LAST_PRINT, DATE_LAST_UPDT, DATE_MODIFIED, DISCOUNT_AMT, DISCOUNT_DATE, DUE_DATE, E_MAIL, E_MAIL_DATE, EXPIRATION, FOB, FREIGHT_CODE, GL_MONTH, GL_YEAR, INVOICE_AMT, INVOICE_AMT_OLD, INVOICE_DATE, INVOICE_FRT_AMT, INVOICE_LC_AMT, INVOICE_NUMBER, INVOICE_ORIG, INVOICE_STATUS, INVOICE_TAX_10, INVOICE_TAX_2, INVOICE_TAX_3, INVOICE_TAX_4, INVOICE_TAX_5, INVOICE_TAX_6, INVOICE_TAX_7, INVOICE_TAX_8, INVOICE_TAX_9, INVOICE_TAX_AMT, INVOICE_TYPE, INVOICE_VAT, LC_AMT_PAID, LC_CURRENT_BAL, LC_DISC_LOST, LC_DISC_USED, LC_MEMO_AMT, MODIFIED_BY, NEXT_PAY_AMT, NEXT_PAY_DATE, NEXT_PAY_DISC, NO_HOLD_FLAG, OPERATOR_ID, ORDER_CLASS, ORDER_DISC_PCT, ORDER_TAKER, PAYMENT_TYPE, REFERENCE, REMARK, REPRINT_FLAG, SALES_REGION, SALESMAN_ID, SHIP_METHOD, SHIP_TO_CUST, SO_ID, SO_TYPE, SOLD_TO_CUST, TAX_CODE, TERMS_CODE, TIME_LAST_UPDT, TOTAL_AMT_PAID, TOTAL_DISC_LOST, TOTAL_DISC_USED, TOTAL_MEMO_AMT

Returned AR Invoice Entry Detail Fields:
ACCOUNT, ACTION_DATE, ACTION_TYPE, AMOUNT, ARFID_USER_1, ARFID_USER_2, BALANCE_DUE, BASE_PRICE, BILL_OF_LADING, COMMISSION_PCT, COMPANY_ID, COST_AMT, CREATED_BY, CUST_PART_ID, DATE_CREATED, DATE_LAST_UPDT, DATE_MODIFIED, DEPARTMENT, DWG_REV, ECN, FOB, FREIGHT_CODE, INV_LINE_NO, INV_QUANTITY, INVOICE_NUMBER, ITEM_DISC_PCT, JOB_ID, LC_LINE_AMT, LC_LINE_DISC, LC_LINE_TAX, LINE_ORDER_DISC, LINE_TAX_10, LINE_TAX_2, LINE_TAX_3, LINE_TAX_4, LINE_TAX_5, LINE_TAX_6, LINE_TAX_7, LINE_TAX_8, LINE_TAX_9, LINE_TAX_AMT, LINE_VAT, MODIFIED_BY, NUMBER_CARTONS, OPER_CODE, OPERATOR_ID, PART_ID, PART_UM, PRICE_CODE, PRICE_CONV, PRICE_UM, PROD_DISC_AMT1, PROD_DISC_AMT2, PROD_DISC_AMT3, PROD_DISC_CODE1, PROD_DISC_CODE2, PROD_DISC_CODE3, PRODUCT_LINE, QUANTITY, RA_REASON, REFERENCE, REPORT_FLAG, REV_ORDER_QTY, REVREC_ADJ, RR_PROCESSED, SALES_ACCT, SALES_COMM, SALES_DEPT, SALES_REGION, SALESMAN_ID, SHIP_METHOD, SHIP_TO_CUST, SHIP_TYPE, SHIPMENT_NO, SO_DESC, SO_LINE_NO, SO_UM, SO_UNIT_COST, SO_UNIT_PRICE, STORES_CODE, TAX_CODE, TIME_LAST_UPDT, VAT_CODE, WEIGHT