BI_INSTALL_SCHE(SQL Table) |
Index Back |
|---|---|
Installment Bill Schedule |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_BI_NONVW |
| 2 | INVOICE |
Character(22) | VARCHAR2(22) NOT NULL |
Invoice
Prompt Table: BI_HDR |
| 3 | 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.
Default Value: 1 |
| 4 | INSTALL_NBR | Number(3,0) | SMALLINT NOT NULL | Installment Number |
| 5 | PERCENTAGE | Signed Number(7,2) | DECIMAL(5,2) NOT NULL | Percentage |
| 6 | INSTALLMENT_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Installment Amount |
| 7 | INSTALLMENT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Installment Amount |
| 8 | INSTALLMENT_XEU | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Installment Amount |
| 9 | SERVICE_CHRG_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Service Charge Amount |
| 10 | SERVICE_CHRG_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Service Charge Amount |
| 11 | SERVICE_CHRG_XEU | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Service Charge Amount |
| 12 | BI_CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Billing Currency Code
Default Value: BI_HDR.BI_CURRENCY_CD |
| 13 | BASE_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL |
"Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. "
Default Value: BI_HDR.BASE_CURRENCY |
| 14 | CURRENCY_CD_XEU | Character(3) | VARCHAR2(3) NOT NULL |
Euro Currency
Default Value: BI_HDR.CURRENCY_CD_XEU |
| 15 | EVENT_DT | Date(10) | DATE | The date upon which an accounting event is scheduled to be processed and converted into corresponding accounting |
| 16 | INVOICE_DT | Date(10) | DATE | Invoice Date |
| 17 | BI_HDR_FROM_DT | Date(10) | DATE | Bill Header From Date |
| 18 | BI_HDR_TO_DT | Date(10) | DATE | Bill Header To Date |
| 19 | ACCOUNTING_DT | Date(10) | DATE | The accounting entry construction date for a given transaction (a generic field that crosses multiple |
| 20 | GENERATED_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Recurring Bill Generated Flag
Y/N Table Edit Default Value: N |
| 21 | GENERATED_INVOICE | Character(22) | VARCHAR2(22) NOT NULL |
Generated Invoice
Default Value: NEXT |
| 22 | GENERATED_DATE | Date(10) | DATE | Generated Date |
| 23 | CPY_STATUS | Character(3) | VARCHAR2(3) NOT NULL | Copy Status |
| 24 | PRIOR_CPY_INVOICE | Character(22) | VARCHAR2(22) NOT NULL | Prior Copy Invoice Id |
| 25 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 26 | ADD_DTTM | DateTime(26) | TIMESTAMP | Date Time Added |
| 27 | LAST_UPDATE_DTTM | DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |
| 28 | LAST_MAINT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Last Maintained By Operator ID |