Árvore de páginas

Versões comparadas

Chave

  • Esta linha foi adicionada.
  • Esta linha foi removida.
  • A formatação mudou.
Comentário: Migration of unmigrated content due to installation of a new plugin

Âncora
_GoBack
_GoBack
Integration Shopify (SIGAFAT) - Version Ingles

CONTENT

  1. Overview
  2. Example of use
  3. Setup Screen
    1. Taxes
    2. Type Inflow an Outflow
  4. Test Screen
  5. Tables


01. OVERVIEW

Totvs developed an integration with Shopify to assist those clients who have the need to integrate Protheus with their marketplace in order to achieve a higher sales demand. The integration was developed in March-July of 2020, and its first version was released on _________. Based on the APIs offered by Shopify, Totvs developed integration with each type of register to attend both Shopify and Protheus required data. The objective of the integration is to concentrate all sales, online and in-store, in Protheus, allowing the client to control its orders, invoices, inventory, finances and accounting in real-time.

Equivalence Overview

  • Product Group (SBM): Equivalent to Collections on Shopify.
  • Product (SB1 & SB4): Equivalent to Products and their variants in Shopify.
  • Customer (SA1): Equivalent to Customer in Shopify.
  • Inventory (SB2): Equivalent to Inventory Level in Shopify.
  • Orders & Invoice (SC5, SC6, SF2, SD2): Equivalent to Order in Shopify.For more information on Shopify APIs, please visit: https://shopify.dev/docs/admin-api/rest/reference

Business Rules Definitions

 All product register and product groups are primarily added and maintained in Protheus. Products that should be part of Shopify should be added to the table A1K. The final customer goes to the website to purchase products. He adds products to his cart and once he is ready to check out, he needs to either login or register in Shopify, which is validated through table A1D to check if the customer is existing in Protheus or not. If the customer does not exist in Protheus, it is added. The customer finalizes his purchase through paying in the website. The orders are integrated in Protheus, generating a Sales Order, which is released and invoiced automatically. If Protheus does not have enough products to issue that order, it goes to the Error Log Table. If it issues the order/invoice successfully, it generates an Accounts Payable to the customer, which is automatically posted. Workflow is shown below.


02. EXAMPLE OF USE

ChekList for Configuration

Initial Settings

  • Updated RPO;
  • Updated Invoice Menu;
  • It is essential to configure Appserver and DBAccess, to support messages up to 30MB.

Wiki Markup
The absence of this configuration can generate the error  " {*}String size overflow{*}"  for messages with many items.
\\
*Appserver.ini file{*}:
Please include the keys below:
\[{*}Environment{*}\]
TopMemoMega =30
\[{*}General{*}\]
MaxStringSize = 30
\\

  • In Invoice (SIGAFAT) access  Updates / Miscellaneous / ShopiFy / Paremeters (SHPINT003)Setup the integration information.
  • In Invoice (SIGAFAT) access  Updates / Registers / Variable Taxes (MATA995).

          Add / change the Taxes with the necessary information. See at section 03. Setup Screen a) Taxes
       In the "Out f. Formula" and "Inf. Formula" fields, fill in "EUATAX". 

  • In Invoice (SIGAFAT) access  Updates / Registers / Type Inflow an Outflow (MATA080).

          Add / change the TES setup ShopiFy Parameters with the necessary information below. See at section 03. Setup Screen  b) Type Inflow an Outflow
          Use the Variable Taxes created.

Project's Specific Case Tests


  • Collection Registration:

