Functional Description
Purpose
The F03B11CreateR1RecordDraft creates the R1 record in the F03B11 file.
Setup Notes and Prerequisites
This function is used in P03B602.
Special Logic
Technical Specification
Parameters:
Data Item Data Structure DescriptionI/OReqNotes
DOCmnDocumentVoucherInvoiceEIY
KCOszCompanyKeyIY
AN8mnAddressNumberIY
DGJjdDateForGLandVoucherJulianIY
DIVJjdDateInvoiceJIY
ICUTszBatchTypeIY
ICUmnBatchNumberIY
DICJjdDateBatchJulianIY
FYmnFiscalYear1IY
CTRYmnCenturyIY
PNmnPeriodNoGeneralLedgeIY
COszCompanyIY
GLCszGLClassIY
AIDszAccountIdIY
AGmnAmountGrossIY
BCRCszCurrencyCodeBaseIY
CRRMcCurrencyModeIY
DDJjdDateDueJulianIY
RMKszNameRemarkIY
ALPHszNameAlphaIY
PYIDmnPaymentIDIY
PIDszProgramIdIY
PA8mnAddressNumberParentIY
AN8JmnAddNoAlternatePayeeIY
MCUszCostCenterIY
VLDTjdDateValueIY
AR01szARreportingcode1nIY
AR02szARreportingcode2IY
AR03szARreportingcode3IY
AR04szARreportingcode4IY
AR05szARreportingcode5IY
AR06szARreportingcode6IY
AR07szARreportingcode7IY
AR08szARreportingcode8IY
AR09szARreportingcode9IY
AR10szARreportingcode10IY
BCRCszCurrencyCodeBase_2IY
PSTcPayStatusCodeIY
RYINcPaymentInstrumentAIY
ISTCcARPostToCashManagementIY
CRCDszTransactionCurrencyIY
EV02cR1OpenAmountFlagIY
Related Tables
F03B11Customer Ledger File
Related Business Functions
B03B0008Default Invoice from Address Book
B9800100Get Audit Information
Processing
Open Table F03B11
Fetch record with key company, document type, suffix, document number
If record exists set update mode to 'U'
If record does not exist set mode to 'A'
Copy all the data structure passed in values to the F03B11 fields
If mode is 'A' and the CR1OpenAmountFlag is 1 initialize the open amount field otherwise copy in the
mnAmountGross into the F03B11 open amount field.
If mode is 'U' and the CR1OpenAmount Flag is 1 initialize the open amount field otherwise add the
MnAmountGross to the F03B11 open amount field.
Call business function to get audit information.
If mode is 'A' add record to the F03B11 file.
If mode is 'U' update record in the F03B11 file.
If an error occurs inserting or updating set an error.
Close F03B11 file
D03B0156 - F03B11 Create R1 Record Draft
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
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
| ||||
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,
| ||||
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
| ||||
jdDateForGLandVoucherJULIA | 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
| ||||
jdDateInvoiceJ | 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
| ||||
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.
| ||||
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
| ||||
jdDateBatchJulian | DICJ | JDEDATE | NONE | NONE |
The date of the batch. If you leave this field blank, the system date is used. | ||||
mnFiscalYear1 | 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
| ||||
mnPeriodNoGeneralLedge | 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
| ||||
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
| ||||
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
| ||||
szAccountId | AID | char | NONE | NONE |
A number that the system assigns to each general ledger account in the Account Master table (F0901) to uniquely identify it. | ||||
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
| ||||
szCurrencyCodeBase | BCRC | char | NONE | 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
| ||||
cCurrencyMode | CRRM | char | NONE | NONE |
An option that specifies whether the system displays amounts in the domestic or foreign currency.
On
The system displays amounts in the
| ||||
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
| ||||
szNameRemark | RMK | char | NONE | NONE |
A generic field that you use for a remark, description, name, or address. | ||||
szNameAlpha | ALPH | char | NONE | NONE |
The text that names or describes an address. This 40-character alphabetic field appears on a number of forms and reports. You can enter
| ||||
mnPaymentID | PYID | MATH_NUMERIC | NONE | NONE |
A number that the system assigns from Next Numbers to identify and track payment records. | ||||
szProgramId | PID | char | NONE | NONE |
The number that identifies the batch or interactive program (batch or interactive object). For example, the number of the Sales Order Entry
| ||||
mnAddressNumberParent | PA8 | MATH_NUMERIC | NONE | NONE |
The address book number of the parent company. The system uses this number to associate a particular address with a parent company
| ||||
mnAddNoAlternatePayee | AN8J | MATH_NUMERIC | NONE | NONE |
An alternate address to which accounts payable can send payments due. | ||||
szCostCenter | MCU | char | NONE | NONE |
An alphanumeric code that identifies a separate entity within a business for which you want to track costs. For example, a business unit
| ||||
jdDateValue | VLDT | JDEDATE | NONE | NONE |
The date that the payment amount was debited or credited to the bank account. The value date is not the date the bank reconciled the
| ||||
szARreportingCode1n | AR01 | char | NONE | NONE |
One of ten user defined codes that the system populates when an invoice is generated. The system uses the corresponding value (AC01)
| ||||
szARreportingCode2 | AR02 | char | NONE | NONE |
One of ten user defined codes that the system populates when an invoice is generated. The system uses the corresponding value (AC02)
| ||||
szARreportingCode3 | AR03 | char | NONE | NONE |
One of ten user defined codes that the system populates when an invoice is generated. The system uses the corresponding value (AC03)
| ||||
szARreportingCode4 | AR04 | char | NONE | NONE |
One of ten user defined codes that the system populates when an invoice is generated. The system uses the corresponding value (AC04)
| ||||
szARreportingCode5 | AR05 | char | NONE | NONE |
One of ten user defined codes that the system populates when an invoice is generated. The system uses the corresponding value (AC05)
| ||||
szARReportingCode6 | AR06 | char | NONE | NONE |
One of ten user defined codes that the system populates when an invoice is generated. The system uses the corresponding value (AC06)
| ||||
szARReportingCode7 | AR07 | char | NONE | NONE |
One of ten user defined codes that the system populates when an invoice is generated. The system uses the corresponding value (AC07)
| ||||
szARReportingCode8 | AR08 | char | NONE | NONE |
One of ten user defined codes that the system populates when an invoice is generated. The system uses the corresponding value (AC08)
| ||||
szARReportingCode9 | AR09 | char | NONE | NONE |
One of ten user defined codes that the system populates when an invoice is generated. The system uses the corresponding value (AC09)
| ||||
szARReportingCode10 | AR10 | char | NONE | NONE |
One of ten user defined codes that the system populates when an invoice is generated. The system uses the corresponding value (AC10)
| ||||
szCurrencyCodeBase_2 | BCRC | char | NONE | 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
| ||||
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
| ||||
cPaymentInstrumentA | RYIN | char | NONE | NONE |
The user defined code (00/PY) that specifies how payments are made by the customer. For example:
C
Check
D
Draft
T
Electronic funds
| ||||
cARPostToCashManagement | ISTC | char | NONE | NONE |
A code that specifies whether the transaction is included in the the A/R Statistical History table (F03B16). Valid values are:
Blank
The
| ||||
szTransactionCurrency | CRCD | char | NONE | NONE |
A code that identifies the currency of a transaction. | ||||
cR1OpenAmountFlag | EV02 | char | NONE | NONE |
An option that specifies the type of processing for an event. | ||||
mnPaymentAmountForeign | PFAP | MATH_NUMERIC | OPT | NONE |
The foreign amount to be paid on an A/P Payment run. | ||||
mnCurrencyConverRateOv | CRR | MATH_NUMERIC | OPT | NONE |
A number (exchange rate) that a foreign currency amount is multiplied by to calculate a domestic currency amount.
The number in this field
| ||||
mnTriangulationLeg1 | CRR1 | MATH_NUMERIC | OPT | NONE |
The exchange rate from the foreign currency of the invoice to the triangulation currency (leg 1). This rate applies when you use triangulation
| ||||
mnTriangulationLeg2 | CRR2 | MATH_NUMERIC | OPT | NONE |
The exchange rate from the triangulation currency to the domestic currency (leg 2). This rate applies when you use triangulation to calculate
| ||||
cCurrencyConversionMethod | CRCM | char | OPT | NONE |
A value that specifies which method to use when converting from one currency to another. Valid values are:
Y
Multiplier method. The
| ||||
jdExchangeRateDate | ERDJ | JDEDATE | OPT | NONE |
The date that the system uses to retrieve the exchange rate from the Currency Exchange Rates table (F0015). | ||||
szReference1 | VR01 | char | OPT | NONE |
An alphanumeric value used as a cross-reference or secondary reference number. Typically, this is the customer number, supplier
| ||||
szDraftNumber | CKNU | char | OPT | NONE |
For Auto Bank Statement, this code identifies the payment/receipt or reference number.
NOTE:
Bank Statement Detail section: The
|
B0000027 CurrencyConvForAndDom | ||||
B9800100 Get Audit Information |
F03B11 Customer Ledger |