| iiCompanyId | integer | Company id |
| iiPostingID | integer |
each PostingLine where
first Division (outer-join) where
first GL (inner-join) where
each PostingVat (inner-join) where
| field name | data type | db field | description |
|---|---|---|---|
| tiCompany_ID | integer | PostingLine.Company_ID | Link to Company |
| tiCostCentre_ID | integer | PostingLine.CostCentre_ID | Cost Center Code |
| tiCrossCompany_ID | integer | PostingLine.CrossCompany_ID | Link to Company |
| tiCrossCompanyPosting_ID | integer | PostingLine.CrossCompanyPosting_ID | Posting (Cross-Cy) |
| tiCrossCompanyPostingLine_ID | integer | PostingLine.CrossCompanyPostingLine_ID | Posting line (Cross-Cy) |
| tiCurrency_ID | integer | PostingLine.Currency_ID | Currency Code |
| tiCurrency_ID2 | integer | PostingVat.Currency_ID | Currency Code |
| tiDivision_ID | integer | PostingLine.Division_ID | Sub-Account Code |
| tcDivisionCode | character | Division.DivisionCode | Sub-Account |
| tcFromTxzTaxZone | character | PostingVat.FromTxzTaxZone | From Tax Zone. |
| api annotation: | ? | ||
| tiGL_ID | integer | PostingLine.GL_ID | GL Description |
| tcGLCode | character | GL.GLCode | A code identifying the GL account. |
| tiIntercoBusinessRelation_ID | integer | PostingLine.IntercoBusinessRelation_ID | Intercompany Code |
| tiPeriod_ID | integer | PostingLine.Period_ID | Link to Period |
| tiPeriodMark_ID | integer | PostingVat.PeriodMark_ID | Link to PeriodMark |
| tiPosting_ID | integer | PostingLine.Posting_ID | Link to Posting |
| tiPosting_ID2 | integer | PostingVat.Posting_ID | Link to Posting |
| tiPostingLine_ID | integer | PostingLine.PostingLine_ID | Record ID |
| 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 |
| tcPostingLineCrossExternRef | character | PostingLine.PostingLineCrossExternRef | Ext Reference (Cross-Cy) - must be filled when create a cross-company posting. |
| api annotation: | Value for this field defaults to blank. | ||
| 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. | ||
| tlPostingLineIsProjPosting | logical | PostingLine.PostingLineIsProjPosting | Project Posting |
| tiPostingLineMaster_ID | integer | PostingLine.PostingLineMaster_ID | Link to Master |
| tcPostingLineMirrorRef | character | PostingLine.PostingLineMirrorRef | This holds a reference number to link the source and mirror postinglines together. --> Source account 1 and mirror account 1 will have the same reference. --> Source account 2 and mirror account 2 will also have the same reference (but different from source and mirror account 1). |
| api annotation: | Value for this field defaults to blank. | ||
| tcPostingLineMirrorType | character | PostingLine.PostingLineMirrorType | SOURCE or MIRROR (Depending if the posting line uses the source account or the mirror account). |
| api annotation: | Value for this field defaults to blank. | ||
| tiPostingLineOriginLineNbr | integer | PostingLine.PostingLineOriginLineNbr | Equivalent to PostingLineSequence, however there is a difference in format and the value may differ in a number of specific cases. MfgPro Equivalent: glt_line |
| api annotation: | Value for this field defaults to 0. | ||
| tcPostingLineProjectText | character | PostingLine.PostingLineProjectText | Project |
| api annotation: | Value for this field defaults to blank. | ||
| tdPostingLineQTY | decimal | PostingLine.PostingLineQTY | Quantity |
| api annotation: | Value for this field defaults to 0.0000. | ||
| tdPostingLineRateScale | decimal | PostingLine.PostingLineRateScale | Scale Factor |
| api annotation: | The default value is 1. | ||
| 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 |
| tiPostingVat_ID | integer | PostingVat.PostingVat_ID | Record ID |
| tdPostingVatBaseCreditCC | decimal | PostingVat.PostingVatBaseCreditCC | SC (Statutory Currency) Base Credit amount. |
| tdPostingVatBaseCreditLC | decimal | PostingVat.PostingVatBaseCreditLC | BC (Base/Local Currency) Base Credit amount. |
| tdPostingVatBaseCreditTC | decimal | PostingVat.PostingVatBaseCreditTC | TC (Transaction Currency) Base Credit amount. |
| tdPostingVatBaseDebitCC | decimal | PostingVat.PostingVatBaseDebitCC | SC (Statutory Currency) Base Debit amount. |
| tdPostingVatBaseDebitLC | decimal | PostingVat.PostingVatBaseDebitLC | BC (Base/Local Currency) Base Debit amount. |
| tdPostingVatBaseDebitTC | decimal | PostingVat.PostingVatBaseDebitTC | TC (Transaction Currency) Base Debit amount. |
| tdPostingVatExchangeRate | decimal | PostingVat.PostingVatExchangeRate | TC/BC Exchange Rate. |
| api annotation: | ? | ||
| tcPostingVatInOut | character | PostingVat.PostingVatInOut | In/Out? |
| api annotation: | Aivalable value for this field: "INPUT" represents purchases, "OUTPUT" represents sales. | ||
| tlPostingVatIsAbsRet | logical | PostingVat.PostingVatIsAbsRet | Absorbed Retained |
| tlPostingVatIsReverseCharge | logical | PostingVat.PostingVatIsReverseCharge | Reverse Charge |
| tlPostingVatIsSuspDel | logical | PostingVat.PostingVatIsSuspDel | Suspended/Delayed Tax |
| tiPostingVatOwnTaxDeclarat | integer | PostingVat.PostingVatOwnTaxDeclarat | Own Declaration Tax |
| tcPostingVatOwnTaxIDFeder | character | PostingVat.PostingVatOwnTaxIDFeder | Own Federal Tax? |
| api annotation: | ? | ||
| tcPostingVatOwnTaxIDMisc1 | character | PostingVat.PostingVatOwnTaxIDMisc1 | Own Miscellaneous Tax 1? For reference and documentation purposes, enter any other tax identification numbers that are useful. |
| api annotation: | ? | ||
| tcPostingVatOwnTaxIDMisc2 | character | PostingVat.PostingVatOwnTaxIDMisc2 | Own Miscellaneous Tax 2 |
| tcPostingVatOwnTaxIDMisc3 | character | PostingVat.PostingVatOwnTaxIDMisc3 | Own Miscellaneous Tax 3 |
| tcPostingVatOwnTaxIDState | character | PostingVat.PostingVatOwnTaxIDState | Own State Tax? |
| api annotation: | ? | ||
| tdPostingVatRateScale | decimal | PostingVat.PostingVatRateScale | Scale Factor (TC/BC). |
| api annotation: | ? | ||
| tdPostingVatTaxCreditCC | decimal | PostingVat.PostingVatTaxCreditCC | SC (Statutory Currency) Tax Credit amount. |
| api annotation: | ? | ||
| tdPostingVatTaxCreditLC | decimal | PostingVat.PostingVatTaxCreditLC | BC (Base/Local) Tax Credit amount. |
| api annotation: | ? | ||
| tdPostingVatTaxCreditTC | decimal | PostingVat.PostingVatTaxCreditTC | TC (Transaction Currency) Tax Credit amount. |
| api annotation: | ? | ||
| tdPostingVatTaxDebitCC | decimal | PostingVat.PostingVatTaxDebitCC | SC (Statutory Currency) Tax Debit amount. |
| api annotation: | ? | ||
| tdPostingVatTaxDebitLC | decimal | PostingVat.PostingVatTaxDebitLC | BC (Base Currency) Tax Debit amount. |
| api annotation: | ? | ||
| tdPostingVatTaxDebitTC | decimal | PostingVat.PostingVatTaxDebitTC | TC (Transaction Currency) Tax Debit amount. |
| api annotation: | ? | ||
| tcPostingVatTaxIDFeder | character | PostingVat.PostingVatTaxIDFeder | Federal Tax? |
| api annotation: | ? | ||
| tcPostingVatTaxIDMisc1 | character | PostingVat.PostingVatTaxIDMisc1 | Miscellaneous Tax 1. For reference and documentation purposes, enter any other tax identification numbers that are useful. |
| api annotation: | ? | ||
| tcPostingVatTaxIDMisc2 | character | PostingVat.PostingVatTaxIDMisc2 | Miscellaneous Tax 2 |
| tcPostingVatTaxIDMisc3 | character | PostingVat.PostingVatTaxIDMisc3 | Miscellaneous Tax 3 |
| tcPostingVatTaxIDState | character | PostingVat.PostingVatTaxIDState | State Tax? |
| api annotation: | ? | ||
| ttPostingVatTaxPointDate | date | PostingVat.PostingVatTaxPointDate | The date when this posting is taken into account in the Tax sub-adminstration. |
| api annotation: | ? | ||
| tcPostingVatTaxTransType | character | PostingVat.PostingVatTaxTransType | Tax Transaction Type? |
| api annotation: | Available value for this field: 29 represents "AP Payment Check (Discount at Payment)", 55 represents "AP Transactions", 22 represents "AP Invoice", 18 represents "AR Invoice", 16 represents "AR Operational Invoice", 19 represents "AR Payment (Discount at Payment)", 56 represents "AR Transactions", 45 represents "Logistic Accounting - DO Shipment", 27 represents "Logistic Accounting - PO Receipt", 43 represents "Logistic Accounting - SO Shipment", 20 represents "Purchase Order", 21 represents "Purchase Order Receipt", 25 represents "Purchase Order Return" | ||
| tcPostingVatTransType | character | PostingVat.PostingVatTransType | Transaction Type? |
| api annotation: | Available value for this field is: ACQUISITION represents "IC Acquisition", BOTH represents "Both", EXPORT represents "Export", IN represents "IN", OUT represents "OUT", IMPORT represents "Import", INLAND-PURCHASE represents "INLAND-PURCHASE", INLAND-SALES represents "INLAND-SALES", PURCHASE represents "Inland Purchase", SALES represents "Inland Sales", SUPPLY represents "IC Supply", TRIANGULARPURCHASE represents "Triangular Purchase", TRIANGULARSALES represents "Triangular Sales". | ||
| 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 |
| tcToTxzTaxZone | character | PostingVat.ToTxzTaxZone | To Tax Zone |
| api annotation: | ? | ||
| tcTxclTaxCls | character | PostingVat.TxclTaxCls | Tax Class. A tax class previously defined in Tax Class Maintenance. Tax classes group addresses taxed at specific rates or that are tax-exempt and help determine the default tax environment (set of tax types) for related transactions. |
| api annotation: | The value of Tax Class defaults to the header of transactions created for this address | ||
| tcTxenvTaxEnv | character | PostingVat.TxenvTaxEnv | Tax Environment. A code (maximum 16 characters) that identifies a set of tax types for a tax zone/tax class combination. On transactions, this code identifies the transaction or line-item tax environment. |
| api annotation: | ? | ||
| tcTxtyTaxType | character | PostingVat.TxtyTaxType | Tax Type |
| tcTxuTaxUsage | character | PostingVat.TxuTaxUsage | Tax Usage. A tax usage code previously defined in Tax Usage Maintenance. Tax usage codes identify the normal use of items sold to this address. Common tax usages are retail, manufacturing, and industrialization. |
| api annotation: | The value of Tax Usage defaults to the header of transactions created for this address. | ||
| tiVat_ID | integer | PostingVat.Vat_ID | Tax Code |
| tiVatGroup_ID | integer | PostingVat.VatGroup_ID | Tax Group Code |
| tiVatPeriod_ID | integer | PostingVat.VatPeriod_ID | Link to VatPeriod |
| tiVatRule_ID | integer | PostingVat.VatRule_ID | Link to VatRule |
QadFinancials