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 |