CT_CORE_FIN_SAAAS_OPTION16_5_8

Purpose of Query

SAAAS Option 16, 5-8- This is designed to closely approximate the functionality of the legacy SAAAS option 16, 5, 8 report.

Folder

AP

Tables

CTW_VCHR_TRANS - Voucher Transactions Rpt Tbl

Prompts

BUSINESS_UNIT - Business Unit (%) – (Wildcard enabled)

DEPTID - DeptID (%) – (Wildcard enabled)

FUND_CODE - Fund (%) – (Wildcard enabled)

CT_SID - SID (%) – (Wildcard enabled)

ACCOUNT - Account (%) – (Wildcard enabled)

ACCOUNTING_DT - From Accounting Date / ACCOUNTING_DT - To Accounting Date – (Between condition)

Criteria

A.POST_STATUS_AP - Post Status equal to P - (Posted)

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.VOUCHER_ID - Voucher ID / Char8 / Voucher
3 / A.VENDOR_ID - Vendor ID / Char10 / Vendor
4 / A.CT_VNDR_NAME1 - Vendor Name 1 / Char40 / 1 / Vendor Name 1
5 / A.VOUCHER_LINE_NUM - Voucher Line Number / Num5.0 / Line
6 / A.ENTERED_DT - Entered on / Date / 2 / Entered
7 / A.ACCOUNTING_DT - Accounting Date / Date / Acctg/Receipt Date
8 / A.MONETARY_AMOUNT - Monetary Amount / SNm25.3 / Amount
9 / A.PO_ID - Purchase Order / Char10 / PO
10 / A.LINE_NBR - Line Number / Num5.0 / Line
11 / A.INVOICE_DT - Invoice Date / Date / Date
12 / A.INVOICE_ID - Invoice Number / Char30 / Invoice
13 / A.ACCOUNT - Account / Char10 / Acct
14 / A.DEPTID - Department / Char10 / DeptID
15 / A.FUND_CODE - Fund Code / Char5 / Fund
16 / A.CT_SID - SID / Char5 / SID
17 / A.PROGRAM_CODE - Program Code / Char5 / Program
18 / A.BUDGET_REF - Budget Reference / Char8 / Bud Ref
19 / A.PROJECT_ID - Project / Char15 / Project