BI_EXT_GRANT_LN(SQL Table) |
Index Back |
---|---|
Billing Extract Grant Lines |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance | |
2 | Character(5) | VARCHAR2(5) NOT NULL | Business Unit | |
3 | Character(22) | VARCHAR2(22) NOT NULL | Invoice | |
4 | Number(5,0) | INTEGER NOT NULL | Sequence | |
5 | 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 % |