MGCLatticeIntercompanyOrderEntity
The MGCLatticeIntercompanyOrderEntity exposes intercompany sales order records from SalesTable, filtered to intercompany orders only, with linkage metadata to the corresponding purchase order in the other legal entity.
- Public collection name:
LatticeIntercompanyOrders
- Primary key:
SalesOrderNumber
Fields
| Name | Type | Mandatory | Description |
|---|
SalesOrderNumber | SalesIdBase | No | |
CustomerAccount | CustAccount | No | |
InvoiceAccount | CustInvoiceAccount | No | |
SalesOrderStatus | SalesStatus | No | |
CurrencyCode | CustCurrencyCode | No | |
IntercompanyOrder | InterCompanyCustomer | No | |
IntercompanyLegalEntityId | InterCompanyCompanyId | No | |
IntercompanyPurchaseOrderNumber | InterCompanyPurchId | No | |
IntercompanyOriginalSalesOrderNumber | InterCompanyOriginalSalesId | No | |
IntercompanyDirectDelivery | InterCompanyDirectDelivery | No | |
CreatedDate | CreatedDateTime | No | |
DeliveryMode | CustDlvModeId | No | |
Mappings
| Entity field | Data source | Field |
|---|
SalesOrderNumber | SalesTable | SalesId |
CustomerAccount | SalesTable | CustAccount |
InvoiceAccount | SalesTable | InvoiceAccount |
SalesOrderStatus | SalesTable | SalesStatus |
CurrencyCode | SalesTable | CurrencyCode |
IntercompanyOrder | SalesTable | InterCompanyOrder |
IntercompanyLegalEntityId | SalesTable | InterCompanyCompanyId |
IntercompanyPurchaseOrderNumber | SalesTable | InterCompanyPurchId |
IntercompanyOriginalSalesOrderNumber | SalesTable | InterCompanyOriginalSalesId |
IntercompanyDirectDelivery | SalesTable | InterCompanyDirectDelivery |
CreatedDate | SalesTable | CreatedDateTime |
DeliveryMode | SalesTable | DlvMode |