BI_CYCLE_PARM(SQL Table) |
Index Back |
|---|---|
Billing Cycle Parameters |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Character(10) | VARCHAR2(10) NOT NULL |
Billing Cycle Identifier
Prompt Table: BI_CYCLE |
|
| 2 | Character(1) | VARCHAR2(1) NOT NULL |
Cycle ParameterType
I=Installment R=Recurring |
|
| 3 | SCHEDULE | Character(10) | VARCHAR2(10) NOT NULL |
Schedule ID
Prompt Table: BI_SCHED_TBL_VW |
| 4 | GENERATE_LEAD_TIME | Number(3,0) | SMALLINT NOT NULL | Bill Generation Lead Days |
| 5 | IVC_DT_DFLT_CD | Character(2) | VARCHAR2(2) NOT NULL |
Invoice Date Default
BF=Bill From Date BT=Bill To Date GD=Generate Date UD=User Date |
| 6 | GENERATE_DT_BASIS | Character(2) | VARCHAR2(2) NOT NULL |
Bill Generation Date Basis
BF=Bill From Date BT=Bill To Date |