RPTG_X_AP_TAO

(SQL Table)
Index Back

Rptg Xref-AP, 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: AP

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 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID
9 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".
10 APPL_JRNL_ID Character(10) VARCHAR2(10) NOT NULL Journal Template
11 PYMNT_CNT Number(5,0) INTEGER NOT NULL Payments
12 VOUCHER_LINE_NUM Number(5,0) INTEGER NOT NULL Voucher Line Number
13 DISTRIB_LINE_NUM Number(5,0) INTEGER NOT NULL Distribution Line
14 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
15 CF_BAL_LINE_NUM Number(10,0) DECIMAL(10) NOT NULL Chart Field Balancing Line Num
16 LEDGER Character(10) VARCHAR2(10) NOT NULL Ledger