1. Using Financials for EMEA
  2. Appendix 6 – Listing of Each Text Position in Open Format Files

Appendix 6 – Listing of Each Text Position in Open Format Files

This appendix provides the listing of each text position in Open Format files.

This table describes the detailed information provided in the fields of the open format files related to Documents code B100:

Documents Code Table Column Field Number in File Start Position Length Description
A100 95
Record Code A100_1100 1100 0 4 Hardcoded Value is A100
Future Use A100_1101 1101 4 9 Runtime Information, Free Text, No Validations
Tax identifier A100_1102 1102 13 9 Legal Entity Contact Persons: Last Name where first name = OM.
Reference Key A100_1103 1103 22 15 DB Sequence Value. Provides the Run Sequence. Last Run Number + 1. Same acriis.
Constant A100_1104 1104 37 8
Rasham Number (Future Use) A100_1105 1105 45 50 No Mapping in code. This report shows only blank spaces.

This table describes the detailed information provided in the fields of the open format files related to Documents code B100.

Documents Code Table Column Field Number in File Start Position Length Description
B100 317
Record Code B100_1350 1350 0 4 Hardcoded Value is B100
Future Use B100_1351 1351 4 9 Runtime Information, Free Text, No Validations
Registration Number (Tax Identifier) B100_1352 1352 13 9 Legal Entity Contact Persons: Last Name where first name = OM.
Journal Header ID B100_1353 1353 22 10 Journal Header ID
Journal Line Nunber B100_1354 1354 32 5 Journal Line Number
Batch ID B100_1355 1355 37 8 Journal Batch ID
JE Category (Transaction Type) B100_1356 1356 45 15 Journal Category
Audit field1 B100_1357 1357 60 20 No Mapping in code. This report shows only blank spaces.
Audit type1 B100_1358 1358 80 3 No Mapping in code. This report shows only blank spaces.
Audit Field2 B100_1359 1359 83 20 No Mapping in code. This report shows only blank spaces.
Audit Type2 B100_1360 1360 103 3 No Mapping in code. This report shows only blank spaces.
Description from GL JE Lines B100_1361 1361 106 50 Journal Line Description
Date B100_1362 1362 156 8 Last Update date of the Journal (usually the Post date, else same with Effective date)
Effective date B100_1363 1363 164 8 Journal Effective date
Account Key B100_1364 1364 172 15 Postable Natural Account Value

This table describes the detailed information provided in the fields of the open format files related to Documents code B100:

Documents Code Table Column Field Number in File Start Position Length Description
Contra Account B100_1365 1365 187 15 No Mapping in code. This report shows only blank spaces.

Calculating the sign for difference of accounted credit and accounted debit.

If the difference is positive = 1, If Negative/Zero= 2

 B100_1366 1366 202 1 Calculated Field.
Transaction Currency B100_1367 1367 203 3 This needs to be from the original transaction from the subledger and thus the info from the XLA tables, as GL ledger entries have only ILS.

Amount without tax -> Comment

Absolute value of Accounted Debit minus credit -> Actual Behaviour

 B100_1368 1368 206 15 Calculated Field. Translated in Ledger Currency if original in Non-ILS currency.

NON ILS Currency Calculation

Absolute value (no signs also) of Entered Debit minus credit -> Actual Behaviour

 B100_1369 1369 221 15 Calculated Field. We enter the non-ILS balance amount.
qty B100_1370 1370 236 12 If one exists, enter the statistical amount.
Adjustment Ref1 B100_1371 1371 248 10 No Mapping in code. This report shows only blank spaces.
Adjustment Ref2 B100_1372 1372 258 10 No Mapping in code. This report shows only blank spaces.
Blank B100_1373 1373 No Mapping in code. This report shows only blank spaces.
Branch Identity only if 1034 =1 B100_1374 1374 268 7 No Mapping in code. This report shows only blank spaces.

Branch Id when 1034=1 is for the case when the report is for a company branch.

Update Date / Creation Date B100_1375 1375 275 8 Creation Date
User Name B100_1376 1376 283 9 User name is an issue as we can only use 9 characters when we have (I think) 17 available for the User Name. They need to be restricted to 9 characters.
Reference Key B100_1377 1377 292 25 No Mapping in code. This report shows only blank spaces.

This table describes the detailed information provided in the fields of the open format files:

Documents Code Table Column Field Number in File Start Position Length Description
B110 376
Record Code B110_1400 1400 0 4 Hardcoded Value is B110
Future Use B110_1401 1401 4 9 Runtime Information, Free Text, No Validations
Registration Number B110_1402 1402 13 9 Legal Entity Contact Persons: Last Name where first name = OM.
Account Value B110_1403 1403 22 15
Account Description B110_1404 1404 37 50 50 Char
Balancing Segment Qualifier B110_1405 1405 87 15
Account Description B110_1406 1406 102 30 30 Char
Customer / Vendor Street B110_1407 1407 132 50 No Mapping in code. This report shows only blank spaces.
Customer / Vendor Home Number B110_1408 1408 182 10 No Mapping in code. This report shows only blank spaces.
Customer / Vendor City B110_1409 1409 192 30 No Mapping in code. This report shows only blank spaces.
Customer / Vendor zip code B110_1410 1410 222 8 No Mapping in code. This report shows only blank spaces.
Customer / Vendor State B110_1411 1411 230 30 No Mapping in code. This report shows only blank spaces.

