EX_PD_CALC_DTL(SQL Table) |
Index Back |
---|---|
Expenses Calculations |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | SETID | Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table:
SP_SETID_NONVW
|
2 | EX_CALC_CODE | Character(5) | VARCHAR2(5) NOT NULL | Calculation Code |
3 | SEQNUM | Number(3,0) | SMALLINT NOT NULL |
Sequence Number
Default Value: 1 |
4 | PARENTHESIS_1 | Character(1) | VARCHAR2(1) NOT NULL |
Paranthesis
(=Open Parenthesis )=Close Parenthesis |
5 | PERDIEM_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Per Diem Value
A=Active Amount G=Government Amount H=Hours Worked |
6 | FIELD_VALUE_NBR | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | An accounting template field designated to support the substitution of desired monetary amounts during a |
7 | PARENTHESIS_2 | Character(1) | VARCHAR2(1) NOT NULL |
Paranthesis
(=Open Parenthesis )=Close Parenthesis |
8 | OPERATOR_1 | Character(1) | VARCHAR2(1) NOT NULL |
Operator
*=Multiply +=Add -=Subtract /=Divide |