BP_LEDGER_BDEXP

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BP_EXPORT_SEQ	Character(30)	VARCHAR2(30) NOT NULL	BAM Export Sequence
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
3	LEDGER	Character(10)	VARCHAR2(10) NOT NULL	Ledger
4	ACCOUNT	Character(10)	VARCHAR2(10) NOT NULL	Account
5	ALTACCT	Character(10)	VARCHAR2(10) NOT NULL	Alternate Account
6	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
7	STATISTICS_CODE	Character(3)	VARCHAR2(3) NOT NULL	Statistics Code
8	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
9	OPERATING_UNIT	Character(8)	VARCHAR2(8) NOT NULL	Operating Unit ChartField Prompt Table: OPERUNT_SC_VW
10	PRODUCT	Character(6)	VARCHAR2(6) NOT NULL	Product ChartField Prompt Table: PRODUCT_SC_VW
11	FUND_CODE	Character(5)	VARCHAR2(5) NOT NULL	Fund Code Prompt Table: FUND_SC_VW
12	CLASS_FLD	Character(5)	VARCHAR2(5) NOT NULL	Class Field Prompt Table: CLASS_CF_SC_VW
13	PROGRAM_CODE	Character(5)	VARCHAR2(5) NOT NULL	Program Code ChartField Prompt Table: PROGRAM_SC_VW
14	BUDGET_REF	Character(8)	VARCHAR2(8) NOT NULL	Budget Reference Prompt Table: BUD_REF_SC_VW
15	AFFILIATE	Character(5)	VARCHAR2(5) NOT NULL	Affiliate Prompt Table: AFFILIATE_VW
16	AFFILIATE_INTRA1	Character(10)	VARCHAR2(10) NOT NULL	IntraUnit Affiliate1 Prompt Table: %EDIT_INTRA01
17	AFFILIATE_INTRA2	Character(10)	VARCHAR2(10) NOT NULL	Operating Unit Affiliate Prompt Table: %EDIT_INTRA02
18	CHARTFIELD1	Character(10)	VARCHAR2(10) NOT NULL	Expansion chartfield 1 Prompt Table: CF1_SC_VW
19	CHARTFIELD2	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 2 Prompt Table: CF2_SC_VW
20	CHARTFIELD3	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 3 Prompt Table: CF3_SC_VW
21	BUSINESS_UNIT_PC	Character(5)	VARCHAR2(5) NOT NULL	PC Business Unit
22	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField
23	ACTIVITY_ID	Character(15)	VARCHAR2(15) NOT NULL	Activity ID
24	RESOURCE_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Source Type
25	ANALYSIS_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Analysis Type
26	RESOURCE_CATEGORY	Character(5)	VARCHAR2(5) NOT NULL	Category
27	RESOURCE_SUB_CAT	Character(5)	VARCHAR2(5) NOT NULL	Subcategory
28	RESOURCE_ID	Character(40)	VARCHAR2(40) NOT NULL	Transaction ID
29	BUDGET_PERIOD	Character(8)	VARCHAR2(8) NOT NULL	Budget Period
30	SCENARIO	Character(10)	VARCHAR2(10) NOT NULL	A unique key identifier that allows a treasury to classify distinct revaluation events as varying and divergent ca
31	FISCAL_YEAR	Number(4,0)	SMALLINT NOT NULL	Fiscal Year
32	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.
33	BP_POSTED_TOT_AMT	Signed Number(29,4)	DECIMAL(27,4) NOT NULL	Posted Total Amount
34	BP_POSTED_BASE_AMT	Signed Number(29,4)	DECIMAL(27,4) NOT NULL	Posted Base Currency Amount
35	BP_POSTED_TRAN_AMT	Signed Number(29,4)	DECIMAL(27,4) NOT NULL	Posted Transaction Amount
36	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. "
37	BP_LEDGER_NAME	Character(30)	VARCHAR2(30) NOT NULL	Budget Ledger Name