| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 3 |
VOUCHER_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Voucher ID
|
| 4 |
VOUCHER_LINE_NUM |
Number(5,0) |
INTEGER NOT NULL |
Voucher Line Number
|
| 5 |
VOUCHER_STYLE |
Character(4) |
VARCHAR2(4) NOT NULL |
Voucher Style
ADJ=Adjustments
AMR=Amortization Voucher
CLBK=Claim Voucher
CORR=Reversal Voucher
JRNL=Journal Voucher
PPAY=Prepaid Voucher
REG=Regular Voucher
RGTR=Register Voucher
SGLP=Single Payment Voucher
THRD=Third Party Voucher
TMPL=Template Voucher
|
| 6 |
MATCH_ACTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Match Action
N=No Match
Y=Standard
|
| 7 |
ENTRY_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
If translate values are added or changed, modify the following code to make sure the values appear accurately in the dropdown list in the search dialog: VCHR_SRCH_DEL.ENTRY_STATUS.SearchInit. Template Voucher status should not be visibile in the drop down.
C=Complete
D=Through batch defaults
E=Edited by Batch Voucher Module
L=Reviewed through Maintenance
M=Modified
O=Open
P=Postable
R=Recycle
S=Scheduled for Payment
T=Template Voucher
X=Deleted
|
| 8 |
VCHR_APPRVL_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Voucher Approval Flag
D=Default from Higher Level
P=Pre-Approved
S=Virtual Approver
W=Approval Framework
|
| 9 |
BUSINESS_UNIT_RECV |
Character(5) |
VARCHAR2(5) NOT NULL |
Receiving Business Unit
|
| 10 |
RECEIVER_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Receiver number
|
| 11 |
RECV_LN_NBR |
Number(5,0) |
INTEGER NOT NULL |
Receipt Line
|
| 12 |
RECV_SHIP_SEQ_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Receiver Shipping Sequence
|
| 13 |
RECV_LN_MATCH_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Receipt Match Status
F=Matched
N=No Match
P=Partial
|
| 14 |
MATCH_STATUS_RECV |
Character(1) |
VARCHAR2(1) NOT NULL |
Match Status
M=Matched
N=Not Matched
P=Partially Matched
T=To Match
V=Vouchered
|
| 15 |
BUSINESS_UNIT_PO |
Character(5) |
VARCHAR2(5) NOT NULL |
PO Business Unit
|
| 16 |
PO_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Purchase Order
|
| 17 |
LINE_NBR |
Number(5,0) |
INTEGER NOT NULL |
Line Number:
11/24/08 - Added TARGET label [PC product]
|
| 18 |
SCHED_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Schedule Number
|
| 19 |
RECV_COUNT |
Number(3,0) |
SMALLINT NOT NULL |
Receiver Count
|
| 20 |
MATCH_STATUS_LN_PO |
Character(1) |
VARCHAR2(1) NOT NULL |
Match Status PO
M=Matched
N=Not Matched
P=Partially Matched
|
| 21 |
MATCH_STATUS_PO |
Character(1) |
VARCHAR2(1) NOT NULL |
Match Status
M=Matched
N=Not Required
P=Partially Matched
T=To Match
|
| 22 |
PO_COUNT |
Number(10,0) |
DECIMAL(10) NOT NULL |
PO Count by Business Unit
|
| 23 |
COUNT_1 |
Number(3,0) |
SMALLINT NOT NULL |
Count Work Field
|
| 24 |
COUNT_2 |
Number(3,0) |
SMALLINT NOT NULL |
Count Work Field
|
| 25 |
ERROR_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Error Flag
|
| 26 |
TEMP_FLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Temporary Field for App Engine
|
| 27 |
QTY_MATCHED_PO |
Number(16,4) |
DECIMAL(15,4) NOT NULL |
Quantity Matched PO
|
| 28 |
QTY_ENTERED |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Quantity Entered
|
| 29 |
MERCH_AMT_PO |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Merchandise Amount
|
| 30 |
AMT_MATCHED |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amt Matched
|
| 31 |
MERCH_AMT_RECV |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Merchandise Amount Received
|