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 |