Functional Description
Purpose
The purpose of this business function is to insert a record in the Voucher Detail Table (F0411).
The key fields should be passed to the function (Company Key, Document Number, Document Type, Pay
Item, and Pay Item Extension), along with several other fields (listed in 'Technical Specifications'),
before inserting a F0411 record.
This business function calls an external function (GetAuditInfo) to grab information such as User ID,
Program ID, Date and Time the table is updated, before performing an insert.
Setup Notes and Prerequisites
The Key fields must be passed (Company Key, Document Number, Document Type, Pay Item, Pay Item
Extension)
Special Logic
None
Technical Specification
The following fields should be passed to the function only if they are to be updated:
RecurFrequencyOfPaym
PayStatusCode
GLDate
PeriodNumber
BatchNumber
BatchType
InvoiceDate
VendorInvoiceNumber
DueDate
DiscountDueDate
ServiceTaxDate
DocumentNumber
RecurringFrequency
PaymentAmount
DiscountAvailable
ForeignAmount
PostStatus
FiscalYear
Century
D0400074 - Insert Recurring Voucher Record
Special Input Expected
The key fields should be passed to the function:
Company Key
Document Number
Document Type
Pay Item
Pay Item Extension
The following fields should be passed to the function only if they are to be updated:
RecurFrequencyOfPaym
PayStatusCode
GLDate
PeriodNumber
BatchNumber
BatchType
InvoiceDate
VendorInvoiceNumber
DueDate
DiscountDueDate
ServiceTaxDate
DocumentNumber
RecurringFrequency
PaymentAmount
DiscountAvailable
ForeignAmount
PostStatus
FiscalYear
Century
^
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
szCompanyKey | KCO | char | NONE | NONE |
| ||||
mnDocvoucherInvoicee | DOC | MATH_NUMERIC | NONE | NONE |
| ||||
szDocumentType | DCT | char | NONE | NONE |
| ||||
szDocumentPayItem | SFX | char | NONE | NONE |
| ||||
mnPayItemExtensionNumber | SFXE | MATH_NUMERIC | NONE | NONE |
| ||||
mnRecurFrequencyOfPaym | DRF | MATH_NUMERIC | NONE | NONE |
The number of recurring invoices or vouchers that you want the system to process. This number includes the original transaction that you
| ||||
cPayStatusCode | PST | char | NONE | 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
| ||||
GLDate | DGJ | JDEDATE | NONE | 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
| ||||
mnPeriodNumber | PN | MATH_NUMERIC | NONE | NONE |
A number indicating the current accounting period. This number, used in conjunction with the Company Constants table (F0010) and the
| ||||
mnBatchNumber | ICU | MATH_NUMERIC | NONE | NONE |
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
| ||||
szBatchType | ICUT | char | NONE | NONE |
A code that specifies the system and type of transactions entered in a batch. The system assigns the value when you enter a transaction.
| ||||
InvoiceDate | DIVJ | JDEDATE | NONE | 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
| ||||
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
| ||||
DueDate | 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
| ||||
DiscountDueDate | DDNJ | JDEDATE | NONE | NONE |
In the Accounts Receivable system, the date that the invoice must be paid to receive the discount. The system calculates the discount due
| ||||
ServiceTaxDate | DSVJ | JDEDATE | NONE | NONE |
A date that indicates when you purchased goods or services, or when you incurred a tax liability. | ||||
mnDocumentNumber | 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
| ||||
szRecurringFrequency | RF | char | NONE | NONE |
A code to specify the time interval between transactions that the system creates. Valid recurring frequency values
| ||||
mnPaymentAmount | PAAP | MATH_NUMERIC | NONE | NONE |
In the Accounts Payable system, the amount of the payment.
In the Accounts Receivable system, the amount of the receipt. This amount
| ||||
mnDiscountAvailable | 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
| ||||
mnForeignAmount | FAP | MATH_NUMERIC | NONE | NONE |
The unpaid foreign amount of a transaction. | ||||
cPostStatus | POST | char | NONE | NONE |
A code the system uses to determine whether a transaction is available for the post process. Valid codes
| ||||
mnFiscalYear | FY | MATH_NUMERIC | NONE | NONE |
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
| ||||
mnCentury | CTRY | MATH_NUMERIC | NONE | NONE |
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
| ||||
mnForeignDiscountAvail | CDS | MATH_NUMERIC | OPT | NONE |
The foreign amount of the discount available as opposed to the amount of the discount actually taken. | ||||
mnAmountTaxable | ATXA | MATH_NUMERIC | OPT | NONE |
The amount on which taxes are assessed. | ||||
mnForeignTaxableAmount | CTXA | MATH_NUMERIC | OPT | NONE |
That portion of the sale that is subject to tax in foreign currency. |
B9800100 Get Audit Information | ||||
N7000910 B0400074 - Plug & Play - 04 | ||||
X0903 Fiscal Date Edits + |
F0411 Accounts Payable Ledger |