FIF GL Cross Ref Dynamic

System-generated primary key for this table.

Set Of Books Id Oracle Retail target column SET_OF_BOOKS_ID on FIF_GL_CROSS_REF_DYNAMIC.

Oracle Retail department. A value of -1 will be used as a wildcard to mean all departments.

Oracle Retail Class. A value of -1 will be used as a wildcard to mean all classes.

Oracle Retail Subclass. A value of -1 will be used as a wildcard to mean all subclasses.

Oracle Retail Location. A value of -1 will be used as a wildcard to mean all locations.

Oracle Retail Transaction code. A value of -1 will be used as a wildcard to mean all tran codes. A tran code of zero will be used to refer to purchase order accounts.

Cost C or Retail R Flag. Oracle Retail target column COST_RETAIL_FLAG on FIF_GL_CROSS_REF_DYNAMIC.

This indicates whether the account code of this record is for an Item, Freight, Tax, or Miscellaneous. This information will be necessary when choosing which Oracle Financials account to associate with each line in the invoice. Without this field, we are only able to choose an account code for an item, not for freight, tax, or miscellaneous charges.

Contains the intercompany transfer from/to location (tran code = 37, 38), the work order activity ID (tran code = 63, 64), the inventory adjustment reason (tran code = 22, 23), the vat code (tran code = 87, 88) or -1 as a catch-all value, the merchandise cost mapping code system option, the unmapped cost component mapping code system option or a non-merchandise code found on the non-merchandise codes table (tran code = 20). If the tran code is Intercompany Out, the field will contain the transfer To Location. If the tran code is Intercompany, the field will contain the transfer From Location.

Oracle debit account combination code ID, determined from the 10 sequence numbers.

Oracle debit account mapping field1, maps to Oracle side GL_Code _combinations table.

Oracle debit account mapping field2, maps to Oracle side GL_Code _combinations table.

Oracle debit account mapping field3, maps to Oracle side GL_Code _combinations table.

Oracle debit account mapping field4, maps to Oracle side GL_Code _combinations table.

Oracle debit account mapping field5, maps to Oracle side GL_Code _combinations table.

Oracle debit account mapping field6, maps to Oracle side GL_Code _combinations table.

Oracle debit account mapping field7, maps to Oracle side GL_Code _combinations table.

Oracle debit account mapping field8, maps to Oracle side GL_Code _combinations table.

Oracle debit account mapping field9, maps to Oracle side GL_Code _combinations table.

Oracle debit account mapping field10, maps to Oracle side GL_Code _combinations table.

Oracle credit account combination code ID, determined from the 10 sequence numbers.

Oracle credit account mapping field1, maps to Oracle side GL_Code _combinations table.

Oracle credit account mapping field2, maps to Oracle side GL_Code _combinations table.

Oracle credit account mapping field3, maps to Oracle side GL_Code _combinations table.

Oracle credit account mapping field4, maps to Oracle side GL_Code _combinations table.

Oracle credit account mapping field5, maps to Oracle side GL_Code _combinations table.

Oracle credit account mapping field6, maps to Oracle side GL_Code _combinations table.

Oracle credit account mapping field7, maps to Oracle side GL_Code _combinations table.

Oracle credit account mapping field8, maps to Oracle side GL_Code _combinations table.

Oracle credit account mapping field9, maps to Oracle side GL_Code _combinations table.

Oracle credit account mapping field10, maps to Oracle side GL_Code _combinations table.

debit account mapping field11 Oracle Retail target column DR_SEQUENCE11 on FIF_GL_CROSS_REF_DYNAMIC.

debit account mapping field12 Oracle Retail target column DR_SEQUENCE12 on FIF_GL_CROSS_REF_DYNAMIC.

debit account mapping field13 Oracle Retail target column DR_SEQUENCE13 on FIF_GL_CROSS_REF_DYNAMIC.

debit account mapping field14 Oracle Retail target column DR_SEQUENCE14 on FIF_GL_CROSS_REF_DYNAMIC.

debit account mapping field15 Oracle Retail target column DR_SEQUENCE15 on FIF_GL_CROSS_REF_DYNAMIC.

debit account mapping field16 Oracle Retail target column DR_SEQUENCE16 on FIF_GL_CROSS_REF_DYNAMIC.

debit account mapping field17 Oracle Retail target column DR_SEQUENCE17 on FIF_GL_CROSS_REF_DYNAMIC.

debit account mapping field18 Oracle Retail target column DR_SEQUENCE18 on FIF_GL_CROSS_REF_DYNAMIC.

debit account mapping field19 Oracle Retail target column DR_SEQUENCE19 on FIF_GL_CROSS_REF_DYNAMIC.

debit account mapping field20 Oracle Retail target column DR_SEQUENCE20 on FIF_GL_CROSS_REF_DYNAMIC.

credit account mapping field11

credit account mapping field12

credit account mapping field13

credit account mapping field14

credit account mapping field15

credit account mapping field16

credit account mapping field17

credit account mapping field18

credit account mapping field19

credit account mapping field20

This column contains the FIF_GL_CROSS_REF_ID of the GL cross reference from which this record has been created along with mapped values from dynamic segments.