BUSINESS_UNITFO_BATCH_IDFO_TIME_CARDDATE_WRKTIME_RPTG_CDPrompt Table: FO_TRC_VW
FO_TIME_RPTG_CDBPrompt Table: FO_TRC_VW
B=Billable
I=Internal
P=Personal
U=Nonbillable
FO_EXPN_LINES(SQL Table) |
Index Back |
|---|---|
Pay/Bill Time Entry Expn Lines |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | FO_BATCH_ID |
Character(11) | VARCHAR2(11) NOT NULL | Batch ID |
| 3 | FO_TIME_CARD |
Character(14) | VARCHAR2(14) NOT NULL | Time Card ID |
| 4 | DATE_WRK |
Date(10) | DATE | Date Work Field |
| 5 | TIME_RPTG_CD |
Character(5) | VARCHAR2(5) NOT NULL |
Time Reporting Code
Prompt Table: FO_TRC_VW |
| 6 | FO_TIME_RPTG_CDB |
Character(5) | VARCHAR2(5) NOT NULL |
Time Reporting Code Billing
Prompt Table: FO_TRC_VW |
| 7 | FO_TOTAL_UNITS | Signed Number(8,2) | DECIMAL(6,2) NOT NULL | Time Card Total Units |
| 8 | FO_PAY_RATE | Number(19,6) | DECIMAL(18,6) NOT NULL | Pay Rate |
| 9 | RATE_AMOUNT | Number(11,4) | DECIMAL(10,4) NOT NULL | Rate Amount |
| 10 | FO_TOTAL_AMOUNT | Signed Number(10,2) | DECIMAL(8,2) NOT NULL | Time Card Total Amount |
| 11 | BILLING_ACTION | Character(1) | VARCHAR2(1) NOT NULL |
Billing Action
B=Billable I=Internal P=Personal U=Nonbillable |
| 12 | MARKUP_MULTIPLIER | Signed Number(11,6) | DECIMAL(9,6) NOT NULL | Markup Multiplier |
| 13 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |