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

-

Email

<TPEmail>

Partner.Email

-