Lawson Insight Technical Documentation |
|
POTRANSDTL
POTRANSDTL FILE
PO Transaction Detail
REFERENCED BY
PO132 POIE.1
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 API1.1 BL120
BL122 BL130 BL20.1 BL20.3 BL21.2 BL21.5
BL29.1 BL29.2 BL520 BL820 BL92.1 MA180
MA41.1 MA41.2 MA41.4 MA41.7 MA43.1 MA43.2
MA43.3 MA43.7 MA530 MA531 MA60.2 MA60.3
MA60.5 MA61.1 MA66.2 MA66.3 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 PO100 PO101 PO122 PO131 PO20.1
PO21.1 PO21.2 PO21.3 PO21.4 PO21.5 PO22.1
PO23.1 PO24.1 PO25.1 PO25.5 PO25.6 PO25.7
PO27.2 PO29.1 PO30.1 PO30.2 PO30.3 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 POD0.1
POI3.1 POID.1 POII.1 POIJ.1 RQ10.1 RQ10.2
WH20.2 WH20.7
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
POT-COMPANY Numeric 4 AP125 AP126
Element: Company Identifies the AP company if the AP131 AP20.1
resource type = V. Identifies the HR AP20.2 AP20.3
company if the resource type = E. It is AP20.4 AP20.5
blank for type A, P or Q resources. AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA180
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
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
...
POT-DOC-TYPE Alpha 2 AP125 AP126
Element: Doc Type This field contains the type of AP131 AP20.1
transaction. AP20.2 AP20.3
PO = Receiving AP20.4 AP20.5
IN = Receiving Inspection Rejection AP20.7 AP21.1
RA = Receiving Adjustment AP23.1 AP25.1
VR = Vendor Return AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA180
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
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
...
POT-SOURCE-DOC-A Alpha 10 (Right Justified) AP125 AP126
Element: Source Doc A This is the source document number if AP131 AP20.1
the document number in the source system AP20.2 AP20.3
is alphanumeric. AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA180
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
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
...
POT-DOC-NBR-NUM Numeric 10 AP125 AP126
Element: Doc Nbr Num 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
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA180
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
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
...
POT-REC-NUMBER Numeric 10 AP125 AP126
Element: Rec Number The receiver number. Assigned when AP131 AP20.1
this receiving information was added. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA180
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
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
...
POT-LINE-NBR Numeric 6 AP125 AP126
Element: Line Nbr This field contains the line number. 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
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA180
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
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
...
POT-LOT Alpha 10 AP125 AP126
Element: Lot This field contains the identifier for AP131 AP20.1
the homogeneous quantity of material. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA180
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
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
...
POT-SUBLOT Alpha 6 AP125 AP126
Element: Sublot This field contains the identifier for AP131 AP20.1
a detail breakdown of a lot number. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA180
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
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
...
POT-SERIAL Alpha 16 AP125 AP126
Element: Serial 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
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA180
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
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
...
POT-BIN Alpha 7 AP125 AP126
Element: Bin This field contains a storage area for AP131 AP20.1
an item or any number of items. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA180
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
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
...
POT-ITEM Alpha 32 AP125 AP126
Element: Item This field contains the item AP131 AP20.1
identifier. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA180
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
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
...
POT-QUANTITY Signed 13.4 AP125 AP126
Element: Quantity This field contains the desired AP131 AP20.1
quantity. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA180
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
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
...
POT-SECONDARY-QTY Signed 13.4 AP125 AP126
Element: Secondary Qty This field contains the secondary AP131 AP20.1
quantity, which is tracked if the item AP20.2 AP20.3
is a catch weight item. This quantity AP20.4 AP20.5
is a memo quantity only. It is not used AP20.7 AP21.1
for valuation. AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA180
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
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
...
POT-HOLD-FLAG Alpha 1 AP125 AP126
Element: Hold Flag This field enables this entire lot to AP131 AP20.1
be put on hold, not allowing any issues AP20.2 AP20.3
or transfers to be made for this lot. AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA180
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
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
...
POT-EXPIRE-DATE Numeric 8 (yyyymmdd) AP125 AP126
Element: Expire Date This field contains the expiration date AP131 AP20.1
for an entire lot. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA180
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
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
...
POT-TRANS-SEQ Numeric 6 AP125 AP126
Element: Trans Seq 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
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA180
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
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
...
POTRANSDTL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
POTSET1 COMPANY AP125 AP126
DOC-TYPE AP131 AP20.1
DOC-NBR-NUM AP20.2 AP20.3
LINE-NBR AP20.4 AP20.5
TRANS-SEQ AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA180
...
POTSET2 COMPANY KeyChange, Subset AP125 AP126
REC-NUMBER Where LOT != Spaces AP131 AP20.1
LINE-NBR Or SERIAL != Spaces AP20.2 AP20.3
LOT AP20.4 AP20.5
SUBLOT AP20.7 AP21.1
SERIAL AP23.1 AP25.1
DOC-TYPE AP25.2 AP26.1
DOC-NBR-NUM AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA180
...
|