Scribd
Upload
31 views25 pages

Mapping Cashpro To Oracle

The document outlines the requirements for various tax and utility payment methods, including those with and without barcodes. It specifies mandatory fields such as Debtor and Creditor Tax IDs, Creditor Address, and various extra payment details for each payment type. Additionally, it includes comments and instructions for managing the information in the system and the involvement of the AP and Supplier teams.

Uploaded by

sumathi Jampala
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
31 views25 pages

Mapping Cashpro To Oracle

The document outlines the requirements for various tax and utility payment methods, including those with and without barcodes. It specifies mandatory fields such as Debtor and Creditor Tax IDs, Creditor Address, and various extra payment details for each payment type. Additionally, it includes comments and instructions for managing the information in the system and the involvement of the AP and Supplier teams.

Uploaded by

sumathi Jampala
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 25

Tax & Utility payment with Barcode

Sr.No Information Description Mandatory


1 Secondary Payment Method Code T11 Yes

Fill CPF if the Debtor (Drawee),is


a Taxpayer (11 numeric) fill,,CGC
or CNPJ if the Debtor (Drawee)
is a Corporate Taxpayer (14
2 Debtor Taxid Numeric) Yes

This information needs to be


3 Creditor Taxid added in ebiz Yes

4 Extra Payment Detail CONVENIO Yes

5 Creditor Address Beneficiary Address Yes


6 Extra Payment Detail Document Number BTAX Yes

DARF Tax payment without Barcode


Sr.No Information Description Mandatory
1 Secondary Payment Method Code T16 Yes

Fill CPF if the Debtor (Drawee),is


a Taxpayer (11 numeric) fill,,CGC
or CNPJ if the Debtor (Drawee)
is a Corporate Taxpayer (14
2 Debtor Taxid Numeric) Yes

This information needs to be


3 Creditor Taxid added in ebiz Yes
4 Extra Payment Detail Fine Amount NO
5 Extra Payment Detail Tax Due Date Yes
6 Extra Payment Detail Fed Tax Code Yes
7 Extra Payment Detail Tax Principal Amount Yes

8 Extra Payment Detail Enrollment Number Yes


7 Extra Payment Detail Tax Calc Yes
8 Extra Payment Detail Tax Principal Amount Yes
9 Extra Payment Detail Tax Reference NO
10 Creditor Address Beneficiary Address Yes
11 Interest Amount Interest Amount No

GPS Tax payment without Barcode


Sr.No Information Description Mandatory
1 Secondary Payment Method Code T17 Yes

Fill CPF if the Debtor (Drawee),is


a Taxpayer (11 numeric) fill,,CGC
or CNPJ if the Debtor (Drawee)
is a Corporate Taxpayer (14
2 Debtor Taxid Numeric) Yes

This information needs to be


3 Creditor Taxid added in ebiz Yes
6 Extra Payment Detail Fed Tax Code Yes
7 Extra Payment Detail Tax Calc Yes

8 Extra Payment Detail INSS Amount Yes

7 Extra Payment Detail Penalty Amount Yes


8 Extra Payment Detail Other Entity Amount Yes

10 Creditor Address Beneficiary Address Yes

GARE Tax payment without Barcode


Sr.No Information Description Mandatory
1 Secondary Payment Method Code T22 Yes

Fill CPF if the Debtor (Drawee),is


a Taxpayer (11 numeric) fill,,CGC
or CNPJ if the Debtor (Drawee)
is a Corporate Taxpayer (14
2 Debtor Taxid Numeric) Yes

This information needs to be


3 Creditor Taxid added in ebiz Yes
7 Extra Payment Detail Tax Calc NO

5 Extra Payment Detail Interest Amount Yes


6 Extra Payment Detail Fed Tax Code Yes
5 Extra Payment Detail Tax Due Date Yes
8 Extra Payment Detail Revenue amount Yes
8 Extra Payment Detail Fine Amount Yes

9 Extra Payment Detail TAX TYPE NO

10 Creditor Address Beneficiary Address Yes


Tax & Utility payment with Barcode
Comment P2P Comments
Can be managed in informatica

We can hard code in Informatica.This


information will be provided by AP Team Need to check with Business - 00.723.020/0001-90

This field is already available in XML, Supplier team needs to add


Supplier team to add taxid it at Supplier site address book global descriptiove flexfield
Can be managed in informatica .. AP team
to provide CONVENIO Number Need to check with Business. 2371

This field is already available in XML, Supplier team needs to add


Supplier team to add Address supplier address. Employee suppliers site address need to check
Bar code from Tax & Utility Bar code number is available in Payment PDF. Need to check to add field in Oracle

DARF Tax payment without Barcode


Comment P2P Comments
Can be managed in informatica

We can hard code in Informatica.This


information will be provided by AP Team Need to check with business. 03 - 22.112.608/0001-40

