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. |