| tcBusinessFieldName | tcDataType | tcOperator |
|---|---|---|
| iiCompanyId | i | |
| iiPostingYear | i | = |
| icJournalCode | c | = |
| iiPostingVoucher | i | = |
| tCInvoice.CInvoiceAllocationStatus | c | =,>=,>,<>,<=,<,begins,can-do,matches |
| tCInvoice.CInvoiceBalanceCC | d | =,>=,>,<>,<=,< |
| tCInvoice.CInvoiceBalanceCreditCC | d | =,>=,>,<>,<=,< |
| tCInvoice.CInvoiceBalanceCreditLC | d | =,>=,>,<>,<=,< |
| tCInvoice.CInvoiceBalanceCreditTC | d | =,>=,>,<>,<=,< |
| tCInvoice.CInvoiceBalanceDebitCC | d | =,>=,>,<>,<=,< |
| tCInvoice.CInvoiceBalanceDebitLC | d | =,>=,>,<>,<=,< |
| tCInvoice.CInvoiceBalanceDebitTC | d | =,>=,>,<>,<=,< |
| tCInvoice.CInvoiceBalanceLC | d | =,>=,>,<>,<=,< |
| tCInvoice.CInvoiceBalanceTC | d | =,>=,>,<>,<=,< |
| tCInvoice.CInvoiceBatchNumber | c | =,>=,>,<>,<=,<,begins,can-do,matches |
| tCInvoice.CInvoiceCCRate | d | =,>=,>,<>,<=,< |
| tCInvoice.CInvoiceCCScale | d | =,>=,>,<>,<=,< |
| tCInvoice.CInvoiceCIText | c | =,>=,>,<>,<=,<,begins,can-do,matches |
| tCInvoice.CInvoiceDate | t | =,>=,>,<>,<=,< |
| tCInvoice.CInvoiceDescription | c | =,>=,>,<>,<=,<,begins,can-do,matches |
| tCInvoice.CInvoiceDiscountDueDate | t | =,>=,>,<>,<=,< |
| tCInvoice.CInvoiceDueDate | t | =,>=,>,<>,<=,< |
| tCInvoice.CInvoiceExchangeRate | d | =,>=,>,<>,<=,< |
| tCInvoice.CInvoiceIsERS | l | =,<> |
| tCInvoice.CInvoiceIsInitialStatus | l | =,<> |
| tCInvoice.CInvoiceIsOpen | l | =,<> |
| tCInvoice.CInvoiceIsSelected | l | =,<> |
| tCInvoice.CInvoiceOriginalCreditCC | d | =,>=,>,<>,<=,< |
| tCInvoice.CInvoiceOriginalCreditLC | d | =,>=,>,<>,<=,< |
| tCInvoice.CInvoiceOriginalCreditTC | d | =,>=,>,<>,<=,< |
| tCInvoice.CInvoiceOriginalDebitCC | d | =,>=,>,<>,<=,< |
| tCInvoice.CInvoiceOriginalDebitLC | d | =,>=,>,<>,<=,< |
| tCInvoice.CInvoiceOriginalDebitTC | d | =,>=,>,<>,<=,< |
| tCInvoice.CInvoicePoDomain | c | =,>=,>,<>,<=,<,begins,can-do,matches |
| tCInvoice.CInvoicePoNbr | c | =,>=,>,<>,<=,<,begins,can-do,matches |
| tCInvoice.CInvoicePostingDate | t | =,>=,>,<>,<=,< |
| tCInvoice.CInvoicePostingPeriod | i | =,>=,>,<>,<=,< |
| tCInvoicePosting.CInvoicePostingType | c | =,>=,>,<>,<=,<,begins,can-do,matches |
| tCInvoice.CInvoicePostingYear | i | =,>=,>,<>,<=,< |
| tCInvoice.CInvoiceRateScale | d | =,>=,>,<>,<=,< |
| tCInvoice.CInvoiceType | c | =,>=,>,<>,<=,<,begins,can-do,matches |
| tCInvoice.CInvoiceVoucher | i | =,>=,>,<>,<=,< |
| tCompany.CompanyCode | c | =,>=,>,<>,<=,<,begins,can-do,matches |
| tCurrency.CurrencyCode | c | =,>=,>,<>,<=,<,begins,can-do,matches |
| tJournal2.JournalCode | c | =,>=,>,<>,<=,<,begins,can-do,matches |
| tJournal1.JournalCode | c | =,>=,>,<>,<=,<,begins,can-do,matches |
| tJournal2.JournalTypeCode | c | =,>=,>,<>,<=,<,begins,can-do,matches |
| tPostingLine.PostingDate | t | =,>=,>,<>,<=,< |
| tPosting.PostingInvoiceReferenceTxt | c | =,>=,>,<>,<=,<,begins,can-do,matches |
| tPosting.PostingIsCorrection | l | =,<> |
| tPosting.PostingIsReplacement | l | =,<> |
| tPosting.PostingIsReversing | l | =,<> |
| tPosting.PostingIsReversingBySign | l | =,<> |
| tPostingLine.PostingLineCCRate | d | =,>=,>,<>,<=,< |
| tPostingLine.PostingLineCCScale | d | =,>=,>,<>,<=,< |
| tPostingLine.PostingLineCostCentreText | c | =,>=,>,<>,<=,<,begins,can-do,matches |
| tPostingLine.PostingLineCreditCC | d | =,>=,>,<>,<=,< |
| tPostingLine.PostingLineCreditLC | d | =,>=,>,<>,<=,< |
| tPostingLine.PostingLineCreditPC | d | =,>=,>,<>,<=,< |
| tPostingLine.PostingLineCreditTC | d | =,>=,>,<>,<=,< |
| tPostingLine.PostingLineDebitCC | d | =,>=,>,<>,<=,< |
| tPostingLine.PostingLineDebitLC | d | =,>=,>,<>,<=,< |
| tPostingLine.PostingLineDebitPC | d | =,>=,>,<>,<=,< |
| tPostingLine.PostingLineDebitTC | d | =,>=,>,<>,<=,< |
| tPostingLine.PostingLineExchangeRate | d | =,>=,>,<>,<=,< |
| tPostingLine.PostingLineProjectText | c | =,>=,>,<>,<=,<,begins,can-do,matches |
| tPostingLine.PostingLineSafText | c | =,>=,>,<>,<=,<,begins,can-do,matches |
| tPostingLine.PostingLineSequence | i | =,>=,>,<>,<=,< |
| tPostingLine.PostingLineText | c | =,>=,>,<>,<=,<,begins,can-do,matches |
| tPosting.PostingOriginAddressCode | c | =,>=,>,<>,<=,<,begins,can-do,matches |
| tPosting.PostingOriginatorReference | c | =,>=,>,<>,<=,<,begins,can-do,matches |
| tPosting.PostingOriginDaybookCode | c | =,>=,>,<>,<=,<,begins,can-do,matches |
| tPosting.PostingOriginDaybookNumber | c | =,>=,>,<>,<=,<,begins,can-do,matches |
| tPosting.PostingOriginDocument | c | =,>=,>,<>,<=,<,begins,can-do,matches |
| tPosting.PostingOriginDocumentType | c | =,>=,>,<>,<=,<,begins,can-do,matches |
| tPosting.PostingOriginIsExternal | l | =,<> |
| tPosting.PostingOriginReference | c | =,>=,>,<>,<=,<,begins,can-do,matches |
| tPosting.PostingOriginTransType | c | =,>=,>,<>,<=,<,begins,can-do,matches |
| tPosting.PostingText | c | =,>=,>,<>,<=,<,begins,can-do,matches |
| tPosting.PostingVoucher | i | =,>=,>,<>,<=,< |
| tPosting.PostingYear | i | =,>=,>,<>,<=,< |
| tPostingLine.PostingYearPeriod | i | =,>=,>,<>,<=,< |
| iiCompanyId | integer | Company id |
| iiPostingYear | integer | Query parameter: posting year. |
| icJournalCode | character | Query parameter: daybook code. |
| iiPostingVoucher | integer | Query paramter: POsting voucher |
each CInvoice where
each CInvoicePosting (inner-join) where
first Posting (inner-join) where
first Journal2 (inner-join) where
each PostingLine (inner-join) where
first Company (inner-join) where
first Currency (inner-join) where
first Journal1 (inner-join) where
| field name | data type | db field | description |
|---|---|---|---|
| tiCInvoice_ID | integer | CInvoice.CInvoice_ID | Record ID |
| tcCInvoiceAllocationStatus | character | CInvoice.CInvoiceAllocationStatus | Allocation Status.This field indicates whether postings occur and if they affect transient or official layers. User can not delete an invoice which has a non-initial invoice status code. |
| tdCInvoiceBalanceCC | decimal | CInvoice.CInvoiceBalanceCC | 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. |
| tdCInvoiceBalanceCreditCC | decimal | CInvoice.CInvoiceBalanceCreditCC | BC Balance Amount CR. This field displays the sum of the credit amounts of all posting lines in transaction currency. This field is calculated by the system using the TC Base Amount CR and the SC rate. |
| tdCInvoiceBalanceCreditLC | decimal | CInvoice.CInvoiceBalanceCreditLC | BC Balance Amount CR. This field displays the sum of the credit amounts of all posting lines in transaction currency. This field is calculated by the system using the TC Base Amount CR and the Exchange rate. |
| tdCInvoiceBalanceCreditTC | decimal | CInvoice.CInvoiceBalanceCreditTC | TC Balance Amount CR. This field displays the sum of the credit amounts of all posting lines in transaction currency. |
| tdCInvoiceBalanceDebitCC | decimal | CInvoice.CInvoiceBalanceDebitCC | SC Balance Amount DR. This field displays the sum of the debit amounts of all posting lines in statutory currency. This field is calculated by the system using the TC Base Amount DR and the SC rate. |
| tdCInvoiceBalanceDebitLC | decimal | CInvoice.CInvoiceBalanceDebitLC | BC Balance Amount DR. This field displays the sum of the debit amounts of all posting lines in transaction currency. This field is calculated by the system using the TC Base Amount DR and the Exchange rate. |
| tdCInvoiceBalanceDebitTC | decimal | CInvoice.CInvoiceBalanceDebitTC | TC Balance Amount DR. This field displays the sum of the debit amounts of all posting lines in transaction currency. |
| tdCInvoiceBalanceLC | decimal | CInvoice.CInvoiceBalanceLC | 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. |
| tdCInvoiceBalanceTC | decimal | CInvoice.CInvoiceBalanceTC | Balance. This field displays the sum of the debit and credit amounts of all posting lines in transaction currency. |
| tcCInvoiceBatchNumber | character | CInvoice.CInvoiceBatchNumber | Batch Number. This field is used to identify a group of supplier invoices created at one time using Evaluated Receipts Settlement (ERS) functions. |
| tdCInvoiceCCRate | decimal | CInvoice.CInvoiceCCRate | SC Rate. The statutory exchange rate used by the invoice. The SC Invoice Amount is calculated based on the SC rate. |
| tdCInvoiceCCScale | decimal | CInvoice.CInvoiceCCScale | Scale Factor. This field indicates the scale factor applying to the SC rate in use for foreign currency payments. |
| tcCInvoiceCIText | character | CInvoice.CInvoiceCIText | CIDescription. A brief description for the SI posting. |
| api annotation: | This field defaults from the CInvoiceDescription. | ||
| ttCInvoiceDate | date | CInvoice.CInvoiceDate | Invoice Date. This field indicates the invoice creation date. The system uses this field with the credit terms to calculate due date and discount date. |
| api annotation: | This field defaults from the system date. | ||
| tcCInvoiceDescription | character | CInvoice.CInvoiceDescription | Description. A brief description of the invoice. The system generates a default description based on the Reference and Supplier Code. |
| ttCInvoiceDiscountDueDate | date | CInvoice.CInvoiceDiscountDueDate | Discount Due Date.This field indicates the last date a discount applies, calculated by the system based on the credit terms and the invoice date. User can modify this field without affecting the credit terms. |
| ttCInvoiceDueDate | date | CInvoice.CInvoiceDueDate | Due Date.This field indicates the date when payment become due. This field can be modified without affecting the credit terms. This field is calculated by the system based on the credit terms and the invoice date. |
| tdCInvoiceExchangeRate | decimal | CInvoice.CInvoiceExchangeRate | Exchange Rate. The exchange rate used by the invoice. The BC Invoice Amount is calculated based on the exchange rate. If user modify the TC Invoice Amount, the BC invoice amount is automatically adjusted. |
| tlCInvoiceIsERS | logical | CInvoice.CInvoiceIsERS | ERS: This field indicates if the invoice is created using Evaluated Receipts Settlement (ERS) functions. |
| tlCInvoiceIsInitialStatus | logical | CInvoice.CInvoiceIsInitialStatus | Initial Status. This field indicates if the invoice is in initial status. |
| api annotation: | This field defaults from the Initial Status field of the Invoice status code. | ||
| tlCInvoiceIsOpen | logical | CInvoice.CInvoiceIsOpen | 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 | ||
| tlCInvoiceIsSelected | logical | CInvoice.CInvoiceIsSelected | Selected. This field indicates whether the invoice is included in a payment selection. This field is read-only. |
| tdCInvoiceOriginalCreditCC | decimal | CInvoice.CInvoiceOriginalCreditCC | 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. |
| tdCInvoiceOriginalCreditLC | decimal | CInvoice.CInvoiceOriginalCreditLC | 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. |
| tdCInvoiceOriginalCreditTC | decimal | CInvoice.CInvoiceOriginalCreditTC | 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. |
| tdCInvoiceOriginalDebitCC | decimal | CInvoice.CInvoiceOriginalDebitCC | 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. |
| tdCInvoiceOriginalDebitLC | decimal | CInvoice.CInvoiceOriginalDebitLC | 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. |
| tdCInvoiceOriginalDebitTC | decimal | CInvoice.CInvoiceOriginalDebitTC | 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. |
| tcCInvoicePoDomain | character | CInvoice.CInvoicePoDomain | PO Domain. This field indicates which domain the purchase order belongs to. |
| tcCInvoicePoNbr | character | CInvoice.CInvoicePoNbr | PO Number. This fields identifies the PO receipts which the invoice matches. |
| tiCInvoicePosting_ID | integer | CInvoicePosting.CInvoicePosting_ID | Record ID |
| ttCInvoicePostingDate | date | CInvoice.CInvoicePostingDate | Posting Date. This filed indicates the date on which the invoice is to be posted. |
| api annotation: | This field defaults from the invoice creation date. | ||
| tiCInvoicePostingPeriod | integer | CInvoice.CInvoicePostingPeriod | GL Period.This field indicates the period when the invoice to be posted. If this field is modified, the posting and tax dates are changed correspondingly. |
| api annotation: | This field defaults to the period associated with the posting date. | ||
| tcCInvoicePostingType | character | CInvoicePosting.CInvoicePostingType | 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. |
| tiCInvoicePostingYear | integer | CInvoice.CInvoicePostingYear | Year.This field indicates the accounting year 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 associated with the posting date. | ||
| tdCInvoiceRateScale | decimal | CInvoice.CInvoiceRateScale | Scale Factor. This field indicates the scale factor applying to the exchange rate in use for foreign currency payments. |
| tcCInvoiceType | character | CInvoice.CInvoiceType | Invoice Type. This field identifies the invoice type. The value can be Invoice Correction and Credit Note Correction type only when the appropriate daybook types have already been defined. |
| tiCInvoiceVoucher | integer | CInvoice.CInvoiceVoucher | Voucher. This field displays the numeric identifier assigned to the posting. When the daybook of the journal entry is changed (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. |
| tiCIRECPostingLine_ID | integer | CInvoicePosting.CIRECPostingLine_ID | Link to PostingLine |
| tiCompany_ID | integer | PostingLine.Company_ID | Link to Company |
| tcCompanyCode | character | Company.CompanyCode | Entity Code |
| tiCostCentre_ID | integer | PostingLine.CostCentre_ID | Cost Center Code |
| tiCurrency_ID | integer | PostingLine.Currency_ID | Currency Code |
| tcCurrencyCode | character | Currency.CurrencyCode | Currency Code |
| tiDivision_ID | integer | PostingLine.Division_ID | Sub-Account Code |
| tiGL_ID | integer | PostingLine.GL_ID | GL Description |
| tcJournalCode | character | Journal1.JournalCode | A daybook code (maximum eight characters). |
| tcJournalCode1 | character | Journal2.JournalCode | A daybook code (maximum eight characters). |
| tcJournalTypeCode | character | Journal2.JournalTypeCode | A daybook type code. |
| api annotation: | Value for this field defaults to "Journal Entries". | ||
| tiPeriod_ID | integer | PostingLine.Period_ID | Link to Period |
| tiPosting_ID | integer | PostingLine.Posting_ID | Link to Posting |
| ttPostingDate | date | PostingLine.PostingDate | Posting Date. |
| api annotation: | If this field is blank, it gets a default value equal to the value of PostingDate in tPosting. | ||
| 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 | ||
| tlPostingIsCorrection | logical | Posting.PostingIsCorrection | Indicates whether the posting is part of a correction action. |
| api annotation: | Value for this field defaults to "false". | ||
| tlPostingIsReplacement | logical | Posting.PostingIsReplacement | Indicate whether the posting is a replacement of an existing posting. |
| api annotation: | Value for this field defaults to "false". For reversal postings, either automatic or manual - this value defaults to "true". | ||
| tlPostingIsReversing | logical | Posting.PostingIsReversing | Indicate whether the posting is a reversal of an existing posting. |
| api annotation: | Value for this field defaults to "false". | ||
| tlPostingIsReversingBySign | logical | Posting.PostingIsReversingBySign | Indicate whether the mathematical inversion - inverse the mathematic sign of the amounts (+ => - and - => +) - has been applied. |
| api annotation: | Value for this field defaults to "false". | ||
| tiPostingLine_ID | integer | PostingLine.PostingLine_ID | Record ID |
| tdPostingLineCCRate | decimal | PostingLine.PostingLineCCRate | The exchange rate used to convert between transaction (TC) and statutory(SC) amounts. |
| api annotation: | Default value for this field depends on the exchangerate shared set specified for the current domain. | ||
| tdPostingLineCCScale | decimal | PostingLine.PostingLineCCScale | A decimal number that must be multiplied by the exchange rate to get the real exchange rate. Its format is 9999999.9999999 and it was introduced to extend the accuracy of the exchange rate. |
| api annotation: | The default value is 1. | ||
| tcPostingLineCostCentreText | character | PostingLine.PostingLineCostCentreText | Cost Center |
| api annotation: | Value for this field defaults to blank. | ||
| 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. | ||
| tdPostingLineCreditPC | decimal | PostingLine.PostingLineCreditPC | PC Credit |
| api annotation: | This field is obsolete and can be left blank. | ||
| tdPostingLineCreditTC | decimal | PostingLine.PostingLineCreditTC | TC Credit |
| 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. | ||
| tdPostingLineDebitPC | decimal | PostingLine.PostingLineDebitPC | PC Debit |
| api annotation: | This field is obsolete. | ||
| tdPostingLineDebitTC | decimal | PostingLine.PostingLineDebitTC | TC Debit |
| 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. | ||
| tcPostingLineProjectText | character | PostingLine.PostingLineProjectText | Project |
| api annotation: | Value for this field defaults to blank. | ||
| tcPostingLineSafText | character | PostingLine.PostingLineSafText | SAF |
| api annotation: | Value for this field defaults to blank. | ||
| tiPostingLineSequence | integer | PostingLine.PostingLineSequence | Sequence |
| 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. | ||
| tiPostingLineTransaction_ID | integer | PostingLine.PostingLineTransaction_ID | Link to Transaction |
| tcPostingOriginAddressCode | character | Posting.PostingOriginAddressCode | For invoices created with Invoice Post and Print, the address code of the bill-to customer is stored in this field. |
| tcPostingOriginatorReference | character | Posting.PostingOriginatorReference | Original Posting Reference. this field must contain the key values of the refered posting, if this posting is a manual reversal or replacement of an existing posting. |
| api annotation: | Value for this field defaults to blank. | ||
| tcPostingOriginDaybookCode | character | Posting.PostingOriginDaybookCode | Daybook Code (normally this corresponds with our JournalCode) MfgPro equivalent: glt_dy_code |
| tcPostingOriginDaybookNumber | character | Posting.PostingOriginDaybookNumber | Daybook Number (normally this corresponds with our PostingVoucher) MfgPro equivalent: glt_dy_num |
| tcPostingOriginDocument | character | Posting.PostingOriginDocument | Transaction History Number (Inventory or Operations) or Invoice Number (Sales Order) MfgPro equivalent: glt_doc |
| tcPostingOriginDocumentType | character | Posting.PostingOriginDocumentType | Document Type (I for Invoice, OP for Work Orders) MfgPro equivalent: glt_doc_type |
| tlPostingOriginIsExternal | logical | Posting.PostingOriginIsExternal | Indicate whether the posting is from an External Origin. When creating cross company postings, set this to true. |
| api annotation: | Value for this field defaults to false. | ||
| tcPostingOriginReference | character | Posting.PostingOriginReference | GL Reference Number. Format is ZZYYMMDD999999 where ZZ = module (IC, SO, WO) YY = Year, MM = Month, DD = Day, 999999 = Running Journal Number. MfgPro equivalent: glt_ref |
| tcPostingOriginTransType | character | Posting.PostingOriginTransType | System generated code used to identify a transaction (IC for Inventory, WO for Work Orders, SO for Sales Orders, FA for Fixed Assets) MfgPro equivalent: glt_tr_type |
| tcPostingText | character | Posting.PostingText | Free text describing the posting. |
| api annotation: | Value for this field defaults to blank | ||
| 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. | ||
| tiPostingYear | integer | Posting.PostingYear | The GL calendar year for the posting. |
| tiPostingYearPeriod | integer | PostingLine.PostingYearPeriod | The GL calendar year/period for the journal entry. |
| api annotation: | In Create mode, it will get be defaulted to the value for the field PostingYearPeriod of tPosting. | ||
| tiProject_ID | integer | PostingLine.Project_ID | Description |
| CInvoiceCustom | character | calculated | custom fields |
| CurrencyCustom | character | calculated | custom fields |
| Journal1Custom | character | calculated | custom fields |
| CompanyCustom | character | calculated | custom fields |
| CInvoicePostingCustom | character | calculated | custom fields |
| PostingCustom | character | calculated | custom fields |
| Journal2Custom | character | calculated | custom fields |
| PostingLineCustom | character | calculated | custom fields |
| ti_sequence | integer | calculated | primary index |
| tc_rowid | character | calculated | = rowid(CInvoice),rowid(CInvoicePosting),rowid(Posting),rowid(Journal2),rowid(PostingLine),rowid(Company),rowid(Currency),rowid(Journal1) |
QadFinancials
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 = "BCInvoice".
create ttContext.
assign ttContext.propertyName = "methodName"
ttContext.propertyValue = "CInvoiceForLegalDocument".
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/bcinvoice.cinvoiceforlegaldocument.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.