Functional Description
Purpose
This business function loads the cache with pay item information. The cache will be read using
function B0400107.
Setup Notes and Prerequisites
The cache needs to be empty or records which are being added must not already exist in the cache.
The cache will not update if identical records are found.
Special Logic
Technical Specifications
Data Item Data Structure Description I/ORequired Notes
KCOCompany Key I YES Key to Cache
DOC Document (Voucher, Invoice, Etc.) I YES Key to Cache
DCT Document Type I YES Key to Cache
SFX Document Pay Item I YES Key to Cache
SFXE Pay Item Extension Number I YES Key toCache
AAP Open Amount I NO
CO Company I NO
VINV Vendor Invoice Number I NO
DDJ Due Date I NO
ADSC Discount Available I NO
AG Gross Amount I NO
CDSCForeign Discount Available I NO
GLC G/L Offset I NO
AN8Address Number I NO
MCU Cost Center I NO
OBJ Cost Center 2 I NO
CRR Currency Conversion Rate I NO
FAPForeign Amount Open I NO
ACRCurrency Amount I NO
ADSADiscount Taken I NO
GLBAG/L Bank Account I NO
EV01Last Cache Record I NO
Related Tables
Table Table Description
Related Business Functions
Source NameFunction Name
Processing
Open cache B0400106. Load key and fetch against the cache. If the fetch is successful then do not process this record. If the fetch fails then insert this
record into the cache. Insert all of the values so they can be used to populate the grid in Manual Payments. Repeat for every record selected. Close cache
B0400106.
^
D0400106 - Load Voucher Info to Cache
Special Output Returned
Last cache record does not need to be used for the load of the cache only for the reading of the
cache.
^
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
szCompanyKey | KCO | char | NONE | NONE |
A number that, with the document number, document type and G/L date, uniquely identifies an original document, such as invoice, voucher,
| ||||
mnDocVoucherInvoiceE | DOC | MATH_NUMERIC | NONE | NONE |
A number that identifies the original document, such as a voucher, invoice, or journal entry. On entry forms, you can assign the document
| ||||
szDocumentType | DCT | char | NONE | NONE |
A user defined code (00/DT) that identifies the origin and purpose of the transaction. PeopleSoft reserves several prefixes for document
| ||||
szDocumentPayItem | SFX | char | NONE | NONE |
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
| ||||
mnPayItemExtensionNumber | SFXE | MATH_NUMERIC | NONE | NONE |
A code to designate an adjusting entry to a pay item on a voucher or invoice. This field is required so that each record is unique. | ||||
mnAmountOpen | AAP | MATH_NUMERIC | NONE | NONE |
The amount of an invoice or voucher pay item that is unpaid. | ||||
szCompany | CO | char | NONE | NONE |
A code that identifies a specific organization, fund, or other reporting entity. The company code must already exist in the Company
| ||||
szVendorInvoiceNumber | VINV | char | NONE | NONE |
The supplier's invoice number that is used for voucher entry. Voucher entry allows only one invoice per voucher number. If multiple invoice
| ||||
jdDateDueJulian | DDJ | JDEDATE | NONE | NONE |
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
| ||||
mnAmtDiscountAvailable | ADSC | MATH_NUMERIC | NONE | NONE |
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
| ||||
mnAmountGross | AG | MATH_NUMERIC | NONE | NONE |
A value that specifies the total amount of the invoice or voucher pay item. The gross amount might include the tax amount, depending on
| ||||
mnForeignDiscountAvail | CDS | MATH_NUMERIC | NONE | NONE |
The foreign amount of the discount available as opposed to the amount of the discount actually taken. | ||||
szGlClass | GLC | char | NONE | NONE |
A code that determines the trade account that the system uses as the offset when you post invoices or vouchers. The system concatenates
| ||||
mnAddressNumber | AN8 | MATH_NUMERIC | NONE | NONE |
A number that identifies an entry in the Address Book system, such as employee, applicant, participant, customer, supplier, tenant, or
| ||||
mnCurrencyConverRateOv | CRR | MATH_NUMERIC | NONE | NONE |
A number (exchange rate) that a foreign currency amount is multiplied by to calculate a domestic currency amount.
The number in this field
| ||||
mnAmountForeignOpen | FAP | MATH_NUMERIC | NONE | NONE |
The unpaid foreign amount of a transaction. | ||||
mnAmountCurrency | ACR | MATH_NUMERIC | NONE | NONE |
The foreign currency amount entered on the transaction. If the Multi-Currency Conversion option on the General Accounting constants is set
| ||||
mnAmountDiscountTaken | ADSA | MATH_NUMERIC | NONE | NONE |
The amount by which an invoice or voucher is reduced if paid by a specific date. The discount taken does not have to be the same as the
| ||||
mnForeignDiscountTaken | CDSA | MATH_NUMERIC | OPT | NONE |
The amount of the discount, expressed in the foreign currency of the transaction, that was taken or granted during the application of a
| ||||
szNameRemark | RMK | char | OPT | NONE |
A generic field that you use for a remark, description, name, or address. | ||||
szCurrencyCodeFrom | CRCD | char | OPT | NONE |
A code that identifies the currency of a transaction. | ||||
jdDateInvoiceJ | DIVJ | JDEDATE | OPT | NONE |
The date that either you or the system assigns to an invoice or voucher. This can be either the date of the supplier's invoice to you or the
| ||||
jdDateForGLandVoucherJULIA | DGJ | JDEDATE | OPT | NONE |
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
| ||||
szPurchaseOrder | PO | char | OPT | NONE |
A document that authorizes the delivery of specified merchandise or the rendering of certain services. | ||||
cPayStatusCode | PST | char | OPT | NONE |
A user defined code (00/PS) that indicates the current payment status for a voucher or an invoice. Examples of codes include:
A
Approved
| ||||
szBusinessUnit | MCU | char | OPT | NONE |
An alphanumeric code that identifies a separate entity within a business for which you want to track costs. For example, a business unit
| ||||
szCurrencyCodeBase | BCRC | char | OPT | NONE |
A code that represents the currency of the company for a transaction. For a foreign currency transaction, this is the currency code of the
|
None |
None |