Skip to main content
Skip table of contents

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

 

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.