The registration of Collection is carried out in the Protheus system, and will be integrated with the ShopiFy system through ShopiFy API, if you want to check the fields that make up the Collect message, just access:  https://shopify.dev/docs/admin-api/rest/reference/products/customcollection?api[version]=2020-04
           1. In Invoice (SIGAFAT) access  Updates / Registers / Product Groups (MATA035).
           Add / change the Product Group with the necessary information. See at section 04. Test Screen 4.1
           1.1 Viewing the Collect in ShopiFy:
           In the Manager access  Products / Collections. See at section 04. Test Screen 4.1.1

  • Product Registration:

          2.0 In Invoice (SIGAFAT) access  Updates / Registers / Product (MATA010).
          Add / change the product with the necessary information. See at section 04. Test Screen 4.2.

  • Product Grids Registration:


           3.0 In Invoice (SIGAFAT) access  Updates / Registers / Product Grids (MATA550)
           Add / change the product grid with the necessary information. See at section 04. Test Screen 4.3 
           3.1 Viewing the Products created:
           Invoice (SIGAFAT) access  Updates / Registers / Product (MATA010). See at section 04. Test Screen 4.3.1

  • Product Setup - Registration (ShopiFy Integration):

The registration of Products  is carried out in the Protheus system, and will be integrated with the ShopiFy system through ShopiFy API, if you want to check the fields that make up the Product API, just access: https://shopify.dev/docs/admin-api/rest/reference/products/product?api[version]=2020-04
         
           4.0 In Invoice (SIGAFAT) access  Updates / Miscellaneous /  ShopiFy / Product Setup (SHPINT009)
           Add / change the product setup with the necessary information. See section 04. Test Screen 4.4.
           4.1 Click  Others Actions / Integrate  to Integrate with ShopiFy. See section 04. Test Screen 4.4.1
           4.2 Viewing the Collect in ShopiFy: In the Manager access  Products / All Products. See section 04. Test Screen 4.4.2

  • Product Grid Setup - Registration (ShopiFy Integration):

The registration of Product Grids  is carried out in the Protheus system, and will be integrated with the ShopiFy system through ShopiFy API, if you want to check the fields that make up the Product Variant API, just access:  https://shopify.dev/docs/admin-api/rest/reference/products/product-variant?api[version]=2020-04
           5.0 In Invoice (SIGAFAT) access  Updates / Miscellaneous / ShopiFy / Product Grid Setup (SHPINT008)
           Add / change the Product Grid setup with the necessary information.  See at section 04. Test Screen 4.5.0
           5.1 Click  Others Actions / Integrate  to Integrate with ShopiFy. See at section 04. Test Screen 4.5.1   
           5. 2  Viewing the Collect in ShopiFy. In the Manager Access Products/All Products See at section 04. Test Screen 4.5.2

  • Price List / Inventory Registration:

The registration of Prince List  is carried out in the Protheus system, and will be integrated with the ShopiFy system through ShopiFy API, if you want to check the fields that make up the Product and Variant API, just access: https://shopify.dev/docs/admin-api/rest/reference/products/product?api[version]=2020-04 / https://shopify.dev/docs/admin-api/rest/reference/products/product-variant?api[version]=2020-04
            
            With each product integration, both the price list and stock level will be updated.
            6.0 In Invoice (SIGAFAT) access  Updates / Registers / Sales Scenarios / Price Lists (OMSA010)
            Add / change the Price List with the necessary information. See at section 04. Test Screen 4.6.
            6.1 Viewing the Price List in ShopiFy. In the Manager access  Products / All Products. See at section 04. Test Screen 4.6.1
            6.2 Viewing the Inventory in ShopiFy. In the Manager access  Products / All Products. See at section 04. Test Screen 4.6.2
The registration of inventory item  is carried out in the Protheus system  , and will be integrated with the ShopiFy system   through ShopiFy API, if you want to check the fields that make up the Inventory Level API, just access:  https://shopify.dev/docs/admin-api/rest/reference/inventory/inventorylevel?api[version]=2020-04

  • Get Order

          7.0 Access the store  and make a Order. See at section 04. Test Screen 4.7
          7.1 Get and View the Sales Order in Protheus. See at section 04. Test Screen 4.7.1
          In  Invoice (SIGAFAT) access  Updates / Miscellaneous / ShopiFy / Invoice Integration (SHPINT001).
          In  Invoice (SIGAFAT) access  Orders /Sales Ordder (MATA410) 

  • Screen Monitor

          8.0 In  Invoice (SIGAFAT) access  Updates / Miscellaneous / ShopiFy / Monitor Integration (SHPINT005).  See at section 04. Test Screen 4.8
          Integration log errors will be displayed. You can view or reprocess the item again after correcting the problem.
    

