Histórico da Página

ER_

...

Invoice_Import

This document is an innovation requisite specification material, of extremely technical contentscontent.

General Information

Specification
Product	Microsiga Protheus	Module	Travel and Tourism Management
Executor Segment	Services
Project¹	M_SER_SER015	IRM¹	PCREQ-4320
Requisite¹	PCREQ-4322	Subtask¹	^{jira.totvs.com.br/browse/PDR_SER_TUR001-1080}
Planned Delivery Release	12.1.78	Copy
Country	( x ) Brazil ( x ) Argentina ( x ) Mexico ( x ) Chile ( x ) Paraguay ( x ) Ecuador ( x ) USA ( x ) Colombia ( ) Other _____________.
Others	<If needed, enter other references pertaining this specification. Example: links of other related documents or subtasks>.

...

To develop the source TURA038 in Model View Controller (MVC) to register Agent Billing Analyses in header and items format, using the data dictionary from tables G6H and G6I.
To create table G6H - Tourism Prov. Airline AGAABA:
G6H_FATURA - AGA ABA code.
G6H_TIPO - Register/import type.
G6H_LAYOUT - Layout of registered/imported AGAABA.
G6H_MES - AGA ABA reference month.
G6H_ANO - AGA ABA reference year.
G6H_PERCID - AGA ABA sending periodicity.
G6H_PERIOD - Period of AGA ABA reference month.
G6H_FATFOR - AGA ABA number.
G6H_EMISSA - AGA ABA issue date.
G6H_VENCTO - AGA ABA due date.
G6H_VALOR - AGA ABA value.
G6H_FORNEC - Code of provider who sent the AGAABA.
G6H_LOJA - Store of provider who sent the AGAABA.
G6H_NREDUZ - Corporate name of provider who sent the AGAABA.
G6H_REPORT - Enter whether the provider is of report.
G6H_EFETIV - Enter whether the AGA ABA has been activated.
G6H_DTIMP - Date of AGA ABA registration/import.
G6H_ARQUIV - Name of AGA ABA file.
To create table G6I - Tourism Prov. Airline AGA ABA Items:
G6I_FATURA - AGA ABA code.
G6I_ITEM - AGA ABA item code.
G6I_TIPOIT - Item type.
G6I_NUMLIN - Number of item row in AGAABA.
G6I_NUMCIA - Number of airline related to item.
G6I_SRBILH - Ticket serial.
G6I_BILHET - Ticket number.
G6I_DGBILH - Ticket verification digit.
G6I_LOCALI - Locator number.
G6I_EMISSA - Ticket issue date.
G6I_TARIFA - Ticket value.
G6I_TAXAS - Fee values.
G6I_TAXADU - DU fee value.
G6I_PERCOM - Commission percentage.
G6I_VLRCOM - Commission value.
G6I_VLRINC - Incentive value.
G6I_VLRINC - Refund value.
G6I_VLRLIQ - Net value.
G6I_TPOPER - Operation type.
G6I_TOURCD - Tour Code number.
G6I_DIVERG - Enter whether the item has any divergence.
G6I_CODDIV - Code of divergence found.
G6I_ACERTO - Enter whether an Adjustment has been generated due to divergence.
G6I_SITUAC - Item status in reconciliation.
G6I_CONCIL - Code of reconciliation process to which the item is correlated.
G6I_CODTAX - Code of Fee applied to reservation.
G6I_NUMID - Single identification number of Sales Record to which the item is correlated.
G6I_IDITEM - Sequential number of Sales Item of Sales Record to which the item is correlated.
G6I_NUMSEQ - Identification sequence of Sales Item to which the item is correlated (groups related items).
To develop function TURA038IMP in Model View Controller (MVC) to import AGAs ABAs and save the header (G6H) and items (G6I), utilizing the following MILE layout and function:
when the import is Airline Ticket (BSP): use layout MULE TURA038B.
when the import is Airline Locator (GOL): use the user function U_TURA038G.
Field G6H_FATURA is the key of the table. You cannot repeat it, as it is sequential and filled out automatically.
Field G6H_PERIOD is constituted by filling out field G6H_PERCID. Namely:

...

Thus, in the first 10 rows we have the AGA ABA "header" data and, from the 11th row onwards, the items data of this AGAABA, its fees, refunds and fines. Such data feed the AGA ABA tables, allowing the reconciliation routine to process the data received versus the transactions made in the system.

The file records feed entities "AGAABA" and "AGA ABA Items".

When generating the AGA ABA from the GOL layout files, you must generate the AGA ABA number with the IATA code catenation sent in ID GOL005B plus the sequential number generated and controlled by the backoffice routine. Example:

