RetainageCalculation= ' 'Used in N5200216/N5200218 to ADD TO the existing values in the cache.
      = '1'Used in N48S0220 to REPLACE specific fields (RTNG, FTNG, DDTR, FDTR, 
STAM, CTAM, THPD, FHPD, ADSC, and CDS) in the cache.
D48S0280A - GenerateInvoiceCache
| Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both | 
|---|---|---|---|---|
| idSeqSumInformation | OBID | ID | REQ | INPUT | 
The Object Identifier uniquely identifies a control on a form.  | ||||
| mnAddressNumberJobAr | AN8O | MATH_NUMERIC | REQ | INPUT | 
The address book number to which the system posts billing and accounts receivable transactions.  | ||||
| mnAddNoAlternatePayee | AN8J | MATH_NUMERIC | OPT | INPUT | 
An alternate address to which accounts payable can send payments due.  | ||||
| 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 
  | ||||
| szCostCenter | 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 
  | ||||
| szSubledger | SBL | char | REQ | 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 | REQ | 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 
  | ||||
| jdDateBillFrom | BTFR | JDEDATE | REQ | INPUT | 
The from date used to determine if a transaction is billed. The transaction is billed if the general ledger date falls between the from date and 
  | ||||
| jdBilledThroughDate | BTDT | JDEDATE | REQ | INPUT | 
This field will be used in the Recurring Billing module as part of a date-oriented billing method, as opposed to period-oriented billing.  This 
  | ||||
| jdDtForGLAndVouch1 | DGL | JDEDATE | REQ | INPUT | 
A date that identifies the financial period to which the transaction is to be posted. 
The company constants specify the date range for each 
  | ||||
| jdDateServiceCurrency | DSVJ | JDEDATE | REQ | INPUT | 
A date that indicates when you purchased goods or services, or when you incurred a tax liability.  | ||||
| mnBatchNumber | 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 
  | ||||
| mnDocumentOrderAlt | DOCZ | MATH_NUMERIC | REQ | BOTH | 
  | ||||
| szDocTypeInvoiceOnly | DCTI | char | REQ | INPUT | 
  | ||||
| szDocumentCompanyInvoice | KCOI | char | REQ | INPUT | 
  | ||||
| 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.)  | ||||
| mnAmountField | AA | MATH_NUMERIC | REQ | INPUT | 
  | ||||
| mnAmountCurrency | ACR | MATH_NUMERIC | REQ | INPUT | 
The foreign currency amount entered on the transaction. If the Multi-Currency Conversion option on the General Accounting constants is set 
  | ||||
| mnThisPeriod | THPD | MATH_NUMERIC | REQ | INPUT | 
The amount that is being billed for this contract pay item.  | ||||
| mnThisPeriodForeign | FHPD | MATH_NUMERIC | REQ | INPUT | 
The amount that is being billed for this contract pay item. On entry screens,you can enter this amount one of three ways:
    o A Dollar 
  | ||||
| szTaxArea1 | 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 
  | ||||
| szTaxExplanationCode1 | EXR1 | char | REQ | INPUT | 
  | ||||
| mnAmtTax2 | STAM | MATH_NUMERIC | REQ | INPUT | 
  | ||||
| mnForeignTaxAmount | CTAM | MATH_NUMERIC | REQ | INPUT | 
  | ||||
| mnAmountTaxable | ATXA | MATH_NUMERIC | REQ | INPUT | 
The amount on which taxes are assessed.  | ||||
| mnForeignTaxableAmount | CTXA | MATH_NUMERIC | REQ | INPUT | 
That portion of the sale that is subject to tax in foreign currency.  | ||||
| mnAmountTaxExempt | ATXN | MATH_NUMERIC | REQ | INPUT | 
The amount upon which taxes are not assessed. This is the portion of the transaction not subject to sales, use, or VAT taxes because the 
  | ||||
