Functional Description
Purpose
Apply Receipt to Invoice Function handles the creating or updating for the application of payment
amount, discount, adjustments, chargeback, or deduction to the open amount of a invoice. It will also
handle the creating and updating for standalone transaction.
This function can perform the following receipt transactions:
10 Simple Invoice Match
11 Match with Auto Chargeback of the Discount
15 Match with Auto Write-Off
16 Match with Auto Chargeback
17 Match with Auto Deduction
25 Standalone Write-Off
26 Standalone Chargeback
27 Standalone Deductions
If any of the above operations leaves an amount open on the invoice and the transaction does not have
a adjusting amount entered by the user. The function will check the open amount to the user defined
automatic write-off limits. If the open amount is less then the automatic write-off limits the function
will perform an automatic write-off to close the invoice.
When operating in a multi-currency environment, and a receipt is captured in foreign mode, this
function will determine if a currency gain or loss has occurred. Function will also check if receipt is in
a alternate currency and dermine any alternate gain or loss.
This function will update the following tables:
Customer Ledger (F03B11) Table
chargeback amount plus deduction amount for the requested invoice. Any discount will also be recorded
in the discount taken column on the invoice. Function will also write any RU- Unapplied Cash,
RB-Chargeback or R5-Deduction Invoices that the transaction creates.
Receipt Header (F03B13) Table
entered.
Receipt Detail (F03B14) Table
currency gains or losses.
on a transaction, this function expects only the net change amount be passed into it, not the entire
new amount. This is true for all amounts such as payment amount, discount taken, chargeback, and
deduction in both foreign and domestic currencies.
Setup Notes and Prerequisites
None.
Special Logic
None.
Technical Specification
Parameters
ItemDescriptionI/OReq?Notes
ACTNcAddOrUpdateFlagIY'A' to add record. 'U' to update a record.
PYIDmnPaymentidIYPayment ID of Receipt Header.
RC5mnFilelineidentifier50IYLine Number of the transaction with in a Payment ID
group. Required for Updates. Must zero on Adds.
KCOszCompanykeyIYDocument Key Company of Invoice being applied.
Required if transaction is a Invoice match.
DOCmnDocvoucherinvoiceeIYDocument Number of Invoice being applied. Required if
transaction is a Invoice match.
DCTszDocumenttypeIYDocument Type of Invoice being applied. Required if
transaction is a Invoice match.
SFXszDocumentpayitemIYPay Item of Invoice being applied. Required if
transaction is a Invoice match.
ICUTszBatchtypeIYBatch Type for the batch. This is the ICUT in F03B14.
ICUmnBatchnumberIYBatch Number for the batch. This is the ICU in
F03B14.
DICJjdDatebatchjulianIYBatch Date of Transaction. This is the DICJ in
F03B14.
FAPmnForeignAmountAppliedIYAmount in foreign currency to be applied to the
Invoice. Can be left BLANK if Transaction Amounts are passed and cCurrencyConvertYN is EQ 1. The function
will calculate the foreign amount and pass it back to the calling function
CDSAmnForeigndiscounttakenIYDiscount amount in foreign currency to be applied to
the Invoice. Can be left BLANK if Transaction Amounts are passed and cCurrencyConvertYN is EQ 1. The
function will calculate the foreign amount and pass it back to the calling function.
RSCOszReasoncodeINReason code for the writeoff. Required if write-off
amount is not zero.
TYINcCashreceipttrancodeIYReceipt Type code (10,11,15,16,17,25,26 or 27).
RMKszNameremarkINRemark.
MCU2szCostcenter2INBusiness Unit 2.
AAmnMaxAutoDRWriteOffAmtIYMax amount that can be automatically written off.
Debit amount.
ARszAutoDRWriteOffReasonCodeIYReason code to be used for a automatic write off.
Debit amount.
AAmnMaxAutoCRWriteOffAmtIYMax amount that can be automatically written off.
Credit amount must be passed in with - sign.
ARszAutoCRWriteOffReasonCodeIYReason code to be used for a automatic write off.
Credit amount.
EV01cAllowPayHeldInvIYEnter a 1 to not allow payment of invoices at status
not equal to "A".
CRCDszReceiptBaseCurrencycodeIYBase currency of the receipt.
EV02cErrorFlagO '1' if errors were found.
AAPmnDomAmountAppliedIYAmount in domestic currency to be applied to Invoice.
Can be left BLANK if Transaction Amounts are passed and cCurrencyConvertYN is EQ 1. The function will
calculate the domestic amount and pass it back to the calling function
ADSAmnDomDiscTakenIYDiscount Amount in domestic currency to be applied to
Invoice. Can be left BLANK if Transaction Amounts are passed and cCurrencyConvertYN is EQ 1. The
function will calculate the domestic amount and pass it back to the calling function
PSTcDDDefaultPaystscodeIYDefault pay status to use on on invoice if not closed
Open amount NEQ Zero.
EV01cSkipAutoWriteOffINSet to '1' to bypass automatic write-off processing.
AAmnMaxManDRWriteOffAmtIYMax amount that can be manually written off. Debit
amount.
AAmnMaxManCRwriteOffAmtIYMax amount that can be manually written off. Credit
amount must be passed in with - sign.
DGJjdGLDateIYG/L date of the transaction.
ARszAdjustmentReasonCodeIYReason code to be used for the manual write off.
Required if there is a adjustment amount.
PIDszProgramidINProgram ID to update transaction audit infor. If not
passed, business function source name will be used.
AAmnChargebackDomesticAmtIYChargeback Amount in domestic currency to be applied
to Invoice. Can be left BLANK if Transaction Amounts are passed and cCurrencyConvertYN is EQ 1. The
function will calculate the domestic amount and pass it back to the calling function
AAmnChargebackForeignAmtIYChargeback Amount in foreign currency to be applied
to Invoice. Can be left BLANK if Transaction Amounts are passed and cCurrencyConvertYN is EQ 1. The
function will calculate the foreign amount and pass it back to the calling function
RMKszChargebackRemarkINRemark to output to chargeback. Required for
Chargeback transactions only.
CRCDszChargebackCcyINCurrency code of the Chargeback transaction. Required
for Chargeback transactions only.
CRRmnChargebackExchRateINExchange rate. Required for Chargeback transactions
only.
COszChargebackCoINCompany number to use in creation of RB-chargeback or
R5- deduction invoices. Also used for account number of the writeoffs. Required for writeoff,
chargeback and deduction transactions only.
GLCszChargebackGLOffsetING/L Offset for Chargeback. Used in creation of RB-
chargeback invoices. Required for Chargeback transactions only.
MCUszChargebackMCUINBusiness Unit. Used in creation of RB- chargeback
invoices. Required for Chargeback transactions only.
PSTcChargebackDefaultPaystsINDefault Pay Status for the Chargeback. Used in
creation of RB- chargeback invoices. If BLANK Data Dictionary will default.
AAAJmnDomAmountAdjustmentsIYDomestic write-off amount. Can be left BLANK if
Transaction Amounts are passed and cCurrencyConvertYN is EQ 1. The function will calculate the domestic
amount and pass it back to the calling function
FCHGmnForAmountAdjustmentsINForeign write-off amount. Can be left BLANK if
Transaction Amounts are passed and cCurrencyConvertYN is EQ 1. The function will calculate the foreign
amount and pass it back to the calling function
ECBRszChargebackreasoncodeINReason code. Required for Chargeback transactions
only.
DGJcChargebackDefaultDatesING/L Date. Required for Chargeback.
AN8mnAddressnumberIYCustomer number from F03B11 invoice.
DDAmnDeductionAmountIYDomestic Deduction amount. Can be left BLANK if
Transaction Amounts are passed and cCurrencyConvertYN is EQ 1. The function will calculate the domestic
amount and pass it back to the calling function
FDAmnForeignDeductionAmountIYForeign Deduction amount. Can be left BLANK if
Transaction Amounts are passed and cCurrencyConvertYN is EQ 1. The function will calculate the foreign
amount and pass it back to the calling function
DDEXszReasonCodeforDeductionINReason code for deduction. Required if deduction
amount is not zero.
DAIDszDeductionAccountIDING/L short account ID for deduction. Required if
deduction amount is not zero.
AIDDszDiscountAccountIDING/L short account ID for Discount. Required if
discount taken is not zero.
AIDWszWriteOffAccountIDING/L short account ID for Write off. Required if
write-off amount is not zero.
UTICszUserTypeInputCodeIYThe UDC code 03B/RE for the transaction.
AIDCszAccountIDGLChargebackING/L short account ID for Chargeback. Required if
chargeback amount is not zero.
TAAPmnTransactionPaymntAmountINTransaction Amount to be applied to Invoice in
transaction currency. Required if transaction is alternate currency. If field is BLANK then Foreign and
Domestic payment amounts must be passed. If BLANK function will calculate transaction amounts based on
receipt.
TADAmnTransactionDiscountAmountINTransaction Discount Amount to be applied to Invoice
in transaction currency. Required if transaction is alternate currency. If field is BLANK then Foreign
and Domestic discount amounts must be passed. If BLANK function will calculate transaction amounts
based on receipt.
TAAJmnTransactionWriteOffAmountINTransaction Write off Amount to be applied to Invoice
in transaction currency. Required if transaction is alternate currency. If field is BLANK then
Foreign and Domestic write off amounts must be passed. If BLANK function will calculate transaction amounts
based on receipt.
TCBAmnTransactionChargeBackAmountINTransaction Chargeback Amount to be applied to
Invoice in transaction currency. Required if transaction is alternate currency. If field is BLANK then
Foreign and Domestic chargeback amounts must be passed. If BLANK function will calculate transaction
amounts based on receipt.
TDAmnTransactionDeductionAmountINTransaction Deduction Amount to be applied to Invoice
in transaction currency. Required if transaction is alternate currency. If field is BLANK then
Foreign and Domestic deduction amounts must be passed. If BLANK function will calculate transaction amounts
based on receipt.
TCRCszTransactionCurrencyCodeINTransaction Currency code. Required if transaction is
alternate currency.
ACRRmnAlternateCurrencyExchangeRINAlternate currency exchange rate. Exchange rate
between receipt currency and the Invoice currency. Required if transaction is alternate currency.
ACR1mnAlternateCurrencyRateLeg1INAlternate currency exchange rate leg 1. Required if
transaction is alternate currency.
ACR2mnAlternateCurrencyRateLeg2INAlternate currency exchange rate leg 2. Required if
transaction is alternate currency.
ACRMcAltCurrencyConversionMethodINConversion method used for alternate currency
transaction. Required if alternate currency.
EV01cCurrencyConvertYNIN1- function will calculate the Foreign and Domestic
amounts based on the transaction amounts and Invoice being applied.
VR01szReference1INCustomer reference will be output to the F03B14
record created. If BLANK the F03B11 VR01 will be used if F03B11 KCO, DCT, DOC and SFX passed.
RIDCcReferenceIdCodeINDeduction reference ID code will be output to F03B14
record.
POszPurchaseOrderDocNumberIN
PDCTszPurchaseOrderDocTypeIN
PKCOszPurchaseOrderDocCompanyIN
UNITszUnitNumberIN
AIDTszGainAccountIDINPass if creating a foreign or alternate currency
receipt. If blank, will default from the 'RG' AAI.
AIDTszLossAccountIDINPass if creating a foreign or alternate currency
receipt. If blank, will default from the 'RL' AAI.'1a'1a
D03B0012 - F03B14 Apply Receipt to Invoice
Parameters
Item Description I/O Req? Notes
ACTN cAddOrUpdateFlag I Y 'A' to add record. 'U' to update a
record.
PYID mnPaymentid I Y Payment ID of Receipt Header.
RC5 mnFilelineidentifier50 I Y Line Number of the transaction with in a Payment ID group. Required for
Updates. Must zero on Adds.
KCO szCompanykey I Y Document Key Company of Invoice being applied. Required if transaction is a Invoice
match.
DOC mnDocvoucherinvoicee I Y Document Number of Invoice being applied. Required if transaction is a Invoice
match.
DCT szDocumenttype I Y Document Type of Invoice being applied. Required if transaction is a Invoice match.
SFX szDocumentpayitem I Y Pay Item of
Invoice being applied. Required if transaction is a Invoice match.
ICUT szBatchtype I Y Batch Type for the batch. This is the ICUT in
F03B14.
ICU mnBatchnumber I Y Batch Number for the batch. This is the ICU in F03B14.
DICJ jdDatebatchjulian I Y Batch Date of Transaction. This is
the DICJ in F03B14.
FAP mnForeignAmountApplied I Y Amount in foreign currency to be applied to the Invoice. Can be left BLANK if
Transaction Amounts are passed and cCurrencyConvertYN is EQ 1. The function will calculate the foreign amount and pass it back to the calling
function
CDSA mnForeigndiscounttaken I Y Discount amount in foreign currency to be applied to the Invoice. Can be left BLANK if Transaction
Amounts are passed and cCurrencyConvertYN is EQ 1. The function will calculate the foreign amount and pass it back to the calling
function.
RSCO szReasoncode I N Reason code for the writeoff. Required if write-off amount is not zero.
TYIN cCashreceipttrancode I Y Receipt Type
code (10,11,15,16,17,25,26 or 27).
RMK szNameremark I N Remark.
MCU2 szCostcenter2 I N Business Unit
2.
AA mnMaxAutoDRWriteOffAmt I Y Max amount that can be automatically written off. Debit amount.
AR szAutoDRWriteOffReasonCode I Y Reason code to be used for a
automatic write off. Debit amount.
AA mnMaxAutoCRWriteOffAmt I Y Max amount that can be automatically written off. Credit amount must be
passed in with - sign.
AR szAutoCRWriteOffReasonCode I Y Reason code to be used for a automatic write off. Credit
amount.
EV01 cAllowPayHeldInv I Y Enter a 1 to not allow payment of invoices at status not equal to "A".
CRCD szReceiptBaseCurrencycode I Y Base currency of the
receipt.
EV02 cErrorFlag O '1' if errors were found.
AAP mnDomAmountApplied I Y Amount in domestic currency to be applied to Invoice.
Can be left BLANK if Transaction Amounts are passed and cCurrencyConvertYN is EQ 1. The function will calculate the domestic amount
and pass it back to the calling function
ADSA mnDomDiscTaken I Y Discount Amount in domestic currency to be applied to Invoice. Can be left
BLANK if Transaction Amounts are passed and cCurrencyConvertYN is EQ 1. The function will calculate the domestic amount and pass it
back to the calling function
PST cDDDefaultPaystscode I Y Default pay status to use on on invoice if not closed Open amount NEQ
Zero.
EV01 cSkipAutoWriteOff I N Set to '1' to bypass automatic write-off processing.
AA mnMaxManDRWriteOffAmt I Y Max amount that can be
manually written off. Debit amount.
AA mnMaxManCRwriteOffAmt I Y Max amount that can be manually written off. Credit amount must be passed in
with - sign.
DGJ jdGLDate I Y G/L date of the transaction.
AR szAdjustmentReasonCode I Y Reason code to be used for the manual write
off. Required if there is a adjustment amount.
PID szProgramid I N Program ID to update transaction audit infor. If not passed, business
function source name will be used.
AA mnChargebackDomesticAmt I Y Chargeback Amount in domestic currency to be applied to Invoice. Can be
left BLANK if Transaction Amounts are passed and cCurrencyConvertYN is EQ 1. The function will calculate the domestic amount and pass
it back to the calling function
AA mnChargebackForeignAmt I Y Chargeback Amount in foreign currency to be applied to Invoice. Can be left
BLANK if Transaction Amounts are passed and cCurrencyConvertYN is EQ 1. The function will calculate the foreign amount and pass it
back to the calling function
RMK szChargebackRemark I N Remark to output to chargeback. Required for Chargeback transactions
only.
CRCD szChargebackCcy I N Currency code of the Chargeback transaction. Required for Chargeback transactions
only.
CRR mnChargebackExchRate I N Exchange rate. Required for Chargeback transactions only.
CO szChargebackCo I N Company number to use in creation of
RB-chargeback or R5- deduction invoices. Also used for account number of the writeoffs. Required for writeoff, chargeback and deduction
transactions only.
GLC szChargebackGLOffset I N G/L Offset for Chargeback. Used in creation of RB- chargeback invoices. Required for
Chargeback transactions only.
MCU szChargebackMCU I N Business Unit. Used in creation of RB- chargeback invoices. Required for Chargeback
transactions only.
PST cChargebackDefaultPaysts I N Default Pay Status for the Chargeback. Used in creation of RB- chargeback invoices. If
BLANK Data Dictionary will default.
AAAJ mnDomAmountAdjustments I Y Domestic write-off amount. Can be left BLANK if Transaction
Amounts are passed and cCurrencyConvertYN is EQ 1. The function will calculate the domestic amount and pass it back to the calling
function
FCHG mnForAmountAdjustments I N Foreign write-off amount. Can be left BLANK if Transaction Amounts are passed and cCurrencyConvertYN
is EQ 1. The function will calculate the foreign amount and pass it back to the calling function
ECBR szChargebackreasoncode I N Reason
code. Required for Chargeback transactions only.
DGJ cChargebackDefaultDates I N IF 1- use invoice dates for RB invoice. Else use
receipt date for RB invoice. Required for Chargeback.
AN8 mnAddressnumber I Y Customer number from F03B11
invoice.
DDA mnDeductionAmount I Y Domestic Deduction amount. Can be left BLANK if Transaction Amounts are passed and cCurrencyConvertYN is EQ 1. The function
will calculate the domestic amount and pass it back to the calling function
FDA mnForeignDeductionAmount I Y Foreign Deduction amount.
Can be left BLANK if Transaction Amounts are passed and cCurrencyConvertYN is EQ 1. The function will calculate the foreign amount and
pass it back to the calling function
DDEX szReasonCodeforDeduction I N Reason code for deduction. Required if deduction amount is not
zero.
DAID szDeductionAccountID I N G/L short account ID for deduction. Required if deduction amount is not
zero.
AIDD szDiscountAccountID I N G/L short account ID for Discount. Required if discount taken is not zero.
AIDW szWriteOffAccountID I N G/L short account ID for Write off.
Required if write-off amount is not zero.
UTIC szUserTypeInputCode I Y The UDC code 03B/RE for the
transaction.
AIDC szAccountIDGLChargeback I N G/L short account ID for Chargeback. Required if chargeback amount is not
zero.
TAAP mnTransactionPaymntAmount I N Transaction Amount to be applied to Invoice in transaction currency. Required if transaction is alternate currency. If field is BLANK then Foreign and
Domestic payment amounts must be passed. If BLANK function will calculate transaction amounts based on
receipt.
TADA mnTransactionDiscountAmount I N Transaction Discount Amount to be applied to Invoice in transaction currency. Required if transaction is alternate
currency. If field is BLANK then Foreign and Domestic discount amounts must be passed. If BLANK function will calculate transaction amounts based
on receipt.
TAAJ mnTransactionWriteOffAmount I N Transaction Write off Amount to be applied to Invoice in transaction currency. Required
if transaction is alternate currency. If field is BLANK then Foreign and Domestic write off amounts must be passed. If BLANK function will
calculate transaction amounts based on receipt.
TCBA mnTransactionChargeBackAmount I N Transaction Chargeback Amount to be applied
to Invoice in transaction currency. Required if transaction is alternate currency. If field is BLANK then Foreign and Domestic chargeback
amounts must be passed. If BLANK function will calculate transaction amounts based on
receipt.
TDA mnTransactionDeductionAmount I N Transaction Deduction Amount to be applied to Invoice in transaction currency. Required if transaction is alternate currency. If field is BLANK then
Foreign and Domestic deduction amounts must be passed. If BLANK function will calculate transaction amounts based on
receipt.
TCRC szTransactionCurrencyCode I N Transaction Currency code. Required if transaction is alternate
currency.
ACRR mnAlternateCurrencyExchangeR I N Alternate currency exchange rate. Exchange rate between receipt currency and the Invoice currency. Required if transaction is
alternate currency.
ACR1 mnAlternateCurrencyRateLeg1 I N Alternate currency exchange rate leg 1. Required if transaction is alternate
currency.
ACR2 mnAlternateCurrencyRateLeg2 I N Alternate currency exchange rate leg 2. Required if transaction is alternate
currency.
ACRM cAltCurrencyConversionMethod I N Conversion method used for alternate currency transaction. Required if alternate
currency.
EV01 cCurrencyConvertYN I N 1- function will calculate the Foreign and Domestic amounts based on the transaction amounts and Invoice being
applied.
VR01 szReference1 I N Customer reference will be output to the F03B14 record created. If BLANK the F03B11 VR01 will be used if F03B11 KCO,
DCT, DOC and SFX passed.
RIDC cReferenceIdCode I N Deduction reference ID code will be output to F03B14 record.
^
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
cAddOrUpdateFlag | ACTN | char | OPT | NONE |
Parameters Item Description I/O Req? Notes ACTN cAddOrUpdateFlag I Y 'A' to add record. 'U' to update a record. ^ | ||||
mnPaymentid | PYID | MATH_NUMERIC | OPT | NONE |
Parameters Item Description I/O Req? Notes PYID mnPaymentid I Y Payment ID of Receipt Header. ^ | ||||
mnFilelineidentifier50 | RC5 | MATH_NUMERIC | OPT | NONE |
Parameters
Item Description I/O Req? Notes
RC5 mnFilelineidentifier50 I Y Line Number of the transaction with in a Payment ID group.
| ||||
szCompanykey | KCO | char | OPT | NONE |
Parameters
Item Description I/O Req? Notes
KCO szCompanykey I Y Document Key Company of Invoice being applied. Required if
| ||||
mnDocvoucherinvoicee | DOC | MATH_NUMERIC | OPT | NONE |
Parameters
Item Description I/O Req? Notes
DOC mnDocvoucherinvoicee I Y Document Number of Invoice being applied. Required if
| ||||
szDocumenttype | DCT | char | OPT | NONE |
Parameters
Item Description I/O Req? Notes
DCT szDocumenttype I Y Document Type of Invoice being applied. Required if transaction is
| ||||
szDocumentpayitem | SFX | char | OPT | NONE |
Parameters
Item Description I/O Req? Notes
SFX szDocumentpayitem I Y Pay Item of Invoice being applied. Required if transaction is a
| ||||
szBatchtype | ICUT | char | OPT | NONE |
Parameters Item Description I/O Req? Notes ICUT szBatchtype I Y Batch Type for the batch. This is the ICUT in F03B14. ^ | ||||
mnBatchnumber | ICU | MATH_NUMERIC | OPT | NONE |
Parameters Item Description I/O Req? Notes ICU mnBatchnumber I Y Batch Number for the batch. This is the ICU in F03B14. ^ | ||||
jdDatebatchjulian | DICJ | JDEDATE | OPT | NONE |
Parameters Item Description I/O Req? Notes DICJ jdDatebatchjulian I Y Batch Date of Transaction. This is the DICJ in F03B14. ^ | ||||
mnForeignAmountApplied | FAP | MATH_NUMERIC | OPT | NONE |
Parameters
Item Description I/O Req? Notes
FAP mnForeignAmountApplied I Y Amount in foreign currency to be applied to the Invoice.
| ||||
mnForeigndiscounttaken | CDSA | MATH_NUMERIC | OPT | NONE |
Parameters
Item Description I/O Req? Notes
CDSA mnForeigndiscounttaken I Y Discount amount in foreign currency to be applied to the
| ||||
szReasncode | RSCO | char | OPT | NONE |
Parameters
Item Description I/O Req? Notes
RSCO szReasoncode I N Reason code for the writeoff. Required if write-off amount is not
| ||||
cCashreceipttrancode | TYIN | char | OPT | NONE |
Parameters Item Description I/O Req? Notes TYIN cCashreceipttrancode I Y Receipt Type code (10,11,15,16,17,25,26 or 27). ^ | ||||
szNameremark | RMK | char | OPT | NONE |
Parameters Item Description I/O Req? Notes RMK szNameremark I N Remark. ^ | ||||
szBusinessUnit2 | MCU2 | char | OPT | NONE |
Parameters Item Description I/O Req? Notes MCU2 szCostcenter2 I N Business Unit 2. ^ | ||||
mnMaxAutoDRWriteOffAmt | AA | MATH_NUMERIC | OPT | NONE |
Parameters
Item Description I/O Req? Notes
AA mnMaxAutoDRWriteOffAmt I Y Max amount that can be automatically written off. Debit
| ||||
szAutoDRWriteOffReasonCode | AR | char | OPT | NONE |
Parameters
Item Description I/O Req? Notes
AR szAutoDRWriteOffReasonCode I Y Reason code to be used for a automatic write off.
| ||||
mnMaxAutoCRWriteOffAmt | AA | MATH_NUMERIC | OPT | NONE |
Parameters
Item Description I/O Req? Notes
AA mnMaxAutoCRWriteOffAmt I Y Max amount that can be automatically written off. Credit
| ||||
szAutoCRWriteOffReasonCode | AR | char | OPT | NONE |
Parameters
Item Description I/O Req? Notes
AR szAutoCRWriteOffReasonCode I Y Reason code to be used for a automatic write off.
| ||||
cAllowPayHeldInv | EV01 | char | OPT | NONE |
Parameters
Item Description I/O Req? Notes
EV01 cAllowPayHeldInv I Y Enter a 1 to not allow payment of invoices at status not equal to
| ||||
szReceiptBaseCurrencycode | CRCD | char | OPT | NONE |
Parameters Item Description I/O Req? Notes CRCD szReceiptBaseCurrencycode I Y Base currency of the receipt. ^ | ||||
cErrorFlag | EV02 | char | OPT | NONE |
Parameters Item Description I/O Req? Notes EV02 cErrorFlag O '1' if errors were found. ^ | ||||
mnDomAmountApplied | AAP | MATH_NUMERIC | OPT | NONE |
Parameters
Item Description I/O Req? Notes
AAP mnDomAmountApplied I Y Amount in domestic currency to be applied to Invoice. Can
| ||||
mnDomDiscTaken | ADSA | MATH_NUMERIC | OPT | NONE |
Parameters
Item Description I/O Req? Notes
ADSA mnDomDiscTaken I Y Discount Amount in domestic currency to be applied to Invoice.
| ||||
cDDDefaultPaystscode | PST | char | OPT | NONE |
Parameters
Item Description I/O Req? Notes
PST cDDDefaultPaystscode I Y Default pay status to use on on invoice if not closed Open
| ||||
cSkipAutoWriteOff | EV01 | char | OPT | NONE |
Parameters Item Description I/O Req? Notes EV01 cSkipAutoWriteOff I N Set to '1' to bypass automatic write-off processing. ^ | ||||
mnMaxManDRWriteOffAmt | AA | MATH_NUMERIC | OPT | NONE |
Parameters
Item Description I/O Req? Notes
AA mnMaxManDRWriteOffAmt I Y Max amount that can be manually written off. Debit
| ||||
mnMaxManCRwriteOffAmt | AA | MATH_NUMERIC | OPT | NONE |
Parameters
Item Description I/O Req? Notes
AA mnMaxManCRwriteOffAmt I Y Max amount that can be manually written off. Credit amount
| ||||
jdGLDate | DGJ | JDEDATE | OPT | NONE |
Parameters Item Description I/O Req? Notes DGJ jdGLDate I Y G/L date of the transaction. ^ | ||||
szAdjustmentReasonCode | AR | char | OPT | NONE |
Parameters
Item Description I/O Req? Notes
AR szAdjustmentReasonCode I Y Reason code to be used for the manual write off. Required
| ||||
szProgramid | PID | char | OPT | NONE |
Parameters
Item Description I/O Req? Notes
PID szProgramid I N Program ID to update transaction audit infor. If not passed, business
| ||||
mnChargebackDomesticAmt | AA | MATH_NUMERIC | OPT | NONE |
Parameters
Item Description I/O Req? Notes
AA mnChargebackDomesticAmt I Y Chargeback Amount in domestic currency to be applied
| ||||
mnChargebackForeignAmt | AA | MATH_NUMERIC | OPT | NONE |
Parameters
Item Description I/O Req? Notes
AA mnChargebackForeignAmt I Y Chargeback Amount in foreign currency to be applied to
| ||||
szChargebackRemark | RMK | char | OPT | NONE |
Parameters
Item Description I/O Req? Notes
RMK szChargebackRemark I N Remark to output to chargeback. Required for Chargeback
| ||||
szChargebackCcy | CRCD | char | OPT | NONE |
Parameters
Item Description I/O Req? Notes
CRCD szChargebackCcy I N Currency code of the Chargeback transaction. Required for
| ||||
mnChargebackExchRate | CRR | MATH_NUMERIC | OPT | NONE |
Parameters
Item Description I/O Req? Notes
CRR mnChargebackExchRate I N Exchange rate. Required for Chargeback transactions
| ||||
szChargebackCo | CO | char | OPT | NONE |
Parameters
Item Description I/O Req? Notes
CO szChargebackCo I N Company number to use in creation of RB-chargeback or R5-
| ||||
szChargebackGLOffset | GLC | char | OPT | NONE |
Parameters
Item Description I/O Req? Notes
GLC szChargebackGLOffset I N G/L Offset for Chargeback. Used in creation of RB-
| ||||
szChargebackMCU | MCU | char | OPT | NONE |
Parameters
Item Description I/O Req? Notes
MCU szChargebackMCU I N Business Unit. Used in creation of RB- chargeback invoices.
| ||||
cChargebackDefaultPaysts | PST | char | OPT | NONE |
Parameters
Item Description I/O Req? Notes
PST cChargebackDefaultPaysts I N Default Pay Status for the Chargeback. Used in creation
| ||||
mnDomAmountAdjustments | AAAJ | MATH_NUMERIC | OPT | NONE |
Parameters
Item Description I/O Req? Notes
AAAJ mnDomAmountAdjustments I Y Domestic write-off amount. Can be left BLANK if
| ||||
mnForAmountAdjustments | FCHG | MATH_NUMERIC | OPT | NONE |
Parameters
Item Description I/O Req? Notes
FCHG mnForAmountAdjustments I N Foreign write-off amount. Can be left BLANK if
| ||||
szChargebackreasoncode | ECBR | char | OPT | NONE |
Parameters
Item Description I/O Req? Notes
ECBR szChargebackreasoncode I N Reason code. Required for Chargeback transactions
| ||||
cChargebackDefaultDates | EV03 | char | OPT | NONE |
Parameters
Item Description I/O Req? Notes
EV03 cChargebackDefaultDates I N IF 1 use invoice date for RB invoice. Else use receipt
| ||||
mnAddressnumber | AN8 | MATH_NUMERIC | OPT | NONE |
Parameters Item Description I/O Req? Notes AN8 mnAddressnumber I Y Customer number from F03B11 invoice. ^ | ||||
mnDeductionAmount | DDA | MATH_NUMERIC | OPT | NONE |
Parameters
Item Description I/O Req? Notes
DDA mnDeductionAmount I Y Domestic Deduction amount. Can be left BLANK if Transaction
| ||||
mnForeignDeductionAmount | FDA | MATH_NUMERIC | OPT | NONE |
Parameters
Item Description I/O Req? Notes
FDA mnForeignDeductionAmount I Y Foreign Deduction amount. Can be left BLANK if
| ||||
szReasonCodeforDeduction | DDEX | char | OPT | NONE |
Parameters
Item Description I/O Req? Notes
DDEX szReasonCodeforDeduction I N Reason code for deduction. Required if deduction
| ||||
szDeductionAccountId | DAID | char | OPT | NONE |
Parameters
Item Description I/O Req? Notes
DAID szDeductionAccountID I N G/L short account ID for deduction. Required if deduction
| ||||
szDiscountAccountID | AIDD | char | OPT | NONE |
Parameters
Item Description I/O Req? Notes
AIDD szDiscountAccountID I N G/L short account ID for Discount. Required if discount taken
| ||||
szWriteOffAccountID | AIDW | char | OPT | NONE |
Parameters
Item Description I/O Req? Notes
AIDW szWriteOffAccountID I N G/L short account ID for Write off. Required if write-off amount
| ||||
szUserTypeInputCode | UTIC | char | OPT | NONE |
Parameters Item Description I/O Req? Notes UTIC szUserTypeInputCode I Y The UDC code 03B/RE for the transaction. ^ | ||||
szAccountIDGLChargeback | AIDC | char | OPT | NONE |
Parameters
Item Description I/O Req? Notes
AIDC szAccountIDGLChargeback I N G/L short account ID for Chargeback. Required if
| ||||
mnTransactionPaymntAmount | TAAP | MATH_NUMERIC | OPT | BOTH |
Parameters
Item Description I/O Req? Notes
TAAP mnTransactionPaymntAmount I N Transaction Amount to be applied to Invoice in
| ||||
mnTransactionDiscountAmount | TADA | MATH_NUMERIC | OPT | BOTH |
Parameters
Item Description I/O Req? Notes
TADA mnTransactionDiscountAmount I N Transaction Discount Amount to be applied to
| ||||
mnTransactionWriteOffAmount | TAAJ | MATH_NUMERIC | OPT | BOTH |
Parameters
Item Description I/O Req? Notes
TAAJ mnTransactionWriteOffAmount I N Transaction Write off Amount to be applied to
| ||||
mnTransactionChargeBackAmount | TCBA | MATH_NUMERIC | OPT | BOTH |
Parameters
Item Description I/O Req? Notes
TCBA mnTransactionChargeBackAmount I N Transaction Chargeback Amount to be
| ||||
mnTransactionDeductionAmount | TDA | MATH_NUMERIC | OPT | BOTH |
Parameters
Item Description I/O Req? Notes
TDA mnTransactionDeductionAmount I N Transaction Deduction Amount to be applied to
| ||||
szTransactionCurrencyCode | TCRC | char | OPT | BOTH |
Parameters
Item Description I/O Req? Notes
TCRC szTransactionCurrencyCode I N Transaction Currency code. Required if transaction is
| ||||
mnAlternateCurrencyExchangeRat | ACRR | MATH_NUMERIC | OPT | BOTH |
Parameters
Item Description I/O Req? Notes
ACRR mnAlternateCurrencyExchangeR I N Alternate currency exchange rate. Exchange rate
| ||||
mnAlternateCurrencyRateLeg1 | ACR1 | MATH_NUMERIC | OPT | BOTH |
Parameters
Item Description I/O Req? Notes
ACR1 mnAlternateCurrencyRateLeg1 I N Alternate currency exchange rate leg 1. Required if
| ||||
mnAlternateCurrencyRateLeg2 | ACR2 | MATH_NUMERIC | OPT | BOTH |
Parameters
Item Description I/O Req? Notes
ACR2 mnAlternateCurrencyRateLeg2 I N Alternate currency exchange rate leg 2. Required if
| ||||
cAltCurrencyConversionMethod | ACRM | char | OPT | BOTH |
Parameters
Item Description I/O Req? Notes
ACRM cAltCurrencyConversionMethod I N Conversion method used for alternate currency
| ||||
cCurrencyConvertYN | EV01 | char | OPT | BOTH |
Parameters
Item Description I/O Req? Notes
EV01 cCurrencyConvertYN I N 1- function will calculate the Foreign and Domestic amounts
| ||||
szReference1 | VR01 | char | OPT | NONE |
Parameters
Item Description I/O Req? Notes
VR01 szReference1 I N Customer reference will be output to the F03B14 record created. If
| ||||
cReferenceIdCode | RIDC | char | OPT | NONE |
Parameters Item Description I/O Req? Notes RIDC cReferenceIdCode I N Deduction reference ID code will be output to F03B14 record. ^ | ||||
szPurchaseOrderDocNumber | PO | char | OPT | INPUT |
A document that authorizes the delivery of specified merchandise or the rendering of certain services. | ||||
szPurchaseOrderDocType | PDCT | char | OPT | INPUT |
A value that is hard-coded in the originating programs and passed to the Accounts Payable system.
In Accounts Receivable, the document
| ||||
szPurchaseOrderDocCompany | PKCO | char | OPT | INPUT |
For purchase orders, a code that differentiates a record from another with the same document number, document type, and G/L date.
If you
| ||||
szUnitNumber | UNIT | char | OPT | INPUT |
The number that identifies the actual space within a building that is or can be leased, such as an apartment, office, retail space, parking
| ||||
szGainAccountID | AIDT | char | OPT | INPUT |
A unique identification number that contains account information for the foreign currency gain or loss account that the system uses when you
| ||||
szLossAccountID | AIDT | char | OPT | INPUT |
A unique identification number that contains account information for the foreign currency gain or loss account that the system uses when you
| ||||
szAltCurrGainAccountID | AIDA | char | OPT | INPUT |
A unique identification number that contains account information for the alternate currency gain or loss account that the system uses when it
| ||||
szAltCurrLossAccountID | AIDA | char | OPT | INPUT |
A unique identification number that contains account information for the alternate currency gain or loss account that the system uses when it
| ||||
szDiscountReasonCode | DRCO | char | OPT | NONE |
A code that specifies the reason that a discount is given. | ||||
mnNetTransactionID | NETTCID | MATH_NUMERIC | OPT | NONE |
A number that identifies a netting transaction. The system assigns it using the Next Numbers program (P0002). A netting transaction could
| ||||
mnNetDocNumber | NETDOC | MATH_NUMERIC | OPT | NONE |
A number that the system uses to cross reference netting source documents from which netting transfer and netting result documents are
| ||||
mnNetLineID | NETRC5 | MATH_NUMERIC | OPT | NONE |
A number that identifies the pay item for a netting source document (voucher or invoice). The system assigns this number. If the voucher or
| ||||
cBatchMode | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
idF03B11Handle | GENLNG | ID | OPT | NONE |
General purpose ID variable. | ||||
idF03B11Z2Handle | GENLNG | ID | OPT | NONE |
General purpose ID variable. | ||||
idF03B13Handle | GENLNG | ID | OPT | NONE |
General purpose ID variable. | ||||
idF03B13Z2Handle | GENLNG | ID | OPT | NONE |
General purpose ID variable. | ||||
idF03B14Handle | GENLNG | ID | OPT | NONE |
General purpose ID variable. | ||||
idF03B14Z2Handle | GENLNG | ID | OPT | NONE |
General purpose ID variable. |
B0000027 CurrencyConvForAndDom | ||||
B0000033 Get Exchange Rate | ||||
B0000055 ValidateAAICompletely | ||||
B03B0069 F03B14 Maintain Unapplied Cash | ||||
B03B0174 Get Invoice Exchange Rate For Euro | ||||
B9800100 Get Audit Information | ||||
N0100041 Address Book MBF | ||||
N03B0185 F03012 Get Customer Master | ||||
X0903 Fiscal Date Edits + | ||||
XX0901 Validate Account Number |
F03B11 Customer Ledger | ||||
F03B13 Receipts Header | ||||
F03B14 Receipts Detail |