| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
CATEGORY_PREV |
Character(5) |
VARCHAR2(5) NOT NULL |
Asset Category
|
| 3 |
SELECT_CLAUSE |
Character(254) |
VARCHAR2(254) NOT NULL |
Select Clause
|
| 4 |
BEGIN_DT |
Date(10) |
DATE |
Begin Date
|
| 5 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 6 |
REQUEST_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Request ID
|
| 7 |
FISCAL_YEAR |
Number(4,0) |
SMALLINT NOT NULL |
Fiscal Year
|
| 8 |
ACCOUNTING_PERIOD |
Number(3,0) |
SMALLINT NOT NULL |
Identifies a time period to which you post transactions. Typically, an accounting period represents a month, but it can also represent a week, a day, or any user-defined interval. An accounting period has a beginning date and an ending date, and is defined in the calendar table.
|
| 9 |
CREATE_ACCOUNTING |
Character(1) |
VARCHAR2(1) NOT NULL |
Create Accounting Entries
|
| 10 |
PROCESS_FREQUENCY |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Frequency
A=Always Process
N=Don't Run
O=Process Once
|
| 11 |
ENABLED |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag indicates whether this row is enabled or not.
|
| 12 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 13 |
BUSINESS_UNIT_GL |
Character(5) |
VARCHAR2(5) NOT NULL |
GL Business Unit
|
| 14 |
LEDGER |
Character(10) |
VARCHAR2(10) NOT NULL |
Ledger
|
| 15 |
PREV_LEDGER_GROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Previous Ledger Group
|
| 16 |
LEDGER_GROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Ledger Group
|
| 17 |
ASSET_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Asset Identification
|
| 18 |
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.
|
| 19 |
ACCOUNTING_DT |
Date(10) |
DATE |
The accounting entry construction date for a given transaction (a generic field that crosses multiple
|
| 20 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 21 |
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
|
| 22 |
PREV_TRANS_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Previous BI Trans Type
|
| 23 |
TRANS_CODE |
Character(5) |
VARCHAR2(5) NOT NULL |
Transaction Code
|
| 24 |
CATEGORY |
Character(5) |
VARCHAR2(5) NOT NULL |
Asset Category
|
| 25 |
BOOK |
Character(10) |
VARCHAR2(10) NOT NULL |
Asset Book Name
|
| 26 |
JRNL_CODE |
Character(8) |
VARCHAR2(8) NOT NULL |
Journal Code
|
| 27 |
DOC_TYPE |
Character(8) |
VARCHAR2(8) NOT NULL |
Specifies the business purpose of a financial transaction in countries that require all financial transactions to be tracked as "documents". A Document Type is associated with one and only one Journal Code.
|
| 28 |
PREV_SEQ_NBR |
Character(12) |
VARCHAR2(12) NOT NULL |
Previous Doc Sequence Number
|
| 29 |
DOC_SEQ_NBR |
Character(12) |
VARCHAR2(12) NOT NULL |
Specifies the sequence number assigned to each financial transaction (a document). The sequence number may be manually entered or system-generated.
|
| 30 |
DOC_SEQ_DATE |
Date(10) |
DATE |
Specifies the date that a document sequence number is assigned to a document or the date the document was created.
|
| 31 |
DOC_SEQ_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag that indicates a document sequencing error. If there is no error the field is blank and document is considered valid for posting.
1=Document Sequencing Disabled
A=GL BU Undefined
B=GL BU Blank
C=Accounting Date blank
D=Doc Type Blank
E=Jrnl Type, Code, Doc Undefine
F=Sequence Range Undefine
G=Max. Sequence Number Reached
H=Manual Nbr for Auto Doc Type
I=No Manual Number Entered
J=Duplicate Manual Number
K=Invalid Ledger
L=Invalid Ledger Group
N=No Status
|
| 32 |
WORK_FIELD |
Character(37) |
VARCHAR2(37) NOT NULL |
Work_field
|
| 33 |
PREV_MAN_SEQ |
Character(12) |
VARCHAR2(12) NOT NULL |
Previous Manual Seq Nbr
|
| 34 |
KLS |
Character(1) |
VARCHAR2(1) NOT NULL |
Keep Ledgers In Sync
|
| 35 |
ASSET_ID_PREV |
Character(12) |
VARCHAR2(12) NOT NULL |
Previous Asset ID
|
| 36 |
SEQ_NBR_PREFIX |
Character(4) |
VARCHAR2(4) NOT NULL |
Sequence Number Prefix
|
| 37 |
RECNAME |
Character(15) |
VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
|
| 38 |
PRCSNAME |
Character(12) |
VARCHAR2(12) NOT NULL |
Process Name
|
| 39 |
CALENDAR_ID |
Character(2) |
VARCHAR2(2) NOT NULL |
Calendar ID
|
| 40 |
END_DT |
Date(10) |
DATE |
End Date
|
| 41 |
SEQ_BY |
Character(1) |
VARCHAR2(1) NOT NULL |
Sequence By
C=Journal Code
D=Document Type
|
| 42 |
SEQ_RANGE_ID |
Character(2) |
VARCHAR2(2) NOT NULL |
Sequence Range
|
| 43 |
SEQ_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Document Sequencing Type
A=Automatic Numbering
M=Manually Entered
|
| 44 |
PREV_DOC_TYPE |
Character(8) |
VARCHAR2(8) NOT NULL |
Previous Document Type
|
| 45 |
RECNAME_2 |
Character(15) |
VARCHAR2(15) NOT NULL |
Record 2 Name
|
| 46 |
SEQ_NBR_START |
Number(12,0) |
DECIMAL(12) NOT NULL |
Start Sequence Number
|
| 47 |
SEQ_NBR_END |
Number(12,0) |
DECIMAL(12) NOT NULL |
End Sequence Number
|
| 48 |
MAN_SEQ_NBR |
Number(12,0) |
DECIMAL(12) NOT NULL |
|
| 49 |
SYSTEM_SOURCE |
Character(3) |
VARCHAR2(3) NOT NULL |
Identifies the application or source system that generated a journal entry.
Release 8.80 - 11/14/2002 - RVlasic - Removed GDM (JrnlGen - Deduction Management) from Translate Values.
SUJ---Included a label as Product.
Release 8.9 - 05/11/2005 - RVlasic - Added PRV (Variance Pricing) and PKK (KK Budget Journal) and deleted GLK for Project Costing per Brian Cohen.
|
| 50 |
DATA_FOUND |
Character(1) |
VARCHAR2(1) NOT NULL |
Data Found
Default Value: N
|
| 51 |
PREV_ACCOUNTING_DT |
Date(10) |
DATE |
The accounting entry construction date for a given transaction (a generic field that crosses multiple
|