Routines that compose the SIAFI section in PROTHEUS

ROUTINE

DESCRIPTION

Notes

FINA760.PRW

Financial Clearing Document Statuses

FINA761.PRW

Financial Clearing Document

Sub-routines:

ROUTINE	DESCRIPTION
FINA761OBR.PRW	Bank Orders
FINA761PDC.PRW	Pre-document
FINA761VAR.PRW	Variable Fields
FINA761WS.PRW	Send Financial Clearing Document (FCD) operations to the SIAFI's Web Service (WS)

FINA762.PRW

Responsible Management Unit

FINA763.PRW

Financial Programming

Sub-routine:

ROUTINE	DESCRIPTION
FINA763WS.PRW

FINXSIAFI.PRW

Functions auxiliary to SIAFI

Informações

title	Information

For more details on legislation, visit the Sao Paulo city hall link: Registration of Companies Outside the City

...

02. Processes - Requirements

...

List of the tables to be created

SIORG

Field	SIORG
Type	Numeric / Int
Size	6
Format	@999999
Title	Institutional Innovation and Organization System
Description	Tree structure containing the Units list. It can be taken from the following W ebService.
Level	1
Used	Yes
Mandatory	No
*Browse*	Yes
Visual?	View
Context	Actual
Options	<Empty>
*When*	<Empty>
*Relationship*	<Empty>
*System Val.*	<Empty>
*Help*	SIORG

COST CENTER

Field	Cost Center
Type	String
Size	11
Format	@!
Title	Expense Nature
Description	Information containing the Cost Center code. Bound to the Protheus' default cost center code because it contains 1 to 11 fields. It is necessary to check if the SIAFI's and the Customer's is the same as the Protheus'.
Level	1
Used	Yes
Mandatory	No
*Browse*	Yes
Visual?	View
Context	Actual
Options	<Empty>
*When*	<Empty>
*Relationship*	<Empty>
*System Val.*	<Empty>
*Help*	Cost Center Cd.

EXPENSE NATURE

Field	Expense Nature
Type	Numeric / int
Size	8
Format	@E 9.9.99.99.99
Title	Expense Nature
Description	Expense's budgeting classification. Table link: http://www.proplan.ufpr.br/portal/normas/NEOF%2010%20-%20Natureza%20da%20Despesa%20(Planilha).xls
Level	1
Used	Yes
Mandatory	No
*Browse*	Yes
Visual?	View
Context	Actual
Options	<Empty>
*When*	<Empty>
*Relationship*	<Empty>
*System Val.*	<Empty>
*Help*	Budgeting Class.

Data modelling, field creation in file SX3 – Fields:

Table SE3 Accounts Payable:

E2_CODSERV

Field	E2_CODSERV
Type	Character
Size	9
Decimal	0
Format	@!
Title	ISS Serv.Cd
Description	ISS Service Code
Level	1
Used	Yes
Mandatory	No
*Browse*	No
Visual?	Edit
Context	Actual
Options	<empty>
*When*	<empty>
Relationship	<empty>
System Val.	ExistCpo("SX5","60"+AllTrim(M→E2_CODSERV)) .and. Fa050Nat2()
*Help*	E2_CODSERV

E2_BTRISS

Field	E2_BTRISS
Type	Numeric
Size	14
Decimal	2
Format	@E 99,999,999,999.99
Title	ISS Doublet
Description	ISS CPOM Double Taxation
Level	1
Used	Yes
Mandatory	No
*Browse*	No
Visual?	Edit
Context	Actual
Options	<Empty>
*When*	M->E2_MULTNAT != "1"
Relationship	<Empty>
System Val.	Positivo() .and. IIF(M->E2_TIPO="PR" .and. M->E2_ISSBTR > 0,.F.,.T.)
*Help*	E2_BTRISS

E2_VRETBIS

Field	E2_VRETBIS
Type	Numeric
Size	14
Decimal	2
Format	@E 99,999,999,999.99
Title	ISB With. Vl
Description	Double t. ISS With. Vl
Level	1
Used	Yes
Mandatory	No
*Browse*	No
Visual?	View
Context	Actual
Options	<Empty>
*When*	<Empty>
*Relationship*	<Empty>
*System Val.*	<Empty>
*Help*	E2_VRETBIS

Accounts Receivable

Data modelling, fields creation in file SX3 – Fields:

Table SE1 Accounts Receivable:

E1_CODSERV

Field	E1_CODSERV
Type	Character
Size	9
Decimal	0
Format	@!
Title	ISS Serv.Cd
Description	ISS Service Code
Level	1
Used	Yes
Mandatory	No
*Browse*	No
*Visual?*	Edit
Context	Actual
Options	<empty>
*When*	<empty>
Relationship	<empty>
System Val.	ExistCpo("SX5","60"+AllTrim(M→E1_CODSERV)) .and. Fa040Natur()
*Help*	E1_CODSERV

E1_BTRISS

Field	E1_BTRISS
Type	Numeric
Size	14
Decimal	2
Format	@E 99,999,999,999.99
Title	ISS Double Taxation
Description	ISS Double Taxation Value
Level	1
Used	Yes
Mandatory	No
*Browse*	No
Visual?	Edit
Context	Actual
Options	<Empty>
*When*	M->E1_MULTNAT != "1"
Relationship	<Empty>
System Val.	positivo() .and. m->e1_iss < m->e1_valor .and. IIF(m->e1_tipo="PR" .and. m->e1_iss > 0,.F.,.T.) .and. fa040valor()
*Help*	ISS Double Taxation

E1_VRETBIS

Field	E1_VRETBIS
Type	Numeric
Size	14
Decimal	2
Format	@E 99,999,999,999.99
Title	ISSB With. Value
Description	Value withheld in ISS Double Taxation
Level	1
Used	Yes
Mandatory	No
*Browse*	No
Visual?	View
Context	Actual
Options	<Empty>
*When*	<Empty>
*Relationship*	<Empty>
*System Val.*	<Empty>
*Help*	ISSB With. Value

04. References

SIAFI - Complete Manual: http://manualsiafi.tesouro.gov.br/

...

Páginas filhas

Versões comparadas

Versão antiga 1

Nova versão Atual

Chave

Routines that compose the SIAFI section in PROTHEUS

02. Processes - Requirements

List of the tables to be created

SIORG

COST CENTER

EXPENSE NATURE

Páginas filhas

Histórico da Página

Versões comparadas

Versão antiga 1

Nova versão Atual

Chave

Routines that compose the SIAFI section in PROTHEUS

02. Processes - Requirements

List of the tables to be created

SIORG

COST CENTER

EXPENSE NATURE