| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_CS.BUSINESS_UNIT
Prompt Table:
SP_BU_SF_NONVW
|
| 2 |
BI_REQ_NBR |
Number(10,0) |
DECIMAL(10) NOT NULL |
Billing Request Nbr
|
| 3 |
BILL_REQ_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Bill Request ID
Prompt Table:
%EDITTABLE
|
| 4 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table:
PEOPLE_SRCH_SF
|
| 5 |
EXT_ORG_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
External Org ID
Prompt Table:
EXT_ORG_SF_VW2
|
| 6 |
BI_REQ_DT_TM |
DateTime(26) |
TIMESTAMP |
Billing Request Dt/Time
|
| 7 |
INVOICE_START |
Character(22) |
VARCHAR2(22) NOT NULL |
Invoice Start Nbr
|
| 8 |
INVOICE_END |
Character(22) |
VARCHAR2(22) NOT NULL |
Invoice Nbr End
|
| 9 |
DUE_DT |
Date(10) |
DATE |
Due Date
|
| 10 |
DUE_DAYS |
Number(3,0) |
SMALLINT NOT NULL |
Due Days
|
| 11 |
INVOICE_DT |
Date(10) |
DATE NOT NULL |
Invoice Date
Default Value: %date
|
| 12 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Default Value: OPR_DEF_TBL_CS.OPRID
|
| 13 |
BILL_ONE_EMPLID |
Character(1) |
VARCHAR2(1) NOT NULL |
Bill By Option
A=Bill All Not Yet Billed
C=Bill Per Contract(s)
E=Bill One Ext Org ID
N=Bill Range
Y=Bill One ID
Default Value: N
|
| 14 |
INVOICE_FORM_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Invoice Layout ID
Prompt Table:
BI_IVC_LAYOUTVW
|
| 15 |
JETFILE_CRYSTAL |
Character(1) |
VARCHAR2(1) NOT NULL |
Jet or Crystal Format
C=Crystal Bill
J=Form Based Extract Bill
O=Other Bill (SQR)
X=XML Publisher
Default Value: O
|
| 16 |
GENERATE_PRINT |
Character(1) |
VARCHAR2(1) NOT NULL |
Generate and Print Invoices
B=Generate & Print Bill
G=Generate Invoice
P=Print Bill
Default Value: G
|
| 17 |
STRM |
Character(4) |
VARCHAR2(4) NOT NULL |
Term
Prompt Table:
TERM_VAL_TBL
|
| 18 |
ALL_TERM_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Bill Term Flag Label
A=All Terms
O=One Term
R=Term Range
Default Value: A
|
| 19 |
TYPE_OF_REQUEST |
Character(1) |
VARCHAR2(1) NOT NULL |
Type of Request
C=Organization
E=Student
|
| 20 |
ORG_CONTACT |
Number(4,0) |
SMALLINT NOT NULL |
Contact Nbr
|
| 21 |
PRT_CLASS_SCHEDULE |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Schedule of Classes
Y/N Table Edit
Default Value: N
|
| 22 |
PRT_TERM_SCHEDULE |
Character(4) |
VARCHAR2(4) NOT NULL |
Print Term Schedule
Prompt Table:
TERM_VAL_TBL
|
| 23 |
BILL_BY_STUDENT |
Character(1) |
VARCHAR2(1) NOT NULL |
Invoice per Student
Y/N Table Edit
Default Value: N
|
| 24 |
USE_EMAIL_ADDR_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Email Address
Y/N Table Edit
Default Value: N
|
| 25 |
BI_CANC_REQ_STAT |
Character(1) |
VARCHAR2(1) NOT NULL |
Canceled flag
A=All bills cancelled
P=Partially cancelled
|
| 26 |
TO_TERM |
Character(4) |
VARCHAR2(4) NOT NULL |
To Term
Prompt Table:
TERM_VAL_TBL
|
| 27 |
ADDR_USAGE |
Character(10) |
VARCHAR2(10) NOT NULL |
Address Usage
Prompt Table:
ADDR_USAGE_TBL
|
| 28 |
OVERRIDE_ADDR_INFO |
Character(1) |
VARCHAR2(1) NOT NULL |
Override Address Info
Y/N Table Edit
Default Value: N
|
| 29 |
OVERRIDE_ADDR_REQ |
Character(1) |
VARCHAR2(1) NOT NULL |
Address not required
Y/N Table Edit
Default Value: N
|
| 30 |
JF_BILL_FILE |
Character(8) |
VARCHAR2(8) NOT NULL |
Bill File
|
| 31 |
JF_FILE_DIR |
Character(45) |
VARCHAR2(45) NOT NULL |
Output File Directory
|
| 32 |
PRINT_ZERO_BILL |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Zero Bill
Y/N Table Edit
Default Value: N
|
| 33 |
ANTIC_AID_TRM_FROM |
Character(4) |
VARCHAR2(4) NOT NULL |
Antic Aid Term From
Prompt Table:
TERM_VAL_TBL
|
| 34 |
ANTIC_AID_TERM_TO |
Character(4) |
VARCHAR2(4) NOT NULL |
Antic Aid Term To
Prompt Table:
TERM_VAL_TBL
|
| 35 |
LS_CONTACT_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Contact Type
Prompt Table:
ORG_CNT_TYP_TBL
|