Ledger Currency

State Code

 B110_1412 1412 260 2
Summary Account B110_1413 1413 262 15 No Mapping in code. This report shows only blank spaces.

Opening Balance of Account.

For which ever dates, the ESS job is submitted, sum of opening balance [difference of db/cr] of all periods in the range. No absolute value.

 B110_1414 1414 277 15

Calculated Value

SUM(gb.BEGIN_BALANCE_DR - gb.BEGIN_BALANCE_CR)

Sum of Accounted Debits

For which ever dates, the ESS job is submitted. No absolute value.

 B110_1415 1415 292 15 Calculated Field.

This table describes the detailed information provided in the fields of the open format files.

Documents Code Table Column Field Number in File Start Position Length Description

Sum of Accounted Credits

For any date, the ESS job is submitted, no absolute value.

 B110_1416 1416 307 15 Calculated Field
Accounting Classification B110_1417 1417 322 4 No Mapping in code. This report shows only blank spaces.
Customer / Supplier tax identifier B110_1419 1419 326 9 No Mapping in code. This report shows only blank spaces.
Branch ID only if 1034=1 B110_1421, -- Ver 1.31 1421 335 7 No Mapping in code. This report shows only blank spaces.

If the ledger currency is ILS, we print zero in this field, else opening balance is printed.

If the ledger currency is non ILS:

Opening Balance of Account.

For any date the ESS job is submitted, sum of opening balance of all periods in the range. No absolute value.

 B110_1422, -- Ver 1.31 1422 342 15

Calculated Values

DECODE('''||lc_ledger_currency||''',''ILS'',0,nvl(balances.open_balance,0))
Ledger Currency B110_1423, -- Ver 1.31 1423 357 3

Calculated Values

DECODE(:4,''ILS'',''ILS'','''||lc_ledger_currency||''')
Future Use B110_1424, -- Ver 1.31 1424 360 16 No Mapping in code. This report shows only blank spaces.

This table describes the detailed information provided in the fields of the open format files:

Documents Code Table Column Field Number in File Start Position Length Description
C100 444

Subcategory =

700 = Payables Invoices
Record Code C100_1200 1200 0 4 Hardcoded Value is C100
Future Use C100_1201 1201 4 9 Runtime Information, Free Text, No Validations
Registration Number C100_1202 1202 13 9 Legal Entity Contact Persons: Last Name where first name = OM.
Subcategory = 700 - Payables Invoices C100_1203 1203 22 3 Hardcoded Value is 700
invoice id of the invoice number C100_1204 1204 25 20
creation date of the invoice C100_1205 1205 45 8 TO_CHAR(api.creation_date, ''YYYYMMDD'')
time of the invoice creation from same field C100_1206 1206 53 4 TO_CHAR(api.creation_date, ''HH24MI'')
supplier name C100_1207 1207 57 50
just address line 1 C100_1208 1208 107 50
Customer / Vendor house number C100_1209 1209 157 10 No Mapping in code. This report shows only blank spaces.
Customer / Vendor city C100_1210 1210 167 30
Customer / Vendor zip code C100_1211 1211 197 8
Customer / Vendor state C100_1212 1212 205 30 No Mapping in code. This report shows only blank spaces.
Customer / Vendor state code C100_1213 1213 235 2 No Mapping in code. This report shows only blank spaces.
Customer / Vendor phone number C100_1214 1214 237 15 No Mapping in code. This report shows only blank spaces.

Customer / Vendor

Tax identifier

 C100_1215 1215 252 9 No Mapping in code. This report shows only blank spaces.
accounting date of the invoice C100_1216 1216 261 8 TO_CHAR(api.gl_date, ''YYYYMMDD'')

If invoice currency code is ILS, then the value reported is zero. If it is non-ILS currency, then the total amount for all distributions.

We are assuming it should be accounted currency.

C100_1217 1217 269 15

This table describes the detailed information provided in the fields of the open format files:

Documents Code Table Column Field Number in File Start Position Length Description
Non ILS Currency code C100_1218 1218 284 3
exclusive of tax lines C100_1219 1219 287 15

If the invoice currency is ILS = straight away take the amount from amount column. In this case, ledger currency will not matter.

If the invoice currency is Non ILS but ledger currency is ILS, then we pick the exchange rate of that particular day for ILS currency from invoice and multiply it with the amount of total distributions.

if the transaction currency is non ILS and the ledger currency is also non ILS then, parameter conversion rate type is used to fetch the exchange rate and then the amount of total distributions is multiplied by it.

