Inventory Transfer Interface: Pipe Delimited Method
- Samantha Menzynski
Use the Inventory Transfer Interface to load inventory transfer data from external applications. Information you load using this interface adds to the data already stored in PENTA.
Data files you load must have Request Types assigned to the I Interface Type.
PENTA runs several high-level tests for integrity on the file and records. When you process the records, be sure to use the file name as the Batch Number. This is different from other PENTA Interface Types. In the inventory interface files, there is no Batch Number field. The file name itself becomes the Batch Number during processing.
The following System Options affect interfaced records:
125 (Mark Batch for Distribution) controls whether PENTA automatically distributes the batches.
128 (Reject Interface File on Error) whether PENTA rejects a batch when errors exist in the file.
Limitations & Restrictions
Do not use tildes (~) to denote null (empty) fields in this interface’s records. Instead, enter nothing (no space) between pipe delimiters.
Where to View Loaded Data
If System Option 125 is set to N, you can review and modify interfaced data using the Inventory Transfer window; otherwise, use the Document Query, Reports, and Queries. For example:
Warehouse Transaction Register
General Ledger Detail
Inventory Subledger
You must reprocess corrections via another inventory transfer interface record or PENTA's Inventory Transfer window.
Available Records
Document Record
The fields listed in the following table identify the inventory transfer data you will add. There is no “header” record. It is most similar to the Labor Interface in this respect.
Note: The end of each record needs a single pipe delimiter.
# | Field | Entry | Format | Description |
|---|---|---|---|---|
1 | Transfer Date | Req | D | Posting Date of Inventory Transfer |
2 | Product ID | Req | X | The Product ID that is transferred in this transaction |
3 | Quantity | Req | I9 | Number of units of the Product ID to be transferred |
4 | From Distribution Type | Req | C1 | Possible values are A (GL Account), F (Fixed Asset), J (Job), and W (Warehouse). |
5 | From Warehouse ID | Opt | C4 | Required if the From Distribution Type is W; otherwise, do not enter a value. |
6 | From Location ID | Opt | C6 | Required if the From Distribution Type is W; otherwise, do not enter a value. |
7 | From Job ID | Opt | X | Required if the From Distribution Type is J; otherwise, do not enter a value. |
8 | From Cost Type Code | Opt | C4 | Required if the From Distribution Type is J; otherwise, do not enter a value. |
9 | From Costcode | Opt | X | Required if the From Distribution Type is J; otherwise, do not enter a value. |
10 | From OU ID | Opt | X | Required if the From Distribution Type is A; otherwise, do not enter a value. |
11 | From Account Number | Opt | X | Required if the From Distribution Type is A; otherwise, do not enter a value. |
12 | From Fixed Asset ID | Opt | X | Required if the From Distribution Type is F; otherwise, do not enter a value. |
13 | From FA Expense Category | Opt | I3 | Required if the From Distribution Type is F; otherwise, do not enter a value. |
14 | From Unit Cost | Opt | F 12.3 | If the From Distribution Type is W, leave this field blank. If From Distribution Type is NOT W and the To Distribution Type is W, this field is required; otherwise this field is required. |
15 | To Distribution Type | Req | C1 | Available options are A (GL Account), F (Fixed Asset), J (Job), and W (Warehouse). |
16 | To Warehouse ID | Opt | C4 | Required if the To Distribution Type is W; otherwise, do not enter a value. |
17 | To Location ID | Opt | C6 | Required if the To Distribution Type is W; otherwise, do not enter a value. |
18 | To Job ID | Opt | X | Required if the To Distribution Type is J; otherwise, do not enter a value. |
19 | To Cost Type Code | Opt | C4 | Required if the To Distribution Type is J; otherwise, do not enter a value. |
20 | To Costcode | Opt | X | Required if the To Distribution Type is J; otherwise, do not enter a value. |
21 | To OU ID | Opt | X | Required if the To Distribution Type is A; otherwise, do not enter a value. |
22 | To Account Number | Opt | X | Required if the To Distribution Type is A; otherwise, do not enter a value. |
23 | To Fixed Asset ID | Opt | X | Required if the To Distribution Type is F; otherwise, do not enter a value. |
24 | To FA Expense Category | Opt | I3 | Required if the To Distribution Type is F; otherwise, do not enter a value. |
25 | Transaction Reference ID | Opt | C15 | The User defined code associated with the transaction. Tables maintaining this Field include INV_XFER_WORK, INTR_INVENTORY_DTL. |
Tracking Attribute Record
The fields listed in the following table identify the inventory tracking attribute data you will add using this interface process. Use this record to identify tracking attributes for the inventory product defined in the Detail record but do not use this Record Type for transfers from a non-warehouse entity (job, account, or asset) to a warehouse location.
# | Field | Entry | Format | Description |
|---|---|---|---|---|
1 | Record Type | Req | C! 5 | This Record Type identifies the tracking attribute value that will transfer. The value must be PRODATTR. |
2 | Attribute Value | Req | C 30 | The value assigned to the tracking attribute. This tracking attribute value must currently exist for one or more products in the From Location defined in the Detail Record above. |
3 | Product Attribute Id | Req | C 15 | The Tracking Attribute value assigned to the product in the Product Information window. |
4 | Units | Req | F 12.3 | The number of units associated with this tracking attribute. This field must be equal to 1 if you defined the tracking attribute as One-To-One in the Product Attributes window. |