Database: "OPOR"."DocEntry"

Database: "OPOR"."DocNum"

Database: "OPOR"."Ref2"

Database: "OPOR"."TaxDate"

Database: "OPOR"."DocDate"

Database: "OPOR"."DocDueDate"

Database: "OPOR"."BPLId"

Database: "OPOR"."Comments"

Entity Relation: BusinessPartner -> CardCode

Database: "OPOR"."CardCode"

Database: "OPOR"."CardName"

Database: "OPOR"."Printed"

Database: "OPOR"."DocStatus"

Document Number for the external Process.

The process is the Purchase Order + Provision process

Database: "BEAS_OWING_SUPPLIES"."DocEntry"

Status of the Process. C=Closed, O=Open

Database: case when "POR1"."LineStatus"='O' and coalesce("BEAS_OWING_SUPPLIES"."DocStatus",'C') <> 'C' then 'O' else 'C' end

The warehouse for external process. This is the warehouse on which the material must be trasnfered

Database: "BEAS_OWING_SUPPLIES"."WhsCode"

Database: "POR1"."InvQty"

Database: coalesce((select sum("PDN1"."InvQty") from "PDN1" where "PDN1"."BaseEntry"="POR1"."DocEntry" and "PDN1"."BaseType"=22 and "PDN1"."BaseLine"="POR1"."LineNum"),0)

Database: (select sum(coalesce("U_von_lag",0)) from "PDN1" where "PDN1"."BaseEntry"="POR1"."DocEntry" and "PDN1"."BaseLine"="POR1"."LineNum")

Database: coalesce((select sum("RPD1"."InvQty") from "PDN1" inner join "RPD1" on "RPD1"."BaseEntry"="PDN1"."DocEntry" and "RPD1"."BaseType"=20 and "RPD1"."BaseLine"="PDN1"."LineNum" where "PDN1"."BaseEntry"="POR1"."DocEntry" and "PDN1"."BaseType"=22 and "PDN1"."Ba

Return the delivery Address in correct format for defined Purchase Order

ExternalPurchaseOrder/getAddress(DocEntry)

Return:

{"address": "WhsStreet\n\nWhsCity GA 122345\nUSA"}

Example

ExternalPurchaseOrder/setReady(1024)