This the documentation of the F0911 Edit Line
F0911EditLine
Purpose
This function will be used to do detail level defaulting and editing. This
includes data dictionary defaults, edits, and UDC editing. Document totaling
is also done in this module. If there are no errors a record will be written
to the detail cache and the header cache will be updated.
Parameters
Parameter Description I/O Required Notes
JOBS szJobNumber I/O Y Pass Job Number created in BeginDocument.
ACTN cLineAction I Y A or 1 = AddC or 2 = ChangeD or 4 = Delete
EV01 cProcessingMode I Y ‘1’ = batch mode (write to detail cache record)
EV01 cEditFlag I Y 0 = No Edits1 = Full Edits2 = Partial EditsThis parameter
is not used. We will always do full edits.
EV01 cErrorFlag O Y ‘ ‘ = No Errors‘1’ = Warning‘2’ = Error
EV01 cRecordWrittenFlag I/O Y ‘1’ = record has already been written to
detail cache
EV01 cTypeDoc I Y This is the transaction type of the document.‘I’ = Invoice
‘V’ = Voucher‘J’ or ‘ ‘ = Journal Entry (default)
JELN mnLineNumber I/O N This line number is used in the key to the detail
cache record along with job number. This line number will also be written to
the F0911. If this is left blank then it will be assigned equal to the last
line number held in the header cache record plus 1.
AA mnAmount I Y This is the amount. If currency is on then this is the
domestic amount and is displayed if the currency mode is ‘D’
ANI szAccountNumber I Y This is the account number associated with this line
of the journal entry. When sending this the account mode must equal ‘2’.
AID szAccountID O N This is the account id of the account number passed in
the ANI field. This value will be returned after calling Validate Account.
MCU szBusinessUnit O N This is the business unit of the account number
passed in the ANI field. This value will be returned after calling Validate
Account.
OBJ szObject O N This is the object of the account number passed in the ANI
field. This value will be returned after calling Validate Account.
SUB szSubsidiary O N This is the subsidiary of the account number passed in
the ANI field. This value will be returned after calling Validate Account.
AM cAccountMode I Y This is the account mode used in the validate account
routine. At this time it must be passed as a value of ‘2’.
FY mnFiscalYear O N This is the fiscal year of the company of the account
based on the G/L date.
PN mnPeriodNumber O N This is the period number of the company of the
account based on the G/L date.
CTRY mnCentury O N This is the century of the company of the account based
on the G/L date.
SBL szSubledger I/O N This field will be formatted and validated based on
the subledger type.
SBLT szSubledgerType I N This field will be validated against UDC table
00/ST and used to scrub and validate the subledger field.
U mnUnits I N This field holds the units for this transaction.
UM szUnitOfMeasure I N This is the unit of measure for the units. This will
be validated against UDC table 00/UM.
DSVJ jdServiceDate I N Service tax date will be defaulted to the value of
the G/L date if left blank.
EXTL szLineExtension I N Used to further break down journal entries by line.
Used by the post program to create intercompany multi-currency settlements
and also used by dual currency processing.
ASID szAssetID I N Secondary Asset identification number. Must be a unique
number.
POST cPostedCode I N This tells us if the this transaction line is posted,
unposted, or in error. If you are creating a model transaction then a ‘M’
must be passed in this field along with a ‘1’ in the cModelFlag in BeginDoc.
EXR szExplanation I N This is the explanation used at the line level for a
transaction.
R2 szReference2 I N
SFX szPayItem I N Pay item of invoice or voucher
BC cBillCode I N Billing status of joint interest billing system. This field
is validated against UDC table 98/BC.
DOI mnDoiSub I N Identifies a specific DOI for a business unit.
WR01 szWorkOrder001 I N Indicates currency stage or phase of development for
work order. This is validated against UDC table 00/W1.
ALID szOutsiderLeaseWellID I N Alternate lease or well number as assigned by
an outsider.
DCTO szOrderType I N Validated against UDC table 00/DT.
LNID mnLineID I N Line id used for order.
PDCT szPODocType I N Purchase order document type. Validated against table
00/DT.
PKCO szPOKeyCompany I N Purchase order document company. Must be a valid
company.
PO szPurchaseOrder I N Purchase order number.
PSFX szPOSuffix I N This field distinguishes between multiple occurrences of
a single purchase order.
TNN c1099Flag I N Flag for 1099’s
ACR mnCurrencyAmount I N This is the amount associated with the foreign side
of an entry. This field is only looked at if currency is on.
CTAM mnForeignTaxAmount I N Future - holds tax amount for foreign side of an
entry.
CTXA mnForeignTaxableAmount I N Future - holds the taxable amount for the
foreign side of an entry.
STAM mnTaxAmount I N Future - holds tax amount for the transaction.
ATXA mnAmountTaxable I N Future - holds the amount taxable for the
transaction.
CRYR cCurrencyFlag I N This flag needs to be loaded with the system value
set in the general constants.
CO szCompany O N Company of the account returned from Validate Account
Number.
MATH06 mnOPTolerance I N Processing Option - will hold the tolerance amount
for the currency exchange rate. For example, .15 = 15%.
DKJ mnCheckDate I N Check or Item date.
KCO szDisplayKeyCompany O N Used to display the key company defaulted from
the first account number.
CRDC szDisplayBaseCoCurr O N Used to display the base company currency
defaulted from the first account.
CRCD szDisplayTransCurrency O N Used to display the transaction currency
defaulted from the first account.
CRR mnDisplayExchgRate O N Used to display the exchange rate which will be
defaulted after the base currency is retrieved.
CRRM cDisplayCurrencyMode O N Used to display the currency mode if it
changes after entering account transactions.
JELN mnLastLineNo O Y Used to hold the last line number used in the current
document
AA mnOriginalAmount I Y This field must be populated with the amount which
was entered on the current line prior to the change. This will be used in
EditDoc for balancing purposes.
ACR mnOriginalAmountForeign I N This field must be populated with the
foreign amount which was entered on the current line prior to the change.
This will be used in EditDoc for balancing purposes. This will only be
looked at if currency is on.
ALT1 cGLPostCodeAlt001 I N G/L posting code alternate 1
ALT2 cGLPostCodeAlt002 I N G/L posting code alternate 2
ALT3 cGLPostCodeAlt003 I N G/L posting code alternate 3
ALT4 cGLPostCodeAlt004 I N G/L posting code alternate 4
ALT5 cGLPostCodeAlt005 I N G/L posting code alternate 5
ALT6 cGLPostCodeAlt006 I N G/L posting code alternate 6 - cash basis account
ALT7 cCommitmentReliefFlag I N Commitment relief flag
ALT8 cBillingControl I N Billing control
ALT9 cGLPostCodeAlt009 I N Currency update
ALT0 cGLPostCodeAlt000 I N G/L posting code alternate 0
ALTX cGLPostCodeAlt00X I N Consumption tax cross reference
CN szCheckNumber I N Payment number
DKC jdDateCheckCleared I N Check cleared date
SUMM cSummerizedCode I N Summarized code
PRGE cPurgeCode I N Purge code
BRE cBatchRearEndPostCode I N Batch rear end posted code
JBCD szJobCategory I N Job type (craft ) code
JBST szJobStep I N Job step
WY mnWeeklyYear I N Fiscal year - weekly
WN mnWeeklyPeriod I N Period number - weekly
FNLP cFinalPayment I N Closed item - as of processing
ASM cAssetInputMode I N Lease cost ledger posted code
OPSQ mnSequenceNoOperations I N Sequence number operations
ODOC mnOriginalDocNumber I N Original document number
OKCO szOriginalKeyCo I N Original key company
CFF1 cClientFreeForm1 I N Client free form - alternate 1
CFF2 cClientFreeForm2 I N Client free form - alternate 2
GLC szGlClass I N G/L class code
DNLA cDeleteNotAllowed I N Delete not allowed flag
ALTY szIDType I N ID type
DL01 szSubledgerDescription O N Returns the description of the subledger
passed to edit line.
DL01 szAccountDescription O N Returns the description of the account passed
to edit line.
EV01 cBypassMEditFlag I N Used to bypass setting an error when using an
account with an ‘M’ posting edit code.‘1’ = bypass setting error
RCND cReconciledCode I N A value passed in this parameter will be written to
the F0911 record in the GLRCND field.
Return Values
If errors are detected (cErrorFlag =’2’), the business function will not
write to the detail cache.
If warnings are detected (cErrorFlag =’1’), the business function will still
update the record to the cache file.
Special Handling Instructions and Prerequisites
Prior to calling EditLine, you must first run BeginDoc, which creates the
header cache record. This is because there are several edits that are
dependent on values in the header cache.
Several work fields need to be set up in your grid. They are:
· Line Action - Action on the individual line - A, C, D.
· Record Written Flag - Flag which tells us if this particular line has
already be written to the detail cache record.
· Original Amount - This field holds the original amount on the line prior
to the change or deletion.
· Original Amount Foreign - This field is similar to the Original Amount
except that it holds the foreign amount if currency is on.
· Currency Amount - This field will hold the foreign amount the amount
pertaining to mode ‘F’.
· Error Flag - This will hold a value of 0 if no errors, 1 if warnings, or 2
if errors.
Because there are several fields in the header cache record which are
dependent on the account entered in the first line of the journal entry for
their defaults, parameters have been provided to return these values to the
appropriate fields in the header of the form when using a GUI screen.
Examples - Key Company, Base Company Currency, Transaction Currency,
Exchange Rate, and Currency Mode. Document totals are calculated in this
module and stored in the header cache record.
-----Message d'origine-----
De :
[email protected]
[mailto
[email protected]]De la part de Oops
Envoyé : mardi 28 août 2001 16:36
À :
[email protected]
Objet : F0911 Edit Line
Hi List!
I'm in a big-big troubles
...
DESPERATELY need any info about BSFN F0911 Edit line arguments!
Smth works incorrect in a custom report (I mean UBE) and I wonder what it
is.
My opinion is that the cause af all troubles lies in these arguments.
The main problem is what numeric value has an ACCOUNT_ID const (C code). Or,
in other words, what set of arguments should I set to transfer Account ID as
an account identifier instead of a 3 segment account number?
If anyone has any info on the matter please send it to me as soon as it's
possible.
Great thanx in advance!
Oops
--------------------------
Visit the forum to view this thread at:
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=&Board=OWDEV&Numbe
r=20053
Franck BLETTNER
Service Informatique RAVATE
Tel : 02 62 90 40 48
E-mail :
[email protected]
