FAH_ACCTG_HDR_H (SQL Table)	Index Back
FAH Acctg Header - Archive

FAH_ACCTG_HDR_H

(SQL Table)

FAH Acctg Header - Archive

# 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 AE_HEADER_ID Number(18,0) DECIMAL(18) NOT NULL AE Header ID

4 ANCHOR_BU Character(5) VARCHAR2(5) NOT NULL 5 character value used to identify the anchor business unit.

5 FAI_TRANSACTION_ID Character(10) VARCHAR2(10) NOT NULL FAI Transaction ID

6 EDIT_HDR_STATUS Character(1) VARCHAR2(1) NOT NULL Header Edit Status
A=Anchor Flag Error
C=Closed - Not Reloadable
D=Different Dates error
E=Error
N=New - Not Processed
S=External Source Error
U=Unbalanced Entries
V=Valid

7 FAI_DISTRIB_STATUS Character(1) VARCHAR2(1) NOT NULL FAI Distribution Status

8 TRANSFER_STATUS Character(1) VARCHAR2(1) NOT NULL Transfer Status
C=Completed
E=Error
P=In Process

9 IN_PROCESS_FLG Character(1) VARCHAR2(1) NOT NULL In process flag

10 SOURCE Character(3) VARCHAR2(3) NOT NULL Identifies the origin of a journal entry and defines journal entry error handling options. The journal source provides a means of selectively tracking, reporting, and inquiring on journal entries. It can be almost anything within the enterprise - a subsystem that generates transactions, a department, or even an individual.

11 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

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

13 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made 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	AE_HEADER_ID	Number(18,0)	DECIMAL(18) NOT NULL	AE Header ID
4	ANCHOR_BU	Character(5)	VARCHAR2(5) NOT NULL	5 character value used to identify the anchor business unit.
5	FAI_TRANSACTION_ID	Character(10)	VARCHAR2(10) NOT NULL	FAI Transaction ID
6	EDIT_HDR_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Header Edit Status A=Anchor Flag Error C=Closed - Not Reloadable D=Different Dates error E=Error N=New - Not Processed S=External Source Error U=Unbalanced Entries V=Valid
7	FAI_DISTRIB_STATUS	Character(1)	VARCHAR2(1) NOT NULL	FAI Distribution Status
8	TRANSFER_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Transfer Status C=Completed E=Error P=In Process
9	IN_PROCESS_FLG	Character(1)	VARCHAR2(1) NOT NULL	In process flag
10	SOURCE	Character(3)	VARCHAR2(3) NOT NULL	Identifies the origin of a journal entry and defines journal entry error handling options. The journal source provides a means of selectively tracking, reporting, and inquiring on journal entries. It can be almost anything within the enterprise - a subsystem that generates transactions, a department, or even an individual.
11	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
12	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.
13	LASTUPDOPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.