ICICRAUDIT

UPDATED BY
AP125 AP126 AP131 AP20.1 AP20.2 AP20.3
AP20.4 AP20.5 AP20.7 AP21.1 AP23.1 AP25.1
AP25.2 AP26.1 AP27.1 AP30.4 AP510 API1.1
API2.1 CX100 CX20.1 CX20.2 CX20.4 CX20.5
CX220 CX30.1 CX300 CX506 CXCP.1 DR100
IC12.1 IC140 IC141 IC142 IC145 IC175
IC195 IC20.1 IC20.2 IC21.1 IC21.2 IC22.1
IC22.2 IC23.1 IC23.2 IC24.1 IC24.2 IC243
IC25.1 IC28.1 IC300 IC330 IC500 IC64.1
IC64.2 IC64.3 IC64.4 IC64.5 IC64.6 IC64.7
IC64.8 IC64.9 IC66.1 IC812 IC820 IC83.1
MA180 MA278 MA41.1 MA41.2 MA41.4 MA41.7
MA42.2 MA43.2 MA43.7 MA44.1 MA44.2 MA53.1
MA530 MA531 MA60.2 MA60.3 MA60.5 MA61.1
MA66.2 MA67.2 MA67.3 MA68.2 MA68.3 MA68.5
MA70.1 MA75.1 MA80.1 MAI1.1 PD10.1 PD10.2
PD130 PD20.1 PD20.2 PD20.3 PD570 PO04.1
PO04.2 PO10.1 PO10.2 PO100 PO101 PO115
PO120 PO122 PO131 PO132 PO136 PO15.1
PO15.2 PO15.4 PO150 PO17.1 PO190 PO20.1
PO20.6 PO20.9 PO204 PO21.1 PO21.2 PO21.3
PO21.4 PO21.5 PO22.1 PO22.3 PO22.4 PO220
PO222 PO224 PO225 PO229 PO23.1 PO230
PO234 PO24.1 PO25.1 PO25.5 PO25.6 PO25.7
PO251 PO26.3 PO26.7 PO26.9 PO27.2 PO27.3
PO27.4 PO275 PO276 PO277 PO28.2 PO280
PO29.1 PO30.1 PO30.2 PO30.3 PO30.4 PO300
PO31.1 PO31.2 PO32.2 PO32.4 PO33.1 PO34.1
PO35.1 PO36.1 PO36.2 PO38.1 PO39.1 PO39.2
PO44.1 PO50.1 PO52.1 PO520 PO536 PO54.5
POCP.1 POI3.1 POID.1 POII.1 POIJ.1 RQ01.1
RQ10.1 RQ10.2 RQ10.3 RQ10.4 RQ10.5 RQ11.1
RQ12.1 RQ13.1 RQ13.2 RQ35.1 RQ44.1 RQ500
RQ810 RQIB.1 RQIF.1 RQII.1 RQIJ.1 WH130
WH132 WH190 WH20.2 WH20.7 WH222 WH30.1
WH30.2 WH30.3 WH30.4 WH31.1 WH31.2 WH31.3
WH31.4 WH32.1 WH32.2 WH32.3 WH32.4 WH32.5
WH33.1 WH33.2 WH33.3 WH33.4 WH33.5 WH33.6
WH33.8 WH33.9 WH34.1 WH34.2 WH34.3 WH34.4
WH40.1 WH40.2 WH520 WH830 IC95.4

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
IRA-COMPANY
Element: Company		Numeric 4
 ...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC140
IC141 IC142
IC145 IC175
IC20.1 IC20.2
IC21.1 IC21.2
IC22.1 IC22.2
IC23.1 IC23.2
IC24.1 IC24.2
IC243 IC25.1
IC28.1 IC300
IC330 IC500
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IRA-LOCATION
Element: Location		Alpha 5
 ...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC140
IC141 IC142
IC145 IC175
IC20.1 IC20.2
IC21.1 IC21.2
IC22.1 IC22.2
IC23.1 IC23.2
IC24.1 IC24.2
IC243 IC25.1
IC28.1 IC300
IC330 IC500
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IRA-ITEM
Element: Item		Alpha 32
 ...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC140
IC141 IC142
IC145 IC175
IC20.1 IC20.2
IC21.1 IC21.2
IC22.1 IC22.2
IC23.1 IC23.2
IC24.1 IC24.2
IC243 IC25.1
IC28.1 IC300
IC330 IC500
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IRA-DOCUMENT
Element: Document		Alpha 10 (Right Justified)
 ...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC140
IC141 IC142
IC145 IC175
IC20.1 IC20.2
IC21.1 IC21.2
IC22.1 IC22.2
IC23.1 IC23.2
IC24.1 IC24.2
IC243 IC25.1
IC28.1 IC300
IC330 IC500
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IRA-DOC-TYPE
Element: Doc Type		Alpha 2

AJ = Adjustment
PI = Physical Inventory Adjustment
PO = PO Receiving
RC = Receipt
RT = Receiving Transfer
SH = Shipment
RR = Requisition Return
VI = Vendor Return Adj to Inventory
CR = Customer Return		 ...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC140
IC141 IC142
IC145 IC175
IC20.1 IC20.2
IC21.1 IC21.2
IC22.1 IC22.2
IC23.1 IC23.2
IC24.1 IC24.2
IC243 IC25.1
IC28.1 IC300
IC330 IC500
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IRA-SYSTEM-CD
Element: System Cd		Alpha 2

