| field name | data type | mnd. | description |
|---|---|---|---|
| Posting_ID | integer | yes | Record ID |
| Company_ID | integer | yes | Link to Company |
| Journal_ID | integer | yes | Daybook Code |
| ReportingJournal_ID | integer | no | Reporting Daybook |
| Period_ID | integer | yes | Link to Period |
| PeriodMark_ID | integer | yes | Link to PeriodMark |
| CreatorUsr_ID | integer | yes | Login |
| LastVerifiedUsr_ID | integer | no | Link to Usr |
| LastApprovedUsr_ID | integer | no | Link to Usr |
| AutoReversalPosting_ID | integer | no | Automatic Reversal Posting |
| PostingVoucher | integer | yes | 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. | ||
| PostingDate | date | yes | 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). |
| PostingSystemDate | date | yes | 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. | ||
| PostingValueDate | date | no | The value date (used for banking entries). |
| PostingText | character(40) | no | Free text describing the posting. |
| api annotation: | Value for this field defaults to blank | ||
| PostingSecondText | character(40) | no | Second Description |
| PostingBusinessRelationTxt | character(40) | no | When the posting is a transaction linked to a business relation (for example, an invoice posting), this field contains the Business Relation Name. Used for information purposes on reports and browses. |
| api annotation: | Value for this field defaults to blank. | ||
| PostingInvoiceReferenceTxt | character(50) | no | 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 | ||
| PostingParentText | character(40) | no | Contains the description field from the parent object that triggered the posting. When the posting is an invoice posting, this field contains the invoice description. When the posting is a banking entry posting, the description of the bank statement line is copied to this field, etc. Used for information purposes on reports and browses. |
| api annotation: | Value for this field defaults to blank. | ||
| PostingPeriod | integer | yes | The GL period for the posting. The period must be open. |
| PostingYear | integer | yes | The GL calendar year for the posting. |
| PostingYearPeriod | integer | yes | The GL calendar year/period for the posting. This field is determined by "PostingPeriod" and "PostingYear". |
| api annotation: | If Partial Update is true, the value defaults using PostingPeriod and PostingYear. | ||
| PostingOriginIsExternal | logical | no | 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. | ||
| PostingOriginReference | character(22) | no | 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 |
| PostingOriginDocument | character(22) | no | Transaction History Number (Inventory or Operations) or Invoice Number (Sales Order) MfgPro equivalent: glt_doc |
| PostingOriginDocumentType | character(2) | no | Document Type (I for Invoice, OP for Work Orders) MfgPro equivalent: glt_doc_type |
| PostingOriginTransType | character(2) | no | 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 |
| PostingOriginDaybookCode | character(8) | no | Daybook Code (normally this corresponds with our JournalCode) MfgPro equivalent: glt_dy_code |
| PostingOriginDaybookNumber | character(40) | no | Daybook Number (normally this corresponds with our PostingVoucher) MfgPro equivalent: glt_dy_num |
| PostingBatchNumber | character(8) | no | Some financial input programs allow you to enter a batch number and to keep a control total on the screen of all the transactions entered with the same batch number. |
| api annotation: | Not applicable for application integration. | ||
| PostingOriginAddressCode | character(20) | no | For invoices created with Invoice Post and Print, the address code of the bill-to customer is stored in this field. |
| PostingOriginatorReference | character(40) | no | 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. | ||
| PostingIsReplacement | logical | yes | 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". | ||
| PostingIsReversing | logical | yes | Indicate whether the posting is a reversal of an existing posting. |
| api annotation: | Value for this field defaults to "false". | ||
| PostingIsReversingBySign | logical | yes | 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". | ||
| PostingIsZeroValueAllowed | logical | yes | Indicate whether zero values are allowed in the posting lines. |
| api annotation: | Value for this field defaults to "false". | ||
| PostingIsSkipAutoAssignLC | logical | yes | When a LC field (Base Currency Amount field of PostingLine) is left zero, but the TC field (transaction currency amount) is not zero, then the posting component automatically calculates the corresponding value for the LC field. With some postings, this behavior is not wanted and can be suppressed by setting this flag to "true". |
| api annotation: | Value for this field defaults to "false". | ||
| PostingAddGLNbr | integer | no | When additional GL numbering is enabled for an entity, all postings for this entity are assigned a continuous, uninterrupted incremental sequence numbers as the value for this field. |
| api annotation: | When additional GL numbering is not enabled for the current entity, value for this field defaults to 0. | ||
| PostingAddGLNbrDate | date | no | Additional GL Numbering Date |
| PostingAddGLNbrRevDate | date | no | Additional GL Numbering Reversal Date |
| PostingVerifyStatus | character(40) | yes | China Financial Regulation requires that all GL transactions be verified as well as approved. This field holds the verification status. |
| api annotation: | Value for this field defaults to "INITIAL". | ||
| PostingVerifyComments | character(40) | no | When running the process of verification, the verifier can add some comments on the transaction. |
| api annotation: | Value for this field defaults to blank. | ||
| PostingVerifiedDate | date | no | The date when this posting is last verified. |
| api annotation: | Value for this field defaults to blank. | ||
| PostingVerifiedTime | integer | no | Last Verified Time. |
| api annotation: | System generates a default value for this field depending on when this posting was last verified. The combination of "PostingVerifiedDate" and "PostingVerifiedTime" uniquely identify the time at which this posting was last verified. | ||
| PostingApproveStatus | character(40) | yes | China Financial Regulation requires that all the GL transactions must be verified as well as approved. This field holds the Approval status. |
| api annotation: | Value for this field defaults to "INITIAL". | ||
| PostingApproveComments | character(40) | no | When running the process of approval, the approver can add some comments on the transaction. |
| api annotation: | Value for this field defaults to blank. | ||
| PostingApprovedDate | date | no | The date on which this posting was last approved. |
| api annotation: | Value for this field defaults to blank. | ||
| PostingApprovedTime | integer | no | Last Approved Time. |
| api annotation: | The system generates default values for this field, depending on when this posting was last approved. The combination of "PostingApprovedDate" and "PostingApprovedTime" uniquely identify the time at which this posting was last approved. | ||
| PostingMirrorRef | character(20) | no | When Mirror Accounting is activated, postings that are mirrored get a reference to their paired posting. The reference contains year, daybook and voucher. |
| api annotation: | Value for this field defaults to blank. | ||
| PostingIsAutoReversal | logical | yes | Indicate whether the posting leads to an automatic reversal. |
| api annotation: | Value for this field defaults to "false". | ||
| PostingAutoReversalType | character(20) | no | If this posting is involved in automatic reversal activity of posting, value of this field will indicate whether this posting is the original one or the reversing one. It is calculated by the system. |
| api annotation: | If the flag PostingIsAutoReversal is "true", the field value defaults to "ORIGINAL ENTRY" for the original posting, and to "REVERSING ENTRY" for the reversing posting. | ||
| value list: | {&POSTINGAUTOREVERSALTYPES} + chr(2) + "":U + chr(2) + "":U | ||
| PostingAutoReversalDate | date | no | Automatic Reversal Date. |
| api annotation: | When the flag PostingIsAutoReversal is "true" - If partialupdate="false", complete this field manually with a date in a later period than the one of the original entry; If partialupdate="true", value of this field will default to the first day of the next period. | ||
| PostingBankImpRef | character(255) | no | Bank Importing Reference |
| PostingIsCorrection | logical | yes | Indicates whether the posting is part of a correction action. |
| api annotation: | Value for this field defaults to "false". | ||
| ObsoleteClosing_ID | integer | no | Link to Closing |
| PostingCreationDate | date | no | Creation Date |
| PostingCreationTimeString | character(10) | no | Seconds since midnight in HH:MM:SS |
| tcLocalCurrency | character(20) | no | Local currency code |
| api annotation: | ? | ||
| tcStatutoryCurrency | character(20) | no | Statutory Currency. |
| tcTemplateCode | character(20) | no | Template Code. A code which identifies a template. |
| api annotation: | Value for this field defaults to null. If the flag "tlSaveAsTemplate" is on, you should enter a string in this field as the posting template code. | ||
| tlSaveAsTemplate | logical | yes | Indicate whether to save the posting lines of this journal entry as a template. |
| api annotation: | Value for this field defaults to "false". | ||
| tiSharedCompanyId | integer | no | ID of the CompanyShared record. |
| tiYearForNbr | integer | no | Year used for additional GL numbering. |
| tlIsAddGLNbr | logical | no | Additional GL Numbering Enabled. Indicate whether additional GL numbering is required. |
| tiOriginVoucher | integer | no | Original Voucher - just a calculated field used by the software as temporary storage during execution of the logic. |
| tiOriginPostingId | integer | no | Original Posting ID? |
| tcJournalCode | character(8) | yes | The daybook code of this posting. |
| api annotation: | The daybook must be an active daybook in the shared set for the current entity. When the accounting layer linked to the daybook tcJournalCode is not of type "Official", some GL types are not allowed, e.g. DEBTORCONTROL, CREDITORCONTROL, VAT. When the accounting layer linked to the daybook tcJournalCode is of type "TRANSIENT"; then the GL type cannot be OPENITEM and INVENTORY. | ||
| tcLayerTypeCode | character(20) | yes | The layer type of the used daybook. |
| api annotation: | Default value for this field depends on the daybook used. | ||
| tcJournalTypeCode | character(30) | yes | The daybook type of the daybook used. |
| api annotation: | For journal entries, this field defaults to "JOURNAL ENTRY". In other types of transactions (e.g. banking entry/invoices etc), this field must be set to the correct journal type. | ||
| tiLayer_ID | integer | yes | ID of the posting daybook layer. |
| tcUsrLogin | character(20) | yes | The creator of the posting. |
| tcPeriodTypeCode | character(30) | no | Type code of the GL period 'normal', 'correction', 'closing'. |
| tcReportingJournalCode | character(8) | no | For AR and AP transactions, it is possible to have additional daybooks under which a posting should be classified during tax reporting. |
| api annotation: | For AP/AR transactions, this field defaults to the journal code of the posting. Otherwise, it remains blank. | ||
| tlJournalAccessAllowed | logical | no | Used to determine whether a user has access to modify a posting |
| CustomShort0 | character(20) | no | Custom Short Field |
| CustomShort1 | character(20) | no | Custom Short Field |
| CustomShort2 | character(20) | no | Custom Short Field |
| CustomShort3 | character(20) | no | Custom Short Field |
| CustomShort4 | character(20) | no | Custom Short Field |
| CustomShort5 | character(20) | no | Custom Short Field |
| CustomShort6 | character(20) | no | Custom Short Field |
| CustomShort7 | character(20) | no | Custom Short Field |
| CustomShort8 | character(20) | no | Custom Short Field |
| CustomShort9 | character(20) | no | Custom Short Field |
| CustomCombo0 | character(20) | no | Custom Combo Field |
| CustomCombo1 | character(20) | no | Custom Combo Field |
| CustomCombo2 | character(20) | no | Custom Combo Field |
| CustomCombo3 | character(20) | no | Custom Combo Field |
| CustomCombo4 | character(20) | no | Custom Combo Field |
| CustomCombo5 | character(20) | no | Custom Combo Field |
| CustomCombo6 | character(20) | no | Custom Combo Field |
| CustomCombo7 | character(20) | no | Custom Combo Field |
| CustomCombo8 | character(20) | no | Custom Combo Field |
| CustomCombo9 | character(20) | no | Custom Combo Field |
| CustomLong0 | character(255) | no | Custom Long Field |
| CustomLong1 | character(255) | no | Custom Long Field |
| CustomNote | character(2000) | no | Custom Note Field |
| CustomDate0 | date | no | Custom Date Field |
| CustomDate1 | date | no | Custom Date Field |
| CustomDate2 | date | no | Custom Date Field |
| CustomDate3 | date | no | Custom Date Field |
| CustomDate4 | date | no | Custom Date Field |
| CustomInteger0 | integer | no | Custom Integer Field |
| CustomInteger1 | integer | no | Custom Integer Field |
| CustomInteger2 | integer | no | Custom Integer Field |
| CustomInteger3 | integer | no | Custom Integer Field |
| CustomInteger4 | integer | no | Custom Integer Field |
| CustomDecimal0 | decimal(4) | no | Custom Decimal Field |
| CustomDecimal1 | decimal(4) | no | Custom Decimal Field |
| CustomDecimal2 | decimal(4) | no | Custom Decimal Field |
| CustomDecimal3 | decimal(4) | no | Custom Decimal Field |
| CustomDecimal4 | decimal(4) | no | Custom Decimal Field |
| CustomShort10 | character(20) | no | Custom Short Field |
| CustomShort11 | character(20) | no | Custom Short Field |
| CustomShort12 | character(20) | no | Custom Short Field |
| CustomShort13 | character(20) | no | Custom Short Field |
| CustomShort14 | character(20) | no | Custom Short Field |
| CustomCombo10 | character(20) | no | Custom Combo Field |
| CustomCombo11 | character(20) | no | Custom Combo Field |
| CustomCombo12 | character(20) | no | Custom Combo Field |
| CustomCombo13 | character(20) | no | Custom Combo Field |
| CustomCombo14 | character(20) | no | Custom Combo Field |
| CustomDecimal5 | decimal(4) | no | Custom Decimal Field |
| CustomDecimal6 | decimal(4) | no | Custom Decimal Field |
| CustomDecimal7 | decimal(4) | no | Custom Decimal Field |
| CustomDecimal8 | decimal(4) | no | Custom Decimal Field |
| CustomDecimal9 | decimal(4) | no | Custom Decimal Field |
| CustomDate5 | date | no | Custom Date Field |
| CustomDate6 | date | no | Custom Date Field |
| CustomDate7 | date | no | Custom Date Field |
| CustomDate8 | date | no | Custom Date Field |
| CustomDate9 | date | no | Custom Date Field |
| LastModifiedDate | date | no | Last Modified Date |
| LastModifiedTime | integer | no | Last Modified Time |
| LastModifiedUser | character(20) | no | Last Modified User |
| QADC01 | character(40) | no | unused QAD reserved field |
| QADC02 | character | no | unused QAD reserved field |
| QADT01 | date | no | unused QAD reserved field |
| QADD01 | decimal(10) | no | unused QAD reserved field |
| tc_Rowid | character | yes | primary index |
| tc_ParentRowid | character | no | empty string |
| tc_Status | character | no | update status |
| field name | data type | mnd. | description |
|---|---|---|---|
| PostingLine_ID | integer | yes | Record ID |
| Company_ID | integer | yes | Link to Company |
| PostingLineMaster_ID | integer | no | Link to Master |
| PostingLineTransaction_ID | integer | no | Link to Transaction |
| Posting_ID | integer | yes | Link to Posting |
| CostCentre_ID | integer | no | Cost Center Code |
| Currency_ID | integer | yes | Currency Code |
| Division_ID | integer | no | Sub-Account Code |
| GL_ID | integer | yes | GL Description |
| Project_ID | integer | no | Description |
| IntercoBusinessRelation_ID | integer | no | Intercompany Code |
| Period_ID | integer | yes | Link to Period |
| CrossCompany_ID | integer | no | Link to Company |
| CrossCompanyPosting_ID | integer | no | Posting (Cross-Cy) |
| CrossCompanyPostingLine_ID | integer | no | Posting line (Cross-Cy) |
| PostingLineSequence | integer | yes | Sequence |
| PostingLineText | character(40) | no | 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. | ||
| PostingLineDebitLC | decimal(4) | no | 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. | ||
| PostingLineDebitTC | decimal(4) | no | TC Debit |
| PostingLineDebitCC | decimal(4) | no | 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. | ||
| PostingLineDebitPC | decimal(4) | no | PC Debit |
| api annotation: | This field is obsolete. | ||
| PostingLineCreditLC | decimal(4) | no | 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. | ||
| PostingLineCreditTC | decimal(4) | no | TC Credit |
| PostingLineCreditCC | decimal(4) | no | 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 | ||
| PostingLineCreditPC | decimal(4) | no | PC Credit |
| api annotation: | This field is obsolete and can be left blank. | ||
| PostingLineIsProjPosting | logical | no | Project Posting |
| PostingLineQTY | decimal(10) | no | Quantity |
| api annotation: | Value for this field defaults to 0.0000. | ||
| PostingLineProjectText | character(40) | no | Project |
| api annotation: | Value for this field defaults to blank. | ||
| PostingLineCostCentreText | character(40) | no | Cost Center |
| api annotation: | Value for this field defaults to blank. | ||
| PostingLineSafText | character(40) | no | SAF |
| api annotation: | Value for this field defaults to blank. | ||
| PostingLineExchangeRate | decimal(10) | no | Exchange Rate |
| api annotation: | Default value for this field depends on the exchang erate shared set specified for the current domain. | ||
| PostingLineRateScale | decimal(10) | no | Scale Factor |
| api annotation: | The default value is 1. | ||
| PostingLineCCRate | decimal(10) | no | 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. | ||
| PostingLineCCScale | decimal(10) | no | 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. | ||
| PostingYearPeriod | integer | no | 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. | ||
| PostingDate | date | no | Posting Date. |
| api annotation: | If this field is blank, it gets a default value equal to the value of PostingDate in tPosting. | ||
| PostingLineCrossExternRef | character(40) | no | Ext Reference (Cross-Cy) - must be filled when create a cross-company posting. |
| api annotation: | Value for this field defaults to blank. | ||
| PostingLineOriginLineNbr | integer | no | 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. | ||
| PostingLineMirrorRef | character(20) | no | 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. | ||
| PostingLineMirrorType | character(20) | no | 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. | ||
| PostingLineAddGLNbr | integer | no | Additional Sequence Number |
| PostingLineGrossIncAccRef | character(40) | no | Gross Income Accounting Reference |
| PostingLineAddGLNbrDate | date | no | Additional Sequence Date |
| PostingLineLegalDocNbr | character(255) | no | Legal Document Nbr |
| tcProjectDescription | character(24) | no | Description |
| tcGLCode | character(8) | yes | The 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"). | ||
| tlPostingLineIsLocalCurrency | logical | no | This flag indicates that the currency for the posting line is the base currency. This is set automatically. |
| tiVatPostID | integer | no | VAT post ID |
| tcGLDescription | character(24) | yes | GL Description |
| tlGLIsAutomaticAccount | logical | yes | Automatic Account |
| tcGLTypeCode | character(20) | yes | GL Type |
| 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"). | ||
| tcUnitCode | character(20) | yes | GL Account Unit of Measure |
| tcAllocationType | character(1) | no | Type 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. | ||
| value list: | {&ALLOCATIONTYPES} + chr(2) + "":U + chr(2) + "":U | ||
| tcAllocationKey | character(40) | no | Reference 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. | ||
| tcAllocationPostingLine | character(40) | no | Open Item Posting |
| tcIntercoBusinessRelationCode | character(20) | no | When 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. | ||
| tcCurrencyCode | character(3) | yes | The 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. | ||
| tcDivisionCode | character(8) | no | The 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. | ||
| tcCostCentreCode | character(4) | no | The 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. | ||
| tcProjectCode | character(8) | no | The 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. | ||
| tlGLIsDebitAccount | logical | yes | Debit/Credit |
| tcCrossCompanyCurrencyCode | character(20) | no | CrossCompanyCurrencyCode |
| tcCrossCompanyGLCode | character(20) | no | GL (Cross-Cy) |
| 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. | ||
| tcCrossCompanyIntercoCode | character(20) | no | Interco-Code (Cross-Cy) |
| tcCrossCompanyCode | character(20) | no | Cross-Company Code |
| tcDivisionDescription | character(24) | no | |
| tlLinkedCrCyDaemonReqExists | logical | no | This 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 |
| tcCostCentreDescription | character(24) | no | |
| tlSkipCOAValForPeriodCosting | logical | no | |
| CustomShort0 | character(20) | no | Custom Short Field |
| CustomShort1 | character(20) | no | Custom Short Field |
| CustomShort2 | character(20) | no | Custom Short Field |
| CustomShort3 | character(20) | no | Custom Short Field |
| CustomShort4 | character(20) | no | Custom Short Field |
| CustomShort5 | character(20) | no | Custom Short Field |
| CustomShort6 | character(20) | no | Custom Short Field |
| CustomShort7 | character(20) | no | Custom Short Field |
| CustomShort8 | character(20) | no | Custom Short Field |
| CustomShort9 | character(20) | no | Custom Short Field |
| CustomCombo0 | character(20) | no | Custom Combo Field |
| CustomCombo1 | character(20) | no | Custom Combo Field |
| CustomCombo2 | character(20) | no | Custom Combo Field |
| CustomCombo3 | character(20) | no | Custom Combo Field |
| CustomCombo4 | character(20) | no | Custom Combo Field |
| CustomCombo5 | character(20) | no | Custom Combo Field |
| CustomCombo6 | character(20) | no | Custom Combo Field |
| CustomCombo7 | character(20) | no | Custom Combo Field |
| CustomCombo8 | character(20) | no | Custom Combo Field |
| CustomCombo9 | character(20) | no | Custom Combo Field |
| CustomLong0 | character(255) | no | Custom Long Field |
| CustomLong1 | character(255) | no | Custom Long Field |
| CustomNote | character(2000) | no | Custom Note Field |
| CustomDate0 | date | no | Custom Date Field |
| CustomDate1 | date | no | Custom Date Field |
| CustomDate2 | date | no | Custom Date Field |
| CustomDate3 | date | no | Custom Date Field |
| CustomDate4 | date | no | Custom Date Field |
| CustomInteger0 | integer | no | Custom Integer Field |
| CustomInteger1 | integer | no | Custom Integer Field |
| CustomInteger2 | integer | no | Custom Integer Field |
| CustomInteger3 | integer | no | Custom Integer Field |
| CustomInteger4 | integer | no | Custom Integer Field |
| CustomDecimal0 | decimal(4) | no | Custom Decimal Field |
| CustomDecimal1 | decimal(4) | no | Custom Decimal Field |
| CustomDecimal2 | decimal(4) | no | Custom Decimal Field |
| CustomDecimal3 | decimal(4) | no | Custom Decimal Field |
| CustomDecimal4 | decimal(4) | no | Custom Decimal Field |
| CustomShort10 | character(20) | no | Custom Short Field |
| CustomShort11 | character(20) | no | Custom Short Field |
| CustomShort12 | character(20) | no | Custom Short Field |
| CustomShort13 | character(20) | no | Custom Short Field |
| CustomShort14 | character(20) | no | Custom Short Field |
| CustomShort15 | character(20) | no | Custom Short Field |
| CustomShort16 | character(20) | no | Custom Short Field |
| CustomShort17 | character(20) | no | Custom Short Field |
| CustomShort18 | character(20) | no | Custom Short Field |
| CustomShort19 | character(20) | no | Custom Short Field |
| CustomCombo10 | character(20) | no | Custom Combo Field |
| CustomCombo11 | character(20) | no | Custom Combo Field |
| CustomCombo12 | character(20) | no | Custom Combo Field |
| CustomCombo13 | character(20) | no | Custom Combo Field |
| CustomCombo14 | character(20) | no | Custom Combo Field |
| CustomDecimal5 | decimal(4) | no | Custom Decimal Field |
| CustomDecimal6 | decimal(4) | no | Custom Decimal Field |
| CustomDecimal7 | decimal(4) | no | Custom Decimal Field |
| CustomDecimal8 | decimal(4) | no | Custom Decimal Field |
| CustomDecimal9 | decimal(4) | no | Custom Decimal Field |
| CustomDate5 | date | no | Custom Date Field |
| CustomDate6 | date | no | Custom Date Field |
| CustomDate7 | date | no | Custom Date Field |
| CustomDate8 | date | no | Custom Date Field |
| CustomDate9 | date | no | Custom Date Field |
| LastModifiedDate | date | no | Last Modified Date |
| LastModifiedTime | integer | no | Last Modified Time |
| LastModifiedUser | character(20) | no | Last Modified User |
| QADC01 | character(40) | no | unused QAD reserved field |
| QADC02 | character | no | unused QAD reserved field |
| QADT01 | date | no | unused QAD reserved field |
| QADD01 | decimal(10) | no | unused QAD reserved field |
| tc_Rowid | character | yes | primary index |
| tc_ParentRowid | character | yes | = tPosting.tc_Rowid |
| tc_Status | character | no | update status |
| field name | data type | mnd. | description |
|---|---|---|---|
| PostingSaf_ID | integer | yes | Record ID |
| PostingLine_ID | integer | yes | Link to PostingLine |
| Saf_ID | integer | yes | SAF Code |
| SafStructure_ID | integer | yes | Structure Code |
| Posting_ID | integer | no | Link to Posting |
| PostingSafParentType | character(20) | yes | Parent Type. Indicates the parent type of this SAF record. |
| value list: | {&POSTINGSAFPARENTTYPES} | ||
| PostingSafInputSequence | integer | yes | Sequence number of this SAF within all the SAF lines for the same posting line. |
| tcSafCode | character(20) | yes | The SAF Code used in this posting. Must be of concept "tcSafConceptCode". |
| tcSafConceptCode | character(20) | yes | The SAF concept of this posting, part of the SAF structure in "tcSafStructureCode". |
| tcSafStructureCode | character(20) | yes | The SAF structure. |
| CustomShort3 | character(20) | no | Custom Short Field |
| CustomShort4 | character(20) | no | Custom Short Field |
| CustomShort5 | character(20) | no | Custom Short Field |
| CustomShort6 | character(20) | no | Custom Short Field |
| CustomShort7 | character(20) | no | Custom Short Field |
| CustomShort8 | character(20) | no | Custom Short Field |
| CustomShort9 | character(20) | no | Custom Short Field |
| CustomCombo0 | character(20) | no | Custom Combo Field |
| CustomCombo1 | character(20) | no | Custom Combo Field |
| CustomCombo2 | character(20) | no | Custom Combo Field |
| CustomCombo3 | character(20) | no | Custom Combo Field |
| CustomCombo4 | character(20) | no | Custom Combo Field |
| CustomCombo5 | character(20) | no | Custom Combo Field |
| CustomCombo6 | character(20) | no | Custom Combo Field |
| CustomCombo7 | character(20) | no | Custom Combo Field |
| CustomCombo8 | character(20) | no | Custom Combo Field |
| CustomCombo9 | character(20) | no | Custom Combo Field |
| CustomLong0 | character(255) | no | Custom Long Field |
| CustomLong1 | character(255) | no | Custom Long Field |
| CustomNote | character(2000) | no | Custom Note Field |
| CustomDate0 | date | no | Custom Date Field |
| CustomDate1 | date | no | Custom Date Field |
| CustomDate2 | date | no | Custom Date Field |
| CustomDate3 | date | no | Custom Date Field |
| CustomDate4 | date | no | Custom Date Field |
| CustomInteger0 | integer | no | Custom Integer Field |
| CustomInteger1 | integer | no | Custom Integer Field |
| CustomInteger2 | integer | no | Custom Integer Field |
| CustomInteger3 | integer | no | Custom Integer Field |
| CustomInteger4 | integer | no | Custom Integer Field |
| CustomDecimal0 | decimal(4) | no | Custom Decimal Field |
| CustomDecimal1 | decimal(4) | no | Custom Decimal Field |
| CustomDecimal2 | decimal(4) | no | Custom Decimal Field |
| CustomDecimal3 | decimal(4) | no | Custom Decimal Field |
| CustomDecimal4 | decimal(4) | no | Custom Decimal Field |
| CustomShort0 | character(20) | no | Custom Short Field |
| CustomShort1 | character(20) | no | Custom Short Field |
| CustomShort2 | character(20) | no | Custom Short Field |
| LastModifiedDate | date | no | Last Modified Date |
| LastModifiedTime | integer | no | Last Modified Time |
| LastModifiedUser | character(20) | no | Last Modified User |
| QADC01 | character(40) | no | unused QAD reserved field |
| QADC02 | character | no | unused QAD reserved field |
| QADT01 | date | no | unused QAD reserved field |
| QADD01 | decimal(10) | no | unused QAD reserved field |
| tc_Rowid | character | yes | primary index |
| tc_ParentRowid | character | yes | = tPostingLine.tc_Rowid |
| tc_Status | character | no | update status |
| field name | data type | mnd. | description |
|---|---|---|---|
| PostingVat_ID | integer | yes | Record ID |
| Posting_ID | integer | no | Link to Posting |
| PostingLine_ID | integer | yes | Link to PostingLine |
| Vat_ID | integer | yes | Tax Code |
| VatRule_ID | integer | yes | Link to VatRule |
| VatPeriod_ID | integer | yes | Link to VatPeriod |
| PeriodMark_ID | integer | no | Link to PeriodMark |
| Currency_ID | integer | no | Currency Code |
| VatGroup_ID | integer | yes | Tax Group Code |
| PostingVatBaseDebitLC | decimal(4) | no | BC (Base/Local Currency) Base Debit amount. |
| PostingVatBaseDebitTC | decimal(4) | no | TC (Transaction Currency) Base Debit amount. |
| PostingVatBaseDebitCC | decimal(4) | no | SC (Statutory Currency) Base Debit amount. |
| PostingVatBaseCreditLC | decimal(4) | no | BC (Base/Local Currency) Base Credit amount. |
| PostingVatBaseCreditTC | decimal(4) | no | TC (Transaction Currency) Base Credit amount. |
| PostingVatBaseCreditCC | decimal(4) | no | SC (Statutory Currency) Base Credit amount. |
| PostingVatExchangeRate | decimal(10) | no | TC/BC Exchange Rate. |
| api annotation: | ? | ||
| PostingVatRateScale | decimal(10) | no | Scale Factor (TC/BC). |
| api annotation: | ? | ||
| PostingVatInOut | character(20) | no | In/Out? |
| api annotation: | Aivalable value for this field: "INPUT" represents purchases, "OUTPUT" represents sales. | ||
| value list: | {&VATINOUT-OUTPUTS} | ||
| PostingVatTaxPointDate | date | yes | The date when this posting is taken into account in the Tax sub-adminstration. |
| api annotation: | ? | ||
| PostingVatTaxTransType | character(2) | no | 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" | ||
| value list: | {&VATTAXTRANSACTIONTYPES} | ||
| PostingVatTransType | character(20) | no | 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". | ||
| value list: | {&VATTRANSACTIONTYPES} | ||
| PostingVatTaxDebitLC | decimal(4) | no | BC (Base Currency) Tax Debit amount. |
| api annotation: | ? | ||
| PostingVatTaxDebitCC | decimal(4) | no | SC (Statutory Currency) Tax Debit amount. |
| api annotation: | ? | ||
| PostingVatTaxDebitTC | decimal(4) | no | TC (Transaction Currency) Tax Debit amount. |
| api annotation: | ? | ||
| PostingVatTaxCreditLC | decimal(4) | no | BC (Base/Local) Tax Credit amount. |
| api annotation: | ? | ||
| PostingVatTaxCreditCC | decimal(4) | no | SC (Statutory Currency) Tax Credit amount. |
| api annotation: | ? | ||
| PostingVatTaxCreditTC | decimal(4) | no | TC (Transaction Currency) Tax Credit amount. |
| api annotation: | ? | ||
| PostingVatTaxIDFeder | character(40) | no | Federal Tax? |
| api annotation: | ? | ||
| PostingVatTaxIDState | character(40) | no | State Tax? |
| api annotation: | ? | ||
| PostingVatTaxIDMisc1 | character(40) | no | Miscellaneous Tax 1. For reference and documentation purposes, enter any other tax identification numbers that are useful. |
| api annotation: | ? | ||
| PostingVatTaxIDMisc2 | character(40) | no | Miscellaneous Tax 2 |
| PostingVatTaxIDMisc3 | character(40) | no | Miscellaneous Tax 3 |
| PostingVatOwnTaxIDFeder | character(40) | no | Own Federal Tax? |
| api annotation: | ? | ||
| PostingVatOwnTaxIDState | character(40) | no | Own State Tax? |
| api annotation: | ? | ||
| PostingVatOwnTaxIDMisc1 | character(40) | no | Own Miscellaneous Tax 1? For reference and documentation purposes, enter any other tax identification numbers that are useful. |
| api annotation: | ? | ||
| PostingVatOwnTaxIDMisc2 | character(40) | no | Own Miscellaneous Tax 2 |
| PostingVatOwnTaxIDMisc3 | character(40) | no | Own Miscellaneous Tax 3 |
| PostingVatOwnTaxDeclarat | integer | no | Own Declaration Tax |
| PostingVatIsReverseCharge | logical | yes | Reverse Charge |
| PostingVatIsAbsRet | logical | yes | Absorbed Retained |
| PostingVatIsSuspDel | logical | yes | Suspended/Delayed Tax |
| TxtyTaxType | character(16) | no | Tax Type |
| TxclTaxCls | character(3) | no | 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 | ||
| TxuTaxUsage | character(8) | no | 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. | ||
| TxenvTaxEnv | character(16) | no | 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: | ? | ||
| FromTxzTaxZone | character(16) | no | From Tax Zone. |
| api annotation: | ? | ||
| ToTxzTaxZone | character(16) | no | To Tax Zone |
| api annotation: | ? | ||
| tcCurrencyCode | character(3) | no | Currency Code |
| tdFullDebitTC | decimal(4) | no | Amount including VAT |
| tdFullCreditTC | decimal(4) | no | Amount including VAT |
| tdTotalVatDebitTC | decimal(4) | no | TC Total Debit |
| tdTotalVatCreditTC | decimal(4) | no | TC Total Credit |
| tcVatCode | character(20) | yes | The TaxCode for this posting. This code determines the registrations in the tax sub-ledger. |
| tcVatDescription | character(40) | yes | Description |
| tcDomainCode | character(8) | yes | Domain |
| tcVatInOut | character(20) | yes | Tax In/Out |
| tcVatGroupCode | character(20) | yes | Tax Group Code |
| CustomShort0 | character(20) | no | Custom Short Field |
| CustomShort1 | character(20) | no | Custom Short Field |
| CustomShort2 | character(20) | no | Custom Short Field |
| CustomShort3 | character(20) | no | Custom Short Field |
| CustomShort4 | character(20) | no | Custom Short Field |
| CustomShort5 | character(20) | no | Custom Short Field |
| CustomShort6 | character(20) | no | Custom Short Field |
| CustomShort7 | character(20) | no | Custom Short Field |
| CustomShort8 | character(20) | no | Custom Short Field |
| CustomShort9 | character(20) | no | Custom Short Field |
| CustomCombo0 | character(20) | no | Custom Combo Field |
| CustomCombo1 | character(20) | no | Custom Combo Field |
| CustomCombo2 | character(20) | no | Custom Combo Field |
| CustomCombo3 | character(20) | no | Custom Combo Field |
| CustomCombo4 | character(20) | no | Custom Combo Field |
| CustomCombo5 | character(20) | no | Custom Combo Field |
| CustomCombo6 | character(20) | no | Custom Combo Field |
| CustomCombo7 | character(20) | no | Custom Combo Field |
| CustomCombo8 | character(20) | no | Custom Combo Field |
| CustomCombo9 | character(20) | no | Custom Combo Field |
| CustomLong0 | character(255) | no | Custom Long Field |
| CustomLong1 | character(255) | no | Custom Long Field |
| CustomNote | character(2000) | no | Custom Note Field |
| CustomDate0 | date | no | Custom Date Field |
| CustomDate1 | date | no | Custom Date Field |
| CustomDate2 | date | no | Custom Date Field |
| CustomDate3 | date | no | Custom Date Field |
| CustomDate4 | date | no | Custom Date Field |
| CustomInteger0 | integer | no | Custom Integer Field |
| CustomInteger1 | integer | no | Custom Integer Field |
| CustomInteger2 | integer | no | Custom Integer Field |
| CustomInteger3 | integer | no | Custom Integer Field |
| CustomInteger4 | integer | no | Custom Integer Field |
| CustomDecimal0 | decimal(4) | no | Custom Decimal Field |
| CustomDecimal1 | decimal(4) | no | Custom Decimal Field |
| CustomDecimal2 | decimal(4) | no | Custom Decimal Field |
| CustomDecimal3 | decimal(4) | no | Custom Decimal Field |
| CustomDecimal4 | decimal(4) | no | Custom Decimal Field |
| LastModifiedDate | date | no | Last Modified Date |
| LastModifiedTime | integer | no | Last Modified Time |
| LastModifiedUser | character(20) | no | Last Modified User |
| QADC01 | character(40) | no | unused QAD reserved field |
| QADC02 | character | no | unused QAD reserved field |
| QADT01 | date | no | unused QAD reserved field |
| QADD01 | decimal(10) | no | unused QAD reserved field |
| tc_Rowid | character | yes | primary index |
| tc_ParentRowid | character | yes | = tPostingLine.tc_Rowid |
| tc_Status | character | no | update status |
| field name | data type | mnd. | description |
|---|---|---|---|
| Vat_ID | integer | no | Description |
| VatRule_ID | integer | no | Link to VatRule |
| PostingLine_ID | integer | yes | Link to PostingLine |
| VatPeriod_ID | integer | no | Link to VatPeriod |
| PeriodMark_ID | integer | no | Link to PeriodMark |
| PostingVatDelay_ID | integer | yes | Record ID |
| Currency_ID | integer | no | Currency Code |
| Posting_ID | integer | no | Link to Posting |
| PostingVatDelayBaseDebLC | decimal(4) | no | BC (Base/Local Currency) Base Debit amount. |
| api annotation: | ? | ||
| PostingVatDelayBaseCredLC | decimal(4) | no | BC (Base/Local Currency) Base Credit amount. |
| api annotation: | ? | ||
| PostingVatDelayBaseDebTC | decimal(4) | no | TC (Trasaction Currency) Base Debit amount. |
| api annotation: | ? | ||
| PostingVatDelayBaseCredTC | decimal(4) | no | TC (Transaction Currency) Base Credit amount. |
| api annotation: | ? | ||
| PostingVatDelayBaseDebCC | decimal(4) | no | SC (Statutory Currency) Base Debit amount. |
| api annotation: | ? | ||
| PostingVatDelayBaseCredCC | decimal(4) | no | SC (Statutory Currency) Base Credit amount. |
| PostingVatDelayTaxPntDate | date | no | Tax Point Date? |
| PostingVatDelayVATBalLC | decimal(4) | no | BC (Base/Local Currency) Tax Balance. |
| PostingVatDelayVATOrigLC | decimal(4) | no | BC (Base/Local Currency) Tax Original. |
| PostingVatDelayIsOpen | logical | yes | Open? |
| PostingVatDelayExchRate | decimal(10) | no | Exchange Rate? |
| PostingVatDelayRateScale | decimal(10) | no | Scale Factor? |
| PostingVatDelayTaxIDFeder | character(40) | no | Federal Tax ID? |
| PostingVatDelayTaxIDState | character(40) | no | State Tax ID? |
| PostingVatDelayTaxIDMisc1 | character(40) | no | Miscellaneous Tax 1. |
| PostingVatDelayTaxIDMisc2 | character(40) | no | Miscellaneous Tax 2. |
| PostingVatDelayTaxIDMisc3 | character(40) | no | Miscellaneous Tax 3. |
| PostingVatDelayOwnTaxIDFed | character(40) | no | Own Federal Tax ID? |
| PostingVatDelayOwnTaxIDSt | character(40) | no | Own State Tax ID? |
| PostingVatDelayOwnTaxIDM1 | character(40) | no | Own Miscellaneous Tax 1 ID. |
| PostingVatDelayOwnTaxIDM2 | character(40) | no | Own Miscellaneous Tax 2 ID. |
| PostingVatDelayOwnTaxIDM3 | character(40) | no | Own Miscellaneous Tax 3 ID. |
| PostingVatDelayOwnTaxDecl | integer | no | Own Tax Declaration. |
| tcVatCode | character(20) | no | Tax Code |
| tcVatDescription | character(40) | no | Description |
| tdFullDebitTC | decimal(4) | no | TC Debit |
| tdFullCreditTC | decimal(4) | no | TC Credit |
| tdTotalVatDebitTC | decimal(4) | no | TC Tax Debit |
| tdTotalVatCreditTC | decimal(4) | no | TC Tax Credit |
| tcCurrencyCode | character(3) | no | Currency Code |
| tcDomainCode | character(8) | no | Domain |
| tcVatInOut | character(20) | no | Tax In / Out |
| QADC01 | character(40) | no | unused QAD reserved field |
| QADC02 | character | no | unused QAD reserved field |
| QADT01 | date | no | unused QAD reserved field |
| QADD01 | decimal(10) | no | unused QAD reserved field |
| tc_Rowid | character | yes | primary index |
| tc_ParentRowid | character | yes | = tPostingLine.tc_Rowid |
| tc_Status | character | no | update status |
| field name | data type | mnd. | description |
|---|---|---|---|
| PostingWHT_ID | integer | yes | Record ID |
| Posting_ID | integer | no | Link to Posting |
| PostingLine_ID | integer | yes | Link to PostingLine |
| Vat_ID | integer | yes | Link to Tax Code |
| PeriodMark_ID | integer | no | Link to PeriodMark |
| Currency_ID | integer | no | Link to Currency Code |
| PostingWHTBaseDebitLC | decimal(4) | no | BC Base Debit |
| PostingWHTBaseDebitTC | decimal(4) | no | TC Base Debit |
| PostingWHTBaseDebitCC | decimal(4) | no | SC Base Debit |
| PostingWHTBaseCreditLC | decimal(4) | no | BC Base Credit |
| PostingWHTBaseCreditTC | decimal(4) | no | TC Base Credit |
| PostingWHTBaseCreditCC | decimal(4) | no | SC Base Credit |
| PostingWHTExchangeRate | decimal(10) | no | Exchange Rate |
| PostingWHTRateScale | decimal(10) | no | Scale Factor |
| PostingWHTInOut | character(20) | no | In/Out |
| value list: | {&VATINOUT-OUTPUTS} | ||
| PostingWHTTaxPointDate | date | yes | Tax Point Date |
| PostingWHTTaxTransType | character(2) | no | Tax Transaction Type |
| value list: | {&VATTAXTRANSACTIONTYPES} | ||
| PostingWHTTransType | character(20) | no | Transaction Type |
| value list: | {&VATTRANSACTIONTYPES} | ||
| PostingWHTTaxDebitLC | decimal(4) | no | BC Tax Debit |
| PostingWHTTaxDebitCC | decimal(4) | no | SC Tax Debit |
| PostingWHTTaxDebitTC | decimal(4) | no | TC Tax Debit |
| PostingWHTTaxCreditLC | decimal(4) | no | BC Tax Credit |
| PostingWHTTaxCreditCC | decimal(4) | no | SC Tax Credit |
| PostingWHTTaxCreditTC | decimal(4) | no | TC Tax Credit |
| PostingWHTTaxIDFeder | character(40) | no | Federal Tax |
| PostingWHTTaxIDState | character(40) | no | State Tax |
| PostingWHTTaxIDMisc1 | character(40) | no | Miscellaneous Tax 1 |
| PostingWHTTaxIDMisc2 | character(40) | no | Miscellaneous Tax 2 |
| PostingWHTTaxIDMisc3 | character(40) | no | Miscellaneous Tax 3 |
| PostingWHTOwnTaxIDFeder | character(40) | no | Own Federal Tax |
| PostingWHTOwnTaxIDState | character(40) | no | Own State Tax |
| PostingWHTOwnTaxIDMisc1 | character(40) | no | Own Miscellaneous Tax 1 |
| PostingWHTOwnTaxIDMisc2 | character(40) | no | Own Miscellaneous Tax 2 |
| PostingWHTOwnTaxIDMisc3 | character(40) | no | Own Miscellaneous Tax 3 |
| PostingWHTOwnTaxDeclarat | integer | no | Own Declaration Tax |
| PostingWHTTxtyTaxType | character(16) | no | Tax Type |
| PostingWHTTxclTaxCls | character(3) | no | Tax Class |
| PostingWHTTxuTaxUsage | character(8) | no | Tax Usage |
| PostingWHTTxenvTaxEnv | character(16) | no | Tax Environment |
| PostingWHTFromTxzTaxZone | character(16) | no | From Tax Zone |
| PostingWHTToTxzTaxZone | character(16) | no | To Tax Zone |
| tcCurrencyCode | character(3) | no | |
| tcVatCode | character(20) | yes | |
| tdFullDebitTC | decimal(4) | no | |
| tdFullCreditTC | decimal(4) | no | |
| tcDomainCode | character(8) | yes | |
| tcVatInOut | character(20) | yes | |
| CustomShort0 | character(20) | no | Custom Short Field |
| CustomShort1 | character(20) | no | Custom Short Field |
| CustomShort2 | character(20) | no | Custom Short Field |
| CustomShort3 | character(20) | no | Custom Short Field |
| CustomShort4 | character(20) | no | Custom Short Field |
| CustomShort5 | character(20) | no | Custom Short Field |
| CustomShort6 | character(20) | no | Custom Short Field |
| CustomShort7 | character(20) | no | Custom Short Field |
| CustomShort8 | character(20) | no | Custom Short Field |
| CustomShort9 | character(20) | no | Custom Short Field |
| CustomCombo0 | character(20) | no | Custom Combo Field |
| CustomCombo1 | character(20) | no | Custom Combo Field |
| CustomCombo2 | character(20) | no | Custom Combo Field |
| CustomCombo3 | character(20) | no | Custom Combo Field |
| CustomCombo4 | character(20) | no | Custom Combo Field |
| CustomCombo5 | character(20) | no | Custom Combo Field |
| CustomCombo6 | character(20) | no | Custom Combo Field |
| CustomCombo7 | character(20) | no | Custom Combo Field |
| CustomCombo8 | character(20) | no | Custom Combo Field |
| CustomCombo9 | character(20) | no | Custom Combo Field |
| CustomLong0 | character(255) | no | Custom Long Field |
| CustomLong1 | character(255) | no | Custom Long Field |
| CustomNote | character(2000) | no | Custom Note Field |
| CustomDate0 | date | no | Custom Date Field |
| CustomDate1 | date | no | Custom Date Field |
| CustomDate2 | date | no | Custom Date Field |
| CustomDate3 | date | no | Custom Date Field |
| CustomDate4 | date | no | Custom Date Field |
| CustomInteger0 | integer | no | Custom Integer Field |
| CustomInteger1 | integer | no | Custom Integer Field |
| CustomInteger2 | integer | no | Custom Integer Field |
| CustomInteger3 | integer | no | Custom Integer Field |
| CustomInteger4 | integer | no | Custom Integer Field |
| CustomDecimal0 | decimal(4) | no | Custom Decimal Field |
| CustomDecimal1 | decimal(4) | no | Custom Decimal Field |
| CustomDecimal2 | decimal(4) | no | Custom Decimal Field |
| CustomDecimal3 | decimal(4) | no | Custom Decimal Field |
| CustomDecimal4 | decimal(4) | no | Custom Decimal Field |
| LastModifiedDate | date | no | Last Modified Date |
| LastModifiedTime | integer | no | Last Modified Time |
| LastModifiedUser | character(20) | no | Last Modified User |
| QADC01 | character(40) | no | unused QAD reserved field |
| QADC02 | character | no | unused QAD reserved field |
| QADT01 | date | no | unused QAD reserved field |
| QADD01 | decimal(10) | no | unused QAD reserved field |
| tc_Rowid | character | yes | primary index |
| tc_ParentRowid | character | yes | = tPostingLine.tc_Rowid |
| tc_Status | character | no | update status |
| field name | data type | description |
|---|---|---|
| tcCustomShort0 | character | |
| tcCustomShort1 | character | |
| tcCustomShort2 | character | |
| tcCustomShort3 | character | |
| tcCustomShort4 | character | |
| tcCustomShort5 | character | |
| tcCustomShort6 | character | |
| tcCustomShort7 | character | |
| tcCustomShort8 | character | |
| tcCustomShort9 | character | |
| tcCustomCombo0 | character | |
| tcCustomCombo1 | character | |
| tcCustomCombo2 | character | |
| tcCustomCombo3 | character | |
| tcCustomCombo4 | character | |
| tcCustomCombo5 | character | |
| tcCustomCombo6 | character | |
| tcCustomCombo7 | character | |
| tcCustomCombo8 | character | |
| tcCustomCombo9 | character | |
| tcCustomLong0 | character | |
| tcCustomLong1 | character | |
| tcCustomNote | character | |
| ttCustomDate0 | date | |
| ttCustomDate1 | date | |
| ttCustomDate2 | date | |
| ttCustomDate3 | date | |
| ttCustomDate4 | date | |
| tiCustomInteger0 | integer | |
| tiCustomInteger1 | integer | |
| tiCustomInteger2 | integer | |
| tiCustomInteger3 | integer | |
| tiCustomInteger4 | integer | |
| tdCustomDecimal0 | decimal(4) | |
| tdCustomDecimal1 | decimal(4) | |
| tdCustomDecimal2 | decimal(4) | |
| tdCustomDecimal3 | decimal(4) | |
| tdCustomDecimal4 | decimal(4) | |
| tc_Rowid | character | Use this data item to add as a field in public temp-tables (with index). |
| tc_ParentRowid | character | |
| tc_Status | character |
| field name | data type | description |
|---|---|---|
| tcCustomShort0 | character | |
| tcCustomShort1 | character | |
| tcCustomShort2 | character | |
| tcCustomShort3 | character | |
| tcCustomShort4 | character | |
| tcCustomShort5 | character | |
| tcCustomShort6 | character | |
| tcCustomShort7 | character | |
| tcCustomShort8 | character | |
| tcCustomShort9 | character | |
| tcCustomCombo0 | character | |
| tcCustomCombo1 | character | |
| tcCustomCombo2 | character | |
| tcCustomCombo3 | character | |
| tcCustomCombo4 | character | |
| tcCustomCombo5 | character | |
| tcCustomCombo6 | character | |
| tcCustomCombo7 | character | |
| tcCustomCombo8 | character | |
| tcCustomCombo9 | character | |
| tcCustomLong0 | character | |
| tcCustomLong1 | character | |
| tcCustomNote | character | |
| ttCustomDate0 | date | |
| ttCustomDate1 | date | |
| ttCustomDate2 | date | |
| ttCustomDate3 | date | |
| ttCustomDate4 | date | |
| tiCustomInteger0 | integer | |
| tiCustomInteger1 | integer | |
| tiCustomInteger2 | integer | |
| tiCustomInteger3 | integer | |
| tiCustomInteger4 | integer | |
| tdCustomDecimal0 | decimal(4) | |
| tdCustomDecimal1 | decimal(4) | |
| tdCustomDecimal2 | decimal(4) | |
| tdCustomDecimal3 | decimal(4) | |
| tdCustomDecimal4 | decimal(4) | |
| tc_Rowid | character | Use this data item to add as a field in public temp-tables (with index). |
| tc_ParentRowid | character | |
| tc_Status | character |
| field name | data type | description |
|---|---|---|
| tcCustomShort0 | character | |
| tcCustomShort1 | character | |
| tcCustomShort2 | character | |
| tcCustomShort3 | character | |
| tcCustomShort4 | character | |
| tcCustomShort5 | character | |
| tcCustomShort6 | character | |
| tcCustomShort7 | character | |
| tcCustomShort8 | character | |
| tcCustomShort9 | character | |
| tcCustomCombo0 | character | |
| tcCustomCombo1 | character | |
| tcCustomCombo2 | character | |
| tcCustomCombo3 | character | |
| tcCustomCombo4 | character | |
| tcCustomCombo5 | character | |
| tcCustomCombo6 | character | |
| tcCustomCombo7 | character | |
| tcCustomCombo8 | character | |
| tcCustomCombo9 | character | |
| tcCustomLong0 | character | |
| tcCustomLong1 | character | |
| tcCustomNote | character | |
| ttCustomDate0 | date | |
| ttCustomDate1 | date | |
| ttCustomDate2 | date | |
| ttCustomDate3 | date | |
| ttCustomDate4 | date | |
| tiCustomInteger0 | integer | |
| tiCustomInteger1 | integer | |
| tiCustomInteger2 | integer | |
| tiCustomInteger3 | integer | |
| tiCustomInteger4 | integer | |
| tdCustomDecimal0 | decimal(4) | |
| tdCustomDecimal1 | decimal(4) | |
| tdCustomDecimal2 | decimal(4) | |
| tdCustomDecimal3 | decimal(4) | |
| tdCustomDecimal4 | decimal(4) | |
| tc_Rowid | character | Use this data item to add as a field in public temp-tables (with index). |
| tc_ParentRowid | character | |
| tc_Status | character |