| mnForeignTaxExempt | CTXN | MATH_NUMERIC | REQ | INPUT | 
The foreign amount associated with this document which is not subject to sales, use or value-added tax due to the nature of the transaction 
  | ||||
| mnTotalAmountLabor | TLAB | MATH_NUMERIC | REQ | INPUT | 
The total labor amount of the invoice or bill.  | ||||
| mnTotalAmountLaborForei | FLAB | MATH_NUMERIC | REQ | INPUT | 
The total labor foreign amount of the invoice or bill.  | ||||
| mnTotalAmountBurden | TBUR | MATH_NUMERIC | REQ | INPUT | 
The total burden amount of the invoice or bill.  | ||||
| mnAmtDiscountAvailable | ADSC | MATH_NUMERIC | REQ | INPUT | 
The amount of the invoice or voucher pay item that is eligible to be subtracted from the gross amount when the transaction is paid. The 
  | ||||
| mnForeignDiscountAvail | CDS | MATH_NUMERIC | REQ | INPUT | 
  | ||||
| cCurrencyMode | 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 
  | ||||
| szCurrencyCodeFrom | CRCD | char | REQ | INPUT | 
  | ||||
| szCurrencyCodeOrigin | CRCF | char | REQ | INPUT | 
The currency code of the insured amount.  | ||||
| mnCurrencyConverRateDiv | CRRD | MATH_NUMERIC | REQ | INPUT | 
A number (exchange rate) that a foreign currency amount is divided by to calculate a domestic currency amount. The number you enter in 
  | ||||
| cModeOfInputValues | MIVL | char | REQ | INPUT | 
  | ||||
| cErrorCode | EV01 | char | OPT | OUTPUT | 
An option that specifies the type of processing for an event.  | ||||
| szObjectAccount | 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.  | ||||
| szDocumentType | DCT | char | OPT | INPUT | 
A user defined code (00/DT) that identifies the origin and purpose of the transaction.  PeopleSoft reserves several prefixes for document 
  | ||||
| mnAddressNumber | AN8 | MATH_NUMERIC | OPT | INPUT | 
A number that identifies an entry in the Address Book system, such as employee, applicant, participant, customer, supplier, tenant, or 
  | ||||
| szJobClass | RP11 | char | OPT | INPUT | 
Category code 11 associated with the Business Unit Master file (F0006).  This is a user defined code (system 00, type 11) for use in flex 
  | ||||
| szWorkOrderClass | WR07 | char | OPT | INPUT | 
A user defined code (00/W7) that indicates the service type for the work order.  | ||||
| szPhase | WR01 | char | OPT | INPUT | 
A user defined code (00/W1) that indicates the current stage or phase of development for a work order. You can assign a work order to only 
  | ||||
| szCostPool | RP12 | char | OPT | INPUT | 
Category code 12 associated with the Business Unit Master file (F0006).  This is a user defined code (00/12) for use in flex account mapping 
  | ||||
| szJobCategory | JBCD | char | OPT | INPUT | 
A user defined code (07/G) that defines the jobs within your organization. You can associate pay and benefit information with a job type and 
  | ||||
| szJobStep | JBST | char | OPT | INPUT | 
A user defined code (07/GS) that designates a specific level within a particular job type. The system uses this code in conjunction with job 
  | ||||
| mnPayDeductBenAccType | PDBA | MATH_NUMERIC | OPT | INPUT | 
A code that defines the type of pay, deduction, benefit, or accrual.
Pay types are numbered from 1 to 999. Deductions and benefits are 
  | ||||
| szEquipmentWorkedPayroll | EQCG | char | OPT | INPUT | 
The ID number of the equipment an employee used to perform a job. For example, an employee might drive a company dump truck or 
  | ||||
| szClassCode0 | ACL0 | char | OPT | INPUT | 
A user defined code (12/CO) that groups similar items for billing. If you are an Equipment Management client and you use Equipment 
  | ||||
