FAI_ACCTG_HDRVW (SQL View)	Index Back
FAI Acctg Header - Workbench

FAI_ACCTG_HDRVW

(SQL View)

FAI Acctg Header - Workbench

SELECT A.EXT_SYSTEM_ID , A.BUSINESS_UNIT , A.LEDGER_GROUP , A.FAI_TRANSACTION_ID , A.ACCOUNTING_DT , A.EDIT_HDR_STATUS , A.POST_STATUS_FAI , A.SOURCE , A.IN_PROCESS_FLG , A.PROCESS_INSTANCE , A.LASTUPDDTTM , A.LASTUPDOPRID FROM PS_FAI_ACCTG_HDR A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EXT_SYSTEM_ID Character(10) VARCHAR2(10) NOT NULL External System ID

2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

3 LEDGER_GROUP Character(10) VARCHAR2(10) NOT NULL Ledger Group

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

5 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple

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 POST_STATUS_FAI Character(1) VARCHAR2(1) NOT NULL FAI Post Status
C=Closed
N=Unposted
P=Posted

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

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

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

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

12 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	EXT_SYSTEM_ID	Character(10)	VARCHAR2(10) NOT NULL	External System ID
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
3	LEDGER_GROUP	Character(10)	VARCHAR2(10) NOT NULL	Ledger Group
4	FAI_TRANSACTION_ID	Character(10)	VARCHAR2(10) NOT NULL	FAI Transaction ID
5	ACCOUNTING_DT	Date(10)	DATE	The accounting entry construction date for a given transaction (a generic field that crosses multiple
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	POST_STATUS_FAI	Character(1)	VARCHAR2(1) NOT NULL	FAI Post Status C=Closed N=Unposted P=Posted
8	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.
9	IN_PROCESS_FLG	Character(1)	VARCHAR2(1) NOT NULL	In process flag
10	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
11	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.
12	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.