Used Parts Return
Tables (3)
Return Parts Master (u_base_fsm_pcp_Return_Parts_Master)
- Subsidiary Code (subsidiary_code) — String — Primary key — NOT NULL
- Parts Code (parts_code) — String — Primary key — NOT NULL
- Vaild From Date (valid_from_date) — date — Primary key — NOT NULL
- Subsidiary Code (subsidiary_code2) — String — Foreign key → Return Parts Master_history.Subsidiary Code — NOT NULL
- Parts Code (parts_code2) — String — Foreign key → Return Parts Master_history.Parts Code — NOT NULL
- Vaild From Date (valid_from_date2) — date — Foreign key → Return Parts Master_history.Vaild From Date — NOT NULL
- Valid to Date (valid_to_date) — date
- Return Code (return_code) — string
- Deletion Flag (deletion_flag) — boolean
- Business unit (business_unit) — string
- Family Group (family_group) — string
- OCTA Allowance Rate (OCTA_Allowance_Rate) — Decimal
- Field
Return Parts Master_history (u_base_fsm_pcp_Return_Parts_Master_History)
- Subsidiary Code (subsidiary_code) — String — Primary key — NOT NULL
- Parts Code (parts_code) — String — Primary key — NOT NULL
- Vaild From Date (valid_from_date) — date — Primary key — NOT NULL
- Valid to Date (valid_to_date) — date
- Return Code (return_code) — string
- Deletion Flag (deletion_flag) — boolean
- Business unit (business_unit) — string
- Family Group (family_group) — string
- OCTA Allowance Rate (OCTA_Allowance_Rate) — Decimal
- Field