...

- Number generated: 000001

- AGA ABA Number: 8016000001 (8016 + 000001)

...

The BSP IATA layout is structured in blocks, the rows of which contain the generated ABA data restricted to a fixed size, with no use of separator. What differentiates the regular layout from the simplified layout is the presence of all or of only some record types in the file. Every BSP IATA file may contain the following structure, as exemplified below:

Image Added

Header Record

The file header is defined in the following structure:

ID	Field	Start	Size	Type	Description
HDR001	Sequential number	1	6	Numeric	Self increasing sequential number starting at 1 and increased for each record of file
HDR002	Record type	7	1	Numeric	Always 0
HDR003	Month of sale	8	2	Numeric	Month and year of sales
HDR004	Year of sale	10	2	Numeric	Month and year of sales
HDR005	Period from	12	7	Numeric	Range of period noted as YYYYMMP
HDR006	Period to	19	7	Numeric	Range of period noted as YYYYMMP
HDR007	Reserved space	26	135	Alphanumeric	Always blank
HDR008	Reserved space	161	46	Alphanumeric	Always blank

Transaction Record

The file transaction record is defined in the following structure:

ID	Field	Start	Size	Type	Description
TRR001	Sequential number	1	6	Numeric	Self increasing sequential number starting at 1 and increased for each record of file
TRR002	Record type	7	1	Numeric	Always 1
TRR003	Code of agent	8	8	Numeric	IATA agent code with verification digit
TRR004	Code of airline	16	4	Alphanumeric	IATA airline code with verification digit
TRR005	Code of transaction	20	1	Numeric	Transaction type, one of: 0 Canceled document 1 Mixed sale (MCO, MPD, ARV, etc.) 2 Ticket sale 3 Refund 4 ADM 5 ACM 6 TASF 7 VMPD 9 BSP Brazil only, regulation CCGR ADM of type “47”
TRR006	Document number	21	11	Numeric	Document number with verification digit, without airline code
TRR007	Blank vouchers	32	4	Alphanumeric	List of segment identifiers of blank vouchers and of surface. For example: “34 “ indicates vouchers numbered 3 and 4 are not flown
TRR008	Date of issue	36	6	Numeric	Date of transaction issue in format DDMMYY
TRR009	Currency	42	4	Alphanumeric	Transaction currency in format CUTP
TRR010	Collection of funds	46	9	Numeric	Gross tariff paid cash and credit (excepting fees)
TRR011	Creditor balance	55	9	Numeric	Gross tariff paid cash and credit (excepting fees)
TRR012	Fees total	64	9	Numeric	Sum total of fees (excepting fines)
TRR013	Cancellation fine	73	9	Numeric	Total cancellation fines (only refund)
TRR014	Commission fee	82	2.2	Numeric	By default, the actual commission fee and the totals; however, in BSP Brazil and in countries with generation of net ACM shipments, the default commission fee and quantity are added
TRR015	Taxable commission	86	9	Numeric
TRR016	Non-taxable commission	95	9	Numeric	BSP Brazil only, cash and credit discount total. Filled out with zeros for other BSPs
TRR017	Commission in cancellation fine	104	9	Numeric	Commission in cancellation fine
TRR018	Commission taxes	113	9	Numeric	Taxes in commission total
TRR019	Balance payable	122	9	Numeric	Net payable to airline
TRR020	Supplemental commission	131	9	Numeric	Supplemental commission
TRR021	Account number	140	15	Alphanumeric	Number of agent bank account
TRR022	Traffic type	155	1	Alphanumeric	Always blank, unless environment variable LIS2040_CON_ID has been exported, in which case the traffic type field may display: “I” – International “D” – Domestic
TRR023	Reserved space	156	4	Alphanumeric	Always blank
TRR024	Down payment of balance payable	160	1	Alphanumeric	Down payment of balance payable, which can be: “+” – Sum owed to airline “-“ – Owed to agent
TRR025	Code of tour	161	15	Alphanumeric	Code of tour, only BSP Brazil. Sent blank to other BSPs
TRR026	Fee of service agent	175	9	Numeric	Fee of service agent and fee of merchant / sum of discount (BSP Brazil only)
TRR027	Merchant fee	185	9	Numeric
TRR028	PNRR	194	13	Alphanumeric	PNRR (Passenger Name Record Reference) / BSP Brazil only

Credit Form of Payment Record

The credit record of payment method is defined in the following structure:

