MGCLatticeFreeTextInvoiceTemplateLineEntity
The MGCLatticeFreeTextInvoiceTemplateLineEntity exposes free text invoice template standard lines (CustInvoiceStandardLineTemplate) including line description, invoice text, amount, quantity, unit price, sales tax groups, project defaults, and the main account / ledger dimension display value. The owning template is identified by TemplateName, surfaced through a read-only join to the CustInvoiceTemplate header: a line is written to an existing template, which the entity never creates or changes.
- Public collection name:
LatticeFreeTextInvoiceTemplateLines
- Primary key:
TemplateName, LineNumber
Fields
| Name | Type | Mandatory | Description |
|---|
TemplateName | CustInvoiceTemplateName | No | |
LineNumber | LineNum | No | |
Description | Description | No | |
InvoiceText | Notes | No | |
LineAmount | AmountCur | No | |
Quantity | InvoiceQuantity | No | |
UnitPrice | InvoiceUnitPrice | No | |
SalesTaxGroup | TaxGroup | No | |
ItemSalesTaxGroup | TaxItemGroup | No | |
OverrideSalesTax | TaxIntegrationOverrideSalesTax | No | |
ProjectId | ProjId | No | |
ProjectCategoryId | ProjCategoryId | No | |
LedgerAccountDisplayValue | DimensionDisplayValue | No | |
DefaultDimensionDisplayValue | DimensionDisplayValue | No | |
ExternalSystem | MGCLatticeExternalSystemId | No | The external system, such as a CRM, a marketplace or a legacy ERP, whose key this is. |
ProjectIdExternalKey | MGCLatticeExternalKey | No | The external system's key for the project. Send it instead of the project ID. |
Mappings
| Entity field | Data source | Field |
|---|
TemplateName | CustInvoiceTemplate | TemplateName |
LineNumber | CustInvoiceStandardLineTemplate | LineNum |
Description | CustInvoiceStandardLineTemplate | Description |
InvoiceText | CustInvoiceStandardLineTemplate | LineTxt |
LineAmount | CustInvoiceStandardLineTemplate | AmountCur |
Quantity | CustInvoiceStandardLineTemplate | Quantity |
UnitPrice | CustInvoiceStandardLineTemplate | UnitPrice |
SalesTaxGroup | CustInvoiceStandardLineTemplate | TaxGroup |
ItemSalesTaxGroup | CustInvoiceStandardLineTemplate | TaxItemGroup |
OverrideSalesTax | CustInvoiceStandardLineTemplate | OverrideSalesTax |
ProjectId | CustInvoiceStandardLineTemplate | ProjId |
ProjectCategoryId | CustInvoiceStandardLineTemplate | ProjCategoryId |
LedgerAccountDisplayValue | LedgerDimensionDAVC | DisplayValue |
DefaultDimensionDisplayValue | DefaultDimensionDAVS | DisplayValue |