|
Primary identification data |
| |
1 |
REQ-NO |
P |
6.0 |
F |
U |
| |
1 |
REQ-TYPE |
A |
2.0 |
F |
|
| |
1 |
REQ-STATUS |
A |
1.0 |
F |
|
| |
1 |
REQ-BUDGETARY-UNIT-NO |
N |
4.0 |
N |
|
| |
1 |
CONTRACT-NO |
A |
13.0 |
N |
|
| |
1 |
OLD-CUSTOMER-ID |
A |
16.0 |
N |
|
| |
1 |
MOF-NO |
N |
6.0 |
N |
|
| |
1 |
BR-TEXT-ID |
A |
16.0 |
N |
|
| |
1 |
PR-TEXT-ID |
A |
16.0 |
N |
|
| |
1 |
GR-TEXT-ID |
A |
16.0 |
N |
|
| PE |
1 |
VENDOR-GROUP |
|
|
|
|
| |
2 |
VENDOR-NO |
P |
6.0 |
N |
|
| |
2 |
VENDOR-NAME-NO |
P |
2.0 |
N |
|
| |
2 |
VENDOR-ADDR-NO |
P |
3.0 |
N |
|
| |
2 |
CUSTOMER-ID |
A |
16.0 |
N |
|
| |
2 |
PROPOSED-VENDOR-IND |
L |
|
N |
|
| |
1 |
QUOTE-BID-SOL-NO |
P |
6.0 |
N |
|
| |
1 |
RECEIVING-TYPE-CD |
A |
1.0 |
N |
|
|
Tracking data |
| |
1 |
DEPT-REF-ID |
A |
8.0 |
N |
|
| |
1 |
DEPT-REP-USER-ID |
A |
8.0 |
N |
|
| |
1 |
REQUESTOR-NAME |
A |
20.0 |
N |
|
| |
1 |
REQUESTOR-PHONE-NO |
A |
17.0 |
N |
|
| |
1 |
DATE-CLOSE-ANTICIPATED |
D |
|
N |
|
| |
1 |
EXTERNAL-REQ-ID |
A |
20.0 |
N |
U |
| PE |
1 |
ACTIVITY-LOG-GROUP |
|
|
|
|
| |
2 |
ACTIVITY-CD |
A |
4.0 |
N |
|
| |
2 |
PRIOR-BUYER-USER-ID |
A |
8.0 |
N |
|
| |
2 |
TIME-ACTIVITY |
T |
|
N |
|
| |
2 |
ACTIVITY-BY-USER-ID |
A |
8.0 |
N |
|
|
Delivery parameters |
| |
1 |
SHIP-TO-CD |
A |
8.0 |
N |
|
| |
1 |
DELIVERY-DATE-CD |
A |
1.0 |
N |
|
| |
1 |
DATE-DELIVERY |
D |
|
N |
|
|
Information for Purchasing |
| |
1 |
BUYER-USER-ID |
A |
8.0 |
N |
|
| |
1 |
ADVANCE-PO-NO |
P |
7.0 |
N |
|
| MU |
1 |
HANDLING-CD |
A |
1.0 |
N |
|
| |
1 |
PAYMENT-HANDLING-AUTH |
A |
25.0 |
N |
|
| |
1 |
SALES-TAX-ID-TYPE |
A |
1.0 |
N |
|
| |
1 |
SALES-TAX-ID |
A |
10.0 |
N |
|
| |
1 |
SUPPORTING-DOC-CD |
A |
1.0 |
N |
|
| |
1 |
CONSTRUCTION-CD |
A |
1.0 |
N |
|
| |
1 |
PO-SUM |
P |
8.2 |
N |
|
| |
1 |
PO-TAX-SUM |
P |
6.2 |
N |
|
| |
1 |
REQ-SPECIAL-PROCESSING-CD |
A |
1.0 |
N |
|
| |
1 |
PURCHASE-CD |
A |
2.0 |
F |
|
|
Financial data |
| |
1 |
BILLING-ADDR-CD |
A |
8.0 |
N |
|
| |
1 |
LOCAL-TAX-CD |
A |
2.0 |
N |
|
| |
1 |
DATE-ORDER-DESIRED-EFFECTIVE |
D |
|
N |
|
| |
1 |
DATE-COMMITMENT-EFFECTIVE |
D |
|
F |
|
| |
1 |
DATE-PO-INEFFECTIVE |
D |
|
N |
|
| |
1 |
REQ-ESTIMATED-AMT |
P |
8.2 |
N |
|
| |
1 |
REQ-ESTIMATED-FREIGHT-AMT |
P |
5.2 |
N |
|
| |
1 |
REQ-AMT |
P |
8.2 |
N |
|
| |
1 |
REQ-FREIGHT-AMT |
P |
5.2 |
N |
|
| |
1 |
REQ-TAX-AMT |
P |
6.2 |
N |
|
| |
1 |
REQ-TOLERANCE-PCT |
P |
3.0 |
N |
|
| PE |
1 |
REQ-DISTRIBUTION-GROUP |
|
|
|
|
| |
2 |
CO-CENTER-NO |
P |
15.0 |
N |
|
| |
2 |
CO-CENTER-PCT |
P |
3.0 |
N |
|
| |
2 |
DEPT-ACCT-PROJECT |
A |
2.0 |
N |
|
| MU |
2 |
DEPT-ACCT-CATEGORY |
A |
8.0 |
N |
|
| MU |
2 |
CO-CENTER-CATEGORY-SUM |
P |
8.2 |
N |
|
|
Audit data |
| |
1 |
DATE-REQ-CREATED |
D |
|
F |
|
| |
1 |
OPEN-REQ-LINE-COUNT |
P |
3.0 |
N |
|
| PE |
1 |
UPDATE-HISTORY-GROUP |
|
|
|
|
| |
2 |
TIME-OF-UPDATE |
T |
|
N |
|
| |
2 |
UPDATED-BY-USER |
A |
8.0 |
N |
|
| |
1 |
TIME-STAMP |
B |
8.0 |
F |
|
|
Data Base Access Keys |
| SP |
1 |
STATUS-BU-TYPE-DATE-KEY |
A |
11.0 |
N |
D |
| SP |
1 |
BU-DEPT-REF-DATE-KEY |
A |
16.0 |
N |
D |
| SP |
1 |
BU-STATUS-REQUESTOR-DATE-KEY |
A |
19.0 |
N |
D |
| SP |
1 |
BUYER-STATUS-DATE-KEY |
A |
13.0 |
N |
D |