Posting Request, Transfer, Expansion (ATFA500) - Mobile Requests Table (SNZ)

CONTENT

Overview
Example of use
Table
Index
Fields
OTHER INFORMATION
Related Subjects

01. OVERVIEW

Technical documentation of table SNZ (Mobile Requests), table used by routine Posting Request or Transfer or Expansion (ATFA500).

02. EXEMPLE OF USE

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.

03. TABLE

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

05. FIELDS

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

06. OTHER INFORMATION

IMPORTANT!

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.

07. RELATED SUBJECTS

User Manual - My Fixed Assets

Páginas filhas