tcBusinessFieldName | tcDataType | tcOperator |
---|---|---|
iiCompanyId | i | |
tBill.BillDate | t | =,>=,>,<>,<=,< |
tBill.BillDueDate | t | =,>=,>,<>,<=,< |
tBill.BillNumber | i | =,>=,>,<>,<=,< |
tBill.BillYear | i | =,>=,>,<>,<=,< |
tCompany.CompanyCode | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tCurrency2.CurrencyCode | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tCurrency1.CurrencyCode | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tDebtor.DebtorCode | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tDInvoice.DInvoiceBalanceCC | d | =,>=,>,<>,<=,< |
tDInvoice.DInvoiceBalanceLC | d | =,>=,>,<>,<=,< |
tDInvoice.DInvoiceBalanceTC | d | =,>=,>,<>,<=,< |
tDInvoice.DInvoiceBatch | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tDInvoice.DInvoiceDate | t | =,>=,>,<>,<=,< |
tDInvoice.DInvoiceDescription | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tDInvoice.DInvoiceDIText | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tDInvoice.DInvoiceDueDate | t | =,>=,>,<>,<=,< |
tDInvoice.DInvoiceGoldenTaxInvoiceList | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tDInvoice.DInvoiceIsOpen | l | =,<> |
tDInvoice.DInvoiceLegalDocumentList | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tDInvoiceMovement.DInvoiceMovementDiscountTC | d | =,>=,>,<>,<=,< |
tDInvoiceMovement.DInvoiceMovementType | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tDInvoiceMovement.DInvoiceMovementYearPeriod | i | =,>=,>,<>,<=,< |
tDInvoice.DInvoiceOriginalCreditCC | d | =,>=,>,<>,<=,< |
tDInvoice.DInvoiceOriginalCreditLC | d | =,>=,>,<>,<=,< |
tDInvoice.DInvoiceOriginalCreditTC | d | =,>=,>,<>,<=,< |
tDInvoice.DInvoiceOriginalDebitCC | d | =,>=,>,<>,<=,< |
tDInvoice.DInvoiceOriginalDebitLC | d | =,>=,>,<>,<=,< |
tDInvoice.DInvoiceOriginalDebitTC | d | =,>=,>,<>,<=,< |
tDInvoice.DInvoicePostingYearPeriod | i | =,>=,>,<>,<=,< |
tDInvoice.DInvoiceSalesOrderList | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tDInvoice.DInvoiceShipperList | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tDInvoice.DInvoiceType | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tDInvoice.DInvoiceVoucher | i | =,>=,>,<>,<=,< |
tGL.GLCode | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tJournal2.JournalCode | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tJournal1.JournalCode | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tDInvoice.LastModifiedDate | t | =,>=,>,<>,<=,< |
tDInvoice.LastModifiedTime | i | =,>=,>,<>,<=,< |
tDInvoice.LastModifiedUser | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tPeriod2.PeriodPeriod | i | =,>=,>,<>,<=,< |
tPeriod1.PeriodPeriod | i | =,>=,>,<>,<=,< |
tPeriod2.PeriodYear | i | =,>=,>,<>,<=,< |
tPeriod1.PeriodYear | i | =,>=,>,<>,<=,< |
tPeriod2.PeriodYearPeriod | i | =,>=,>,<>,<=,< |
tPeriod1.PeriodYearPeriod | i | =,>=,>,<>,<=,< |
tPosting.PostingDate | t | =,>=,>,<>,<=,< |
tPosting.PostingInvoiceReferenceTxt | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tPostingLine.PostingLineCreditCC | d | =,>=,>,<>,<=,< |
tPostingLine.PostingLineCreditLC | d | =,>=,>,<>,<=,< |
tPostingLine.PostingLineCreditTC | d | =,>=,>,<>,<=,< |
tPostingLine.PostingLineDebitCC | d | =,>=,>,<>,<=,< |
tPostingLine.PostingLineDebitLC | d | =,>=,>,<>,<=,< |
tPostingLine.PostingLineDebitTC | d | =,>=,>,<>,<=,< |
tPostingLine.PostingLineExchangeRate | d | =,>=,>,<>,<=,< |
tPostingLine.PostingLineText | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tPosting.PostingPeriod | i | =,>=,>,<>,<=,< |
tPosting.PostingSystemDate | t | =,>=,>,<>,<=,< |
tPosting.PostingVoucher | i | =,>=,>,<>,<=,< |
tPosting.PostingYear | i | =,>=,>,<>,<=,< |
iiCompanyId | integer | Company id |
field name | data type | db field | description |
---|---|---|---|
tdAmountCCCalc | decimal | calculated | Net amount in SC |
tdAmountLCCalc | decimal | calculated | Net Amount in BC |
tdAmountTCCalc | decimal | calculated | Net Amount in TC |
ttBillDate | date | Bill.BillDate | Bill Date |
ttBillDueDate | date | Bill.BillDueDate | Bill Due Date |
tiBillNumber | integer | Bill.BillNumber | Bill Number |
tiBillYear | integer | Bill.BillYear | Bill Year |
tcCompanyCode | character | Company.CompanyCode | Entity Code |
tiDInvoice_ID | integer | DInvoice.DInvoice_ID | Record ID |
tdDInvoiceBalanceCC | decimal | DInvoice.DInvoiceBalanceCC | SC Balance. This field displays the sum of the debit and credit amounts of all posting lines in statutory currency. This field is calculated by the system using the TC Balance and the SC rate. |
tdDInvoiceBalanceLC | decimal | DInvoice.DInvoiceBalanceLC | BC Balance. This field displays the sum of the debit and credit amounts of all posting lines in base currency. This field is calculated by the system using the TC Balance and the Exchange rate. |
tcDInvoiceDIText | character | DInvoice.DInvoiceDIText | CIDescription. A brief description for the SI posting. |
api annotation: | This field defaults from the DInvoiceDescription. | ||
ttDInvoiceDueDate | date | DInvoice.DInvoiceDueDate | Due Date. This field displays the date when payment is due, calculated by the system based on the credit terms and the invoice date. User can modify the due date without affecting the credit terms. If the credit terms have a base date specified, this is used in the due date calculations rather than the invoice creation date. |
tcDInvoiceGoldenTaxInvoiceList | character | DInvoice.DInvoiceGoldenTaxInvoiceList | Golden Tax Invoices |
tcDInvoiceKeyID | character | calculated | Concatenated list of key fields of invoice |
tcDInvoiceLegalDocumentList | character | DInvoice.DInvoiceLegalDocumentList | Legal Documents |
tdDInvoiceMovementDiscountTC | decimal | DInvoiceMovement.DInvoiceMovementDiscountTC | CInvoiceMovementDiscountTC. The amount of payment discount in TC. |
tiDInvoiceMovementYearPeriod | integer | DInvoiceMovement.DInvoiceMovementYearPeriod | Year/GL Period. This field indicates the accounting year and period for the invoice's movement. |
tcDInvoiceMovTypeMovCalc | character | calculated | |
tdDInvoiceOriginalCreditCC | decimal | DInvoice.DInvoiceOriginalCreditCC | SC Invoice Amount (CR). This field displays the credit total invoice amount in the statutory currency. This field is calculated by the system using the TC Invoice Amount(CR) and the SC Rate. |
tdDInvoiceOriginalCreditLC | decimal | DInvoice.DInvoiceOriginalCreditLC | BC Invoice Amount(CR). This field displays the credit total invoice amount in the base currency. This field is calculated by the system using the TC Invoice Amount(CR) and the Exchange rate. |
tdDInvoiceOriginalDebitCC | decimal | DInvoice.DInvoiceOriginalDebitCC | SC Invoice Amount (DR). This field displays the debit total invoice amount in the statutory currency. This field is calculated by the system using the TC Invoice Amount(CR) and the SC Rate. |
tdDInvoiceOriginalDebitLC | decimal | DInvoice.DInvoiceOriginalDebitLC | BC Invoice Amount(DR). This field displays the debit total invoice amount in the base currency. This field is calculated by the system using the TC Invoice Amount(DR) and the Exchange rate. |
tiDInvoicePostingYearPeriod | integer | DInvoice.DInvoicePostingYearPeriod | Year/Period. This field indicates the accounting year and period for the invoice. If you modify these fields, the posting and tax dates are changed correspondingly. |
api annotation: | This field defaults to the accounting year and period associated with the posting date. | ||
tcDInvoiceSalesOrderList | character | DInvoice.DInvoiceSalesOrderList | Sales Orders |
tcDInvoiceShipperList | character | DInvoice.DInvoiceShipperList | Shippers |
ttLastModifiedDate | date | DInvoice.LastModifiedDate | Last Modified Date |
tiLastModifiedTime | integer | DInvoice.LastModifiedTime | Last Modified Time |
tcLastModifiedUser | character | DInvoice.LastModifiedUser | Last Modified User |
tdPostingLineCreditCC | decimal | PostingLine.PostingLineCreditCC | SC Credit |
api annotation: | Partial Update = yes - it will get a default value depending on the value of PostingLinCreditTC, PostingLineCCRate & PostingLineCCScale. SC Amount = TC Amount * Exchange rate (TC/SC) * Scale Factor (TC/SC). If Partial Update is false, you should enter the correct value for this field | ||
tdPostingLineCreditLC | decimal | PostingLine.PostingLineCreditLC | BC Credit |
api annotation: | Partial Update = yes - it will get a default value depends on the value of PostingLineCreditTC, PostingLineExchangeRate & PostingLineRateScale. BC Amount = TC Amount * Exchange rate (TC/BC) * Scale Factor (TC/BC). If Partial Update is false, enter a value for this field. | ||
tdPostingLineDebitCC | decimal | PostingLine.PostingLineDebitCC | SC Debit |
api annotation: | Partial Update = yes - it will get a default value depending on the value of PostingLineDebitTC, PostingLineCCRate & PostingLineCCScale. SC Amount = TC Amount * Exchange rate (TC/SC) * Scale Factor (TC/SC). If Partial Update is false, enter the correct value for this field. | ||
tdPostingLineDebitLC | decimal | PostingLine.PostingLineDebitLC | BC Debit |
api annotation: | Partial Update = yes - it will get a default value depending on the value of PostingLineDebitTC, PostingLineExchangeRate and PostingLineRateScale. BC Amount = TC Amount * Exchange rate (TC/BC) * Scale Factor (TC/BC). If Partial Update = false, enter the correct value into this field. | ||
tdPostingLineExchangeRate | decimal | PostingLine.PostingLineExchangeRate | Exchange Rate |
api annotation: | Default value for this field depends on the exchang erate shared set specified for the current domain. | ||
tcPostingLineText | character | PostingLine.PostingLineText | Description |
api annotation: | Value for this field defaults to blank. Note: if a new record is created through the user interface, the default value is as same as the value of "PostingText" of tPosting. | ||
tiPostingPeriod | integer | Posting.PostingPeriod | The GL period for the posting. The period must be open. |
ttPostingSystemDate | date | Posting.PostingSystemDate | The system date of the posting corresponding to "PostingDate". |
api annotation: | In Create mode, when Partial Update = yes - this field gets a default value which is the current date of the system. | ||
tiPostingYear | integer | Posting.PostingYear | The GL calendar year for the posting. |
tcQADC01 | character | DInvoice.QADC01 | unused QAD reserved field |
tiPeriodPeriod | integer | Period1.PeriodPeriod | GL Period |
tcPostingInvoiceReferenceTxt | character | Posting.PostingInvoiceReferenceTxt | When the posting is part of an invoice posting, then this field contains the invoice number (Year/Daybook/Voucher extended with supplier invoice Reference in case of a supplier invoice). Used for information purpose on reports and browsers. |
api annotation: | Value for this field defaults to blank | ||
tcDInvoiceMovementType | character | DInvoiceMovement.DInvoiceMovementType | CInvoiceMovementType. "Initial" indicates that the movement represents the initial creation of the invoice, "movement" stands for all subsequent modifications of the invoice balance (payments, adjustments etc). |
tiPostingLine_ID | integer | DInvoiceMovement.PostingLine_ID | Link to PostingLine |
tcDInvoiceBatch | character | DInvoice.DInvoiceBatch | Batch Number. This field is used to identify a group of customer invoices created at one time using Evaluated Receipts Settlement (ERS) functions. |
tiCompany_ID | integer | DInvoice.Company_ID | Link to Company |
tiPeriodYear | integer | Period1.PeriodYear | GL Calendar Year |
tcPostingJournalCode | character | Journal1.JournalCode | A daybook code (maximum eight characters). |
tiPeriodYearPeriod | integer | Period1.PeriodYearPeriod | GL Calendar Year/GL Period |
tcDInvoiceMovTypeInvCalc | character | calculated | DInvoiceTypeCalc; Debtor Invoice Type nl Invoice or Credit Note |
tiPeriodYear2 | integer | Period2.PeriodYear | GL Calendar Year |
tiPeriodPeriod2 | integer | Period2.PeriodPeriod | GL Period |
tcDebtorCode | character | Debtor.DebtorCode | A code (maximum eight characters) that identifies a customer. If the code you specify matches an existing supplier code, a warning message displays. You can choose to ignore the warning, and create the record. However, when a supplier and customer share the same code, they must reference the same business relation. |
api annotation: | If you leave the Customer Code field blank, the system automatically generates a number for the record based on the sequence defined in Customer Autonumber Create. | ||
tiPeriodYearPeriod2 | integer | Period2.PeriodYearPeriod | GL Calendar Year/GL Period |
tcInvJournal | character | Journal2.JournalCode | A daybook code (maximum eight characters). |
tiDInvoiceVoucher | integer | DInvoice.DInvoiceVoucher | Voucher.This field displays the numeric identifier assigned to the posting. When the daybook of the journal entry is charged(after transfer), the voucher is cleared. Voucher must be unique in one GL period. When the user input is zero, the system automatically assign a value not used yet for this field. |
tcDInvoiceCurrencyCode | character | Currency1.CurrencyCode | Currency Code |
tiPostingVoucher | integer | Posting.PostingVoucher | Voucher is a sequential number that uniquely identifies the journal entry (within the combination of an entity and a daybook code). |
api annotation: | In create mode,enter 0 in this field - the voucher number is generated by the system. In Modify/Delete, the correct voucher number must be entered because this identifies the record. | ||
tcGLCode | character | GL.GLCode | A code identifying the GL account. |
tdPostingLineCreditTC | decimal | PostingLine.PostingLineCreditTC | TC Credit |
tdPostingLineDebitTC | decimal | PostingLine.PostingLineDebitTC | TC Debit |
tcPostingLineCurrencyCode | character | Currency2.CurrencyCode | Currency Code |
ttPostingDate | date | Posting.PostingDate | The accounting date on which the journal entry is posted. The posting date must be a valid calendar date and must be within the GL calendar year (PostingYear) and period (PostingPeriod). |
tdDInvoiceBalanceTC | decimal | DInvoice.DInvoiceBalanceTC | Balance. This field displays the sum of the debit and credit amounts of all posting lines in transaction currency. |
tlDInvoiceIsOpen | logical | DInvoice.DInvoiceIsOpen | Open.This field indicates if the invoice has been completely paid. This field is updated automatically when complete payment is confirmed. This field is read-only. |
api annotation: | PartialUpdate = yes - defaults to true | ||
ttDInvoiceDate | date | DInvoice.DInvoiceDate | Invoice Date. This field indicates the invoice creation date.This field is normallly prior to the posting date and within the same accounting period as the posting date. The date must be within the upper and lower date limits of an open GL period. The system uses the invoice date with the credit terms to calculate due date and discount date. |
api annotation: | This field defaults to the DInvoicePostingDate. | ||
tcDInvoiceDescription | character | DInvoice.DInvoiceDescription | Description. A brief description of the invoice. This field is mandatory. |
tdDInvoiceOriginalCreditTC | decimal | DInvoice.DInvoiceOriginalCreditTC | TC Invoice Amount CR. This field displays the credit total invoice amount in the transaction currency. If you modify this field, the system automatically recalculates the exchange rate to ensure that the BC Invoice Amount remains the same. |
tdDInvoiceOriginalDebitTC | decimal | DInvoice.DInvoiceOriginalDebitTC | TC AP Amount. This field displays the debit total invoice amount in the transaction currency. If you modify this field, the system automatically recalculates the exchange rate to ensure that the TC Invoice Amount remains the same. |
tcDInvoiceType | character | DInvoice.DInvoiceType | Invoice Type. This field displays the invoice type. Invoice Correction and Credit Note Correction display as choices only when the appropriate daybook types have already been defined. |
api annotation: | PartialUpdate = yes - defaults to Invoice | ||
tiJournal_ID | integer | Posting.Journal_ID | Daybook Code |
tiPeriod_ID | integer | Posting.Period_ID | Link to Period |
DInvoiceCustom | character | calculated | custom fields |
Currency1Custom | character | calculated | custom fields |
DebtorCustom | character | calculated | custom fields |
DInvoiceMovementCustom | character | calculated | custom fields |
PostingLineCustom | character | calculated | custom fields |
Currency2Custom | character | calculated | custom fields |
GLCustom | character | calculated | custom fields |
PostingCustom | character | calculated | custom fields |
Journal1Custom | character | calculated | custom fields |
Period1Custom | character | calculated | custom fields |
Journal2Custom | character | calculated | custom fields |
Period2Custom | character | calculated | custom fields |
BillCustom | character | calculated | custom fields |
CompanyCustom | character | calculated | custom fields |
ti_sequence | integer | calculated | primary index |
tc_rowid | character | calculated | = rowid(DInvoice),rowid(Bill),rowid(Company),rowid(Currency1),rowid(Debtor),rowid(DInvoiceMovement),rowid(PostingLine),rowid(Currency2),rowid(GL),rowid(Posting),rowid(Journal1),rowid(Period1),rowid(Journal2),rowid(Period2) |
define temp-table ttContext no-undo field propertyQualifier as character field propertyName as character field propertyValue as character index entityContext is primary unique propertyQualifier propertyName index propertyQualifier propertyQualifier. define dataset dsContext for ttContext. define variable vhContextDS as handle no-undo. define variable vhExceptionDS as handle no-undo. define variable vhServer as handle no-undo. define variable vhInputDS as handle no-undo. define variable vhInputOutputDS as handle no-undo. define variable vhOutputDS as handle no-undo. define variable vhParameter as handle no-undo. /* Create context */ create ttContext. assign ttContext.propertyName = "programName" ttContext.propertyValue = "BDInvoice". create ttContext. assign ttContext.propertyName = "methodName" ttContext.propertyValue = "SelectDInvoiceForMovementInv". create ttContext. assign ttContext.propertyName = "applicationId" ttContext.propertyValue = "fin". create ttContext. assign ttContext.propertyName = "entity" ttContext.propertyValue = "1000". create ttContext. assign ttContext.propertyName = "userName" ttContext.propertyValue = "mfg". create ttContext. assign ttContext.propertyName = "password" ttContext.propertyValue = "". /* Create input dataset */ create dataset vhInputDS. vhInputDS:read-xmlschema("file", "xml/bdinvoice.selectdinvoiceformovementinv.i.xsd", ?). vhParameter = vhInputDS:get-buffer-handle("tParameterI"). vhParameter:buffer-create(). assign vhParameter::icRange = "A" vhParameter::icRowid = "" vhParameter::iiRownum = 0 vhParameter::iiNumber = 5 /* Number of records to read */ vhParameter::icSortColumns = "" vhParameter::ilCountOnly = false vhParameter::ilForwardRead = true vhParameter::iiMaximumBrowseRecordsToCount = 0. vhParameter = vhInputDS:get-buffer-handle("tFilter"). vhParameter:buffer-create(). assign vhParameter::<field-name-1> = <field-value-1> vhParameter::<field-name-2> = <field-value-2> ... /* Connect the AppServer */ create server vhServer. vhServer:connect("-URL <appserver-url>"). if not vhServer:connected() then do: message "Could not connect AppServer" view-as alert-box error title "Error". return. end. /* Run */ assign vhContextDS = dataset dsContext:handle. run program/rpcrequestservice.p on vhServer (input-output dataset-handle vhContextDS by-reference, output dataset-handle vhExceptionDS, input dataset-handle vhInputDS by-reference, input-output dataset-handle vhInputOutputDS by-reference, output dataset-handle vhOutputDS). /* Handle output however you want, in this example, we dump it to xml */ if valid-handle(vhExceptionDS) then vhExceptionDS:write-xml("file", "Exceptions.xml", true). if valid-handle(vhOutputDS) then vhOutputDS:write-xml("file", "Output.xml", true). /* Cleanup */ vhServer:disconnect(). assign vhServer = ?. if valid-handle(vhInputDS) then delete object vhInputDS. if valid-handle(vhOutputDS) then delete object vhOutputDS. if valid-handle(vhExceptionDS) then delete object vhExceptionDS.