FND Design Data [Home] [Help]

Table: AR_GTA_TRX_HEADERS_ALL

Product: AR - Receivables
Description: Header-level information for GTA Invoice
Implementation/DBA Data: TableAR.AR_GTA_TRX_HEADERS_ALL
Primary Key: AR_GTA_TRX_HEADERS_N4
  1. ColumnGTA_TRX_NUMBER
  2. ColumnORG_ID
Primary Key: AR_GTA_TRX_HEADERS_PK
  1. ColumnGTA_TRX_HEADER_ID
Primary Key: AR_GTA_TRX_HEADERS_U2
  1. ColumnGTA_TRX_NUMBER
  2. ColumnORG_ID
  3. ColumnSOURCE
Primary Key: AR_GTA_TRX_HEADERS_U3
  1. ColumnRA_TRX_ID
  2. ColumnGROUP_NUMBER
  3. ColumnVERSION
  4. ColumnORG_ID
  5. ColumnSOURCE
Primary Key: JMF_GTA_TRX_HEADERS_PK
  1. ColumnGTA_TRX_HEADER_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
AR_GTA_TRX_HEADERS_ALL FK Joins to TableHZ_CUST_ACCOUNTS AR_GTA_TRX_HEADERS_ALL.BILL_TO_CUSTOMER_ID
AR_GTA_TRX_HEADERS_ALL FK Joins to TableAR_GTA_RULE_HEADERS_ALL AR_GTA_TRX_HEADERS_ALL.RULE_HEADER_ID
AR_GTA_TRX_HEADERS_ALL FK Joins to TableRA_CUSTOMER_TRX_ALL AR_GTA_TRX_HEADERS_ALL.RA_TRX_ID
AR_GTA_TRX_HEADERS_ALL FK Joins to TableFND_CURRENCIES AR_GTA_TRX_HEADERS_ALL.RA_CURRENCY_CODE