ID	Field	Start	Size	Type	Description
CPR001	Sequential number	1	6	Numeric	Self increasing sequential number starting at 1 and increased for each record of file
CPR002	Record type	7	1	Numeric	Always 2
CPR003	FPAC 1	8	20	Alphanumeric	Number of credit card account (FPAC) of the first seven credit card payment methods
CPR004	FPAC 2	28	20	Alphanumeric
CPR005	FPAC 3	48	20	Alphanumeric
CPR006	FPAC 4	68	20	Alphanumeric
CPR007	FPAC 5	88	20	Alphanumeric
CPR008	FPAC 6	108	20	Alphanumeric
CPR009	FPAC 7	128	20	Alphanumeric
CPR010	Reserved space	148	13	Alphanumeric	Always blank
CPR011	Reserved space	161	46	Alphanumeric	Always blank

...

The credit record of payment method is defined in the following structure:

In accordance with

ID	Field	Start	Size	Type	Description
RDR001	Sequential number	1	6	Numeric	Self increasing sequential number starting at 1 and increased for each record of file
RDR002	Record type	7	1	Numeric	Always 3
RDR003	Code of airline	8	3	Alphanumeric	Code of airline without the verification digit of correlated ticket
RDR004	Document number	11	10	Numeric	Number of correlated document without verification digit
RDR005	Vouchers	21	4	Alphanumeric	Correlated vouchers
RDR006	Code of airline	25	3	Alphanumeric	Second correlated document
RDR007	Document number	28	10	Numeric
RDR008	Vouchers	38	4	Alphanumeric
RDR009	Code of airline	42	3	Alphanumeric	Third correlated document
RDR010	Document number	45	10	Numeric
RDR011	Vouchers	55	4	Alphanumeric
RDR012	Code of airline	59	3	Alphanumeric	Fourth correlated document
RDR013	Document number	62	10	Numeric
RDR014	Vouchers	72	4	Alphanumeric
RDR014	Code of airline	76	3	Alphanumeric	Fifth correlated document
RDR016	Document number	79	10	Numeric
RDR017	Vouchers	89	4	Alphanumeric
RDR018	Code of airline	93	3	Alphanumeric	Sixth correlated document
RDR019	Document number	96	10	Numeric
RDR020	Vouchers	106	4	Alphanumeric
RDR021	Code of airline	110	3	Alphanumeric	Seventh correlated document
RDR022	Document number	113	10	Numeric
RDR023	Vouchers	123	4	Alphanumeric
RDR024	Code of airline	127	3	Alphanumeric	Eighth correlated document
RDR025	Document number	130	10	Numeric
RDR026	Vouchers	140	4	Alphanumeric
RDR027	Reserved space	144	17	Alphanumeric	Always blank
RDR028	Reserved space	161	46	Alphanumeric	Always blank

Conjunction Document Record

The conjunction document record is defined in the following structure:

ID	Field	Start	Size	Type	Description
CRD001	Sequential number	1	6	Numeric	Self increasing sequential number starting at 1 and increased for each record of file
CDR002	Record type	7	1	Numeric	Always 4
CDR003	Conjunctive ticket	8	11	Numeric	First conjunctive ticket with verification digit
CDR004	Blank vouchers	19	4	Alphanumeric	Unused vouchers
CDR005	Conjunctive ticket	23	11	Numeric	Second conjunctive ticket
CDR006	Blank vouchers	34	4	Alphanumeric	Second conjunctive ticket
CDR007	Conjunctive ticket	38	11	Numeric	Third conjunctive ticket
CDR008	Blank vouchers	49	4	Alphanumeric	Third conjunctive ticket
CDR009	Conjunctive ticket	53	11	Numeric	Fourth conjunctive ticket
CDR010	Blank vouchers	64	4	Alphanumeric	Fourth conjunctive ticket
CDR011	Conjunctive ticket	68	11	Numeric	Fifth conjunctive ticket
CDR012	Blank vouchers	79	4	Alphanumeric	Fifth conjunctive ticket
CDR013	Conjunctive ticket	83	11	Numeric	Sixth conjunctive ticket
CDR014	Blank vouchers	94	4	Alphanumeric	Sixth conjunctive ticket
CDR015	Conjunctive ticket	98	11	Numeric	Seventh conjunctive ticket
CDR016	Blank vouchers	109	4	Alphanumeric	Seventh conjunctive ticket
CDR017	Conjunctive ticket	113	11	Numeric	Eighth conjunctive ticket
CDR018	Blank vouchers	124	4	Alphanumeric	Eighth conjunctive ticket
CDR019	Reserved space	128	33	Alphanumeric	Always blank
CDR020	Reserved space	161	46	Alphanumeric	Always blank

Trailer Record

The file trailer is defined in the following structure:

