RPTG_X_BI_TAO

(SQL Table)
Index Back

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

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 INVOICE Character(22) VARCHAR2(22) NOT NULL Invoice
9 LINE_SEQ_NUM Number(5,0) INTEGER NOT NULL Sequence
10 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple
11 ACCT_ENTRY_TYPE Character(3) VARCHAR2(3) NOT NULL Account Entry Type
12 DISC_SUR_LVL Number(2,0) SMALLINT NOT NULL Discount/Surcharge Level
13 DISC_SUR_ID Character(15) VARCHAR2(15) NOT NULL Identifier
14 LINE_DST_SEQ_NUM Number(3,0) SMALLINT NOT NULL Revenue Sequence Number
15 TAX_AUTHORITY_CD Character(3) VARCHAR2(3) NOT NULL Tax Authority
16 PROCESS_INST_STG Number(10,0) DECIMAL(10) NOT NULL Stage Record Process Instance