INPUT FILE VALIDATION

Field Name

Validation

Error Message

Line

Must be unique.

Line number must be unique.

Valid values must be from 1 onwards; incremented by 1.

Line number must be in sequence.

Commitment Date

Every line must have a commitment date.

Must be in input file.

Date must be valid.

Not a valid date.

Project

Every line must have a project.

Must be in input file.

Must be in PROJ table.

Not found in PROJ table.

Alternate message displayed depending on suspense replacement option:

Not in PROJ table, replaced.

Not in PROJ table, replaced P/A/O.

Must be active.

Not active.

Not active, replaced.

Not active, replaced P/A/O.

Must allow charging.

Does not allow charges.

Does not allow charges, replaced.

Does not allow charges, replaced P/A/O.

Account

Every line must have an account.

Must be in input file.

Must be in ACCT table.

Not found in ACCT table.

Alternate message displayed depending on suspense replacement option:

Not in ACCT table, replaced.

Not in ACCT table, replaced A/O.

Not in ACCT table, replaced P/A/O.

Must be active.

Not active.

Not active, replaced.

Not active, replaced A/O.

Not active, replaced P/A/O.

Must be a detail account.

Not a detail ACCT.

Not a detail ACCT, replaced.

Not a detail ACCT, replaced A/O.

Not a detail ACCT, replaced P/A/O.

Account requires a project.

PROJ is required for this ACCT.

PROJ is required, replaced.

PROJ is required, replaced A/O.

PROJ is required, replaced P/A/O.

Account cannot have project.

A PROJ cannot be used with this ACCT.

PROJ cannot be used, replaced.

PROJ cannot be used, replaced A/O.

PROJ cannot be used, replaced P/A/O.

Not valid for AP.

Not found in ACCT Entry Groups table.

Cannot be used for APV, replaced.

Cannot be used for APV, replaced A/O.

Cannot be used for APV, replaced P/A/O.

Organization

Every line must have an organization.

Must be in input file.

Must be in ORG table.

Not found in ORG table.

Alternate message displayed depending on suspense replacement option:

Not found in ORG table, replaced.

Not found in ORG table, replaced A/O.

Not found in ORG table, replaced P/A/O.

Must be active.

Not active.

Not active, replaced.

Not active, replaced A/O.

Not active, replaced P/A/O.

Account/Organization

Acct/Org exists on ORG_ACCT table.

See AOPUTLAM. Use standard class AO validation. Either value could be replaced with suspense and revalidated.

Must be active.

Within the Period of Performance.

Project/Organization/Account

Standard Class POA validation including Project Period of Performance.

See AOPUTLAM. Use standard class POA validation. Any of the three values could be replaced with suspense and revalidated.

Project/Account

Standard Class PAG validation.

See AOPUTLAM. Use standard POA validation. Either value could be replaced with suspense and revalidated.

Project/Organization

Standard Class Proj/Org validation.

See AOPUTLAM. Use standard POA validation. Either value could be replaced with suspense and revalidated.

Reference Number 1

Must be in REF_STRUC table.

Not found in Reference Structure table.

Alternate message displayed depending on suspense replacement option:

Not in Reference Structure, replaced.

Available for data entry.

May not be used in data entry.

Cannot be used in data entry, replaced.

Valid reference 1.

This entry is not valid as a reference 1.

Invalid as a reference 1, replaced.

Reference Number 2

Must be in REF_STRUC table.

Not found in Reference Structure table.

Alternate message displayed depending on suspense replacement option:

Not in Reference Structure, replaced.

Available for data entry.

May not be used in data entry.

Cannot be used in data entry, replaced.

Valid reference 2.

This entry is not valid as a reference 2.

Invalid as a reference 2, replaced.

Commitment Amount

Every line must have a Commitment Amount.

Must be in input file.

Must be numeric.

Not numeric.

Functional Currency Code

Every line must have a Functional Currency Code.

Must be in input file.

Employee

Every line must have an Employee

Must be in input file.

Must be a valid vendor in EMPL table.

Not found in EMPL table.

Vendor

Every line must have a Vendor.

Must be in input file.

Must be a valid vendor in VEND table.

Not found in VEND table.

Payroll vendor flag cannot be set.

Flagged as a PR VEND.

Cannot be an inactive vendor.

Inactive in the Manage Vendors screen.

Last Calculated Date/Time

Every line must have a last calculated date/time.

Must be in input file.

Date/time must be valid.

Not a valid date/time.

Company

Every line must have a company.

Must be in input file.

Company must be company of currently logged in user.

Not the company of the currently logged in user.