| # |
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 |
REQUEST_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Request ID
|
| 4 |
LANGUAGE_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Language Code
|
| 5 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table:
SP_BUEXD_NONVW
|
| 6 |
PROCESS_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Status
A=Active
C=Successfully Completed
E=Completed With Errors
N=Not Yet Processed
P=Processing Now
X=No Success
Default Value: N
|
| 7 |
EXD_INVOICE_OPT |
Character(2) |
VARCHAR2(2) NOT NULL |
Excise Invoice Option
AI=All Invoices
DI=Date of Invoice
RI=Range of Invoices
SC=Single Customer
SI=Single Invoice
SL=Single Location
Default Value: AI
|
| 8 |
EXD_DOC_NBR_SER |
Character(6) |
VARCHAR2(6) NOT NULL |
Excise Document Number Series. Excise Document number series group will be created against each excise transaction type.
Prompt Table:
EXD_DOC_NBR_VW
|
| 9 |
EXD_REPRINT_INV |
Character(1) |
VARCHAR2(1) NOT NULL |
Reprint Invoice
N=no
Y=yes
Y/N Table Edit
Default Value: N
|
| 10 |
EXD_INV_DATE |
Date(10) |
DATE |
Date Invoice Created
Default Value: %Date
|
| 11 |
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:
EXD_CUST_ID_VW
|
| 12 |
LOCATION |
Character(10) |
VARCHAR2(10) NOT NULL |
Location Code
Prompt Table:
EXD_SHP_LOC_VW
|
| 13 |
EXD_INVOICE_NO |
Character(10) |
VARCHAR2(10) NOT NULL |
Excise Invoice Number
Prompt Table:
%EDITTABLE2
|
| 14 |
EXD_INVOICE_NO_FR |
Character(18) |
VARCHAR2(18) NOT NULL |
Excise Invoice No FR
Prompt Table:
EXD_ALLINV_VW
|
| 15 |
EXD_INVOICE_NO_TR |
Character(18) |
VARCHAR2(18) NOT NULL |
Excise Invoice No TR
Prompt Table:
EXD_ALLINV_VW
|