| szCostCenterHome | HMCU | char | OPT | INPUT | 
The number of the business unit in which the employee generally resides.  | ||||
| szPayrollTaxType | PTAX | char | OPT | INPUT | 
A code that specifies the type of payroll tax being processed. This is a user defined code (07/TX). To set up state minimum wage amounts, 
  | ||||
| szBillItemCode | R001 | char | OPT | INPUT | 
Category code 1 associated with the Account Master table (F0901). This is a user defined code (09/01) for use in flex account mapping and 
  | ||||
| szCategoryCodeGl002 | R002 | char | OPT | INPUT | 
Category code 2 associated with the Account Master table (F0901). This is a user defined code (09/02) for use in flex account mapping and 
  | ||||
| szLocation | R003 | char | OPT | INPUT | 
Category code 3 associated with the Account Master table (F0901). The system uses this user defined code (09/03) in mapping flexible 
  | ||||
| mnRateInvoice | BRTI | MATH_NUMERIC | OPT | INPUT | 
A rate that the system uses to mark up the invoice amount reflected in the billing of professional services workers such as draftsmen, 
  | ||||
| szProgramId | PID | char | REQ | INPUT | 
The number that identifies the batch or interactive program (batch or interactive object). For example, the number of the Sales Order Entry 
  | ||||
| szWorkStationId | JOBN | char | REQ | INPUT | 
The code that identifies the work station ID that executed a particular job.  | ||||
| szUserId | USER | char | REQ | INPUT | 
The code that identifies a user profile.  | ||||
| jdDateRecordUpdated | MUPM | JDEDATE | REQ | INPUT | 
The date of last update. Used in the Financial Reporting Merge file (F1011) where field name is duplicated.  | ||||
| mnTimeLastUpdated | UPMT | MATH_NUMERIC | REQ | INPUT | 
The time that specifies when the program executed the last update to this record.  | ||||
| szPaymentTermsAR | 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 
  | ||||
| szGlClass | GLC | char | REQ | INPUT | 
A code that determines the trade account that the system uses as the offset when you post invoices or vouchers. The system concatenates 
  | ||||
| cKeyTypeGLOffsetTable | TKG1 | char | OPT | INPUT | 
  | ||||
| mnDocVoucherInvoiceE | DOC | MATH_NUMERIC | OPT | INPUT | 
A number that identifies the original document, such as a voucher, invoice, or journal entry. On entry forms, you can assign the document 
  | ||||
| szComponentCode | CCOD | char | OPT | INPUT | 
A component code identifies a provisional burden that is accounted for at the billing detail transaction level.  | ||||
| mnBillingControlId | BCI | MATH_NUMERIC | OPT | INPUT | 
A unique number that the system assigns to each billing record. The system assigns the number from the Next Numbers - Automatic table 
  | ||||
| mnTotalAmountBurdenFore | FBUR | MATH_NUMERIC | REQ | INPUT | 
The total burden foreign amount of the invoice or bill.  | ||||
| mnAmountDocumentsEntered | DOCN | MATH_NUMERIC | REQ | BOTH | 
If you are using the batch control feature, the number of transactions entered into the batch. If you are not using batch control, the system 
  | ||||
| mnAmountEntered | AME | MATH_NUMERIC | REQ | BOTH | 
  | ||||
| szDocumentPayItem | SFX | char | REQ | BOTH | 
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 
  | ||||
| szCompositeKeyBlock | BLKK | char | OPT | OUTPUT | 
The Composit Key Block contains the values of multiple key fields grouped in various sequences.  In the Service Billing system, it is used 
  | ||||
| jdDateDueJulian | DDJ | JDEDATE | REQ | INPUT | 
In Accounts Receivable, the date that the net payment is due.
In Accounts Payable, the date that the payment is due to receive a discount 
  | ||||
