| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 SHEET_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Report ID
|
| 2 |
LINE_NBR |
Number(5,0) |
INTEGER NOT NULL |
Line Number:
11/24/08 - Added TARGET label [PC product]
Default Value: 1
|
| 3 |
EX_LINE_STATUS |
Character(3) |
VARCHAR2(3) NOT NULL |
The Line Status of an Expenses transaction (i.e. Expense Report, Cash Advance, Travel Authorization, Time Report)
ADJ=Adjusted
APR=Approved
APY=Approved for Payment
CLS=Closed
DEN=Denied
DNA=Denied by Approver
DNC=Denied
DNU=Denied by Auditor
ESC=Escheated Payment
HDA=Hold by Approver
HDU=Hold by Auditor
HLD=Hold
MFS=Marked For Submit
OPN=Open
PAR=Approvals in Process
PD=Paid
PND=Pending
PRO=In Process
RAP=Approved
STG=Staged
SUB=Submitted
XML=Submitted, Pending Validation
Default Value: OPN
|
| 4 |
DISTRIB_LINE_NUM |
Number(5,0) |
INTEGER NOT NULL |
Distribution Line
Prompt Table:
SPA_EXPWODST_VW
|
| 5 |
SHEET_RCPT_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Receipt Number
|
| 6 |
SHEET_RCPT_TOTAL |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total Local Amount
|
| 7 |
ARRIVAL_DATE |
Date(10) |
DATE |
Arrival Date
|
| 8 |
DEPARTURE_DATE |
Date(10) |
DATE |
Departure Date
|
| 9 |
EXPENSE_TYPE |
Character(7) |
VARCHAR2(7) NOT NULL |
Expense Type
Prompt Table:
EX_TYPES_TBL
|
| 10 |
TRANS_DT |
Date(10) |
DATE |
Transaction Date
|
| 11 |
REIMBURSEMENT_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Deny
N=Nonreimburseable
P=Prepaid
R=Reimburseable
Default Value: R
|
| 12 |
PERSONAL_EXPENSE |
Character(1) |
VARCHAR2(1) NOT NULL |
Personal Expense
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 13 |
REIMB_ACTION |
Character(5) |
VARCHAR2(5) NOT NULL |
Reason
Prompt Table:
EX_ACTION_TBL
|
| 14 |
MONETARY_AMOUNT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Specifies the monetary amount of a debit or credit in the business unit base currency. Debit entries are positive and credit entries are negative. This amount is only zero if associated with a statistical account.
|
| 15 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table:
CURRENCY_CD_TBL
|
| 16 |
TXN_AMOUNT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Transaction Amount
|
| 17 |
TXN_CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Transaction Currency
Prompt Table:
CURRENCY_CD_TBL
|
| 18 |
RATE_MULT |
Signed Number(17,8) |
DECIMAL(15,8) NOT NULL |
Rate Multiplier
|
| 19 |
RATE_DIV |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
Rate Divisor
Default Value: 1
|
| 20 |
RT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
Prompt Table:
RT_TYPE_TBL
|
| 21 |
GROSS_UP_EST_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Gross Up Estimated Amount
|
| 22 |
TXN_LOCATION |
Character(5) |
VARCHAR2(5) NOT NULL |
Expense Location
Prompt Table:
EX_LOCATION_VW
|
| 23 |
EXPEND_MTHD |
Character(3) |
VARCHAR2(3) NOT NULL |
Payment Type
Prompt Table:
EX_EXP_MTHD_TBL
Set Control Field: BUSINESS_UNIT_GL
|
| 24 |
PREF_MRCHNT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Preferred Merchant
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 25 |
MERCHANT_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Preferred Merchant
Prompt Table:
EX_MERCHANT_VW
|
| 26 |
MERCHANT |
Character(40) |
VARCHAR2(40) NOT NULL |
Merchant
|
| 27 |
DESCR60 |
Character(60) |
VARCHAR2(60) NOT NULL |
Description
|
| 28 |
DESCR254 |
Character(254) |
VARCHAR2(254) NOT NULL |
Description of length 254
|
| 29 |
AIRFARE_RCPT_NBR |
Character(16) |
VARCHAR2(16) NOT NULL |
Airfare Receipt Number
|
| 30 |
DISTANCE |
Number(8,2) |
DECIMAL(7,2) NOT NULL |
Distance Traveled
|
| 31 |
DISTANCE_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Distance Type
3=Metres
K=Kilometers
M=Miles
|
| 32 |
DISTANCE_RT |
Number(9,4) |
DECIMAL(8,4) NOT NULL |
Standard Distance Rate
|
| 33 |
NBR_NIGHTS |
Number(3,0) |
SMALLINT NOT NULL |
Number of Nights
Default Value: 1
|
| 34 |
EE_LOCAMT_COMMENT |
Character(60) |
VARCHAR2(60) NOT NULL |
Location Amount Comment
|
| 35 |
EE_NORCPT_COMMENT |
Character(60) |
VARCHAR2(60) NOT NULL |
No Receipt Comment
|
| 36 |
EE_PRFMRC_COMMENT |
Character(60) |
VARCHAR2(60) NOT NULL |
Preferred Vendor Comment
|
| 37 |
EE_DPLCAT_COMMENT |
Character(80) |
VARCHAR2(80) NOT NULL |
Duplicate Comment
|
| 38 |
RECEIPT_VERIFIED |
Character(1) |
VARCHAR2(1) NOT NULL |
Receipt Verified
Y/N Table Edit
Default Value: N
|
| 39 |
OUT_OF_POLICY |
Character(1) |
VARCHAR2(1) NOT NULL |
Authorized Amount Exceeded
Y/N Table Edit
Default Value: N
|
| 40 |
NO_RECEIPT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
No Receipt
Y/N Table Edit
Default Value: N
|
| 41 |
PREF_MRCH_NOT_USED |
Character(1) |
VARCHAR2(1) NOT NULL |
Non-Preferred Merchant
Y/N Table Edit
Default Value: N
|
| 42 |
TAX_IMPLICATIONS |
Character(1) |
VARCHAR2(1) NOT NULL |
Items with Tax Implications
Y/N Table Edit
Default Value: N
|
| 43 |
DUPLICATES_EXIST |
Character(1) |
VARCHAR2(1) NOT NULL |
Duplicates Exist
Y/N Table Edit
Default Value: N
|
| 44 |
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
|
| 45 |
SPA_BILLING_ACTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Billing Action
B=Billable
U=Nonbillable
Default Value: B
|
| 46 |
BILLING_ACTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Billing Action
B=Billable
I=Internal
P=Personal
U=Nonbillable
|
| 47 |
OVRRIDE_SPLT_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Override Accounting Split
Y/N Table Edit
Default Value: N
|
| 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 |
GROSSUP |
Character(1) |
VARCHAR2(1) NOT NULL |
Gross Up Indicator
Y/N Table Edit
Default Value: N
|
| 50 |
SEPCHK |
Number(1,0) |
SMALLINT NOT NULL |
Separate Check Indicator
|
| 51 |
EX_CREDIT_REF |
Character(60) |
VARCHAR2(60) NOT NULL |
Informational field used for reference when a credit line
is entered in an expense sheet.
|
| 52 |
TRANS_DT_JULIAN |
Number(3,0) |
SMALLINT NOT NULL |
Julian Transaction Date
|
| 53 |
STARTTM_PERDIEM |
Time(15) |
TIMESTAMP |
Start Time (HH:MI)
|
| 54 |
ENDTM_PERDIEM |
Time(15) |
TIMESTAMP |
End Time (HH:MI)
|
| 55 |
CRDMEM_ACCT_NBR |
Character(44) |
VARCHAR2(44) NOT NULL |
Cardmember Number
|
| 56 |
BREAKFAST_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Breakfast Provided
Y/N Table Edit
Default Value: N
|
| 57 |
LUNCH_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Lunch Provided
Y/N Table Edit
Default Value: N
|
| 58 |
DINNER_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Dinner Provided
Y/N Table Edit
Default Value: N
|
| 59 |
COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
|
| 60 |
STATE |
Character(6) |
VARCHAR2(6) NOT NULL |
State
|
| 61 |
VAT_RECEIPT |
Character(1) |
VARCHAR2(1) NOT NULL |
No VAT Receipt
|
| 62 |
VAT_INCLUDE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Includes VAT
E=Exclude VAT
I=Include VAT
|
| 63 |
VAT_ENTRD_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Entered VAT Amount
|
| 64 |
VAT_APPL_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
VAT Applicable
|
| 65 |
VAT_NRCVR_PRO_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Prorate Non-Recoverable VAT
|
| 66 |
TAX_CD_VAT |
Character(8) |
VARCHAR2(8) NOT NULL |
Defines the VAT (Value Added Tax) percentage (via link to the Tax Authority) and is used to retrieve VAT accounting ChartFields. The VAT code determines how the VAT amount is calculated on a transaction and how that amount is accounted and reported for.
|
| 67 |
TAX_CD_VAT_PCT |
Signed Number(9,4) |
DECIMAL(7,4) NOT NULL |
Specifies the tax percentage that corresponds to the VAT code. If more than one VAT authority is linked to a VAT code this will represent an aggregate percentage.
|
| 68 |
VAT_TREATMENT_EXP |
Character(3) |
VARCHAR2(3) NOT NULL |
VAT Treatment for Expenses
DOM=Domestic VAT
FOR=Foreign VAT
NON=No VAT
|
| 69 |
VAT_TXN_TYPE_CD |
Character(4) |
VARCHAR2(4) NOT NULL |
Specifies a user-defined category of business transaction that is subject to VAT accounting and reporting. The VAT code and the VAT transaction type are used in conjunction with the VAT account type to obtain the ChartFields for accounting entries. Some examples of VAT Transaction Types are Exempt Sales Exempt Purchases Triangulation EU Sales and Domestic Sales.
|
| 70 |
VAT_RECOVERY_PCT |
Signed Number(7,2) |
DECIMAL(5,2) NOT NULL |
VAT Recovery Percent
|
| 71 |
VAT_REBATE_PCT |
Signed Number(7,2) |
DECIMAL(5,2) NOT NULL |
VAT Rebate Percent
|
| 72 |
VAT_ROUND_RULE |
Character(1) |
VARCHAR2(1) NOT NULL |
" Rounding rule to be applied to VAT calculations. Options are 'Natural'
D=Round Down
N=Natural Round
U=Round Up
|
| 73 |
VAT_CF_ANLSYS_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
VAT Chartfield Analysis
E=Use Expense Line Chartfields
N=Not Applicable
V=Use VAT Accounting Chartfields
|
| 74 |
AIR_TKT_RECON_STAT |
Character(1) |
VARCHAR2(1) NOT NULL |
Airline Ticket Reconciliation Status
C=Cancelled
N=Not Reconciled
R=Reconciled
Default Value: N
|
| 75 |
AMOUNT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amount
|
| 76 |
CURRENCY_CD_BASE |
Character(3) |
VARCHAR2(3) NOT NULL |
Business Unit Base Currency
|
| 77 |
RATE_MULT_2 |
Signed Number(17,8) |
DECIMAL(15,8) NOT NULL |
Rate Multiplier
|
| 78 |
RATE_DIV_2 |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
Rate Divisor
|
| 79 |
TE_INVOICE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Time and expense invoiced flag
N=No
Y=Yes
Default Value: N
|
| 80 |
INVOICE_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Invoice Number
|
| 81 |
INVOICE_LINE |
Number(5,0) |
INTEGER NOT NULL |
Invoice Line
|
| 82 |
INV_LINE_STATUS |
Character(4) |
VARCHAR2(4) NOT NULL |
Invoice Line Status
1=Generated
10=Adjusted by Ent Approver
11=Adjusted by Enterprise
2=Approved by Enterprise
3=Submitted to Enterprise
4=Denied by Enterprise
5=Submitted to Supplier
6=Approved by Supplier
7=Denied by Supplier
8=Canceled
9=Adjusted by Supplier
|
| 83 |
PC_DISTRIB_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
PC Distribution Status
B=Budget Check
D=Distributed
G=Generated
H=Hold
I=Ignore
M=Modified
N=Not Distributed
S=Staged
|