Query is too long
Doc Amount (in ILS) without discount C100_1220 1220 302 15 hardcoded as zero as no discount is considered
The field is the sum of C100_1219+ C100_1220 BUT AS C100_1220 IS HARDCODED AS ZERO, ITS PRACTICALLY REPEAT OF C100_1219 C100_1221 1221 317 15

If the invoice currency is ILS = straight away take the amount from amount column. In this case, ledger currency will not matter.

If the invoice currency is Non ILS but ledger currency is ILS, then we pick the exchange rate of that particular day for ILS currency from invoice and multiply it with the amount of total distributions.

if the transaction currency is non ILS and the ledger currency is also non ILS then, parameter conversion rate type is used to fetch the exchange rate and then the amount of total distributions is multiplied by it.

Query is too long
only tax lines. Assuming withholding is not reported here. C100_1222 1222 332 15

If the invoice currency is ILS = straight away take the amount from amount column. In this case, ledger currency will not matter.

If the invoice currency is Non ILS but ledger currency is ILS, then we pick the exchange rate of that particular day for ILS currency from invoice and multiply it with the amount of total distributions.

if the transaction currency is non ILS and the ledger currency is also non ILS then, parameter conversion rate type is used to fetch the exchange rate and then the amount of total distributions is multiplied by it.

Query is too long
Sum of C100_1221 + C100_1222 C100_1223 1223 347 15
Withholding Tax amount in ILS C100_1224 1224 362 12 hardcoded as zero as no withholding tax is considered
supplier account number C100_1225 1225 374 15
Adjustment Field C100_1226 1226 389 10 No Mapping in code. This report shows only blank spaces.
If date is Null, we report NULL, if it’s a cancelled invoice, the value reported is 1 C100_1228 1228 399 1
C100_1230 1230 400 8 TO_CHAR(api.invoice_date, ''YYYYMMDD'')
Branch Id Required only if 1034=1 C100_1231 1231 408 7 No Mapping in code. This report shows only blank spaces.
id of the username C100_1233 1233 415 9
invoice id of the invoice number C100_1234 1234 424 7 Proposal: The last 7 digits of the Invoice_ID
Future Use C100_1235 1235 431 13 No Mapping in code. This report shows only blank spaces.

This table describes the detailed information provided in the fields of the open format files:

Documents Code Table Column Field Number in File Start Position Length Description
D110 339
Record Code D110_1250 1250 0 4 Hardcoded Value is D110
Future Use D110_1251 1251 4 9 Runtime Information, Free Text, No Validations
Registration Number D110_1252 1252 13 9 Legal Entity Contact Persons: Last Name where first name = OM.
Subcategory = 700 - Payables Invoices D110_1253 1253 22 3 Hardcoded Value is 700
invoice id of the invoice number D110_1254 1254 25 20
Line number. Only integer part of it if it’s in decimals D110_1255 1255 45 4 FLOOR(ap_invoices_lines_all line_number)
Subcategory = 700 - Payables Invoices D110_1256 1256 49 3 Hardcoded Value is 700
invoice number D110_1257 1257 52 20
D110_1258 1258 72 1 No Mapping in code. This report shows only blank spaces.
If the invoice is matched to a PO, then the item name from PO is printed else 999999 D110_1259 1259 73 20
If the item description is present, use it or if its missing, use invoice line description or if both are not present, use hardcoded value - 'Description is null' D110_1260 1260 93 30
D110_1261 1261 123 50 No Mapping in code. So, nothing appears in the report for this. No Mapping in code. So, nothing appears in the report for this. Only blank spaces.
D110_1262 1262 173 30 No Mapping in code. This report shows only blank spaces.
D110_1263 1263 203 20 No Mapping in code. This report shows only blank spaces.

This table describes the detailed information provided in the fields of the open format files related to Documents code D100:

Documents Code Table Column Field Number in File Start Position Length Description
Quantity of the line D110_1264 1264 223 17

Unit price of the line if it is present.

If unit price is not present, then the total of all distributions for that particular line exclusive of tax.

 D110_1265 1265 240 15
D110_1266 1266 255 15 hardcoded as zero as no discount is considered

The total of all the distributions inclusive of tax distributions for that line. Tax lines includes both recoverable and non-recoverable lines.

Validator checks if it is the multiplication of D110_1264 * D110_1265.

 D110_1267 1267 270 15

If for a line, tax rate is present, the following calculation happens:

tax rate is reported. Only recoverable tax rate is to be reported which is derived by (recoverable tax amount for a particular distribution line amount/distribution line amount is exclusive of tax)*100

If the line has multiple distribution lines, the value is calculated for all the lines and the maximum rate fetched is reported in the file.

If no tax rate is present, zero is reported as tax rate.

 D110_1268 1268 285 4
