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 |