DESTIN_BUINTERUNIT_IDC=Closed
O=Open
P=Pending
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
IN_IUT_RECV_TMP(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | DESTIN_BU |
Character(5) | VARCHAR2(5) NOT NULL | Destination Unit |
| 2 | INTERUNIT_ID |
Character(10) | VARCHAR2(10) NOT NULL | InterUnit Order ID |
| 3 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 4 | RECEIVER_ID | Character(10) | VARCHAR2(10) NOT NULL | Receiver number |
| 5 | RECV_LN_NBR | Number(5,0) | INTEGER NOT NULL | Receipt Line |
| 6 | INV_RECVLN_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Receipt Line Status
C=Closed O=Open P=Pending |
| 7 | QTY_INV_RECV | Number(16,4) | DECIMAL(15,4) NOT NULL | Quantity Received |
| 8 | UNIT_OF_MEASURE | Character(3) | VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly PER=Percentage SQF=Square Footage |