D110_1270 1270 289 7 No Mapping in code. This report shows only blank spaces.
D110_1272 1272 296 8 TO_CHAR(api.invoice_date, ''YYYYMMDD'')
Invoice id of the invoice number D110_1273 1273 304 7 Proposal: The last 7 digits of the Invoice_ID
If the invoice is matched to a PO, then the item id from PO is printed else 999999 D110_1274 1274 311 7 NVL(Po_lines_all Item_Id, ''999999'')
If the invoice is matched to a PO, then the organization [inventory org] id of the item from PO is printed else 1000000 D110_1275 1275 318 21 NVL(rcv_transactions ORGANIZATION_ID, ''999999'')

This table describes the detailed information provided in the fields of the open format files related to Documents code C100:

Documents Code Table Column Field Number in File Start Position Length Description
C100 444

Subcategory =

710 = Credit Memos
Record Code C100_1200 1200 0 4 Hardcoded Value is C100
Future Use C100_1201 1201 4 9 Runtime Information, Free Text, No Validations
Registration Number C100_1202 1202 13 9 Legal Entity Contact Persons: Last Name where first name = OM.
Subcategory = 710 - Credit Memos C100_1203 1203 22 3 Hardcoded Value is 710
Invoice id of the invoice number C100_1204 1204 25 20
Creation date of the invoice C100_1205 1205 45 8 TO_CHAR(api.creation_date, ''YYYYMMDD'')
Time of the invoice creation from same field C100_1206 1206 53 4 TO_CHAR(api.creation_date, ''HH24MI'')
Supplier name C100_1207 1207 57 50
Just address line 1 C100_1208 1208 107 50
Customer / Vendor house number C100_1209 1209 157 10 No Mapping in code. This report shows only blank spaces.
Customer / Vendor city C100_1210 1210 167 30
Customer / Vendor zip code C100_1211 1211 197 8
Customer / Vendor state C100_1212 1212 205 30 No Mapping in code. This report shows only blank spaces.
Customer / Vendor state code C100_1213 1213 235 2 No Mapping in code. This report shows only blank spaces.
Customer / Vendor phone number C100_1214 1214 237 15 No Mapping in code. This report shows only blank spaces.

Customer / Vendor

Tax identifier

 C100_1215 1215 252 9 No Mapping in code. This report shows only blank spaces.
Accounting date of the invoice C100_1216 1216 261 8 TO_CHAR(api.gl_date, ''YYYYMMDD'')

This table describes the detailed information provided in the fields of the open format files.

Documents Code Table Column Field Number in File Start Position Length Description

If invoice currency code is ILS, then the value reported is zero. If it is non-ILS currency, then the total amount for all distributions.

We are assuming it should be accounted currency.

C100_1217 1217 269 15
Non ILS Currency code C100_1218 1218 284 3
Exclusive of tax lines C100_1219 1219 287 15

If the invoice currency is ILS = straight away take the amount from amount column. In this case, ledger currency will not matter.

If the invoice currency is Non ILS but ledger currency is ILS, then we pick the exchange rate of that particular day for ILS currency from invoice and multiply it with the amount of total distributions.

if the transaction currency is non ILS and the ledger currency is also non ILS then, parameter conversion rate type is used to fetch the exchange rate and then the amount of total distributions is multiplied by it.

Query is too long
Doc Amount (in ILS) without discount C100_1220 1220 302 15 hardcoded as zero as no discount is considered
The field is the sum of C100_1219+ C100_1220 BUT AS C100_1220 IS HARDCODED AS ZERO, ITS PRACTICALLY REPEAT OF C100_1219 C100_1221 1221 317 15

If the invoice currency is ILS = straight away take the amount from amount column. In this case, ledger currency will not matter.

If the invoice currency is Non ILS but ledger currency is ILS, then we pick the exchange rate of that particular day for ILS currency from invoice and multiply it with the amount of total distributions.

if the transaction currency is non ILS and the ledger currency is also non ILS then, parameter conversion rate type is used to fetch the exchange rate and then the amount of total distributions is multiplied by it.

Query is too long

This table describes the detailed information provided in the fields of the open format files.

Documents Code Table Column Field Number in File Start Position Length Description
Only tax lines. Assuming withholding is not reported here. C100_1222 1222 332 15

If the invoice currency is ILS = straight away take the amount from amount column. In this case, ledger currency will not matter.

If the invoice currency is Non ILS but ledger currency is ILS, then we pick the exchange rate of that particular day for ILS currency from invoice and multiply it with the amount of total distributions.

if the transaction currency is non ILS and the ledger currency is also non ILS then, parameter conversion rate type is used to fetch the exchange rate and then the amount of total distributions is multiplied by it.

Query is too long
Sum of C100_1221 + C100_1222 C100_1223 1223 347 15
Withholding Tax amount in ILS C100_1224 1224 362 12 hardcoded as zero as no withholding tax is considered
Supplier account number C100_1225 1225 374 15
Adjustment Field C100_1226 1226 389 10 No Mapping in code. This report shows only blank spaces.
If date is Null, we report NULL, if it’s a cancelled invoice, the value reported is 1 C100_1228 1228 399 1
C100_1230 1230 400 8 TO_CHAR(api.invoice_date, ''YYYYMMDD'')
Branch Id Required only if 1034=1 C100_1231 1231 408 7 No Mapping in code. This report shows only blank spaces.
Id of the username C100_1233 1233 415 9
Invoice id of the invoice number C100_1234 1234 424 7 Proposal: The last 7 digits of the Invoice_ID
Future Use C100_1235 1235 431 13 No Mapping in code. This report shows only blank spaces.

