RPTG_X_EX_DB2 (SQL Table)	Index Back
Rptg Xref-EX, AE Tmp

RPTG_X_EX_DB2

(SQL Table)

Rptg Xref-EX, AE Tmp

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

2 RPTG_APPL_ID Character(3) VARCHAR2(3) NOT NULL Reporting Application
AP=Accounts Payable
AR=Accounts Receivable
BI=Billing
EX=Expenses
Default Value: EX

3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

4 FISCAL_YEAR Number(4,0) SMALLINT NOT NULL Fiscal Year

5 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.

6 RPTG_DETAIL_SEQ Number(6,0) INTEGER NOT NULL Reporting Detail Line

7 BUSINESS_UNIT_TXN Character(5) VARCHAR2(5) NOT NULL Transaction Business Unit

8 EX_DOC_ID Character(10) VARCHAR2(10) NOT NULL Documentation ID

9 EX_DOC_TYPE Character(1) VARCHAR2(1) NOT NULL Identifies Expenses Document Type
A=Cash Advance
C=Time Report
J=Time Adjustment
M=Accrual - My Wallet
R=Accrual - Expense Report
S=Expense Report
T=Travel Authorization

10 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]

11 DISTRIB_LINE_NUM Number(5,0) INTEGER NOT NULL Distribution Line

12 DST_ACCT_TYPE Character(4) VARCHAR2(4) NOT NULL 07/20/04 st: added RCN for Advance Reconciliation 02/16/98 ebn CN#CM800-2.0 : Added for MISC type for Landed Cost Enhancement 11/11/99 llr: Added ADVP for Payables Advance Payment

13 APPL_JRNL_ID Character(10) VARCHAR2(10) NOT NULL Journal Template

14 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".

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	RPTG_APPL_ID	Character(3)	VARCHAR2(3) NOT NULL	Reporting Application AP=Accounts Payable AR=Accounts Receivable BI=Billing EX=Expenses Default Value: EX
3	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
4	FISCAL_YEAR	Number(4,0)	SMALLINT NOT NULL	Fiscal Year
5	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.
6	RPTG_DETAIL_SEQ	Number(6,0)	INTEGER NOT NULL	Reporting Detail Line
7	BUSINESS_UNIT_TXN	Character(5)	VARCHAR2(5) NOT NULL	Transaction Business Unit
8	EX_DOC_ID	Character(10)	VARCHAR2(10) NOT NULL	Documentation ID
9	EX_DOC_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Identifies Expenses Document Type A=Cash Advance C=Time Report J=Time Adjustment M=Accrual - My Wallet R=Accrual - Expense Report S=Expense Report T=Travel Authorization
10	LINE_NBR	Number(5,0)	INTEGER NOT NULL	Line Number: 11/24/08 - Added TARGET label [PC product]
11	DISTRIB_LINE_NUM	Number(5,0)	INTEGER NOT NULL	Distribution Line
12	DST_ACCT_TYPE	Character(4)	VARCHAR2(4) NOT NULL	07/20/04 st: added RCN for Advance Reconciliation 02/16/98 ebn CN#CM800-2.0 : Added for MISC type for Landed Cost Enhancement 11/11/99 llr: Added ADVP for Payables Advance Payment
13	APPL_JRNL_ID	Character(10)	VARCHAR2(10) NOT NULL	Journal Template
14	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".