EX_ADV_LINE_H (SQL Table)	Index Back
Advance Line History Advance Line History after the Archival process has run.

EX_ADV_LINE_H

(SQL Table)

Advance Line History

Advance Line History after the Archival process has run.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PSARCH_ID Character(8) VARCHAR2(8) NOT NULL Archive ID (see PSARCHTEMPLATE).

2 PSARCH_BATCHNUM Number(30,0) DECIMAL(30) NOT NULL Archive Batch Number

3 ADVANCE_ID Character(10) VARCHAR2(10) NOT NULL Advance ID

4 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
Default Value: 1

5 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: PND

6 ADVANCE_SOURCE Character(4) VARCHAR2(4) NOT NULL Advance Source
Prompt Table: EX_ADV_SRC_TBL

7 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.

8 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
Default Value: BUS_UNIT_TBL_EX.BASE_CURRENCY
Prompt Table: CURRENCY_CD_TBL

9 DESCR Character(30) VARCHAR2(30) NOT NULL Description

10 GROSSUP Character(1) VARCHAR2(1) NOT NULL Gross Up Indicator
Y/N Table Edit
Default Value: N

11 SEPCHK Number(1,0) SMALLINT NOT NULL Separate Check Indicator

12 GROSS_UP_EST_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Gross Up Estimated Amount

13 APPROVER_OPRID Character(30) VARCHAR2(30) NOT NULL Approver Oprid

14 APPROVER_ACTN_DT Date(10) DATE The Date on which the approver takes necessary action

15 APPROVER_ADD_FLAG Character(1) VARCHAR2(1) NOT NULL New Approver Add Flag

16 LASTUPDDTTM 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.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PSARCH_ID	Character(8)	VARCHAR2(8) NOT NULL	Archive ID (see PSARCHTEMPLATE).
2	PSARCH_BATCHNUM	Number(30,0)	DECIMAL(30) NOT NULL	Archive Batch Number
3	ADVANCE_ID	Character(10)	VARCHAR2(10) NOT NULL	Advance ID
4	LINE_NBR	Number(5,0)	INTEGER NOT NULL	Line Number: 11/24/08 - Added TARGET label [PC product] Default Value: 1
5	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: PND
6	ADVANCE_SOURCE	Character(4)	VARCHAR2(4) NOT NULL	Advance Source Prompt Table: EX_ADV_SRC_TBL
7	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.
8	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Default Value: BUS_UNIT_TBL_EX.BASE_CURRENCY Prompt Table: CURRENCY_CD_TBL
9	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
10	GROSSUP	Character(1)	VARCHAR2(1) NOT NULL	Gross Up Indicator Y/N Table Edit Default Value: N
11	SEPCHK	Number(1,0)	SMALLINT NOT NULL	Separate Check Indicator
12	GROSS_UP_EST_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Gross Up Estimated Amount
13	APPROVER_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Approver Oprid
14	APPROVER_ACTN_DT	Date(10)	DATE	The Date on which the approver takes necessary action
15	APPROVER_ADD_FLAG	Character(1)	VARCHAR2(1) NOT NULL	New Approver Add Flag
16	LASTUPDDTTM	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.