POTRANSDTL FILE
PO Transaction Detail
REFERENCED BY
PO132 POID.1
UPDATED BY
PO885 POIJ.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
POT-COMPANY Numeric 4 POIJ.1
Company The company number represents an
established company and is entered on
all function codes.
POT-DOC-TYPE Alpha 2 POIJ.1
Document Type This field contains the type of
transaction.
PO = Receiving
IN = Receiving Inspection Rejection
RA = Receiving Adjustment
VR = Vendor Return
POT-SOURCE-DOC-A Alpha 10 (Right Justified) POIJ.1
Source Doc A This is the source document number if
the document number in the source system
is alphanumeric.
POT-DOC-NBR-NUM Numeric 10 POIJ.1
Doc Nbr Num
POT-REC-NUMBER Numeric 10 POIJ.1
Receiver Number The receiver number. Assigned when
this receiving information was added.
POT-LINE-NBR Numeric 6 POIJ.1
Line Number This field contains the line number.
POT-SEQ Numeric 3 PO885 POIJ.1
Sequence Number This field contains the record sequence
number.
POT-LOT Alpha 10 POIJ.1
Lot Number This field contains the identifier for
the homogeneous quantity of material.
POT-SUBLOT Alpha 6 POIJ.1
Sublot Number This field contains the identifier for
a detail breakdown of a lot number.
POT-SERIAL Alpha 16 POIJ.1
Serial Number
POT-BIN Alpha 7 POIJ.1
Bin This field contains a storage area for
an item or any number of items.
POT-ITEM Alpha 32 POIJ.1
Item Number This field contains the item
identifier.
POT-QUANTITY Signed 13.4 POIJ.1
Quantity This field contains the desired
quantity.
POT-SECONDARY-QTY Signed 13.4 POIJ.1
Secondary Quantity This field contains the secondary
quantity, which is tracked if the item
is a catch weight item. This quantity
is a memo quantity only. It is not used
for valuation.
POT-HOLD-FLAG Alpha 1 POIJ.1
On Hold Flag This field enables this entire lot to
be put on hold, not allowing any issues
or transfers to be made for this lot.
POT-EXPIRE-DATE Numeric 8 (yyyymmdd) POIJ.1
Expiration Date This field contains the expiration date
for an entire lot.
POT-TRANS-SEQ Numeric 6 PO885 POIJ.1
Trans Seq
POTRANSDTL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
POTSET1 COMPANY PO132 PO885
DOC-TYPE POID.1 POIJ.1
DOC-NBR-NUM
LINE-NBR
TRANS-SEQ
SEQ
POTSET2 COMPANY This index is used to group lot tracked POIJ.1
REC-NUMBER items with the same lot number across
LINE-NBR receivers, receiving adjustments, and
LOT inspection rejections for purposes of
SUBLOT lot quantity editing.
SERIAL KeyChange, Subset
DOC-TYPE Where LOT != Spaces
DOC-NBR-NUM Or SERIAL != Spaces
|
