RUN_BI_EXS_DFLT

(SQL Table)
Index Back

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
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: INV

4 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL 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

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