Entity Relation: QCOrderSamples -> DocEntry

Entity Relation: QCOrderMeasurement -> DocEntry

Entity Relation: QCOrderAttachment -> DocEntry

Database: "BEAS_QSFTHAUPT"."DocEntry"

Id of the QC order document

First letter present the document type

Goods receipt PO (I) Purchase goods receipt

Production (E) Assembly posting in production

Sales-Return (R) Sales credit or offset

Reaching Date of Expiry (C) Set at "batches to be verified"

Stock transfer (T) for stock transfer

Goods Receipt (M) for all manual postings

AP Invoice (X) purchase invoices

Negative Purchase returns (Y) for returns from purchase with negative amounts

Credit Memos (O) credit memos

Negative Delivery (P) deliveries with negative amounts

Negative Invoices (Q) invoices with negative amounts

Split batch (A) At batch split

Transfer batch (B) At a batch transfer

At the end, the number of the origin document is displayed (goods receipt, work order document etc.)

Primary key

Database: "BEAS_QSFTHAUPT"."CHARGE_ID"

Primary key

Database: "BEAS_QSFTHAUPT"."BELNR_ID"

Database: "BEAS_QSFTHAUPT"."PRODUZIERT_AM"

Entity Relation: Item -> ItemCode

Linked table: OITM

Linked column: ItemCode

Database: "BEAS_QSFTHAUPT"."ItemCode"

Database: "BEAS_QSFTHAUPT"."BEZ"

Database: "BEAS_QSFTHAUPT"."U_beas_ver"

Database: "BEAS_QSFTHAUPT"."ZNR"

Database: "BEAS_QSFTHAUPT"."WhsCode_ORG"

Quantity in Stock unit

Database: "BEAS_QSFTHAUPT"."MENGE"

Stock onut

Linked table: BEAS_ME

Linked column: ME_ID

Database: "BEAS_QSFTHAUPT"."ME_ID"

Database: "BEAS_QSFTHAUPT"."QcInfo"

Database: rtrim("BEAS_QSFTHAUPT"."BatchNum")

Linked table: BEAS_QSARTIKELHAUPT

Linked column: ItemCode

Database: "BEAS_QSFTHAUPT"."PRUEFAUFTRAG"

If defined: This QC order is part of QC order .... lined to field BEAS_QSFTHAUPT.CHARGE_ID (DocumentNumber)

Linked table: BEAS_QSFTHAUPT

Linked column: PARENTCHARGEID

Database: "BEAS_QSFTHAUPT"."ParentChargeId"

In Item Master Data you can define the link to the QC Inspection plan

In this field the Number of link is saved

Linked table: BEAS_QSVERWEIS

Linked column: NR

Database: "BEAS_QSFTHAUPT"."QcItemNr"

In Item QC Link you can define a rule

This rule is additional check for parallel qc orders.

Linked table: BEAS_QSARTIKELSUB

Linked column: RuleId

Database: "BEAS_QSFTHAUPT"."RuleId"

Type of Base document

Constraints:

Goods receipt PO=W

Manufacturing Access=E

Operation=F

Exceeded Expiry date=C

Stock transfer=U

Book in manually=M

Return=R

Stock transfer=T

Batch=B

A/P invoice=X

Shopping return=Y

Incoming credit note=Z

Outgoing credit=O

Delivery=P

Outgoing invoice=Q

Database: "BEAS_QSFTHAUPT"."TYP"

Database: "BEAS_QSFTHAUPT"."BaseType"

Database: "BEAS_QSFTHAUPT"."BASEDOCENTRY"

Database: "BEAS_QSFTHAUPT"."BASEORDER"

Database: "BEAS_QSFTHAUPT"."BASELINENUM"

Database: "BEAS_QSFTHAUPT"."BASELINENUM2"

Database: rtrim("BEAS_QSFTHAUPT"."CardCode")

Project Id

Linked table: OPRJ

Linked column: PrjCode

Database: "BEAS_QSFTHAUPT"."Project"

Link to Project Line

Linked table: BEAS_PRJ_LINE

Linked column: PRJUID

Database: "BEAS_QSFTHAUPT"."PRJUID"

Internal User Sign

Linked table: OUSR

Linked column: INTERNAL_K

Database: "BEAS_QSFTHAUPT"."INTERNAL_K"

Created by Personell Id

Linked table: BEAS_PERS

Linked column: PERS_ID

Database: "BEAS_QSFTHAUPT"."PERS_ID"

