project QadFinancials > class BCInvoiceJournalEntry > dataset tApiPostingLineCIJE

table tApiPostingLineCIJE

Description

ApiPostingLineCIJE

field namedata typedescription
PostingLine_IDinteger
Company_IDinteger
PostingLineMaster_IDinteger
PostingLineTransaction_IDinteger
Posting_IDinteger
CostCentre_IDinteger
Currency_IDinteger
Division_IDinteger
GL_IDinteger
Project_IDinteger
IntercoBusinessRelation_IDinteger
Period_IDinteger
CrossCompany_IDinteger
CrossCompanyPosting_IDinteger
CrossCompanyPostingLine_IDinteger
PostingLineSequenceinteger
PostingLineTextcharacter
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.
PostingLineDebitLCdecimal(4)
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.
PostingLineDebitTCdecimal(4)
PostingLineDebitCCdecimal(4)
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.
PostingLineDebitPCdecimal(4)
api annotation:This field is obsolete.
PostingLineCreditLCdecimal(4)
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.
PostingLineCreditTCdecimal(4)
PostingLineCreditCCdecimal(4)
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
PostingLineCreditPCdecimal(4)
api annotation:This field is obsolete and can be left blank.
PostingLineIsProjPostinglogical
PostingLineQTYdecimal(10)
api annotation:Value for this field defaults to 0.0000.
PostingLineProjectTextcharacter
api annotation:Value for this field defaults to blank.
PostingLineCostCentreTextcharacter
api annotation:Value for this field defaults to blank.
PostingLineSafTextcharacter
api annotation:Value for this field defaults to blank.
PostingLineExchangeRatedecimal(10)
api annotation:Default value for this field depends on the exchang erate shared set specified for the current domain.
PostingLineRateScaledecimal(10)
api annotation:The default value is 1.
PostingLineCCRatedecimal(10)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.
PostingLineCCScaledecimal(10)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.
PostingYearPeriodintegerThe 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.
PostingDatedatePosting Date.
api annotation:If this field is blank, it gets a default value equal to the value of PostingDate in tPosting.
PostingLineCrossExternRefcharacterExt Reference (Cross-Cy) - must be filled when create a cross-company posting.
api annotation:Value for this field defaults to blank.
PostingLineOriginLineNbrintegerEquivalent 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.
PostingLineMirrorRefcharacterThis 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.
PostingLineMirrorTypecharacterSOURCE or MIRROR (Depending if the posting line uses the source account or the mirror account).
api annotation:Value for this field defaults to blank.
PostingLineAddGLNbrinteger
PostingLineGrossIncAccRefcharacter
PostingLineAddGLNbrDatedate
PostingLineLegalDocNbrcharacter
tcProjectDescriptioncharacter
tcGLCodecharacterThe GL account used in this posting line.
api annotation:This GL account must be active and from the shared set of the entity. The same GL account can appear twice or more in the same posting.

GL accounts used in the postings must be of type 'Manual'.

When the GL account is an open item account, the postings on the account are stored as individual items with a balance.

