| FIELD NAME |
DESCRIPTION/VALID VALUES |
UPDATED BY |
POR-COMPANY
Element: Company | Numeric 4
The company number.
|
|
POR-REC-NUMBER
Element: Rec Number | Numeric 10
The receiver number. Assigned when
this receiving information was added.
|
|
POR-REFERENCE-NO
Element: Upn2 Nbr | Alpha 25 (Right Justified)
|
|
POR-PO-NUMBER
Element: Po Number | Alpha 14 (Right Justified)
This field contains the number
representing the purchase order.
|
|
POR-PO-RELEASE
Element: Po Release | Numeric 4
Used to identify a purchase order
release (created from a Blanket or
Standing order).
|
|
POR-PO-CODE
Element: Po Code | Alpha 4
This is the purchase order code.
|
|
POR-LOCATION
Element: Location | Alpha 5
This field contains a valid stock
location within the company inventory.
|
|
POR-PO-LOCATION
Element: Location | Alpha 5
The purchase order and/or inventory
control receiving location for this
receiver.
|
|
POR-OPER-ID
Element: Operator | Alpha 10
Unique identification code that defines
who is entering the receiver.
|
|
POR-BUYER-CODE
Element: Buyer | Alpha 3
|
|
POR-BOL-NBR
Element: Bol Nbr | Alpha 22
The bill of lading number assigned to
this receiver.
|
|
POR-REC-DATE
Element: Date | Numeric 8 (yyyymmdd)
The date the items were received.
|
|
POR-CARRIER
Element: Vendor | Alpha 9 (Right Justified)
The carrier ID must be a valid vendor
ID.
|
|
POR-VENDOR
Element: Vendor | Alpha 9 (Right Justified)
The vendor's identification code.
|
|
POR-PURCH-FR-LOC
Element: Purch Fr Loc | Alpha 4
The vendor's purchase from location.
|
|
POR-STATUS
Element: Status | Numeric 1
The current status of this receiver.
0 = Unreleased
1 = Released
5 = Ready to Archive
7 = Drop Ship
9 = Archived / Closed |
|
POR-LOGGED-FLAG
Element: Logged Flag | Alpha 1
If set to "Y", this field indicates the
receiving or receiving adjustment log
has been run against this record in a
print all unprinted transactions mode.
Y = Yes
N = No |
|
POR-REPRINT-REC-FL
Element: Reprint Rec Fl | Alpha 1
Y = Reprint Receiver
N = Do Not Reprint Receiver |
|
POR-ACTUAL-TIME
Element: Actual Time | Numeric 4
This is the actual time the receiver
was entered into the system. System
time defaults if one was not entered.
|
|
POR-ERS-STATUS
Element: Ers Status | Numeric 1
The status of the receipt in the
Evaluated Receipts Settlement process.
1 = Vendor to Invoice
2 = Invoice From Receipt
3 = Invoice Pending
4 = Invoice In Process
5 = Invoice Complete
6 = Invoice Complete - Errors |
|
POR-INVOICE
Element: Invoice | Alpha 22
Used to identify the invoice created
from this receipt in the Evaluated
Receipts Settlement process.
|
|
POR-INVC-REF-TYPE
Element: Invc Ref Type | Alpha 2
Indicates the type of number the vendor
is providing to reference the invoice.
BM = Bill of Lading
IN = Invoice
OW = Service Order Number
PL = Packing List Number
PO = PO Number
VN = Vendor Order
WO = Work Order
WP = Warehouse Pick Ticket
ZZ = Mutually Defined |
|
POR-COMMENT
Element: Comment | Alpha 40 (Lower Case)
Occurs 5 Times
This field contains comments that can
optionally be printed on the vendor
remittance or used internally.
|
|
POR-PRINT-CODE
Element: Print Code | Alpha 1
This field contains the print code,
which defines where comments are
displayed or printed.
A = All
C = Check (Cheque)
D = Display and Print
N = Notation Only |
|
POR-MATCH-AMT
Element: Intl Amt | Signed 18.2
The amount of the receipt.
|
|
POR-MATCH-AMT-TOT
Element: Intl Amt | Signed 18.2
The amount matched on the receipt
|
|
POR-MATCH-REF-NBR
Element: Match Ref Nbr | Alpha 22
|
|
POR-CURRENCY-CODE
Element: Currency Code | Alpha 5
This field contains the company base
currency code established in Company
(GL10.1 ).
|
|
POR-PROCESS-LEVEL
Element: Process Level | Alpha 5
This field contains the process level,
which is the reporting hierarchy below
company.
|
|
POR-REC-CNV-RATE
Element: Ent Cnv Rate | Signed 14.7
Currency conversion rate at Purchase
Order entry time.
|
|
POR-TERMS-CD
Element: Term Code | Alpha 5
A user-defined code representing a
method of determining invoice due and
discount dates.
|
|
POR-SHIP-TO-ARRIVE
Element: Date | Numeric 8 (yyyymmdd)
This field displays the system date
when this was created.
|
|
POR-MTCH-PRPY-FL
Element: Mtch Prpy Fl | Alpha 1
This field will be populated from the
INVOICE file if the invoice is
INVOICE-TYPE R for Match Prepayment.
When the receipt is entered or
interfaced the same firled on the
receipt record will be populated in
oreder to note that it will be matched
to a match prepayment invoice.
" " = No Option
R = Invoice Type Match Prepay |
|
POR-PO-AOC-TOTAL
Element: Intl Amt | Signed 18.2
|
|
POR-HASH-QTY
Element: Hash Qty | Signed 15.4
This is the total of the goods quantity
on the invoice. This field will be used
to match on quantity.
|
|
POR-HASH-QTY-MATCH
Element: Hash Qty Match | Signed 15.4
This is the total Qty matched from this
receipt.
|
|
POR-XREF-VENDOR
Element: Xref Vendor | Alpha 9 (Right Justified)
This is a vendor that is supported on a
system outside Lawson. When records are
interfaces we will maintain this vendor
on the file but we will use the Lawson
vendor while in the lawson application.
|
|
POR-RETAIL-FLAG
Element: Retail Flag | Numeric 1
|
|
POR-CREATED-BY
Element: Operator | Alpha 10
|
|
POR-LAST-UPDT-DATE
Element: Date | Numeric 8 (yyyymmdd)
|
|
POR-LAST-UPDT-TIME
Element: Time | Numeric 8
|
|
POR-LAST-UPDATE-BY
Element: Operator | Alpha 10
|
|
POR-REL-OPER-ID
Element: Operator | Alpha 10
|
|
POR-FREIGHT-TOT
Element: Freight Total | Signed 18.2
|
|
POR-INSURANCE-TOT
Element: Insurance Tot | Signed 18.2
|
|
POR-CSTMS-TOT
Element: Cstms Total | Signed 18.2
|
|
POR-OTHER-AOC-TOT
Element: Other Aoc Tot | Signed 18.2
|
|
POR-GLBL-DOC-TYPE
Element: Glbl Doc Type | Alpha 10
|
|
POR-TEMP-HOLD
Element: Temp Hold | Alpha 1
A = Approved by Engine
S = Sent for Approval |
|
| NAME |
KEY FIELDS |
DESCRIPTION / SUBSET CONDITION |
USED IN |
| PORSET1 |
COMPANY
REC-NUMBER*
|
|
|
| PORSET10 |
COMPANY
VENDOR
MATCH-REF-NBR
REC-NUMBER
|
|
KeyChange, Subset |
| Where | | MATCH-REF-NBR |
!= | Spaces | |
|
|
| PORSET11 |
COMPANY
REFERENCE-NO
REC-NUMBER
|
|
KeyChange, Subset |
| Where | | REFERENCE-NO |
!= | Spaces | |
|
|
| PORSET12 |
COMPANY
REC-NUMBER
REC-DATE
LAST-UPDT-DATE
STATUS
|
|
|
| PORSET2 |
COMPANY
STATUS
REC-DATE
REC-NUMBER
|
|
|
| PORSET3 |
COMPANY
PO-CODE
PO-NUMBER
PO-RELEASE
PO-LOCATION
REC-NUMBER
|
|
|
| PORSET4 |
COMPANY
LOCATION
REC-NUMBER
|
|
KeyChange, Subset |
| Where | | STATUS |
= | Zeroes | |
|
|
| PORSET5 |
COMPANY
PO-CODE
PO-NUMBER
BOL-NBR
OPER-ID
BUYER-CODE
CARRIER
REC-NUMBER
|
|
|
| PORSET6 |
COMPANY
LOCATION
REC-DATE*
REC-NUMBER
|
|
|
| PORSET7 |
COMPANY
VENDOR
REC-NUMBER
|
|
KeyChange, Subset |
| Where | | ERS-STATUS |
= | 3 | |
|
|
| PORSET8 |
COMPANY
VENDOR
INVOICE
|
|
KeyChange, Subset |
| Where | | INVOICE |
!= | Spaces | |
|
|
| PORSET9 |
COMPANY
VENDOR
PO-CODE
PO-NUMBER
PO-RELEASE
LOCATION
REC-NUMBER
|
|
KeyChange, Subset |
| Where | ( | STATUS |
= | 1 | ) |
| Or | ( | STATUS |
= | 4 | ) |
|
|