ID	Field	Start	Size	Type	Description
TRL001	Sequential number	1	6	Numeric	Self increasing sequential number starting at 1 and increased for each record of file
TRL002	Record type	7	1	Numeric	Always 9
TRL003	Reserved space	8	153	Alphanumeric	Always blank
TRL004	Reserved space	161	46	Alphanumeric	Always blank

The register is developed in header format (ABA) and tabs, each tab with its respective functionality. Namely:

...

Header: location where the information given by the user upon adding or importing the ABA is saved and where the attribute controlling his/her status will be found. The caption also uses the status attribute.
TAB - TICKETS / DOCUMENTS – in this tab you can view all items imported or deleted, which you may filter, identifying whether each item is already associated and/or approved. In this folder, when the "Layout" attribute is equal to "Airline Manual" or "Others", an action is offered regarding the process of creating reconciliations through a button placed at the right side of the screen (see prototype - ABA Import - Tickets / Documents). When you execute this action, the association processes are executed and, if needed, adjustments. This action results in the creation of one or more reconciliation processes, separated by IATAs and by the ABA Item type.

Attributes

(*) – Fields required

(**) – Key fields of table

ABA Items (validate the items along the integration process)

Name	Description	Example
Branch (**)	Code of system branch	01 – Head Office
ABA Code (**)	Sequential code of ABA table	000002
Item (**)	Sequential code of imported item	000001
File	Imported file name	231014GOL3563575.TXT
Item Type	Type of Item. Options: 1 – TKTA (regular sale) 2 – ADM (fine) 3 – RFND (refund) * a FROM/TO in Alatur identifies these types * you must evaluate it through the integration process (Pedro)	TKTA
Row No.	Number of row in file	15
Airline No.	Number of airline	JJ
Ticket Sr.	Serial number of ticket/document	55258
Ticket No.	Number of ticket/document	8327001350
Ticket dig.	Verification digit of ticket	24
Locator	Number of locator for electronic ticket
Issue Dt.	Date of ticket/document issue	28/11/2014
Currency Cd.	Code of currency in which the sale was made	BRL
Tariff Vl.	Value of tariff sold	280.22
Fees Vl.	Total value of fees	56.39
DU Fee	Value of DU Fee	0.00
Commission %	Commission percentage	10
Commission Vl.	Value of commission	28.02
Incentive Vl.	Value of fixed incentive	0.00
Refund F.Vl.	Value of fine in case of refund	0.00
Net Vl.	Net value to be paid to or received from provider	308.59
Operation Tp.	Type of ABA option. Options: 1 – Debit 2 – Credit	Debit
Tour Code	Number of Tour Code used in sale
Divergent	Defines whether the item has any divergence. Options: 1 – Divergent 2 – Not Divergent	No
Diverg. Note	Note on divergence found when associating the item (evaluate whether you need a list, a register or free completion at development)
Adjustment Generated?	Enter whether an adjustment has been generated after the item divergence was identified. Options: 1 – Yes 2 – No If no adjustment has been generated, the item cannot be approved.
Status	The status of the item during reconciliation. Options: 1 – Not Associated 2 – Associated 3 – Approved	Not Associated
Reconciliation Cd.	Code of reconciliation process with which the item is correlated	000001
DR Cd.	Code of Reservation Document to which it is associated

...

TABLE G6H – ABAs' Headers

File SIX – Indices

Index	Key
01	G6H_FILIAL + G6H_FATURA + G6H_EMISSA +G6H_FORNEC + G6H_LOJA
02	G6H_FILIAL + G6H_ FATFOR
03	G6H_FILIAL+DTOS(G6H_EMISSA)+G6H_FORNEC+G6H_LOJA
04	G6H_FILIAL + DTOS(G6H_VENCTO) )+G6H_FORNEC+G6H_LOJA

File SX2 – Table

Table	Description
Acronym	G6H
Name	ABAs' Header
Branch Ac. Mod.	Shared
Unit Ac. Mod.	Shared
Company Ac. Mod.	Exclusive
Single Key	G6H_FILIAL + G6H_FATURA + G6H_EMISSA +G6H_FORNEC + G6H_LOJA
Display	G6H_FILIAL + G6H_FATURA + G6H_EMISSA +G6H_FORNEC + G6H_LOJA

File SX3 - Table Fields

Field	G6H_FILIAL
Type	C
Size	8
Picture	@!
Context	Real
Property	View
Description	Branch of System
Bill	Branch
Field Help	Branch of System
System Vl.	0
Default Init.	0
Required	Yes
Used	Yes
Browser	No
Modules	All

