BI_CYCLE_PARM(SQL Table) |
Index Back |
---|---|
Billing Cycle Parameters |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | BILL_CYCLE_ID | Character(10) | VARCHAR2(10) NOT NULL |
Billing Cycle Identifier
Prompt Table: BI_CYCLE |
2 | CYCLE_PARM_TYPE | 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 |