Tran Code:
Empty & there is default in DB
Batch is created in DBs.
TI assigns system’s default tran code to imported record.
|
Batch is created in DBs.
TI assigns system’s default tran code to imported record.
|
79
|
Tran Code:
Empty & no current biennium’s default
|
|
|
80
|
Tran Code:
Zero & there is default in DBs.
|
Reject entire file
No batch created in DBs.
Invalid record is searchable with: 'System Message 9: Item not found, please reenter.
'System Message 8002: Error In Field: ctrancode_2 Value: ""0"" Column 55
'System Message 8004: Data File Record/Line Number: 3 Column: 55
'System Message 8055: ========Error Processing Transaction Data Line
Valid record immediately follows invalid record is searchable with:
'Application Error: A valid AR Type must be provided for the batch before transactions can be entered.
'System Message 2: Data must be entered in this field
'System Message 8034: Error in Field: cartype_0 Value:
Remaining valid record are searchable by:
'System Message 8055: ========Error Processing Document Data Line========
'Application Error: A valid AR Type must be provided for the batch before transactions can be entered.’
'System Message 2: Data must be entered in this field
'System Message 8034: Error in Field: cartype_0 Value:
Best recognition of error is that a batch number was not assigned, indicating that a batch was not created and that the entire data file failed the import.
|
Batch is created in DBs.
Reject invalid record.
Invalid record is searchable with: 'System Message 9: Item not found, please reenter.
'System Message 8002: Error In Field: ctrancode_2 Value: ""0"" Column 54
'System Message 8004: Data File Record/Line Number: 7 Column: 54
'System Message 8055: ========Error Processing Transaction Data Line
|
81
|
Tran Code:
Invalid value: Negative
|
Reject entire file.
No batch created in DBs.
Invalid record is searchable with: 'System Message 8002: Error In Field: ctrancode_2 Value: ""-012"" Column 55
'System Message 8033: Invalid data. Value ""-012"" does not match Mask ""WWW""
'System Message 8055: ========Error Processing Transaction Data Line========
Valid record immediately follows invalid record is searchable with:
'Application Error: A valid AR Type must be provided for the batch before transactions can be entered.
'System Message 2: Data must be entered in this field
'System Message 8034: Error in Field: cartype_0 Value:
Remaining valid record are searchable by:
'System Message 8055: ========Error Processing Document Data Line========
'Application Error: A valid AR Type must be provided for the batch before transactions can be entered.’
'System Message 2: Data must be entered in this field
'System Message 8034: Error in Field: cartype_0 Value:
Best recognition of error is that a batch number was not assigned, indicating that a batch was not created and that the entire data file failed the import.
|
Batch is created.
Reject invalid record.
Invalid record is searchable with: 'System Message 8002: Error In Field: ctrancode_2 Value: ""-012"" Column 54
'System Message 8033: Invalid data. Value ""-012"" does not match Mask ""WWW""
'System Message 8055: ========Error Processing Transaction Data Line
|
82
|
Tran Code:
Invalid value: Alpha (length, character type, not in table)
|
Reject entire file
No batch is created in DBs.
Invalid record is searchable with: 'System Message 9: Item not found, please reenter.
'System Message 8002: Error In Field: ctrancode_2 Value: ""PDQ"" Column 55
'System Message 8004: Data File Record/Line Number: 3 Column: 55
'System Message 8055: ========Error Processing Transaction Data Line
Valid record immediately follows invalid record is searchable with:
'Application Error: A valid AR Type must be provided for the batch before transactions can be entered.
'System Message 2: Data must be entered in this field
'System Message 8034: Error in Field: cartype_0 Value:
Remaining valid record are searchable by:
'System Message 8055: ========Error Processing Document Data Line========
'Application Error: A valid AR Type must be provided for the batch before transactions can be entered.’
'System Message 2: Data must be entered in this field
'System Message 8034: Error in Field: cartype_0 Value:
Best recognition of error is that a batch number was not assigned, indicating that a batch was not created and that the entire data file failed the import.
|
Batch is created in DBs.
Reject invalid record.
Invalid record is searchable with: 'System Message 9: Item not found, please reenter.
'System Message 8002: Error In Field: ctrancode_2 Value: ""PDQ"" Column 54
'System Message 8004: Data File Record/Line Number: 7 Column: 54
'System Message 8055: ========Error Processing Transaction Data Line
|
83
|
Tran Code:
Invalid value: Symbols
|
Reject entire file.
No batch created in DBs.
Invalid record is searchable with: 'System Message 8002: Error In Field: ctrancode_2 Value: ""@#$"" Column 55
'System Message 8033: Invalid data. Value ""@#$"" does not match Mask ""WWW""
'System Message 8055: ========Error Processing Transaction Data Line========
Valid record immediately follows invalid record is searchable with:
'Application Error: A valid AR Type must be provided for the batch before transactions can be entered.
'System Message 2: Data must be entered in this field
'System Message 8034: Error in Field: cartype_0 Value:
Remaining valid record are searchable by:
'System Message 8055: ========Error Processing Document Data Line========
'Application Error: A valid AR Type must be provided for the batch before transactions can be entered.’
'System Message 2: Data must be entered in this field
'System Message 8034: Error in Field: cartype_0 Value:
Best recognition of error is that a batch number was not assigned, indicating that a batch was not created and that the entire data file failed the import.
|
Batch is created in DBs.
Reject invalid record.
Invalid record is searchable with: 'System Message 8002: Error In Field: ctrancode_2 Value: ""@#$"" Column 54
'System Message 8033: Invalid data. Value ""@#$"" does not match Mask ""WWW""
'System Message 8055: ========Error Processing Transaction Data Line========
|
84
|
Tran Code:
Invalid value: Length greater than 3 characters with the first 3 characters matching a value in DBs.
|
Batch is created in DBs.
Import truncates Tran code to 3 digits.
|
Batch is created in DBs.
Import truncates Tran Code to 3 digits.
|
85
|
Tran Code:
Invalid value: Length greater than 3 characters, with the first 3 characters not matching value exists in DBs.
|
Reject entire file.
No batch created in DBs.
Invalid record is searchable with: 'System Message 9: Item not found, please reenter.
'System Message 8002: Error In Field: ctrancode_2 Value: ""000"" Column 55
'System Message 8004: Data File Record/Line Number: 3 Column: 55
'System Message 8055: ========Error Processing Transaction Data Line========
Valid record immediately follows invalid record is searchable with:
'Application Error: A valid AR Type must be provided for the batch before transactions can be entered.
'System Message 2: Data must be entered in this field
'System Message 8034: Error in Field: cartype_0 Value:
Remaining valid record are searchable by:
'System Message 8055: ========Error Processing Document Data Line========
'Application Error: A valid AR Type must be provided for the batch before transactions can be entered.’
'System Message 2: Data must be entered in this field
'System Message 8034: Error in Field: cartype_0 Value:
Best recognition of error is that a batch number was not assigned, indicating that a batch was not created and that the entire data file failed the import.
|
Batch is created in DBs.
Reject invalid record.
Invalid record is searchable with: 'System Message 9: Item not found, please reenter.
'System Message 8002: Error In Field: ctrancode_2 Value: ""000"" Column 54
'System Message 8004: Data File Record/Line Number: 7 Column: 54
'System Message 8055: ========Error Processing Transaction Data Line========
|
86
|
Fund:
Empty & there is default in DBs.
|
Batch is created in DBs.
TI assigns system’s default fund to imported record.
|
Batch is created in DBs.
TI assigns system’s default fund to imported record.
|
87
|
Fund:
Empty & there is NO current biennium default in DBs.
|
Reject entire file
No batch created in DBs
Invalid record is searchable with: 'Application Error: Cant find default AFRS Code for AR Type NO and DocCat ND
'System Message 8034: Error in Field: cfund_2 Value:
'System Message 2: Data must be entered in this field
Valid record immediately follows invalid record is searchable with: 'System Message 8055: ========Error Processing Document Data Line========
'Application Error: A valid AR Type must be provided for the batch before transactions can be entered.
'System Message 2: Data must be entered in this field
'System Message 8034: Error in Field: cartype_0 Value:
Remaining valid record are searchable by:
'System Message 8055: ========Error Processing Document Data Line========
'Application Error: A valid AR Type must be provided for the batch before transactions can be entered.’
'System Message 2: Data must be entered in this field
'System Message 8034: Error in Field: cartype_0 Value:
Best recognition of error is that a batch number was not assigned, indicating that a batch was not created and that the entire data file failed the import.
|
Batch is created in DBs
Reject invalid record.
Valid records prior to invalid record have the following log: 'Application Error: Cant find default AFRS Code for AR Type NO and DocCat ND
Invalid record is searchable with: 'Application Error: Cant find default AFRS Code for AR Type NO and DocCat ND
'System Message 8034: Error in Field: cfund_2 Value:
'System Message 2: Data must be entered in this field
Valid record immediately follows invalid record is searchable with: 'System Message 8055: ========Error Processing Document Data Line
'Application Error: Cant find default AFRS Code for AR Type NO and DocCat ND
Remaining valid record are searchable by: 'Application Error: Cant find default AFRS Code for AR Type NO and DocCat ND
|
88
|
Fund:
Zero
|
Reject entire file
No batch created in DBs.
Invalid record is searchable with: 'System Message 9: Item not found, please reenter.
'System Message 8002: Error In Field: cfund_2 Value: ""0"" Column 49
'System Message 8004: Data File Record/Line Number: 3 Column: 49
'System Message 8055: ========Error Processing Transaction Data Line
Valid record immediately follows invalid record is searchable with:
'Application Error: A valid AR Type must be provided for the batch before transactions can be entered.
'System Message 2: Data must be entered in this field
'System Message 8034: Error in Field: cartype_0 Value:
Remaining valid record are searchable by:
'System Message 8055: ========Error Processing Document Data Line========
'Application Error: A valid AR Type must be provided for the batch before transactions can be entered.’
'System Message 2: Data must be entered in this field
'System Message 8034: Error in Field: cartype_0 Value:
Best recognition of error is that a batch number was not assigned, indicating that a batch was not created and that the entire data file failed the import.
|
Batch is created in DBs.
Reject invalid record.
Invalid record is searchable with: 'System Message 9: Item not found, please reenter.
'System Message 8002: Error In Field: cfund_2 Value: ""0"" Column 48
'System Message 8004: Data File Record/Line Number: 7 Column: 48
'System Message 8055: ========Error Processing Transaction Data Line========
|
89
|
Fund:
Invalid value: Negative
|
Reject entire file
No batch created in DBs.
Invalid record is searchable with: 'System Message 8002: Error In Field: cfund_2 Value: ""-543"" Column 49
'System Message 8033: Invalid data. Value ""-543"" does not match Mask ""WWW""
'System Message 8055: ========Error Processing Transaction Data Line
Valid record immediately follows invalid record is searchable with:
'Application Error: A valid AR Type must be provided for the batch before transactions can be entered.
'System Message 2: Data must be entered in this field
'System Message 8034: Error in Field: cartype_0 Value:
Remaining valid record are searchable by:
'System Message 8055: ========Error Processing Document Data Line========
'Application Error: A valid AR Type must be provided for the batch before transactions can be entered.’
'System Message 2: Data must be entered in this field
'System Message 8034: Error in Field: cartype_0 Value:
Best recognition of error is that a batch number was not assigned, indicating that a batch was not created and that the entire data file failed the import.
|
Batch is created in DBs.
Reject invalid record.
Invalid record is searchable with: 'System Message 8002: Error In Field: cfund_2 Value: ""-543"" Column 48
'System Message 8033: Invalid data. Value ""-543"" does not match Mask ""WWW""
'System Message 8055: ========Error Processing Transaction Data Line
|
90
|
Fund:
Invalid value: Alpha (length, character type, not in table)
|
Reject entire file.
No batch created in DBs.
Invalid record is searchable with: 'System Message 9: Item not found, please reenter.
'System Message 8002: Error In Field: cfund_2 Value: ""ZZZ"" Column 49
'System Message 8004: Data File Record/Line Number: 3 Column: 49
'System Message 8055: ========Error Processing Transaction Data Line
Valid record immediately follows invalid record is searchable with:
'Application Error: A valid AR Type must be provided for the batch before transactions can be entered.
'System Message 2: Data must be entered in this field
'System Message 8034: Error in Field: cartype_0 Value:
Remaining valid record are searchable by:
'System Message 8055: ========Error Processing Document Data Line========
'Application Error: A valid AR Type must be provided for the batch before transactions can be entered.’
'System Message 2: Data must be entered in this field
'System Message 8034: Error in Field: cartype_0 Value:
Best recognition of error is that a batch number was not assigned, indicating that a batch was not created and that the entire data file failed the import.
|
Batch is created in DBs.
Reject invalid record.
Invalid record is searchable with: 'System Message 9: Item not found, please reenter.
'System Message 8002: Error In Field: cfund_2 Value: ""ZZZ"" Column 48
'System Message 8004: Data File Record/Line Number: 7 Column: 48
'System Message 8055: ========Error Processing Transaction Data Line========
|
91
|
Fund:
Invalid value: Symbols
|
Reject entire file
No batch created in DBs.
Invalid record is searchable with: 'System Message 8002: Error In Field: cfund_2 Value: ""@#$"" Column 49
'System Message 8033: Invalid data. Value ""@#$"" does not match Mask ""WWW""
'System Message 8055: ========Error Processing Transaction Data Line
Valid record immediately follows invalid record is searchable with:
'Application Error: A valid AR Type must be provided for the batch before transactions can be entered.
'System Message 2: Data must be entered in this field
'System Message 8034: Error in Field: cartype_0 Value:
Remaining valid record are searchable by:
'System Message 8055: ========Error Processing Document Data Line========
'Application Error: A valid AR Type must be provided for the batch before transactions can be entered.’
'System Message 2: Data must be entered in this field
'System Message 8034: Error in Field: cartype_0 Value:
Best recognition of error is that a batch number was not assigned, indicating that a batch was not created and that the entire data file failed the import.
|
Batch is created in DBs.
Reject invalid record.
Invalid record is searchable with: 'System Message 8002: Error In Field: cfund_2 Value: ""@#$"" Column 48
'System Message 8033: Invalid data. Value ""@#$"" does not match Mask ""WWW""
'System Message 8055: ========Error Processing Transaction Data Line========
|
92
|
Fund:
Invalid value: large 543999 but with first 3 digits matching a valid value in DBs.
|
Batch is created in DBs.
Import truncates Fund to 3 digits and edit against DBs.
|
Batch is created in DBs.
Import truncates Fund to 3 digits and edit against DBs
|
93
|
Fund:
Invalid value: Numeric and Alpha (999X.45)
|
Reject entire file
No batch created in DBs.
Invalid record is searchable with: 'System Message 9: Item not found, please reenter.
'System Message 8002: Error In Field: cfund_2 Value: ""Z22"" Column 49
'System Message 8004: Data File Record/Line Number: 3 Column: 49
'System Message 8055: ========Error Processing Transaction Data Line========
Valid record immediately follows invalid record is searchable with:
'Application Error: A valid AR Type must be provided for the batch before transactions can be entered.
'System Message 2: Data must be entered in this field
'System Message 8034: Error in Field: cartype_0 Value:
Remaining valid record are searchable by:
'System Message 8055: ========Error Processing Document Data Line========
'Application Error: A valid AR Type must be provided for the batch before transactions can be entered.’
'System Message 2: Data must be entered in this field
'System Message 8034: Error in Field: cartype_0 Value:
Best recognition of error is that a batch number was not assigned, indicating that a batch was not created and that the entire data file failed the import.
|
Batch is created in DBs.
Reject invalid record.
Invalid record is searchable with: 'System Message 9: Item not found, please reenter.
'System Message 8002: Error In Field: cfund_2 Value: ""ZZ9"" Column 48
'System Message 8004: Data File Record/Line Number: 7 Column: 48
'System Message 8055: ========Error Processing Transaction Data Line========
|
|
|
94
|
Other:
Invalid File extension
File .txt
Note: Must select ‘All Files (*.*) from File Type dropdown.
|
Will import.
|
Will import.
|
95
|
Other:
Invalid File extension
File .doc
Note: Must select ‘All Files (*.*) from File Type dropdown.
|
Will import.
|
Will import.
|
96
|
Other:
Invalid File single quotes for field delimiter
|
Will not import, treats file as one record:
'System Message 2: Data must be entered in this field
'System Message 8034: Error in Field: cartype_0 Value:
|
N/A
|
97
|
Other:
Invalid File TAB for field separator
|
Will not import, treats file as one record:
'System Message 2: Data must be entered in this field
'System Message 8034: Error in Field: cartype_0 Value:
|
N/A
|
98
|
Other:
Maximum file size (32,000 characters)
|
|
|
99
|
Other:
Access file import
|
|
|
100
|
Other:
Maximum file name length
File name is 45 characters in length:
|
Reject entire file.
No batch created in DBs.
'System Message 569: Unable to open file V:\TransAction Import\long_file_name_16_901234567890123456789012345.dt.
|
N/A
|