Field	G6H_FATURA
Type	C
Size	8
Picture	@!
Context	Real
Property	View
Description	ABA Code
Bill	ABA
Field Help	ABA Code
Validation	NotBlank()
Required	Yes
Used	Yes
Browser	Yes
Modules	All
Default Initializer	GetSXENum("G6H","G6H_FATURA")

Field	G6H_TIPO
Type	C
Size	1
Picture	@!
Context	Real
Property	Edit
Description	Import Type
Bill	Type
Field Help	Import Type 1=Directory. 2=File. 3=Physical
SXB Cons.	1=Directory. 2=File. 3=Physical System
System Vl.	Belongs("123")
Required	Yes
Used	Yes
Browser	Yes
Modules	All

Field	G6H_LAYOUT
Type	C
Size	1
Picture	@!
Context	Real
Property	Edit
Description	Layout
Bill	Layout
Field Help	ABA Layout 1=BSP Simplified. 2=Airline Manual. 3=Airline Locator. 4=Others
SXB Cons.	1=BSP Simplified. 2=Airline Manual. 3=Airline Locator. 4=Others
System Vl.	Belongs("1234")
Required	Yes
Used	Yes
Browser	Yes
Modules	All

Field	G6H_MES
Type	C
Size	2
Picture	99
Context	Real
Property	Edit
Description	Reference Month
Bill	Month
Field Help	Reference Month Enter a month between 01 and 12
System Vl.	Val(M->GH6_MES) >= 1 .and. Val(M->GH6_MES) <= 12
Required	Yes
Used	Yes
Browser	Yes
Modules	All

Field	G6H_ANO
Type	C
Size	4
Picture	9999
Context	Real
Property	Edit
Description	Reference Year
Bill	Year
Field Help	Reference Year.
Options	0
Required	Yes
Used	Yes
Browser	Yes
Modules	All

Field	G6H_PERCID
Type	C
Size	1
Picture	@!
Context	Real
Property	Edit
Description	Periodicity
Bill	Periodicity
Field Help	ABA Periodicity. 1=Weekly.2=Ten Day Period.3=Fortnightly.4=Monthly;5=Twenty Day Period
Options	1=Weekly.2=Ten Day Period.3=Fortnightly.4=Monthly;5=Twenty Day Period
Validation	Belongs("12345")
Required	Yes
Used	Yes
Browser	Yes
Modules	All

Field	G6H_PERIOD
Type	C
Size	1
Picture	@!
Context	Real
Property	Edit
Description	ABA Period
Bill	Period
Field Help	Enter the period within the periodicity, considering Weekly from 1 to 4, Ten Day Period from 1 to 3, Fortnightly from 1 to 2, Monthly just 1, Twenty Day Period from 1 to 2.
Options	1=1;2=2;3=3;4=4
Validation	TURA038Per()
Required	Yes
Used	Yes
Browser	Yes
Modules	All

Field	G6H_FATFOR
Type	C
Size	20
Picture	@!
Context	Real
Property	Edit
Description	ABA at Provider
Bill	ABA Prov
Field Help	Code of ABA in Provider
Required	No
Used	Yes
Browser	Yes
Modules	All

Field	G6H_EMISSA
Type	D
Size	8
Context	Real
Property	Edit
Description	ABA Issue
Bill	Issue
Field Help	ABA issue date
Validation	0
Required	Yes
Used	Yes
Browser	Yes
Modules	All

Field	G6H_VENCTO
Type	D
Size	8
Context	Real
Property	Edit
Description	ABA Due Date
Bill	Due Date
Field Help	ABA Due Date
Validation	0
Required	Yes
Used	Yes
Browser	Yes
Modules	All

Field	G6H_VALOR
Type	N
Size	12.2
Picture	@E999,999,999.99
Context	Real
Property	Edit
Description	ABA Value
Bill	Value
Field Help	ABA Value
Options	0
Validation	Positive()
Required	Yes
Used	Yes
Browser	Yes
Modules	All

Field	G6H_FORNEC
Type	C
Size	0
Picture	@!
Context	Real
Property	Edit
Description	Provider Code
Bill	Provider
Field Help	Code of ABA Provider
Validation	ExistCpo("SA2")
Required	Yes
Used	Yes
Browser	Yes
Modules	All

Field	G6H_LOJA
Type	C
Size	0
Picture	@!
Context	Real
Property	Edit
Description	Store
Bill	Store
Field Help	Store of ABA Provider
Validation	TURA038Loj()
Required	Yes
Used	Yes
Browser	Yes
Modules	All