IC = Inventory Control
PO = Purchase Order
OE = Order Entry
RQ = Requisitions
WO = Work Order		 ...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC140
IC141 IC142
IC145 IC175
IC20.1 IC20.2
IC21.1 IC21.2
IC22.1 IC22.2
IC23.1 IC23.2
IC24.1 IC24.2
IC243 IC25.1
IC28.1 IC300
IC330 IC500
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IRA-LINE-NBR
Element: Line Nbr		Numeric 6
 ...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC140
IC141 IC142
IC145 IC175
IC20.1 IC20.2
IC21.1 IC21.2
IC22.1 IC22.2
IC23.1 IC23.2
IC24.1 IC24.2
IC243 IC25.1
IC28.1 IC300
IC330 IC500
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IRA-COMPONENT-SEQ
Element: Seq		Numeric 3
This field contains the component sequence number. 		...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC140
IC141 IC142
IC145 IC175
IC20.1 IC20.2
IC21.1 IC21.2
IC22.1 IC22.2
IC23.1 IC23.2
IC24.1 IC24.2
IC243 IC25.1
IC28.1 IC300
IC330 IC500
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IRA-DATE
Element: Date		Numeric 8 (yyyymmdd)
 ...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC140
IC141 IC142
IC145 IC175
IC20.1 IC20.2
IC21.1 IC21.2
IC22.1 IC22.2
IC23.1 IC23.2
IC24.1 IC24.2
IC243 IC25.1
IC28.1 IC300
IC330 IC500
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IRA-TIME
Element: Time		Numeric 8
 ...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC140
IC141 IC142
IC145 IC175
IC20.1 IC20.2
IC21.1 IC21.2
IC22.1 IC22.2
IC23.1 IC23.2
IC24.1 IC24.2
IC243 IC25.1
IC28.1 IC300
IC330 IC500
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IRA-FLD-NBR
Element: Fld Nbr		Numeric 4
 ...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC140
IC141 IC142
IC145 IC175
IC20.1 IC20.2
IC21.1 IC21.2
IC22.1 IC22.2
IC23.1 IC23.2
IC24.1 IC24.2
IC243 IC25.1
IC28.1 IC300
IC330 IC500
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IRA-BEFORE-IMAGE
Element: Field Val		Alpha 35
 ...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC140
IC141 IC142
IC145 IC175
IC20.1 IC20.2
IC21.1 IC21.2
IC22.1 IC22.2
IC23.1 IC23.2
IC24.1 IC24.2
IC243 IC25.1
IC28.1 IC300
IC330 IC500
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IRA-AFTER-IMAGE
Element: Field Val		Alpha 35
This field contains the field image after the change. 		...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC140
IC141 IC142
IC145 IC175
IC20.1 IC20.2
IC21.1 IC21.2
IC22.1 IC22.2
IC23.1 IC23.2
IC24.1 IC24.2
IC243 IC25.1
IC28.1 IC300
IC330 IC500
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IRA-OPERATOR
Element: Operator		Alpha 10
 ...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC140
IC141 IC142
IC145 IC175
IC20.1 IC20.2
IC21.1 IC21.2
IC22.1 IC22.2
IC23.1 IC23.2
IC24.1 IC24.2
IC243 IC25.1
IC28.1 IC300
IC330 IC500
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IRA-DESCRIPTION
Element: Description		Alpha 30 (Lower Case)
 ...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC140
IC141 IC142
IC145 IC175
IC20.1 IC20.2
IC21.1 IC21.2
IC22.1 IC22.2
IC23.1 IC23.2
IC24.1 IC24.2
IC243 IC25.1
IC28.1 IC300
IC330 IC500
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IRA-AUDIT-ACTION
Element: Audit Action		Alpha 1

A = Add
C = Change
D = Delete		 ...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC140
IC141 IC142
IC145 IC175
IC20.1 IC20.2
IC21.1 IC21.2
IC22.1 IC22.2
IC23.1 IC23.2
IC24.1 IC24.2
IC243 IC25.1
IC28.1 IC300
IC330 IC500
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8


ICICRAUDIT FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
IRASET1 COMPANY
LOCATION
ITEM
DOCUMENT
DOC-TYPE
SYSTEM-CD
LINE-NBR
COMPONENT-SEQ
DATE*
TIME*
FLD-NBR
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100


ICICRAUDIT FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Iccompany ICCOMPANY Required
IRA-COMPANY->ICC-COMPANY
Iclocation ICLOCATION Required
IRA-COMPANY->ICL-COMPANY
IRA-LOCATION->ICL-LOCATION
Icreceipts ICRECEIPTS Required
IRA-COMPANY->ICR-COMPANY
IRA-LOCATION->ICR-LOCATION
IRA-ITEM->ICR-ITEM
IRA-DOCUMENT->ICR-DOCUMENT
IRA-DOC-TYPE->ICR-DOC-TYPE
IRA-SYSTEM-CD->ICR-SYSTEM-CD
IRA-LINE-NBR->ICR-LINE-NBR
IRA-COMPONENT-SEQ->ICR-COMPONENT-SEQ
Itemloc ITEMLOC Required
IRA-COMPANY->ITL-COMPANY
IRA-LOCATION->ITL-LOCATION
IRA-ITEM->ITL-ITEM
Itemmast ITEMMAST Required
ICC-ITEM-GROUP->ITE-ITEM-GROUP
IRA-ITEM->ITE-ITEM

File created: Thu Jun 09 02:18:39 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.