AMPOASTHDR

UPDATED BY
AM19.1 AM19.2 AM219 AP115 AP125 AP126
AP131 AP20.1 AP20.2 AP20.3 AP20.4 AP20.5
AP20.7 AP21.1 AP220 AP23.1 AP25.1 AP25.2
AP26.1 AP27.1 AP30.2 AP30.4 AP305 API1.1
API2.1 CX100 CX20.1 CX20.2 CX20.4 CX20.5
CX220 CX30.1 CX300 CX506 CXCP.1 DR100
IC140 IC66.1 IC83.1 MA180 MA41.1 MA41.2
MA41.4 MA41.7 MA42.1 MA42.2 MA43.1 MA43.2
MA43.3 MA43.4 MA43.6 MA43.7 MA44.1 MA44.2
MA530 MA531 MA60.2 MA60.3 MA60.5 MA61.1
MA63.1 MA65.1 MA66.2 MA67.2 MA67.3 MA68.2
MA68.3 MA68.5 MA69.1 MA70.1 MA75.1 MA80.1
MAI1.1 PD10.1 PD10.2 PD130 PD20.1 PD20.2
PD20.3 PO100 PO101 PO122 PO131 PO136
PO150 PO190 PO20.1 PO20.6 PO20.9 PO21.1
PO21.2 PO21.3 PO21.4 PO21.5 PO22.1 PO22.3
PO22.4 PO23.1 PO24.1 PO25.1 PO25.5 PO25.6
PO25.7 PO27.2 PO28.2 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 RQ10.1 RQ10.2 RQ10.4 RQ12.1
RQ13.1 RQ13.2 RQ35.1 RQ500 RQIF.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 ZW130

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
AOH-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.
...
AM19.1 AM19.2
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
API1.1 API2.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 IC140
IC66.1 IC83.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA42.1
MA42.2 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA44.1
MA44.2 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA63.1
AOH-PO-NUMBER
Element: Po Number
Alpha 14 (Right Justified)
This field contains the number representing the purchase order.
...
AM19.1 AM19.2
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
API1.1 API2.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 IC140
IC66.1 IC83.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA42.1
MA42.2 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA44.1
MA44.2 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA63.1
AOH-PO-RELEASE
Element: Po Release
Numeric 4
Used to identify a purchase order release (created from a Blanket or Standing order).
...
AM19.1 AM19.2
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
API1.1 API2.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 IC140
IC66.1 IC83.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA42.1
MA42.2 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA44.1
MA44.2 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA63.1
AOH-PO-CODE
Element: Po Code
Alpha 4
This is the purchase order code.
...
AM19.1 AM19.2
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
API1.1 API2.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 IC140
IC66.1 IC83.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA42.1
MA42.2 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA44.1
MA44.2 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA63.1
AOH-LINE-NBR
Element: Line Nbr
Numeric 6
This field contains the line number.
...
AM19.1 AM19.2
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
API1.1 API2.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 IC140
IC66.1 IC83.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA42.1
MA42.2 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA44.1
MA44.2 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA63.1
AOH-STATUS
Element: Status
Numeric 1
This field displays the status of the transaction.
0 = Unreleased
1 = Released
...
AM19.1 AM19.2
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
API1.1 API2.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 IC140
IC66.1 IC83.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA42.1
MA42.2 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA44.1
MA44.2 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA63.1
AOH-VENDOR
Element: Vendor
Alpha 9 (Right Justified)
The vendor's identification code.
...
AM19.1 AM19.2
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
API1.1 API2.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 IC140
IC66.1 IC83.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA42.1
MA42.2 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA44.1
MA44.2 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA63.1
AOH-DROPSHIP-FL
Element: Dropship Fl
Alpha 1
This flag indicates whether goods being shipped by the vendor directly to a non standard location need to have the receiving process performed.
...
AM19.1 AM19.2
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
API1.1 API2.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 IC140
IC66.1 IC83.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA42.1
MA42.2 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA44.1
MA44.2 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA63.1
AOH-PO-LINE-QTY
Element: Item Quantity
Numeric 8
The number of units that make up the asset item. Each unit of an item is exactly the same as every other unit of the item.
...
AM19.1 AM19.2
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
API1.1 API2.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 IC140
IC66.1 IC83.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA42.1
MA42.2 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA44.1
MA44.2 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA63.1
AOH-RCVD-QTY
Element: Item Quantity
Numeric 8
The number of units that make up the asset item. Each unit of an item is exactly the same as every other unit of the item.
...
AM19.1 AM19.2
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
API1.1 API2.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 IC140
IC66.1 IC83.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA42.1
MA42.2 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA44.1
MA44.2 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA63.1
AOH-RJCT-QTY
Element: Item Quantity
Numeric 8
The number of units that make up the asset item. Each unit of an item is exactly the same as every other unit of the item.
...
AM19.1 AM19.2
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
API1.1 API2.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 IC140
IC66.1 IC83.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA42.1
MA42.2 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA44.1
MA44.2 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA63.1
AOH-RTRN-QTY
Element: Item Quantity
Numeric 8
The number of units that make up the asset item. Each unit of an item is exactly the same as every other unit of the item.
...
AM19.1 AM19.2
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
API1.1 API2.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 IC140
IC66.1 IC83.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA42.1
MA42.2 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA44.1
MA44.2 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA63.1
AOH-INVC-QTY
Element: Item Quantity
Numeric 8
The number of units that make up the asset item. Each unit of an item is exactly the same as every other unit of the item.
...
AM19.1 AM19.2
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
API1.1 API2.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 IC140
IC66.1 IC83.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA42.1
MA42.2 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA44.1
MA44.2 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA63.1
AOH-CHBK-QTY
Element: Item Quantity
Numeric 8
The number of units that make up the asset item. Each unit of an item is exactly the same as every other unit of the item.
...
AM19.1 AM19.2
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
API1.1 API2.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 IC140
IC66.1 IC83.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA42.1
MA42.2 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA44.1
MA44.2 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA63.1
AOH-AM-CREATE-QTY
Element: Item Quantity
Numeric 8
The number of units that make up the asset item. Each unit of an item is exactly the same as every other unit of the item.
...
AM19.1 AM19.2
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
API1.1 API2.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 IC140
IC66.1 IC83.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA42.1
MA42.2 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA44.1
MA44.2 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA63.1
AOH-AM-DIST-QTY
Element: Item Quantity
Numeric 8
The number of units that make up the asset item. Each unit of an item is exactly the same as every other unit of the item.
...
AM19.1 AM19.2
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
API1.1 API2.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 IC140
IC66.1 IC83.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA42.1
MA42.2 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA44.1
MA44.2 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA63.1
AOH-CNCL-QTY
Element: Item Quantity
Numeric 8
The number of units that make up the asset item. Each unit of an item is exactly the same as every other unit of the item.
...
AM19.1 AM19.2
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
API1.1 API2.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 IC140
IC66.1 IC83.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA42.1
MA42.2 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA44.1
MA44.2 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA63.1


AMPOASTHDR FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
AOHSET1 COMPANY
PO-NUMBER
PO-RELEASE
PO-CODE
LINE-NBR
...
AM19.1 AM19.2
AM219 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5


AMPOASTHDR FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Ampodflts AMPODFLTS Not Required, Delete Cascades
AOH-COMPANY->AOT-COMPANY
AOH-PO-NUMBER->AOT-PO-NUMBER
AOH-PO-RELEASE->AOT-PO-RELEASE
AOH-PO-CODE->AOT-PO-CODE
AOH-LINE-NBR->AOT-LINE-NBR


AMPOASTHDR FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Ampoastdtl AMPOASTDTL
AOH-COMPANY->AOD-COMPANY
AOH-PO-NUMBER->AOD-PO-NUMBER
AOH-PO-RELEASE->AOD-PO-RELEASE
AOH-PO-CODE->AOD-PO-CODE
AOH-LINE-NBR->AOD-LINE-NBR
  AOD-DTL-SEQ-NBR


File created: Thu Jun 09 11:06:15 2016

Home
Contact Us



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