| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Default Value: OPR_DEF_TBL_FS.OPRID
|
| 2 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID
Prompt Table:
SP_SETID_NONVW
|
| 3 |
WORKBENCH_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
WorkBench ID
|
| 4 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 5 |
CLAIM_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Claim Status
1=Open
3=Approved
5=Deferred
6=Cancelled
7=Pending Payment
8=Partially Paid
9=Paid
|
| 6 |
OVERDUE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Overdue Status
C=Current
O=Overdue
Y/N Table Edit
Default Value: N
|
| 7 |
CLAIM_DUE_DT |
Date(10) |
DATE |
Claim Due Date
|
| 8 |
CLAIM_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Claim ID
Prompt Table:
%EDITTABLE
|
| 9 |
CLAIM_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Claim Type
C=Claimbacks
R=Vendor Rebate
|
| 10 |
VENDOR_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Vendor SetID
Prompt Table:
VENDOR_PO_VW
|
| 11 |
VENDOR_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Identifier
Prompt Table:
%EDITTABLE2
Set Control Field: SETID
|
| 12 |
ACCOUNTING_DT |
Date(10) |
DATE |
The accounting entry construction date for a given transaction (a generic field that crosses multiple
|
| 13 |
CLAIM_PRCS_ACCT_DT |
Date(10) |
DATE |
Processing Accounting Date
|
| 14 |
VRBT_ID |
Character(25) |
VARCHAR2(25) NOT NULL |
Vendor Rebate ID
Prompt Table:
%EDIT_VRBT_ID
|
| 15 |
CB_CONTRACT_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Claimback Contract Setid
|
| 16 |
CB_CONTRACT_ID |
Character(25) |
VARCHAR2(25) NOT NULL |
Claimback Contract ID
Prompt Table:
CB_CON_SEC_VW
Set Control Field: CB_CONTRACT_SETID
|
| 17 |
RUNCNTLID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
Prompt Table:
VRBT_CLMPRCS_RC
|
| 18 |
SERVERNAME |
Character(8) |
VARCHAR2(8) NOT NULL |
Server Name
Prompt Table:
SERVERDEFN
|
| 19 |
OUTDESTFORMAT_VR |
Character(3) |
VARCHAR2(3) NOT NULL |
Output Dest Format
2=Acrobat (*.pdf)
|
| 20 |
OUTDESTTYPE_VR |
Character(3) |
VARCHAR2(3) NOT NULL |
Output Dest Type
2=File
6=Web
|