BI_EXT_GRANT_LN

(SQL Table)
Index Back

Billing Extract Grant Lines

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
3 INVOICE Character(22) VARCHAR2(22) NOT NULL Invoice
4 LINE_SEQ_NUM Number(5,0) INTEGER NOT NULL Sequence
5 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence
6 INVOICE_DT Date(10) DATE Invoice Date
7 BUSINESS_UNIT_CA Character(5) VARCHAR2(5) NOT NULL Contracts Business Unit
8 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract
9 CONTRACT_LINE_NUM Number(3,0) SMALLINT NOT NULL Contract Line Num
10 BILL_PLAN_ID Character(10) VARCHAR2(10) NOT NULL Billing Plan ID
11 EVENT_OCCURRENCE Number(3,0) SMALLINT NOT NULL Identifies a user-defined event on a schedule for automatically creating standard and recurring journal entries. Event Occurrence is a number associated with a date for creation of the journal.
12 EVENT_DT Date(10) DATE The date upon which an accounting event is scheduled to be processed and converted into corresponding accounting
13 TEXT254 Character(254) VARCHAR2(254) NOT NULL Text
14 CA_PERCENTAGE Signed Number(13,8) DECIMAL(11,8) NOT NULL Percentage
15 AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount
16 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
17 START_DT Date(10) DATE Start Date
18 END_DT Date(10) DATE End Date
19 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID
20 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
21 FUNDED_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Funded Amount
22 FA_RATE_TYPE Character(5) VARCHAR2(5) NOT NULL FA_RATE_TYPE
23 FA_FUNDED_RATE_PCT Number(6,2) DECIMAL(5,2) NOT NULL FA Funded Rate %