AP_REPORTING_ENTITY_LINES_ALL

AP_REPORTING_ENTITY_LINES_ALL holds the line information for the tax reporting entities you define. Each tax reporting entity must have at least one line that contains the balancing segment value for the organization for which you perform your 1099 reporting. . If you define more than one organization for your company or agency, you can define tax reporting entities to handle your multi-organization 1099 reporting. You use different balancing segment values to represent the different organizations in your company or organization. . You can define a reporting entity with a single balancing segment line for each organization or you can define a reporting entity with multiple lines to combine 1099 reporting for your organizations. For multi-organization reporting entities, you define a different balancing segment value for each line; however, you cannot assign the same balancing segment value to more than one reporting entity. . This table corresponds to the Balancing Segment Values region of the Reporting Entity window.

Details

• Schema: FUSION

• Object owner: AP

• Object type: TABLE

• Tablespace: APPS_TS_TX_DATA

Primary Key

Name	Columns
AP_REPORTING_ENTITY_LINES_PK	BALANCING_SEGMENT_VALUE, ORG_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
BALANCING_SEGMENT_VALUE	VARCHAR2	25		Yes	Balancing segment value for reporting entity Accounting Flexfield(s)
TAX_ENTITY_ID	NUMBER		18	Yes	Reporting entity identifier for tax reporting.
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.
ORG_ID	NUMBER		18	Yes	Indicates the identifier of the business unit associated to the row.
OBJECT_VERSION_NUMBER	NUMBER		9	Yes	Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.

Foreign Keys

Table	Foreign Table	Foreign Key Column
AP_REPORTING_ENTITY_LINES_ALL	ap_reporting_entities_all	TAX_ENTITY_ID

Indexes

Index	Uniqueness	Columns
AP_REPORTING_ENTITY_LINES_U1	Unique	BALANCING_SEGMENT_VALUE, ORG_ID