This table describes the detailed information provided in the fields of the open format files related to Documents code D110:

Documents Code Table Column Field Number in File Start Position Length Description
D110 339
Record Code D110_1250 1250 0 4 Hardcoded Value is D110
Future Use D110_1251 1251 4 9 Runtime Information, Free Text, No Validations
Registration Number D110_1252 1252 13 9 Legal Entity Contact Persons: Last Name where first name = OM.
Subcategory = 710 - Payables Invoices D110_1253 1253 22 3 Hardcoded Value is 710
Invoice id of the invoice number D110_1254 1254 25 20
Line number. Only integer part of it if it’s in decimals D110_1255 1255 45 4 FLOOR(ap_invoices_lines_all line_number)
Subcategory = 700 - Payables Invoices D110_1256 1256 49 3 Hardcoded Value is 700
Invoice number D110_1257 1257 52 20
D110_1258 1258 72 1 No Mapping in code. This report shows only blank spaces.
If the invoice is matched to a PO, then the item name from PO is printed else 999999 D110_1259 1259 73 20
If the item description is present, use it or if its missing, use invoice line description or if both are not present, use hardcoded value - 'Description is null' D110_1260 1260 93 30
D110_1261 1261 123 50 No Mapping in code. So, nothing appears in the report for this. No Mapping in code. So, nothing appears in the report for this. Only blank spaces.
D110_1262 1262 173 30 No Mapping in code. This report shows only blank spaces.
D110_1263 1263 203 20 No Mapping in code. This report shows only blank spaces.
Quantity of the line D110_1264 1264 223 17

Unit price of the line if it is present.

If unit price is not present, then the total of all distributions for that particular line exclusive of tax.

 D110_1265 1265 240 15
D110_1266 1266 255 15 hardcoded as zero as no discount is considered

The total of all the distributions inclusive of tax distributions for that line. Tax lines includes both recoverable and non-recoverable lines.

Validator checks if it is the multiplication of D110_1264 * D110_1265.

 D110_1267 1267 270 15

If for a line, tax rate is present, the following calculation happens:

tax rate is reported. Only recoverable tax rate is to be reported which is derived by (recoverable tax amount for a particular distribution line amount/distribution line amount is exclusive of tax)*100

If the line has multiple distribution lines, the value is calculated for all the lines and the maximum rate fetched is reported in the file.

If no tax rate is present, zero is reported as tax rate.

 D110_1268 1268 285 4
D110_1270 1270 289 7 No Mapping in code. This report shows only blank spaces.
D110_1272 1272 296 8 TO_CHAR(api.invoice_date, ''YYYYMMDD'')
Invoice id of the invoice number D110_1273 1273 304 7 Proposal: The last 7 digits of the Invoice_ID
If the invoice is matched to a PO, then the item id from PO is printed else 999999 D110_1274 1274 311 7 NVL(Po_lines_all Item_Id, ''999999'')
If the invoice is matched to a PO, then the organization [inventory org] id of the item from PO is printed else 1000000 D110_1275 1275 318 21 NVL(rcv_transactions ORGANIZATION_ID, ''999999'')

This table describes the detailed information provided in the fields of the open format files related to Documents code C110:

Documents Code Table Column Field Number in File Start Position Length Description
C100 444

Subcategory = 300_305_330_345 = Receivables Transactions
Record Code C100_1200 1200 0 4 Hardcoded Value is C100
Future Use C100_1201 1201 4 9 Runtime Information, Free Text, No Validations
Registration Number C100_1202 1202 13 9 Legal Entity Contact Persons: Last Name where first name = OM.
Subcategory to be picked up from GDF: IL Transaction Type Additional Info, segment Tax Document Type on transaction types page C100_1203 1203 22 3

Value from the Transaction Type can be:

300 AR Proforma Invoices

305 AR Standard Transactions (Sales Inv)

330 AR Credit Memos

