DIST_LN_IU2_TMP

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
3	ASSET_ID	Character(12)	VARCHAR2(12) NOT NULL	Asset Identification
4	BOOK	Character(10)	VARCHAR2(10) NOT NULL	Asset Book Name
5	DTTM_STAMP	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.
6	CF_SEQNO	Number(6,0)	INTEGER NOT NULL	Chartfield Sequence Number
7	ACCOUNT	Character(10)	VARCHAR2(10) NOT NULL	Account Prompt Table: GL_ACCT_CUR_VW
8	ALTACCT	Character(10)	VARCHAR2(10) NOT NULL	Alternate Account Prompt Table: ALTACCT_CUR_VW
9	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department Prompt Table: DEPT_TBL
10	DISTRIBUTION_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Distribution Type
11	TRANS_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Types of Asset Management Transactions ACR=Accretion Expense ADD=Asset Addition ADJ=Asset Cost Adjustment BKS=Book Adjustment BUD=Budgeted Depreciation DPR=Depreciation INF=Inflation Adjustment LEX=Lease Expense LPB=Budgeted Lease Payments LPY=Lease Payment PDP=Prior Period Depreciation PLP=Prior Lease Payment RAD=Manual Reserve Adjustment RCT=Asset Recategorization REI=Asset Reinstatement RES=Resume Depreciation RET=Asset Retirement RRC=Retro rate change for grp ast SUS=Suspend Depreciation TRF=Asset Transfer
12	ACCOUNTING_DT	Date(10)	DATE NOT NULL	The accounting entry construction date for a given transaction (a generic field that crosses multiple
13	OPERATING_UNIT	Character(8)	VARCHAR2(8) NOT NULL	Operating Unit ChartField Prompt Table: OPER_UNIT_TBL
14	PRODUCT	Character(6)	VARCHAR2(6) NOT NULL	Product ChartField Prompt Table: PRODUCT_TBL
15	FUND_CODE	Character(5)	VARCHAR2(5) NOT NULL	Fund Code Prompt Table: FUND_TBL
16	CLASS_FLD	Character(5)	VARCHAR2(5) NOT NULL	Class Field Prompt Table: CLASS_CF_TBL
17	PROGRAM_CODE	Character(5)	VARCHAR2(5) NOT NULL	Program Code ChartField Prompt Table: PROGRAM_TBL
18	BUDGET_REF	Character(8)	VARCHAR2(8) NOT NULL	Budget Reference Prompt Table: BUD_REF_TBL
19	AFFILIATE	Character(5)	VARCHAR2(5) NOT NULL	Affiliate Prompt Table: AFFILIATE_VW
20	AFFILIATE_INTRA1	Character(10)	VARCHAR2(10) NOT NULL	IntraUnit Affiliate1 Prompt Table: %EDIT_INTRA01
21	AFFILIATE_INTRA2	Character(10)	VARCHAR2(10) NOT NULL	Operating Unit Affiliate Prompt Table: %EDIT_INTRA02
22	CHARTFIELD1	Character(10)	VARCHAR2(10) NOT NULL	Expansion chartfield 1 Prompt Table: CHARTFIELD1_TBL
23	CHARTFIELD2	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 2 Prompt Table: CHARTFIELD2_TBL
24	CHARTFIELD3	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 3 Prompt Table: CHARTFIELD3_TBL
25	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField Prompt Table: PROJECT_ID_VW
26	CATEGORY	Character(5)	VARCHAR2(5) NOT NULL	Asset Category Prompt Table: CATEGORY_TBL
27	COST_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Cost Type Prompt Table: COST_TYPE_TBL
28	TRANS_IN_OUT	Character(1)	VARCHAR2(1) NOT NULL	Transaction In/Out I=In M=IUT Proceeds Markup O=Out
29	TRANS_CODE	Character(5)	VARCHAR2(5) NOT NULL	Transaction Code
30	APPL_JRNL_ID	Character(10)	VARCHAR2(10) NOT NULL	Journal Template Prompt Table: JRNLGEN_APPL_ID
31	AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Amount
32	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.
33	JOURNAL_DATE	Date(10)	DATE	Specifies the date the journal was created.
34	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.
35	GL_DISTRIB_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Distribution Status C=Available to Contracts D=Distributed G=Generated H=Hold I=Ignored J=Creating Journals M=Modified N=None P=To be processed X=Waiting for Reversal
36	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
37	LEDGER_GROUP	Character(10)	VARCHAR2(10) NOT NULL	Ledger Group
38	LEDGER	Character(10)	VARCHAR2(10) NOT NULL	Ledger
39	FISCAL_YEAR	Number(4,0)	SMALLINT NOT NULL	Fiscal Year
40	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.
41	BUSINESS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	GL Business Unit
42	BUSINESS_UNIT_PC	Character(5)	VARCHAR2(5) NOT NULL	PC Business Unit
43	PC_DISTRIB_STATUS	Character(1)	VARCHAR2(1) NOT NULL	PC Distribution Status B=Budget Check D=Distributed G=Generated H=Hold I=Ignore M=Modified N=Not Distributed S=Staged
44	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
45	TXN_CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Transaction Currency
46	TXN_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Transaction Amount
47	RATE_MULT	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	Rate Multiplier
48	RATE_DIV	Number(16,8)	DECIMAL(15,8) NOT NULL	Rate Divisor
49	RT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
50	DOC_TYPE	Character(8)	VARCHAR2(8) NOT NULL	Specifies the business purpose of a financial transaction in countries that require all financial transactions to be tracked as "documents". A Document Type is associated with one and only one Journal Code.
51	DOC_SEQ_NBR	Character(12)	VARCHAR2(12) NOT NULL	Specifies the sequence number assigned to each financial transaction (a document). The sequence number may be manually entered or system-generated.
52	DOC_SEQ_DATE	Date(10)	DATE	Specifies the date that a document sequence number is assigned to a document or the date the document was created.
53	DOC_SEQ_STATUS	Character(1)	VARCHAR2(1) NOT NULL	A flag that indicates a document sequencing error. If there is no error the field is blank and document is considered valid for posting. 1=Document Sequencing Disabled A=GL BU Undefined B=GL BU Blank C=Accounting Date blank D=Doc Type Blank E=Jrnl Type, Code, Doc Undefine F=Sequence Range Undefine G=Max. Sequence Number Reached H=Manual Nbr for Auto Doc Type I=No Manual Number Entered J=Duplicate Manual Number K=Invalid Ledger L=Invalid Ledger Group N=No Status
54	ALLOC_RUN	Character(1)	VARCHAR2(1) NOT NULL	Allocation Run?
55	IU_ANCHOR_FLG	Character(1)	VARCHAR2(1) NOT NULL	Y/N flag used to specify which transaction line is the Inter/IntraUnit anchor flag (the line that contains the anchor Business Unit and ChartFields).
56	IU_SYS_TRAN_CD	Character(8)	VARCHAR2(8) NOT NULL	System Transactions are delivered system data, representing the activities that can require interunit or intraunit accounting entries.
57	IU_TRAN_CD	Character(8)	VARCHAR2(8) NOT NULL	Transaction Codes are user-defined. They are mapped to the delivered System Transactions. InterUnit and IntraUnit Templates are keyed by Transaction code, allowing users to vary their accounting by transaction.
58	IUT_JOURNAL_ID	Character(30)	VARCHAR2(30) NOT NULL	Identifies a journal entry for AM's interunit transfers
59	IU_MAP_KEY	Number(7,0)	INTEGER NOT NULL	InterUnit transfer map key
60	TRANSFER_BU	Character(5)	VARCHAR2(5) NOT NULL	Transfer Business Unit
61	TRANSFER_ASSET_ID	Character(12)	VARCHAR2(12) NOT NULL	Transfer Asset ID
62	TRANSFER_BOOK	Character(10)	VARCHAR2(10) NOT NULL	Transfer From Book
63	BOOK_CODE	Character(4)	VARCHAR2(4) NOT NULL	Book Code
64	MAX_SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Maximum Sequence Number
65	IU_LINE_TYPE	Character(1)	VARCHAR2(1) NOT NULL	1 - original transactions 2 - original transactions aggregated 3 - InterUnit Anchor w/o base (primary ledger lines) 4 - secondary non-translation ledger lines 5 - secondary translation ledger lines 6 - used as holding area for iu line type '3' when processing multicurrency 7 - already allocated secondary ledger lines 8 - InterUnit Anchor w/ base, already allocated primary ledger lines 9 - InterUnit Non-anchor A - IntraUnit Anchor B - IntraUnit non-anchor N - New lines U - Unbalanced x,y,z - lowercase letters to ignore for addl processing, marked as deleted
66	IU_LEGAL_ENT_BU_IU	Character(5)	VARCHAR2(5) NOT NULL	The business unit that represents the legal entity to which the GL Unit belongs. May have the same value as the GL Unit if it is its own legal entity.
67	PRIMARY_LEDGER_IU	Character(1)	VARCHAR2(1) NOT NULL	A flag that indicates whether or not (Y or N) a ledger is designated as the primary ledger in a ledger group.
68	TRANSL_LEDGER_IU	Character(1)	VARCHAR2(1) NOT NULL	Currency Translation Ledger
69	SETID_IU	Character(5)	VARCHAR2(5) NOT NULL	SetID
70	LEDGERS_SYNC_IU	Character(1)	VARCHAR2(1) NOT NULL	Keep Ledgers in Sync
71	SECOND_LEDGERS_IU	Character(1)	VARCHAR2(1) NOT NULL	Secondary Ledgers Exist
72	MAX_SEQUENCE	Number(9,0)	DECIMAL(9) NOT NULL