| # | Name | Location | Type | Details | Index | Description |
|---|---|---|---|---|---|---|
| .01 | inventory point(+) | 0;1 | POINTER | 445 | B | This is the inventory point affected by the transaction. Each time an item has activity against it, the inventory point will be added as a new entry to this file. |
| 1 | transaction id(+) | 0;2 | FREE TEXT | This is the Transaction ID defined in two parts: A Transaction is any event that affects the inventory level (e.g., receiving, distribution, etc.). The ID uniquely identifies the transaction (e.g., Distribution Order No., P.O. No.). | ||
| 2 | date of transaction(+) | 0;3 | DATE-TIME | This is the date of the original transaction (e.g., P.O. date for receiving; date Distribution Order was entered). | ||
| 2.5 | date posted | 0;17 | DATE-TIME | This is the date the transaction affected the inventory. | ||
| 3 | type of transaction(+) | 0;4 | SET OF CODES | RC:RECEIVING R:DISTR.(REGULAR) U:USAGE A:MANUAL ADJ. C:DISTR.(CALL-IN) S:SET/PACKS P:PHYSICAL COUNT E:DISTR.(EMERGENCY) Q:QTY ON SUPPLY STATION | This code indicates the type of transaction (i.e., RC= receiving supplies into inventory; R or C or E= Distribution to another Inventory Point; U= Usage (e.g., patient, in-house); A= Manual adjustment to inventory; S=Assemble Sets/Packs; P= Physical Count; Q= Quantity adjusted to supply station value. | |
| 4 | item no.(+) | 0;5 | POINTER | 441 | This is a pointer the Item Master File, #441 (Note: The item must be in the Inventory file for this Inventory Point). | |
| 5 | packaging unit | 0;6 | FREE TEXT | This is the unit of issue from this Inventory Point. | ||
| 6 | quantity | 0;7 | NUMERIC | This is the number indicating whether the inventory was incremented by the quantity, or whether the inventory was decremented. | ||
| 6.1 | inventory value | 0;22 | NUMERIC | This field is used to store the total dollar inventory value of the transaction. | ||
| 6.2 | sell value | 0;23 | NUMERIC | This field is used to store the total dollar sales value of the transaction. | ||
| 7 | avg.unit cost | 0;8 | NUMERIC | This is the average unit cost which is used to value the net effect to the Inventory of this transaction. | ||
| 8 | selling unit price | 0;9 | NUMERIC | This is used for cost accounting (i.e., the higher of the actual cost or the average at the time the transaction occurred). | ||
| 8.5 | posted by(+) | 0;16 | POINTER | 200 | This field stores the user which created the activity against this item in the inventory point. | |
| 9 | reason code | 0;10 | FREE TEXT | This field is no longer used. | ||
| 9.5 | additional reason text | 1;1 | FREE TEXT | This field is used to explain the reason for the activity against this item in the inventory point. It allows the user to enter a reason for making adjustments to items. | ||
| 10 | issuable/nonissuable | 0;11 | SET OF CODES | I:ISSUABLE N:NON-ISSUABLE | This code is used to denote transfers between Issuable and Non-Issuable Inventory adjustments. | |
| 10.5 | log transaction code | 0;13 | POINTER | 420.4 | This field is no longer used. | |
| 11 | source code | 0;12 | POINTER | 420.8 | This field is no longer used. | |
| 12 | account code | 0;14 | FREE TEXT | This field is no longer used. | ||
| 13 | voucher number | 0;15 | FREE TEXT | V | This field stores the voucher number which appears on the voucher summary report and is used for reconciliation. | |
| 14 | other inventory point affected | 0;18 | POINTER | 445 | This is designated for the name of the other inventory point affected (i.e., in the case where there is a transaction that affects two inventory points). | |
| 20 | adjustment approved date@time | 0;20 | DATE-TIME | This field is used for adjustment transactions. When an adjustment is made in the warehouse inventory point, this field is used to indicate the date and time the adjustment was approved by the accountable and approving officials. | ||
| 21 | adjustment approved by | 0;21 | POINTER | 200 | This field is used for adjustment transactions. When an adjustment is made in the warehouse inventory point, this field is used to indicate the user who entered the adjustment as approved. | |
| 22 | supply station user | 2;1 | FREE TEXT | The name of the person who took the supplies from the automated supply station. | ||
| 23 | recipient | 2;2 | FREE TEXT | This field holds the name of patient or area receiving supplies from an automated supply station. For example, floor stock, trashed, etc. | ||
| 410 | transaction/p.o. number | 0;19 | FREE TEXT | C | This field is used to store the transaction number from file 410. The field is set to the transaction number when the warehouse posts an issue book to a primary. This field is used for lookups during the 'Reprint a Picking Ticket' option. | |
| 411 | issue book line number | 0;24 | NUMERIC | This field is used to store the issue book line number. The issue book line number is used to look up on the issue book line to determine the subacct for fms. |
Not Referenced