03. SETUP SCREEN

a) Taxes


b) Type Inflow an Outflow


04. TEST SCREEN


4.1 Product Groups 


4.1.1 Collect in ShopiFy

4.2 Product

4.3 Product Grids


4.3.1 Viewing the Products created

4.4 Product Setup - Registrarion (ShopiFy Integration)

4.4.1 ShopiFy Integration


4.4.2 Viewing the Collect in ShopiFy

4.5 Product Grid Setup - Registration (ShopiFy Integration):
4.5.1 Click  Others Actions / Integrate  to Integrate with ShopiFy
4.5.2 Viewing the Collect in ShopiFy



4.6 Price List / Inventory Registration

4.6.1 Price List in ShopiFy

4.6.2 Inventory in ShopiFy

4.7 Make a Order


4.7.1 Sales Order



4.8 Monitor Integration

05. Tables

  • Shopify Integration Error Log (A1C) – Stores integration error logs for further analysis and correction.
  • Shopify Identifiers (A1D) – Stores the "from-to" equivalence between Protheus & Shopify.
  • Shopify Product Images (A1E) – Stores images URLs for Shopify exhibition.
  • Shopify Integration Parameters (A1F) – Stores integration parameters such as endpoints, API version, integration activation status, etc.
  • Shopify Integration Products (A1K) – Stores which products from Protheus should be exhibited in Shopify.
  • Shopify Tax Order Details (A1L) – Stores taxes details of each order
  • Shopify Product Grid Set-up (A1M) – Defines how product grids are exhibited in Shopify.


Data Dictionary
Table: A1C – Shopify Integration Error Log

Index

Key

01

A1C_FILIAL+A1C_INTEGR

02

A1C_FILIAL+A1C_DATE+A1C_TIME



Field

A1C_FILIAL

Type

C

Size

2

Decimal

0

Format

@!

Title

Branch

Description

Branch of the System

Level

1

Used

Yes

Required

Yes

Browse

No

Options

 

When

 

Relationship

 

Val. System

 

Val. User

 

F3

 

Help

 

Field

A1C_INTEGR

Type

C

Size

50

Decimal

0

Format

@!

Title

Int. Code

Description

Integration code

Level

0

Used

Yes

Required

0

Browse

S

Options

 

When

 

Relationship

 

Val. System

 

Val. User

 

F3

 

Help

Integration code


Field

A1C_ID

Type

C

Size

50

Decimal

0

Format

 

Title

Id

Description

Identifier

Level

0

Used

Yes 

Required

No

Browse

S

Options

 

When

 

Relationship

 

Val. System

 

Val. User

 

F3

 

Help

Alias Identifier

 

Field

A1C_IDEXT

Type

C

Size

50

Decimal

0

Format

 

Title

External Id

Description

External Id

Level

0

Used

Yes 

Required

No

Browse

S

Options

 

When

 

Relationship

 

Val. System

 

Val. User

 

F3

 

Help

External Id

 

Field

A1C_MESSAG

Type

M

Size

10

Decimal

0

Format

 

Title

Message

Description

Log Message

Level

0

Used

Yes 

Required

No

Browse

N

Options

 

When

 

Relationship

 

Val. System

 

Val. User

 

F3

 

Help

Log Message

 

Field

A1C_PATH

Type

C

Size

254

Decimal

0

Format

 

Title

Api Path

Description

Api Path

Level

0

Used

Yes 

Required

No

Browse

S

Options

 

