MN
MNMaterialList
Material List header.
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
BranchID | int | Branch | Branch | |
Description:The identifier of the Branch to which the material list belongs. The value of this field corresponds to the value of the Branch.BranchID field. | ||||
CreatedByID | uniqueidentifier | Created By | Users | |
Description:No description available | ||||
CreatedByScreenID | char(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | Created On | - | |
Description:No description available | ||||
CustomerID | int | Customer | Customer | |
Description:The identifier of the customer. The field is a part of the identifier of the customer location. The field is included in the foreign keys FK.Customer and FK.CustomerLocation. For a customer, the value of this field corresponds to the value of the Customer.bAccountID field. For a customer location, the value of this field corresponds to the value of the Location.bAccountID field. | ||||
CustomerLocationID | int | Location | Location | |
Description:The identifier of the customer location. The field is included in the FK.CustomerLocation foreign key. The value of this field corresponds to the value of the Location.locationID field. | ||||
Date | datetime | Date | - | |
Description:The date on which the material list was created. | ||||
DefaultSiteID | int | Preferred Warehouse ID | INSite | |
Description:The identifier of the warehouse from which the goods should be shipped. The value of this field corresponds to the value of the INSite.siteID field. This field is available only if the Inventory feature is enabled on the Enable/Disable Features (CS100000) form. | ||||
LastModifiedByID | uniqueidentifier | Last Modified By | Users | |
Description:No description available | ||||
LastModifiedByScreenID | char(8) | - | ||
Description:No description available | ||||
LastModifiedDateTime | datetime | Last Modified On | - | |
Description:No description available | ||||
LineCntr | int | - | ||
Description:A counter of the document lines, which is used internally to assign numbers to newly created lines. We do not recommend that you rely on this field to determine the exact number of lines because it might not reflect the this number under various conditions. | ||||
NoteID | uniqueidentifier | - | ||
Description:No description available | ||||
ProjectID | int | Project | PMProject | |
Description:The identifier of the project associated with the material list, or the non-project code indicating that the transaction is not related to any particular project. The value of this field corresponds to the value of the PMProject.ContractID field. | ||||
RefNbr | nvarchar(15) | Reference Nbr. | - | |
Description:The reference number of the material list. The number is generated from the numbering sequence `MATLIST`. | ||||
SelectedNonexistent in DB | bool? | Selected | - | |
Description:No description available | ||||
ShipAddressID | int | - | ||
Description:The identifier of the shipping address associated with the customer. Corresponds to the PMAddress.AddressID field. | ||||
ShipContactID | int | Shipping Contact | PMShippingContact | |
Description:The identifier of the shipping contact associated with the customer. Corresponds to the PMContact.ContactID field. | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||