BUSINESS_UNITFIELDNAMEPrompt Table: RECFIELD_VW
PO_CHNG_SHP_FLD(SQL View) |
Index Back |
|---|---|
Schedule Change Order Fields |
| SELECT A.BUSINESS_UNIT , B.FIELDNAME FROM PS_BUS_UNIT_TBL_PM A , PS_CHNG_TMPLT_FLD B WHERE A.CHNG_TMPLT_ID = B.CHNG_TMPLT_ID AND B.RECNAME = 'PO_LINE_SHIP' AND B.CHNG_TMPLT_TYPE='PO' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | FIELDNAME |
Character(18) | VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
Prompt Table: RECFIELD_VW |