345 Agent Invoices
If the document sequence number is present , use it. If it is not there, use the transaction number. C100_1204 1204 25 20
Date C100_1205 1205 45 8
Time C100_1206 1206 53 4
Customer Name C100_1207 1207 57 50
Line 1 of the address C100_1208 1208 107 50
C100_1209 1209 157 10 No Mapping in code. So, nothing appears in the report for this.
C100_1210 1210 167 30
C100_1211 1211 197 8
C100_1212 1212 205 30 No Mapping in code. So, nothing appears in the report for this.
C100_1213 1213 235 2 No Mapping in code. So, nothing appears in the report for this.
C100_1214 1214 237 15 No Mapping in code. So, nothing appears in the report for this.
C100_1215 1215 252 9 No Mapping in code. So, nothing appears in the report for this.
GL Date C100_1216 1216 261 8
Sum of all distribution lines for all lines. Amount is inclusive of tax. C100_1217 1217 269 15 SUM(RCTLGDA1.amount)
C100_1218 1218 284 3
Total amount for all lines with line type as line C100_1219 1219 287 15 SUM(RCTLGDA1.amount) RCTLA1.line_type = ''LINE''
Generally, discount but no information is mentioned. C100_1220 1220 302 15 Hardcoded as zero.
Total amount where the account class should not be tax. C100_1221 1221 317 15 RCTLGDA1.account_class <> ''TAX'' SUM(RCTLGDA1.amount)
Total amount where the account class should be tax. C100_1222 1222 332 15 (RCTLGDA1.amount) RCTLGDA1.account_class = ''TAX''
Total amount for all lines without any exclusion. C100_1223 1223 347 15 SUM(RCTLGDA1.amount)
No comment C100_1224 1224 362 12 Hardcoded as zero.
Customer account number C100_1225 1225 374 15
C100_1226 1226 389 10 No Mapping in code. So, nothing appears in the report for this.
C100_1228 1228 399 1 No Mapping in code. So, nothing appears in the report for this.
C100_1230 1230 400 8
C100_1231 1231 408 7 No Mapping in code. So, nothing appears in the report for this.
C100_1233 1233 415 9
C100_1234 1234 424 7
C100_1235 1235 431 13 No Mapping in code. So, nothing appears in the report for this.

This table describes the detailed information provided in the fields of the open format files related to Documents code D110.

Documents Code Table Column Field Number in File Start Position Length Description
D110 339
Record Code D110_1250 1250 0 4 Hardcoded Value is D110
Future Use D110_1251 1251 4 9 Runtime Information, Free Text, No Validations
Registration Number D110_1252 1252 13 9 Legal Entity Contact Persons: Last Name where first name = OM.
Subcategory to be picked up from GDF: IL Transaction Type Additional Info, segment Tax Document Type on transaction types page D110_1253 1253 22 3

Value from the Transaction Type can be:

300 AR Proforma Invoices

305 AR Standard Transactions (Sales Inv)

330 AR Credit Memos

345 Agent Invoices
If the document sequence number is present, use it. If it is not there, use the transaction number. D110_1254 1254 25 20
D110_1255 1255 45 4
Subcategory to be picked up from GDF: IL Transaction Type Additional Info, segment Tax Document Type on transaction types page D110_1256 1256 49 3

Value from the Transaction Type can be:

300 AR Proforma Invoices

305 AR Standard Transactions (Sales Inv)

330 AR Credit Memos

345 Agent Invoices
D110_1257 1257 52 20
If the segment information is not present, the value present is 999999 D110_1258 1258 72 1 No Mapping in code. So, nothing appears in the report for this.
D110_1259 1259 73 20
D110_1260 1260 93 30
D110_1261 1261 123 50 No Mapping in code. So, nothing appears in the report for this.
D110_1262 1262 173 30 No Mapping in code. So, nothing appears in the report for this.

If quantity invoiced is zero, then the value printed is 1. If the quantity invoiced is not zero then, quantity invoiced is printed. If quantity invoiced is null, then quantity credited is printed.

Quantity credited??

 D110_1263 1263 203 20
D110_1264 1264 223 17 NVL( DECODE(RCTLA1.quantity_invoiced,0,1,RCTLA1.quantity_invoiced),DECODE(RCTLA1.quantity_credited,0,1,NULL,1,RCTLA1.quantity_credited))
D110_1265 1265 240 15
D110_1266 1266 255 15 Hardcoded Value is 0
Multiplication of d110_1264*d110_1265 D110_1267 1267 270 15
D110_1268 1268 285 4 NVL(SUM(RCTLA2.tax_rate),00.00)
D110_1270 1270 289 7 No Mapping in code. So, nothing appears in the report for this.
D110_1272 1272 296 8 to_char(RCTA.TRX_DATE,''YYYYMMDD'')
D110_1273 1273 304 7 RCTA.CUSTOMER_TRX_ID
If the item id is not present, print 999999 D110_1274 1274 311 7 NVL(RCTLA1.Inventory_Item_Id, ''999999'')

If interface_line_attribute10

is not present, print 999999

 D110_1275 1275 318 21 NVL(RCTLA1.interface_line_attribute10, ''999999'')

This table describes the detailed information provided in the fields of the open format files.

Documents Code Table Column Field Number in File Start Position Length Description
C100 444

Subcategory =

400_405_410_420 = Receivables Receipts
Record Code C100_1200 1200 0 4 Hardcoded Value is C100
Future Use C100_1201 1201 4 9 Runtime Information, Free Text, No Validations
Registration Number C100_1202 1202 13 9 Legal Entity Contact Persons: Last Name where first name = OM.
Subcategory to be picked up from receipt class GDF C100_1203 1203 22 3

Value from the Receipt class can be:

400 AR Standard Receipts

405 Donation Receipts

410 Petty Cash Receipts

