Primary identification data |
|
1 |
VENDOR-NO |
P |
6.0 |
N |
|
|
1 |
VENDOR-NAME-NO |
P |
2.0 |
N |
|
|
1 |
VENDOR-ADDR-NO |
P |
3.0 |
N |
|
|
1 |
INVOICE-NO |
A |
15.0 |
N |
|
|
1 |
INVOICE-SUFFIX |
A |
1.0 |
|
|
SP |
1 |
VENDOR-INVOICE-SUFFIX-KEY |
A |
20.0 |
N |
U |
|
1 |
AP-ID |
P |
9.0 |
N |
U |
Vendor data |
|
1 |
DATE-INVOICE |
D |
|
N |
|
|
1 |
VENDOR-INVOICE-AMT |
P |
8.2 |
N |
|
|
1 |
DATE-DISCOUNT-DUE |
D |
|
N |
|
|
1 |
DATE-PAYMENT-DUE |
D |
|
N |
|
|
1 |
CUSTOMER-ID |
A |
16.0 |
N |
|
UofA classification data |
|
1 |
INVOICE-TYPE |
A |
2.0 |
N |
|
|
1 |
AP-REF-ID |
A |
10.0 |
N |
|
SP |
1 |
INVOICE-TYPE-BU-AP-REF-KEY |
A |
16.0 |
N |
D |
|
1 |
DATE-INVOICE-RECEIVED |
D |
|
N |
|
|
1 |
DATE-INVOICE-RECEIVED-INV |
P |
5.0 |
N |
|
SP |
1 |
VENDOR-DATE-RECEIVED-INV-KEY |
B |
7.0 |
N |
D |
MU |
1 |
AP-PO-NO |
P |
7.0 |
N |
|
SP |
1 |
PO-DATE-RECEIVED-INV-KEY |
B |
7.0 |
N |
D |
|
1 |
AP-BUDGETARY-UNIT-NO |
N |
4.0 |
N |
|
|
1 |
AP-PROBLEM-CD |
A |
1.0 |
N |
|
SP |
1 |
AP-PROBLEM-DATE-RECEIVED-KEY |
A |
5.0 |
N |
D |
|
1 |
INVOICE-REJECT-CD |
A |
1.0 |
N |
|
|
1 |
INVOICE-STATUS |
A |
1.0 |
N |
|
|
1 |
TIME-INVOICE-STATUS |
T |
|
N |
|
SP |
1 |
STATUS-TYPE-TIME-STATUS-KEY |
A |
10.0 |
N |
D |
|
1 |
DATE-CANCEL-EFFECTIVE |
D |
|
N |
|
|
1 |
CONSTRUCTION-CD |
A |
1.0 |
N |
|
|
1 |
SALES-TAX-EXCEPTION-CD |
A |
1.0 |
N |
|
|
1 |
LOCAL-TAX-CD |
A |
2.0 |
N |
|
|
1 |
LOG-TEXT-ID |
A |
16.0 |
N |
|
|
1 |
COMMON-VENDOR-NO |
N |
6.0 |
N |
|
|
1 |
PRE-PAID-EXPENSE-CD |
A |
1.0 |
N |
|
|
1 |
DATE-PRE-PAID-EXPENSE-BEGIN |
D |
|
N |
|
|
1 |
DATE-PRE-PAID-EXPENSE-END |
D |
|
N |
|
|
1 |
PSC-CD |
A |
1.0 |
N |
|
Amount we'll pay & the breakdown |
|
1 |
INVOICE-AMT |
P |
8.2 |
N |
|
|
1 |
INVOICE-TAX-EXEMPT-AMT |
P |
8.2 |
N |
|
|
1 |
INVOICE-FREIGHT-AMT |
P |
5.2 |
N |
|
|
1 |
INVOICE-TAX-AMT |
P |
6.2 |
N |
|
|
1 |
EXCESS-TAX-AMT |
P |
5.2 |
N |
|
|
1 |
INVOICE-MISC-AMT |
P |
4.2 |
N |
|
|
1 |
USE-TAX-AMT |
P |
5.2 |
N |
|
|
1 |
DISCOUNT-AMT |
P |
4.2 |
N |
|
Line distribution/force bal data |
|
1 |
AP-LINE-SUM |
P |
8.2 |
N |
|
|
1 |
AP-LINE-FREIGHT-SUM |
P |
5.2 |
N |
|
|
1 |
AP-LINE-TAX-SUM |
P |
6.2 |
N |
|
|
1 |
AP-LINE-EXCESS-TAX-SUM |
P |
5.2 |
N |
|
|
1 |
AP-LINE-MISC-SUM |
P |
4.2 |
N |
|
|
1 |
AP-LINE-DISCOUNT-SUM |
P |
4.2 |
N |
|
|
1 |
AP-LINE-TAX-EXEMPT-SUM |
P |
8.2 |
N |
|
Payment data |
MU |
1 |
REMITTANCE-ADVICE-COMMENT |
A |
72.0 |
N |
|
MU |
1 |
PAYMENT-HANDLING-CD |
A |
1.0 |
N |
|
|
1 |
PAYMENT-HANDLING-AUTH |
A |
25.0 |
N |
|
|
1 |
DISCOUNT-TAKEN-CD |
A |
1.0 |
N |
|
MU |
1 |
PAYMENT-ID |
P |
9.0 |
N |
D |
|
1 |
VOUCHER-YEAR |
N |
4.0 |
N |
|
PE |
1 |
VOUCHER-GROUP |
|
|
|
|
|
2 |
VOUCHER-TYPE |
A |
4.0 |
N |
|
|
2 |
VOUCHER-NO |
A |
5.0 |
N |
|
|
2 |
VOUCHER-AMT |
P |
8.2 |
N |
|
|
2 |
VOUCHER-DISCOUNT-AMT |
P |
4.2 |
N |
|
|
1 |
TA-LODGING-VENDOR-ID |
A |
13.0 |
N |
|
|
1 |
TA-DATE-RETURN |
D |
|
N |
|
|
1 |
TA-DATE-DEPARTURE |
D |
|
N |
|
|
1 |
TA-LODGING-DAYS |
P |
3.0 |
N |
|
|
1 |
TA-MEALS-DAYS |
P |
3.0 |
N |
|
|
1 |
TA-REIMBURSABLE-MILES |
P |
4.0 |
N |
|
Audit and tracking data |
|
1 |
INVOICE-CMD-ID |
A |
4.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 |
|