BUSINESS_UNITBUS_UNIT_ON_BEHALFDefault Value: LC_HDR.BUSINESS_UNIT
Prompt Table: SP_BU_PM_NONVW
PO_IDPrompt Table: PO_HDR
Prompt Table: LC_TR_VNDR_VW
LC_PO_PROMPT_VW(SQL View) |
Index Back |
|---|---|
PO Number prompt view |
| SELECT BU.BUSINESS_UNIT_GL , HDR.BUSINESS_UNIT , HDR.PO_ID , HDR.PO_DT , HDR.PO_REF , HDR.VENDOR_ID FROM PS_PO_HDR hdr , PS_BUS_UNIT_TBL_PM BU , PS_BUS_UNIT_TBL_FS FS WHERE HDR.BUSINESS_UNIT = BU.BUSINESS_UNIT AND BU.BUSINESS_UNIT = FS.BUSINESS_UNIT AND HDR.BUSINESS_UNIT = FS.BUSINESS_UNIT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | BUS_UNIT_ON_BEHALF |
Character(5) | VARCHAR2(5) NOT NULL |
On Behalf Of Business Unit
Default Value: LC_HDR.BUSINESS_UNIT Prompt Table: SP_BU_PM_NONVW |
| 3 | PO_ID |
Character(10) | VARCHAR2(10) NOT NULL |
Purchase Order
Prompt Table: PO_HDR |
| 4 | PO_DT | Date(10) | DATE | Date |
| 5 | PO_REF | Character(30) | VARCHAR2(30) NOT NULL | Specifies the purchase order number associated with a receivables item. |
| 6 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL |
Vendor Identifier
Prompt Table: LC_TR_VNDR_VW |