FileMan FileNo | FileMan Filename | Package |
---|---|---|
440.6 | PURCHASE CARD ORDER RECONCILE | IFCAP |
Package | Total | FileMan Files |
---|---|---|
Prosthetics | 1 | PROSTHETICS 1358(#664)[30] |
Package | Total | FileMan Files |
---|---|---|
IFCAP | 1 | PROCUREMENT & ACCOUNTING TRANSACTIONS(#442)[41] |
Kernel | 1 | NEW PERSON(#200)[16, 27, 45] |
Field # | Name | Loc | Type | Details |
---|---|---|---|---|
.01 | ORACLE DOCUMENT ID | 0;1 | FREE TEXT | ************************REQUIRED FIELD************************
|
1 | BATCH NUMBER | 0;2 | FREE TEXT |
|
2 | LINE NUMBER | 0;3 | FREE TEXT |
|
3 | CREDIT CARD NUMBER | 0;4 | FREE TEXT |
|
4 | BANK'S VENDOR ID | 0;5 | FREE TEXT |
|
5 | STATEMENT DATE | 0;6 | DATE |
|
6 | TRANSACTION DATE | 0;7 | DATE |
|
7 | STATION NUMBER | 0;8 | FREE TEXT |
|
8 | PURCHASE DATE | 0;9 | DATE |
|
9 | TXN REFERENCE # | 0;10 | FREE TEXT |
|
10 | BBFY | 0;11 | DATE |
|
11 | EBFY | 0;12 | DATE |
|
12 | ACCOUNTING PERIOD | 0;13 | NUMBER |
|
13 | AMOUNT | 0;14 | NUMBER |
|
14 | FISCAL YEAR | 0;15 | NUMBER |
|
15 | STATUS | 0;16 | SET |
|
16 | CARD HOLDER | 0;17 | POINTER TO NEW PERSON FILE (#200) | NEW PERSON(#200)
|
17 | ET CODE SHEET RI | 0;18 | FREE TEXT |
|
18 | COMMITTED AMOUNT | 0;19 | NUMBER |
|
19 | OLD PO STATUS CODE | 0;20 | FREE TEXT |
|
20 | VENDOR PURCHASE ORDER | 0;21 | FREE TEXT |
|
21 | FUND CODE | 5;1 | FREE TEXT |
|
22 | ACC CODE | 5;2 | FREE TEXT |
|
23 | COST CENTER | 5;3 | FREE TEXT |
|
24 | BOC | 5;4 | FREE TEXT |
|
25 | APPROVING OFFICE | 5;5 | FREE TEXT |
|
26 | APPROVAL DATE | 5;6 | DATE |
|
27 | APPROVING OFFICIAL | 5;7 | POINTER TO NEW PERSON FILE (#200) | NEW PERSON(#200)
|
31 | MERCHANT NAME | 6;1 | FREE TEXT |
|
32 | MERCHANT ADDRESS 1 | 6;2 | FREE TEXT |
|
33 | MERCHANT ADDRESS 2 | 6;3 | FREE TEXT |
|
34 | MERCHANT CITY | 6;4 | FREE TEXT |
|
35 | MERCHANT STATE | 6;5 | FREE TEXT |
|
36 | MERCHANT ZIP | 6;6 | FREE TEXT |
|
41 | PURCHASE ORDER | 1;1 | POINTER TO PROCUREMENT & ACCOUNTING TRANSACTIONS FILE (#442) | PROCUREMENT & ACCOUNTING TRANSACTIONS(#442)
|
42 | RECEIVING REQUIRED | 1;2 | SET |
|
43 | COMPLETE ORDER RECEIVED | 1;3 | SET | ************************REQUIRED FIELD************************
|
44 | FINAL CHARGE | 1;4 | SET | ************************REQUIRED FIELD************************
|
45 | RECONCILE USER | 1;5 | POINTER TO NEW PERSON FILE (#200) | NEW PERSON(#200)
|
46 | RECONCILE DATE | 1;6 | DATE |
|
47 | CHARGE RECEIVING DATE | 1;7 | DATE |
|
ICR LINK | Subscribing Package(s) | Fields Referenced | Description |
---|---|---|---|
ICR #3691 | |||
ICR #6830 | ORACLE DOCUMENT ID (.01). Access: Read w/Fileman BATCH NUMBER (1). Access: Read w/Fileman LINE NUMBER (2). Access: Read w/Fileman CREDIT CARD NUMBER (3). Access: Both R/W w/Fileman BANK'S VENDOR ID (4). Access: Read w/Fileman STATEMENT DATE (5). Access: Read w/Fileman TRANSACTION DATE (6). Access: Read w/Fileman STATION NUMBER (7). Access: Read w/Fileman PURCHASE DATE (8). Access: Read w/Fileman TXN REFERENCE # (9). Access: Read w/Fileman BBFY (10). Access: Read w/Fileman EBFY (11). Access: Read w/Fileman ACCOUNTING PERIOD (12). Access: Read w/Fileman AMOUNT (13). Access: Read w/Fileman FISCAL YEAR (14). Access: Read w/Fileman STATUS (15). Access: Both R/W w/Fileman CARD HOLDER (16). Access: Read w/Fileman ET CODE SHEET (17). Access: Both R/W w/Fileman COMMITTED AMOUNT (18). Access: Both R/W w/Fileman OLD PO STATUS CODE (19). Access: Both R/W w/Fileman VENDOR PURCHASE ORDER (20). Access: Read w/Fileman PURCHASE ORDER (41). Access: Both R/W w/Fileman RECEIVING REQUIRED (42). Access: Both R/W w/Fileman COMPLETE ORDER RECEIVED (43). Access: Both R/W w/Fileman FINAL CHARGE (44). Access: Both R/W w/Fileman RECONCILE USER (45). Access: Both R/W w/Fileman RECONCILE DATE (46). Access: Both R/W w/Fileman CHARGE RECEIVING DATE (47). Access: Read w/Fileman FUND CODE (21). Access: Read w/Fileman ACC CODE (22). Access: Read w/Fileman COST CENTER (23). Access: Read w/Fileman BOC (24). Access: Read w/Fileman APPROVING OFFICE (25). Access: Read w/Fileman APPROVAL DATE (26). Access: Both R/W w/Fileman APPROVING OFFICIAL (27). Access: Both R/W w/Fileman MERCHANT NAME (31). Access: Read w/Fileman MERCHANT ADDRESS 1 (32). Access: Read w/Fileman MERCHANT ADDRESS 2 (33). Access: Read w/Fileman MERCHANT CITY (34). Access: Read w/Fileman MERCHANT STATE (35). Access: Read w/Fileman MERCHANT ZIP (36). Access: Read w/Fileman |
"ST" cross reference Used for look up by combinationof status and card holderFile 440.6 'C' cross reference Used to look up byVENDORPURCHASE ORDERFile 440.6 'PO' cross reference Used to look up byreconciledPURCHASE ORDER |
>> | Not killed explicitly |
* | Changed |
! | Killed |
~ | Newed |
Name | Field # of Occurrence |
---|---|
% | .01(XREF 2n1.1) |
>> %DT | 5+1*, 6+1*, 8+1*, 10+1*, 11+1*, 26+1*, 46+1*, 47+1* |
%H | .01(XREF 2n1.1) |
%I | .01(XREF 2n1.1) |
>> D0 | .01(XREF 2S) |
>> DA | .01(XREF 1S), .01(XREF 1K), .01(XREF 2S), 5(XREF 1S), 5(XREF 1K), 15(XREF 1S), 15(XREF 1K), 16(XREF 1S), 16(XREF 1K), 20(XREF 1S) , 20(XREF 1K), 41(XREF 50S), 41(XREF 50K) |
>> DIG | .01(XREF 2n1.4) |
>> DIH | .01(XREF 2n1.4) |
>> DIU | .01(XREF 2S) |
DIV | .01(XREF 2S), .01(XREF 2n1.1), .01(XREF 2n1.4) |
DIV(0 | .01(XREF 2S), .01(XREF 2n1.4) |
U | IDH1+1, IDH2+1, IDH3+1, .01(XREF 2S), .01(XREF 2n1.4), 15(XREF 1S), 15(XREF 1K), 16(XREF 1S), 16(XREF 1K) |
X | .01+1!, .01(XREF 1S), .01(XREF 1K), .01(XREF 2S), .01(XREF 2n1.1), .01(XREF 2n1.4), 1+1!, 2+1!, 3+1!, 4+1! , 5+1*!, 5(XREF 1S), 5(XREF 1K), 6+1*!, 7+1!, 8+1*!, 9+1!, 10+1*!, 11+1*!, 12+1! , 13+1*!, 14+1!, 15(XREF 1S), 15(XREF 1K), 16(XREF 1S), 16(XREF 1K), 17+1!, 18+1*!, 19+1!, 20+1! , 20(XREF 1S), 20(XREF 1K), 21+1!, 22+1!, 23+1!, 24+1!, 25+1!, 26+1*!, 31+1!, 32+1! , 33+1!, 34+1!, 35+1!, 36+1!, 41(XREF 50S), 41(XREF 50K), 46+1*!, 47+1*! |
Y | .01(XREF 2S), 5+1, 6+1, 8+1, 10+1, 11+1, 26+1, 46+1, 47+1 |
Y(0 | .01(XREF 2S) |
Y(1 | .01(XREF 2S) |