When

 

Relationship

 

Val. System

 

Val. User

 

F3

 

Help

Api Path

 

Field

A1C_APIVER

Type

C

Size

20

Decimal

0

Format

 

Title

Api Version

Description

Api Version

Level

0

Used

Yes 

Required

No

Browse

S

Options

 

When

 

Relationship

 

Val. System

 

Val. User

 

F3

 

Help

Api Version

 

Field

A1C_BODY

Type

M

Size

10

Decimal

0

Format

 

Title

Request Body

Description

Request Body

Level

0

Used

Yes 

Required

No

Browse

N

Options

 

When

 

Relationship

 

Val. System

 

Val. User

 

F3

 

Help

Request Body

 

Field

A1C_VERB

Type

C

Size

10

Decimal

0

Format

 

Title

Request Verb

Description

Request Verb

Level

0

Used

Yes 

Required

No

Browse

S

Options

 

When

 

Relationship

 

Val. System

 

Val. User

 

F3

 

Help

Request Verb

 

Field

A1C_DATE

Type

D

Size

8

Decimal

0

Format

 

Title

Date

Description

Log date

Level

0

Used

Yes 

Required

No

Browse

S

Options

 

When

 

Relationship

 

Val. System

 

Val. User

 

F3

 

Help

Log date

 

Field

A1C_TIME

Type

C

Size

8

Decimal

0

Format

99:99:99

Title

Time

Description

Log time

Level

0

Used

Yes 

Required

No

Browse

S

Options

 

When

 

Relationship

 

Val. System

 

Val. User

 

F3

 

Help

Log time

 

Field

A1C_STATUS

Type

C

Size

1

Decimal

0

Format

 

Title

Status

Description

Error Status

Level

0

Used

Yes 

Required

No

Browse

S

Options

P=Pendente;R=Resolvido

When

 

Relationship

"P"

Val. System

 

Val. User

 

F3

 

Help

Error Status

 
Table: A1D – Shopify Identifiers

Index

Key

01

A1D_FILIAL+A1D_ALIAS+A1D_ID

02

A1D_FILIAL+A1D_ALIAS+A1D_ID+A1D_IDEXT+A1D_ALIASP+A1D_IDPAI


 

Field

A1D_FILIAL

Type

C

Size

2

Decimal

0

Format

@!

Title

Branch

Description

Branch of the System

Level

1

Used

Yes

Required

No

Browse

N

Options

 

When

 

Relationship

 

Val. System

 

Val. User

 

F3

 

Help

 

 

Field

A1D_ALIAS

Type

C

Size

20

Decimal

0

Format

 

Title

Alias

Description

Alias

Level

0

Used

Yes 

Required

No

Browse

S

Options

 

When

 

Relationship

 

Val. System

 

Val. User

 

F3

 

Help

Alias

 

Field

A1D_ID

Type

C

Size

20

Decimal

0

Format

 

Title

Protheus Id

Description

Protheus Id

Level

0

Used

Yes 

Required

No

Browse

S

Options

 

When

 

Relationship

 

Val. System

 

Val. User

 

F3

 

Help

Protheus Id

 

Field

A1D_IDEXT

Type

C

Size

20

Decimal

0

Format

 

Title

External Id

Description

External Id

Level

0

Used

Yes 

Required

No

Browse

N

Options

 

When

 

Relationship

 

Val. System

 

Val. User

 

F3

 

Help

External Id

 

Field

A1D_ALIASP

Type

C

Size

50

Decimal

0

Format

 

Title

Main Alias

Description

Main Alias

Level

0

Used

Yes 

Required

No

Browse

S

Options

 

When

 

Relationship

 

Val. System

 

Val. User

 

F3

 

Help

Main Alias

 

Field

A1D_IDPAI

Type

C

Size

20

Decimal

0

Format

 

Title

Main Id

Description

Main Id

Level

0

Used

Yes 

Required

No

Browse

S

Options

 

When

 

Relationship

 

Val. System

 

Val. User

 

F3

 

Help

Main Id

 

Field

A1D_LASTUP

Type

C

Size

30

Decimal

0

Format

 

Title

Last Update

Description

Last Update

Level

0

Used

Yes 

Required

No

Browse

S

Options

 

When

 

Relationship

 

Val. System

 

Val. User

 

F3

 

Help

Last Update

 
Table: A1E – Shopify Product Images

Index

Key

01

A1E_FILIAL+A1E_COD

02

A1E_FILIAL+A1E_COD+A1E_SEQUEN

 

Field

A1E_FILIAL

Type

C

Size

2

Decimal

0

Format

@!

Title

Branch

Description

Branch of the System

Level

1

Used

Yes

Required

No

Browse

N

Options

 

When

 

Relationship

 

Val. System

 

Val. User

 

F3

 

Help

 

 

Field

A1E_COD

Type

C

Size

20

Decimal

0

Format

 

Title

Product Code

Description

Product Code

Level

0

Used

Yes 

Required

No

Browse

S

Options

 

When

 

Relationship

 

Val. System

 

Val. User

 

F3

SB1

Help

Product Code

 

Field

A1E_SEQUEN

Type

C

Size

3

Decimal

0

Format

 

Title

Sequence

Description

Image sequence

Level

0

Used

Yes 

Required

No

Browse

S

Options

 

When

 

Relationship

 

Val. System

 

Val. User

 

F3

 

Help

Image sequence

 

Field

A1E_DESC

Type

C

Size

30

Decimal

0

Format

 

Title

Description

Description

Description

Level

0

Used

Yes 

Required

No

Browse

S

Options

 

When

 

Relationship

 

Val. System

 

Val. User

 

F3

 

Help

Description

 

Field

A1E_URL

Type

C

Size

254

Decimal

0

Format

 

Title

Photo Url

Description

Photo url

Level

0

Used

Yes 

Required

No

Browse

S

Options

 

When

 

Relationship

 

Val. System

 

Val. User

 

F3

 

Help

Photo url

 

Field

A1E_INTEGR

Type

C

Size

1

Decimal

0

Format

 

Title

Int.Shopify?

Description

Integrate with Shopify

Level

0

Used

Yes 

Required

No

Browse

S

Options

1=Sim;2=Não

When

 

Relationship

'2'

Val. System

 

Val. User

 

F3

 

Help

 

 
Table: A1F – Shopify integration parameters

Index

Key

01

A1F_FILIAL+A1F_PARAM

 
 

Field

A1F_FILIAL

Type

C

Size

2

Decimal

0

Format

@!

Title

Branch

Description

Branch of the System

Level

1

Used

Yes

Required

No

Browse

N

Options

 

When

 

Relationship

 

Val. System

 

Val. User

 

F3

 

Help

 

 

Field

A1F_PARAM

Type

C

Size

20

Decimal

0

Format

@!

Title

Parameter

Description

Parameter name

Level

0

Used

Yes 

Required

No

Browse

S

Options

 

When

 

Relationship

 

Val. System

 

Val. User

ExistChav("A1F", M->A1F_PARAM, 1)

F3

 

Help

Parameter name

 

Field

A1F_DESC

Type

C

Size

254

Decimal

0

Format

@!

Title

Description

Description

Parameter description

Level

0

Used

Yes 

Required

No

Browse

S

Options

 

When

 

Relationship

 

Val. System

 

Val. User

 

F3

 

Help

Parameter description

 

Field

A1F_CONT

Type

C

Size

254

Decimal

0

Format

 

Title

Content

Description

Parameter content

Level

0

Used

Yes 

Required

No

Browse

S

Options

 

When

 

Relationship

 

Val. System

 

Val. User

 

F3

 

Help

Parameter content

 

Field

A1F_MANDAT

Type

C

Size

1

Decimal

0

Format

 

Title

Mandatory

Description

Mandatory parameter

Level

0

Used

Yes 

Required

No

Browse

S

Options

1=Sim;2=Não

When

 

Relationship

"1"

Val. System

 

Val. User

 

F3

 

Help

Mandatory parameter

 
Table: A1K – Shopify integration products

Index

Key

01

A1K_FILIAL+A1K_COD

02

A1K_FILIAL+A1K_CODPAI

 
 

Field

A1K_FILIAL

Type

C

Size

2

Decimal

0

Format

@!

Title

Branch

Description

Branch of the System

Level

1

Used

Yes

Required

0

Browse

N

Options

 

When

 

Relationship

xFilial("A1K")

Val. System

 

Val. User

 

F3

 

Help

 

 

Field

A1K_SEQUEN

Type

C

Size

3

Decimal

0

Format

 

Title

Sequence

Description

Display sequence

Level

0

Used

Yes 

Required

No

Browse

S

Options

 

When

 

Relationship

 

Val. System

 

Val. User

 

F3

 

Help

Display sequence

 

Field

A1K_COD

Type

C

Size

20

Decimal

0

Format

 

Title

Product Code

Description

Product code

Level

0

Used

Yes 

Required

No

Browse

S

Options

 

When

 

Relationship

 

Val. System

 

Val. User

ExistCpo("SB1", M->A1K_COD)

F3

SB1

Help

Product code

 

Field

A1K_DESC

Type

C

Size

70

Decimal

0

Format

 

Title

Description

Description

Product description

Level

0

Used

Yes 

Required

No

Browse

N

Options

 

When

 

Relationship

IF(INCLUI,"",GETADVFVAL("SB1","B1_DESC", XFILIAL("SB1") + A1K->A1K_COD,1))

Val. System

 

Val. User

 

F3

 

Help

Product description

 

Field

A1K_TAX

Type

C

Size

1

Decimal

0

Format

 

Title

Taxable?

Description

Taxable Product?

Level

0

Used

Yes 

Required

No

Browse

N

Options

1=Sim;2=Não

When

 

Relationship

'1'

Val. System

 

Val. User

 

F3

 

Help

Taxable Product?

 

Field

A1K_INI

Type

D

Size

8

Decimal

0

Format

 

Title

Initial date

Description

Initial date

Level

0

Used

Yes 

Required

No

Browse

S

Options

 

When

 

Relationship

Date()

Val. System

 

Val. User

 

F3

 

Help

Initial date

 

Field

A1K_FIM

Type

D

Size

8

Decimal

0

Format

 

Title

End Date

Description

End Date

Level

0

Used

Yes 

Required

No

Browse

S

Options

 

When

 

Relationship

 

Val. System

 

Val. User

 

F3

 

Help

End Date

 

Field

A1K_GRIDID

Type

C

Size

20

Decimal

0

Format

 

Title

Grid Id

Description

Grid Id

Level

0

Used

Yes

Required

No

Browse

N

Options

 

When

 

Relationship

 

Val. System

 

Val. User

ExistCpo("ZZY", M->A1K_GRIDID)

F3

 

Help

Grid Id

 

Field

A1K_SQLTIT

Type

C

Size

100

Decimal

0

Format

 

Title

Sql - Title

Description

Sql Field for title

Level

0

Used

Yes 

Required

No

Browse

S

Options

 

When

 

Relationship

 

Val. System

 

Val. User

 

F3

 

Help

SQL Field for brand. Available table alias: SB1, SBM, SB4, SB5, LIN (SBV), COL (SBV)

 

Field

A1K_SQLPES

Type

C

Size

100

Decimal

0

Format

 

Title

Sql - Weight

Description

Sql field for Weight

Level

0

Used

Yes 

Required

No

Browse

S

Options

 

When

 

Relationship

 

Val. System

 

Val. User

 

F3

 

Help

Sql field for Weight.Available table alias: SB1, SBM, SB4, SB5, LIN (SBV), COL (SBV)

 

Field

A1K_CODPAI

Type

C

Size

20

Decimal

0

Format

 

Title

Parent Code

Description

Parent Code

Level

0

Used

Yes

Required

No

Browse

N

Options

 

When

 

Relationship

 

Val. System

 

Val. User

 

F3

 

Help

Parent Code

 
Table: A1L – Shopify Tax

Index

Key

01

A1L_FILIAL+ A1L_ORDER

02

A1L_FILIAL+ A1L_TAXCOD

 

Field

A1L_FILIAL

Type

C

Size

2

Decimal

0

Format

@!

Title

Branch

Description

Branch of the System

Level

1

Used

Yes

Required

No

Browse

N

Options

 

When

 

Relationship

 

Val. System

 

Val. User

 

F3

 

Help

 

 

Field

A1L_ID

Type

C

Size

20

Decimal

0

Format

 

Title

ID

Description

 

Level

0

Used

Yes 

Required

No

Browse

N

Options

 

When

 

Relationship

 

Val. System

 

Val. User

 

F3

 

Help

 

 

Field

A1L_SKU

Type

C

Size

20

Decimal

0

Format

 

Title

SKU

Description

 

Level

0

Used

Yes 

Required

No

Browse

N

Options

 

When

 

Relationship

 

Val. System

 

Val. User

 

F3

 

Help

 

 

Field

A1L_ITEM

Type

C

Size

2

Decimal

0

Format

 

Title

Item

Description

 

Level

0

Used

Yes 

Required

No

Browse

N

Options

 

When

 

Relationship

 

Val. System

 

Val. User

 

F3

 

Help

 

 

Field

A1L_ORDER

Type

C

Size

10

Decimal

0

Format

 

Title

Order

Description

 

Level

0

Used

Yes 

Required

No

Browse

N

Options

 

When

 

Relationship

 

Val. System

 

Val. User

 

F3

 

Help

 

 

Field

A1L_VALIMP

Type

N

Size

14

Decimal

2

Format

@E 99,999,999,999.99

Title

Sales Tax

Description

 

Level

0

Used

Yes 

Required

No

Browse

N

Options

 

When

 

Relationship

 

Val. System

 

Val. User

 

F3

 

Help

 

 

Field

A1L_BASIMP

Type

N

Size

14

Decimal

2

Format

@E 99,999,999,999.99

Title

Tax Rate

Description

 

Level

0

Used

Yes 

Required

No

Browse

N

Options

 

When

 

Relationship

 

Val. System

 

Val. User

 

F3

 

Help

 

 

Field

A1L_TAXCOD

Type

C

Size

30

Decimal

0

Format

 

Title

Tax Code

Description

 

Level

0

Used

Yes 

Required

No

Browse

N

Options

 

When

 

Relationship

 

Val. System

 

Val. User

 

F3

 

Help

 

 

Field

A1L_ALIIMP

Type

N

Size

6

Decimal

2

Format

@E 999.99

Title

Tax Rate

Description

 

Level

0

Used

Yes 

Required

No

Browse

N

Options

 

When

 

Relationship

 

Val. System

 

Val. User

 

F3

 

Help

 

 

Field

A1L_INVOIC

Type

C

Size

13

Decimal

0

Format

 

Title

Invoice Numb

Description

 

Level

0

Used

Yes 

Required

No

Browse

N

Options

 

When

 

Relationship

 

Val. System

 

Val. User

 

F3

 

Help

 

 

Field

A1L_SERIE

Type

C

Size

3

Decimal

0

Format

 

Title

Serie

Description

 

Level

0

Used

Yes 

Required

No

Browse

N

Options

 

When

 

Relationship

 

Val. System

 

Val. User

 

F3

 

Help

 

 

Field

A1L_CLIENT

Type

C

Size

6

Decimal

