SPA_SHEET_LN_AW

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	SHEET_ID	Character(10)	VARCHAR2(10) NOT NULL	Report ID
3	LINE_NBR	Number(5,0)	INTEGER NOT NULL	Line Number: 11/24/08 - Added TARGET label [PC product] Default Value: 1
4	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
5	DISTRIB_LINE_NUM	Number(5,0)	INTEGER NOT NULL	Distribution Line Prompt Table: SPA_EXPWODST_VW
6	SHEET_RCPT_NUM	Number(3,0)	SMALLINT NOT NULL	Receipt Number
7	SHEET_RCPT_TOTAL	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Total Local Amount
8	ARRIVAL_DATE	Date(10)	DATE	Arrival Date
9	DEPARTURE_DATE	Date(10)	DATE	Departure Date
10	EXPENSE_TYPE	Character(7)	VARCHAR2(7) NOT NULL	Expense Type Prompt Table: EX_TYPES_TBL
11	TRANS_DT	Date(10)	DATE	Transaction Date
12	REIMBURSEMENT_CD	Character(1)	VARCHAR2(1) NOT NULL	Deny N=Nonreimburseable P=Prepaid R=Reimburseable Default Value: R
13	PERSONAL_EXPENSE	Character(1)	VARCHAR2(1) NOT NULL	Personal Expense N=No Y=Yes Y/N Table Edit Default Value: N
14	REIMB_ACTION	Character(5)	VARCHAR2(5) NOT NULL	Reason Prompt Table: EX_ACTION_TBL
15	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.
16	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Prompt Table: CURRENCY_CD_TBL
17	TXN_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Transaction Amount
18	TXN_CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Transaction Currency Prompt Table: CURRENCY_CD_TBL
19	RATE_MULT	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	Rate Multiplier
20	RATE_DIV	Number(16,8)	DECIMAL(15,8) NOT NULL	Rate Divisor Default Value: 1
21	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
22	GROSS_UP_EST_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Gross Up Estimated Amount
23	TXN_LOCATION	Character(5)	VARCHAR2(5) NOT NULL	Expense Location Prompt Table: EX_LOCATION_VW
24	EXPEND_MTHD	Character(3)	VARCHAR2(3) NOT NULL	Payment Type Prompt Table: EX_EXP_MTHD_TBL Set Control Field: BUSINESS_UNIT_GL
25	PREF_MRCHNT_FLG	Character(1)	VARCHAR2(1) NOT NULL	Preferred Merchant N=No Y=Yes Y/N Table Edit Default Value: N
26	MERCHANT_CD	Character(10)	VARCHAR2(10) NOT NULL	Preferred Merchant Prompt Table: EX_MERCHANT_VW
27	MERCHANT	Character(40)	VARCHAR2(40) NOT NULL	Merchant
28	DESCR60	Character(60)	VARCHAR2(60) NOT NULL	Description
29	DESCR254	Character(254)	VARCHAR2(254) NOT NULL	Description of length 254
30	AIRFARE_RCPT_NBR	Character(16)	VARCHAR2(16) NOT NULL	Airfare Receipt Number
31	DISTANCE	Number(8,2)	DECIMAL(7,2) NOT NULL	Distance Traveled
32	DISTANCE_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Distance Type 3=Metres K=Kilometers M=Miles
33	DISTANCE_RT	Number(9,4)	DECIMAL(8,4) NOT NULL	Standard Distance Rate
34	NBR_NIGHTS	Number(3,0)	SMALLINT NOT NULL	Number of Nights Default Value: 1
35	EE_LOCAMT_COMMENT	Character(60)	VARCHAR2(60) NOT NULL	Location Amount Comment
36	EE_NORCPT_COMMENT	Character(60)	VARCHAR2(60) NOT NULL	No Receipt Comment
37	EE_PRFMRC_COMMENT	Character(60)	VARCHAR2(60) NOT NULL	Preferred Vendor Comment
38	EE_DPLCAT_COMMENT	Character(80)	VARCHAR2(80) NOT NULL	Duplicate Comment
39	RECEIPT_VERIFIED	Character(1)	VARCHAR2(1) NOT NULL	Receipt Verified Y/N Table Edit Default Value: N
40	OUT_OF_POLICY	Character(1)	VARCHAR2(1) NOT NULL	Authorized Amount Exceeded Y/N Table Edit Default Value: N
41	NO_RECEIPT_FLG	Character(1)	VARCHAR2(1) NOT NULL	No Receipt Y/N Table Edit Default Value: N
42	PREF_MRCH_NOT_USED	Character(1)	VARCHAR2(1) NOT NULL	Non-Preferred Merchant Y/N Table Edit Default Value: N
43	TAX_IMPLICATIONS	Character(1)	VARCHAR2(1) NOT NULL	Items with Tax Implications Y/N Table Edit Default Value: N
44	DUPLICATES_EXIST	Character(1)	VARCHAR2(1) NOT NULL	Duplicates Exist Y/N Table Edit Default Value: N
45	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
46	SPA_BILLING_ACTION	Character(1)	VARCHAR2(1) NOT NULL	Billing Action B=Billable U=Nonbillable Default Value: B
47	BILLING_ACTION	Character(1)	VARCHAR2(1) NOT NULL	Billing Action B=Billable I=Internal P=Personal U=Nonbillable
48	OVRRIDE_SPLT_SW	Character(1)	VARCHAR2(1) NOT NULL	Override Accounting Split Y/N Table Edit Default Value: N
49	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.
50	GROSSUP	Character(1)	VARCHAR2(1) NOT NULL	Gross Up Indicator Y/N Table Edit Default Value: N
51	SEPCHK	Number(1,0)	SMALLINT NOT NULL	Separate Check Indicator
52	EX_CREDIT_REF	Character(60)	VARCHAR2(60) NOT NULL	Informational field used for reference when a credit line is entered in an expense sheet.
53	TRANS_DT_JULIAN	Number(3,0)	SMALLINT NOT NULL	Julian Transaction Date
54	STARTTM_PERDIEM	Time(15)	TIMESTAMP	Start Time (HH:MI)
55	ENDTM_PERDIEM	Time(15)	TIMESTAMP	End Time (HH:MI)
56	CRDMEM_ACCT_NBR	Character(44)	VARCHAR2(44) NOT NULL	Cardmember Number
57	BREAKFAST_FLG	Character(1)	VARCHAR2(1) NOT NULL	Breakfast Provided Y/N Table Edit Default Value: N
58	LUNCH_FLG	Character(1)	VARCHAR2(1) NOT NULL	Lunch Provided Y/N Table Edit Default Value: N
59	DINNER_FLG	Character(1)	VARCHAR2(1) NOT NULL	Dinner Provided Y/N Table Edit Default Value: N
60	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country
61	STATE	Character(6)	VARCHAR2(6) NOT NULL	State
62	VAT_RECEIPT	Character(1)	VARCHAR2(1) NOT NULL	No VAT Receipt
63	VAT_INCLUDE_FLG	Character(1)	VARCHAR2(1) NOT NULL	Includes VAT E=Exclude VAT I=Include VAT
64	VAT_ENTRD_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Entered VAT Amount
65	VAT_APPL_FLG	Character(1)	VARCHAR2(1) NOT NULL	VAT Applicable
66	VAT_NRCVR_PRO_FLG	Character(1)	VARCHAR2(1) NOT NULL	Prorate Non-Recoverable VAT
67	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.
68	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.
69	VAT_TREATMENT_EXP	Character(3)	VARCHAR2(3) NOT NULL	VAT Treatment for Expenses DOM=Domestic VAT FOR=Foreign VAT NON=No VAT
70	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.
71	VAT_RECOVERY_PCT	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	VAT Recovery Percent
72	VAT_REBATE_PCT	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	VAT Rebate Percent
73	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
74	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
75	AIR_TKT_RECON_STAT	Character(1)	VARCHAR2(1) NOT NULL	Airline Ticket Reconciliation Status C=Cancelled N=Not Reconciled R=Reconciled Default Value: N
76	AMOUNT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Amount
77	CURRENCY_CD_BASE	Character(3)	VARCHAR2(3) NOT NULL	Business Unit Base Currency
78	RATE_MULT_2	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	Rate Multiplier
79	RATE_DIV_2	Number(16,8)	DECIMAL(15,8) NOT NULL	Rate Divisor
80	TE_INVOICE_FLG	Character(1)	VARCHAR2(1) NOT NULL	Time and expense invoiced flag N=No Y=Yes Default Value: N
81	INVOICE_ID	Character(30)	VARCHAR2(30) NOT NULL	Invoice Number
82	INVOICE_LINE	Number(5,0)	INTEGER NOT NULL	Invoice Line
83	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
84	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