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.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related searches
- mortgage remaining balance payoff calc
- common core vocabulary by grade
- excel remaining balance formula
- ct home daycare licensing
- remaining balance calculator
- mortgage remaining balance payoff calculator
- step by step balance sheet
- balance home exercise program pdf
- balance home exercise program
- at home balance exercises pdf
- balance ball core workouts
- ct dmv return license plates by mail