Field	G6H_NREDUZ
Type	C
Size	0
Picture	@!
Context	Virtual
Property	Edit
Description	Provider Corporate Name
Bill	Corporate Name
Field Help	Provider Corporate Name
Validation	0
Required	No
Used	Yes
Browser	Yes
Modules	All

Field	G6H_REPORT
Type	C
Size	1
Picture	@!
Context	Real
Property	Edit
Description	Report Provider
Bill	Report
Field Help	Report Provider 1=Yes. 2=No.
Options	1=Yes.2=No
Validation	Belongs("12")
Required	No
Used	Yes
Browser	Yes
Modules	All

Field	G6H_EFETIV
Type	C
Size	0
Picture	@!
Context	Real
Property	Edit
Description	ABA in Effect
Bill	In Effect
Field Help	ABA in Effect
Options	1=Reconciled.2=Not Reconciled
Validation	Belongs("12")
Required	No
Used	Yes
Browser	Yes
Modules	All

Field	G6H_DTIMP
Type	D
Size	8
Context	Real
Property	View
Description	Import Date
Bill	Import Date
Field Help	Date of ABA Import
Required	No
Used	Yes
Browser	Yes
Modules	All

TABLE G6I – ABA Items

File SIX – Indices

Index	Key
01	G6I_FILIAL + G6I_FATURA + G6I_ITEM
02	G6I_FILIAL + DTOS(G6I_EMISSA)
03	G6I_FILIAL + G6I_NUMCIA + DTOS(G6I_EMISSA)
04	G6I_FILIAL + G6I_BILHET + G6I_SRBILH + G6I_DGBILH
05	G6I_FILIAL + G6I_LOCALI
06	G6I_FILIAL + G6I_TOURCD
07	G6I_FILIAL + G6I_CONCIL
08	G6I_FILIAL + G6I_DOCRES

File SX2 – Table

Table	Description
Acronym	G6I
Name	ABAs' Items
Branch Ac. Mod.	Shared
Unit Ac. Mod.	Shared
Company Ac. Mod.	Exclusive
Single Key	G6I_FILIAL + G6I_FATURA + G6I_ITEM
Display	G6I_FILIAL + G6I_FATURA + G6I_ITEM

File SX3 - Table Fields

Field	G6I_FILIAL
Type	C
Size	8
Picture	@!
Context	Real
Property	View
Description	Branch of System
Bill	Branch
Field Help	Branch of System
System Vl.	0
Default Init.	0
Required	Yes
Used	Yes
Browser	No
Modules	All

Field	G6I_FATURA
Type	C
Size	8
Picture	@!
Context	Real
Property	View
Description	ABA Code
Bill	ABA
Field Help	ABA Code
Required	Yes
Used	Yes
Browser	Yes
Modules	All

Field	G6I_ITEM
Type	C
Size	4
Picture	@!
Context	Real
Property	View
Description	ABA Item
Bill	Item
Field Help	ABA Item
Required	Yes
Used	Yes
Browser	Yes
Modules	All

Field	G6I_TIPOIT
Type	C
Size	1
Picture	99
Context	Real
Property	Edit
Description	Type of Item
Bill	Type of Item
Field Help	Type of Item. Options: 1=TKTA (regular sale);2=ADM (fine);3=RFND (refund)
SXB Cons.	1=TKTA (regular sale);2=ADM (fine);3=RFND (refund)
System Vl.	Belongs("123")
Required	Yes
Used	Yes
Browser	Yes
Modules	All

Field	G6I_NUMLIN
Type	C
Size	6
Picture	9999
Context	Real
Property	Edit
Description	File Row No.
Bill	Row Number
Field Help	Number of Row
Options	0
Required	Yes
Used	Yes
Browser	Yes
Modules	All

Field	G6I_NUMCIA
Type	C
Size	2
Picture	@!
Context	Real
Property	Edit
Description	Number of Airline
Bill	Airline No.
Field Help	Abbreviated Airline Number
Required	Yes
Used	Yes
Browser	Yes
Modules	All

Field	G6I_SRBILH
Type	C
Size	6
Picture	@!
Context	Real
Property	Edit
Description	Ticket Serial
Bill	Ticket Ser.
Field Help	Ticket Serial
Required	No
Used	Yes
Browser	Yes
Modules	All

Field	G6I_BILHET
Type	C
Size	20
Picture	@!
Context	Real
Property	Edit
Description	Ticket Number
Bill	Ticket No.
Field Help	Ticket Number
Required	No
Used	Yes
Browser	Yes
Modules	All

Field	G6I_DGBILH
Type	C
Size	2
Context	Real
Property	Edit
Description	Ticket Digit
Bill	Ticket Dig.
Field Help	Ticket Digit
Validation	0
Required	No
Used	Yes
Browser	Yes
Modules	All

