Files > INVOICE TRACKING

name
INVOICE TRACKING
number
421.5
location
^PRCF(421.5,
description
This file is used to record payment invoices which require Control Point sign-off.
Fields
#NameLocationTypeDetailsIndexDescription
.01id number(+)0;1NUMERICBThis is the ID number of certified invoices.
.4station number1;2FREE TEXTThis is the station number of the service generating the invoice.
.5document locator number(+)0;2FREE TEXTThis is the system generated number for tracking purposes at Austin.
.6certification required?(+)0;27BOOLEAN0:NO
1:YES
This field indicates whether service certification is required for this invoice.
1invoice/bill number(+)0;3FREE TEXTThis is the invoice/bill number assigned by the vendor.
2date of invoice(+)0;4DATE-TIMEThis is the date of the vendor invoice.
3date invoice received(+)0;5DATE-TIMEThis is the date the invoice was received in Fiscal Service.
4prompt pay type(+)0;6SET OF CODESA:NORMAL
C:CONTRACT
D:DAIRY
E:EXEMPT
I:FEE WITH INTEREST
M:MEAT
N:FEE WITH NO INTEREST
O:OLDER PAYMENT
P:PRODUCE
R:RECURRING PAYMENTS
V:PRIME VENDORS
X:PAY IMMEDIATE IFCAP
Z:PRE PROMPT PAY ORDERS
This field indicates the prompt pay type of the invoice.
4.5purchase order number(+)1;3FREE TEXTThis is the IFCAP PO number in expanded form, i.e. 503-A10001.
5purchase order pointer0;7POINTER442EThis is the pointer to the Procurement and Accounting Transactions file, #442.
6vendor0;8POINTER440CThis is the name of the vendor generating the invoice.
7vendor stub name0;9FREE TEXTThis is the CALM stub name.
8vendor id number0;10FREE TEXTThis is the CALM ID number.
9discount percent0;11NUMERICThis is the percentage to be deducted from the invoice when prompt payment is made.
10discount days0;12NUMERICThis is the number of days in which a discount can be taken.
11discount terms0;13SET OF CODESE:EOM
P:PROX
X:STANDARD
These are the terms defining the discount amount/days (i.e., net-30).
11.3discount amount0;26NUMERICThis is the dollar amount of the discount.
11.5date goods/service received(+)0;21DATE-TIMEThis is the date the items were received at the station.
12approved shipping amount0;14NUMERICThis is the amount authorized for shipping charges.
13amount certified for payment(+)0;15NUMERICThis is the amount certified for payment.
14liquidation code0;16SET OF CODESP:PARTIAL
C:COMPLETE
This field indicates the status of liquidation, whether partial or complete.
15subaccount 10;17POINTER420.2This is the subaccount being charged.
16subaccount 20;18POINTER420.2This is the second subaccount being charged.
17liquidation amount 10;19NUMERICThis is the amount liquidated for subaccount 1.
18liquidation amount 20;20NUMERICThis is the amount liquidated for subaccount 2.
19money management indicator(+)0;22SET OF CODESX:EXEMPT - PAY IMMEDIATELY
B:NOT EXEMPT - DELAY PAYMENT FOR MONEY MANAGEMENT
This field indicates when payment is to be made.
20interest indicator(+)0;23SET OF CODESX:INTEREST & PAYMENT
I:INTEREST ONLY
P:PAYMENT ONLY
This field indicates the type of payment to be made.
21payment to be sent to: 0;24SET OF CODES0:CAPPS
1:CALM
This field indicates the system in Austin to which payment is to be sent.
22date payment released0;25DATE-TIMEThis is the date payment is released from CALM.
23reason for suspension4;0WORD-PROCESSINGThis is the reason for suspending payment.
24date of suspension letter1;4DATE-TIMEThis is the date when the suspense letter is sent to the vendor.
25suspension letter required?1;5BOOLEAN0:NO
1:YES
Indicates whether suspension of payment is required.
26partial number1;6FREE TEXTThis is a two-character alphanumeric field which is appended to the Purchase Order number before it is transmitted to FMS. This expanded number then becomes the Document ID Number for the Payment Voucher (PV) as it is processed by FMS. There are 974 valid alphanumeric codes for the Partial Number.
27fms payment voucher #1;7FREE TEXTFThis is the 11-character Document ID Number given to the Payment Voucher (PV) as it is being transmitted to FMS. This number provides the primary lookup for the local copy of the PV in the Generic Code Sheet Stack File. The normal format for the Payment Voucher # is SSSAFNNNNPP where SSS is the Station Number A is an alphabetic code identifying the Common Numbering Series F is the last digit of the Fiscal Year NNNN is the document sequence number within the series PP is the alphanumeric Partial Number assigned by IFCAP.
30one time payment?1;1BOOLEAN0:NO
1:YES
This field indicates a one time payment.
31prompt payment terms6;0MULTIPLE421.531This is a multiple field which contains the payment terms for this invoice.
37gross amount of invoice(+)1;8NUMERICThis is the total amount of the invoice.
38gross shipping1;9NUMERICThis is the gross amount of shipping charges.
39net days1;10NUMERICThis is the number of days when net payment is due.
41fms line5;0MULTIPLE421.541This is a multiple field which contains a set of accounting data associated with the FMS accounting line.
45memo 11;16FREE TEXTReserved for use by Austin.
46memo 21;17FREE TEXTReserved for use by Austin.
47memo 31;18FREE TEXTReserved for use by Austin.
50status2;1SET OF CODES0:Incomplete
3:Invoice Returned to Vendor
5:Pending Service Certification
10:Awaiting Voucher Audit Review
11:Vendor ID Incomplete
15:In Accounting
20:Transaction Complete
AEThis is the status indicator of invoice for processing.
51po suffix2;2FREE TEXTThis is the suffix number assigned by Fiscal for tracking purposes.
52expanded po number2;3FREE TEXTDIFCAP PO number to include suffix, i.e. 503-A10001-0001.
53current invoice location2;4FREE TEXTIndicates service which currently has invoice for certification.
54d/t charged to current loc2;5DATE-TIMEThis is the date/time the invoice was sent to the service.
54.5charged to current location by2;17POINTER200This is the person charging the invoice to the service.
55discount payment date2;6DATE-TIMEDate payment is to be made by in order to receive payment.
56net payment date2;7DATE-TIMEDate payment is to be made to avoid penalties.
57date due in fiscal2;8DATE-TIMEACDate invoice is due in Fiscal.
58date returned to fiscal2;9DATE-TIMEDate invoice was returned to Fiscal.
59certified for payment by2;10POINTER200Person certifying invoice is true and correct for payment.
60completed in accounting by2;11POINTER200This is the Accounting technician completing the invoice.
61certified by validation code2;12FREE TEXTElectronic signature of certifying official.
61.5certified by validation ver2.1;1NUMERICThis is the version number of the algorithms used for encoding and decoding the Validation Code created for the Payment/Invoice Tracking record at the time that the certification of the invoice is entered into the system.
61.7certified by esig code2.1;2FREE TEXTEncoded value used by IFCAP security utilities when confirming the integrity of this record.
61.9certified by sig date/time2.1;5DATE-TIMEAFThis is the date and time that a valid electronic signature was entered certifying an invoice for payment.
62completed by validation code2;13FREE TEXTElectronic signature of completing technician.
62.5completed by validation ver2.1;3NUMERICThis is the version number of the algorithms used to encode and decode the Validation Code for the Payment/Invoice Tracking record at the time that the technician who completes the record enters their valid electronic signature into the system.
62.7completed by esig code2.1;4FREE TEXTEncoded value used by IFCAP security utilities when confirming the integrity of this record.
62.9completed by sig date/time2.1;6DATE-TIMEThis is the date and time that the person completing the details of a Payment/Invoice Tracking record entered a valid electronic signature.
63bulletin sent to service2;14BOOLEAN0:NO
1:YES
Indicates if overdue bulletin sent to certifying service.
64date bulletin sent2;15DATE-TIMEDate bulletin sent to certifying service.
65message number2;16POINTER3.9This is the MailMan message number of overdue bulletin.
66control point certified by2;18POINTER200This field identifies the control point officer or clerk who certifies that the invoice is true and correct for payment.
67control point validation code2;19FREE TEXTElectronic signature of certifying control point officer or clerk.
67.5control point validation ver2.1;7NUMERICThis is the version number of the algorithms used to encode and decode the Validation Code for the Payment/Invoice Tracking record at the time that the control point officer or clerk who certifies the record enters their valid electronic signature into the system.
67.7control point esig code2.1;8FREE TEXTEncoded value used by IFCAP security utilities when confirming the integrity of this record.
67.9control point sig date/time2.1;9DATE-TIMEThis is the date and time that a valid electronic signature was entered by a control point officer or clerk certifying an invoice for payment.
68certifying control point1;11FREE TEXTThis is the control point to which the invoice is referred for certification, as indicated by the obligation document.
70certifying service3;0MULTIPLE421.51Services which are required to certify invoice as true and correct.
71fms transaction date1;19DATE-TIMEThe value in the FMS Transaction Date field determines when the Payment Voucher will be transmitted to FMS by the Generic Code Sheet module. With the new Hold Code Sheet functionality, Obligations may be entered to take effect in the future. This field will enable the user to ensure that the Payment Voucher does not arrive at FMS before its Obligation documents.
72accounting period month/year1;20DATE-TIMEEnter the calendar month and year of the accounting period you would like this Payment Voucher (PV) transaction to affect in FMS. Note: For the PV to be accepted by FMS, the value must be an Accounting Period, which is open at the time of receipt. For ease of data entry, this field stores Calendar Month and Calendar Year. During transmission to FMS, this value is converted to Fiscal Year and the Sequence number of that month within that Fiscal Year before being placed in the transmission record. (i.e. Oct 1994 is converted to fiscal year 95 and month 01.)

Not Referenced