| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 LINE_NO |
Number(3,0) |
SMALLINT NOT NULL |
Line Number
|
| 2 |
RESP_RETURN_CD |
Number(5,0) |
INTEGER NOT NULL |
Return code when call to an EIP was unsuccessful.
|
| 3 |
MESSAGE_TEXT |
Character(100) |
VARCHAR2(100) NOT NULL |
Message Text This field refers to the Text for a particular Message Number in the Message Catalog.
|
| 4 |
SHIPTO_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Setid corresponding to the ship-to from Inventory.
|
| 5 |
SHIPTO_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Ship-to identification number from Inventory.
|
| 6 |
CARRIER_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Carrier ID
|
| 7 |
BUSINESS_UNIT_PO |
Character(5) |
VARCHAR2(5) NOT NULL |
PO Business Unit
|
| 8 |
PO_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Purchase Order
|
| 9 |
LINE_NBR |
Number(5,0) |
INTEGER NOT NULL |
This field represents the integer Order Line Number.
|
| 10 |
SCHED_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Schedule Number
|
| 11 |
VENDOR_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Identifier
|
| 12 |
QTY |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Quantity
|
| 13 |
QTY_OPEN |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Item quantity in a lot that is still open.
|
| 14 |
DUE_DT |
Date(10) |
DATE |
Specifies the date that a transaction is due. It is a generic field used in multiple PeopleSoft applications including Receivables Payables and Purchasing. For example it represents the date that payment is due for a voucher or the date that a scheduled shipment is due to be received.
|