iiCompanyId | integer | Company id |
iiPostingLineID | integer | PostingLineId |
iiSharedSetId | integer |
field name | data type | db field | description |
---|---|---|---|
tcBusinessRelationCode | character | BusinessRelation.BusinessRelationCode | Business Relation. A code to identify the business relation. If this field does not have a input from the user, the system automatically generates a number for the record based on the sequence defined in Business Relation Autonumber Create. |
tcBusinessRelationICCode | character | BusinessRelation.BusinessRelationICCode | Intercompany Code. When Intercompany is true, this field is mandatory. The code entered here must match the intercompany code entered for GL accounts in order to generate intercompany reports. The intercompany code must be unique for this business relation. |
tlBusinessRelationIsActive | logical | BusinessRelation.BusinessRelationIsActive | Active: This field indicates if this is an active record. |
api annotation: | PartialUpdate = yes - defaults to true. | ||
tiCompany_ID | integer | Posting.Company_ID | Link to Company |
tcCompanyCode | character | Company.CompanyCode | Entity Code |
tlCurrencyIsActive | logical | Currency.CurrencyIsActive | Active |
tiGLSharedSet_ID | integer | GL.SharedSet_ID | Link to SharedSet |
tiCurrency_ID | integer | PostingLine.Currency_ID | Currency Code |
tiGL_ID | integer | PostingLine.GL_ID | GL Description |
tiIntercoBusinessRelation_ID | integer | PostingLine.IntercoBusinessRelation_ID | Intercompany Code |
tiPostingLine_ID | integer | PostingLine.PostingLine_ID | Record ID |
tiPosting_ID | integer | PostingLine.Posting_ID | Link to Posting |
tiBusinessRelation_ID | integer | GL.BusinessRelation_ID | Link to BusinessRelation |
tcGLCode | character | GL.GLCode | A code identifying the GL account. |
tlGLIsActive | logical | GL.GLIsActive | Active: Indicate if this is an active account. |
tcCurrencyCode | character | Currency.CurrencyCode | Currency Code |
ti_sequence | integer | calculated | primary index |
tc_rowid | character | calculated | = rowid(PostingLine),rowid(Currency),rowid(GL),rowid(Posting),rowid(Company),rowid(CompanyProperty),rowid(BusinessRelation) |