Adjust F4822 Subsequent Invoices
Source Name:N5200202
Data Structure: D5200202
Function Name:AdjustF4822SubsequentInvoices
System Code:52 Contract Billing
Function Category:BAT
Function Use:UPD
Designer:Ira Frosch
Programmer:Ira Frosch
Revisions Log
Date Modified bySAR NumberDescription
4 Aug 99Ira Frosch3231605Creation
1.Functional Description
1.1Purpose
This business function adjusts all F4822 records after the specified application and adjustment
number with an updated amount.
1.2Setup Notes and Prerequisites
The application number and adjustment number must be inputted.
1.3Special Logic
This routine needs to do the following steps in order:
1.Select all F4822 for this billing line where the application number is equal to or greater than
the parameter
2.Fetch Next F4822
3.If the application number is equal to the parameter and the adjustment number is less than or
equal to the adjustment number parameter, skip updating (as it will have no effect).
4.Update the Prior Units and all prior amounts fields (Foreign and Domestic) with the input
parameters
5.Update the F4822 record
6.Repeat steps 2-5 until End of Table
2.Technical Specifications
2.1Parameters:
See attachment of D5200202.
2.2Related Tables
Table Table Description
F4822Invoice Summary Work File
2.3Related Business Functions
Source NameFunction Name
GetAuditInformation
2.4Processing
//
F4822.Open
//
// Select all valid records for update
//
F4822.Select (DOCO,DCTO,KCOO,COCH,LNID, APPL >= BF mnApplicationNo)
//
// Loop over records until found
//
Do while evt_cF4822Status = evt_cOK
//
// Insure that application number is greater than input, or if the same, the adjustment no is greater
//
If evt_mnApplicationNo > BF mnApplicationNo
evt_F4822PriorUnits = evt_F4822PriorUnits + BF mnPriorUnits
F4822.Close
D5200202 - Adjust F4822 Subsequent Invoices
D5200202
Adjust F4822 Subsequent Invoices
Parameters:
Data
Item Data Structure DescriptionI/ORequiredNotes
PIDszCallingProgramIDIY
DOCOmnContractNoIY
DCTOszContractDocumentTypeIY
KCOOszContractKeyCoIY
COCHszContractChangeOrderIY
LNIDmnContractLineNoIY
APPLmnApplicationNoIY
ADJNmnAdjustmentNoIY
PUHPmnPriorUnitsIY
PTHPmnPriorThisPeriodIY
PATXmnPriorInvoiceTaxableIY
PTAMmnPriorInvTaxAmtIY
PSMAmnPriorMiscInvIY
RTNPmnPriorRetainageIY
SMRPmnPriorMiscRetAmtIY
FTHPmnForPriorThisPeriodIY
FATXmnForPriorInvTaxableIY
FPTAmnForPriorInvTaxAmtIY
FSMAmnForPriorMiscInvIY
FTNGmnForPriorRetainageIY
SMRFmnForPriorMiscRetAmtIY
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
szCallingProgramId | PID | char | OPT | NONE |
The number that identifies the batch or interactive program (batch or interactive object). For example, the number of the Sales Order Entry
| ||||
mnContractNo | DOCO | MATH_NUMERIC | OPT | NONE |
A number that identifies an original document. This document can be a voucher, a sales order, an invoice, unapplied cash, a journal entry,
| ||||
szContractDocumentType | DCTO | char | OPT | NONE |
A user defined code (00/DT) that identifies the type of document. This code also indicates the origin of the transaction. J.D. Edwards has
| ||||
szContractKeyCo | KCOO | char | OPT | NONE |
A number that, along with order number and order type, uniquely identifies an order document (such as a purchase order, a contract, a
| ||||
szContractChgOrder | COCH | char | OPT | NONE |
The change number of the contract. The change order number of the base contract is always initialized to 000. Each time you enter a
| ||||
mnContractLineNo | LNID | MATH_NUMERIC | OPT | NONE |
A number that identifies multiple occurrences, such as line numbers on a purchase order or other document. Generally, the system assigns
| ||||
mnApplicationNo | APPL | MATH_NUMERIC | OPT | NONE |
The last or current application number for the specified contract. (The system assigns a new application number each time an invoice is
| ||||
mnAdjustmentNo | ADJN | MATH_NUMERIC | OPT | NONE |
A number used to control changes to closed applications. Closed applications represent invoices that have been sent. This number is
| ||||
mnPriorUnits | PUHP | MATH_NUMERIC | OPT | NONE |
The units previously billed this period for the line item on the contract. | ||||
mnPriorInvTotalAmt | PTHP | MATH_NUMERIC | OPT | NONE |
| ||||
mnPriorInvTaxableAmt | PATX | MATH_NUMERIC | OPT | NONE |
| ||||
mnPriorStoredMatInvAmt | PSMA | MATH_NUMERIC | OPT | NONE |
The amount previously billed for Stored Material for the line item on the contract. | ||||
mnPriorRetAmt | RTNP | MATH_NUMERIC | OPT | NONE |
Retainage Amount through the last application or adjustment for a specific contract. | ||||
mnForPriorInvTotalAmt | FTHP | MATH_NUMERIC | OPT | NONE |
| ||||
mnForPriorInvTaxableAmt | FATX | MATH_NUMERIC | OPT | NONE |
| ||||
mnForPriorStoredMatInvAmt | FSMA | MATH_NUMERIC | OPT | NONE |
The amount previously billed for Stored Material for the line item on the contract. | ||||
mnForPriorRetAmt | FTNG | MATH_NUMERIC | OPT | NONE |
xThis field is the retained dollars for a contract line. | ||||
mnPriorInvTaxAmt | PTAM | MATH_NUMERIC | OPT | NONE |
The tax amount previously billed for the billing line on the contract. | ||||
mnPriorStoredMatRetAmt | SMRP | MATH_NUMERIC | OPT | NONE |
The prior retained amount for the stored materials. | ||||
mnForPriorInvTaxAmt | FPTA | MATH_NUMERIC | OPT | NONE |
The foreign tax amount previously billed for the billing line on the contract. | ||||
mnForPriorStoredMatRetAmt | SMPF | MATH_NUMERIC | OPT | NONE |
None |
None |