Field	G6I_LOCALI
Type	C
Size	6
Picture	@!
Context	Real
Property	Edit
Description	Locator
Bill	Locator
Field Help	Locator
Validation	0
Required	No
Used	Yes
Browser	Yes
Modules	All

Field	G6I_EMISSA
Type	D
Size	8
Context	Real
Property	Edit
Description	ABA issue date
Bill	Issue
Field Help	ABA issue date
Options	0
Required	Yes
Used	Yes
Browser	Yes
Modules	All

Field	G6I_MOEDA
Type	C
Size	3
Picture	@!
Context	Real
Property	Edit
Description	ABA Currency
Bill	Currency
Field Help	ABA Currency
Required	Yes
Used	Yes
Browser	Yes
Modules	All

Field	G6I_TARIFA
Type	N
Size	12.2
Picture	@E999,999,999.99
Context	Real
Property	Edit
Description	Tariff
Bill	Tariff
Field Help	Tariff
Required	Yes
Used	Yes
Browser	Yes
Modules	All

Field	G6I_TAXAS
Type	N
Size	12.2
Picture	@E999,999,999.99
Context	Real
Property	Edit
Description	Fees
Bill	Fees
Field Help	Fees
Required	No
Used	Yes
Browser	Yes
Modules	All

Field	G6I_TAXADU
Type	N
Size	12.2
Picture	@E999,999,999.99
Context	Real
Property	Edit
Description	DU Fee
Bill	DU Fee
Field Help	DU Fee
Required	No
Used	Yes
Browser	Yes
Modules	All

Field	G6I_PERCOM
Type	N
Size	3.9
Picture	@E999.999999999
Context	Real
Property	Edit
Description	Commission Percentage
Bill	Commission %
Field Help	Commission Percentage
Validation	Empty() .or. Positive()
Required	No
Used	Yes
Browser	Yes
Modules	All

Field	G6I_VLRCOM
Type	N
Size	12.2
Picture	@E999,999,999.99
Context	Real
Property	Edit
Description	Value of Commission
Bill	Commission
Field Help	Value of Commission
Validation	Empty() .or. Positive()
Required	No
Used	Yes
Browser	Yes
Modules	All

Field	G6I_VLRINC
Type	N
Picture	@E999,999,999.99
Context	Real
Property	Edit
Description	Value of Incentive
Bill	Incentive
Field Help	Value of Incentive
Options	0
Validation	Empty() .or. Positive()
Required	No
Used	Yes
Browser	Yes
Modules	All

Field	G6I_VLRREE
Type	N
Size	12.2
Picture	@E999,999,999.99
Context	Real
Property	Edit
Description	Value of Refund
Bill	Refund
Field Help	Value of Refund
Options	0
Validation	Empty() .or. Positive()
Required	No
Used	Yes
Browser	Yes
Modules	All

Field	G6I_VLRLIQ
Type	N
Size	12.2
Picture	@E999,999,999.99
Context	Real
Property	Edit
Description	Net Value
Bill	Net Value
Field Help	Net Value
Options	0
Validation	Empty() .or. Positive()
Required	No
Used	Yes
Browser	Yes
Modules	All

Field	G6I_TPOPER
Type	C
Size	1
Picture	@!
Context	Real
Property	Edit
Description	Type of ABA Operation
Bill	Operation Tp
Field Help	Type of ABA Operation 1=Debit.2=Credit.
Options	1=Debit.2=Credit.
Validation	Belongs("12")
Required	Yes
Used	Yes
Browser	Yes
Modules	All

Field	G6I_TOURCD
Type	C
Size	20
Picture	@!
Context	Real
Property	Edit
Description	Tour Code
Bill	Tour Code
Field Help	Tour Code
Options	0
Validation	0
Required	No
Used	Yes
Browser	Yes
Modules	All

Field	G6I_DIVERG
Type	C
Size	1
Picture	@!
Context	Real
Property	Edit
Description	Enter whether you have found Divergences
Bill	Divergence
Field Help	Enter whether you have found Divergences 1=Yes.2=No.
Options	1=Yes.2=No
Validation	Belongs("12")
Required	No
Used	Yes
Browser	Yes
Modules	All

Field	G6I_CODDIV
Type	C
Size	250
Picture	@!
Context	Real
Property	Edit
Description	Stores the codes of Divergences found
Bill	Diverg Cd.
Field Help	Stores the codes of Divergences found
Required	No
Used	Yes
Browser	Yes
Modules	All