| mnCurrencyConverRateOv | CRR | MATH_NUMERIC | REQ | INPUT | 
  | ||||
| mnDocumentOrderInvoiceE | 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, 
  | ||||
| szOrderType | 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 
  | ||||
| szCompanyKeyOrderNo | 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 
  | ||||
| mnParentContNumber | 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.  | ||||
| szParentContractDocumentCo | PCKO | char | OPT | INPUT | 
Parent Contract Document Company.  | ||||
| szContractChangeNum | 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 
  | ||||
| mnLineNumber | 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 
  | ||||
| szOwnerPayItem | 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 
  | ||||
| mnPercntRetainage | PRET | MATH_NUMERIC | OPT | INPUT | 
The retainage rate for the contract. The rate is a percentage that is expressed as a whole number. For example, you enter a retainage rate 
  | ||||
| szGlOffsetRetention | RGLC | char | REQ | INPUT | 
A code that designates the offset accounts for retainage, for example RETN or 1225. You set up the code as an automatic accounting 
  | ||||
| szAuthorizeTransactionID | ATRI | char | OPT | INPUT | 
This field indicates the identification number for authorization.  You can track your prepayment authorization transaction with this 
  | ||||
| cModeOfInputSm | MISM | char | OPT | BOTH | 
This code indicates the mode of input for Stored Materials.
   blank indicates dollar amount entered.
   %       indicates percent complete 
  | ||||
| mnApplicationNo | APPL | MATH_NUMERIC | OPT | INPUT | 
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 | INPUT | 
A number used to control changes to closed applications. Closed applications represent invoices that have been sent. This number is 
  | ||||
| cBillingType | 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 
  | ||||
| cBillSuspendFlag | BLSP | char | OPT | INPUT | 
The Billing Rule Flag attaches to each pay item on a contract. The flag indicates:
   blank Add billing records to the Invoice Summary Work 
  | ||||
| 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, 
  | ||||
| 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, 
  | ||||
| mnUnitPrice | UP | MATH_NUMERIC | OPT | INPUT | 
The list or base price you charge for one primary or pricing unit of this item.  | ||||
| mnForUnitPrice | FUP | MATH_NUMERIC | OPT | INPUT | 
The foreign price per unit.  | ||||
| mnPriorUnitsInv | 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.  | ||||
| mnForPriorInvTotalAmt | FTHP | MATH_NUMERIC | OPT | INPUT | 
The amount previously billed this period for the line item on the contract.  | ||||
| mnPriorInvTaxAmt | PTAM | MATH_NUMERIC | OPT | INPUT | 
The tax amount previously billed for the billing line on the contract.  | ||||
| mnForPriorInvTaxAmt | FPTA | MATH_NUMERIC | OPT | INPUT | 
The foreign tax amount previously billed for the billing line on the contract.  | ||||
| mnPriorInvTaxableAmt | PATX | MATH_NUMERIC | OPT | INPUT | 
  | ||||
| mnForPriorInvTaxableAmt | FATX | MATH_NUMERIC | OPT | INPUT | 
  | ||||
| szRetRule | RTNR | char | OPT | INPUT | 
A rule the system uses to calculate retainage on a contract. For example:
Retn % - 10.00; Percent Complete - 50.00
Retn % - 5.00; Percent 
  | ||||
| cRetControlFlag | RCTL | char | OPT | INPUT | 
An option that determines whether the retainage amount is stored in the Accounts Receivable or General Accounting system and whether 
  | ||||
| mnRetAmt | RTNG | MATH_NUMERIC | OPT | INPUT | 
This field is the retained dollars for a contract line.  | ||||
| mnForRetAmt | FTNG | MATH_NUMERIC | OPT | INPUT | 
xThis field is the retained dollars for a contract line.  | ||||
| mnPriorRetAmt | RTNP | MATH_NUMERIC | OPT | INPUT | 
  | ||||
