|
|
|
|
|
|
|
|
| Previous | Next | Contents | Index | Glossary | Library |
This section describes the columns in the RA_INTERFACE_LINES interface table for Oracle Financials for Brazil and shows where the values are stored.
| In this column
| Oracle Receivables stores
| For this location
|
| HEADER_GDF_ATTRIBUTE1
| Interest type (rate or amount). If this value is not null, this value must
exist in the FND_LOOKUP_VALUES.
LOOKUP_CODE table and LOOKUP_TYPE = “JLBR_INTEREST_PENALTY_TYPE.” The current date is the active date. | RA_CUSTOMER_TRX.
GLOBAL_ATTRIBUTE1 |
| HEADER _GDF_ATTRIBUTE2
| Interest rate or amount. If the interest type is R (rate), this value must be
between 0 and 100. If the interest type is A (amount), this value must be
greater than zero.
| RA_CUSTOMER_TRX.
GLOBAL_ATTRIBUTE2 |
| HEADER _GDF_ATTRIBUTE3
| Interest period days. If the interest type is not null, this value must be
greater than zero.
| RA_CUSTOMER_TRX.
GLOBAL_ATTRIBUTE3 |
| HEADER _GDF_ATTRIBUTE4
| Interest formula (simple, compound). If this value is not null, this value
must exist in the FND_LOOKUP_VALUES.
LOOKUP_CODE table and LOOKUP_TYPE = “JLBR_INTEREST_FORMULA.” The system date is the active date. | RA_CUSTOMER_TRX.
GLOBAL_ATTRIBUTE4 |
| HEADER _GDF_ATTRIBUTE5
| Grace days. This value must be greater than zero.
| RA_CUSTOMER_TRX.
GLOBAL_ATTRIBUTE5 |
| HEADER _GDF_ATTRIBUTE6
| Penalty type (rate or amount). If this value is not null, this value must
exist in the FND_LOOKUP_VALUES.
LOOKUP_CODE table and LOOKUP_TYPE = “JLBR_INTEREST_PENALTY_TYPE.” The system date is the active date. | RA_CUSTOMER_TRX.
GLOBAL_ATTRIBUTE6 |
| HEADER _GDF_ATTRIBUTE7
| Penalty rate or amount. If the penalty type is R (rate) ,this value must be
between 0 and 100. If the penalty type is A (amount), this value must be greater
than 0.
| RA_CUSTOMER_TRX.
GLOBAL_ATTRIBUTE7 |
| HEADER_GDF_ATTRIBUTE9
| Freight accessory expense. This value is numeric and is not mandatory.
| RA_CUSTOMER_TRX.
GLOBAL_ATTRIBUTE9 |
| HEADER_GDF_ATTRIBUTE10
| Insurance accessory expense. This value is numeric and is not mandatory.
| RA_CUSTOMER_TRX.
GLOBAL_ATTRIBUTE10 |
| HEADER_GDF_ATTRIBUTE11
| Other accessory expense. This value is numeric and is not mandatory.
| RA_CUSTOMER_TRX.
GLOBAL_ATTRIBUTE11 |
| HEADER_GDF_ATTRIBUTE12
| License plate
| RA_CUSTOMER_TRX.
GLOBAL_ATTRIBUTE12 |
| HEADER_GDF_ATTRIBUTE13
| Volume quantity. This value is numeric and is not mandatory.
| RA_CUSTOMER_TRX.
GLOBAL_ATTRIBUTE13 |
| HEADER_GDF_ATTRIBUTE14
| Volume type
| RA_CUSTOMER_TRX.
GLOBAL_ATTRIBUTE14 |
| HEADER_GDF_ATTRIBUTE15
| Volume number. This value is numeric and is not mandatory.
| RA_CUSTOMER_TRX.
GLOBAL_ATTRIBUTE15 |
| HEADER_GDF_ATTRIBUTE16
| Total gross weight. This value is numeric and is not mandatory.
| RA_CUSTOMER_TRX.
GLOBAL_ATTRIBUTE16 |
| HEADER_GDF_ATTRIBUTE17
| Total net weight. This value is numeric and is not mandatory.
| RA_CUSTOMER_TRX.
GLOBAL_ATTRIBUTE17 |
| LINE_GDF_ATTRIBUTE1
| Operation Fiscal Code (CFO). This value is mandatory. The value must exist in
the JL_BR_AP_OPERATIONS.
CFO_CODE table. | RA_CUSTOMER_TRX_
LINES.GLOBAL_ ATTRIBUTE1 |
| LINE_GDF_ATTRIBUTE2
| Fiscal Classification Code. This value is mandatory if RA_INTERFACE_LINES.
INVENTORY_ITEM_ID or RA_INTERFACE_LINES. MEMO_LINE_ID is not null. The value must exist in the JL_BR_LOOKUP_CODES. LOOKUP_CODE table and LOOKUP_TYPE = “FISCAL_CLASSIFICATION_ CODE. The current date is the active date. | RA_CUSTOMER_TRX_
LINES.GLOBAL_ ATTRIBUTE2 |
| LINE_GDF_ATTRIBUTE3
| Transaction Nature. This field is mandatory if RA_INTERFACE_LINES.
INVENTORY_ITEM_ID or RA_INTERFACE_LINES. MEMO_LINE_ID is not null. This value must exist in the JL_BR_LOOKUP_CODES. LOOKUP_CODE table and LOOKUP_TYPE = “TRANSACTION_REASON.” The current date is the active date. | RA_CUSTOMER_TRX_
LINES.GLOBAL_ ATTRIBUTE3 |
| LINE_GDF_ATTRIBUTE4
| Item origin. This value is mandatory if RA_INTERFACE_LINES.
INVENTORY_ITEM_ID or RA_INTERFACE_LINES. MEMO_LINE_ID is not null. This value must exist in the JL_BR_LOOKUP_CODES. LOOKUP_CODE table and LOOKUP_TYPE = “ITEM_ORIGIN.” The current date is the active date. | RA_CUSTOMER_TRX_
LINES.GLOBAL_ ATTRIBUTE4 |
| LINE_GDF_ATTRIBUTE5
| Item fiscal type. This value is mandatory if RA_INTERFACE_LINES.
INVENTORY_ITEM_ID or RA_INTERFACE_LINES. MEMO_LINE_ID is not null. This value must exist in the JL_BR_LOOKUP_CODES. LOOKUP_CODE table and LOOKUP_TYPE = “ITEM_FISCAL_TYPE.” The current date is the active date. | RA_CUSTOMER_TRX_
LINES.GLOBAL_ ATTRIBUTE5 |
| LINE_GDF_ATTRIBUTE6
| Federal tributary situation. This value is mandatory if RA_INTERFACE_LINES.
INVENTORY_ITEM_ID or RA_INTERFACE_LINES. MEMO_LINE_ID is not null. This value must exist in the JL_BR_LOOKUP_CODES. LOOKUP_CODE table and LOOKUP_TYPE = “ITEM_FEDERAL_ SITUATION.” The current date is the active date. | RA_CUSTOMER_TRX_
LINES.GLOBAL_ ATTRIBUTE6 |
| LINE_GDF_ATTRIBUTE7
| State tributary situation. This value is mandatory if RA_INTERFACE_LINES.
INVENTORY_ITEM_ID or RA_INTERFACE_LINES. MEMO_LINE_ID is not null. This value must exist in the JL_BR_LOOKUP_CODES. LOOKUP_CODE table and LOOKUP_TYPE = “ITEM_STATE_ORIGIN.” The current date is the active date. | RA_CUSTOMER_TRX_
LINES.GLOBAL_ ATTRIBUTE7 |
| LINE_GDF_ATTRIBUTE8
| Legal Message 1
| RA_CUSTOMER_TRX_
LINES.GLOBAL_ ATTRIBUTE8 |
| LINE_GDF_ATTRIBUTE9
| Legal Message 2
| RA_CUSTOMER_TRX_
LINES.GLOBAL_ ATTRIBUTE9 |
| LINE_GDF_ATTRIBUTE10
| Legal Message 3
| RA_CUSTOMER_TRX_
LINES.GLOBAL_ ATTRIBUTE10 |
| LINE_GDF_ATTRIBUTE11
| The tax base amount (numeric 38,2)
| RA_CUSTOMER_TRX_
LINES.GLOBAL_ ATTRIBUTE11 |
| LINE_GDF_ATTRIBUTE12
| The tax base rate (numeric 5,2)
| RA_CUSTOMER_TRX_
LINES.GLOBAL_ ATTRIBUTE12 |
| Previous | Next | Contents | Index | Glossary | Library |