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