Payment Advice Line Invoice DMO

Represents an individual line item within a payment advice, capturing the applied amount, deductions, and invoice reference for each payment allocation.

Object Properties

Object API Name: PaymentAdviceLineInvoice_std__dlm
Category: Unassigned
Availability: Available in 264 and later versions
Primary Key Field: Id

Relationships

• PaymentAdviceId has a FOREIGNKEY relationship with the Payment Advice DMO Id field.
• InvoiceId has a FOREIGNKEY relationship with the Invoice DMO Id field.

Fields

• AppliedAmount
• cdp_sys_record_currency
• CreatedDateTime
• CurrencyCode
• DataSourceId
• DataSourceObjectId
• DeductionAmount
• DeductionCode
• GrossAmount
• Id
• InternalOrganizationId
• InvoiceId
• InvoiceNumber
• KQ_Id
• KQ_InvoiceId
• KQ_PaymentAdviceId
• LastModifiedDateTime
• PaymentAdviceId

AppliedAmount

• Field API Name: AppliedAmount__c
• Data Type: CURRENCY
• Description: The net amount applied to the invoice after deductions.

cdp_sys_record_currency

• Field API Name: cdp_sys_record_currency__c
• Data Type: TEXT
• Description: System-generated metadata field that stores a 3-letter ISO currency code.

CreatedDateTime

• Field API Name: CreatedDateTime__c
• Data Type: DATETIME
• Description: The timestamp when the record was created.

CurrencyCode

• Field API Name: CurrencyCode__c
• Data Type: TEXT
• Description: The currency code for this record.

DataSourceId

• Field API Name: DataSourceId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

DataSourceObjectId

• Field API Name: DataSourceObjectId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

DeductionAmount

• Field API Name: DeductionAmount__c
• Data Type: CURRENCY
• Description: The amount the payer is withholding or short-paying on this invoice line. For example, an early payment discount, a pricing dispute deduction, or a return credit.

DeductionCode

• Field API Name: DeductionCode__c
• Data Type: TEXT
• Description: The reason code that indicates the type of deduction, such as EARLY_PAY_DISCOUNT, SHORT_PAY, DAMAGED_GOODS, PRICING_DISPUTE, RETURNS.

GrossAmount

• Field API Name: GrossAmount__c
• Data Type: CURRENCY
• Description: The original amount on the remittance advice line record before any deductions or discounts are applied.

Id

• Field API Name: Id__c
• Data Type: TEXT
• Description: Unique identifier of this record.

InternalOrganizationId

• Field API Name: InternalOrganizationId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

InvoiceId

• Field API Name: InvoiceId__c
• Data Type: TEXT
• Description: Resolved InvoiceId if the invoice is already resolved.

InvoiceNumber

• Field API Name: InvoiceNumber__c
• Data Type: TEXT
• Description: The invoice number associated with the remittance advice line record against which payment was remitted.

KQ_Id

• Field API Name: KQ_Id__c
• Data Type: TEXT
• Description: Key Qualifier system field for Id

KQ_InvoiceId

• Field API Name: KQ_InvoiceId__c
• Data Type: TEXT
• Description: Key Qualifier system field for InvoiceId

KQ_PaymentAdviceId

• Field API Name: KQ_PaymentAdviceId__c
• Data Type: TEXT
• Description: Key Qualifier system field for PaymentAdviceId

LastModifiedDateTime

• Field API Name: LastModifiedDateTime__c
• Data Type: DATETIME
• Description: The timestamp when the record was last updated.

PaymentAdviceId

• Field API Name: PaymentAdviceId__c
• Data Type: TEXT
• Description: The ID of the parent remittance advice record related to the remittance advice line record.