This appendix contains the following topics:
This section provides information about record type 1 (A). Record type 1 (A) is header information.
Record Name | Source of Data | Position in File |
---|---|---|
Record type | Hard-coded value of 1. | 1 |
Model | Hard-coded value of 340. | 2–4 |
Exercise | The value from the Declaration Year processing option. | 5–8 |
Declarant NIF | The tax ID number from the company's address book record. | 9–17 |
Declarant name and surname or social reason | The company name as stored in the Company Constants table (F0010). | 18–57 |
Support type | The value from the Media Type processing option. | 58 |
Contact name—telephone number | The telephone number of the contact person. You set a processing option to specify the line number of the Who's Who record to use for contact information. | 59–67 |
Contact name—name and surname | The name of the contact person. You use a processing option to specify the line number of the Who's Who record to use for contact information.
The name of the contact person must be set up as the mailing name in the Who's Who record. |
68–107 |
Declaration justification number | The value for 340EEEEPPSSSS where EEEE is the year specified in the processing options; PP is the period specified in the processing option; and SSSS is the consecutive sequence number specified in the processing option. | 108–120 |
Complementary declaration | The value C if you specify enter C in the Declaration Type processing option. If you do not specify C, then this field is blank. | 121 |
Substitutive declaration | The value S if you specify enter S in the Declaration Type processing option. If you do not specify S, then this field is blank. | 122 |
Previous declaration number | The value from the Enter previous Declaration Number processing option. | 123–125 |
Period | The value that corresponds to the code that you enter in the Enter the Declaration Period processing option. | 136–137 |
Total number of records | The system totals the number of type 2 records and inserts the number in this position. | 138–146 |
Taxable total amount—sign | The sign (plus or minus) for the value written to positions 138–146 of the flat file for Record Type 1. | 147 |
Taxable total amount | The sum of the amounts from positions 122–135 from the Record Type 2 flat file. | 148–164 |
Tax amount total – sign | The sign (plus or minus) for the value written to positions 166–182 of the flat file for Record Type 1. Values are:
|
165 |
Tax amount – amount | The sum of the amounts from positions 136–149 from the Record Type 2 flat file. | 166–182 |
Gross amount total – sign | The sign (plus or minus) for the value written to positions 184–200 of the flat file for Record Type 1. Values are:
|
183 |
Gross amount total – amount | The sum of the amounts from positions 150–163 from the Record Type 2 flat file. | 184–200 |
Blank | Blank | 201–390 |
Declarant legal representative NIF | The NIF of the legal representative specified for the company in the Address Book - Additional Information program (P74S101). | 391–399 |
IVA electronic code | The value from the VAT Electronic Code processing option. | 400–415 |
XXXXX
These positions are not currently used. |
Blank | 416–500 |
This section provides information about emitted (sent) invoices for your sales and accounts receivable transactions.
The system retrieves the tax amounts corresponding to VAT from the Tax Amount 1 (STA1) field in the Taxes table (F0018) and retrieves the tax amounts corresponding to VAT surcharge from the Tax Amount 2 (STA2) in the F0018 table.
Record Name | Source of Data | Position in File |
---|---|---|
Record type | Hard-coded value of 1. | 1 |
Model | Hard-coded value of 340. | 2–4 |
Exercise | The value from the Declaration Year processing option. | 5–8 |
Declarant NIF | The tax ID number from the company's address book record. | 9–17 |
Declared NIF | If the residence country identification key field (position 78) is equal to 1, the NIF (Tax ID) from the address book record of the customer. If the value in position 78 is not 1, then positions 18–26 are blank. | 18–26 |
Legal representative NIF | If declared customer is a minor (the value in S740115.F74S101 is equal to 1), then the NIF of legal representative of the declared customer. If the value of S740115.F74S101 is not equal to 1, then positions 27–35 are blank. | 27–35 |
Declared name and surname or social reason | The mailing name of the customer as stored in the address book records for the customer. | 36–75 |
Country code | The country code of the customer. The system uses the country code in the customer's address book record to retrieve the country code from the Tax ID Validation (70/TI) UDC table. If the country code in the address book record is blank, the system writes ES (Spain) for this value. | 76–77 |
Residence country identification key | The code that represents the documentation used to verify the country of residence. You assign a code to an address book record in the Address Book - Additional Information - ESP program (P74S101). | 78 |
Fiscal identification number is residence country—Country code | If the Residence country identification key field (position 78) is not equal to 1, then the first two characters from the value in the Additional Tax ID field (data item TX2) for the address book record for the declared customer.
If the value in position 78 is equal to 1, then positions 79–80 are blank. |
79–80 |
Fiscal identification number is residence country—Number | If the Residence country identification key field (position 78) is not equal to 1, then characters 3–17 from the value in the Additional Tax ID field (data item TX2) for the address book record for the customer.
If the value in position 78 is equal to 1, then positions 81–95 are blank. |
81–95 |
Blanks | Blank | 96–98 |
Book type key | A code for the type of records included in the file. Possible values for record type 2 (B.1) are:
|
99 |
Operation type | The value from the 74S/RL UDC table that corresponds to the document type of the emitted invoice or from 74S/RT UDC that corresponds the tax area. The system determines the operation type as:
If the document type is R (Lease of Business Premises), the system completes the Location of the Building field and the Cadastral Reference field. The system calculates the value for the Lease of Business Premises field based on the Country Code, Government Reference Number (F74S74.SGRE), and Province Code. Possible values are: 1: Building with cadastral reference located on the Spanish Territory (Except Pais Vasco and Navarra). 2: Building with cadastral reference located in the Pais Vasco or Navarra (if Province Code is 1, 20, 21, or 48). 3: Building located in 1 or 2 but without a cadastral reference. 4: Building located in a foreign country. The system obtains the value for the Cadastral Reference field from Government Reference Number (F74S74.SGRE). |
100 |
Expedition date—year | The year of the emitted invoice. The system determines the expedition date as:
|
101–104 |
Expedition date—month | The month of the emitted invoice. The system determines the expedition date as:
|
105–106 |
Expedition date—day | The day of the emitted invoice. The system determines the expedition date as:
|
107–108 |
Operation date—year | The year of the service. The system determines the year of the service as:
|
109–112 |
Operation date—month | Month of the service. The system determines the month of the service as:
|
113–114 |
Operation date—day | Day of the service. The system determines the day of the service as:
|
115–116 |
Tax type—integer | The integer portion of the tax rate. If the transaction is a reverse charge intracommunity transaction and it is not a special intracommunity transaction as specified in the F74S408 table, then the system determines the integer portion of the tax rate as:
If the transaction is not a reverse charge intracommunity transaction or it is a special intracommunity transaction as specified in the F74S408 table, then the system determines the integer portion of the tax rate as:
The system uses Tax Rate 1 as the integer portion of the tax rate if the transaction is not an intracommunity transaction. |
117–119 |
Tax type—decimal | The characters after the decimal point in the tax rate.
The system identifies the decimal portion of the tax type in the same manner as it determines the integer portion of the tax type. |
120–121 |
Taxable base—sign | If the value written to positions 123–135 of the flat file for Record Type 2 (B.1) is negative, then the system writes N to this position. Otherwise the position is blank. | 122 |
Taxable base—integer | The integer portion of the sum of taxable amount (ATXA.F0018) and nontaxable amount (ATXN.F0018). | 123–133 |
Taxable base—decimal | The characters after the decimal point in the sum of taxable amount (ATXA.F0018) and nontaxable amount (ATXN.F0018). | 134–135 |
Tax quota—sign | If the value written to positions 137–139 of the flat file for Record Type 2 (B.1) is negative, then the system writes N to this position. Otherwise the position is blank. | 136 |
Tax quota—integer | The integer portion of the total tax amount. If the transaction is a reverse charge intracommunity transaction and it is not a special intracommunity transaction as specified in the F74S408 table, then the system determines the integer portion of the tax amount as:
If the transaction is not a reverse charge intracommunity transaction or it is a special intracommunity transaction as specified in the F74S408 table, then the system determines the integer portion of the tax amount as:
The system uses the Sales Tax Authority 1 as the integer portion of the tax amount if the transaction is not an intracommunity transaction. |
137–147 |
Tax quota—decimal | The decimal portion of the total tax amount.
The system identifies the decimal portion of the tax amount in the same manner as it determines the integer portion of the tax amount. |
148–149 |
Invoice amount total—sign | If the value written to positions 151–161 of the flat file for Record Type 2 (B.1) is negative, then the system writes N to this position. Otherwise the position is blank. | 150 |
Invoice amount total—integer | The integer part for the invoice amount. The system calculates the invoice amount from the sum of the taxable base (positions 122-135), tax quota (positions 136 – 149), and surcharge of equivalence (positions 371-384). | 151–161 |
Invoice amount total—decimal | The characters after the decimal point for the invoice amount. The system calculates the invoice amount from the sum of taxable base (positions 122-135), tax quota (positions 136 – 149), and surcharge of equivalence (positions 371-384). | 162–163 |
Cost taxable base—sign | The JD Edwards EnterpriseOne system does not supply this value. The system leaves this position blank. | 164 |
Cost Taxable Base - Integer | The JD Edwards EnterpriseOne system does not supply this value. The system completes these positions with 0 (zeros). | 165–175 |
Cost Taxable Base - Decimal | The JD Edwards EnterpriseOne system does not supply this value. The system completes these positions with 0 (zeros). | 176–177 |
Invoice identification | The invoice identification number. The system determines the invoice identification as:
|
178–217 |
Record Number | The number of the record.
The system uses the value that you specify in the processing options as the number for the first record, and increments the number by one for each subsequent record. |
218–235 |
Number of Invoices | The JD Edwards EnterpriseOne system does not supply this value. The system completes these positions with 0 (zeros). | 236–243 |
Record Number (breakdown) | If the operation type is C, the system completes these positions with the record number. If the operation type is not equal to C then the system writes 01 to these positions. | 244–245 |
Accumulation Range - First Number | The JD Edwards EnterpriseOne system does not supply this value. The system leaves these positions blank. | 246–285 |
Accumulation Range - Last Number | The JD Edwards EnterpriseOne system does not supply this value. The system leaves these positions blank. | 286–325 |
Rectified invoice identification | If the operation type of the invoice is D, then assign the invoice or substitution (replacement) document number being rectified.
This field is optional and the system uses it only when the information exists in the F03B11 table. |
326–365 |
Surcharge of Equivalence Type - Integer | If the transaction is an intracommunity transaction or a reverse charge, then this field is completed with zeroes, else it is completed with the integer portion of the Tax Rate 2 (TXR2.F0018). | 366–368 |
Surcharge of Equivalence Type - Decimal | If the transaction is an intracommunity transaction or a reverse charge, then this field is completed with zeroes, else it is completed with the decimal portion of the Tax Rate 2 (TXR2.F0018). | 369–370 |
Surcharge of Equivalence quota - Sign | If the value written to positions 366–370 of the flat file for Record Type 2 (B.1) is negative, then the system writes N to this position. Otherwise the position is blank. | 371 |
Surcharge of Equivalence quota - Integer | If the transaction is an intracommunity transaction or a reverse charge, then this field is completed with zeroes, else it is completed with the integer portion of the Amount - Sales Tax Authority 2 (STA2.F0018). | 372–382 |
Surcharge of Equivalence quota - Decimal | If the transaction is an intracommunity transaction or a reverse charge, then this field is completed with zeroes, else it is completed with the decimal portion of the Amount - Sales Tax Authority 2 (STA2.F0018). | 382–384 |
XXXXX
These positions are not currently used. |
Blanks | 385–500 |
This section provides information about your received invoices for purchase and accounts payable transactions.
The tax amounts corresponding to VAT are retrieved from the Tax Amount 1 (STA1) and Tax Amount 2 (STA2) fields. The non-recoverable tax and the tax amounts corresponding to deductible tax are also retrieved from Tax Amount 1 (STA1) and Tax Amount 2 (STA2) fields in the Taxes table (F0018).
Record Name | Source of Data | Position in File |
---|---|---|
Record type | Hard-coded value of 2. | 1 |
Model | Hard-coded value of 340. | 2–4 |
Exercise | The value from the Declaration Year processing option. | 5–8 |
Declarant NIF | The tax ID number from the company's address book record. | 9–17 |
Declared NIF | The NIF of the supplier, from the supplier's address book record. | 18–26 |
Legal representative NIF | If declared supplier is a minor (the value in S740115.F74S101 is equal to 1), then the NIF of legal representative of the declared supplier. If the value of S740115.F74S101 is not equal to 1, then positions 27–35 are blank. | 27–35 |
Declared name and surname or social reason | The mailing name of the supplier as stored in the address book records for the customer. | 36–75 |
Country code | The country code of the supplier. The system uses the country code in the supplier's address book record to retrieve the country code from the Tax ID Validation (70/TI) UDC table. If the country code in the address book record is blank, the system writes ES (Spain) for this value. | 76–77 |
Residence country identification key | The code that represents the documentation used to verify the country of residence. You assign a code to an address book record in the Address Book - Additional Information - ESP program (P74S101). | 78 |
Fiscal identification number is residence country—Country code | The first two characters from the value in the Additional Tax ID field (data item TX2) for the address book record for the supplier. The system uses the first two characters from the value in the Additional Tax ID field if the residence country identification key field is not equal to 1, else blank is used. | 79–80 |
Fiscal identification number is residence country—Number | Characters 3–17 from the value in the Additional Tax ID field (data item TX2) for the address book record for the supplier. The system uses the characters 3–17 from the value in the Additional Tax ID field if the residence country identification key field is not equal to 1, else blank is used. | 81–95 |
Blanks | Blank | 96–98 |
Book type key | A code for the type of records included in the file. Possible values for record type 2 (B.2) are:
|
99 |
Operation type | The value from the 74S/RL UDC table that corresponds to the document type of the received invoice or from 74S/RT UDC that corresponds the tax area. The system determines the operation type as:
|
100 |
Expedition date—year | The year of the received invoice. The system writes the expedition date as:
|
101–104 |
Expedition date—month | The month of the received invoice. The system determines the expedition date as:
|
105–106 |
Expedition date—day | The day of the received invoice. The system determines the expedition date as:
|
107–108 |
Operation date—year | The year of the service. The system determines the year of the service as:
|
109–112 |
Operation date—month | Month of the service. The system determines the month of the service as:
|
113–114 |
Operation date—day | Day of the service. The system determines the day of the service as:
|
115–116 |
Tax type—integer | The integer portion of the tax rate. If the transaction is reverse charge intracommunity transaction and it is not a special intracommunity transaction (F74S408), then the system determines the integer portion of the tax rate as:
If a transaction is not a reverse intracommunity transaction or it is a special intracommunity transaction as specified in the F74S408 table, then the system determines the integer portion of the tax rate as:
The system uses the integer portion of the sum of the Tax Rate 1 and Tax Rate 2 if the transaction is not an intracommunity transaction. |
117–119 |
Tax type—decimal | The characters after the decimal point in the tax rate.
The system identifies the decimal portion of the tax type in the same manner as it determines the integer portion of the tax type. |
120–121 |
Taxable base—sign | If the value written to positions 123–135 of the flat file for Record Type 2 (B.2) is negative, then the system writes N to this position. Otherwise the position is blank. | 122 |
Taxable base—integer | The integer portion of the sum of the taxable amount (ATXA.F0018) and nontaxable amount (ATXN.F0018). | 123–133 |
Taxable base—decimal | The characters after the decimal point in the sum of the taxable amount (ATXA.F0018) and nontaxable amount (ATXN.F0018). | 134–135 |
Tax quota—sign | If the value written to positions 137–139 of the flat file for Record Type 2 (B.2) is negative, then the system writes N to this position. Otherwise the position is blank. | 136 |
Tax quota—integer | The integer portion of the total tax amount. If the transaction is reverse charge intracommunity transaction and it is not a special intracommunity transaction as specified in the F74S408 table, then the system determines the integer portion of the tax amount as:
If a transaction is not a reverse intracommunity transaction or it is a special intracommunity transaction in the F74S408 table, then the system determines the integer portion of the tax amount as:
The system uses the integer portion of the sum of the Sales Tax Authority 1 and Sales Tax Authority 2 if the transaction is not an intracommunity transaction. |
137–147 |
Tax quota—decimal | The decimal portion of the total tax amount.
The system identifies the decimal portion of the tax amount in the same manner as it determines the integer portion of the tax amount. |
148–149 |
Invoice amount total—sign | If the value written to positions 151–161 of the flat file for Record Type 2 (B.2) is negative, then the system writes N to this position. Otherwise the position is blank. | 150 |
Invoice amount total—integer | The integer portion of the invoice amount (data item AEXP). The system calculates the invoice amount from the sum of the taxable base (positions 122-135), tax quota (positions 136 – 149), and surcharge of equivalence (positions 371-384). | 151–161 |
Invoice amount total—decimal | The characters after the decimal point for the invoice amount. The system calculates the invoice amount from the sum of the taxable base (positions 122-135), tax quota (positions 136 – 149), and surcharge of equivalence (positions 371-384). | 162–163 |
Cost taxable base—sign | The JD Edwards EnterpriseOne system does not supply this value. The system leaves this position blank. | 164 |
Cost Taxable Base - Integer | The JD Edwards EnterpriseOne system does not supply this value. The system completes these positions with 0 (zeros). | 165–175 |
Cost Taxable Base - Decimal | The JD Edwards EnterpriseOne system does not supply this value. The system completes these positions with 0 (zeros). | 176–177 |
Invoice identification | The invoice number. The system determines the invoice identification as:
|
178–217 |
Record Number | The number of the record.
The system uses the value that you specify in the processing options as the number for the first record, and increments the number by one for each subsequent record. |
218–235 |
Number of Invoices | The JD Edwards EnterpriseOne system does not supply this value. The system completes these positions with 0 (zeros). | 236–253 |
Record Number (breakdown) | If the operation type is C, the system completes these positions with the record number. If the operation type is not equal to C then the system writes 01 to these positions. | 254–255 |
Accumulation Range - First Number | The JD Edwards EnterpriseOne system does not supply this value. The system leaves these positions blank. | 256–295 |
Accumulation Range - Last Number | The JD Edwards EnterpriseOne system does not supply this value. The system leaves these positions blank. | 296–335 |
Deducible quota - Sign | If the value written to positions 337–347 of the flat file for Record Type 2 (B.2) is negative, then the system writes N to this position. Otherwise the position is blank. | 336 |
Deducible quota - Integer | If the transaction is an intracommunity transaction or reverse charge, then this field is completed with zeroes, else it is completed with the integer portion of the total of the Amount - Sales Tax Authority 1 (STA1.F0018) and Amount - Sales Tax Authority 2 (STA2.F0018).
For suspended VAT transactions, this field represents the amount of tax reclassified in the period. |
337–347 |
Deducible quota - Decimal | If the transaction is an intracommunity transaction or reverse charge, then this field is completed with zeroes, else it is completed with the decimal portion of the total of the Amount - Sales Tax Authority 1 (STA1.F0018) and Amount - Sales Tax Authority 2 (STA2.F0018). | 348–349 |
Payment Date - Integer (Release 9.1 Update) | If the transaction is VAT suspended and is reclassified in the selected period, the system completes this value with reclassification date in F704200, otherwise the system completes these positions with 0 (zeros). | 350-357 |
Amount Paid - Decimal (Release 9.1 Update) | Reclassification amount in F704200, if the value written to position 100 of the flat file for Record Type 2 (B.2) - Received Invoices is Z.
If the value written to position 100 of the flat file for Record Type 2 (B.2) - Received Invoices is not Z, the system completes these positions with 0 (zeros). |
358-370 |
Payment Method- Alphanumeric (Release 9.1 Update) | The value from the 74S/PM UDC table that corresponds to the payment instrument.
If the payment instrument is not set up in the 74S/PM UDC table, the system assigns value of C in this position. If the operation is not VAT suspended or is not reclassified in the specified period, the system completes this position with blanks. |
371 |
First position of Bank Account or Payment Method (Release 9.1 Update) | If the value written to position 371 of the flat file for Record Type 2 (B.2) - Received Invoices is C, get GLBA.F0413=AID.F0030. Then, if there is a corresponding value, get CBNK.F0030 corresponding to this value; else, get IBAN.F0030.
Document Method (DOCM.F0413), if the value written to position 371 of the flat file for Record Type 2 (B.2) - Received Invoices is O or T. If the transaction is not VAT suspended or is not reclassified in the specified period, the system leaves these positions blank (no zero). |
372-405 |
XXXXXXX
These positions are not currently used. |
Blanks | 405–500 |
The tax amounts corresponding to VAT are retrieved from the Tax Amount 2 (STA2) field if the Tax Rate line number for Intra-Community Vat processing option is blank. Otherwise, the system retrieves the tax amounts from Tax Amount 3 (STA3) in the F0018 table.
Record Name | Source of Data | Position in File |
---|---|---|
Record type | Hard-coded value of 2. | 1 |
Model | Hard-coded value of 340. | 2–4 |
Exercise | The value from the Declaration Year processing option. | 5–8 |
Declarant NIF | The tax ID number from the company's address book record. | 9–17 |
Declared NIF | The NIF of the customer or supplier, from the address book record. | 18–26 |
Legal representative NIF | The NIF of the legal representative of the customer or supplier's company, as set up in the Address Book - Additional Information program (P74S101). | 27–35 |
Declared name and surname or social reason | The mailing name of the customer or supplier as stored in the address book records. | 36–75 |
Country code | The country code of the customer or supplier. The system uses the country code in the address book record to retrieve the country code from the Tax ID Validation (70/TI) UDC table. If the country code in the address book record is blank, the system writes ES (Spain) for this value. | 76–77 |
Residence country identification key | The code that represents the documentation used to verify the country of residence. You assign a code to an address book record in the Address Book - Additional Information - ESP program (P74S101). | 78 |
Fiscal identification number is residence country—Country code | The first two characters from the value in the Additional Tax ID field (data item TX2) for the address book record for the customer or supplier. | 79–80 |
Fiscal identification number is residence country—Number | Characters 3–17 from the value in the Additional Tax ID field (data item TX2) for the address book record for the supplier. | 81–95 |
Blanks | Blank | 96–98 |
Book type key | The system completes this field with U, which is the code for the book of intracommunity operations. | 99 |
Operation type | The value from the Relation DCT/Operation Type (74S/RL) UDC table that corresponds to the document type of the received invoice. If the document type is not set up in the 74S/RL UDC table, the system leaves this position blank. | 100 |
Expedition date—year | The year of the received invoice. | 101–104 |
Expedition date—month | The month of the received invoice. | 105–106 |
Expedition date—day | The day of the received invoice. | 107–108 |
Operation date—year | The year of the service. | 109–112 |
Operation date—month | Month of the service. | 113–114 |
Operation date—day | Day of the service. | 115–116 |
Tax type—integer | The integer portion of the tax rate. | 117–119 |
Tax type—decimal | The characters after the decimal point in the tax rate. | 120–121 |
Taxable base—sign | If the value written to positions 123–135 of the flat file for Record Type 2 (B.3) is negative, then the system writes N to this position. Otherwise the position is blank. | 122 |
Taxable base—integer | The integer portion of the taxable amount from F0018.ATXA. | 123–133 |
Taxable base—decimal | The characters after the decimal point in the taxable base from F0018.ATXA. | 134–135 |
Tax quota—sign | If the value written to positions 137–139 of the flat file for Record Type 2 (B.2) is negative, then the system writes N to this position. Otherwise the position is blank. | 136 |
Tax quota—integer | The integer portion of the total tax amount from F0018.STA2 or F0018.STA3, according the value in the processing option. | 137–147 |
Tax quota—decimal | The decimal portion of the total tax amount from F0018.STA2 or F0018.STA3, according the value in the processing option. | 148–149 |
Invoice amount total—sign | If the value written to positions 151–161 of the flat file for Record Type 2 (B.3) is negative, then the system writes N to this position. Otherwise the position is blank. | 150 |
Invoice amount total—integer | The integer portion of the taxable base amount plus the tax quota amount from the invoice. | 151–161 |
Invoice amount total—decimal | The characters after the decimal point for the taxable base amount plus the tax quota amount from the invoice. | 162–163 |
Cost taxable base—sign | The JD Edwards EnterpriseOne system does not supply this value. The system leaves this position blank. | 164 |
Cost Taxable Base - Integer | The JD Edwards EnterpriseOne system does not supply this value. The system completes these positions with 0 (zeros). | 165–175 |
Cost Taxable Base - Decimal | The JD Edwards EnterpriseOne system does not supply this value. The system completes these positions with 0 (zeros). | 176–177 |
Invoice identification | The legal invoice number. | 178–217 |
Record Number | The number of the record.
The system uses the value that you specify in the processing options as the number for the first record, and increments the number by one for each subsequent record. |
218–235 |
Intracommunity Operation Type | The value from the Intra-community Operation Type (74S/OC) UDC table that you associated with the tax rate area. | 236 |
Declared Key | The value is D for emitted invoices with a batch type of IB, or R for received invoices with a batch type of V or W. | 237 |
Member state code | For emitted invoices with associated sales orders, the system uses the country code from the F0116 table for the ship-to address book record to obtain the country code from the 70/TI UDC table. Otherwise, the system uses the country code from the F0116 table for the address used in the F03B11 table to obtain the country code from the 70/TI UDC table. If the country code does not exist in the 70/TI UDC table, the system uses the country code from the ship-to address, or uses a default value of ES (Spain), if no country code exists in the ship-to address book record.
For received invoices, the system uses the country of origin from the F4102 table, or the address number from the F0411 table if the country of origin field is blank, to get the country code from the F0116 table. The system then obtain the country code from the 70/TI UDC table to write a value to the text file. If the country code in the F0116 table is blank, the system writes ES (Spain) to this field. |
238–239 |
Operation Duration | For emitted invoices with associated sales orders, the difference between the transaction date in the F4211 table and the service date in the F0018 table. Otherwise, the difference between the invoice date in the F03B11 table and the service date in the F0018 table.
For received invoices with associated purchase orders, the difference between the transaction date in the F43121 and the service date in the F0018 table. Otherwise, the difference between the invoice date in the F0411 table and the service date in the F0018 table. |
240–242 |
Description of goods | For emitted invoices with associated sales orders, the item description from the F4101 table. Otherwise, the remark from the F03B11 table.
For received invoices with associated purchase orders, the item description from the F4101 table. Otherwise, the remark from the F0411 table. |
243–277 |
Intracommunity Operator Address - Address | The value from ADD1.F0116 for the address book record of the intracommunity operator associated with the customer or supplier. If no intracommunity operator is set up in the Address Book - Additional Information - ESP program (P74S101), the system uses the address book record of the customer or supplier. | 278–317 |
Intracommunity Operator Address -City | The value from CTY1.F0116 for the address book record of the intracommunity operator associated with the customer or supplier. If no intracommunity operator is set up in the Address Book - Additional Information - ESP program, the system uses the address book record of the customer or supplier. | 318–339 |
Intracommunity Operator Address - Postal Code | The value from ADDZ.F0116 for the address book record of the intracommunity operator associated with the customer or supplier. If no intracommunity operator is set up in the Address Book - Additional Information - ESP program, the system uses the address book record of the customer or supplier. | 340–349 |
Other Invoices or documentation | The JD Edwards EnterpriseOne system does not provide a value for this field. These positions are left blank. | 350–484 |
XXXXXX
These positions are not currently used. |
Blanks | 485–500 |