Process Unit Price Billing Line for Contract Billing Invoice
Source Name:N5200206
Data Structure:D5200206
Function Name:ProcUntPriceBillLineForCBInvoice
System Code:52
Function Category:BAT
Function Use:UPD
Designer:Ira Frosch
Programmer:Falah Thamir
Revisions Log
DateModifications bySAR NumberDescription
2 Aug 99Ira Frosch3303189Creation
1.Functional Description
1.1Purpose
This business function will perform the processing to update/create records for a Unit Price billing line.
1.2Setup Notes and Prerequisites
An F4812 cache should be created before entry into this business function. The Pay Item (Data Dictionary Item SFX) should be pre-determined.
1.3Special Logic
This business function will perform the appropriate calculation for Unit Price lines. The calculation is done in the following way:
1.Retrieve the one account from F5212 for this pay item (Unit Price only allows one cross reference with no wildcards)
2.Retrieve the Actual Units Inception-to-date with subledger and type defined from F5212.
3.Perform Calculation:
a. Current Units = Actual Units Previous Billed Units
b.Current Billing Amt = Current Units * Unit Price
4.Write record to F4812 cache. If a record is not found in F5212, a record will be created in F4812 with zero amount.
Changes from World
a.Allow negative units/amounts
2.Technical Specifications
2.1Parameters:
See attachment to data structure D5200206
2.2Related Tables
Table Table Description
F5212Unit Price Cross Reference
F0901Account Master
F0902Account Balances
2.3Related Business Functions
Source NameFunction Name
X0051Retrieve G/L Balances
N5200200CreateCBDefaultInvoice WorkfileRecord
XX0901Retrieve Account Master
D5200206 - Process Unit Price Billing Line For CB Invoice
D5200206
Process Unit Price Billing Line For Contract Billing Invoice
Parameters:
Data
Item Data Structure I/OReq. Notes
DOCOmnContractNoIY
DCTOszContractDocumentTypeIY
KCOOszContractKeyCoIY
COCHszContractChangeOrderIY
LNIDmnContractLineNoIY
ICUmnBatchNoIY
DTTOjdDateBillThruIYIf zero, the system will use the
current date.
APDTjdApplicationDateIY
DGJjdGeneralLedgerDateIY
DSVJjdServiceDateIY
ERDBcExchangeRateDateBasisIY
ERRCcErrorCodeOblank = no errors
1 = record not found in F5212
2 = error returned by XX0901
3 = error returned by N5200200
DOCZmnInvoiceNoI
DCTIszInvoiceDocumentTypeIY
KCOIszInvoiceKeyCompany IY
SFXszPayItemIYThis is the pay item of the billing
line on the invoice.
CRCDszBaseCurrencyIIf multicurrency is on, this field
is required.
CRCFszForeignCurrencyIIf multicurrency is on, this field
is required.
CRRMcCurrencyModeIIf multicurrency is on, this field
is required. This is the mode from
the contract.
CRRDmnCurrencyRateIIf multicurrency is on, this field
is required. This is the rate
calculated for this date.
AN8OmnCustomerNumberI
UPmnUnitPriceI
FUPmnForeignUnitPriceI
PUHPmnPriorUnitsI
PTHPmnPriorInvTotalAmtI
PATXmnPriorInvTaxableAmtI
DL01szBillingLineDescriptI
OPIMszBillingLineI
PRTPcBillingLineTypeI
COszCompanyIY
MCUSszProjectNoIRequired for Default Invoice record.
Should be from F5202 table.
EXR1szTaxExplanationCodeI
TXA1szTaxRateAreaI
PCTNmnParentContractNoI
PCTTszParentContractTypeI
PCKOszParentContractKeyCoI
JMCUszHostBusinessUnitIYUsed to determine the RP12 from the Business Unit Master.
(From F5201)
ACCOcAccountOverIDetermines whether to set override
revenue account
MCUszBusinessUnitIYBusiness Unit from F5202
OBJszObjectINeeded only for override revenue account
SUBszSubsidiary INeeded only for override revenue account
SBLszSubledgerI
SBLTcSubledgerTypeI
EV01cVertexActiveIRequired for Vertex
JOBSmnVertexJobNumberIRequired for Vertex
TBDTjdTableBasisDateIY
PTCszPaymentTermsI
UMszUnitOfMeasureI
PIDszCallingProgramIDI
UmnUnitsO
AAmnCostAmtO
ITOLmnInvoiceTotalAmtO
ITAMmnInvoiceTaxAmtO
ITXAmnInvoiceTaxableAmtO
JTAXmnJournaledTaxO
IDSCmnDiscountAmtO
AA2mnCostAmtFO
CITLmnForInvTotalAmtO
CITXmnForInvTaxAmtO
CITAmnForInvTaxableAmtO
JTXFmnForJrnlTaxAmtO
CIDSmnForInvDiscountAmtO
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
mnContractNo | DOCO | MATH_NUMERIC | REQ | INPUT |
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 | REQ | INPUT |
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 | REQ | INPUT |
A number that, along with order number and order type, uniquely identifies an order document (such as a purchase order, a contract, a
| ||||
szContractChangeOrder | COCH | char | REQ | INPUT |
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 | REQ | INPUT |
A number that identifies multiple occurrences, such as line numbers on a purchase order or other document. Generally, the system assigns
| ||||
mnBatchNo | ICU | MATH_NUMERIC | REQ | INPUT |
A number that identifies a group of transactions that the system processes and balances as a unit. When you enter a batch, you can either
| ||||
jdDateBillThru | DTTO | JDEDATE | REQ | INPUT |
The ending date for which the transaction or code is applicable. | ||||
jdApplicatnDate | APDT | JDEDATE | REQ | INPUT |
The date of the last or current application. (An application is assigned each time an invoice is issued for the contract.) | ||||
jdGeneralLedgerDate | DGJ | JDEDATE | REQ | INPUT |
A date that identifies the financial period to which the transaction will be posted. You define financial periods for a date pattern code that you
| ||||
jdServiceDate | DSVJ | JDEDATE | REQ | INPUT |
A date that indicates when you purchased goods or services, or when you incurred a tax liability. | ||||
cExchangeRateDateBasis | ERDB | char | REQ | INPUT |
A code that controls which date the system uses to retrieve the exchange rate for the invoice. Valid values are:
1
Use the invoice date
| ||||
cErrorCode | ERRC | char | OPT | OUTPUT |
This error code indicates if any errors occurred during the creation of the Trip Document Detail (F4914) records by the Delivery Document
| ||||
mnInvoiceNo | DOCZ | MATH_NUMERIC | OPT | INPUT |
The original document number. This can be a voucher, an invoice, unapplied cash, a journal entry number, etc. Matching document
| ||||
szInvoiceDocumentType | DCTI | char | REQ | INPUT |
A user defined (00/DI) document type for invoice entry. Any document type set up for invoice-only entry should begin with the letter R
| ||||
szInvoiceKeyCompany | KCOI | char | REQ | INPUT |
Invoice Document Company. | ||||
szPayItem | SFX | char | REQ | INPUT |
A number that identifies the pay item for a voucher or an invoice. The system assigns the pay item number. If the voucher or invoice has
| ||||
szBaseCurrency | CRCD | char | OPT | INPUT |
A code that identifies the currency of a transaction. | ||||
szForeignCurrency | CRCF | char | OPT | INPUT |
The currency code of the insured amount. | ||||
cCurrencyMode | CRRM | char | OPT | INPUT |
An option that specifies whether the system displays amounts in the domestic or foreign currency.
On
The system displays amounts in the
| ||||
mnCurrencyRate | CRRD | MATH_NUMERIC | OPT | INPUT |
A number (exchange rate) that a foreign currency amount is divided by to calculate a domestic currency amount. The number you enter in
| ||||
mnUnitPrice | UP | MATH_NUMERIC | OPT | BOTH |
The list or base price you charge for one primary or pricing unit of this item. | ||||
mnForeignUnitPrice | FUP | MATH_NUMERIC | OPT | BOTH |
The foreign price per unit. | ||||
mnPriorUnits | PUHP | MATH_NUMERIC | OPT | INPUT |
The units previously billed this period for the line item on the contract. | ||||
mnPriorInvTotalAmt | PTHP | MATH_NUMERIC | OPT | INPUT |
The amount previously billed this period for the line item on the contract. | ||||
mnPriorInvTaxableAmt | PATX | MATH_NUMERIC | OPT | INPUT |
szBillingLineDescription | DL01 | char | OPT | INPUT |
A user defined name or remark. | ||||
szBillingLine | OPIM | char | OPT | INPUT |
The pay item number as defined by the owner. This field is alphanumeric and can be up to 15 characters in length. It is recommended that
| ||||
cBillingLineType | PRTP | char | OPT | INPUT |
A code that specifies the billing terms that are defined by the billing line on the contract. The system uses the predefined codes for the
| ||||
szProjectNo | MCUS | char | OPT | INPUT |
Either a subsequent business unit or a project number.
A subsequent business unit specifies where to charge costs (or revenues) when the
| ||||
szTaxExplanationCode | EXR1 | char | OPT | INPUT |
A hard-coded user defined code (00/EX) that controls the algorithm that the system uses to calculate tax and G/L distribution amounts. The
| ||||
szTaxRateArea | TXA1 | char | OPT | INPUT |
A code that identifies a tax or geographic area that has common tax rates and tax authorities. The system validates the code you enter
| ||||
mnParentContractNo | PCTN | MATH_NUMERIC | OPT | INPUT |
The parent contract number to which this particular contract is attached. | ||||
szParentContractType | PCTT | char | OPT | INPUT |
The parent contract type to which this particular contract is attached. | ||||
szParentContractKeyCo | PCKO | char | OPT | INPUT |
Parent Contract Document Company. | ||||
szHostBusinessUnit | JMCU | char | REQ | INPUT |
The Business Unit responsible for the job. This is particularly useful during transfer pricing. | ||||
cAccountOver | ACCO | char | OPT | INPUT |
An option that specifies whether the account information for a billing line identifies a revenue or cost (source) account. The system
| ||||
szBusinessUnit | MCU | char | REQ | INPUT |
An alphanumeric code that identifies a separate entity within a business for which you want to track costs. For example, a business unit
| ||||
szObject | OBJ | char | OPT | INPUT |
The portion of a general ledger account that refers to the division of the Cost Code (for example, labor, materials, and equipment) into
| ||||
szSubsidiary | SUB | char | OPT | INPUT |
A subset of an object account. Subsidiary accounts include detailed records of the accounting activity for an object account. | ||||
szSubledger | SBL | char | OPT | INPUT |
A code that identifies a detailed, auxiliary account within a general ledger account. A subledger can be an equipment item number or an
| ||||
cSubledgerType | SBLT | char | OPT | INPUT |
A user defined code (00/ST) that is used with the Subledger field to identify the subledger type and how the system performs subledger
| ||||
cVertexActive | EV01 | char | OPT | INPUT |
An option that specifies the type of processing for an event. | ||||
mnVertexJobNumber | JOBS | MATH_NUMERIC | OPT | INPUT |
The job number (work station ID) which executed the particular job. | ||||
mnUnits | U | MATH_NUMERIC | OPT | OUTPUT |
The quantity of something that is identified by a unit of measure. For example, it can be the number of barrels, boxes, cubic yards, gallons,
| ||||
mnCostAmt | AA | MATH_NUMERIC | OPT | OUTPUT |
A number that identifies the amount that the system will add to the account balance of the associated account number. Enter credits with a
| ||||
mnInvoiceTotalAmt | ITOL | MATH_NUMERIC | OPT | OUTPUT |
The invoice amount for a billing detail transaction. | ||||
mnInvoiceTaxAmt | ITAM | MATH_NUMERIC | OPT | OUTPUT |
The tax amount in the invoice. This can be either the sales, use or VAT tax. | ||||
mnInvoiceTaxableAmt | ITXA | MATH_NUMERIC | OPT | OUTPUT |
The portion of the invoice amount that is subject to tax. | ||||
mnJournaledTax | JTAX | MATH_NUMERIC | OPT | OUTPUT |
The portion of the tax amount calculated for this entry that is not automatically generated by the post program. | ||||
mnDiscountAmt | IDSC | MATH_NUMERIC | OPT | OUTPUT |
The amount of the discount available, as opposed to the amount of the discount actually taken. The discount calculated is based on the
| ||||
mnCostAmtF | AA2 | MATH_NUMERIC | OPT | OUTPUT |
Amount. | ||||
mnForInvTotalAmt | CITL | MATH_NUMERIC | OPT | OUTPUT |
The total amount of the invoice in foreign currency. | ||||
mnForInvTaxAmt | CITX | MATH_NUMERIC | OPT | OUTPUT |
The tax amount on the invoice in foreign currency. This can be either the sales, use or VAT tax. | ||||
mnForInvTaxableAmt | CITA | MATH_NUMERIC | OPT | OUTPUT |
The portion of the foreign invoice amount that is subject to tax. | ||||
mnForJrnlTaxAmt | JTXF | MATH_NUMERIC | OPT | OUTPUT |
The portion of the tax amount calculated for this entry that is not automatically generated by the post program. | ||||
mnForInvDiscountAmt | CIDS | MATH_NUMERIC | OPT | OUTPUT |
The foreign currency amount of the discount available, as opposed to the amount of the discount actually taken. The discount calculated is
| ||||
szCompany | CO | char | REQ | INPUT |
A code that identifies a specific organization, fund, or other reporting entity. The company code must already exist in the Company
| ||||
jdTableBasisDate | TBDT | JDEDATE | REQ | INPUT |
This date is used as the basis for comparison to the effective dates of the various tables used by the Service Billing system. This date is
| ||||
szCallingProgramId | PID | char | OPT | INPUT |
The number that identifies the batch or interactive program (batch or interactive object). For example, the number of the Sales Order Entry
| ||||
mnCustomerNumber | AN8O | MATH_NUMERIC | OPT | INPUT |
The address book number to which the system posts billing and accounts receivable transactions. | ||||
szPaymentTerms | PTC | char | OPT | INPUT |
A code that specifies the terms of payment, including the percentage of discount available if the invoice is paid by the discount due date.
| ||||
szUnitOfMeasure | UM | char | OPT | INPUT |
A user defined code (00/UM) that identifies the unit of measurement for an amount or quantity. For example, it can represent a barrel, box,
| ||||
szGlClass | GLC | char | OPT | INPUT |
A code that determines the trade account that the system uses as the offset when you post invoices or vouchers. The system concatenates
| ||||
szGlOffsetRetention | RGLC | char | OPT | INPUT |
A code that designates the offset accounts for retainage, for example RETN or 1225. You set up the code as an automatic accounting
| ||||
szVertexTransactionType | VVTY | char | OPT | INPUT |
Vertex Sales and Use Tax transaction type. | ||||
szVertexProductCategory | VVTC | char | OPT | INPUT |
User defined code used in the Vertex Tax Decision Maker for products or services that are non-taxable or are at a non-stanard rate. | ||||
mnNTECacheJobNo | JOBS | MATH_NUMERIC | OPT | BOTH |
The job number (work station ID) which executed the particular job. | ||||
cNTEAmtExceedFlag | EV01 | char | OPT | OUTPUT |
An option that specifies the type of processing for an event. | ||||
cNTELevelExceedFlag | EV01 | char | OPT | OUTPUT |
An option that specifies the type of processing for an event. |
None |
None |