Required Fields in the F1001Z1 Table
The system has required fields in the F1001Z1 table. In some fields, blank is a value.
The system uses some of these fields to identify or control the transfer of consolidation information from the F1001Z1 table to the Multi-Site Consolidation Transfer File Header table (F1001). Values in the other fields are written to the F1001 table.
This table lists the required fields in the F1001Z1 table:
Field Name |
Alias |
Type |
Length |
Definition |
---|---|---|---|---|
EDI - User ID |
IAEDUS |
Alpha |
10 |
Enter the user ID of the person who is running the process or the person who is to receive workflow messages about the transfer. This field, with IAEDBT and IAEDTN, uniquely identifies a specific transaction. |
EDI - Batch Number |
IAEDBT |
Alpha |
15 |
Enter a number that groups transactions for processing. This field, with IAEDUS and IAEDTN, uniquely identifies a specific transaction. |
EDI - Transaction Number |
IAEDTN |
Alpha |
22 |
Enter a number that identifies a transaction. This field, with the SZRC5 from the F1002Z1, uniquely identifies a specific line of a specific transaction. This field, with IAEDUS and IAEDBT, uniquely identifies a specific transaction. |
Direction Indicator |
IADRIN |
Alpha |
1 |
Enter a value that indicates that the record was written by an external system. The value in this field must be 1 for inbound transactions. |
Transaction Action |
IATNAC |
Alpha |
1 |
Enter A for transactions to be processed. No other values are valid. |
EDI - Successfully Processed |
IAEDSP |
Alpha |
1 |
Leave this field blank because the system populates it. The value N indicates that the transaction was not processed or was processed in error. After the transaction is successfully processed, the system changes the value in this field to Y. |
Consolidation Name |
IACNAM |
Alpha |
3 |
Enter the name of the consolidation. This value must exist in UDC table. |
Period Number - General Ledger |
IAPN |
Number |
2 |
Enter the general ledger period number of the transaction. |
Fiscal Year |
IAFY |
Number |
2 |
Enter the last two digits of the fiscal year. |
Century |
IACTRY |
Number |
2 |
The first two digits of the fiscal year. |
Ledger Type |
IALT |
Alpha |
2 |
Enter the ledger type of the transaction. This ledger type must exist in UDC 09/LT. If you leave this field blank, the system uses ledger type AA. |
Document Company |
IACO |
Alpha |
5 |
Enter the company of the transaction. This company must exist in the F0010 table. |