| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
BUSINESS_UNIT_GL |
Character(5) |
VARCHAR2(5) NOT NULL |
GL Business Unit
|
| 3 |
VAT_ENTITY |
Character(20) |
VARCHAR2(20) NOT NULL |
Specifies an organizational entity that is responsible for VAT reporting and that is registered in one or more countries that require VAT reporting. A single VAT entity is linked to one or more General Ledger Business Units depending on the reporting requirements.
|
| 4 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 5 |
VAT_BOOK |
Character(10) |
VARCHAR2(10) NOT NULL |
Value Added Tax Book
|
| 6 |
INSERT_VAT_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Insert Vat?
|
| 7 |
UPDATE_VAT_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Update Vat?
|
| 8 |
VAT_DISTRIB_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
Distribution Type
|
| 9 |
DIST_TYPE_INSERT |
Character(2) |
VARCHAR2(2) NOT NULL |
Distribution Type
|
| 10 |
VAT_STRING_1 |
Character(30) |
VARCHAR2(30) NOT NULL |
SQL Object Identifier
|
| 11 |
TXN_VAT_STRING_1 |
Character(30) |
VARCHAR2(30) NOT NULL |
SQL Object Identifier
|
| 12 |
RET_COST_WHERE |
Character(30) |
VARCHAR2(30) NOT NULL |
SQL Object Identifier
|
| 13 |
RET_COST_WHERE_1 |
Character(30) |
VARCHAR2(30) NOT NULL |
SQL Object Identifier
|
| 14 |
RET_COST_WHERE_2 |
Character(30) |
VARCHAR2(30) NOT NULL |
SQL Object Identifier
|
| 15 |
RET_COST_SELECT |
Character(30) |
VARCHAR2(30) NOT NULL |
SQL Object Identifier
|
| 16 |
RET_COST_FROM |
Character(30) |
VARCHAR2(30) NOT NULL |
SQL Object Identifier
|
| 17 |
VAT_CALC_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
"A flag that indicates how VAT is stated and determines how the system performs the relevant VAT calculations. If ""Exclusive"", the VAT amount is stated separately from the merchandise amount. If ""Inclusive"", the VAT is not stated separately but is included with the merchandise amount."
E=Exclusive
I=Inclusive
|
| 18 |
VAT_LEDGER |
Character(1) |
VARCHAR2(1) NOT NULL |
Maintain VAT Balances
|
| 19 |
VAT_ASSET_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Asset Identification
|
| 20 |
VAT_DTTM_STAMP |
DateTime(26) |
TIMESTAMP |
Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
|
| 21 |
FROM_CUR |
Character(3) |
VARCHAR2(3) NOT NULL |
From Currency Code
|
| 22 |
DISTRIB_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
GL Distribution
|
| 23 |
RET_ASSET_ID_TMP |
Character(30) |
VARCHAR2(30) NOT NULL |
SQL Object Identifier
|
| 24 |
VAT_AMT_SELECT |
Character(30) |
VARCHAR2(30) NOT NULL |
SQL Object Identifier
|
| 25 |
RET_AMT_SELECT |
Character(30) |
VARCHAR2(30) NOT NULL |
SQL Object Identifier
|
| 26 |
RET_TXN_AMT_SELECT |
Character(30) |
VARCHAR2(30) NOT NULL |
SQL Object Identifier
|
| 27 |
VAT_TXN_AMT_SELECT |
Character(30) |
VARCHAR2(30) NOT NULL |
SQL Object Identifier
|
| 28 |
RET_COST_SELECT_RN |
Character(30) |
VARCHAR2(30) NOT NULL |
SQL Object Identifier
|
| 29 |
RET_DIST_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
Distribution Type
|
| 30 |
RET_AMT_WHERE |
Character(30) |
VARCHAR2(30) NOT NULL |
SQL Object Identifier
|
| 31 |
VAT_SIGN |
Signed Number(2,0) |
DECIMAL(1) NOT NULL |
Used to adjust sign for AM trn
|
| 32 |
RET_AMT_SEL1 |
Character(30) |
VARCHAR2(30) NOT NULL |
SQL Object Identifier
|
| 33 |
RET_TXN_AMT_SEL1 |
Character(30) |
VARCHAR2(30) NOT NULL |
SQL Object Identifier
|
| 34 |
RET_AMT_WHERE1 |
Character(30) |
VARCHAR2(30) NOT NULL |
SQL Object Identifier
|
| 35 |
IU_TRANSFER_WHERE |
Character(30) |
VARCHAR2(30) NOT NULL |
SQL Object Identifier
|
| 36 |
RET_TXN_CURRENCY |
Character(30) |
VARCHAR2(30) NOT NULL |
SQL Object Identifier
|
| 37 |
RET_RATE_MULT |
Character(30) |
VARCHAR2(30) NOT NULL |
SQL Object Identifier
|
| 38 |
RET_RATE_DIV |
Character(30) |
VARCHAR2(30) NOT NULL |
SQL Object Identifier
|
| 39 |
RET_BILL_WHERE |
Character(30) |
VARCHAR2(30) NOT NULL |
SQL Object Identifier
|
| 40 |
TRANS_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Types of Asset Management Transactions
ACR=Accretion Expense
ADD=Asset Addition
ADJ=Asset Cost Adjustment
BKS=Book Adjustment
BUD=Budgeted Depreciation
DPR=Depreciation
INF=Inflation Adjustment
LEX=Lease Expense
LPB=Budgeted Lease Payments
LPY=Lease Payment
PDP=Prior Period Depreciation
PLP=Prior Lease Payment
RAD=Manual Reserve Adjustment
RCT=Asset Recategorization
REI=Asset Reinstatement
RES=Resume Depreciation
RET=Asset Retirement
RRC=Retro rate change for grp ast
SUS=Suspend Depreciation
TRF=Asset Transfer
|