| mnForPriorRetAmt | FTNP | MATH_NUMERIC | OPT | INPUT | 
  | ||||
| mnDefTaxAmt | DDTR | MATH_NUMERIC | OPT | INPUT | 
The deferred tax associated with the retainage amount.  | ||||
| mnForDefTaxAmt | FDTR | MATH_NUMERIC | OPT | INPUT | 
The deferred tax associated with the retainage stored in the foreign currency of the transaction.  | ||||
| mnPriorStoredMatInvAmt | PSMA | MATH_NUMERIC | OPT | INPUT | 
The amount previously billed for Stored Material for the line item on the contract.  | ||||
| mnForPriorStoredMatInvAmt | FSMA | MATH_NUMERIC | OPT | INPUT | 
  | ||||
| mnPriorStoredMatRetAmt | SMRP | MATH_NUMERIC | OPT | INPUT | 
The prior retained amount for the stored materials.  | ||||
| mnForPriorStoredMatRetAmt | SMPF | MATH_NUMERIC | OPT | NONE | 
| szGeoCodeShipFrom | VGCSF | char | OPT | INPUT | 
The location (warehouse or store location) from which a product was shipped or where a service is performed. This location is used by the 
  | ||||
| szGeoCodeOrderAccept | VGCOA | char | OPT | INPUT | 
The jurisdiction where a sales transaction is approved or a contract is accepted by the seller.  | ||||
| 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.  | ||||
| szAccountId | AID | char | OPT | INPUT | 
A number that the system assigns to each general ledger account in the Account Master table (F0901) to uniquely identify it.  | ||||
| szAccountId5 | AID5 | char | OPT | INPUT | 
The General Ledger Account number can be one of four numbers.  These are: (1) the BU/Object/Subsidiary, (2) the 25-digit unstructured 
  | ||||
| szSubledger5 | SBL5 | char | OPT | INPUT | 
The subledger provides for detailed subsidiary accounting within any General Ledger account.  This provides an audit trail of the 
  | ||||
| cSubledgerType05 | SBT5 | char | OPT | INPUT | 
A code used in conjunction with subledger.  It controls subledger editing for validity.  Valid codes are edited in User Defined Codes, 
  | ||||
| szAccountId6 | AID6 | char | OPT | INPUT | 
The short account id that is used to create the debit side of a journal entry for the Contract Billing and Service Billing modules. If this field is 
  | ||||
| szSubledger6 | SBL6 | char | OPT | INPUT | 
The subledger provides for detailed subsidiary accounting within any General Ledger account.  This provides an audit trail of the 
  | ||||
| cSubledgerType06 | SBT6 | char | OPT | INPUT | 
A code used in conjunction with subledger.  It controls subledger editing for validity.  Valid codes are edited in User Defined Codes, 
  | ||||
| cRetainageCalculation | EV01 | char | OPT | INPUT | 
An option that specifies the type of processing for an event.  | ||||
| szVendorInvoiceNumber | VINV | char | OPT | INPUT | 
The supplier's invoice number that is used for voucher entry. Voucher entry allows only one invoice per voucher number. If multiple invoice 
  | ||||
| cPayWhenPaid | PYWP | char | OPT | INPUT | 
This field is used to identify Pay When Paid transactions.
Accounts Payable
A 'W' will be used to identify Pay When Paid Voucher 
  | ||||
| B0000083 Convert Math Numeric to String with Left Zero Pad | ||||
| N48S0290 F48011 Billing Batch Validation | ||||
| N48S0310 F4812 Update Invoice Information | ||||
| N48S0440 F48S58 Get UBE Name and Version | ||||
| X0010 Next Numbers | ||||
| X0903 Fiscal Date Edits + | 
| F48011 Service Billing Batch Control | ||||
| F48051 Invoice Sequence/Summarization Table Detail | ||||
| F4812 Billing Detail Workfile | ||||
| F4822 Invoice Summary Work File |