SF1219_DTL_TBL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	ALC	Character(8)	VARCHAR2(8) NOT NULL	Agency Location Code
3	FISCAL_YEAR	Number(4,0)	SMALLINT NOT NULL	Fiscal Year
4	ACCOUNTING_PERIOD	Number(3,0)	SMALLINT NOT NULL	Identifies a time period to which you post transactions. Typically, an accounting period represents a month, but it can also represent a week, a day, or any user-defined interval. An accounting period has a beginning date and an ending date, and is defined in the calendar table.
5	SF1219_LINE_ID	Character(7)	VARCHAR2(7) NOT NULL	SF1219 Line ID corresponds to the line on the SF1219 Statement of Accountability
6	SUPPLMNT_NUM	Number(1,0)	SMALLINT NOT NULL	Supplemental Number used by the flatfile SF1219_1220.
7	SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Sequence Number
8	SF1219_LINE_ID_UPD	Character(7)	VARCHAR2(7) NOT NULL	SF1219 Line ID corresponds to the line on the SF1219 Statement of Accountability. This field allows for a user to reclassify a transaction to another line number. Prompt Table: SF1219_LINE_VW2
9	SF1219_SOURCE	Character(3)	VARCHAR2(3) NOT NULL	Code that indicates the source of the SF1219 extracted data.. AP=AP ARD=AR Dir Jnl ARI=AR Item GL=GL
10	BUSINESS_UNIT_1	Character(5)	VARCHAR2(5) NOT NULL	Non-Joint Venture BU
11	VOUCHER_ID	Character(8)	VARCHAR2(8) NOT NULL	Voucher ID
12	VOUCHER_LINE_NUM	Number(5,0)	INTEGER NOT NULL	Voucher Line Number
13	APPL_JRNL_ID	Character(10)	VARCHAR2(10) NOT NULL	Journal Template
14	ITEM	Character(30)	VARCHAR2(30) NOT NULL	Uniquely identifies an invoice credit memo or debit memo. The item ID is also called the invoice number.
15	ITEM_LINE	Number(6,0)	INTEGER NOT NULL	Item Line
16	DEPOSIT_ID	Character(15)	VARCHAR2(15) NOT NULL	Uniquely identifies a deposit of customer payments. The deposit ID can be manually assigned or system-generated.
17	PAYMENT_SEQ_NUM	Number(6,0)	INTEGER NOT NULL	Specifies the system-generated sequence number assigned to each payment as it is entered in a deposit.
18	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.
19	JOURNAL_DATE	Date(10)	DATE	Specifies the date the journal was created.
20	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.
21	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.
22	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
23	ISSUE_MONTH	Number(2,0)	SMALLINT NOT NULL	Issue Month for SF1219 Statement of Accountability Report
24	ISSUE_YEAR	Number(4,0)	SMALLINT NOT NULL	Issue Year for SF1219 Statement of Accountability Report
25	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
26	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance