MGCLatticePaymentRequestEntity
The MGCLatticePaymentRequestEntity exposes cash flow management payment request headers (CFMPaymentRequestTable): request identification, due and payment dates, status, account type/number, and currencies.
- Public collection name:
LatticePaymentRequests
- Primary key:
PaymentRequestId
Fields
| Name | Type | Mandatory | Description |
|---|
PaymentRequestId | CFMPaymentRequestId | No | |
DueDate | DueDate | No | |
PaymentDate | TransDate | No | |
Status | CFMPaymentRequestStatus | No | |
WorkflowStatus | CFMPaymentRequestWorkflowStatus | No | |
AccountType | CFMAccountType | No | |
AccountNumber | CFMAccountNum | No | |
CurrencyCode | CurrencyCode | No | |
PaymentCurrency | CurrencyCode | No | |
SourceDataAreaId | SelectableDataArea | No | |
PaymentDataAreaId | SelectableDataArea | No | |
ExternalSystem | MGCLatticeExternalSystemId | No | The external system, such as a CRM, a marketplace or a legacy ERP, whose key this is. |
AccountNumberExternalKey | MGCLatticeExternalKey | No | The external system's key for the customer or vendor, as set by the account type. Send it instead of the account number. |
Mappings
| Entity field | Data source | Field |
|---|
PaymentRequestId | CFMPaymentRequestTable | PaymentRequestId |
DueDate | CFMPaymentRequestTable | DueDate |
PaymentDate | CFMPaymentRequestTable | PaymentDate |
Status | CFMPaymentRequestTable | Status |
WorkflowStatus | CFMPaymentRequestTable | WorkflowStatus |
AccountType | CFMPaymentRequestTable | AccountType |
AccountNumber | CFMPaymentRequestTable | AccountNum |
CurrencyCode | CFMPaymentRequestTable | CurrencyCode |
PaymentCurrency | CFMPaymentRequestTable | PaymentCurrency |
SourceDataAreaId | CFMPaymentRequestTable | SourceDataAreaId |
PaymentDataAreaId | CFMPaymentRequestTable | PaymentDataAreaId |