pears.SelfBillCustomColumn

Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.

COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."SelfBillCustomColumn" IS 
{CREATE FUNCTION SelfBillCustomColumn 
(IN SupplierCode CHAR(20),IN RecordType CHAR(2))
RETURNS CHAR(100)
BEGIN
  -- RecordType M= Supplier Code Maint (this is for potential future expansion)
  -- SupplierCode=null means return column heading for RecordType 
  -- usual use is to show Self Bill Agreement expiry date
  RETURN NULL
END
}
  • database/procedures/pears_selfbillcustomcolumn.txt
  • Last modified: 2026/08/07 19:24
  • by 127.0.0.1