Field	G6I_ACERTO
Type	C
Size	1
Picture	@!
Context	Real
Property	Edit
Description	Enter whether an Adjustment was generated
Bill	Adjustment
Field Help	Enter whether an Adjustment was generated 1=Yes.2=No.
Options	1=Yes.2=No
Validation	Belongs("12")
Required	No
Used	Yes
Browser	Yes
Modules	All

Field	G6I_SITUAC
Type	C
Size	1
Picture	@!
Context	Real
Property	Edit
Description	The status of the item during reconciliation.
Bill	Status
Field Help	The status of the item during reconciliation. Options: 1=Non-associated;2=Associated;3=Approved
Options	1=Non-associated;2=Associated;3=Approved
Validation	Belongs("123")
Required	No
Used	Yes
Browser	Yes
Modules	All

Field	G6I_CONCIL
Type	C
Size	6
Picture	@!
Context	Real
Property	Edit
Description	Code of reconciliation process
Bill	Reconciliation
Field Help	Code of reconciliation process with which the item is correlated
Options	0
Validation	0
Required	No
Used	Yes
Browser	Yes
Modules	All

Field	G6I_CODTAX
Type	C
Size	6
Picture	@!
Context	Real
Property	View
Description	Code of Fee
Bill	Fee Code
Field Help	Code of Fee applied to ticket.
Validation	ExistCpo("G3A")
Required	No
Used	Yes
Browser	No
Modules	All
Field	G6I_NUMID
Type	C
Size	10
Picture	@!
Context	Real
Property	View
Description	Sales Rec. Code
Bill	SR Cd.
Field Help	Single identification number of Sales Record
Required	No
Used	Yes
Browser	No
Modules	All

Field	G6I_IDITEM
Type	C
Size	4
Picture	@!
Context	Real
Property	View
Description	Sales Item Cd.
Bill	SI Cd.
Field Help	Sequential number of Sales Item of Sales Record.
Required	No
Used	Yes
Browser	No
Modules	All
Field	G6I_NUMSEQ
Type	C
Size	2
Picture	@!
Context	Real
Property	View
Description	Sales Item Seq.
Bill	SL Seq.
Field Help	Identification sequence of Sales Item, used to gather related Sales Items.
Required	No
Used	Yes
Browser	No
Modules	All

Screen Prototypes

Provider ABA - Browser

Image Added

Attributes of parameter setting interface for Import

Image Added

Provider ABA - Header

Image Added

Provider ABA - Tab: Tickets / Documents - Layout: Simplified BSP

Image Added

Provider ABA - Tickets / Documents - Layout: Airline Locator

Image Added

Integrity Rules

Premises

You must use version 12 or above.
You can only delete an ABA if no item related to it has been approved.

Release Notes

Module	Tourism
Function	TURA038()
Description of Function	Now you can register and import the ABAs of airline providers to allow the definition of the rule negotiated with the entities.

Process Flow

Entity and Relationship

Image Added

Test Cases

A test case contains general information that determine how to conduct tests previously specified by the Tests Plan. Generally, they are grouped by requisite. However, you can group test cases by set of requisites, if the tests are integrally checking the requisites that belong to this set.

...

1. Reusable Test Case(s)

is() no

Test Cases	There	are	none
Storage
Procedures/Test Scenarios
Estimates
Tests Purpose
Recommendations
Product integrations

2. Test Case(s) Specific to the Project

Test Cases	Register an Airline Provider ABA
Tests Purpose	Registration of an Airline Provider ABA to be used by SIGATUR module routines
Estimates	5 min
Programmer Test	( X ) Yes ( ) No
Recommendations
Preconditions
Post-conditions
How to check the results	Updates -> Provider Reconciliation -> Agent Billing Analysis
Procedures	Expected Results
Register an Additional Entity	Updates -> Provider Reconciliation -> Agent Billing Analysis. Click "Add". Fill out the registration form. Pay attention to required fields. Add at least one item. Click "Save".

Test Cases	Import an Airline Provider ABA
Tests Purpose	Import of an Airline Provider ABA to be used by SIGATUR module routines
Estimates	5 min
Programmer Test	( X ) Yes ( ) No
Recommendations
Preconditions
Post-conditions
How to check the results	Updates -> Provider Reconciliation -> Agent Billing Analysis
Procedures	Expected Results
Register an Additional Entity	Updates -> Provider Reconciliation -> Agent Billing Analysis. Click "Other Actions" and select option "Import ABA". Fill out the import interface form. Pay attention to required fields. Click "Import".

contents

This document is an innovation requisite specification material, of extremely technical

content.

Páginas filhas

Versões comparadas

Versão antiga 4

Nova versão Atual

Chave