| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 SHEET_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Report ID
Default Value: NEXT
|
| 2 |
PERSON_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Person ID
|
| 3 |
EXP_HDR_STATUS |
Character(3) |
VARCHAR2(3) NOT NULL |
Expense Header Status
ADJ=Adjusted
APY=Approved for Payment
APZ=Approved for zero Payment
DEN=Denied
DNA=Denied by Approver
DNU=Denied by Auditor
OPN=Open
PD=Paid
PND=Pending
RAP=Approved
SUB=Submitted
|
| 4 |
EX_ORIGIN |
Character(1) |
VARCHAR2(1) NOT NULL |
Origin of Entry (Expenses)
A=Asset Lifecycle Management
H=Mobile Hand Held Device
M=Mobile Time and Expense
N=NUI
P=Primavera P6
W=Web
Default Value: W
|
| 5 |
APPROVAL_LEVEL |
Character(1) |
VARCHAR2(1) NOT NULL |
Approval Level
A=Approver Only
B=Pre- and Post-Pay Audit
E=Approver & Pre-Pay Auditor
I=Approve, Pre- & Post-Pay Audit
N=None
S=Approver & Post-Pay Auditor
T=Auditor Only - Post-Payment
U=Auditor Only - Pre-Payment
|
| 6 |
CREATION_DT |
Date(10) |
DATE |
Creation Date
Default Value: %date
|
| 7 |
APPROVAL_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A system generated value that reflects the operator that approved a given transaction.
|
| 8 |
APPROVAL_DT |
Date(10) |
DATE |
Date of Approval
|
| 9 |
AUDIT_DT |
Date(10) |
DATE |
Date of Audit
|
| 10 |
AUDIT_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
The OPRID of the user who made the changes audited on an audit record.
|
| 11 |
ADVANCE_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Advance Amount
|
| 12 |
ADVANCE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Advance ID
|
| 13 |
SHEET_ID_RELATED |
Character(10) |
VARCHAR2(10) NOT NULL |
Journal Report ID
|
| 14 |
SHEET_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Expense Sheet Type
J=Journal Sheet
R=Regular Sheet
Default Value: R
|
| 15 |
PP_DENIAL_ADV |
Character(10) |
VARCHAR2(10) NOT NULL |
Cash advance created from expense items denied on an expense sheet that has already been paid.
|
| 16 |
CREDIT_ADV |
Character(10) |
VARCHAR2(10) NOT NULL |
Credit Advance
|
| 17 |
SUBMISSION_DATE |
Date(10) |
DATE |
Submission Date
|
| 18 |
RESUBMISSION_DT |
Date(10) |
DATE |
Resubmission Date
|
| 19 |
LAST_UPDATE_DT |
Date(10) |
DATE |
Last Updated
|
| 20 |
OPRID_LAST_UPDT |
Character(30) |
VARCHAR2(30) NOT NULL |
Last User to Update
|
| 21 |
RCPT_VERIFY_DT |
Date(10) |
DATE |
Date of Verification
|
| 22 |
RCPT_VERIFY_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Verification UserID
|
| 23 |
RCPT_VERIF_LEVEL |
Character(1) |
VARCHAR2(1) NOT NULL |
Receipt Verification Level - Determines to what level the receipts on expense sheets need to be verified.
B=Both Received & Verified
N=Neither need Receive or Verfy
R=Receipts Received
V=Receipts Verified
|
| 24 |
RECEIPTS_RECEIVED |
Character(1) |
VARCHAR2(1) NOT NULL |
Receipts Received
Y/N Table Edit
Default Value: N
|
| 25 |
RECEIPT_VERIFIED |
Character(1) |
VARCHAR2(1) NOT NULL |
Receipt Verified
Y/N Table Edit
Default Value: N
|
| 26 |
DST_CNTRL_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Accounting Template
|
| 27 |
REFERENCE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Reference ID
|
| 28 |
TEMPLATE |
Character(8) |
VARCHAR2(8) NOT NULL |
Used to define a particular type of travel, i.e. company relocation, internal travel, etc. Determines what type of expenses and expenditure limits are associated with that particular type of travel. Established in the Structure Expenses system and chosen on the header panel of cash advances, expense sheets and travel authorizations.
|
| 29 |
SHEET_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Report Description
|
| 30 |
TXN_LOCATION |
Character(5) |
VARCHAR2(5) NOT NULL |
Expense Location
Prompt Table:
EX_LOCATION_VW2
|
| 31 |
COPY_EXPENSE_SHEET |
Character(1) |
VARCHAR2(1) NOT NULL |
Copy From Existing Report
Y/N Table Edit
Default Value: N
|
| 32 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 33 |
BUSINESS_UNIT_GL |
Character(5) |
VARCHAR2(5) NOT NULL |
GL Business Unit
|
| 34 |
EMPL_RCD |
Number(3,0) |
SMALLINT NOT NULL |
Empl Rcd Nbr
|
| 35 |
RECEIPT_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Receipt ID
|
| 36 |
POST_STATUS_EX |
Character(1) |
VARCHAR2(1) NOT NULL |
Expenses Post Status
C=Closed
M=Marked for Unpost
N=Not Applied
O=Unpost In Process
P=Posted
S=Close In Process
U=Unposted
Default Value: N
|
| 37 |
ACCOUNTING_DT |
Date(10) |
DATE |
The accounting entry construction date for a given transaction (a generic field that crosses multiple
|
| 38 |
PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 39 |
PROCESS_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Flag
A=Purge All
S=Only purge items with at least
Default Value: N
|
| 40 |
UNPOST_SEQ |
Number(2,0) |
SMALLINT NOT NULL |
Identifies the sequence of journal entries when a journal is "unposted". When a journal is posted the UnPost Sequence is automatically set to "0". When a journal is unposted, a new reversing entry is automatically created with an UnPost Sequence of "1".
|
| 41 |
REVERSAL_DATE |
Date(10) |
DATE |
Specifies the date for an automatic reversal journal entry. The date must be within the calendar of the target (posting) ledger. PeopleSoft General Ledger automatically creates and populates a journal entry with this date.
|
| 42 |
BUSINESS_PURPOSE |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Purpose
Prompt Table:
EX_PURPOSE_TBL
|
| 43 |
APPL_JRNL_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Journal Template
|
| 44 |
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.
|
| 45 |
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.
|
| 46 |
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.
|
| 47 |
OPRID_ENTERED_BY |
Character(30) |
VARCHAR2(30) NOT NULL |
Entered By
07/25/2011 MRAD 12383033 :Ensured that OPRID_ENTERED_BY is set with format type of MixedCase.
03/22/2013 GL 16482301: Switched OPRID_ENTERED_BY back to MixedCase again. Please don't change it to UpperCase!!!
FYI - The alternatives to use a User ID as uppercase:
1) Create your own User ID, add comments in the Field Properties, and fill out the Owner ID
2) Use %Upper meta-SQL in SQL statements
3) Use Upper function in peoplecodes
|
| 48 |
TRAVEL_AUTH_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Travel Authorization Identification. Number used to define travel authorizations. Key field on most travel authorization records and exists at level 0 for travel authorization panels.
|
| 49 |
PROJ_MGR_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Project Manager Review
Default Value: N
|
| 50 |
OUT_OF_POLICY |
Character(1) |
VARCHAR2(1) NOT NULL |
Authorized Amount Exceeded
Y/N Table Edit
Default Value: N
|
| 51 |
VAT_ENTRIES |
Character(1) |
VARCHAR2(1) NOT NULL |
VAT Items
Y/N Table Edit
Default Value: N
|
| 52 |
NO_RECEIPT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
No Receipt
Y/N Table Edit
Default Value: N
|
| 53 |
VAT_RECEIPT |
Character(1) |
VARCHAR2(1) NOT NULL |
No VAT Receipt
Y/N Table Edit
Default Value: N
|
| 54 |
TAX_IMPLICATIONS |
Character(1) |
VARCHAR2(1) NOT NULL |
Items with Tax Implications
Y/N Table Edit
Default Value: N
|
| 55 |
DUPLICATES_EXIST |
Character(1) |
VARCHAR2(1) NOT NULL |
Duplicates Exist
Y/N Table Edit
Default Value: N
|
| 56 |
PREF_MRCH_NOT_USED |
Character(1) |
VARCHAR2(1) NOT NULL |
Non-Preferred Merchant
Y/N Table Edit
Default Value: N
|
| 57 |
CC_FEED_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Field used to indicate whether a credit card feed was used to populate an expense sheet or not.
Y/N Table Edit
Default Value: N
|
| 58 |
BUDGET_HDR_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Budget Checking Header Status
E=Error in Budget Check
I=Document In Processing
N=Not Budget Checked
P=Provisionally Valid
V=Valid
Default Value: N
|
| 59 |
KK_TRAN_OVER_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Commitment Control source transaction override flag
N=No
Y=Yes
Y/N Table Edit
|
| 60 |
KK_TRAN_OVER_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Commitment Control source transaction override operator
|
| 61 |
KK_TRAN_OVER_DTTM |
DateTime(26) |
TIMESTAMP |
Commitment Control source transaction override datetime
|
| 62 |
KK_AMOUNT_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Commitment Control Amount Type
0=Budget
1=Actuals and Recognized
2=Encumbrance
3=Pre-Encumbrance
4=Collected Revenue
5=Planned
7=Actuals, Recognize and Collect
9=Dynamic
|
| 63 |
COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
|
| 64 |
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.
|
| 65 |
RCPT_RECEIVED_DT |
DateTime(26) |
TIMESTAMP |
Receipts Received Date
|
| 66 |
COMMENTS |
Long Character |
CLOB |
Comment
|
| 67 |
SPA_ADJUSTED_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag to indicate Progress Log/Expenses has been adjusted
A=Adjusted
N=Not Adjusted
Default Value: N
|