TR_BTB_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
3	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
4	REQUEST_NBR	Number(4,0)	SMALLINT NOT NULL	Request Number
5	BNK_ID_NBR	Character(20)	VARCHAR2(20) NOT NULL	A literal alphanumeric attribute that uniquely identifies a given bank or counterparty.
6	BANK_ACCOUNT_NUM	Character(35)	VARCHAR2(35) NOT NULL	The literal unique identifier associated with a given bank/counterparty account.
7	FISCAL_YEAR	Number(4,0)	SMALLINT NOT NULL	Fiscal Year
8	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.
9	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
10	LEDGER	Character(10)	VARCHAR2(10) NOT NULL	Ledger
11	LEDGER_GROUP	Character(10)	VARCHAR2(10) NOT NULL	Ledger Group
12	STATEMENT_ID	Number(10,0)	DECIMAL(10) NOT NULL	Statement ID for bank statements, key on Bank Statement Header
13	ASOFDATE	Date(10)	DATE	As of Date
14	BEGIN_DT	Date(10)	DATE	Begin Date
15	END_DT	Date(10)	DATE	End Date
16	BANK_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	Bank Account Currency
17	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. "
18	RATE_MULT	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	Rate Multiplier
19	RATE_DIV	Number(16,8)	DECIMAL(15,8) NOT NULL	Rate Divisor
20	RATE_INDEX	Character(10)	VARCHAR2(10) NOT NULL	Rate index
21	CUR_RT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Currency Rate Type
22	TRANS_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	Transaction Currency
23	RATE_DATE	Date(10)	DATE	Exchange Rate Date
24	RT_RATE_INDEX	Character(10)	VARCHAR2(10) NOT NULL	Market Rate Index
25	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.
26	RATE_MULT_2	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	Rate Multiplier
27	RATE_DIV_2	Number(16,8)	DECIMAL(15,8) NOT NULL	Rate Divisor
28	BTB_RECON_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Book to bank Reconciliation Status 1=Confirmed 2=Awaiting Confirmation 3=Calculating 4=New
29	BANK_STMT_BAL	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Used in Book to bank Recon
30	BANK_STMT_BAL_BASE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Used in Book to bank Recon
31	GL_BANK_ACCT_BAL	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Bank Acct Ledger Balance
32	PYMNT_IN_TRANSIT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Payment in Tansit use in Book to bank Recon
33	DEP_IN_TRANSIT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Deposits in Transit
34	GL_ADJUSTMENTS	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	GL Adj field used in Book to Bank Recon
35	FEES_INTEREST	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Unbooked Fees and Interest
36	UNBOOKED_PYMNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Unbooked Payments
37	UNBOOKED_DEP	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Unbooked Deposits
38	BANK_ADJUSTMENTS	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Bank Adjustments
39	ADJ_BANK_BAL	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Use in Book to Bank Recon
40	ADJUSTED_BNK_BAL	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Use in Book to Bank Recon
41	ADJ_GL_BAL	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	GL Adjustments Subtotal
42	ADJ_LEDGER_BAL	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Total Adjusted Ledger Balance
43	ADJ_DIFFERENCE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Adjustment Difference
44	REVAL_ADJUSTMENT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Revaluation Adjustment Amount
45	BANK_SETID	Character(5)	VARCHAR2(5) NOT NULL	The PeopleSoft tableset ID associated with a given bank/counterparty.
46	BANK_CD	Character(5)	VARCHAR2(5) NOT NULL	Bank Code
47	BANK_ACCT_KEY	Character(4)	VARCHAR2(4) NOT NULL	A user defined unique identifier that facilitates the identification of a given account with a given bank
48	PROCESS_FREQUENCY	Character(1)	VARCHAR2(1) NOT NULL	Process Frequency A=Always Process N=Don't Run O=Process Once Default Value: N
49	PROCESS_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Process Status A=Active C=Successfully Completed E=Completed With Errors N=Not Yet Processed P=Processing Now X=No Success Default Value: N
50	PROCESS_ORIG	Character(1)	VARCHAR2(1) NOT NULL	Process Origin N=Other Source P=Process Scheduler
51	SELECT_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Selection Flag N=No Y=Yes
52	AE_APPLID	Character(12)	VARCHAR2(12) NOT NULL	Program Name (see PSAEAPPLDEFN).
53	AE_SECTION	Character(8)	VARCHAR2(8) NOT NULL	Section
54	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.
55	FIELDLIST	Character(254)	VARCHAR2(254) NOT NULL	Used to store a list of FieldNames
56	XLATLONGNAME	Character(30)	VARCHAR2(30) NOT NULL	Translate Long Name
57	EVENT_TRACKING_ID	Number(10,0)	DECIMAL(10) NOT NULL	The event tracking ID is used in order to correlate objects with an event. Each object (i.e. Payment) will store the tracking ID with a given payment. That way the system can obtain all the events for a given payment via the tracking ID.
58	DESCR_VALUE_1	Character(30)	VARCHAR2(30) NOT NULL	Description
59	DESCR_VALUE_2	Character(30)	VARCHAR2(30) NOT NULL	Description
60	EX_PYMNT_DEST	Character(1)	VARCHAR2(1) NOT NULL	Determines whether employee expenses reimbursement will be processed by Payroll or Accounts Payables. A=Accounts Payable P=Payroll
61	EX	Character(1)	VARCHAR2(1) NOT NULL	Expenses