420 Bank Deposits
If no value is present for sequence, take the receipt number. C100_1204 1204 25 20 substr(nvl(to_char (ACRA.doc_sequence_value),ACRA.receipt_number), 1, 20)
Receipt creation date C100_1205 1205 45 8 (ACRHA.creation_date,''YYYYMMDD'')
Receipt creation time. C100_1206 1206 53 4 TO_CHAR(ACRHA.creation_date,''HHMI'')
Customer name C100_1207 1207 57 50 NVL(HP.party_name,''9999'')
Line 1 C100_1208 1208 107 50
C100_1209 1209 157 10 No Mapping in code. So, nothing appears in the report for this.
C100_1210 1210 167 30
C100_1211 1211 197 8
C100_1212 1212 205 30 No Mapping in code. So, nothing appears in the report for this.
C100_1213 1213 235 2 No Mapping in code. So, nothing appears in the report for this.
C100_1214 1214 237 15 No Mapping in code. So, nothing appears in the report for this.
C100_1215 1215 252 9 No Mapping in code. So, nothing appears in the report for this.
GL date of the receipt at the header level C100_1216 1216 261 8 TO_CHAR(ACRHA.gl_date,''YYYYMMDD'')
Total receipt amount in ILS C100_1217 1217 269 15 ACRHA.amount

This table describes the detailed information provided in the fields of the open format files.

Documents Code Table Column Field Number in File Start Position Length Description
Should be ILS only. But is picking value from entered or accounted? C100_1218 1218 284 3
Total receipt amount C100_1219 1219 287 15

If the invoice currency is ILS = straight away take the amount from amount column. In this case, ledger currency will not matter.

If the invoice currency is Non ILS but ledger currency is ILS, then we pick the exchange rate of that particular day for ILS currency from invoice and multiply it with the total amount of receipt.

if the transaction currency is non ILS and the ledger currency is also non ILS then, parameter conversion rate type is used to fetch the exchange rate and then the amount of total receipt amount is multiplied by it.

Query is too long
C100_1220 1220 302 15 Hardcoded Value is 0
Total receipt amount C100_1221 1221 317 15

If the invoice currency is ILS = straight away take the amount from amount column. In this case, ledger currency will not matter.

If the invoice currency is Non ILS but ledger currency is ILS, then we pick the exchange rate of that particular day for ILS currency from invoice and multiply it with the total amount of receipt.

If the transaction currency is non ILS and the ledger currency is also non ILS then, parameter conversion rate type is used to fetch the exchange rate and then the amount of total receipt amount is multiplied by it.

Query is too long
C100_1222 1222 332 15 Hardcoded Value is 0
total receipt amount C100_1223 1223 347 15

If the invoice currency is ILS = straight away take the amount from amount column. In this case, ledger currency will not matter.

If the invoice currency is Non ILS but ledger currency is ILS, then we pick the exchange rate of that particular day for ILS currency from invoice and multiply it with the total amount of receipt.

If the transaction currency is non ILS and the ledger currency is also non ILS then, parameter conversion rate type is used to fetch the exchange rate and then the amount of total receipt amount is multiplied by it.

