Process Lump Sum Billing Line
Source Name:N5200208
Data Structure:D5200208
Function Name:ProcessLumpSumBillingLine
System Code:52
Function Category:BAT
Function Use:UPD
Designer:Ira Frosch
Programmer:Ira Frosch
Revisions Log
Date Modified bySAR NumberDescription
30 July 99Ira Frosch3231605Creation
08 Sept 99Ira Frosch33033189Add Schedule of Values Billing Limit Stop
1.Functional Description
1.1Purpose
This business function will perform the processing to create Workfile records (F4812) for a Lump Sum
billing line.
1.2Setup Notes and Prerequisites
An F4812 cache should be created before entry into this business function. The invoice number and
pay item (Data Dictionary Item SFX) should be determined as well.
1.3Special Logic
This business function will perform the appropriate calculation for Lump Sum lines. Only Domestic
amounts are considered for the calculation (No foreign use in calculation). This is required because
only domestic amounts are stored in Job Cost.
The calculation is done in the following way:
1.Check if the current recurring billing matches the five current recurring billing codes. If yes,
create record for amount and stop. If the Schedule of values is not equal to zero, calculate the
remaining amount left. Subtract the previous taxable billed to date from the schedule of values, and bill
up to the recurring bill amount. (For example, if previous billed to date = 5000, the schedule of
values = 6000, and recurring bill amount = 2500, the remaining amount = 1000 (6000 5000) and the current
bill amount = 1000.
2.Select and loop through F5212 records for this billing line and perform steps 3-8.
3.For each line, check to see if there if subsidiary or object = '*ALL'. If yes, change value to
all '*'
4.If no wildcards, check if account exists, next perform step 8, if first, retrieve Defined Ledger
and then perform step 9.
5.If wildcard exists in object only, loop over F0901 with MCU and SUB match, check object with
wildcard and perform step 8 for each match.
6.If wildcard exists in subsidiary only, loop over F0901 with MCU and OBJ match, check subsidiary
with wildcard and perform step 8 for each match.
7.If wildcard exists in both object and subsidiary , loop over F0901with MCU, check subsidiary and
object with wildcards and perform step 8 for each match.
8.For each match, retrieve from balances: Cost-Inception to Date, Actual Cost This Period,
Projected Final Inception to Date. Accumulate for multiple F5212/F0901 lines.
9.If Calculation method = ' ', '2', '9' perform Percent of Cost Method calculation
a. Markup Amt = SCOF Project Final (ITD)
b. Markup % = Markup Amt / Project Final (ITD) (If Project Final = 0, Markup % = 1)
c. Bill Amt 1 = Markup % * Actual Cost (This Period)
d. Current Amt 1 = Bill Amt 1 Previous Taxable Invoice Amt
10.If Calculation Method = ' ' , '1', '9', perform Percent Complete Method calculation
a. % Complete = Actual Cost (ITD) / Project Final (ITD) (If Project Final = 0, do not perform
calculation)
b. Bill Amt 2 = % Complete * SCOF
c. Current Amt 2 = Bill Amt 2 - Previous Taxable Invoice Amt
11.If Calculation Method = ' ' , '3', '9', perform Defined Ledger Method calculation
a. Bill Amt 2 = % Complete (from passed ledger) * SCOF
c. Current Amt 2 = Bill Amt 2 - Previous Taxable Invoice Amt
12.If Calculation Method <> '9', Invoice Taxable Amt = Greater of ( |Current Amt 1| , |Current Amt
2|, |Current Amt 3|), else Invoice Taxable Amt = Lesser of (| Current Amt 1|, |Current Amt
2|,|Current Amt 3|)
13.Create F4812CacheRecord
If the information from the F5201/F5202 is not passed in, the system will retrieve it during the
creation of the Default Invoice line.
2.Technical Specifications
2.1Parameters:
See attachment for D5200208.
2.2Related Tables
Table Table Description
F5212Lump Sum Cross Reference
F0901Account Master
F0902Account Balances
2.3Related Business Functions
Source NameFunction Name
X0051Retrieve G/L Balances
N5200150Wildcard Account Matching
N5200200CreateCBDefaultInvoice WorkfileRecord
XX0901Retrieve Account Master
2.4Processing
//
// Process a lump sum line
//
evt_cRecordFound = ' '
//
// In case there is no recurring bill code or bill amount
//
evt_mnBillAmt = 0
evt_mnLedgerPercent = 0
//
// Check Recurring Billing Codes
//
If BF szBLRecurBillCode <> ' '
szCmpRecurBillingCode3, szCmpRecurBillingCode4, szCmpRecurBillingCode5)
If BF szCurrencyMode = 'D'
if BF Schedule of Values != 0
evt_mnBillAmt = mnRemainingAmt
Endif
Else
Endif
if BF Foreign Schedule of Values != 0
evt_mnBillAmt = BF mnForRecurBillAmt
Else
Endif
evt_cRecordFound = '1'
Endif
//
// If record not found, perform search through F5212
//
If evt_cRecordFound = ' '
F5212.FetchNext
//
If evt_cF5212Status = cOK
//
// Check if *ALL in Object or Subsidiary
//
If szF5212_OBJ = '*ALL'
szF5212_OBJ = '******'
Endif
If szF5212_SUB = '*ALL'
szF5212_SUB = '******'
Endif
//
// Check if wildcards exist in OBJ or SUB
//
Call DoesWildcardExist(N5200090) (OBJ)
Call DoesWildcardExist(N5200090) (SUB)
//
// If first record and wildcard does not exist, retrieve specified ledger % for later calculation
//
//
// If wildcards do not exist
//
If cObject_Wildcard = ' ' and cSubsidiary_Wildcard = ' '
//
// Retrieve account by MCU, OBJ, SUB
//
szF5212_OBJ, sF5212_SUB)
// Retrieve Cost-ITD, Cost-This Period, Projected Final from X0051 and add to accumulators
//
//
// If first record, retrieve specified ledger % for later calculation
//
If $FIRST and ' ','3','9'
//
// Retrieve Percent from ledger type
//
Else
//
// Test Wildcards 1. Object Wildcard, no Sub wildcard
//
If cObject_Wildcard = '1' and cSubsidiary_Wildcard = ' '
F0901.Select (szF5212_MCU, szF5212_SUB)
Do while Not EOF_F0901
F0901.FetchNext
If Not EOF_F0901
//
// Check if the wildcard matches
//
(szF5212_OBJ,szF0901_OBJ)
// Retrieve Cost-ITD, Cost-This Period, Projected Final from X0051 and add to accumulators
//
Endif
End While
Endif
// Test Wildcards 2. No object Wildcard, Subsidiary wildcard
//
If cObject_Wildcard = ' ' and cSubsidiary_Wildcard = '1'
F0901.Select (szF5212_MCU, szF5212_OBJ)
Do while Not EOF_F0901
F0901.FetchNext
If Not EOF_F0901
//
// Check if the wildcard matches
//
(szF5212_SUB,szF0901_SUB)
// Retrieve Cost-ITD, Cost-This Period, Projected Final from X0051 and add to accumulators
//
Endif
End While
Endif
// Test Wildcards 3. Object Wildcard + Subsidiary wildcard
//
If cObject_Wildcard = '1' and cSubsidiary_Wildcard = '1'
F0901.Select (szF5212_MCU, szF5212_OBJ)
Do while Not EOF_F0901
F0901.FetchNext
If Not EOF_F0901
//
// Check if the wildcard matches
//
(szF5212_SUB,szF0901_SUB)
Call Wildcard Account Matching (N5200150)
(szF5212_OBJ,szF0901_OBJ)
// Retrieve Cost-ITD, Cost-This Period, Projected Final from X0051 and add to accumulators
//
Endif
End While
Endif
Endif
Enddo
Endif
//
// Perform Calculations
//
// First, clear all workfields
//
evt_mnBillAmt1 = 0
evt_mnCurrentAmt1 = 0
evt_mnBillAmt2 = 0
evt_mnCurrentAmt2 = 0
evt_mnBillAmt3 = 0
evt_mnCurrentAmt3 = 0
//
// Perform Percent of Cost Calculation if necessary
//
// Calculate Markup Amt
//
// Calculate Markup %
//
If evt_ProjectedFinal <> 0
Else
evt_mnMarkupPct = 1.00
Endif
// Calculate Bill Amt 1
//
evt_mnBillAmt1 = evt_mnMarkupPct * evt_mnActualCostThisPeriod
//
// Calculate Current Amt 1 (* Change from WorldSoftware Taxable used instead of total)
//
evt_mnCurrentAmt1 = evt_mnBillAmt1 BF PreviousInvoiceTaxableAmt
//
Endif
//
// Calculate Percent Complete Method if necessary
//
If BF cLumpSumCalculationMethod = ' ', '1','9'
//
// Calculate % Complete If projected final = 0, % complete = 0
//
If evt_ProjectedFinal
D5200208 - Process Lump Sum Billing Line for Contract Billing Invoice
D5200208
Process Lump Sum Billing Line for Contract Billing Invoice
Parameters:
Data
ItemData Structure DescriptionI/ORequiredNotes
DOCOmnContractNoIY
DCTOszContractDocumentTypeIY
KCOOszContractKeyCoIY
COCHszContractChangeOrderIY
LNIDmnContractLineNoIY
ICUmnBatchNoIY
DTTOjdDateBillThruINIf zero, the system will
use the current date.
APDTjdApplicationDateIY
DGJjdGeneralLedgerDateIY
DSVJjdServiceDateIY
ERDBcExchangeRateDateBasisIY
RRBCszCmpRecurBillingCode1IYThis is the current invoice
Recur Bill Code
RRBCszCmpRecurBillingCode2IYThis is the current invoice
Recur Bill Code
RRBCszCmpRecurBillingCode3IYThis is the current invoice
Recur Bill Code
RRBCszCmpRecurBillingCode4IYThis is the current invoice
Recur Bill Code
RRBCszCmpRecurBillingCode5IYThis is the current invoice
Recur Bill Code
LSCMcLumpSumCalculationMethodIY'1' Percent Complete,
'2' Percent of cost,
'3' Defined Ledger,
'9' lesser of methods,
' ', the greater of the
methods
LTszLumpSumLedgerTypeIYLedger Type for calculating
method '3'
ERRCcErrorCodeONThis returns if there was
any errors
DOCZmnInvoiceNoIY
DCTIszInvoiceDocumentTypeIY
KCOIszInvoiceKeyCompany IY
SFXszPayItemIYThis is the pay item of
the billing line on the
invoice.
CRCDszBaseCurrencyINIf multicurrency is on,
this field is required.
CRCFszForeignCurrencyINIf multicurrency is on,
this field is required.
CRRMcCurrencyModeINIf multicurrency is on,
this field is required.
This is the mode from
the contract.
CRRDmnCurrencyRateINIf multicurrency is on,
this field is required.
This is the rate calculated
for this date.
SCOFmnScheduleOfValuesIN
FSOFmnForeignScheduleOfValuesIN
PTHPmnPriorInvTotalAmtIN
PATXmnPriorInvTaxableAmtIN
PTHPmnPriorInvTotalAmtIN
PATXmnPriorInvTaxableAmtIN
PTHPMnPriorInvPeriodAmtINThis period
DL01szBillingLineDescriptionIN
OPIMszBillingLineIN
PRTPcBillingLineTypeIN
MCUSszProjectNoINRequired for Default
Invoice record. Should be
from F5202 table.
EXR1szTaxExplanationCodeIN
TXA1szTaxRateAreaIN
PCTNszParentContractNoIN
PCTTszParentContractTypeIN
PCKOszParentContractKeyCoIN
JMCUszHostBusinessUnitIYUsed to determine the RP12
from the Business Unit
Master. (From F5201)
ACCOcAccountOverrideFlagINDetermines whether to set
override revenue account
MCUszBusinessUnitIYBusiness Unit from
F5202
OBJszObjectINNeeded only for override
revenue account
SUBszSubsidiary INNeeded only for override
revenue account
SBLszSubledgerIN
SBLTszSubledgerTypeIN
RRBCszBLRecurBillingCodeINThis is the Recurring
Billing Code from the
Billing Line
RRBAmnRecurBillAmtIN
FRBAmnForRecurBillAmtIN
VVTXcVertexActiveINRequired for Vertex
JOBSmnVertexJobNumberINRequired for Vertex
UmnUnitsON
AAmnCostAmtON
ITOLmnInvoiceTotalAmtON
ITAMmnInvoiceTaxAmtON
ITXAmnInvoiceTaxableAmtON
JTAXMnJournaledTaxON
IDSCmnDiscountAmtON
AA2mnCostAmtFON
CITLmnForInvTotalAmtON
CITXmnForInvTaxAmtON
CITAmnForInvTaxableAmtON
JTXFmnForJrnlTaxAmtON
CIDSmnForInvDiscountAmtON
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
mnContractNo | DOCO | MATH_NUMERIC | OPT | 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 | OPT | 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 | OPT | 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 | OPT | 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 | OPT | INPUT |
A number that identifies multiple occurrences, such as line numbers on a purchase order or other document. Generally, the system assigns
| ||||
mnBatchNumber | ICU | MATH_NUMERIC | OPT | 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 | OPT | INPUT |
The ending date for which the transaction or code is applicable. | ||||
jdApplicationDate | APDT | JDEDATE | OPT | INPUT |
The date of the last or current application. (An application is assigned each time an invoice is issued for the contract.) | ||||
jdGLDate | DGJ | JDEDATE | OPT | 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 | OPT | INPUT |
A date that indicates when you purchased goods or services, or when you incurred a tax liability. | ||||
cExchangeRateDateBasis | ERDB | char | OPT | 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
| ||||
szRecurBillingCode1 | RRBC | char | OPT | INPUT |
A code that specifies the frequency of the recurring billing amount for the billing line, such as M, MO, or MON for monthly. You can generate
| ||||
szRecurBillingCode2 | RRBC | char | OPT | INPUT |
A code that specifies the frequency of the recurring billing amount for the billing line, such as M, MO, or MON for monthly. You can generate
| ||||
szRecurBillingCode3 | RRBC | char | OPT | INPUT |
A code that specifies the frequency of the recurring billing amount for the billing line, such as M, MO, or MON for monthly. You can generate
| ||||
szRecurBillingCode4 | RRBC | char | OPT | INPUT |
A code that specifies the frequency of the recurring billing amount for the billing line, such as M, MO, or MON for monthly. You can generate
| ||||
szRecurBillingCode5 | RRBC | char | OPT | INPUT |
A code that specifies the frequency of the recurring billing amount for the billing line, such as M, MO, or MON for monthly. You can generate
| ||||
cLumpSumCalculationMethod | LSCM | char | OPT | INPUT |
Use this option to determine how lump sum lines are calculated. Valid values are:
Blank Use the greater of methods 1 and 2. The system
| ||||
szLumpSumLedgerType | LT | char | OPT | INPUT |
A user defined code (09/LT) that specifies the type of ledger, such as AA (Actual Amounts), BA (Budget Amount), or AU (Actual Units). You
| ||||
cErrorCode | ERRC | char | OPT | INPUT |
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 | OPT | 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
| ||||
szInvoiceKeyCo | KCOI | char | OPT | INPUT |
Invoice Document Company. | ||||
szInvoicePayItem | SFX | char | OPT | 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
| ||||
mnScheduleOfValues | SCOF | MATH_NUMERIC | OPT | INPUT |
The expected or budgeted amount assigned to a specific line item of the contract. The system uses this amount in conjunction with the
| ||||
mnForeignScheduleofValues | FSOF | MATH_NUMERIC | OPT | INPUT |
The foreign expected or foreign budgeted amount assigned to a specific line item of the contract. The system uses this amount in
| ||||
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 |
mnPriorInvPeriodAmt | PTHP | MATH_NUMERIC | OPT | INPUT |
The amount previously billed this period for the line item on the contract. | ||||
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
| ||||
mnParentContractNumber | 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 | OPT | INPUT |
The Business Unit responsible for the job. This is particularly useful during transfer pricing. | ||||
cAccountOverrideFlag | 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 | OPT | 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
| ||||
szBLRecurringBillingCode | RRBC | char | OPT | INPUT |
A code that specifies the frequency of the recurring billing amount for the billing line, such as M, MO, or MON for monthly. You can generate
| ||||
mnRecurBillingAmt | RRBA | MATH_NUMERIC | OPT | INPUT |
A fixed amount you want to bill with each recurring frequency. | ||||
mnForRecurBillingAmt | FRBA | MATH_NUMERIC | OPT | INPUT |
A fixed amount that you want to bill with each recurring frequency. | ||||
cVertexActive | 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
| ||||
mnVertexJobNumber | JOBS | MATH_NUMERIC | OPT | INPUT |
The job number (work station ID) which executed the particular job. | ||||
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,
| ||||
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. | ||||
mnInvoiceDiscountAmt | 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
| ||||
mnGLCentury | CTRY | MATH_NUMERIC | OPT | INPUT |
The calendar century associated with the year. Enter is the first two digits of
the year. For example, 19 indicates any year beginning with 19
| ||||
mnGLFiscalYear | FY | MATH_NUMERIC | OPT | INPUT |
A number that identifies the fiscal year. Generally, you can either enter a number in this field or leave it blank to indicate the current fiscal
| ||||
mnGLPeriodNo | PN | MATH_NUMERIC | OPT | INPUT |
A number indicating the current accounting period. This number, used in conjunction with the Company Constants table (F0010) and the
| ||||
mnBTCentury | CTRY | MATH_NUMERIC | OPT | INPUT |
The calendar century associated with the year. Enter is the first two digits of
the year. For example, 19 indicates any year beginning with 19
| ||||
mnBTFiscalYear | FY | MATH_NUMERIC | OPT | INPUT |
A number that identifies the fiscal year. Generally, you can either enter a number in this field or leave it blank to indicate the current fiscal
| ||||
mnBTPeriodNo | PN | MATH_NUMERIC | OPT | INPUT |
A number indicating the current accounting period. This number, used in conjunction with the Company Constants table (F0010) and the
| ||||
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
| ||||
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
| ||||
mnCustomerNo | 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.
| ||||
mnPriorForInvPeriodAmt | FTHP | MATH_NUMERIC | OPT | INPUT |
The amount previously billed this period for the line item on the contract. | ||||
mnPriorForInvTotalAmt | FTHP | MATH_NUMERIC | OPT | INPUT |
The amount previously billed this period for the line item on the contract. | ||||
mnPriorForInvTaxableAmt | FATX | MATH_NUMERIC | OPT | INPUT |
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 |