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

Untitled