BUSINESS_UNITPrompt Table: SP_BU_BI_NONVW
INVOICEPrompt Table: BI_HDR
Default Value: NEXT
Y/N Table Edit
Default Value: N
BI_INST_SCHE_VW(SQL View) |
Index Back |
|---|---|
Installment Bill Schedule |
| SELECT BUSINESS_UNIT ,INVOICE ,INSTALL_NBR ,GENERATED_INVOICE ,GENERATED_FLAG ,GENERATED_DATE FROM PS_BI_INSTALL_SCHE |
| # | 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 | INSTALL_NBR | Number(3,0) | SMALLINT NOT NULL | Installment Number |
| 4 | GENERATED_INVOICE | Character(22) | VARCHAR2(22) NOT NULL |
Generated Invoice
Default Value: NEXT |
| 5 | GENERATED_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Recurring Bill Generated Flag
Y/N Table Edit Default Value: N |
| 6 | GENERATED_DATE | Date(10) | DATE | Generated Date |