Functional Description
Purpose
This function is used to maintain receipt detail for Standard Receipt Entry (P03B102) and Draft Entry
(P03B602). This function does not perform any database operations. Instead, this function calls the
F03B14 Apply Receipt to Invoice (B03B0012) function to perform adds and updates to the F03B11, F03B13,
and F03B14 tables. Deletes and voids are handled through the F03B14 Void/Delete Receipt (B03B0023)
function.
Setup Notes and Prerequisites
The Edit Receipt Detail (B03B0149) function must be called to validate the transaction before calling
this function.
Special Logic
If currency is on, only one side of the transaction needs to be passed. The function will perform
currency conversion for the other side of the transaction. For example, if the receipt is entered in
foreign mode, only pass the foreign amounts.
Technical Specification
Parameters
Item DescriptionI/OReq?Notes
PYIDmnPaymentIDIYPayment ID of Receipt Header.
RC5mnFileLineIdentifierIYLine Number of the transaction within a Payment ID
group. Required for updates, ignored on adds.
CKNUszReceiptNumberIY
DOCmnDocumentNumberIYDocument Number of invoice being applied. Required if
transaction is an Invoice Match.
DCTszDocumentTypeIYDocument Type of invoice being applied. Required if
transaction is an Invoice Match.
KCOszDocumentCompanyIYDocument Company of invoice being applied. Required
if transaction is an Invoice Match.
SFXszDocumentPayItemIYPay Item of invoice being applied. Required if
transaction is an Invoice Match.
AN8mnCustomerNumberIY
DGJjdDateGLIY
COszCompanyIY
ICUTszBatchTypeIY
ICUmnBatchNumberIY
DICJjdDateBatchIY
PAAPmnAmountAppliedIYPayment amount. Required if currency is off or
currency mode is domestic.
ADSAmnAmountDiscountTakenIYDiscount Taken. Required if currency is off or
currency mode is domestic.
AAAJmnAmountWriteOffIYWrite-off Amount. Required if currency is off or
currency mode is domestic.
ECBAmnAmountChargebackIYChargeback Amount. Required if currency is off or
currency mode is domestic.
DDAmnAmountDeductionIYDeduction Amount. Required if currency is off or
currency mode is domestic.
BCRCszBaseCurrencyIYCurrency of the company. Required if currency is on.
CRRMcCurrencyModeIYCurrency mode of the receipt (D/F). Required if
currency is on.
CRCDszTransactionCurrencyIYReceipt currency. Required if currency is on.
CRRmnExchangeRateIYExchange rate of the receipt. Required if currency is
on and the mode is foreign.
PFAPmnAmountForeignAppliedIYForeign Payment Amount. Required if mode is foreign.
CDSAmnAmountForeignDiscountTakenIYForeign Discount Amount Taken. Required if currency
mode is foreign.
FCHGmnAmountForeignWriteOffIYForeign Write-off Amount. Required if currency mode
is foreign.
ECBFmnAmountForeignChargebackIYForeign Chargeback Amount. Required if currency mode
is foreign.
FDAmnAmountForeignDeductionIYForeign Deduction Amount. Required if currency mode
is foreign.
AIDDszDiscountAccountIDIYDiscount short account ID. Required if discount taken
is not zero.
RSCOszWriteOffReasonCodeIYRequired if write-off is not zero.
AIDWszWriteOffAccountIDIYWrite-off short account ID. Required if write-off is
not zero.
ECBRszChargebackReasonCodeIYRequired if chargeback amount is not zero.
GLCCszChargebackGLOffsetIYChargeback G/L Offset. Required if chargeback amount
is not zero.
AIDCszChargebackAccountIDIYChargeback short account ID. Required if chargeback
amount is not zero.
DDEXszDeductionReasonCodeIYRequired if deduction amount is not zero.
DAIDszDeductionAccountIDIYDeduction short account ID. Required if deduction
amount is not zero.
UTICszUserTypeInputCodeIYThe transaction code. (UDC table 03B/RE)
MCUszBusinessUnitIY
RMKszRemarkIY
PIDszProgramIDIYProgram calling this function.
AGmnAmountGrossIYInvoice gross amount.
AAPmnAmountOpenIYInvoice open amount.
ADSCmnAmountDiscountAvailIYInvoice discount available.
CRCDszInvoiceTransactionCurrencyIYInvoice currency. Required if currency is on.
CRRmnInvoiceExchangeRateIYInvoice exchange rate. Required for a foreign
invoice.
ACRmnAmountForeignGrossIYInvoice foreign gross amount. Required for a foreign
invoice.
FAPmnAmountForeignOpenIYInvoice foreign open amount. Required for a foreign
invoice.
CDSmnAmountForeignDiscountAvailIYInvoice foreign discount available.
PSTcChargebackPayStatusIYProcessing Option value.
EV01cChargebackDateOptionIYProcessing Option value.
MATH01mnAutoWriteOffUnderAmountIYProcessing Option value.
ARDRszAutoWriteOffUnderReasonCodIYProcessing Option value.
MATH01mnAutoWriteOffOverAmountIYProcessing Option value.
ARCRszAutoWriteOffOverReasonCodeIYProcessing Option value.
MATH01mnManWriteOffUnderAmountIYProcessing Option value.
MATH01mnManWriteOffOverAmountIYProcessing Option value.
EV01cDiscountAllowOverAvailableIYAllow Discount Taken to be greater than Discount
Available. Processing Option value.
EV01cDiscountAllowOverAppliedIYAllow Discount Taken to be greater than Amount
Applied. Processing Option value.
EV01cEditPayApprovedInvoicesIYProcessing Option value.
EV01cEditOverpaymentOptionIYProcessing Option value.
CRRmnReceiptTriangulationRate1IYTriangulated rate component. Required if foreign and
if rate is triangulated.
CRRmnReceiptTriangulationRate2IYTriangulated rate component. Required if foreign and
if rate is triangulated.
CRCMcReceiptConversionMethodIYNo inverse rate component. Required if foreign and
rate is no inverse.
EFTjdReceiptTransactionDateIYEffective date of no inverse or triangulation rate.
Required if rate is no inverse or triangulated.
CRRMcInvoiceCurrencyModeIYInvoice Currency Mode (D/F). Required if invoice is a
foreign invoice.
DIVJjdDateInvoiceJIYInvoice Date.
DGJjdInvoiceGLDate IYInvoice G/L Date.
VR01szReference1IYCustomer Reference.
TAAPmnTransactionPaymntAmountIYReceipt Amount.
TADAmnTransactionDiscountAmountIYReceipt Discount Amount.
TAAJmnTransactionWriteOffAmountIYReceipt Write-off Amount.
TCBAmnTransactionChargeBackAmounIYReceipt Chargeback Amount.
TDAmnTransactionDeductionAmountIYReceipt Deduction Amount.
TCRCszTransactionCurrencyCodeIYReceipt Currency Code.
ACRRmnAlternateCurrencyExchangeRIYExchange Rate between the receipt and invoice
currencies.
ACR1mnAlternateCurrencyRateLeg1IYTriangulated rate component of alternate currency
exchange rate.
ACR2mnAlternateCurrencyRateLeg2IYTriangulated rate component of alternate currency
exchange rate.
ACRMcAltCurrencyConversionMethodIYNo inverse rate component of alternate currency
exchange rate.
AGmnInvTransactionGrossIYInvoice gross amount restated in the receipt
currency.
AAPmnInvTransactionOpenIYInvoice open amount restated in the receipt currency.
ADSCmnInvTransactionDiscAvailIYInvoice discount available restated in the receipt
currency.
POszPurchaseOrderDocNumberIN
PDCTszPurchaseOrderDocTypeIN
PKCOszPurchaseOrderDocCompanyIN
MCU2szBusinessUnit2IN
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.
AIDAszAltCurrGainAccountIDINPass if creating an alternate currency receipt. If
blank, will default from the 'RY' AAI.
AIDAszAltCurrLossAccountIDINPass if creating an alternate currency receipt. If
blank, will default from the 'RZ' AAI.
Related Tables
F03B14Receipt Detail
Related Functions
B0000027Currency Conversion, Calculate
B03B0012F03B14 Write/Update Receipt Detail Record
B03B0174Get Invoice Exchange Rate For Euro
Processing
Retrieve currency constant.
If currency is on and the receipt base currency is different from the
invoice currency,
If a standalone transaction,
Set exchange rate to receipt's exchange rate.
Else,
Set exchange rate to invoice's exchange rate.
If currency mode is foreign,
If foreign discount taken is not zero,
If foreign discount taken is equal to foreign discount
available,
Set domestic discount taken equal to domestic discount
available.
Else,
Convert foreign discount taken to domestic discount taken.
Reduce total domestic and foreign invoice open by amount of
discount taken.
If foreign write-off amount is not zero,
If foreign write-off amount is equal to foreign invoice open,
Set domestic write-off amount equal to domestic invoice
open.
Else,
Convert foreign write-off amount to domestic write-off
amount.
Reduce total domestic and foreign invoice open by amount of
write-off.
If foreign chargeback amount is not zero,
If foreign chargeback amount is equal to foreign invoice open,
Set domestic chargeback amount equal to domestic invoice
open.
Else,
Convert foreign chargeback amount to domestic chargeback
amount.
Reduce total domestic and foreign invoice open by amount of
chargeback.
If foreign deduction amount is not zero,
If foreign deduction amount is equal to foreign invoice open,
Set domestic deduction amount equal to domestic invoice
open.
Else,
Convert foreign deduction amount to domestic deduction
amount.
Reduce total domestic and foreign invoice open by amount of
deduction.
If foreign amount applied is not zero,
If foreign amount applied is equal to foreign invoice open and
the receipt and invoice exchange rates are equal,
Set domestic amount applied equal to domestic invoice open.
Else,
Convert foreign amount applied to domestic amount applied.
Reduce total domestic and foreign invoice open by amount
applied.
Else,
If domestic discount taken is not zero,
If domestic discount taken is equal to domestic discount
available,
Set foreign discount taken equal to foreign discount
available.
Else,
Convert domestic discount taken to foreign discount taken.
Reduce total domestic and foreign invoice open by amount of
discount taken.
If domestic write-off amount is not zero,
If domestic write-off amount is equal to domestic invoice
open,
Set foreign write-off amount equal to foreign invoice open.
Else,
Convert domestic write-off amount to foreign write-off
amount.
Reduce total domestic and foreign invoice open by amount of
write-off.
If domest'1a'1a
D03B0149 - F03B14 Maintain Receipt Detail
Parameters
Item DescriptionI/OReq?Notes
PYIDmnPaymentIDIYPayment ID of Receipt Header.
RC5mnFileLineIdentifierIYLine Number of the
transaction within a Payment
ID group. Required for
Updates,Ignored on Adds.
CKNUszReceiptNumberIYCustomers check Number.
DOCmnDocumentNumberIYDocument Number of Invoice
being applied. Required if
transaction is an Invoice
Match.
DCTszDocumentTypeIYDocument Type of Invoice being
applied.
Required if transaction is an
Invoice Match.
KCOszDocumentCompanyIYDocument Key Company of
Invoice being applied.
Required if transaction is an
Invoice Match.
SFXszDocumentPayItemIYPay Item of Invoice being
applied. Required if
transaction is an Invoice
Match.
AN8mnCustomerNumberIYCustomer Number.
DGJjdDateGLIYReceipt G/L Date.
COszCompanyIYCompany
ICUTszBatchTypeIYReceipt Batch Type
ICUmnBatchNumberIYReceipt Batch Number
DICJjdDateBatchIYReceipt Batch Date
PAAPmnAmountAppliedIYPayment amount . Required if
currency is off or currency
mode is domestic.
ADSAmnAmountDiscountTakenIYDiscount Taken. Required if
currency is off or currency
mode is domestic.
AAAJmnAmountWriteOffIYWrite Off Amount. Required if
currency is off or currency
mode is domestic.
ECBAmnAmountChargebackIYChargeback Amount. Required
if currency is off or
currency mode is domestic.
DDAmnAmountDeductionIYDeduction Amount.Required if
currency is off or currency
mode is domestic.
BCRCszBaseCurrencyIYCurrency of the receipt's
base company.
Required if currency is on.
CRRMcCurrencyModeIYCurrency mode of the receipt (D/F).
Required if currency is on.
CRCDszTransactionCurrencyIYReceipt currency.
Required if currency is on.
CRRmnExchangeRateIYExchange rate of the receipt.
Required if currency is on &
the mode is foreign.
PFAPmnAmountForeignAppliedIYForeign Payment Amount.
Required if mode is foreign.
CDSAmnAmountForeignDiscount IYForeign Discount Amount Taken.
Required if currency mode is
foreign.
FCHGmnAmountForeignWriteOffIYForeign Write Off Amount.
Required if currency mode is
foreign.
ECBFmnAmountForeignChargebaIYForeign Chargeback Amount.
Required if currency mode is
foreign.
FDAmnAmountForeignDeductioIYForeign Deduction Amount.
Required if currency mode is
foreign.
AIDDszDiscountAccountIDIYDiscount G/L account short ID
number.
Required if discount taken is not
zero.
RSCOszWriteOffReasonCodeIYWrite Off Reason Code (UDC table
value)
Required if write-off is not zero.
AIDWszWriteOffAccountIDIYWriteOff G/L account short ID
number.
Required if write-off is not zero.
ECBRszChargebackReasonCodeIYChargeback Reason Code (UDC table
value)Required if chargeback amount
is not zero.
GLCCszChargebackGLOffsetIYChargeback G/L Offset.Required if
chargeback amount is not zero.
AIDCszChargebackAccountIDIYChargeback G/L account short ID
number. Required if chargeback
amount is not zero.
DDEXszDeductionReasonCodeIYDeduction Reason Code. (UDC table
value)Required if deduction amount
is not zero.
DAIDszDeductionAccountIDIYDeduction G/L account short ID
number. Required if deduction
amount is not zero.
UTICszUserTypeInputCodeIYThe transaction code.
(UDC table 03B/RE)
MCUszBusinessUnitIYReceipts Business Unit.
RMKszRemarkIYReceipt Remark field.
PIDszProgramIDIYApplication Program calling this
function.
AGmnAmountGrossIYInvoice gross amount.
AAPmnAmountOpenIYInvoice open amount.
ADSCmnAmountDiscountAvailIYInvoice discount available.
CRCDszInvoiceTransactionCurIYInvoice Currency.
Required if currency is on.
CRRmnInvoiceExchangeRateIYInvoice Exchange rate.
Required for a foreign invoice.
ACRmnAmountForeignGrossIYInvoice foreign gross amount.
Required for a foreign invoice.
FAPmnAmountForeignOpenIYInvoice foreign open amount.
Required for a foreign invoice.
CDSmnAmountForeignDiscountIYInvoice foreign discount available.
PSTcChargebackPayStatusIYChargeback Pay status.
Processing Option value.
EV01cChargebackDateOptionIYChargeback Date Option.
Processing Option value.
MATH01 mnAutoWriteOffUnderAmoIYAuto Writeoff Under Amount.
Processing Option value.
ARDRszAutoWriteOffUnderReasIYAuto Writeoff Under Reason Code
Processing Option value.
MATH01 mnAutoWriteOffOverAmouIYAuto Writeoff Over Amount
Processing Option value.
ARCRszAutoWriteOffOverReasoIYAuto Writeoff Over Reason Code
Processing Option value.
MATH01 mnManWriteOffUnderAmntIYManual W/O Under Amount
Processing Option value.
MATH01 mnManWriteOffOverAmntIYManual W/O Over Amount
Processing Option value.
EV01cDiscountAllowOverAvailIYAllow Discount Taken to be greater
than Discount Available.
Processing Option value.
EV01cDiscountAllowOverAppldIYAllow Discount Taken to be greater
than Amount Applied.
Processing Option value.
EV01cEditPayApprovedInvoicIYEdit for Approved Invoices
Processing Option value.
EV01cEditOverpaymentOptionIYEdit for Over Payment
Processing Option value.
CRRmnReceiptsTriangulatio IYTriangulated rate component.
Required if foreign and if rate is
triangulated
CRRmnReceiptsTriangulati IYTriangulated rate component
Required if foreign and if rate is
triangulated
CRCMcReceiptsConversionMeth IYNo Inverse rate component
Required if foreign & rate is no
Inverse
EFTjdReceiptTransacDate IYEffective date of No Inverse or
Triangulation rate processing.
Required if rate is no inverse or
triangulated .
CRRMcInvoiceCurrencyModeIYInvoice Currency Mode (D/F).
Required if invoice is a foreign
invoice.
DIVJjdDateInvoiceJIYInvoice Date.
DGJjdInvoiceGLDate IYInvoice G/L Date
VR01szReference1IYCustomer Reference.
TAAPmnTransactionPaymentAmtIYReceipt Amount
TADAmnTransactionDiscountAmIYReceipt Discount Amount
TAAJmnTransactionWriteOffAmIYReceipt Write Off Amount
TCBAmnTransactionChargeBackIYReceipt Chargeback Amount
TDAmnTransactionDeductionA IYReceipt Deduction Amount
TCRCszTransactionCurrencyCoIYReceipt Currency Code
ACRRmnAlternateCurrencyExchIYExchange Rate between the Receipt
and the Invoice Currencies.
ACR1mnAltCurrencyRateLeg1IYTriangulated rate component of
Alternate Currency exchange rate.
ACR2mnAltCurrencyRateLeg2IYTriangulated rate component of
Alternate Currency exchange rate.
ACRMcAltCurrencyConversiMthIYNo inverse rate component of
Alternate Currency exchange rate.
AGmnInvTransactionGrossIYInvoice Gross amount restated in
the receipt's Currency.
AAPmnInvTransactionOpenIYInvoice Open amount restated in the
Receipt's Currency
ADSCmnInvTransactionDiscAvlIYInvoice's Discount Available amount
restated in the receipts currency.
^
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
mnPaymentID | PYID | MATH_NUMERIC | NONE | NONE |
Item ab Descriptionab I/Oab Req?ab Notes
| ||||
mnFileLineIdentifier | RC5 | MATH_NUMERIC | NONE | NONE |
Item ab Descriptionab I/Oab Req?ab Notes
| ||||
szReceiptNumber | CKNU | char | NONE | NONE |
Item ab Descriptionab I/Oab Req?ab Notes
| ||||
mnDocumentNumber | DOC | MATH_NUMERIC | NONE | NONE |
Item ab Descriptionab I/Oab Req?ab Notes
| ||||
szDocumentType | DCT | char | NONE | NONE |
Item ab Descriptionab I/Oab Req?ab Notes
| ||||
szDocumentCompany | KCO | char | NONE | NONE |
Item ab Descriptionab I/Oab Req?ab Notes
| ||||
szDocumentPayItem | SFX | char | NONE | NONE |
Item ab Descriptionab I/Oab Req?ab Notes
| ||||
mnCustomerNumber | AN8 | MATH_NUMERIC | NONE | NONE |
Item ab Descriptionab I/Oab Req?ab Notes
| ||||
jdDateGL | DGJ | JDEDATE | NONE | NONE |
Item ab Descriptionab I/Oab Req?ab Notes
| ||||
szCompany | CO | char | NONE | NONE |
Item ab Descriptionab I/Oab Req?ab Notes
| ||||
szBatchType | ICUT | char | NONE | NONE |
Item ab Descriptionab I/Oab Req?ab Notes
| ||||
mnBatchNumber | ICU | MATH_NUMERIC | NONE | NONE |
Item ab Descriptionab I/Oab Req?ab Notes
| ||||
jdDateBatch | DICJ | JDEDATE | NONE | NONE |
Item ab Descriptionab I/Oab Req?ab Notes
| ||||
mnAmountApplied | PAAP | MATH_NUMERIC | NONE | NONE |
Item ab Descriptionab I/Oab Req?ab Notes
| ||||
mnAmountDiscountTaken | ADSA | MATH_NUMERIC | NONE | NONE |
Item ab Descriptionab I/Oab Req?ab Notes
| ||||
mnAmountWriteOff | AAAJ | MATH_NUMERIC | NONE | NONE |
Item ab Descriptionab I/Oab Req?ab Notes
| ||||
mnAmountChargeback | ECBA | MATH_NUMERIC | NONE | NONE |
Item ab Descriptionab I/Oab Req?ab Notes
| ||||
mnAmountDeduction | DDA | MATH_NUMERIC | NONE | NONE |
Item ab Descriptionab I/Oab Req?ab Notes
| ||||
szBaseCurrency | BCRC | char | NONE | NONE |
Item ab Descriptionab I/Oab Req?ab Notes
| ||||
cCurrencyMode | CRRM | char | NONE | NONE |
Item ab Descriptionab I/Oab Req?ab Notes
| ||||
szTransactionCurrency | CRCD | char | NONE | NONE |
Item ab Descriptionab I/Oab Req?ab Notes
| ||||
mnExchangeRate | CRR | MATH_NUMERIC | NONE | NONE |
Item ab Descriptionab I/Oab Req?ab Notes
| ||||
mnAmountForeignApplied | PFAP | MATH_NUMERIC | NONE | NONE |
Item ab Descriptionab I/Oab Req?ab Notes
| ||||
mnAmountForeignDiscountTaken | CDSA | MATH_NUMERIC | NONE | NONE |
Item ab Descriptionab I/Oab Req?ab Notes
| ||||
mnAmountForeignWriteOff | FCHG | MATH_NUMERIC | NONE | NONE |
Item ab Descriptionab I/Oab Req?ab Notes
| ||||
mnAmountForeignChargeback | ECBF | MATH_NUMERIC | NONE | NONE |
Item ab Descriptionab I/Oab Req?ab Notes
| ||||
mnAmountForeignDeduction | FDA | MATH_NUMERIC | NONE | NONE |
Item ab Descriptionab I/Oab Req?ab Notes
| ||||
szDiscountAccountID | AIDD | char | NONE | NONE |
Item ab Descriptionab I/Oab Req?ab Notes
| ||||
szWriteOffReasonCode | RSCO | char | NONE | NONE |
Item ab Descriptionab I/Oab Req?ab Notes
| ||||
szWriteOffAccountID | AIDW | char | NONE | NONE |
Item ab Descriptionab I/Oab Req?ab Notes
| ||||
szChargebackReasonCode | ECBR | char | NONE | NONE |
Item ab Descriptionab I/Oab Req?ab Notes
| ||||
szChargebackGLOffset | GLCC | char | NONE | NONE |
Item ab Descriptionab I/Oab Req?ab Notes
| ||||
szChargebackAccountID | AIDC | char | NONE | NONE |
Item ab Descriptionab I/Oab Req?ab Notes
| ||||
szDeductionReasonCode | DDEX | char | NONE | NONE |
Item ab Descriptionab I/Oab Req?ab Notes
| ||||
szDeductionAccountID | DAID | char | NONE | NONE |
Item ab Descriptionab I/Oab Req?ab Notes
| ||||
szUserTypeInputCode | UTIC | char | NONE | NONE |
Item ab Descriptionab I/Oab Req?ab Notes
| ||||
szBusinessUnit | MCU | char | NONE | NONE |
Item ab Descriptionab I/Oab Req?ab Notes
| ||||
szRemark | RMK | char | NONE | NONE |
Item ab Descriptionab I/Oab Req?ab Notes
| ||||
szProgramID | PID | char | NONE | NONE |
Item ab Descriptionab I/Oab Req?ab Notes
| ||||
mnAmountGross | AG | MATH_NUMERIC | NONE | NONE |
Item ab Descriptionab I/Oab Req?ab Notes
| ||||
mnAmountOpen | AAP | MATH_NUMERIC | NONE | NONE |
Item ab Descriptionab I/Oab Req?ab Notes
| ||||
mnAmountDiscountAvail | ADSC | MATH_NUMERIC | NONE | NONE |
Item ab Descriptionab I/Oab Req?ab Notes
| ||||
szInvoiceTransactionCurrency | CRCD | char | NONE | NONE |
Item ab Descriptionab I/Oab Req?ab Notes
| ||||
mnInvoiceExchangeRate | CRR | MATH_NUMERIC | NONE | NONE |
Item ab Descriptionab I/Oab Req?ab Notes
| ||||
mnAmountForeignGross | ACR | MATH_NUMERIC | NONE | NONE |
Item ab Descriptionab I/Oab Req?ab Notes
| ||||
mnAmountForeignOpen | FAP | MATH_NUMERIC | NONE | NONE |
Item ab Descriptionab I/Oab Req?ab Notes
| ||||
mnAmountForeignDiscountAvail | CDS | MATH_NUMERIC | NONE | NONE |
Item ab Descriptionab I/Oab Req?ab Notes
| ||||
cChargebackPayStatus | PST | char | NONE | NONE |
Item ab Descriptionab I/Oab Req?ab Notes
| ||||
cChargebackDateOption | EV01 | char | NONE | NONE |
Item ab Descriptionab I/Oab Req?ab Notes
| ||||
mnAutoWriteOffUnderAmount | MATH01 | MATH_NUMERIC | NONE | NONE |
Item ab Descriptionab I/Oab Req?ab Notes
| ||||
szAutoWriteOffUnderReasonCode | ARDR | char | NONE | NONE |
Item ab Descriptionab I/Oab Req?ab Notes
| ||||
mnAutoWriteOffOverAmount | MATH01 | MATH_NUMERIC | NONE | NONE |
Item ab Descriptionab I/Oab Req?ab Notes
| ||||
szAutoWriteOffOverReasonCode | ARCR | char | NONE | NONE |
Item ab Descriptionab I/Oab Req?ab Notes
| ||||
mnManWriteOffUnderAmount | MATH01 | MATH_NUMERIC | NONE | NONE |
Item ab Descriptionab I/Oab Req?ab Notes
| ||||
mnManWriteOffOverAmount | MATH01 | MATH_NUMERIC | NONE | NONE |
Item ab Descriptionab I/Oab Req?ab Notes
| ||||
cDiscountAllowOverAvailable | EV01 | char | NONE | NONE |
Item ab Descriptionab I/Oab Req?ab Notes
| ||||
cDiscountAllowOverApplied | EV01 | char | NONE | NONE |
Item ab Descriptionab I/Oab Req?ab Notes
| ||||
cEditPayApprovedInvoices | EV01 | char | NONE | NONE |
Item ab Descriptionab I/Oab Req?ab Notes
| ||||
cEditOverpaymentOption | EV01 | char | NONE | NONE |
Item ab Descriptionab I/Oab Req?ab Notes
| ||||
mnReceiptTriangulationRate1 | CRR | MATH_NUMERIC | OPT | NONE |
Item ab Descriptionab I/Oab Req?ab Notes
| ||||
mnReceiptTriangulationRate2 | CRR | MATH_NUMERIC | OPT | NONE |
Item ab Descriptionab I/Oab Req?ab Notes
| ||||
cReceiptConversionMethod | CRCM | char | OPT | NONE |
Item ab Descriptionab I/Oab Req?ab Notes
| ||||
jdReceiptTransactionDate | EFT | JDEDATE | OPT | NONE |
Item ab Descriptionab I/Oab Req?ab Notes
| ||||
cInvoiceCurrencyMode | CRRM | char | OPT | NONE |
Item ab Descriptionab I/Oab Req?ab Notes
| ||||
szReference1 | VR01 | char | OPT | NONE |
Item ab Descriptionab I/Oab Req?ab Notes
| ||||
mnTransactionPaymntAmount | TAAP | MATH_NUMERIC | OPT | NONE |
Item ab Descriptionab I/Oab Req?ab Notes
| ||||
mnTransactionDiscountAmount | TADA | MATH_NUMERIC | OPT | NONE |
Item ab Descriptionab I/Oab Req?ab Notes
| ||||
mnTransactionWriteOffAmount | TAAJ | MATH_NUMERIC | OPT | NONE |
Item ab Descriptionab I/Oab Req?ab Notes
| ||||
mnTransactionChargeBackAmount | TCBA | MATH_NUMERIC | OPT | NONE |
Item ab Descriptionab I/Oab Req?ab Notes
| ||||
mnTransactionDeductionAmount | TDA | MATH_NUMERIC | OPT | NONE |
Item ab Descriptionab I/Oab Req?ab Notes
| ||||
szTransactionCurrencyCode | TCRC | char | OPT | NONE |
Item ab Descriptionab I/Oab Req?ab Notes
| ||||
mnAlternateCurrencyExchangeRat | ACRR | MATH_NUMERIC | OPT | NONE |
Item ab Descriptionab I/Oab Req?ab Notes
| ||||
mnAlternateCurrencyRateLeg1 | ACR1 | MATH_NUMERIC | OPT | NONE |
Item ab Descriptionab I/Oab Req?ab Notes
| ||||
mnAlternateCurrencyRateLeg2 | ACR2 | MATH_NUMERIC | OPT | NONE |
Item ab Descriptionab I/Oab Req?ab Notes
| ||||
cAltCurrencyConversionMethod | ACRM | char | OPT | NONE |
Item ab Descriptionab I/Oab Req?ab Notes
| ||||
mnInvTransactionGross | AG | MATH_NUMERIC | OPT | NONE |
Item ab Descriptionab I/Oab Req?ab Notes
| ||||
mnInvTransactionOpen | AAP | MATH_NUMERIC | OPT | NONE |
Item ab Descriptionab I/Oab Req?ab Notes
| ||||
mnInvTransactionDiscAvail | ADSC | MATH_NUMERIC | OPT | NONE |
Item ab Descriptionab I/Oab Req?ab Notes
| ||||
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
| ||||
szBusinessUnit2 | MCU2 | char | OPT | INPUT |
An accounting entity, such as a profit center, department, warehouse location, job, project, workcenter, and so on, required for management
| ||||
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
| ||||
jdInvoiceExchangeRateDate | ERDJ | JDEDATE | OPT | NONE |
The date that the system uses to retrieve the exchange rate from the Currency Exchange Rates table (F0015). | ||||
szDiscountReasonCode | DRCO | char | OPT | NONE |
A code that specifies the reason that a discount is given. |
B0000027 CurrencyConvForAndDom | ||||
B03B0012 F03B14 Apply Receipt to Invoice | ||||
B03B0174 Get Invoice Exchange Rate For Euro |
F03B14 Receipts Detail |