pears.ExpenseBenefitType

Definitions of types of Expense Benefit available with behaviour settings

• ExpenseBenefitTypeID

• No outgoing foreign keys found.

• No indexes found.

• No triggers found.

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."ExpenseBenefitType"
-- Table comment: Definitions of types of Expense Benefit available with behaviour settings
-- Statement count: 4
 
CREATE TABLE "pears"."ExpenseBenefitType" (
    "ExpenseBenefitTypeID"           CHAR(20) NOT NULL
   ,"Description"                    CHAR(50) NULL
   ,"Class"                          CHAR(10) NULL
   ,"Period"                         CHAR(10) NULL
   ,"PayrollFlag"                    CHAR(10) NULL
   ,"ExpenseCode"                    CHAR(10) NULL
   ,"SortOrder"                      INTEGER NULL
   ,PRIMARY KEY ("ExpenseBenefitTypeID" ASC) 
)
GO
 
 
COMMENT ON COLUMN "pears"."ExpenseBenefitType"."PayrollFlag" IS 
	'Passed to payroll system'
GO
 
 
COMMENT ON COLUMN "pears"."ExpenseBenefitType"."ExpenseCode" IS 
	'Used by payroll transfer to apply rules'
GO
 
 
COMMENT ON TABLE "pears"."ExpenseBenefitType" IS 
	'Definitions of types of Expense Benefit available with behaviour settings'
GO