Database: "BEAS_QSFTHAUPT"."BEASVERSION"

Database: "BEAS_QSFTHAUPT"."STATION"

Database: "BEAS_QSFTHAUPT"."FERT_BELNR_ID"

Database: "BEAS_QSFTHAUPT"."FERT_BELPOS_ID"

Database: "BEAS_QSFTHAUPT"."FERT_POS_ID"

Database: (select count(*) from "BEAS_QSFTMESSUNG" where "BEAS_QSFTMESSUNG"."CHARGE_ID"="BEAS_QSFTHAUPT"."CHARGE_ID" and "BEAS_QSFTMESSUNG"."BELNR_ID"="BEAS_QSFTHAUPT"."BELNR_ID" and Coalesce("BEAS_QSFTMESSUNG"."Release",0)<>1 and "BEAS_QSFTMESSUNG"."PRUEFKZ" not i

Database: (select count(*) from "BEAS_QSFTMESSUNG" where "BEAS_QSFTMESSUNG"."CHARGE_ID"="BEAS_QSFTHAUPT"."CHARGE_ID" and "BEAS_QSFTMESSUNG"."BELNR_ID"="BEAS_QSFTHAUPT"."BELNR_ID" and Coalesce("BEAS_QSFTMESSUNG"."Release",0)=1)

Database: (select count(*) from "BEAS_QSFTMESSUNG" where "BEAS_QSFTMESSUNG"."CHARGE_ID"="BEAS_QSFTHAUPT"."CHARGE_ID" and "BEAS_QSFTMESSUNG"."BELNR_ID"="BEAS_QSFTHAUPT"."BELNR_ID" and Coalesce("BEAS_QSFTMESSUNG"."Release",0)<>1 and "BEAS_QSFTMESSUNG"."PRUEFKZ" in ('

Database: case when "BEAS_QSFTHAUPT"."DRUCKKZ" = 'J' then 1 else 0 end

Constraints:

no transfer needed=0

open=1

booked=2

Database: coalesce("BEAS_QSFTHAUPT"."MaterialTransfer",0)

Database: "BEAS_QSFTHAUPT"."Release"

Database: "BEAS_QSFTHAUPT"."ReleasePersId"

Database: "BEAS_QSFTHAUPT"."ReleasePersName"

Database: "BEAS_QSFTHAUPT"."ReleaseStationId"

Database: "BEAS_QSFTHAUPT"."ReleaseDate"

Linked table: BEAS_QSVALUATION

Linked column: ValuationId

Database: "BEAS_QSFTHAUPT"."BEWERTUNG"

Database: "BEAS_QSFTHAUPT"."BEWERTUNGINFO"

Linked table: BEAS_QSSPERRGRUND

Linked column: SPERRGRUNDID

Database: "BEAS_QSFTHAUPT"."SPERRGRUNDID"

Database: "BEAS_QSFTHAUPT"."SPERRGRUND"

Database: case when "BEAS_QSFTHAUPT"."ABGKZ" = 'J' then 1 else 0 end

Database: "BEAS_QSFTHAUPT"."CloseOrderDate"

Database: "BEAS_QSFTHAUPT"."CloseOrderPersName"

Database: "BEAS_QSFTHAUPT"."BILD1"

Database: "BEAS_QSFTHAUPT"."BILD2"

Database: "BEAS_QSFTHAUPT"."BILD3"

Database: "BEAS_QSFTHAUPT"."UDF1"

Database: "BEAS_QSFTHAUPT"."UDF2"

Database: "BEAS_QSFTHAUPT"."UDF3"

Database: "BEAS_QSFTHAUPT"."UDF4"

Database: "BEAS_QSFTHAUPT"."UDF5"

Database: "BEAS_QSFTHAUPT"."UDF6"

Database: "BEAS_QSFTHAUPT"."UDF7"

Database: "BEAS_QSFTHAUPT"."UDF8"

Database: "BEAS_QSFTHAUPT"."UDF9"

Database: "BEAS_QSFTHAUPT"."UDF10"

Database: "BEAS_QSFTHAUPT"."UDF11"

Database: "BEAS_QSFTHAUPT"."UDF12"

Database: "BEAS_QSFTHAUPT"."UDF13"

Database: "BEAS_QSFTHAUPT"."UDF14"

Database: "BEAS_QSFTHAUPT"."UDF15"

Database: "BEAS_QSFTHAUPT"."ANDTSTAMP"

Primary key

Database: "BEAS_QSFTHAUPT"."ANDUSER"

Generte QC order for all batches, which locked and a Inspection plan is defined for this scenario

Create a QC order related to a document

Type:

F = Workorder routing position (Docentry=0, BaseX=Reference to the the Routing Position)

E = Work order BoM - PostIn Document (Docentry = PostIn Document, Base = Reference to the BoM Position)

For all other types please use CreateQcORderFromSAPDocument

Example: Create QC Order for a Routing Position

The DocEntry is always 0

get QCOrder/CreateQcOrder("F",0,1000,10,10 )

Note:

If you need QC order related to Issue/Receipt document, please use

get QCORder/CreateQcOrderFromSAPDocument

Create a QC Order based on a SAP Goods Receipt PO for all lines, if a QC Inspection plan is defined for this items and related rules defined in configuration wizzard

Example:

QCOrder/CreateQcOrderFromGoodsReceiptPO(100) -> Create QC order for Purchase Order with DocEntry=100

Create a QC Order based on a SAP Document for all lines, if a QC Inspection plan is defined for this items and related rules defined in configuration wizzard

Define the SAP Document by Table Name, example

from manual post in document

QCOrder/CreateQcOrderFromSAPDocment(100,"OIGE")

beas Script

declare bsl b
b.GET QCOrder/CreateQcOrderFromSAPDocment(100,"OIGE")

Note: The system can generate more then one QC Document. The System don't return the created Document number

Note: if QC Document created by transaction notification, you must use the function

CreateQcOrderFromSAPDocumentDirect(DocEntry,Table )

Same as CreateQcOrderFromSAPDocument

But create QC order always and ignore transaction notification settings.

Check Messurements, Samples,

Release Samples, if all Measurements ok

Release Order, if all Samples released

Related to settings in QC Plan.

Return Status 200 if no error, otherwise 400 with Error message.

odata4/QCOrder/CheckRelease(1250)

Check, if Release is possible and release the QC order

Note: Electonic Signature not checked. The front end must do this self.

odata4/QCOrder/ReleaseQcOrder(1408)

return only status 200 OK or 404 not ok

Allow to close defined QC Order (DocEntry)

odata4/QCOrder/CloseQcOrder(1408)

return only status 200 OK or 404 not ok

Allow creation of new sample inside an existing QC order

odata4/QCOrder/CreateSample(1408)

Return Json

{
"DocEntry": [current DocEntry],
"LineNumber": [number of created Sample]
}

This return all related batches from the QC order

this is working, if QC order created from SAP Document AND manually without any transaction

This return the array value with follow objects

ItemCode, SystemNumber, Status and Batch

get QCOrder/QCOrderBatches(18)

return follow JSON (example)

{
    "value": [
        {
            "ItemCode": "po_batchauto",
            "SystemNumber": 1011,
            "Status": "0",
            "Batch": "abc-1"
        },
        {
            "ItemCode": "po_batchauto",
            "SystemNumber": 1009,
            "Status": "0",
            "Batch": "abc-2"
        },
        {
            "ItemCode": "po_batchauto",
            "SystemNumber": 1010,
            "Status": "0",
            "Batch": "abc-3"
        }
    ]
}

Load all items, batch. and serial numbers, which must transfered

(Beas: Transfer function)

get QCOrder/TransferLoad(1410)

{
    "value": [
        {
            "Quantity": 2,
            "ItemCode": "po_batchauto",
            "WhsCode": "01",
            "Version": "1",
            "DistNumber": "abc-2",
            "Bincode": "",
            "RFID": null,
            "RejectQuantity": 0,
            "TotalQuantity": 0,
            "OpenQuantity": 2,
            "SystemNumber": 1009,
            "GoodQuantity": 0
        },
        {
            "Quantity": 3,
            "ItemCode": "po_batchauto",
            "WhsCode": "01",
            "Version": "1",
            "DistNumber": "abc-3",
            "Bincode": "",
            "RFID": null,
            "RejectQuantity": 0,
            "TotalQuantity": 0,
            "OpenQuantity": 3,
            "SystemNumber": 1010,
            "GoodQuantity": 0
        }
	]
}

Return the target transfer warehouse related to rejected flag

GET QCOrder/TransferGetWareHouse(1413,false)

return follow properties

{
    "ToWhsCode": "SAP_BIN",
    "ToBinCode": "SAP_BIN-AREA_B",
	 "RuleId": "test",
    "Description": "test1 QC"
}

The system return the description of warehouse rule, if existing

If no rule found, the system return the default warehouse from the item and ToBinCode and Description is empty