| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 2 |
VCHR_BLD_CODE |
Character(6) |
VARCHAR2(6) NOT NULL |
Voucher Build Code
|
| 3 |
LINE_NBR |
Number(5,0) |
INTEGER NOT NULL |
Line Number:
11/24/08 - Added TARGET label [PC product]
|
| 4 |
SEQ_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Sequence
|
| 5 |
VENDOR_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Supplier
Y/N Table Edit
Default Value: N
|
| 6 |
RECV_DOC_REF_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Receiver Reference
B=Bill of Lading
C=Carrier ID
I=Invoice as Packslip
N=None
P=Packing Slip
Default Value: N
|
| 7 |
RECV_LINE_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Recv Line Criteria
B=Receiver Business Unit
N=None
R=Receiver ID
S=Receiver Schedule
Default Value: N
|
| 8 |
ITEM_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Item Option
I=Item Id
N=None
Default Value: N
|
| 9 |
PO_LINE_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
PO Line Criteria
B=PO Business Unit
L=PO Line
N=None
P=PO ID
S=PO Schedule
Default Value: N
|
| 10 |
RECV_QTY_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Quantity Option
A=Accepted Quantity
N=None
R=Received Quantity
Default Value: N
|
| 11 |
QTY_TOL_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Quantity Tolerances
N=None
P=PO Quanity Tolerances
V=Voucher Quantity Tolerances
Default Value: N
|
| 12 |
USER_BLD_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
User Defined
N=None
U=User Defined
V=View Only
Default Value: N
|
| 13 |
USER_BLD_CLAUSE |
Character(254) |
VARCHAR2(254) NOT NULL |
User Clause
|
| 14 |
BLD_CLAUSE1 |
Character(254) |
VARCHAR2(254) NOT NULL |
Bld Clause1
|
| 15 |
BLD_CLAUSE2 |
Character(254) |
VARCHAR2(254) NOT NULL |
Bld Clause2
|
| 16 |
BLD_CLAUSE3 |
Character(254) |
VARCHAR2(254) NOT NULL |
Bld Clause3
|
| 17 |
BLD_CLAUSE4 |
Character(254) |
VARCHAR2(254) NOT NULL |
Bld Clause4
|
| 18 |
FRM_CLAUSE1 |
Character(254) |
VARCHAR2(254) NOT NULL |
From Clause 1
|
| 19 |
BLD_CLAUSE_PB |
Character(1) |
VARCHAR2(1) NOT NULL |
Build Clause
|
| 20 |
USER_CLAUSE_PB |
Character(5) |
VARCHAR2(5) NOT NULL |
User Clause
|
| 21 |
BLD_CLAUSE_LONG |
Long Character(1024) |
VARCHAR2(1024) |
Concatenate Build Clause
|