RUN_BI_STSCHG

(SQL Table)
Index Back

BI Prcs Run Cntl-Status Change

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

Prompt Table: OPRID_VW

2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
3 INVOICE_RANGE_OPT Character(3) VARCHAR2(3) NOT NULL Invoice Range Option
ALI=All Invoiced Bills
ALL=All
CUS=Cust ID
CYC=Bill Cycle
DT=Date Bill Added
DTI=Date
GRP=Copy Group ID
INV=Invoice ID
MUL=Multi-Select Table
PVN=Public Voucher Number
RGP=Reprint Group
SEL=Range ID
SHP=Ship ID
SRC=Bill Source
TYP=Bill Type

Default Value: ALL

4 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

Prompt Table: SP_BU_BI_NONVW

5 CUST_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.

Prompt Table: BI_BILL_TO_VW

6 BILL_CYCLE_ID Character(10) VARCHAR2(10) NOT NULL Billing Cycle Identifier

Prompt Table: BI_CYCLE_VW

7 BILL_SOURCE_ID Character(10) VARCHAR2(10) NOT NULL Bill Source

Prompt Table: BI_SRC_EF_VW

8 BILL_TYPE_ID Character(3) VARCHAR2(3) NOT NULL Bill Type Identifier

Prompt Table: BI_TYPE_EF_VW

9 START_INVOICE Character(22) VARCHAR2(22) NOT NULL Starting Invoice Number

Prompt Table: BI_INV_LKUP_DVW

10 END_INVOICE Character(22) VARCHAR2(22) NOT NULL Ending Invoice Number

Default Value: RUN_BI_STSCHG.START_INVOICE

Prompt Table: BI_INV_LKUP_DVW

11 STARTING_DT Date(10) DATE Bills Added On or After
12 RANGE_SELECTION_ID Character(30) VARCHAR2(30) NOT NULL Range Selection ID

Prompt Table: BI_RNG_LKUP_DVW

13 BILL_CPY_GRP_ID Character(10) VARCHAR2(10) NOT NULL Bill Copy Group ID

Prompt Table: BI_BILL_CPY_VW

14 STATUS_SOURCE Character(1) VARCHAR2(1) NOT NULL Status Source
G=Status from Bill Copy Group
R=Status from Run Control

Default Value: R

15 NEW_BILL_STATUS Character(3) VARCHAR2(3) NOT NULL New Bill Status
CAN=Canceled
HLD=Hold Bill
NEW=New Bill
PND=Pending
RDY=Ready Bill

Default Value: RDY

16 NEW_ALLOWED Character(1) VARCHAR2(1) NOT NULL New Allowed

Y/N Table Edit

Default Value: Y

17 HOLD_ALLOWED Character(1) VARCHAR2(1) NOT NULL Hold Allowed

Y/N Table Edit

Default Value: N

18 PENDING_ALLOWED Character(1) VARCHAR2(1) NOT NULL Pending Allowed

Y/N Table Edit

Default Value: N

19 READY_ALLOWED Character(1) VARCHAR2(1) NOT NULL Ready Allowed

Y/N Table Edit

Default Value: N

20 CANCELED_ALLOWED Character(1) VARCHAR2(1) NOT NULL Canceled Allowed

Y/N Table Edit

Default Value: N

21 CONSOLIDATE Character(1) VARCHAR2(1) NOT NULL Consolidate Headers

Y/N Table Edit

22 ADD_DT Date(10) DATE Customer Added On

Default Value: %DATE