The Item/Item Location Audit file is created as a result of choosing the
audit options in IC00.1 (Corporate Item Group) and/or IC01.1 (Company). When
the options are selected, the file is updated whenever a change is made to
either the Item Master or the Item Location Master file.
| FIELD NAME |
DESCRIPTION/VALID VALUES |
UPDATED BY |
IAU-ITEM-GROUP
Element: Item Group | Alpha 5
This field contains the identifier for
a group of items that can be shared by
one or more companies.
|
|
IAU-COMPANY
Element: Company | Numeric 4
Identifies the AP company if the
resource type = V. Identifies the HR
company if the resource type = E. It is
blank for type A, P or Q resources.
|
|
IAU-LOCATION
Element: Location | Alpha 5
This field contains a valid stocking
location within the company inventory.
|
|
IAU-ITEM
Element: Item | Alpha 32
This field contains the item's
identifier.
|
|
IAU-GL-CATEGORY
Element: Gl Category | Alpha 4
|
|
IAU-DATE
Element: Date | Numeric 8 (yyyymmdd)
This field contains the system date
when the audit record was created.
|
|
IAU-TIME
Element: Time | Numeric 8
This field contains the system time
when the audit record was created.
|
|
IAU-FLD-NBR
Element: Fld Nbr | Numeric 4
This field contains a unique number
assigned to a field that identifies the
description of the field.
|
|
IAU-BEFORE-IMAGE
Element: Description3 | Alpha 350 (Lower Case)
This field contains the field image
before the change.
|
|
IAU-AFTER-IMAGE
Element: Description3 | Alpha 350 (Lower Case)
This field contains the field image
after the change.
|
|
IAU-DB-FILE
Element: Db File | Alpha 3
This field identifies which file is
being maintained by this audit record.
ITE = Item Master File (ITEMMAST)
ITL = Item Location File (ITEMLOC)
ITM = Item Source File (ITEMSRC)
ICA = GL Category File (ICCATEGORY)
ICB = IC Bin (ICBIN)
BGD = Bin Group Detail (BINGRPDTL)
ITG = Item Group File (ITEMGROUP)
ICC = IC Company File (ICCOMPANY) |
|
IAU-OPERATOR-ID
Element: Operator | Alpha 10
This field contains the terminal sign
on when this update was performed to the
database.
|
|
IAU-FLD-DESC
Element: Fld Desc | Derived
|
|
IAU-BIN-GROUP
Element: Bin Group | Alpha 7
|
|
IAU-BIN
Element: Bin | Alpha 7
|
|
RELATION
NAME |
RELATED FILE |
INTEGRITY RULES / FIELD MATCH |
| Iccategory |
ICCATEGORY |
Not Required
| Valid When | | IAU-GL-CATEGORY | != | Spaces | |
| IAU-COMPANY | -> | ICA-COMPANY |
| IAU-LOCATION | -> | ICA-LOCATION |
| IAU-GL-CATEGORY | -> | ICA-GL-CATEGORY |
|
| Iccompany |
ICCOMPANY |
Required
| When | | IAU-COMPANY | != | Zeroes | |
|
| Icdict |
ICDICT |
Required
|
| Itemgroup |
ITEMGROUP |
Required
| When | | IAU-ITEM-GROUP | != | Spaces | |
| IAU-ITEM-GROUP | -> | ITG-ITEM-GROUP |
|
| Itemloc |
ITEMLOC |
Not Required
| Valid When | | IAU-COMPANY | != | Zeroes | |
| And | | IAU-GL-CATEGORY | = | Spaces | |
| IAU-COMPANY | -> | ITL-COMPANY |
| IAU-ITEM | -> | ITL-LOCATION |
| IAU-ITEM | -> | ITL-ITEM |
|
| Itemmast |
ITEMMAST |
Not Required
| Valid When | | IAU-ITEM-GROUP | != | Spaces | |
| IAU-ITEM-GROUP | -> | ITE-ITEM-GROUP |
| IAU-ITEM | -> | ITE-ITEM |
|
| Itemmast2 |
ITEMMAST |
Not Required
| Valid When | | IAU-COMPANY | != | Zeroes | |
| And | | IAU-GL-CATEGORY | = | Spaces | |
| ICC-ITEM-GROUP | -> | ITE-ITEM-GROUP |
| IAU-ITEM | -> | ITE-ITEM |
|
| Location |
ICLOCATION |
Required
| IAU-COMPANY | -> | ICL-COMPANY |
| IAU-LOCATION | -> | ICL-LOCATION |
|
