Data Element Summary for ACCOUNTS-PAYABLE (U-96)
Type Level Field Name Format Length Compression
Option
Index
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  

Generated 06/01/21 12:37:03