swo_Kit_DemCov_SrcBas_Info

This table records details of kitting demand coverage sources. It tracks where required parts and materials are sourced from to fulfill work order kitting requirements.

Process: COMPMAINTENANCE · Component: BasMAK · Table type: Transaction Table Category: captures detailed information about the sources used to fulfill kitting demand within a Shop Work Order (SWO)

This table is the canonical store for the KitDemCov entity.

Primary key

KDSI_dmdcovtrkid

Columns (54)

#	Column	Type	Description
1	`KDSI_actassby`	varchar	User who performed the actual assembly.
2	`KDSI_actassdt`	datetime	Date when the assembly was performed.
3	`kdsi_Assemblytsk`	varchar	Assembly task identifier.
4	`KDSI_assempcode`	varchar	Employee code performing the assembly.
5	`KDSI_assemqty`	numeric	Quantity assembled.
6	`KDSI_ass_dt`	datetime	Date of assembly activity.
7	`KDSI_ass_grp`	varchar	Group responsible for the assembly task.
8	`KDSI_ass_rem`	varchar	Remarks related to the assembly task.
9	`KDSI_billable`	varchar	Indicates if the assembly is billable.
10	`KDSI_cmpqty`	numeric	Quantity completed.
11	`KDSI_createdby`	varchar	User who created the record.
12	`KDSI_createddt`	datetime	Date when the record was created.
13	`KDSI_delvqty`	numeric	Quantity delivered.
14	`KDSI_dmdcovtrkid` 🔑	bigint	Demand coverage tracking ID.
15	`KDSI_dmddocid`	bigint	Demand document ID.
16	`KDSI_dmddocno`	varchar	Demand document number.
17	`KDSI_dmddoctyp`	varchar	Type of demand document.
18	`KDSI_dmdqty`	numeric	Quantity demanded.
19	`kdsi_dmdremarks`	Char	Remarks on the demand.
20	`kdsi_Exchg_reason`	varchar	Reason for exchange.
21	`KDSI_flwup_dt`	datetime	Date for follow-up action.
22	`KDSI_flwup_rem`	varchar	Remarks for follow-up.
23	`KDSI_kitby`	varchar	User who prepared the kit.
24	`KDSI_kitdt`	datetime	Date when the kit was prepared.
25	`KDSI_kitgroup`	varchar	Group associated with the kit.
26	`KDSI_kitqty`	numeric	Quantity in the kit.
27	`KDSI_kittrkid`	bigint	Tracking ID for the kit.
28	`KDSI_kit_sts`	varchar	Status of the kit.
29	`KDSI_modifiedby`	varchar	User who last modified the record.
30	`KDSI_modifieddt`	datetime	Date of last modification.
31	`KDSI_movqty`	numeric	Quantity moved.
32	`kdsi_needdate`	datetime	Required date for assembly or kit.
33	`KDSI_ou`	int	Organizational unit associated with the record.
34	`Kdsi_Posprt_OOS`	varchar	Flag indicating out-of-stock position part.
35	`KDSI_Posprt_QuoteReqFlg`	varchar	Flag indicating if quote is required.
36	`KDSI_raisePR`	varchar	Indicates if purchase requisition is raised.
37	`KDSI_recdby`	varchar	User who received the item.
38	`KDSI_recddt`	datetime	Date item was received.
39	`KDSI_recdqty`	numeric	Quantity received.
40	`kdsi_refid`	varchar	Reference ID for related record.
41	`KDSI_reqfor`	varchar	Purpose or request description.
42	`KDSI_source`	varchar	Source of the item or task.
43	`KDSI_src_basis`	varchar	Basis for source selection.
44	`KDSI_sys_billable`	varchar	System-calculated billable flag.
45	`KDSI_timestamp`	int	Record timestamp.
46	`KDSI_unkitby`	varchar	User who un-kitted the item.
47	`KDSI_unkitdt`	datetime	Date of un-kitting.
48	`KDSI_usrdfd_cb1`	varchar	User-defined checkbox 1.
49	`KDSI_usrdfd_cb2`	varchar	User-defined checkbox 2.
50	`KDSI_usrdfd_dt1`	datetime	User-defined date 1.
51	`KDSI_usrdfd_dt2`	datetime	User-defined date 2.
52	`KDSI_usrdfd_txt1`	varchar	User-defined text 1.
53	`KDSI_usrdfd_txt2`	varchar	User-defined text 2.
54	`KDSI_usrdfd_txt3`	varchar	User-defined text 3.

Relationships (1)

KitRefDetail (swo_Kit_Ref_Dtl) → KIT_HAS_COVERAGE (this table is target)
- Join: swo_Kit_Ref_Dtl.KRD_trackid = swo_Kit_DemCov_SrcBas_Info.kit_id
- Kit has demand coverage

Sample rows (from live DB)

`KDSI_actassby`	`KDSI_actassdt`	`kdsi_Assemblytsk`	`KDSI_assempcode`	`KDSI_ass_dt`
—	—	—	—	—
—	—	—	—	—
—	—	—	—	—

Showing 3 of 82,007 rows.

swo_Kit_DemCov_SrcBas_Info

Primary key

Columns (54)

Relationships (1)

Sample rows (from live DB)

See also