Related Topics

Comp Tax Generated Invoice Report

Contents

1 Overview

2 Sample Report

3 How-to

4 Fields

5 Selection Criteria

6 Tables Diagram

 

4 Fields

Field Name

Path to data field

Table/ field ID

Invoice Status 1

Financial Management / A/P / Invoices / (Select invoice) +Add or Edit

FFAPIM-INVOICE-MST.STATUS

Cash Account Code 2

System Admin / PAC Finance / Config / Accounts Receivable / Bank (Unapplied Cash Account)

FFAPIM-INVOICE-MST.FFAMB-T-CODE

Generated Invoice Vendor Name Key 3

Assigned by the system and not updateable. The system assigns a  new name key if the vendor name is updated/changed: Financial Management / A/P / Invoices / (Select invoice) +Add or Edit

FFAPIM-INVOICE-MST.NALPHAKEY

Generated Invoice Vendor Name 4

Financial Management / A/P / Invoices / (Select invoice) +Add or Edit / Vendor

NAME-TYPE.FULL-NAME-LFM

Generated Invoice Number 5

Financial Management / A/P / Invoices / (Select invoice) +Add or Edit

FFAPIM-INVOICE-MST.FFAPIM-INV-NBR

Invoice Amount 6

Financial Management / A/P / Invoices / (Select invoice) +Add or Edit

FFAPIM-INVOICE-MST.FFAPIM-INV-DATE

Generated Invoice Amount 7

 

Financial Management / A/P / Invoices / (Select invoice) +Add or Edit

 

FFAPIM-INVOICE-MST.FFAPIM-AMT

Vendor Key for Associated Vendor Invoice 8

Assigned by the system and not updateable. The system assigns a  new name key if the vendor name is updated/changed: Financial Management / A/P / Invoices / (Select invoice) +Add or Edit

FFAPIM-INVOICE-MST.NALPHAKEY

Vendor Name for Associated Vendor Invoice 9

Financial Management / A/P / Invoices / (Select invoice) +Add or Edit / Vendor

NAME-TYPE.FULL-NAME-LFM

Invoice Number for Associated Vendor Invoice 10

Financial Management / A/P / Invoices / (Select invoice) +Add or Edit /Vendor

FFAPIM-INVOICE-MST.FFAPIM-INV-NBR

Invoice Date for Associated Vendor Invoice 11

Financial Management / A/P / Invoices / (Select invoice) +Add or Edit

FFAPIM-INVOICE-MST.FFAPIM-INV-DATE

Comp Tax Amount 12

Financial Management / A/P / Invoices / (Select invoice) +Add or Edit / Check Comp Tax / Show Comp Tax

FFAPIA-INVOICE-ACCTS-WA-FFAPIA-SALES-TAX

Page Updated 2/04

Top