ITEMSRC

REFERENCED BY
AP300


UPDATED BY
CX205 DR100 IC10.2 IC12.1 IC12.2 IC125
IC130 IC140 IC141 IC142 IC175 IC182
IC211 IC225 IC226 IC227 IC270 IC281
IC282 IC283 IC285 IC320 IC330 IC331
IC36.1 IC511 IC520 IC521 IC522 IC523
IC524 IC525 IC526 IC527 IC598 IC66.1
IC81.1 IC812 IC82.1 IC83.1 IC84.1 IC84.2
IC840 PC120 ZC522 PO16.1 PO20.1 PO20.9
PO21.1 PO21.2 PO21.3 PO21.4 PO21.5 PO23.1
PO27.2 PO520 PO54.5 POII.1 POIJ.1 RQ10.1
RQ10.3 RQ10.4 RQ11.1 RQ35.1 RQ500 RQIC.1
RQID.1 RQIF.1 RQIG.1 RQIH.1 RQIJ.1 WH20.2
WH20.7

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ITM-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.
IC10.2 IC12.2
IC320 IC331
IC81.1 IC812
IC82.1 IC840
ITM-LOCATION
Element: Location
Alpha 5
This field contains a valid stocking location within the company inventory.
IC10.2 IC12.2
IC320 IC331
IC81.1 IC812
IC82.1 IC840
ITM-ITEM
Element: Item
Alpha 32
This field contains the item identifier.
IC10.2 IC12.2
IC331 IC81.1
IC812 IC82.1
IC840
ITM-REPLENISH-PRI
Element: Replenish Pri
Numeric 6
Replenishment Priority. A priority of 1 is the top priority.
IC10.2 IC12.2
IC331 IC81.1
IC812 IC82.1
IC840
ITM-VENDOR
Element: Vendor
Alpha 9 (Right Justified)
The vendor's identification code.
IC10.2 IC12.2
IC320 IC330
IC331 IC81.1
IC812 IC82.1
IC840
ITM-PURCH-FR-LOC
Element: Purch Fr Loc
Alpha 4
The vendor's purchase from location.
IC10.2 IC12.2
IC330 IC331
IC81.1 IC812
IC82.1 IC840
ITM-REPL-FROM-CO
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.
IC10.2 IC12.2
IC330 IC331
IC81.1 IC812
IC82.1 IC840
ITM-REPL-FROM-LOC
Element: Location
Alpha 5
This field contains a valid stocking location within the company inventory.
IC10.2 IC12.2
IC330 IC331
IC81.1 IC812
IC82.1 IC840
ITM-REPL-FROM-BIN
Element: Bin
Alpha 7
This field contains a storage area for an item or any number of items.
IC10.2 IC12.2
IC330 IC331
IC81.1 IC812
IC82.1 IC840


ITEMSRC FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ITMSET1 COMPANY
LOCATION
ITEM
REPLENISH-PRI
...
CX205 DR100
IC10.2 IC12.1
IC12.2 IC125
IC130 IC140
IC141 IC142
IC175 IC182
IC211 IC225
IC226 IC227
IC270 IC281
IC282 IC283
IC285 IC320
IC330 IC331
IC36.1 IC511
IC520 IC521
IC522 IC523
ITMSET2 REPL-FROM-CO
REPL-FROM-LOC
COMPANY
LOCATION
ITEM
REPLENISH-PRI
IC12.1 IC12.2
IC330 IC331
ITMSET3 VENDOR
PURCH-FR-LOC
COMPANY
LOCATION
ITEM
REPLENISH-PRI
KeyChange
IC12.2 IC330
ITMSET4 COMPANY
LOCATION
VENDOR
ITEM
PURCH-FR-LOC
KeyChange, Subset
WhereVENDOR !=Spaces
AP300 IC330
ITMSET5 COMPANY
LOCATION
ITEM
VENDOR
PURCH-FR-LOC
KeyChange, Subset
WhereVENDOR !=Spaces
IC330


ITEMSRC FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Apcompany APCOMPANY Required
When ITM-VENDOR !=Spaces
ITM-COMPANY->CPY-COMPANY
Company ICCOMPANY Required
ITM-COMPANY->ICC-COMPANY
Gl Company GLSYSTEM Required
ITM-COMPANY->GLS-COMPANY
Itemmast ITEMMAST Required
ICC-ITEM-GROUP->ITE-ITEM-GROUP
ITM-ITEM->ITE-ITEM
Location ICLOCATION Required
ITM-COMPANY->ICL-COMPANY
ITM-LOCATION->ICL-LOCATION
Procuregrp PROCUREGRP Required
ICC-ITEM-GROUP->PCG-ITEM-GROUP
Repl From Bin ICBIN Required
ITM-REPL-FROM-CO->ICB-COMPANY
ITM-REPL-FROM-LOC->ICB-LOCATION
ITM-REPL-FROM-BIN->ICB-BIN
Repl Itemloc ITEMLOC Not Required
ITM-REPL-FROM-CO->ITL-COMPANY
ITM-REPL-FROM-LOC->ITL-LOCATION
ITM-ITEM->ITL-ITEM
Vendloc APVENLOC Required
When ITM-VENDOR !=Spaces
CPY-VENDOR-GROUP->VLO-VENDOR-GROUP
ITM-VENDOR->VLO-VENDOR
ITM-PURCH-FR-LOC->VLO-LOCATION-CODE
Vendmast APVENMAST Required
When ITM-VENDOR !=Spaces
CPY-VENDOR-GROUP->VEN-VENDOR-GROUP
ITM-VENDOR->VEN-VENDOR
Vendorgroup APVENGROUP Required
When ITM-VENDOR !=Spaces
CPY-VENDOR-GROUP->VGP-VENDOR-GROUP


ITEMSRC FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Poitemven POITEMVEN
PCG-PROCURE-GROUP->PIV-PROCURE-GROUP
ITM-ITEM->PIV-ITEM
ITM-VENDOR->PIV-VENDOR
  PIV-VEN-ITEM


File created: Thu Jun 09 11:17:23 2016

Home
Contact Us



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