--- schema_version: "1" id: 030dcd1a6c3be5b774d74800bb2fa56bac20c2a1dbf1c8d3847dc7ff279cc674 title: Invoice DMO collection: developer version: current locale: en-us portal_url: https://docs.salesforce.com/developer/current/en-us/data-cloud/data-cloud-dmo-mapping/guides/std_dmos/c360dm-si-invoicedmo-dmo.md canonical_url: https://developer.salesforce.com/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-invoicedmo-dmo.html source_site: developer.salesforce.com content_type: documentation content_hash: 1c67bd2fe20e90f41af92eb638f76707e2a43c6c09c28f6afdc55fa4263f31e9 products: - Data 360 DMO and Mapping Guide - Data 360 Developer Documentation --- # Invoice DMO ## Object Properties **Object API Name:** `ssot__Invoice__dlm` **Category:** Unassigned **Availability:** Available in 254 and later versions **Primary Key Field:** Id ## Fields - [BalanceAmount](#balanceamount) - [BillingAccountId](#billingaccountid) - [BillToContactId](#billtocontactid) - [cdp_sys_record_currency](#cdp_sys_record_currency) - [CollectionStatus](#collectionstatus) - [CollectionUserId](#collectionuserid) - [CorpCrcyCnvTotWithTaxAmount](#corpcrcycnvtotwithtaxamount) - [CorporateCurrency](#corporatecurrency) - [CorporateCurrencyCvsnDate](#corporatecurrencycvsndate) - [CorporateCurrencyCvsnRate](#corporatecurrencycvsnrate) - [CreatedById](#createdbyid) - [CreatedDate](#createddate) - [CreationMode](#creationmode) - [Currency](#currency) - [DataSourceId](#datasourceid) - [DataSourceObjectId](#datasourceobjectid) - [DaysInvoiceOpenNumber](#daysinvoiceopennumber) - [DaysInvoiceOverdueNumber](#daysinvoiceoverduenumber) - [Description](#description) - [DueDate](#duedate) - [FullSettlementDate](#fullsettlementdate) - [GroupingKeyText](#groupingkeytext) - [Id](#id) - [InternalOrganizationId](#internalorganizationid) - [InvoiceAppType](#invoiceapptype) - [InvoiceBatchRunId](#invoicebatchrunid) - [InvoiceDate](#invoicedate) - [InvoiceNumber](#invoicenumber) - [InvoiceReferenceText](#invoicereferencetext) - [InvoiceSettlementLevel](#invoicesettlementlevel) - [InvoiceStatus](#invoicestatus) - [IsBillingScheduleGroupSkipped](#isbillingschedulegroupskipped) - [KQ_Id](#kq_id) - [LastModifiedById](#lastmodifiedbyid) - [LastModifiedDate](#lastmodifieddate) - [Name](#name) - [NetCreditsAppliedAmount](#netcreditsappliedamount) - [NetPaymentsAppliedAmount](#netpaymentsappliedamount) - [PaymentExclusionReasonText](#paymentexclusionreasontext) - [PaymentTermId](#paymenttermid) - [PostedDate](#posteddate) - [ReferenceEntity](#referenceentity) - [ReferenceEntityId](#referenceentityid) - [SettlementStatus](#settlementstatus) - [ShouldExcludePaymentText](#shouldexcludepaymenttext) - [TaxLocaleType](#taxlocaletype) - [TotalAdjustmentAmount](#totaladjustmentamount) - [TotalAdjustmentTaxAmount](#totaladjustmenttaxamount) - [TotalAdjustmentWithTaxAmount](#totaladjustmentwithtaxamount) - [TotalAmount](#totalamount) - [TotalChargeAmount](#totalchargeamount) - [TotalChargeTaxAmount](#totalchargetaxamount) - [TotalChargeWithTaxAmount](#totalchargewithtaxamount) - [TotalConvertedNegAmount](#totalconvertednegamount) - [TotalCreditMemoInvAppliedAmount](#totalcreditmemoinvappliedamount) - [TotalCreditMemoInvUnappliedAmount](#totalcreditmemoinvunappliedamount) - [TotalPaymentLineInvAppliedAmount](#totalpaymentlineinvappliedamount) - [TotalPaymentLineInvUnappliedAmount](#totalpaymentlineinvunappliedamount) - [TotalTaxAmount](#totaltaxamount) - [TotalWithTaxAmount](#totalwithtaxamount) - [TotAppliedCrMemoLineAmount](#totappliedcrmemolineamount) - [TotPymtLineInvLineAppliedAmount](#totpymtlineinvlineappliedamount) - [TotPymtLineInvLineUnappAmount](#totpymtlineinvlineunappamount) - [TotUnappliedCrMemoLineAmount](#totunappliedcrmemolineamount) ### BalanceAmount - **Field API Name:** `ssot__BalanceAmount__c` - **Data Type:** DOUBLE - **Description:** Monetary balance amount associated with the record. ### BillingAccountId - **Field API Name:** `ssot__BillingAccountId__c` - **Data Type:** TEXT - **Description:** A unique, system-generated identifier for this record. ### BillToContactId - **Field API Name:** `ssot__BillToContactId__c` - **Data Type:** TEXT - **Description:** A unique, system-generated identifier for this record. ### cdp_sys_record_currency - **Field API Name:** `ssot__cdp_sys_record_currency__c` - **Data Type:** TEXT - **Description:** System-generated metadata field that stores a 3-letter ISO currency code. ### CollectionStatus - **Field API Name:** `ssot__CollectionStatus__c` - **Data Type:** TEXT - **Description:** Alphanumeric string representing the collection status. ### CollectionUserId - **Field API Name:** `ssot__CollectionUserId__c` - **Data Type:** TEXT - **Description:** A unique, system-generated identifier for this record. ### CorpCrcyCnvTotWithTaxAmount - **Field API Name:** `ssot__CorpCrcyCnvTotWithTaxAmount__c` - **Data Type:** DOUBLE - **Description:** Numeric value representing the corp crcy cnv tot with tax amount. Do not include currency symbols or commas. ### CorporateCurrency - **Field API Name:** `ssot__CorporateCurrency__c` - **Data Type:** TEXT - **Description:** Corporate currency used for standardized financial reporting. ### CorporateCurrencyCvsnDate - **Field API Name:** `ssot__CorporateCurrencyCvsnDate__c` - **Data Type:** DATEONLY - **Description:** Date on which the corporate currency conversion rate was applied. ### CorporateCurrencyCvsnRate - **Field API Name:** `ssot__CorporateCurrencyCvsnRate__c` - **Data Type:** DOUBLE - **Description:** Conversion rate used to convert the record's currency to the corporate currency. ### CreatedById - **Field API Name:** `ssot__CreatedById__c` - **Data Type:** TEXT - **Description:** The user who created the record. ### CreatedDate - **Field API Name:** `ssot__CreatedDate__c` - **Data Type:** DATETIME - **Description:** The date and time the record was originally created. ### CreationMode - **Field API Name:** `ssot__CreationMode__c` - **Data Type:** TEXT - **Description:** Alphanumeric string representing the creation mode. ### Currency - **Field API Name:** `ssot__Currency__c` - **Data Type:** TEXT - **Description:** ISO 4217 currency code associated with the record. ### DataSourceId - **Field API Name:** `ssot__DataSourceId__c` - **Data Type:** TEXT - **Description:** A unique, system-generated identifier for this record. ### DataSourceObjectId - **Field API Name:** `ssot__DataSourceObjectId__c` - **Data Type:** TEXT - **Description:** A unique, system-generated identifier for this record. ### DaysInvoiceOpenNumber - **Field API Name:** `ssot__DaysInvoiceOpenNumber__c` - **Data Type:** DOUBLE - **Description:** Numeric value representing the days invoice open number. Do not include currency symbols or commas. ### DaysInvoiceOverdueNumber - **Field API Name:** `ssot__DaysInvoiceOverdueNumber__c` - **Data Type:** DOUBLE - **Description:** Numeric value representing the days invoice overdue number. Do not include currency symbols or commas. ### Description - **Field API Name:** `ssot__Description__c` - **Data Type:** TEXT - **Description:** Description of this record. ### DueDate - **Field API Name:** `ssot__DueDate__c` - **Data Type:** DATEONLY - **Description:** Calendar date representing the due date in the YYYY-MM-DD format. ### FullSettlementDate - **Field API Name:** `ssot__FullSettlementDate__c` - **Data Type:** DATEONLY - **Description:** Calendar date representing the full settlement date in the YYYY-MM-DD format. ### GroupingKeyText - **Field API Name:** `ssot__GroupingKeyText__c` - **Data Type:** TEXT - **Description:** Alphanumeric string representing the grouping key text. ### Id - **Field API Name:** `ssot__Id__c` - **Data Type:** TEXT - **Description:** A unique, system-generated identifier for this record. ### InternalOrganizationId - **Field API Name:** `ssot__InternalOrganizationId__c` - **Data Type:** TEXT - **Description:** A unique, system-generated identifier for this record. ### InvoiceAppType - **Field API Name:** `ssot__InvoiceAppType__c` - **Data Type:** TEXT - **Description:** Alphanumeric string representing the invoice app type. ### InvoiceBatchRunId - **Field API Name:** `ssot__InvoiceBatchRunId__c` - **Data Type:** TEXT - **Description:** A unique, system-generated identifier for this record. ### InvoiceDate - **Field API Name:** `ssot__InvoiceDate__c` - **Data Type:** DATEONLY - **Description:** Calendar date representing the invoice date in the YYYY-MM-DD format. ### InvoiceNumber - **Field API Name:** `ssot__InvoiceNumber__c` - **Data Type:** TEXT - **Description:** Alphanumeric string representing the invoice number. ### InvoiceReferenceText - **Field API Name:** `ssot__InvoiceReferenceText__c` - **Data Type:** TEXT - **Description:** Alphanumeric string representing the invoice reference text. ### InvoiceSettlementLevel - **Field API Name:** `ssot__InvoiceSettlementLevel__c` - **Data Type:** TEXT - **Description:** Alphanumeric string representing the invoice settlement level. ### InvoiceStatus - **Field API Name:** `ssot__InvoiceStatus__c` - **Data Type:** TEXT - **Description:** Alphanumeric string representing the invoice status. ### IsBillingScheduleGroupSkipped - **Field API Name:** `ssot__IsBillingScheduleGroupSkipped__c` - **Data Type:** TEXT - **Description:** Alphanumeric string representing the is billing schedule group skipped. ### KQ_Id - **Field API Name:** `KQ_Id__c` - **Data Type:** TEXT - **Description:** Key Qualifier system field for Id ### LastModifiedById - **Field API Name:** `ssot__LastModifiedById__c` - **Data Type:** TEXT - **Description:** The user who most recently changed the record. ### LastModifiedDate - **Field API Name:** `ssot__LastModifiedDate__c` - **Data Type:** DATETIME - **Description:** The date and time of the last modification to this record. ### Name - **Field API Name:** `ssot__Name__c` - **Data Type:** TEXT - **Description:** The primary name or label for this record. ### NetCreditsAppliedAmount - **Field API Name:** `ssot__NetCreditsAppliedAmount__c` - **Data Type:** DOUBLE - **Description:** Net monetary amount of credits applied to the record. ### NetPaymentsAppliedAmount - **Field API Name:** `ssot__NetPaymentsAppliedAmount__c` - **Data Type:** DOUBLE - **Description:** Numeric value representing the net payments applied amount. Do not include currency symbols or commas. ### PaymentExclusionReasonText - **Field API Name:** `ssot__PaymentExclusionReasonText__c` - **Data Type:** TEXT - **Description:** Alphanumeric string representing the payment exclusion reason text. ### PaymentTermId - **Field API Name:** `ssot__PaymentTermId__c` - **Data Type:** TEXT - **Description:** A unique, system-generated identifier for this record. ### PostedDate - **Field API Name:** `ssot__PostedDate__c` - **Data Type:** DATEONLY - **Description:** Calendar date representing the posted date in the YYYY-MM-DD format. ### ReferenceEntity - **Field API Name:** `ssot__ReferenceEntity__c` - **Data Type:** TEXT - **Description:** Alphanumeric string representing the reference entity. ### ReferenceEntityId - **Field API Name:** `ssot__ReferenceEntityId__c` - **Data Type:** TEXT - **Description:** A unique, system-generated identifier for this record. ### SettlementStatus - **Field API Name:** `ssot__SettlementStatus__c` - **Data Type:** TEXT - **Description:** Alphanumeric string representing the settlement status. ### ShouldExcludePaymentText - **Field API Name:** `ssot__ShouldExcludePaymentText__c` - **Data Type:** TEXT - **Description:** Alphanumeric string representing the should exclude payment text. ### TaxLocaleType - **Field API Name:** `ssot__TaxLocaleType__c` - **Data Type:** TEXT - **Description:** Alphanumeric string representing the tax locale type. ### TotalAdjustmentAmount - **Field API Name:** `ssot__TotalAdjustmentAmount__c` - **Data Type:** DOUBLE - **Description:** Numeric value representing the total adjustment amount. Do not include currency symbols or commas. ### TotalAdjustmentTaxAmount - **Field API Name:** `ssot__TotalAdjustmentTaxAmount__c` - **Data Type:** DOUBLE - **Description:** Numeric value representing the total adjustment tax amount. Do not include currency symbols or commas. ### TotalAdjustmentWithTaxAmount - **Field API Name:** `ssot__TotalAdjustmentWithTaxAmount__c` - **Data Type:** DOUBLE - **Description:** Numeric value representing the total adjustment with tax amount. Do not include currency symbols or commas. ### TotalAmount - **Field API Name:** `ssot__TotalAmount__c` - **Data Type:** DOUBLE - **Description:** Total monetary amount associated with the record. ### TotalChargeAmount - **Field API Name:** `ssot__TotalChargeAmount__c` - **Data Type:** DOUBLE - **Description:** Numeric value representing the total charge amount. Do not include currency symbols or commas. ### TotalChargeTaxAmount - **Field API Name:** `ssot__TotalChargeTaxAmount__c` - **Data Type:** DOUBLE - **Description:** Numeric value representing the total charge tax amount. Do not include currency symbols or commas. ### TotalChargeWithTaxAmount - **Field API Name:** `ssot__TotalChargeWithTaxAmount__c` - **Data Type:** DOUBLE - **Description:** Numeric value representing the total charge with tax amount. Do not include currency symbols or commas. ### TotalConvertedNegAmount - **Field API Name:** `ssot__TotalConvertedNegAmount__c` - **Data Type:** DOUBLE - **Description:** Numeric value representing the total converted neg amount. Do not include currency symbols or commas. ### TotalCreditMemoInvAppliedAmount - **Field API Name:** `ssot__TotalCreditMemoInvAppliedAmount__c` - **Data Type:** DOUBLE - **Description:** Numeric value representing the total credit memo inv applied amount. Do not include currency symbols or commas. ### TotalCreditMemoInvUnappliedAmount - **Field API Name:** `ssot__TotalCreditMemoInvUnappliedAmount__c` - **Data Type:** DOUBLE - **Description:** Numeric value representing the total credit memo inv unapplied amount. Do not include currency symbols or commas. ### TotalPaymentLineInvAppliedAmount - **Field API Name:** `ssot__TotalPaymentLineInvAppliedAmount__c` - **Data Type:** DOUBLE - **Description:** Numeric value representing the total payment line inv applied amount. Do not include currency symbols or commas. ### TotalPaymentLineInvUnappliedAmount - **Field API Name:** `ssot__TotalPaymentLineInvUnappliedAmount__c` - **Data Type:** DOUBLE - **Description:** Numeric value representing the total payment line inv unapplied amount. Do not include currency symbols or commas. ### TotalTaxAmount - **Field API Name:** `ssot__TotalTaxAmount__c` - **Data Type:** DOUBLE - **Description:** Numeric value representing the total tax amount. Do not include currency symbols or commas. ### TotalWithTaxAmount - **Field API Name:** `ssot__TotalWithTaxAmount__c` - **Data Type:** DOUBLE - **Description:** Numeric value representing the total with tax amount. Do not include currency symbols or commas. ### TotAppliedCrMemoLineAmount - **Field API Name:** `ssot__TotAppliedCrMemoLineAmount__c` - **Data Type:** DOUBLE - **Description:** Numeric value representing the tot applied cr memo line amount. Do not include currency symbols or commas. ### TotPymtLineInvLineAppliedAmount - **Field API Name:** `ssot__TotPymtLineInvLineAppliedAmount__c` - **Data Type:** DOUBLE - **Description:** Numeric value representing the tot pymt line inv line applied amount. Do not include currency symbols or commas. ### TotPymtLineInvLineUnappAmount - **Field API Name:** `ssot__TotPymtLineInvLineUnappAmount__c` - **Data Type:** DOUBLE - **Description:** Numeric value representing the tot pymt line inv line unapp amount. Do not include currency symbols or commas. ### TotUnappliedCrMemoLineAmount - **Field API Name:** `ssot__TotUnappliedCrMemoLineAmount__c` - **Data Type:** DOUBLE - **Description:** Numeric value representing the tot unapplied cr memo line amount. Do not include currency symbols or commas.