pears.AccordExpenseBenefitExport [iqx]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
====== pears.AccordExpenseBenefitExport ======
<WRAP center round info>
Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.
</WRAP>

===== Description =====
Expense benefit timesheets for Accord.

===== Columns =====
^ Column ^ Type ^ Null ^ Default ^ Comment ^
| **TempTimeSheetID** | char(20) | NOT NULL |  |  |
| PersonID | char(20) | NULL |  |  |
| Admin_Value | numeric(9,2) | NULL |  |  |
| Travel_Value | numeric(9,2) | NULL |  |  |
| Expense_4_Value | numeric(9,2) | NULL |  |  |
| Period | integer | NULL |  |  |
| Original_TimeSheet_Number | char(13) | NULL |  |  |
| Subsistence_Value | numeric(9,2) | NULL |  |  |
| Expense_3_Value | numeric(9,2) | NULL |  |  |

===== Primary Key =====
  * TempTimeSheetID

===== Foreign Keys =====
  * No outgoing foreign keys found.

===== Referenced By =====
  * No incoming foreign keys found.

===== Indexes =====
  * No indexes found.

===== Triggers =====
  * No triggers found.

===== Original SQL =====
<code sql>
-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."AccordExpenseBenefitExport"
-- Table comment: Expense benefit timesheets for Accord.
-- Statement count: 2

CREATE TABLE "pears"."AccordExpenseBenefitExport" (
    "TempTimeSheetID"                char(20) NOT NULL
   ,"PersonID"                       char(20) NULL
   ,"Admin_Value"                    numeric(9,2) NULL
   ,"Travel_Value"                   numeric(9,2) NULL
   ,"Expense_4_Value"                numeric(9,2) NULL
   ,"Period"                         integer NULL
   ,"Original_TimeSheet_Number"      char(13) NULL
   ,"Subsistence_Value"              numeric(9,2) NULL
   ,"Expense_3_Value"                numeric(9,2) NULL
   ,PRIMARY KEY ("TempTimeSheetID" ASC) 
)
go


COMMENT ON TABLE "pears"."AccordExpenseBenefitExport" IS 
	'Expense benefit timesheets for Accord.'
go
</code>