Appearance
Trading Partner Attributes
The Attributes of a Trading Partner are the values from the General Tab and Contact Details Tab for the Trading Partner.
These Attributes can be used in Statelake in several ways -
- As Trading Partner Tags such as <TPCustomerID>.
- As Properties of a Partner Object such as Partner.CustomerId.
- As columns in a Trading Partner database record, such as CUSTOMERID.
The references to Attributes as Tags, Properties, and columns are listed in the table below.
| Trading Partner Attribute | Trading Partner Tag | Partner Object Property | Database Column |
|---|---|---|---|
| (Statelake ID) | <TPId> | Partner.Id | [FID] [uniqueidentifier] |
| Partner Name | <TPName> | Partner.CompanyName | [MODULENAME] [varchar](255) |
| Partner Type | - | Partner.PartnerType | [PARTNERTYPE] [int] |
| Your ID for them as customer | <TPCustomerId> | Partner.CustomerId | [CUSTOMERID] [varchar](100) |
| Their ID for you as supplier | <TPTheirSupplierId> | Partner.TPSupplierId | [TPSUPPLIERID] [varchar](100) |
| Your ID for them as supplier | <TPSupplierId> | Partner.SupplierId | [SUPPLIERID] [varchar](100) |
| Their ID for you as customer | <TPTheirCustomerId> | Partner.TPCustomerId | [TPCUSTOMERID] [varchar](100) |
| Custom Id | <TPFlowNetId> <TPMemberID> | Partner.FlowNetId | [MEMBERID] [varchar](50) |
| User Name | <TPUsername> | Partner.Username | [USERNAME] [varchar](35) |
| User Password | <TPPassword> | Partner.Userpass | [USERPASS] [varchar](255) |
| First Name | <TPFirstName> | Partner.FirstName | - |
| Last Name | <TPLastName> | Partner.LastName | - |
| Address (field 1) | <TPAddress1> | Partner.Address1 | - |
| Address (field 2) | <TPAddress2> | Partner.Address2 | - |
| Suburb | <TPAddress3> | Partner.Address3 | - |
| City | <TPCity> | Partner.City | - |
| State | - | Partner.AddrState | - |
| Country | <TPCountry> | Partner.Country | - |
| Phone | <TPPhone> | Partner.Phone | - |
| Fax | <TPFax> | Partner.Fax | - |
| <TPEmail> | Partner.Email | - |