PRT_PRCRL_CENTRALREFLIST_INFO
This table contains the Part main details for a Organization Unit Group.
Process: INVENTORY · Component: BasPartAdmn · Table type: Master Table Category: Holds master details of aircraft, parts, and components for accurate technical and operational reference in transactions.
This table is the canonical store for the Part entity.
Primary key
PRCRL_PART_NO, PRCRL_CREATED_OUINSTANCE
Columns (74)
| # | Column | Type | Description |
|---|---|---|---|
| 1 | PRCRL_CREATED_OUINSTANCE 🔑 | varchar | Organization Unit instance for part reference |
| 2 | PRCRL_PART_NO 🔑 | varchar | Part number |
| 3 | PRCRL_PART_DESC | varchar | Part description |
| 4 | PRCRL_PART_DESC_UP | varchar | Part description in uppercase |
| 5 | PRCRL_REFERENCE_STATUS | varchar | Reference status of the part |
| 6 | PRCRL_KEYWORD | varchar | Keyword associated with the part |
| 7 | PRCRL_KEYWORD_UP | varchar | Keyword in uppercase |
| 8 | PRCRL_PART_TYPE | varchar | Part type |
| 9 | PRCRL_PART_CATEGORY | varchar | Part category |
| 10 | PRCRL_MANUF_PART_NO | varchar | Manufacturer part number |
| 11 | PRCRL_FILENAME | varchar | File name |
| 12 | PRCRL_BASE_PART_NO | varchar | Base part number |
| 13 | PRCRL_MANUF_NO | decimal | Manufacturer number |
| 14 | PRCRL_AC_MANUF_OU | decimal | Aircraft manufacturer Organization Unit |
| 15 | PRCRL_SUP_MANUF_OU | varchar | Supplier manufacturer Organization Unit |
| 16 | PRCRL_ISSUE_BASIS | varchar | Issue basis |
| 17 | PRCRL_PART_CNTRL_TYPE | varchar | Part control type |
| 18 | PRCRL_PREV_PART_NO | varchar | Previous part number |
| 19 | PRCRL_DRAWING_REF | varchar | Drawing reference |
| 20 | PRCRL_DRAWING_REVISION_NO | varchar | Drawing revision number |
| 21 | PRCRL_MOD_STATUS_NO | varchar | Modification status number |
| 22 | PRCRL_SOURCE_DOC_TYPE | decimal | Source document type |
| 23 | PRCRL_SOURCE_DOC_OUINSTANCE | varchar | Source document Organization Unit instance |
| 24 | PRCRL_SOURCE_DOC_NO | varchar | Source document number |
| 25 | PRCRL_SUGGESTED_PART_NO | varchar | Suggested part number |
| 26 | PRCRL_DOC_REVISION_NO | varchar | Document revision number |
| 27 | PRCRL_MATERIAL_SPEC | varchar | Material specification |
| 28 | PRCRL_SL_NO_CONTROL_FLAG | varchar | Serial number control flag |
| 29 | PRCRL_SL_NO_LOGIC | varchar | Serial number logic |
| 30 | PRCRL_SL_NO_TYPE_NO | varchar | Serial number type |
| 31 | PRCRL_LOT_NO_CONTROL_FLAG | varchar | Lot number control flag |
| 32 | PRCRL_LOT_NO_TYPE_NO | decimal | Lot number type |
| 33 | PRCRL_STD_COST | varchar | Standard cost |
| 34 | PRCRL_PLANNING_TYPE | varchar | Planning type |
| 35 | PRCRL_EXPENCE_TYPE | varchar | Expense type |
| 36 | PRCRL_SHELF_LIFE_UNIT | decimal | Shelf life unit |
| 37 | PRCRL_DESIGNED_SHELF_LIFE | decimal | Designed shelf life |
| 38 | PRCRL_MIN_SHELF_LIFE | decimal | Minimum shelf life |
| 39 | PRCRL_ALERT_VALUE | decimal | Alert value for shelf life |
| 40 | PRCRL_UOM_OUINSTANCE | varchar | Unit of Measure Organization Unit instance |
| 41 | PRCRL_STOCK_UOM | decimal | Stock Unit of Measure |
| 42 | PRCRL_GROSS_VOLUME | varchar | Gross volume |
| 43 | PRCRL_VOLUME_UOM | decimal | Volume Unit of Measure |
| 44 | PRCRL_GROSS_WEIGHT | varchar | Gross weight |
| 45 | PRCRL_WEIGHT_UOM | varchar | Weight Unit of Measure |
| 46 | PRCRL_NSN_NO | varchar | National Stock Number (NSN) |
| 47 | PRCRL_USER_DEFINED_DTL1 | varchar | User-defined detail 1 |
| 48 | PRCRL_USER_DEFINED_DTL2 | varchar | User-defined detail 2 |
| 49 | PRCRL_REMARKS | varchar | Remarks |
| 50 | PRCRL_CREATED_BY | varchar | Created by user |
| 51 | PRCRL_CREATEDDATE | varchar | Creation date |
| 52 | PRCRL_MODIFIED_BY | varchar | Modified by user |
| 53 | PRCRL_MODIFIEDDATE | decimal | Modification date |
| 54 | PRCRL_TIMESTAMP | varchar | Timestamp |
| 55 | PRCRL_PART_ACC_GRP | varchar | Part accountability group |
| 56 | PRCRL_PRIMEPART_NO | varchar | Prime part number |
| 57 | PRCRL_WORK_CENTER | varchar | Work center |
| 58 | PRCRL_MODEL | varchar | Model |
| 59 | PRCRL_SHELFLIFE_EXTENDABLE | varchar | Shelf life extendable flag |
| 60 | Prcrl_Strip_Part_no | varchar | Strip part number |
| 61 | PRCRL_Non_Stockable | varchar | Non-stockable flag |
| 62 | PRCRL_RefDocumentNo | varchar | Reference document number |
| 63 | PRCRL_RefDocumentType | varchar | Reference document type |
| 64 | PRCRL_RefNotes | varchar | Reference notes |
| 65 | PRCRL_SOURCE_DOC_DATE | varchar | Source document date |
| 66 | PRCRL_PRM_PRT_GROUP | varchar | Prime part group |
| 67 | PRCRL_Spec2kPrt_NO | int | Specification 2000 part number |
| 68 | PRCRL_PartId | numeric | Part ID |
| 69 | PRCRL_PRTLENGTH | varchar | Part length |
| 70 | PRCRL_PRTLENGTH_UOM | numeric | Part length Unit of Measure |
| 71 | PRCRL_PRTWEIGHT | varchar | Part weight |
| 72 | PRCRL_PRTWEIGHT_UOM | numeric | Part weight Unit of Measure |
| 73 | PRCRL_PRTHEIGHT | varchar | Part height |
| 74 | PRCRL_PRTHEIGHT_UOM | varchar | Part height Unit of Measure |
Relationships (2)
- ShopWorkOrder (swo_swoh_shop_wo_hdr) →
FOR_PART(this table is target)- Join:
swo_swoh_shop_wo_hdr.swoh_part_desc = PRT_PRCRL_CENTRALREFLIST_INFO.PRCRL_PART_DESC - SWO is for a part
- Join:
- SWOPartDetail (swo_swoprt_part_details) →
SWO_PART_CONSUMPTION(this table is target)- Join:
swo_swoprt_part_details.swoprt_part_no = PRT_PRCRL_CENTRALREFLIST_INFO.PRCRL_PART_NO - SWO part detail for specific part
- Join:
Sample rows (from live DB)
PRCRL_CREATED_OUINSTANCE | PRCRL_PART_NO | PRCRL_PART_DESC | PRCRL_PART_DESC_UP | PRCRL_REFERENCE_STATUS | PRCRL_KEYWORD |
|---|---|---|---|---|---|
| 2.0 | :09832 | Pressure Gauge | Pressure Gauge | A | HARNESS |
| 2.0 | :101_WH1 | Trial Part 1 | Trial Part 1 | A | — |
| 2.0 | :101_WH1_TEST1 | :101_WH1_test1 | :101_WH1_test1 | A | — |
Showing 3 of 50,000 rows.