FileMan FileNo | FileMan Filename | Package |
---|---|---|
445.2 | INVENTORY TRANSACTION | IFCAP |
Package | Total | FileMan Files |
---|---|---|
IFCAP | 4 | ITEM MASTER(#441)[4] CALM/LOG TRANSACTIONS CODE LIST(#420.4)[10.5] SOURCE CODE(#420.8)[11] GENERIC INVENTORY(#445)[.01, 14] |
Kernel | 1 | NEW PERSON(#200)[8.5, 21] |
Field # | Name | Loc | Type | Details |
---|---|---|---|---|
.01 | INVENTORY POINT | 0;1 | POINTER TO GENERIC INVENTORY FILE (#445) | ************************REQUIRED FIELD************************ GENERIC INVENTORY(#445)
|
1 | TRANSACTION ID | 0;2 | FREE TEXT | ************************REQUIRED FIELD************************
|
2 | DATE OF TRANSACTION | 0;3 | DATE | ************************REQUIRED FIELD************************
|
2.5 | DATE POSTED | 0;17 | DATE |
|
3 | TYPE OF TRANSACTION | 0;4 | SET | ************************REQUIRED FIELD************************
|
4 | ITEM NO. | 0;5 | POINTER TO ITEM MASTER FILE (#441) | ************************REQUIRED FIELD************************ ITEM MASTER(#441)
|
5 | PACKAGING UNIT | 0;6 | FREE TEXT |
|
6 | QUANTITY | 0;7 | NUMBER |
|
6.1 | INVENTORY VALUE | 0;22 | NUMBER |
|
6.2 | SELL VALUE | 0;23 | NUMBER |
|
7 | AVG.UNIT COST | 0;8 | NUMBER |
|
8 | SELLING UNIT PRICE | 0;9 | NUMBER |
|
8.5 | POSTED BY | 0;16 | POINTER TO NEW PERSON FILE (#200) | ************************REQUIRED FIELD************************ NEW PERSON(#200)
|
9 | REASON CODE | 0;10 | FREE TEXT |
|
9.5 | ADDITIONAL REASON TEXT | 1;1 | FREE TEXT |
|
10 | ISSUABLE/NONISSUABLE | 0;11 | SET |
|
10.5 | LOG TRANSACTION CODE | 0;13 | POINTER TO CALM/LOG TRANSACTIONS CODE LIST FILE (#420.4) | CALM/LOG TRANSACTIONS CODE LIST(#420.4)
|
11 | SOURCE CODE | 0;12 | POINTER TO SOURCE CODE FILE (#420.8) | SOURCE CODE(#420.8)
|
12 | ACCOUNT CODE | 0;14 | FREE TEXT |
|
13 | VOUCHER NUMBER | 0;15 | FREE TEXT |
|
14 | OTHER INVENTORY POINT AFFECTED | 0;18 | POINTER TO GENERIC INVENTORY FILE (#445) | GENERIC INVENTORY(#445)
|
20 | ADJUSTMENT APPROVED DATE@TIME | 0;20 | DATE |
|
21 | ADJUSTMENT APPROVED BY | 0;21 | POINTER TO NEW PERSON FILE (#200) | NEW PERSON(#200)
|
22 | SUPPLY STATION USER | 2;1 | FREE TEXT |
|
23 | RECIPIENT | 2;2 | FREE TEXT |
|
410 | TRANSACTION/P.O. NUMBER | 0;19 | FREE TEXT |
|
411 | ISSUE BOOK LINE NUMBER | 0;24 | NUMBER |
|
ICR LINK | Subscribing Package(s) | Fields Referenced | Description |
---|---|---|---|
ICR #3707 | |||
ICR #6548 | INVENTORY POINT (.01). Access: Both R/W w/Fileman TRANSACTION ID (1). Access: Both R/W w/Fileman DATE OF TRANSACTION (2). Access: Both R/W w/Fileman TYPE OF TRANSACTION (3). Access: Both R/W w/Fileman ITEM NO. (4). Access: Both R/W w/Fileman PACKAGING UNIT (5). Access: Both R/W w/Fileman QUANTITY (6). Access: Both R/W w/Fileman AVG.UNIT COST (7). Access: Both R/W w/Fileman SELLING UNIT PRICE (8). Access: Both R/W w/Fileman REASON CODE (9). Access: Both R/W w/Fileman ISSUABLE/NONISSUABLE (10). Access: Read w/Fileman SOURCE CODE (11). Access: Read w/Fileman LOG TRANSACTION CODE (10.5). Access: Read w/Fileman ACCOUNT CODE (12). Access: Read w/Fileman VOUCHER NUMBER (13). Access: Read w/Fileman POSTED BY (8.5). Access: Both R/W w/Fileman DATE POSTED (2.5). Access: Both R/W w/Fileman OTHER INVENTORY POINT (14). Access: Read w/Fileman TRANSACTION/P.O. NUMBER (410). Access: Read w/Fileman ADJUSTMENT APPROVED DATE@TIME (20). Access: Read w/Fileman ADJUSTMENT APPROVED BY (21). Access: Read w/Fileman INVENTORY VALUE (6.1). Access: Both R/W w/Fileman SELL VALUE (6.2). Access: Both R/W w/Fileman ISSUE BOOK LINE NUMBER (411). Access: Read w/Fileman ADDITIONAL REASON TEXT (9.5). Access: Both R/W w/Fileman SUPPLY STATION USER (22). Access: Read w/Fileman RECIPIENT (23). Access: Read w/Fileman |
"B" cross reference - used to search by Inventory Point"C" cross reference - used to search by Transaction /P.O. Number."T" cross reference - used to search by Transaction ID."V" cross reference - used to search by Voucher Number.'AX' cross reference - used to look up by INVENTORYPOINT, TRANSACTION DATE & TYPE |
>> | Not killed explicitly |
* | Changed |
! | Killed |
~ | Newed |
Name | Field # of Occurrence |
---|---|
>> %DT | 2+1*, 2.5+1*, 20+1* |
>> DA | IXDSL+1, IXDKL+1, .01(XREF 1S), .01(XREF 1K), .01(XREF 3S), .01(XREF 3K), .01(XREF 4S), .01(XREF 4K), 1(XREF 1S), 1(XREF 1K) , 3(XREF 1S), 3(XREF 1K), 4(XREF 2S), 4(XREF 2K), 13(XREF 1S), 13(XREF 1K), 410(XREF 1S), 410(XREF 1K) |
DIC | 4+1!*, 10.5+1!* |
DIC("S" | 4+1*, 4SCR+1*, 10.5+1*, 10.5SCR+1* |
>> DIE | 4+1, 10.5+1 |
>> PRCPPRIV | .01+1 |
U | .01(XREF 3S), .01(XREF 3K), 4(XREF 2S), 4(XREF 2K) |
X | .01+1!, .01(XREF 1S), .01(XREF 1K), .01(XREF 2S), .01(XREF 3S), .01(XREF 3K), .01(XREF 4S), .01(XREF 4K), 1+1!, 1(XREF 1S) , 1(XREF 1K), 2+1*!, 2.5+1*!, 3(XREF 1S), 3(XREF 1K), 4+1*!, 4(XREF 2S), 4(XREF 2K), 5+1!, 6+1! , 6.1+1*!, 6.2+1*!, 7+1!, 8+1!, 9+1!, 9.5+1!, 10.5+1*!, 12+1!, 13+1!, 13(XREF 1S) , 13(XREF 1K), 20+1*!, 22+1!, 23+1!, 410+1!, 410(XREF 1S), 410(XREF 1K), 411+1! |
X(1 | IXDSL+1, IXDKL+1 |
X(2 | IXDSL+1, IXDKL+1 |
>> Y | 2+1, 2.5+1, 4+1, 10.5+1, 20+1 |
Z | .01(XREF 3S), .01(XREF 3K), 4(XREF 2S), 4(XREF 2K) |