0

Format

 

Title

Client

Description

 

Level

0

Used

Yes 

Required

No

Browse

N

Options

 

When

 

Relationship

 

Val. System

 

Val. User

 

F3

 

Help

 

 

Field

A1L_LOJA

Type

C

Size

4

Decimal

0

Format

 

Title

Store

Description

 

Level

0

Used

Yes 

Required

No

Browse

N

Options

 

When

 

Relationship

 

Val. System

 

Val. User

 

F3

 

Help

 


Table: A1M – Shopify Product Setup

Index

Key

01

A1M_FILIAL+ A1M_COD

 

Field

A1M_FILIAL

Type

C

Size

2

Decimal

0

Format

@!

Title

Branch

Description

Branch of the System

Level

1

Used

Yes

Required

0

Browse

N

Options

 

When

 

Relationship

 

Val. System

 

Val. User

 

F3

 

Help

 

 

Field

A1M_COD

Type

C

Size

20

Decimal

0

Format

 

Title

Shopify Prod

Description

Shopify Prod

Level

0

Used

Yes 

Required

No

Browse

S

Options

 

When

INCLUI

Relationship

 

Val. System

 

Val. User

 

F3

 

Help

Shopify Product

 

Field

A1M_DESC

Type

C

Size

254

Decimal

0

Format

@!

Title

Description

Description

Grid description

Level

0

Used

Yes 

Required

No

Browse

S

Options

 

When

 

Relationship

 

Val. System

 

Val. User

 

F3

 

Help

Grid description

 

Field

A1M_SQLTIT

Type

C

Size

100

Decimal

0

Format

 

Title

Sql - Title

Description

SQL Field for title

Level

0

Used

Yes 

Required

No

Browse

N

Options

 

When

 

Relationship

 

Val. System

 

Val. User

 

F3

 

Help

SQL Field for title. Available table alias: SB1, SBM, SB4, SB5, LIN (SBV), COL (SBV)

 

Field

A1M_SQLMAR

Type

C

Size

100

Decimal

0

Format

 

Title

Sql - Brand

Description

SQL Field for brand

Level

0

Used

Yes 

Required

No

Browse

N

Options

 

When

 

Relationship

 

Val. System

 

Val. User

 

F3

 

Help

SQL Field for brand. Available table alias: SB1, SBM, SB4, SB5, LIN (SBV), COL (SBV)

 

Field

A1M_SQLHTM

Type

C

Size

254

Decimal

0

Format

 

Title

Sql - Html

Description

Sql - Body Html

Level

0

Used

Yes 

Required

No

Browse

N

Options

 

When

 

Relationship

 

Val. System

 

Val. User

 

F3

 

Help

Sql - Body Html.Available table alias: SB1, SBM, SB4, SB5, LIN (SBV), COL (SBV)

 

Field

A1M_SQLTP

Type

C

Size

100

Decimal

0

Format

 

Title

Sql-Prod Tp

Description

SQL Field for prod. type

Level

0

Used

Yes 

Required

No

Browse

N

Options

 

When

 

Relationship

 

Val. System

 

Val. User

 

F3

 

Help

 

 

Field

A1M_SQLTAG

Type

C

Size

254

Decimal

0

Format

 

Title

Sql - Tag

Description

SQL field for tag

Level

0

Used

Yes 

Required

No

Browse

N

Options

 

When

 

Relationship

 

Val. System

 

Val. User

 

F3

 

Help

SQL field for tag.The content must be separated by comma.Available table alias: SB1, SBM, SB4, SB5, LIN (SBV), COL (SBV)

 

Field

A1M_GRADE

Type

C

Size

1

Decimal

0

Format

 

Title

Grid?

Description

Product Grid?

Level

0

Used

Yes

Required

No

Browse

N

Options

1=Sim;2=Não

When

 

Relationship

 

Val. System

 

Val. User

 

F3

 

Help

Product Grid?