Order Inspection

This table shows the Infor LN tables from which fields are retrieved for the dimension:

Table Description

qmptc120

Order Inspection

qmptc220

Storage Inspection

This table shows the attribute mapping to LN table fields for the dimension:

Attribute Mapping
Active Date qmptc120.acdt\ qmptc220.acdt
Canceled Date qmptc120.cndt\ qmptc220.cndt
Closed Date qmptc120.cldt\ qmptc220.cldt
Company qmptc120.compnr\ qmptc220.compnr
Completed Date qmptc120.cdat\ qmptc220.cdat
Current Status qmptc120.rsta\ qmptc220.rsta
Creation Date qmptc120.crdt\ qmptc220.crdt
Is Current 1 if it is the latest record, else 0
Order Inspection qmptc120.orgn\ qmptc120.orno\ qmptc120.pono

qmptc120.opno\ qmptc120.wstt\ qmptc120.seqn

qmptc120.apno\ qmptc120.apsq\ qmptc120.huid

or, qmptc220.item\ qmptc220.effn\ qmptc220.revi\ qmptc220.seqn

Order Type For qmptc120 Order Inspection, for qmptc220 Storage Inspection
Order Unit qmptc120.cuoq
Previous Status Calculated from the previous record
Processed Date qmptc120.pdat\ qmptc20.crdt
Status Sequence Number qmptc120.stat_chno
Unknown 1 for null records, else 0
deleted 1 if deleted in LN, else 0
Customer Defined Fields Standard list of fields