Epicor Prophet 21 Definitions of Mandatory Fields: Sales Order Automation (SOA) Accounts Payable (AP) Validations
Mandatory fields in Epicor Prophet 21 SOA and AP validations.
Conexiom can identify the following fields in the purchase order/accounts payable invoice/order acknowledgement and raise an alert if they are not found.
General
Output Name | Data Type and Definition |
Approved | Text Whether there is approval... (of what by who?) |
Carrier Id | Number The name of the freight company's identification. |
Company Id | Text The identification number of the trading partner...? (What is the company? PO's trading partner making the sale?} |
Customer Id | Number The identification number of the customer? (what is the customer? PO's customer?" |
Invoice Batch Number | Number The identification number of the group of invoices. |
Location Id | Number identification number of the location (of the customer PO customer?) |
Order Date | Date The date that the order was submitted |
PO No | Text The identification number of the PO itself. |
Source Location Id | Number The identification number of the source of the product or service. |
Requested Date | Date The date that the product or service would like the product or service. |
Ship To Id | Number The identification number of the company to whom the product or service will be delivered. |
Line Items
Output Name | Data Type |
Commission Cost | Number The cost of the (sales commission for the product or service?) |
Expedite Date | Date The date on which the (product or service should be delivered when the order has been expedited? |
Extended Price | Number The price of the product or service (after the addition of any fees, taxes, or other additional costs?) |
Line No | Number The physical line number of ....?) |
Other Cost | Number Other costs as defined by the customer? |
Promise Date | Date The date which the (product or service was promised for delivery?) |
Required Date | Date The date that the product or service is required. |
Source Loc Id | Number The identification number (of the source of the product or service?) |
Supplier Id | Number The identification number of the supplier of the product or service. |
Unit Price | Number The price of individual units of the product or service. |
Unit Quantity | Number The quantity of the individual units of the product or service. |
Accounts Payable (Invoice}
General
Output Name | Data Type |
PO No | Text The identification number of the Purchase Order (PO). |
PO number | The identification number of the Purchase Order (PO). Text |
Invoice Number | Text The identification number of the invoice. |
Customer ID | Text The identification number of the customer. |
Invoice Date | Date The date of the Invoice. |
|
|
Location ID | Text |
Line Items
Output Name | Data Type |
Item ID | Text |
Unit Quantity | Number |
Quantity to Invoice | Text |
Unit Price | Text |
Line Number | Text |