Technical documentation of table SNZ (Mobile Requests), table used by routine Posting Request or Transfer or Expansion (ATFA500).
The table SNZ (Mobile Requests) is used in routine Posting Request or Transfer or Expansion (ATFA500), to store the pre-requests made by "MY FIXED ASSETS", app in which you can directly request postings, transfers and expansion.
Key | SNZ |
Name | Mobile Requests |
Mode | Exclusive |
Pyme | Yes |
04. TABLE INDEX
Index | SNZ |
Order | 1 |
Key | NZ_FILIAL+NZ_CBASE+NZ_ITEM+DTOS(NZ_DATA)+NZ_SEQ |
Description | Base Code + Item Code + Date + Sequential |
Display Search | Yes |
Field | NZ_FILIAL |
Type | Character |
Size | 8 |
Decimal | 0 |
Title | Branch |
Description | Code of branch |
Used | No |
Required | No |
Field Group | 033 - Branch Size |
Order | 01 |
Field | NZ_CBASE |
Type | Character |
Size | 10 |
Decimal | 0 |
Format | @! |
Title | Base Code |
Description | Asset Base Code |
Used | Yes |
Mandatory | No |
Browse | Yes |
Context | Real |
Order | 02 |
Field | NZ_ITEM |
Type | Character |
Size | 4 |
Decimal | 0 |
Format | @! |
Title | Item Code |
Description | Code of Item |
Used | Yes |
Mandatory | No |
Browse | Yes |
Context | Real |
Order | 03 |
Field | NZ_TIPO |
Type | Character |
Size | 2 |
Decimal | 0 |
Format | @9 |
Title | Type |
Description | Type of Asset |
Used | Yes |
Mandatory | No |
Browse | Yes |
Editing Mode | M->(NZ_OPER)$"0" |
Context | Real |
Order | 04 |
Field | NZ_TPSALDO |
Type | Character |
Size | 1 |
Decimal | 0 |
Format | @! |
Title | Type of Balance |
Description | Type of Balance |
Used | Yes |
Mandatory | No |
Browse | Yes |
Editing Mode | M->(NZ_OPER)$"0" |
Context | Real |
Order | 05 |
Field | NZ_DATA |
Type | Date |
Size | 8 |
Decimal | 0 |
Title | Date |
Description | Addition Date |
Used | Yes |
Mandatory | No |
Browse | Yes |
Context | Real |
Order | 06 |
Field | NZ_SEQ |
Type | Character |
Size | 3 |
Decimal | 0 |
Format | @! |
Title | Sequential |
Description | Sequential |
Used | Yes |
Mandatory | No |
Browse | No |
Default Init. | GETSXENUM("SNZ", "NZ_SEQ") |
Context | Real |
Order | 07 |
Field | NZ_DESCRI |
Type | Character |
Size | 250 |
Decimal | 0 |
Format | @! |
Title | Description |
Description | Description |
Used | Yes |
Required | No |
Browse | Yes |
Context | Real |
Order | 08 |
Field | NZ_VALOR |
Type | Numeric |
Size | 16 |
Decimal | 2 |
Format | @E 9,999,999,999,999.99 |
Title | Amount |
Description | Value |
Used | Yes |
Required | No |
Browse | Yes |
Editing Mode | M->(NZ_OPER)$"0/2" |
Context | Real |
Order | 09 |
Field | NZ_QUANT |
Type | Numeric |
Size | 11 |
Decimal | 3 |
Format | @9999999.999 |
Title | Quantity |
Description | Quantity |
Used | Yes |
Required | No |
Browse | Yes |
Editing Mode | M->(NZ_OPER)$"0/2" |
Context | Real |
Order | 10 |
Field | NZ_TRANSF |
Type | Character |
Size | 1 |
Decimal | 0 |
Format | @! |
Title | Transf. Type |
Description | Type of transfer |
Used | Yes |
Required | No |
Browse | No |
Options | 0=Physical; 1=Accounting |
Context | Real |
Order | 11 |
Field | NZ_OPER |
Type | Character |
Size | 1 |
Decimal | 0 |
Format | @! |
Title | Oper. Type |
Description | Type of Operation |
Used | Yes |
Required | No |
Browse | No |
Options | 0=Posting; 1=Transfer; 2=Expansion |
Context | Real |
Order | 12 |
Field | NZ_STATUS |
Type | Character |
Size | 1 |
Decimal | 0 |
Format | @! |
Title | Add. State |
Description | State of Addition |
Used | Yes |
Required | No |
Browse | No |
Options | 0=Pending; 1=Finished; 2=Canceled |
Context | Real |
Order | 13 |
My Fixed Assets is compatible with Protheus from version 12.1.17 (issued in JANUARY/2018). For the App to work correctly, it is imperative that table SNZ (Mobile Requests) be compliant with the documentation. When you query fields of table SNZ, if there is a field called NZ_TABORI or if fields differ from the documentation, the system administrator must delete table SNZ - Mobile Requests and add it again through the configurator, following the documentation above.IMPORTANT!