Optional Fields in the F1001Z1 Table

The system has optional fields in the F1001Z1 table. They are not required to process multisite consolidations. The values in these fields are written to the F1001 table, but they are not used by the multisite consolidations programs.

This table lists the optional fields in the F1001Z1 table:

Field Name

Alias

Type

Length

Definition

Category Code File Sent

IACCSE

Alpha

1

Enter a value indicates whether the Multi-Site Consolidation Transfer File - Category Codes table (F1003) was created for this consolidation. Values are:

Blank or 0: The table was not created

1: The table was created.

EDI - Line Number

IAEDLN

Number

7

Not used to process consolidations.

EDI - Document Type

IAEDCT

Alpha

2

Not used to process consolidations.

Type Transaction

IATYTN

Alpha

8

Not used to process consolidations.

EDI - Translation Format

IAEDFT

Alpha

10

Not used to process consolidations.

EDI - Transmission Date

IAEDDT

Date

6

Not used to process consolidations.

EDI - Detail Lines Processed

IAEDDL

Number

5

Not used to process consolidations.

Trading Partner ID

IAPNID

Alpha

15

Not used to process consolidations.

Transmission File Status

IATRFG

Alpha

1

Not used to process consolidations.

Number of Records Transmitted

IATRSE

Number

15

Not used to process consolidations.

Date - Sent

IADTSE

Date

6

Not used to process consolidations.

Number of Records Received

IATRRC

Number

15

Not used to process consolidations.

Date - Received

IADTRI

Date

6

Not used to process consolidations.

Prior Period Adjustments

IAIN01

Alpha

1

Not used to process consolidations.

Debits = Credits

IAIN02

Alpha

1

Not used to process consolidations.

Source UDC = Target UDC

IAIN03

Alpha

1

Not used to process consolidations.

Source OBJ/Sub = Target OBJ/Sub

IAIN04

Alpha

1

Not used to process consolidations.

Accounts Last Month Not This Month

IAIN05

Alpha

1

Not used to process consolidations.

Business Units Last Month Not This Month

IAIN06

Alpha

1

Not used to process consolidations.

Accounts This Month Not Last Month

IAIN07

Alpha

1

Not used to process consolidations.

Business Units This Month Not Last Month

IAIN08

Alpha

1

Not used to process consolidations.

Integrity Control Status 9

IAIN09

Alpha

1

Not used to process consolidations.

Integrity Control Status 10

IAIN10

Alpha

1

Not used to process consolidations.

Integrity Control Status 11

IAIN11

Alpha

1

Not used to process consolidations.

Integrity Control Status 12

IAIN12

Alpha

1

Not used to process consolidations.