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 |