Remaining PO Balance by PO - Core-CT - Home



CT_CORE_FIN_PO_BAL_SUM_BY_PO

Purpose of Query

Remaining PO Balance by PO - This query will return purchase order balances and voucher sums for vouchers that are posted, over applied, or partially applied to a purchase order or group of purchase orders.

Folder

PO

Tables

A CTW_PO_TRANS - PO Transaction Reportng Tbl

Join B CTW_VCHR_TRANS - Voucher Transactions Rpt Tbl

Note: A JOIN is an SQL command that is used to relate two or more data tables (Records in PeopleSoft) based on the use of related (key) fields from one table to the next. Once joined, data can be retrieved without repeating all of the data in every table.

Prompts

BUSINESS_UNIT - PO Business Unit – (Equal To)

PO_ID - PO ID (%) - Wildcard enabled)

ACCOUNTING_DATE – Accounting Date (Between condition)

[pic]

Criteria

B.POST_STATUS_AP - Post Status in list ('P','S','O') - (Posted, Partial Application, Over Application)

A.PO_STATUS - PO Status not in list ('C','X') – (Complete, Cancelled)

A.DISTRIB_LN_STATUS - Distribution Line Status not in list ('C','X') – (Complete, Cancelled)

Note: Runtime prompts are included as criteria.

Fields

|Col |Record.Fieldname |Format |Ord |XLAT |Agg |Heading Text |

|1 |A.BUSINESS_UNIT - Business Unit |Char5 | | | |Unit |

|2 |A.PO_ID - Purchase Order |Char10 | | | |PO ID |

|3 |A.PO_DT - Purchase Order Date |Date | | | |PO Date |

|4 |A.VENDOR_ID - Vendor ID |Char10 | | | |Vendor |

|5 |A.CT_VNDR_NAME1 - Vendor Name 1 |Char40 | | | |Vendor Name 1 |

|6 |A.MERCHANDISE_AMOUNT - Merchandise Amount |SNm25.3 | | | |PO Amount |

|7 |B.MONETARY_AMOUNT - Monetary Amount |SNm25.3 | | |Sum |Voucher Amount |

|8 |A.CT_OBLIGATED_AMT - Applied Amount |SNm25.3 |  |  |  |Obligated Amount |

|9 |A.ENTERED_DT - Entered on |Date |  |  |  |Obligation Entered Date |

|10 |B.ACCOUNTING_DATE – Accounting Date |Date | | | |Acctg Date |

|11 |A.CT_SID - SID |Char5 |  |  |  |SID |

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download