This field is already available in XML, Supplier team needs to add


Supplier team to add taxid it at Supplier site address book global descriptiove flexfield
AP team to send if available Need to check with business if we can get this information. 08
DD/MM/YYYY Format. AP Team to send Need to check with business if we can get this information. 06
AP Team to send.Prefix with /ENYC/ Need to check with business if we can get this information. 04
AP Team to send Need to check with business if we can get this information. 07

AP Team to send.Fill CPF if the Beneficiary


is aTaxpayer (11 numeric) fillCGC or CNPJ
if theBeneficiary is a Corporate Taxpayer
(14 Numeric) Is it same as Creditor Taxid? If yes, it is already available in XML
Tax Calculation period dd/mm/yyyy Need to check with business if we can get this information. 02
AP Team to send Need to check with business if we can get this information. 07
AP team to send if available Need to check with business if we can get this information. 05
This field is already available in XML, Supplier team needs to add
Supplier team to add Address supplier address
Interest Amount Need to check with business if we can get this information. 09

GPS Tax payment without Barcode


Comment P2P Comments
Can be managed in informatica

We can hard code in Informatica.This


information will be provided by AP Team Need to check with business

This field is already available in XML, Supplier team needs to add


Supplier team to add taxid it at Supplier site address book global descriptiove flexfield
AP Team to send.Prefix with /ENYC/ Need to check with business if we can get this information. 03
Tax month & year (MMYYYY) Need to check with business if we can get this information. 04
AP team to send amount prefix with
/INSS/ Need to check with business if we can get this information. 06
AP team to send amount prefix with
/PENA/ Need to check with business if we can get this information. 10
AP Team to send Prefix with /OENT/ Need to check with business if we can get this information. 09
This field is already available in XML, Supplier team needs to add
Supplier team to add Address supplier address

GARE Tax payment without Barcode


Comment P2P Comments
Can be managed in informatica

We can hard code in Informatica.This


information will be provided by AP Team Need to check with business

This field is already available in XML, Supplier team needs to add


Supplier team to add taxid it at Supplier site address book global descriptiove flexfield
Tax Month and Year(MMYYYY) Need to check with business if we can get this information. 07
AP team to send Interest Amount with
prefix /INTA/ Need to check with business if we can get this information. 10
AP Team to send.Prefix with /ENYC/ Need to check with business if we can get this information. 03
DD/MM/YYYY Format. AP Team to send Need to check with business if we can get this information. 02
AP Team to send Prefix with /REVA/ Need to check with business if we can get this information. 09
AP Team to send.Prefix with /FINA/ Need to check with business if we can get this information. 11
AP team to send.Prefix with /REFN. Gare
Type, if GARE ICMS =22 GARE= 23 Need to check with business if we can get this information
This field is already available in XML, Supplier team needs to add
Supplier team to add Address supplier address
Sample Invoice - ISS042021

check to add field in Oracle

Invoice - 032021IRRF1708INV6293COMPUW
Sample Invoice - INSSGILSON0032

Sample Invoice - ICMS032021


2

02--Tax due date


Tax code--4 digit code
04--vendor tax id creditor tax id
05--BMC tax id--debitor tax id
06--Blank
07--Tax period
08--Blank
09--Principal amount
10--
11--
12--
13--
14--total
convenio Number--2371
Organization name--BMC Software DO brazil ltda
Value date--13/05/2021
Tax Period--31/03/2021
CNPJ number--BMC tax payer id(00723020000190)
Tax id--differs from payment to payment 4 digit code
Tax Due date-20/04/2021
08 interest
09 penality
07 principal amount
10 Total
Tax period--4
CNPJ number --identificador
Valor --Principal amount 6
Valor De-9--Penality
3--Tax id
10--
Required fields in

Convenio number--2371
Due Date--10/05/2021
Barcode--48 digit number
Tax and Utility Barcode DARF Tax Payment GPS Tax Payment
Secondary Payment Method Code Secondary Payment Method Code Secondary Payment Method Code
Debtor Taxid Debtor Taxid Debtor Taxid
Creditor Taxid Creditor Taxid Creditor Taxid
Creditor Address Creditor Address Creditor Address
Enrollment Number -> Same as
Creditor Taxid ?
CONVENIO

Document Number BTAX


Tax Principal Amount INSS Amount
Fine Amount Penalty Amount
Interest Amount Other Entity Amount
Tax Due Date
Fed Tax Code Fed Tax Code
Tax Calc Period Month and Year
Tax Calc Period (dd/mm/yyyy) (MMYYYY)
Tax Reference
GARE Tax Payment
Secondary Payment Method Code
Debtor Taxid
Creditor Taxid
Creditor Address

Revenue amount
Fine Amount
Interest Amount
Tax Due Date
Fed Tax Code
Tax Calc Period Month and Year
(MMYYYY)

TAX TYPE

You might also like