D48S0200 - Calculate Billing Amounts
Parameters Usage
The following fields need to be passed in only when calling the this function for Invoice Generation
(cAdhocFlag = '2'):
mnInvoiceTaxAmount
mnInvoiceDiscountAmount
mnJournaledTaxAmount
mnForeignCostAmount
mnForeignRevenueAmount
mnForeignInvoiceAmount
mnForeignInvoiceTaxableAmount
mnForiegnInvoiceTaxAmount
mnForeignInvoiceDiscountAmount
mnForiegnjournaledTaxAmount
mnExchangeRate
'2':
jdExchangeRateDate = G/L Date (DGL)
jdTableBasisDate = Invoice Date (APDT)
^
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
mnUnits | U | MATH_NUMERIC | OPT | INPUT |
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,
| ||||
mnCostAmount | AA | MATH_NUMERIC | REQ | BOTH |
A number that identifies the amount that the system will add to the account balance of the associated account number. Enter credits with a
| ||||
szTaxExplanationCode | EXR1 | char | REQ | 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 | REQ | 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
| ||||
szPaymentTerms | TRAR | char | REQ | INPUT |
A code that indicates the default payment terms for a customer. Payment terms determine the due date, discount amount, and discount due
| ||||
cTaxableYNFlag | TX | char | OPT | BOTH |
A code that indicates whether the item is subject to sales tax when you purchase it. The system calculates tax on the item only if the supplier
| ||||
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
| ||||
szDomesticCurrencyCode | CRCD | char | REQ | INPUT |
A code that identifies the currency of a transaction. | ||||
szForeignCurrencyCode | CRCF | char | REQ | INPUT |
The currency code of the insured amount. | ||||
cCurrencyModeSystem | CRRM | char | REQ | INPUT |
An option that specifies whether the system displays amounts in the domestic or foreign currency.
On
The system displays amounts in the
| ||||
mnInvoiceMarkupOverrideRate | BRTI | MATH_NUMERIC | OPT | BOTH |
A rate that the system uses to mark up the invoice amount reflected in the billing of professional services workers such as draftsmen,
| ||||
cInvoiceMarkupCapFlag | CAPI | char | OPT | INPUT |
A flag to indicate if the associated amount is the override rate or the cap of the rate. | ||||
mnInvoiceMarkupAmount | ADCI | MATH_NUMERIC | OPT | BOTH |
An amount that the system uses to mark up the invoice amount for the billing of professional services, such as the services of draftsmen,
| ||||
mnInvoiceMarkupPercentage | PCIM | MATH_NUMERIC | OPT | INPUT |
A number that specifies the percentage that the system uses to mark up the revenue amount reflected in the billing of professional services,
| ||||
mnRevenueMarkupOverrideRate | BRT | MATH_NUMERIC | OPT | BOTH |
A rate that the system uses to mark up the revenue amount reflected in the billing of professional services such as draftsmen, engineers, or
| ||||
cRevenueMarkupCapFlag | CAP | char | OPT | INPUT |
This flag indicates whether the associated amount is the override rate or the cap of the rate.
Values are:
blank Override Rate.
1 Cap of
| ||||
mnRevenueMarkupAmount | ADCR | MATH_NUMERIC | OPT | BOTH |
An amount that the system uses to mark up the revenue amount for the billing of professional services, such as the services of draftsmen,
| ||||
mnRevenueMarkupPercentage | PERT | MATH_NUMERIC | OPT | INPUT |
The percentage that you use to mark up the revenue amount reflected in the billing of professional services workers, such as draftsmen,
| ||||
cBurdenFlag | EV01 | char | OPT | INPUT |
An option that specifies the type of processing for an event. | ||||
cAdhocFlag | EV01 | char | OPT | INPUT |
An option that specifies the type of processing for an event. | ||||
mnInvoiceAmount | ITOL | MATH_NUMERIC | OPT | BOTH |
| ||||
mnInvoiceTaxableAmount | ITXA | MATH_NUMERIC | OPT | BOTH |
| ||||
mnRevenueAmount | BTOL | MATH_NUMERIC | OPT | BOTH |
The revenue amount for a billing detail transaction. | ||||
mnInvoiceTaxAmount | ITAM | MATH_NUMERIC | OPT | BOTH |
The tax amount in the invoice. This can be either the sales, use or VAT tax. | ||||
mnInvoiceDiscountAmount | IDSC | MATH_NUMERIC | OPT | BOTH |
The amount of the discount available, as opposed to the amount of the discount actually taken. The discount calculated is based on the
| ||||
mnJournaledTaxAmount | JTAX | MATH_NUMERIC | OPT | BOTH |
| ||||
mnUnitPrice | PRIC | MATH_NUMERIC | OPT | OUTPUT |
A base or default price that is used with multipliers from the pricing rules to develop discounted prices. If no formula applies to an item or no
| ||||
mnRetainageAmount | RTNG | MATH_NUMERIC | OPT | OUTPUT |
This field is the retained dollars for a contract line. | ||||
mnForeignCostAmount | AA2 | MATH_NUMERIC | OPT | BOTH |
Amount. | ||||
mnForeignRevenueAmount | FTOL | MATH_NUMERIC | OPT | BOTH |
The total amount of the invoice or bill. The total of the individual line items must match this amount. | ||||
mnForeignInvoiceAmount | CITL | MATH_NUMERIC | OPT | BOTH |
The total amount of the invoice in foreign currency. | ||||
mnForeignInvoiceTaxableAmount | CITA | MATH_NUMERIC | OPT | BOTH |
| ||||
mnForeignInvoiceTaxAmount | CITX | MATH_NUMERIC | OPT | BOTH |
| ||||
mnForeignInvoiceDiscountAmount | CIDS | MATH_NUMERIC | OPT | BOTH |
| ||||
mnForeignJournaledTaxAmount | JTXF | MATH_NUMERIC | OPT | BOTH |
| ||||
mnForeignUnitPrice | PRIF | MATH_NUMERIC | OPT | OUTPUT |
This field represents the Foreign Unit price. | ||||
mnForeignRetainageAmount | FRTN | MATH_NUMERIC | OPT | OUTPUT |
The amount of retainage in foreign currency. | ||||
mnDiscountPercent | DCP | MATH_NUMERIC | OPT | BOTH |
The percent of the total invoice or voucher that you will discount if it is paid within the discount period. You enter the discount percent as a
| ||||
mnExchangeRate | CRR | MATH_NUMERIC | OPT | BOTH |
A number (exchange rate) that a foreign currency amount is multiplied by to calculate a domestic currency amount.
The number in this field
| ||||
jdExchangeRateDate | ERDT | JDEDATE | OPT | BOTH |
This is the date that was used to establish the exchange rate at the time the billing detail transaction was being created. | ||||
cDateExchangeRateDateBasi | ERDB | char | OPT | BOTH |
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
| ||||
mnHistoricalRevenueAmount | HBTL | MATH_NUMERIC | OPT | OUTPUT |
This value represents the revenue amount prior to invoice generation. Use this value to restore the original revenue amount if the record is
| ||||
mnHistoricalInvoiceAmount | HITL | MATH_NUMERIC | OPT | OUTPUT |
This value represents the invoice amount prior to invoice generation. Use this value to restore the original invoice amount if the record is
| ||||
mnHistoricalInvoiceTaxableAmt | HITX | MATH_NUMERIC | OPT | OUTPUT |
| ||||
mnHistoricalInvoiceTaxAmount | HTAM | MATH_NUMERIC | OPT | OUTPUT |
| ||||
szErrorMessageID | DTAI | char | OPT | NONE |
A code that identifies and defines a unit of information. It is an alphanumeric code up to 8 characters long that does not allow blanks or
| ||||
mnCustomerNumber | AN80 | MATH_NUMERIC | OPT | INPUT |
Everest Parent Data Item. | ||||
szCurrencyCodeAdhoc | CRCD | char | OPT | INPUT |
A code that identifies the currency of a transaction. | ||||
jdServiceTaxDate | DSVJ | JDEDATE | OPT | INPUT |
A date that indicates when you purchased goods or services, or when you incurred a tax liability. | ||||
szCompany | CO | char | OPT | INPUT |
A code that identifies a specific organization, fund, or other reporting entity. The company code must already exist in the Company
| ||||
szCurrencyModeAdhoc | CRCM | char | OPT | INPUT |
A value that specifies which method to use when converting from one currency to another. Valid values are:
Y
Multiplier method. The
| ||||
jdCurrentSystemDate | UPMJ | JDEDATE | OPT | INPUT |
The date that specifies the last update to the file record. | ||||
cReExtendOption | RXOP | char | OPT | INPUT |
A code that specifies how the system should re-extend a transaction. You re-extend a transaction when you want to change or reapply the
| ||||
szGeoCodeShipTo | 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
| ||||
szGeoCodeShipFrom | 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
| ||||
szGeoCodeOrderAccept | 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
| ||||
szVertexTransactionType | VVTY | char | OPT | INPUT |
Vertex Sales and Use Tax transaction type. | ||||
szLineType | LNTY | char | OPT | INPUT |
A code that controls how the system processes lines on a transaction. It controls the systems with which the transaction interfaces, such as
| ||||
szOrderType | DCTO | char | OPT | INPUT |
| ||||
mnIdentifierShortItem | ITM | MATH_NUMERIC | OPT | INPUT |
An inventory item number. The system provides three separate item numbers plus an extensive cross-reference capability to other item
| ||||
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. | ||||
cVertexActiveFlag | VVTX | char | OPT | INPUT |
This flag determines whether to use the Vertex Tax Compliance system for tax calculations. Values are:
Y
Use Vertex system to calculate
| ||||
mnVertexCacheJobNumber | JOBS | MATH_NUMERIC | OPT | INPUT |
The job number (work station ID) which executed the particular job. |
None |
None |