BI_IVC_AL_CTX

(SQL Table)
Index Back

bi alert context record

BI invoice alert context record

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EOEN_PRCS_NAME Character(30) VARCHAR2(30) NOT NULL EOEN Process Name
2 EOEN_CATEGORY Character(30) VARCHAR2(30) NOT NULL EOEN Category
3 SEQ_NBR_EOEN Number(15,0) DECIMAL(15) NOT NULL EOEN Sequence Nbr
4 EOEN_EMAIL_GROUP Number(10,0) DECIMAL(10) NOT NULL Email group id
5 EOEN_NOTIFY_TO Character(30) VARCHAR2(30) NOT NULL Notification receiver
6 EMAIL_ADDRESS Long Character CLOB Email Addresses
7 QRYNAME Character(30) VARCHAR2(30) NOT NULL Query Name
8 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
9 EOEN_LAST_DTTIME DateTime(26) TIMESTAMP Last Date Time
10 EOEN_EMAIL_SUBJECT Character(100) VARCHAR2(100) NOT NULL EOEN Email subject field
11 EOEC_UL_ID Character(30) VARCHAR2(30) NOT NULL Identifies the user list to be used when creating the approval process.
12 INVOICE Character(22) VARCHAR2(22) NOT NULL Invoice
13 INVOICE_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Invoice Amount
14 BI_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Billing Currency Code
15 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
16 BILL_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Customer
17 BILLING_SPECIALIST Character(8) VARCHAR2(8) NOT NULL Billing Specialist
18 BI_ACTION_TMP Character(1) VARCHAR2(1) NOT NULL Bill Action
A=Approve Later
C=Approve Now
D=Delete Later
R=Delete Now