PO_PRINT_LN_WS(SQL Table) |
Index Back |
|---|---|
PO Print Line Working Scroll |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | LINE_NBR | Number(5,0) | INTEGER NOT NULL | Line Number: 11/24/08 - Added TARGET label [PC product] |
| 2 | CHNG_ORD_SEQ | Number(3,0) | SMALLINT NOT NULL | Change Order Sequence Number |
| 3 | ITM_ID_VNDR | Character(50) | VARCHAR2(50) NOT NULL | Vendor Item ID |
| 4 | DESCR254_MIXED | Character(254) | VARCHAR2(254) NOT NULL | Description |
| 5 | UNIT_OF_MEASURE | Character(3) | VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly PER=Percentage SQF=Square Footage |
| 6 | MFG_ID | Character(50) | VARCHAR2(50) NOT NULL | Manufacturer ID |
| 7 | CNTRCT_ID | Character(25) | VARCHAR2(25) NOT NULL | Buying Agreement ID |
| 8 | CNTRCT_LINE_NBR | Number(5,0) | INTEGER NOT NULL | Buying Agreement Line Nbr |
| 9 | CANCEL_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Cancel Status
A=Active C=Closed D=Denied H=Hold O=Open P=Pending Approval X=Canceled |