DSSO LPCI PLUS REPORT

TITLEVALUE
NAMEDSSO LPCI PLUS REPORT
DESCRIPTIONThis RPC provides a list of order history transactions for one user or all
users. There are multiple lines for each purchase card order - the first
and second lines contain multiple fields; the third line contains dates to
be displayed as Transaction date(s) along with the associated AMOUNT and
whether that entry had been reconciled; for each billing item, line item,
item name, 2319 total cost and brief description are also returned.
Shipping/Delivery costs are displayed as the final billing item entry.
The final line contains comments made by the purchasing agent. Days
Old are returned as calendar days. The report may be requested for
reconciled purchase card orders or unreconciled purchase card orders but
not both. For this report, reconciled purchase card orders have SUPPLY
STATUS (file 442 field #.5) set to "Reconciled", "Reconciled - Amended",
"Transaction Complete", or "Transaction Complete (Amended)". Purchase
card orders are considered unreconciled for the purposes of this report
for all other values of SUPPLY STATUS (file 442 field #.5).
TAGLPCIPLUS
ROUTINEDSSOROHL
INPUT PARAMETERSSEQUENCE NUMBER1
INPUT PARAMETERDSSO6699
DESCRIPTIONDSSO6699 - required - Prosthetic Site - file 669.9 IEN
PARAMETER TYPELITERAL
REQUIREDYES
MAXIMUM DATA LENGTH15
INPUT PARAMETERSSEQUENCE NUMBER2
INPUT PARAMETERDSSOADM
DESCRIPTIONDSSOADM - optional - "1" indicates that an Admin user is requesting the
report
PARAMETER TYPELITERAL
REQUIREDNO
MAXIMUM DATA LENGTH1
INPUT PARAMETERSSEQUENCE NUMBER3
INPUT PARAMETERDSSOBDT
DESCRIPTIONDSSOBDT - optional - Begin Date of report in FileMan format; defaults to
the current date
PARAMETER TYPELITERAL
REQUIREDNO
MAXIMUM DATA LENGTH7
INPUT PARAMETERSSEQUENCE NUMBER4
INPUT PARAMETERDSSOEDT
DESCRIPTIONDSSOEDT - optional - End Date - in FileMan format - if entered, must be
future to DSSOBDT; if null, defaults to current date
PARAMETER TYPELITERAL
REQUIREDNO
MAXIMUM DATA LENGTH7
INPUT PARAMETERSSEQUENCE NUMBER5
INPUT PARAMETERDSSOUSR
DESCRIPTIONDSSOUSR - optional (only required if DSSOADM'=1)- DUZ of user for which
to pull order history - New Person file (#200) IEN; if full report is
requested by an admin, this field should be null.
PARAMETER TYPELITERAL
REQUIREDNO
MAXIMUM DATA LENGTH30
INPUT PARAMETERSSEQUENCE NUMBER6
INPUT PARAMETERDSSOIEN
DESCRIPTIONThis is the last IEN # returned by a previous call to this RPC. This is
to be used for chunking data across multiple calls.
PARAMETER TYPELITERAL
REQUIREDNO
MAXIMUM DATA LENGTH30
INPUT PARAMETERSSEQUENCE NUMBER7
INPUT PARAMETERDSSOSTS
DESCRIPTIONStatus - indicates whether to return reconciled or unreconciled
purchase card orders from the PROSTHETICS 1358 file (#664) based
on the value of SUPPLY STATUS (file 442 field #.5):
"R" - reconciled
"U" - unreconciled
PARAMETER TYPELITERAL
REQUIREDYES
MAXIMUM DATA LENGTH1
RETURN VALUE TYPEGLOBAL ARRAY
RETURN PARAMETER DESCRIPTIONOutput:

Error Messages: DSSORET(0)="-1^"_error message or
Warning Messages: DSSORET(0)="0^"_warning message
Successful Processing:
For each purchase card order returned, several lines will be returned:
DSSORET(n)=
PO Line 1:
^-piece 1: File 664 IEN
^-piece 2: Text "FLDS-1"
^-piece 3: IFCAP Order (full PO number)
^-piece 4: Vendor (external format)
^-piece 5: Not used
^-piece 6: Total Ordered
^-piece 7: Last 4 digits of Purchase Card Number
^-piece 8: Date Ordered (external format)
^-piece 9: Date Reconciled (external format)
^-piece 10: Total Reconciled
^-piece 11: Not Used
^-piece 12: Initiator

PO Line 2:
^-piece 1: File 664 IEN
^-piece 2: Text "FLDS-2"
^-piece 3: Station
^-piece 4: Cancellation Date
^-piece 5: Act. Shipping Charge
^-piece 6: Est. Shipping Charge
^-piece 7: Line Item Count
^-piece 8: Patient Name (Last,First MI)
^-piece 9: Supply Status
^-piece 10: Days since P.O. DATE - stops
incrementing if CLOSE OUT DATE is populated
^-piece 11: FCP (external format)
^-piece 12: Final Charge (file 440.6 field #44)
=1 if this is the final charge
=0 if not the final charge
^-piece 13: Not Used

PO Line 3+ - these dates are to be displayed as the Transaction
Dates for the purchase card order. There may be more than one
line of Transaction Dates:
^-piece 1: File 664 IEN
^-piece 2: "BILLING DATES-"_x where x=line number of the
line of TRANSACTION DATEs from file 440.6
^-piece 3+: Repeating TRANSACTION DATE information:
~-piece 1 TRANSACTION DATE (file 440.6 field #5) for
this purchase card order number.
~-piece 2 AMOUNT (file 440.6 field #13)
~-piece 3 RECONCILED INDICATOR
=1 Reconciled
=0 Not Reconciled
NOTE: The first TRANSACTION DATE section may contain
message: "0~No Billing Dates found."

PO Line n to n+1 (where n=# of billing items in file 664) -
information for each billing item:
^-piece 1: File 664 IEN
^-piece 2: "BILLING ITEM"
^-piece 3: Line Item Number
^-piece 4: SHORT DESCRIPTION (file #441 field #.05)
^-piece 5: TOTAL COST (file #660 field #14)
^-piece 6: BRIEF DESCRIPTION (file 664 subfile 664.02 #1)

Last Billing Item Line - SHIPPING/DELIVERY Charge - if there is no
shipping charge, then this line doesn't exist:
^-piece 1: File 664 IEN
^-piece 2: "BILLING ITEM"
^-piece 3: Line Item Number
^-piece 4: "*DELIVERY" (to be used as Item Description) if
there are no line items in the PO but
there is a SHIPPING ENTRY (field #13) in the
PROSTHETICS 1358 file (#664)

or "*SHIPPING" (to be used as Item Description) if
there are line items and a SHIPPING
ENTRY (field #13) in the PROSTHETICS 1358 file (#664)

^-piece 5: If ^piece-4 is "*DELIVERY", this is the TOTAL COST
(field #14) from the RECORD OF PROS APPLIANCE/
REPAIR (#660)

or If ^-piece 4 is "*SHIPPING", this is the SHIP/DEL
(field #6) from the RECORD OF PROS APPLIANCE/REPAIR
(#660).

Last PO Line - Comments from file 23645.1 for this simplified
purchase card order - only viewable by the Initiator
of the PO
^-piece 1: File 664 IEN
^-piece 2: "COMMENTS"
^-piece 3: File 23645.1 IEN
^-piece 4: Comments from file 23645.1

If the final result of a call begins with "$$MORE$$", the end date was not
reached. It will be formatted as follows:

p1 = $$MORE$$
p2 = Last date processed; to be used as DSSOBDT in next call
p3 = Last IEN processed; to be used as DSSOIEN in next call
AVAILABILITY
INACTIVE
CLIENT MANAGER
WORD WRAP ONTRUE
VERSION
SUPPRESS RDV USER SETUP
APP PROXY ALLOWED