Each posting on this account type results either from the creation of a new open item ('INITIAL") or a change in the balance of an existing open item ("MOVEMENT").
tlPostingLineIsLocalCurrencylogicalThis flag indicates that the currency for the posting line is the base currency. This is set automatically.
tiVatPostIDintegerVAT post ID
tcGLDescriptioncharacter
tlGLIsAutomaticAccountlogical
tcGLTypeCodecharacter
api annotation:GL accounts used in the postings must be of type "Manual".

When the account is an open item account, then the postings on the account are stored as individual items with a balance.

Each possting on this account type results from either the creation of a new open item ("INITIAL") or a change in the balance of an existing open item ("MOVEMENT").
tcUnitCodecharacter
tcAllocationTypecharacterType of the open item posting. For example, a new item or a link to an existing item.
api annotation:Each posting line for an open item account must contain either:

Information for the creation of a new open item.
tcAllocationType = "INITIAL",
tcAllocationKey = a new mnemonic (reference to an open item).

Or

a reference to an existing posting on the same account .
tcAllocationType = "MOVEMENT"
tcAllocationKey = an existing reference to an open item.
tcAllocationKeycharacterReference key to an open item.
api annotation:Each posting line for an open item account must contain either:

Information for the creation of a new open item.
tcAllocationType = "INITIAL",
tcAllocationKey = a new mnemonic (reference to an open item).

Or

a reference to an existing posting on the same account .
tcAllocationType = "MOVEMENT"
tcAllocationKey = an existing reference to an open item.
tcAllocationPostingLinecharacter
tcIntercoBusinessRelationCodecharacterWhen the GL is an intercompany account (Intercompany Account box checked), then an intercompany business relation must be entered on the posting line.
api annotation:When the field tcIntercoBusinessRelationCode is blank and the GL has a default business relation specified, this default is used.

When the account is a fixed intercompany account (Fixed Intercompany box checked), the default intercompany business relation is the only valid value.
tcCurrencyCodecharacterThe currency code of this posting line.
api annotation:If a tcCurrencyCode is supplied for a local currency posting, this currency must be the local currency of the current entity.

When the posting account is a single currency account, then the posting line must contain the currency in tcCurrencyCode.

When a posting is in the local currency of the entity, the TC amount must equal the LC value.
tcDivisionCodecharacterThe sub-account code of the GL account used in this posting line.
api annotation:When the account is defined with sub-account analysis, then a sub-account must be entered on the posting line. If so, then this field defaults to the sub-account found in the account definition.

The account and sub-account combination must be allowed by the COA mask.
tcCostCentreCodecharacterThe cost center code of the account used in this posting line.
api annotation:When the account is defined with cost center analysis, a cost center code must be entered on the posting line. The field defaults to the cost center in the account definition (if specified).

The account and cost center combination must be allowed by the COA mask.

If the posting account allows dual analysis, then both cost center and project analysis must be specified on the posting line. If left blank, the default values found in the account definition are used.
tcProjectCodecharacterThe project code of the account used in this posting line.
api annotation:When the account is defined with project analysis, a project code must be entered on the posting line. The field defaults to the project in the account definition (if specified).

The account and project combination must be allowed by the COA mask.

If the posting account allows dual analysis, then both cost center and project analysis must be specified on the posting line. If left blank, the default values found in the account definition are used.
tlGLIsDebitAccountlogical
tcCrossCompanyCurrencyCodecharacterCrossCompanyCurrencyCode
tcCrossCompanyGLCodecharacter
api annotation:Cross-company is a special type of intercompany. When the data of the other company is also in the same database, you can create a cross-company posting that generates a second posting in that other company's accounting. Both postings balance each other and are also linked to each other. So cross-company postings are pairs of postings where one posting is in one entity and the other posting is in another entity. Both postings are linked to each other with reference fields.
tcCrossCompanyIntercoCodecharacter
tcCrossCompanyCodecharacter
tcDivisionDescriptioncharacter
tlLinkedCrCyDaemonReqExistslogicalThis calculated field is set to True when the posting is a cross-company posting and is created by the cross-company daemon, otherwise its value is set to false, and no logic is applied to calculate the field value for modified records
tcCostCentreDescriptioncharacter
tlSkipCOAValForPeriodCostinglogical
CustomShort0character
CustomShort1character
CustomShort2character
CustomShort3character
CustomShort4character
CustomShort5character
CustomShort6character
CustomShort7character
CustomShort8character
CustomShort9character
CustomCombo0character
CustomCombo1character
CustomCombo2character
CustomCombo3character
CustomCombo4character
CustomCombo5character
CustomCombo6character
CustomCombo7character
CustomCombo8character
CustomCombo9character
CustomLong0character
CustomLong1character
CustomNotecharacter
CustomDate0date
CustomDate1date
CustomDate2date
CustomDate3date
CustomDate4date
CustomInteger0integer
CustomInteger1integer
CustomInteger2integer
CustomInteger3integer
CustomInteger4integer
CustomDecimal0decimal(4)
CustomDecimal1decimal(4)
CustomDecimal2decimal(4)
CustomDecimal3decimal(4)
CustomDecimal4decimal(4)
CustomShort10character
CustomShort11character
CustomShort12character
CustomShort13character
CustomShort14character
CustomShort15character
CustomShort16character
CustomShort17character
CustomShort18character
CustomShort19character
CustomCombo10character
CustomCombo11character
CustomCombo12character
CustomCombo13character
CustomCombo14character
CustomDecimal5decimal(4)
CustomDecimal6decimal(4)
CustomDecimal7decimal(4)
CustomDecimal8decimal(4)
CustomDecimal9decimal(4)
CustomDate5date
CustomDate6date
CustomDate7date
CustomDate8date
CustomDate9date
LastModifiedDatedate
LastModifiedTimeinteger
LastModifiedUsercharacter
QADC01characterunused QAD reserved field
QADC02characterunused QAD reserved field
QADT01dateunused QAD reserved field
QADD01decimal(10)unused QAD reserved field
tc_Rowidcharacter
tc_ParentRowidcharacter
tc_Statuscharacter


Internal usage


QadFinancials
method BCInvoiceJournalEntry.ApiStdMaintainTT
method BCInvoiceJournalEntry.ApiStdMaintainTTV01