Query is too long
C100_1224 1224 362 12 Hardcoded Value is 0
C100_1225 1225 374 15 NVL(HCA.account_number,''9999'')
If the account number is not present, print 9999 C100_1226 1226 389 10 No Mapping in code. So, nothing appears in the report for this.
If the status is present, print it. If null, print 1 C100_1228 1228 399 1 NVL2(ACRHA1.status,1,'''')
C100_1230 1230 400 8 TO_CHAR(ACRHA.trx_date,''YYYYMMDD'')
C100_1231 1231 408 7 No Mapping in code. So, nothing appears in the report for this.
C100_1233 1233 415 9 ACRA.CREATED_BY
C100_1234 1234 424 7 ACRA.CASH_RECEIPT_ID
C100_1235 1235 431 13 No Mapping in code. So, nothing appears in the report for this.

This table describes the detailed information provided in the fields of the open format files related to Documents code: D120

Documents Code Table Column Field Number in File Start Position Length Description
D120 222
Record Code D120_1300 1300 0 4 Hardcoded Value is D120
Future Use D120_1301 1301 4 9 Runtime Information, Free Text, No Validations
Registration Number D120_1302 1302 13 9 Legal Entity Contact Persons: Last Name where first name = OM.
Subcategory to be picked up from receipt class GDF D120_1303 1303 22 3

Value from the Receipt class can be:

400 AR Standard Receipts

405 Donation Receipts

410 Petty Cash Receipts

420 Bank Deposits
If no value is present for sequence, take the receipt number. D120_1304 1304 25 20 substr(nvl(to_char (ACRA.doc_sequence_value),ACRA.receipt_number), 1, 20)
D120_1305 1305 45 4 Hardcoded Value is 1
D120_1306 1306 49 1 Receipt Type.
D120_1307 1307 50 10 IL Check Bank Number
D120_1308 1308 60 10 IL Check Bank Branch Number
D120_1309 1309 70 15 IL Check Account Number
D120_1310 1310 85 10 IL Check Number
D120_1311 1311 95 8 to_char(APS.due_date,''YYYYMMDD'')
D120_1312 1312 103 15

If the invoice currency is ILS = straight away take the amount from amount column. In this case, ledger currency will not matter.

If the invoice currency is Non ILS but ledger currency is ILS, then we pick the exchange rate of that particular day for ILS currency from invoice and multiply it with the total amount of receipt.

If the transaction currency is non ILS and the ledger currency is also non ILS then, parameter conversion rate type is used to fetch the exchange rate and then the amount of total receipt amount is multiplied by it.

Query is too long
D120_1313 1313 118 1 IL Credit Clearing House

This table describes the detailed information provided in the fields of the open format files.

Documents Code Table Column Field Number in File Start Position Length Description
D120_1314 1314 119 20 IL Credit Card Name
D120_1315 1315 139 1 IL Credit Deal Type
D120_1320 1320 140 7 No Mapping in code. This report shows only blank spaces.
Only date D120_1322 1322 147 8 (ACRA.RECEIPT_DATE,''YYYYMMDD'')
D120_1323 1323 155 7 ACRA.CASH_RECEIPT_ID
Future Use D120_1324 1324 162 60 No Mapping in code. This report shows only blank spaces.

This table describes the detailed information provided in the fields of the open format files related to Documents code Z900:

Documents Code Table Column Field Number in File Start Position Length Description
Z900 110
Record Code Z900_1150 1150 0 4 Hardcoded Value is Z900
Future Use Z900_1151 1151 4 9 Runtime Information, Free Text, No Validations
Registration Number Z900_1152 1152 13 9 Legal Entity Contact Persons: Last Name where first name = OM.
Reference Key Z900_1153 1153 22 15 DB Sequence Value. Provides the Run Sequence. Last Run Number + 1. Same ascii.
Constant Z900_1154 1154 37 8 Given hardcoded value: &OF1.31&
Count - All records = B100 +C100+D120+D110+B110+M100+A100 Z900_1155 1155 45 15
Future Use 60 50 No Mapping in code. This report shows only blank spaces.

This table describes the detailed information provided in the fields of the open format files for INI.

Documents Code Table Column Field Number in File Start Position Length Description
INI 580
Record Code INI_1000 0 4 Hardcoded Value is A000
Future Use INI_1001 4 5 Runtime Information, Free Text, No Validations
Total qty of records in BKMVDATA file INI_1002 9 15 Total qty of records in BKMVDATA file
Tax Identifier INI_1003 24 9 Legal Entity Contact Persons: Last Name where first name = OM.
Reference Key INI_1004 33 15
Constant INI_1005 48 8 Given hardcoded value: &OF1.31&
Software registration Number INI_1006 56 8 34002
Software Name INI_1007 64 20 ERP Cloud
Software Version INI_1008 84 20 11.13.08.01
Tax Identifier of Software Manufacturer INI_1009 104 9 512200502
Software Manufacturer Name INI_1010 113 20 Oracle Software

This table describes the detailed information provided in the fields of the open format files for INI.

Documents Code Table Column Field Number in File Start Position Length Description
Software Type INI_1011 133 1 2
Backup path INI_1012 134 50 C:\
Software Accounting Type INI_1013 184 1 2
Accounting Type INI_1014 185 1 1
Company Registration Number INI_1015 186 9 OM person_first_name value from the LE contact name
Company Tax File INI_1016 195 9 TN person_first_name value from the LE contact name
Future use INI_1017 204 10 No Mapping in code. This report shows only blank spaces.
Company Name INI_1018 214 50 LE NAME
Company Street INI_1019 264 50 Le address
Company location number INI_1020 314 10
Company City INI_1021 324 30 LE City
Company zip code INI_1022 354 8 LE Zip Code
Tax year INI_1023 362 4 From the parameters the tax year of start date.
Date range (start) INI_1024 366 8

Date format is YYYYMMDD

Start date from the parmaters

This table describes the detailed information provided in the fields of the open format files for INI.

Documents Code Table Column Field Number in File Start Position Length Description
Date range (end) INI_1025 374 8

Date format is YYYYMMDD

End date from the parameters
Process start date INI_1026 382 8

Date format is YYYYMMDD

Sys date

Process start time INI_1027 390 4

Format HHMM

Sys starting hour

Language Code INI_1028 394 1 0
Character Set INI_1029 395 1 1
Software zip code INI_1030 396 20 Winzip
Currency Code INI_1032 416 3 ILS
Branch Information INI_1034 419 1 0
Future use INI_1035 420 46
B100 466 19 Counter of all header records of GL Journals
B110 485 19 Counter of all Account Balances records in GL
C100 504 19 Counter of all Receivable and Payable Header records
D110 523 19 Counter of all Receivable and Payable Line records
D120 542 19 Counter of all Receivable Receipt records
M100 561 19 Counter of all Supply Chain transaction records