Understanding Accounts Receivable Draft Processing in Spain
This chapter provides an overview of accounts receivable draft processing and discusses how to:
Work with draft remittance formats.
Originate drafts for Spain.
Reprint drafts for Spain.
Enter A.E.B. customer and supplier bank information for Spain.
Generate financial statement reports for Spain.
Understanding Accounts Receivable Draft Processing in Spain
The JD Edwards EnterpriseOne system provides country-specific functionality for draft origination and draft remittance in Spain. To process accounts receivable drafts in Spain, perform these steps:
Set up the JD Edwards EnterpriseOne Accounts Receivable system base software for drafts, and also use the Maintenance of Stamp Fees program (P74S505) to set up fees for draft stamps for Spain.
Use Spain-specific programs to group invoices and print drafts.
Use the standard JD Edwards EnterpriseOne Accounts Receivable software to accept drafts.
Use Spain-specific programs to remit drafts.
Use the standard JD Edwards EnterpriseOne Accounts Receivable software to collect drafts.
See Also
Processing Accounts Receivable Drafts
Prerequisites
Before you work with draft remittance for Spain:
Set up UDCs.
See Setting Up UDCs for Accounts Receivable.
See Setting Up UDCs for Accounts Receivable Drafts for Spain.
Set up draft stamp tables.
Working With Draft Remittance Formats for Spain
This section provides an overview of draft remittance formats and discusses how to:
Set processing options for Draft Remittance File Format AEB 19 - Spain (R74S6729).
Set processing options for Draft Remittance File Format AEB 32 - Spain (R74S6722).
Set processing options for Draft Remittance File Format AEB 58 - Spain (R74S6728).
Understanding Remittance Formats for Spain
The system provides these remittance formats to remit drafts to the bank:
Draft Remittance File Format AEB 32 - Spain (R74S6722).
Draft Remittance File Format AEB 58 - Spain (R74S6728).
To remit drafts using one of these formats, enter the program number and version of the format that you want to use in the Paper/Tape processing option of the Draft Remittance program (R03B672).
The Spanish remittance formats create Text File Processor batches that contain the remittance information.
Use the AEB 19 format to remit drafts for which the funds will be collected later.
The AEB 19 can be submitted in either of two formats. You specify the format in the processing options of the Draft Remittance File Format AEB 19 - Spain program (R74S6729). Format 1 contains the invoice number in the reference field. Format 2 contains the draft number in the reference field. The format that you select depends on the requirements of the bank to which you remit the drafts.
Use the AEB 32 to remit discounted drafts for which you have a physical receipt.
Use the AEB 58 format to remit drafts for which the bank will advance you the funds before the due date of the draft. This process is called discounting a draft. When you discount a draft in Spain, you must recognize contingent liability.
See Understanding Journal Entries Created by the Draft Post.
Setting Processing Options for Draft Remittance File Format AEB 19 - Spain (R74S6729)
Processing options enable you to specify the default processing for programs and reports.
Process
These processing options specify the format in which drafts are printed as well as where address information is stored on customer records in the JD Edwards EnterpriseOne Address Book system.
|
Format |
Specify the format that the system uses. Values are: Blank: Format one. 1: Format two. |
|
Client Address Line Number |
Specify the address line number in the address book record that contains the street address of the client. Values are: Blank: Address line 1. 1: Address line 2. 2: Address line 3. |
|
City Address Line Number |
Specify the address line number in the address book record that contains the city of the client. Values are: Blank: Address line 1. 2: Address line 2. 3: Address line 3. 4: Address line 4. |
Currency
This processing option specifies the currency in which the system creates remittances.
|
Currency Designation |
Specify whether the system creates remittances using euros or the currency of the company. Values are: Blank: Use the company currency. 1: Use euros (EUR). |
Defaults
These processing options specify processing information that the system uses when creating remittances.
|
1. File Creation Date |
Specify the date on which the remittance is created. If you leave this processing option blank, the system uses the system date as the default value. |
|
2. Company Number |
Specify the company that is issuing the remittance. Blank is not a value. |
Setting Processing Options for Draft Remittance File Format AEB 32 - Spain (R74S6722)
Processing options enable you to specify the default processing for programs and reports.
Process
|
Client Address Line Number |
Specify the address line number in the address book record that contains the street address of the client. Values are: Blank: Address line 1. 1: Address line 2. 2: Address line 3. |
|
City Address Line Number |
Specify the address line number in the address book record that contains the city of the client. Values are: Blank: Address line 1. 2: Address line 2. 3: Address line 3. 4: Address line 4. |
Currency
This processing option specifies the currency in which the system creates remittances.
|
Currency Designation |
Specify whether the system creates remittances using euros or the currency of the company. Values are: Blank: Use the company currency. 1: Use euros (EUR). |
Defaults
These processing options specify processing information that the system uses when creating remittances.
|
1. File Creation Date |
Specify the date on which the remittance is created. If you leave this processing option blank, the system uses the system date as the default value. |
|
2. Company Number |
Specify the company that is issuing the remittance. Blank is not a value. |
|
3. Draft Type |
Specify the type of draft that the system uses to create remittances. Values are: Blank: Receipt. 1: Letra 2: Receipt 3: Pagare |
|
4. Customer Acceptance Status |
Specify the customer draft acceptance status. Values are: Blank: Drafts are not accepted. 1: Drafts are accepted. 2: Drafts are not accepted. |
|
5. Draft Fees Choice |
Specify the draft fees choice. Values are: 0: Without fees. 1: With fees. 9: Orden de protesto notarial. |
|
6. Geographic Area Code |
Specify the geographic area code (UDC 00/S) that the system prints on remittance records. If this processing option is left blank, the system uses the first two digits in the zip code. |
|
7. Village Emission Code |
Specify the name of the city of the company. |
Setting Processing Options for Draft Remittance File Format AEB 58 - Spain (R74S6728)
Processing options enable you to specify the default processing for programs and reports.
Currency
This processing option specifies the currency in which the system creates remittances.
|
1. Currency Designation |
Specify whether the system creates remittances using euros or the currency of the company. Values are: Blank: Use the company currency. 1: Use euros (EUR). |
Date
This processing option specifies the date that the remittance is created.
|
1. File Creation Date |
Specify the date on which the remittance is created. If you leave this processing option blank, the system uses the system date as the default value. |
Company
This processing option specifies the company number issuing the remittance.
|
1. Company Number |
Specify the company that is issuing the remittance. Blank is not a value. |
AEB 58
|
AEB 58 Suffix |
Enter the suffix for the tax ID. This value should be from 000 to 999. |
Originating Drafts for Spain
This section provides an overview of Spanish draft origination, the Print Receipt with Letter Program, and the Print Drafts from Invoices program, list prerequisites, and discusses how to:
Group invoices for drafts.
Set processing options for Invoice Group by Draft (R03B5052).
Print drafts with letters.
Set processing options for Print Receipt with Letter (R74S500).
Print drafts from invoices.
Set processing options for Print Drafts from Invoices (R74S502).
Understanding Spanish Draft Origination
The draft process begins when you originate (print) a draft. The draft shows the amount to be paid, the due date, and information about the underlying liabilities (invoices).
The first step in draft origination is grouping invoices for drafts. You use the Invoice Group by Draft program (R03B5052) to group invoices for drafts.
The Invoice Group by Draft program groups open invoices from the F03B11 table by either customer number or payor number; and by company, currency code, and net due date. You can also use detail mode to group each invoice pay item with the same net due date on one draft.
For each group, the program assigns the draft number of the draft as a control number. The program also produces a report that includes a total for each group of invoices. This total is the amount of the draft.
The system processes only invoices that have an open amount and that have an empty Control/Statement field (CTL) in the F03B11 table. The system excludes invoices with record types R1, R5, or RU, as well as invoices for customers who have a Send Invoice To (SITO) value of N for Company 00000 in the Customer Master by Line of Business table (F03012).
Note. You must group records in the Invoice Group by Draft program in the same way that you process records in the Print Drafts from Invoices program. For example, if you set the processing options on the Invoice Group by Draft program to group by customer, you must also set the processing options on the Print Drafts from Invoices program to process by customer. If you specify the Print Drafts with Invoices program in the processing options of the Invoice Group by Draft program, the processing option value for grouping does not get passed from the Invoice Group by Draft program to the Print Drafts with Invoices program. You must set up matching processing options for both programs.
Printing Drafts
You can use the processing options on the Invoice Group by Draft program to run a program that prints the drafts, such as the Print Drafts from Invoices program (R74S502). You can also print the drafts separately after running the Invoice Group by Draft program.
You can use the processing options on the Invoice Group By Draft program (R03B5052) to run either of these draft print programs:
Print Receipt with Letter (R74S500)
Print Drafts from Invoices (R74S502)
Both of these programs create drafts based on invoices (document type RI). Print Receipt with Letter does not group invoices according to their stamp fees, whereas Print Drafts from Invoices does.
Understanding the Print Receipt with Letter Program
The Print Receipt with Letter program prints statements of invoices and their corresponding drafts using the groupings that are produced by the Invoice Group by Draft program (R03B5052).
The system uses the customer number to retrieve bank transit information from the Bank Transit Master table (F0030). The system first looks for a record with a bank type of D (A/R Drafts, Auto Debit). If no record with a bank type of D exists, the system looks for a record with a bank type of C (Customer Bank Account). The system retrieves additional bank information from the A.E.B. Bank - Spain table (F74SCSB) by cross-referencing the transit number from the F0030 table with a bank code and control digit in table F74SCSB.
If no record with a bank type of either D or C exists for the customer in the F0030 table, the system does not print bank transit information on the draft.
Note. You must process records in the Print Receipt with Letter program in the same way that you group records in the Invoice Group by Draft program. For example, if you set the processing options for the Invoice Group by Draft program to group by customer, you must also set the processing options for the Print Receipt with Letter program to process by customer. If you specify the Print Receipt with Letter program in the processing options for the Invoice Group by Draft program, the processing option value for grouping does not get passed from the Invoice Group by Draft program to the Print Receipt with Letter program. You must set up matching processing options for both programs.
The Print Receipt with Letter program retrieves information from the F03B11 table.
Understanding the Print Drafts from Invoices Program
The Print Drafts from Invoices program (R74S502) uses the groups that are produced by the Invoice Group by Draft program (R03B5052) to prints drafts. The total amount of each draft, which is the total open amount of each group of invoices, determines the amount of the stamp that is required on the draft.
The system retrieves fee amounts from these tables:
Stamps (Timbres) Fee Detail (F74S502)
Stamps (Timbres) Fee Header (F74S505)
If the system cannot find a fee that corresponds to the draft amount, it sends an error message to the work center and does not print the draft.
The Print Drafts from Invoices program produces one printer spool file for each fee amount. All of the drafts that have the same fee amount are included in one printer spool file. This grouping enables you to load the paper with the appropriate stamp for each group of drafts.
Note. You must group records in the Print Drafts from Invoices program in the same way that you group records in the Invoice Group by Draft program. For example, if you set the processing options for the Invoice Group by Draft program to group by customer, you must also set the processing options for the Print Drafts from Invoices program to group by customer. If you specify the Print Drafts with Invoices program in the processing options for the Invoice Group by Draft program, the processing option value for grouping does not get passed from the Invoice Group by Draft program to the Print Drafts with Invoices program. You must set up matching processing options for both programs.
The Print Drafts from Invoices program selects RI documents from the F03B11 table.
Data Selection
It is recommended that you set up data selection based on a currency code.
Prerequisites
Before you complete the tasks in this section:
Set up the fee table for draft stamps.
Enter bank information for Spanish customers in the AEB Bank Revisions - Spain program (P74SCSB) and in the Bank Accounts by Addresses program (P0030A). The bank transit number in the Bank Accounts Addresses program corresponds to the bank code and office code in the AEB Bank Revisions - Spain program. The first four digits of the bank transit number are the bank code, and the second four digits are the office code.
See Entering A.E.B. Customer and Supplier Bank Information for Spain.
Grouping Invoices for Drafts
Select Spanish Draft Processing (G74S03B161), Invoice Group by Draft.
Setting Processing Options for Invoice Group by Draft (R03B5052)
Processing options enable you to specify the default processing for programs and reports.
Defaults
This processing option specifies a default value for the pay status code on R1 draft records.
|
1. Pay Status Code |
Specify the Payment Status code (UDC 00/PS) that the system assigns to processed invoices. |
Process
These processing options specify how the system selects invoices for payment.
|
1. Process Mode |
Specify how the system groups invoices and assigns draft numbers when it processes invoices. You can specify that the system process the invoices in detail mode, in which case the system assigns one draft number to each invoice or group of pay items with the same net due date. For example, for an invoice with two pay items whose net due dates differ, the system generates two drafts. For an invoice with two pay items whose net due dates are the same, the system generates only one draft. Alternatively, you can group invoices by customer and assign one draft number to all invoices that have the same company, currency code, net due date, and customer number. Finally, you can group invoices by payor and assign one draft number to all invoices that have the same company, currency code, net due date, and payor number. Values are: Blank: Process invoices in detail mode. 1: Group invoices by customer (AN8). 2: Group by invoices payor (PYR). |
|
2. Threshold Amount |
Specify the threshold amount that the system uses to suppress draft creation. If the total draft amount for the group of invoices is less than this threshold amount, no draft number is assigned to the invoices in the group. The system compares the threshold amount that you enter to the total domestic open amount, regardless of the currency code. |
Versions
These processing options specify the program number and version to use to print drafts.
|
1. Program ID |
Specify the program that the system uses to print the drafts that are generated by this program. If you leave this processing option blank, you must manually run a draft print program to print the drafts. |
|
2. Version ID |
Specify the version of the program that you specified in the Program ID processing option that the system uses to print drafts. If you leave this processing option blank, the system runs version ZJDE0001. If the ZJDE0001 version does not exist, the report does not run. If the Program ID processing option is blank, the system disregards this processing option. |
Printing Drafts with Letters
Select Spanish Draft Processing (G74S03B161), Print Receipt with Letter.
Setting Processing Options for Print Receipt with Letter (R74S500)
Processing options enable you to specify the default processing for programs and reports.
Defaults
|
1. Creation Date |
Use this processing option to enter the date that you want to appear on the receipt and letter. If you leave this processing option blank, the program uses the current system date. |
|
2. City of Origin |
Specify the city of origin of the receipt. The system prints the city that you enter here on the receipt. If you leave this processing option blank, no city of origin appears on the receipt. |
Process
|
1. Address Number |
Specify the address number that the system uses to determine where to send the receipt. Values are: Blank: Use the customer number (AN8). 1: Use the payor number (PYR). |
|
1. Print Tax Amounts |
Use this processing option to indicate whether you want tax amounts to appear on the letter. Values are: Blank: Do not print tax amounts. 1: Print tax amounts. |
|
2. Print Currency |
Specify whether the system prints the invoice currency code and currency amounts on the receipt and the letter. Values are: Blank: Do not print currency information. 1: Print currency information. If you enter 1, the system prints foreign invoices with foreign amounts. If currency processing is not enabled, the system prints invoices with domestic amounts. |
|
3. Print Attachments |
Use this processing option to indicate whether you want generic text associated with an invoice to be printed on the letter. Values are: Blank: Do not print associated generic text. 1: Print associated generic text. |
Printing Drafts from Invoices
Select Spanish Draft Processing (G74S03B161), Print Drafts from Invoices.
Setting Processing Options for Print Drafts from Invoices (R74S502)
Processing options enable you to specify the default processing for programs and reports.
Defaults
|
1. Creation Date |
Use this processing option to indicate the date when the draft is created. If you leave this processing option blank, the program uses the current system date. |
|
2. City of Origin |
Specify the city of origin of the draft. The system prints the city name on the draft. If you leave this processing option blank, no city of origin appears on the draft. |
|
3. Clause |
Use this processing option to enter a plain text clause. If you leave this processing option blank, no clause appears on the draft. |
Process
|
1. Address Number |
Specify the address number that the system uses to determine where the draft is sent. Values are: Blank: Use the customer number (AN8). 1: Use the payor number (PYR). If you grouped invoices by customer when you ran the Invoice Group by Draft program (R03B5052), you should leave this processing option blank. If the Invoice Group by Draft program grouped invoices by payor, you should set the value of this processing option to 1. If you ran the Invoice Group by Draft program in detail mode, you can set the value of this processing option to either blank or 1. |
Reprinting Drafts for Spain
This section provides an overview of draft reprinting, lists prerequisites, and discusses how to:
Reprint drafts by receipt with letters.
Set processing options for Print Draft (R1) by Receipt with Letter (R74S520).
Reprint drafts by receipt.
Set processing options for Print Draft (R1) by Receipt (R74S521).
Reprint drafts based on stamp fees.
Set processing options for Print Drafts from R1 by Efecto (R74S522).
Understanding Draft Reprinting
After you have originated drafts and printed them with either the Print Receipt with Letter program (R74S500) or the Print Drafts from Invoices program (R74S502), you can reprint drafts using these programs:
Print Draft (R1) by Receipt with Letter (R74S520).
Print Draft (R1) by Receipt (R74S521).
Print Draft from R1 by Efecto (R74S522).
These programs print drafts based on existing draft (R1) documents. The first two programs do not group drafts according to their stamp fees, whereas Print Draft from R1 by Efecto does.
Print Drafts (R1) by Receipt with Letter
The Print Drafts (R1) by Receipt with Letter program (R74S520) prints duplicate copies of drafts (R1 documents) that were generated by the Print Receipt with Letter program (R74S500), but that have not been voided or collected.
Similar to the Print Draft (R1) by Receipt with Letter program (R74S520), the Print Drafts (R1) by Receipt program (R74S521) prints duplicate copies of drafts (R1 documents) that were generated by the Print Receipt with Letter program (R74S500), but that have not been voided or collected. However, the Print Drafts (R1) by Receipt program prints only the receipt format; it does not print the associated letter.
The Print Draft from R1 by Efecto program (R74S522) prints drafts for existing draft documents from the Receipts Header table (F03B13) and the Receipts Detail table (F03B14). You can also use this program to print duplicate copies of drafts that were generated by the Print Drafts from Invoices program (R74S502).
The Print Draft from R1 by Efecto program prints drafts that are based on the stamp fees for the drafts. The total amount of each draft determines the amount of the stamp that is required on the draft.
The system retrieves fee amounts from these tables:
Stamps (Timbres) Fee Detail (F74S502)
Stamps (Timbres) Fee Header (F74S505)
If the system cannot find a fee that corresponds to the draft amount, it sends an error message to the work center and does not print the draft.
The Print Draft from R1 by Efecto program produces one printer spool file for each fee amount. All of the drafts that have the same fee amount are included in one printer spool file. This grouping enables you to load the paper with the appropriate stamp for each group of drafts.
Prerequisites
Before you complete the tasks in this section:
Group invoices using the Invoice Group by Draft program (R03B5052).
Print drafts using the Print Receipt with Letter program (R74S500).
Reprinting Drafts by Receipt with Letters
Select Spanish Draft Processing (G74S03B161), Print Draft (R1) by Receipt with Letter.
Setting Processing Options for Print Draft (R1) by Receipt with Letter (R74S520)
Processing options enable you to specify the default processing for programs and reports.
Defaults
|
1. Emission Village |
Specify the city of origin of the draft. The system prints the city name that you enter here on the draft. If you leave this processing option blank, no city of origin appears on the draft. |
|
1. Print Tax Amount |
Specify whether you want the system to print tax amounts on the letter. Values are: Blank: Do not print tax amounts. 1: Print tax amounts. |
|
2. Print Currency |
Specify whether the system prints the invoice currency code and currency amounts on the draft and the letter. Values are: Blank: Do not print currency information. 1: Print currency information. If you enter 1, the system prints foreign invoices with foreign amounts. If currency processing is not enabled, the system prints invoices with domestic amounts. |
|
3. Print Attachments |
Use this processing option to indicate whether you want the system to print attachments associated with an invoice on the letter. Values are: Blank: Do not print associated attachments. 1: Print associated attachments. |
Reprinting Drafts by Receipt
Select Spanish Draft Processing (G74S03B161), Print Draft (R1) by Receipt.
Setting Processing Options for Print Draft (R1) by Receipt (R74S521)
Processing options enable you to specify the default processing for programs and reports.
Defaults
|
1. Emission Village |
Specify the city of origin of the draft. The system prints the city name that you enter here on the draft. If you leave this processing option blank, no city of origin appears on the draft. |
|
1. Print Currency |
Specify whether to print the invoice currency code and currency amounts on the draft and the letter. Values are: Blank: Do not print currency information. 1: Print currency information. If you enter 1, the system prints foreign invoices with foreign amounts. If currency processing is not enabled, the system prints invoices with domestic amounts. |
Reprinting Drafts based on Stamp Fees
Select Spanish Draft Processing (G74S03B161), Print Draft from R1 by Efecto.
Setting Processing Options for Print Drafts from R1 by Efecto (R74S522)
Processing options enable you to specify the default processing for programs and reports.
Defaults
|
1. City of Origin |
Specify the city of the origin of the draft. The system prints the city name that you enter here on the draft. If you leave this processing option blank, no city of origin appears on the draft. |
|
2. Clause |
Use this processing option to enter a plain text clause. If you leave this processing option blank, no clause appears on the draft. |
Process
|
1. Address Number |
Specify the address number that the system uses to determine where the draft is sent. Values are: Blank: Use the customer number (AN8). 1: Use the payor number (PYR). If the Invoice Group by Draft program (R03B5052) grouped invoices by customer, you should leave this processing option blank. If the Invoice Group by Draft program grouped invoices by payor, you should set the value of this processing option to 1. If the Invoice Group by Draft program grouped invoices in detail mode, you can set the value of this processing option to either blank or 1. |
Entering A.E.B. Customer and Supplier Bank Information for Spain
This section provides an overview of A.E.B. bank account information, lists a prerequisite, and discusses how to:
Enter A.E.B. bank account information.
Upload A.E.B. bank account information.
Understanding A.E.B Bank Account Information
The Spanish Bank Authority (A.E.B.) provides valid bank account information including the bank code, office code, control digit, and sort number. The system uses this bank information when printing the draft formats for draft remittance and during automatic payment processing. You must enter this bank information in the A.E.B. Bank - Spain table (F74SCSB) to validate the bank account information for your Spanish customers and suppliers. You can enter the bank information manually or upload the bank information that is provided by the A.E.B. directly to the F74SCSB table.
The system uses the information in the Bank Code and Office Code fields of the F74SCSB table to validate bank account numbers. The Bank Code and Office Code in the F74SCSB table are used to validate the Bank Transit Number in the Bank Account Cross-Reference program (P0030A) or the Bank Account Information program (P0030G). The system validates the first four digits of the Bank Transit Number against the Bank Code, and the second four digits against the Office Code.
Prerequisite
Create an address book record for each bank, ensuring that both the name of the bank and the name of the local office are entered in the Alpha Name field.
See Entering Address Book Records.
Form Used to Enter A.E.B. Bank Account Information
|
Form Name |
FormID |
Navigation |
Usage |
|
Bank Revision (A.E.B.) |
W74SCSBB |
Accounts Payable - Spain (G74S04), AEB Bank Revisions - Spain On the Work With Banks (A.E.B.) form, click Add. |
Enter A.E.B. bank account information. |
Entering A.E.B. Bank Account Information
Access the Bank Revision (A.E.B.) form.
|
Bank Code |
Enter a valid four-digit code assigned by the A.E.B. |
|
Office Code |
Enter a valid four-digit code assigned by the A.E.B. |
|
Control Digit |
Enter the control digit. This digit is a value generated by the A.E.B. using both the bank code and the office code. The bank or the A.E.B. must supply this number. |
|
Sort Number |
Enter a four-digit code that is assigned by the A.E.B. This code is used to sort the information for a specific Bank Number and Office Number. |
|
Business Site Code |
Enter a code that identifies the business site where the office is located. The code that you assign usually matches the city, but such a match is not strictly necessary. |
|
Bank Name |
Enter the name of the bank. This must be the proper name used by the bank in business. |
|
Office Name |
Enter the commercial name of the bank office. This is the name used in inquires or to look for a special commercial office of a bank. |
|
Office Address |
Enter the complete address of a particular commercial office of a bank. This is the suitable address to contact this office with any inquiry. |
|
City in Castilian |
Enter the Castilian proper name of the city where the office is located. |
|
Zip |
Enter the zip code of the bank office. |
|
City Other Lang. (city other language) |
Enter the proper name of the city where the office is located, as the region commonly uses it. |
|
OT (office type) |
Enter the type of the bank office, according to the A.E.B. criteria. |
|
Phone Number |
Enter the phone number of the bank office. |
|
Telex Number |
Enter the Telex number of the bank office, if available. |
Uploading A.E.B. Bank Information
To upload bank information provided by the A.E.B. directly to the A.E.B. Bank - Spain table (F74SCSB), you import the A.E.B. bank information file into the Text Processor Detail Table (F007111) using the Text File Processor program (P007101). When you import a file into the F007111 table, the system stores the contents of the imported file in the Text field (GPTX) of the F007111 table. Because the A.E.B. bank information file has no common format, you must create a custom batch program or table conversion to parse the value in the Text field (GPTX) of the F007111 table to correspond to the fields in the F74SCSB table and to update the parsed values to the F74SCSB table.
This table lists the fields in the F74SCSB table. You can use this information when creating a custom batch program or table conversion to parse the value in the Text field (GPTX) of the Text Processor Detail Table (F007111).
|
Alias |
Description |
Length |
|
SBCO |
Bank Code |
4 |
|
SOCO |
Office Code |
4 |
|
SSNU |
Sort |
4 |
|
SBNA |
Bank Name |
36 |
|
SONA |
Office Name |
36 |
|
SOAD |
Office Address |
40 |
|
SCDI |
Control Digit |
1 |
|
SFI1 |
Filler One |
1 |
|
SCNC |
City Name in Castilian |
40 |
|
SCNL |
City Name in Other Language |
40 |
|
SOFT |
Office Type |
1 |
|
SBSI |
Business Site Code |
9 |
|
SACO |
Area Code |
3 |
|
SPNU |
Phone Number |
7 |
|
SENU |
Extension Number |
7 |
|
STNU |
Telex Number |
7 |
|
SZCO |
Zip Code |
5 |
|
SFI2 |
Filler Two |
17 |
See Also
Working with the Text File Processor
Generating Financial Statement Reports for Spain
This section provides an overview of financial statement reports, lists a prerequisite, and discusses how to:
Run the Generate Financial Report program.
Set processing options for Generate Financial Report (R749110).
Understanding Financial Statement Reports
Use the Generate Financial Report program (R749110) to print profit and loss, balance sheet, and other financial statement reports for Spain. You use the Financial Report Setup (P749101) and Financial Report Account Setup (R749102) programs to identify the layout of the report and the accounts to include, and then use the Generate Financial Report program to print the reports that you set up.
Prerequisite
Before you complete the tasks in this section, set up layouts for financial statement reports.
See (ESP, CZE and HUN) Setting Up Accounts and Layouts for Financial Statement Reports.
Running the Generate Financial Report Program
Select Financial Reports (G7410), Generate Financial Report.
Setting Processing Options for Generate Financial Report (R749110)
Processing options enable you to set default processing values.
Period
|
1. Fiscal Year |
Specify the last two digits of the fiscal year for which the trial balance will be printed. For example, enter 07 for 2007. If you complete this processing option, you must also specify the ending period number in the Period Number processing option. If you leave this processing option blank, the program uses the fiscal year. |
|
2. Period Number - General Ledger |
Enter the period for which the trial balance will be printed. If you complete this processing option, you must also specify the fiscal year for the ending period in the Fiscal Year processing option. If you leave this processing option blank, the program uses the current period. |
|
3. Company |
Enter the company for which you process records. |
|
4. Account Number Format |
Specify the format for printed account numbers. Values are: 1 or blank: Standard account number (The default is business unit.object.subsidiary) 2: Short account ID (The system assigns) 3: Third G/L number (Your organization can assign during account setup) |
|
5. Accounts with Zero Balances |
Specify whether the system includes or omits accounts with zero balances for the specified period. Values are: Blank: Include accounts with zero balances. 1: Omit accounts with zero balances. Note. Accounts that are assigned a posting edit code of N print even when you set this processing option to 1. Accounts that are assigned a posting edit code of N are header accounts, which do not have balances. |
|
6. Show Account Detail |
Enter 1 to show account detail. Leave this processing option blank to suppress printing of account details. |
|
7. Scale Factor |
Enter a value that exists in the Scale Factor (74/SF) UDC table to specify the factor by which the system divides the value. |
Cost Center / Subledger
|
7. Cost Center Group |
Enter a value to override the cost center group definition in the report setup. The cost center group represents a subset of cost centers. Financial reports use the cost center group to filter the accounts that belong to the specified cost center. |
|
8. Subledger - G/L |
Specify whether to print amounts for accounts with subledgers. Enter a specific subledger number to use that ledger. Enter * to include all subledgers. Leave this processing option blank to include only accounts without subledgers. If you complete this processing option, you must also complete the Subledger Type processing option. |
|
9. Subledger Type |
Enter a value that exists in the Subledger Type (00/ST) UDC table to specify the table containing the subledger numbers. For example, subledger type A identifies the Address Book Master table (F0101). If you complete this processing option, you must also complete the Subledger - G/L processing option. |
Currency Code
|
10. Currency Code - From |
Specify the currencies that the system includes in the report when you post account balances by currency. To limit the report to amounts for a specific currency code, enter the code for the currency. The value that you enter must exist in the Currency Codes table (F0013). To include amounts for all currencies, enter * (asterisk). Leave this processing option blank if you do not post balances by currency. Note. If you specify the CA ledger type in the Ledger Type processing option, and the CA ledger type includes amounts for multiple currencies, the totals will be meaningless unless you enter a specific currency code for this processing option. |
Ledger
|
11. Ledger Types |
Enter a value that exists in the Ledger Types (09/LT) UDC table. You can specify up to four ledger types. |
Layout
|
12. Report Name |
Enter a report name that you set up in the Financial Report Setup program (P749101). The system uses this value to determine the report specifications. |
|
13. Report Layout |
Enter a value that exists in the Reports Layout (74/RL) UDC table to specify whether the report is generated in landscape or portrait mode. |
|
14. Version |
Enter the version of the program that is specified in the Report Layout processing option. |
|
15. Title Line 1 |
Enter the text that the system prints for the first line of the report title. If you leave this processing option blank, the system does not print a title. |
|
16. Title Line 2 |
Enter the text that the system prints for the second line of the report title. If you leave this processing option blank, the system does not print a second line. |
Process
|
17. Reuse Last Account Definition |
Enter 1 to reuse the account structure that was created by the last run. You can reuse the account structure only when recalculating or reprinting. If you enter 1 but have changed the report template or account structure, your system might generate invalid data. |
|
18. Clear Work Files |
Enter 1 to clear the work files. Oracle recommends that you clear the work files only when required, such as when the Work Center generates a message that you must do so. |