APGL_OPEN_DET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
2	REQUEST_ID	Character(10)	VARCHAR2(10) NOT NULL	Request ID
3	BUSINESS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	GL Business Unit
4	LEDGER_GROUP	Character(10)	VARCHAR2(10) NOT NULL	Ledger Group
5	LEDGER	Character(10)	VARCHAR2(10) NOT NULL	Ledger
6	ACCOUNT	Character(10)	VARCHAR2(10) NOT NULL	Account
7	BASE_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	"Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. "
8	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: BUS_UNIT_TBL_AP
9	VOUCHER_ID	Character(8)	VARCHAR2(8) NOT NULL	Voucher ID Default Value: NEXT
10	UNPOST_SEQ	Number(2,0)	SMALLINT NOT NULL	Identifies the sequence of journal entries when a journal is "unposted". When a journal is posted the UnPost Sequence is automatically set to "0". When a journal is unposted, a new reversing entry is automatically created with an UnPost Sequence of "1".
11	APPL_JRNL_ID	Character(10)	VARCHAR2(10) NOT NULL	Journal Template
12	PYMNT_CNT	Number(5,0)	INTEGER NOT NULL	Payments
13	JOURNAL_LINE	Number(9,0)	DECIMAL(9) NOT NULL	Uniquely identifies a journal line with a sequence number. Within a single journal entry, the line sequence begins with 1 and automatically increments by 1 for each succeeding journal line. There can be any number of lines associated with a journal header.
14	TOTAL_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Total Amount
15	AS_OF_DATE	Date(10)	DATE	As of Date
16	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.
17	VENDOR_SETID	Character(5)	VARCHAR2(5) NOT NULL	Vendor SetID Default Value: VENDOR.SETID
18	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier Default Value: VENDOR_SHRT_VW.VENDOR_ID Prompt Table: VNDR_ACTIVE_VW
19	NAME1	Character(40)	VARCHAR2(40) NOT NULL	Name 1
20	INVOICE_DT	Date(10)	DATE	Invoice Date
21	ACCOUNTING_DT	Date(10)	DATE	The accounting entry construction date for a given transaction (a generic field that crosses multiple
22	JOURNAL_DATE	Date(10)	DATE	Specifies the date the journal was created.
23	JOURNAL_ID	Character(10)	VARCHAR2(10) NOT NULL	Identifies a journal entry, consisting of a header and one or more lines. The Journal ID itself does not have to be unique, but together with the journal business unit and journal date, it forms a unique journal identifier.