swo_Kit_Ref_Dtl
This table stores primary data sources for kitting activities. It consolidates essential part, material, and demand details that support kit creation and management.
Process: COMPMAINTENANCE · Component: BasMAK · Table type: Transaction Table Category: stores the primary reference data used in SWO kitting operations. It consolidates key details about parts, materials, and demand requirements, providing a comprehensive source for kit creation and management
This table is the canonical store for the KitRefDetail entity.
Primary key
KRD_trackid
Columns (52)
| # | Column | Type | Description |
|---|---|---|---|
| 1 | KRD_Assemblytsk | varchar | Assembly task identifier. |
| 2 | KRD_Assemblytskrackid | bigint | Assembly task tracking ID. |
| 3 | KRD_AssemblyWC | varchar | Work center for the assembly task. |
| 4 | KRD_assemqty | numeric | Quantity assembled. |
| 5 | KRD_cfglevel | int | Configuration level. |
| 6 | KRD_cfglevelcode | varchar | Configuration level code. |
| 7 | KRD_cfgrevno | varchar | Configuration revision number. |
| 8 | KRD_configtype | varchar | Type of configuration. |
| 9 | KRD_createdby | varchar | User who created the record. |
| 10 | KRD_createddt | datetime | Date the record was created. |
| 11 | KRD_crno | varchar | Change request number. |
| 12 | KRD_crtrkid | bigint | Change request tracking ID. |
| 13 | KRD_dassemblytsk | varchar | Dependent assembly task. |
| 14 | KRD_dassemtsktrackid | bigint | Dependent assembly task tracking ID. |
| 15 | KRD_dem_covqty | numeric | Demand coverage quantity. |
| 16 | KRD_hierarchy | varchar | Hierarchy level. |
| 17 | KRD_hierarchy_str | varchar | Hierarchy structure string. |
| 18 | KRD_historyFlg | varchar | History flag for the record. |
| 19 | KRD_IntgFlag | varchar | Integration flag. |
| 20 | KRD_kitqty | numeric | Quantity in the kit. |
| 21 | KRD_kittingWArea | varchar | Kitting work area. |
| 22 | krd_kittingWC | varchar | Kitting work center. |
| 23 | KRD_Levelno | int | Level number in hierarchy. |
| 24 | KRD_modifiedby | varchar | User who modified the record. |
| 25 | KRD_modifieddt | datetime | Date of modification. |
| 26 | KRD_nhacomp | varchar | NHA component flag. |
| 27 | KRD_ou | int | Organizational unit. |
| 28 | KRD_parentdocid | bigint | Parent document ID. |
| 29 | KRD_parentdocno | varchar | Parent document number. |
| 30 | KRD_parentdoctyp | varchar | Parent document type. |
| 31 | KRD_poscode | varchar | Position code. |
| 32 | KRD_pospart | varchar | Position part. |
| 33 | KRD_postype | varchar | Position type. |
| 34 | KRD_qty | numeric | Quantity. |
| 35 | KRD_refdocid | bigint | Reference document ID. |
| 36 | KRD_refdocno | varchar | Reference document number. |
| 37 | KRD_refdoctyp | varchar | Reference document type. |
| 38 | KRD_remcompno | varchar | Removed component number. |
| 39 | KRD_rmllotno | varchar | Removed lot number. |
| 40 | KRD_rmlprtno | varchar | Removed part number. |
| 41 | KRD_rmlsrlno | varchar | Removed serial number. |
| 42 | KRD_rootdocid | bigint | Root document ID. |
| 43 | KRD_rootdocno | varchar | Root document number. |
| 44 | KRD_rootdoctyp | varchar | Type of the root document used in kitting |
| 45 | KRD_stkallocruleid | varchar | Tracking number for stock allocation rules |
| 46 | KRD_timestamp | int | Timestamp of the record creation or update |
| 47 | KRD_trackid 🔑 | bigint | Reference tracking number for kitting operations |
| 48 | KRD_TrgtCfgLmt | int | Limit number for target configuration |
| 49 | KRD_trgtrkid | bigint | Tracking number for the target configuration |
| 50 | KRD_TrgtThrstRtng | varchar | Target thrust rating for the kitted item |
| 51 | KRD_visitdoc_no | varchar | Document number for kitting visit |
| 52 | KRD_VisitRule | varchar | Configuration rule associated with visit |
Relationships (3)
- ShopWorkOrder (swo_swoh_shop_wo_hdr) →
SWO_HAS_KIT(this table is target)- Join:
swo_swoh_shop_wo_hdr.swoh_poscode = swo_Kit_Ref_Dtl.KRD_poscode - SWO has kit reference
- Join:
KIT_HAS_COVERAGE→ KitDemandCoverage (swo_Kit_DemCov_SrcBas_Info)- Join:
swo_Kit_Ref_Dtl.KRD_trackid = swo_Kit_DemCov_SrcBas_Info.kit_id - Kit has demand coverage
- Join:
KIT_HAS_PRICE→ KitSpecSrcPrice (swo_Kit_Spec_Src_Price_Info)- Join:
swo_Kit_Ref_Dtl.KRD_trackid = swo_Kit_Spec_Src_Price_Info.kitspec_id - Kit has source pricing
- Join:
Sample rows (from live DB)
KRD_Assemblytsk | KRD_Assemblytskrackid | KRD_AssemblyWC | KRD_assemqty | KRD_cfglevel | KRD_cfglevelcode |
|---|---|---|---|---|---|
| NULL | NULL | YUL-100-00 | 0.00000000 | 1 | NULL |
| NULL | NULL | YUL-100-00 | 0.00000000 | 1 | NULL |
| NULL | NULL | YUL-100-00 | 0.00000000 | 1 | NULL |
Showing 3 of 82,253 rows.