| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 VAT_RPT_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Report ID
|
| 2 |
VAT_RPT_LINE_NBR |
Number(5,0) |
INTEGER NOT NULL |
Line Number
|
| 3 |
LC_RPT_AMT_LN_NBR |
Number(3,0) |
SMALLINT NOT NULL |
VAT Transaction Report Amount Identifier
Default Value: 1
|
| 4 |
COLUMNNUM |
Number(3,0) |
SMALLINT NOT NULL |
Column Number
Default Value: 1
|
| 5 |
LC_RPT_OPERATOR |
Character(4) |
VARCHAR2(4) NOT NULL |
VAT Transaction Report Operator
ADD=Addition
DIV=Division
MULT=Multiplication
SUB=Subtraction
|
| 6 |
AMOUNT_FIELDNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
An internal work field utilized for calculating forecast amounts for a given category in cash wor
|
| 7 |
ABS_VALUE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Absolute Value
Y/N Table Edit
Default Value: N
|
| 8 |
LC_RPT_SECNAME |
Character(4) |
VARCHAR2(4) NOT NULL |
Amount Type
FUBA=Basis Amount
FUE2=Expense(VI)/Transaction(VO)
FUEB=Expense(VI)/Basis(VO)
FUET=Expense - Transaction
FUEX=Expense - Basis
FUGR=Gross Amount - Basis
FUGT=Gross Amount - Transaction
FUNB=Non Recoverable Basis
FUNR=Non Recoverable Tax
FUNT=Non Recoverable Transaction
FURB=Rebate Amount
FURC=Recoverable Amount
FUTN=Transaction Amount
FUTR=Tax(VO)/Recoverable Amount(VI)
FUTX=Gross Tax
|
| 9 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 10 |
LC_RPT_COL1_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Modifier
|