APDISTPAY

For invoices with retainage, it is required to track what has been paid against a vendor agreement or purchase order line and their distributions. The APDISTPAY file is used to link payment records for retainage invoices to the invoice distributions and purchase order or vendor agreement lines.
UPDATED BY
AP125 AP126 AP133 AP20.1 AP20.2 AP20.3
AP20.4 AP20.5 AP20.7 AP21.1 AP23.1 AP233
AP25.1 AP25.2 AP26.1 AP27.1 AP300 AP33.1
AP97.1 AP97.2 AP97.3 AP97.5 API1.1 API2.1
MA41.1 MA41.2 MA41.4 MA41.7 MA42.2 MA43.2
MA44.1 MA44.2 MA61.1 MA66.2 MA70.1 MA75.1
MAI1.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
DTY-COMPANY
Element: Company		Numeric 4
Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.
AP125 AP126
AP133 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 API1.1
API2.1 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA44.1
MA44.2 MA61.1
MA66.2 MAI1.1
DTY-VENDOR
Element: Vendor		Alpha 9 (Right Justified)
The vendor's identification code.
AP125 AP126
AP133 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 API1.1
API2.1 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA44.1
MA44.2 MA61.1
MA66.2 MAI1.1
DTY-INVOICE
Element: Invoice		Alpha 22
Used to identify the invoice.
AP125 AP126
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA42.2 MA43.2
MA44.1 MA44.2
MA61.1 MA66.2
MAI1.1
DTY-SUFFIX
Element: Suffix		Numeric 3
This is the suffix for the invoice.
AP125 AP126
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA42.2 MA43.2
MA44.1 MA44.2
MA61.1 MA66.2
MA70.1 MA75.1
MAI1.1
DTY-PMT-SEQ-NBR
Element: Seq Nbr		Numeric 4
AP125 AP126
AP133 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP33.1
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA42.2 MA43.2
MA44.1 MA44.2
MA61.1 MA66.2
MAI1.1
DTY-API-OBJ-ID
Element: Obj Id		Numeric 12
System assigned number for the invoice. Used to tie invoice to distribution records.
AP125 AP126
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA42.2 MA43.2
MA44.1 MA44.2
MA61.1 MA66.2
MA70.1 MA75.1
MAI1.1
DTY-DIST-SEQ-NBR
Element: Dist Seq Nbr		Numeric 6
A unique sequence number. Used to tie the APDISTPAY record to the related distribution in APDISTRIB.
AP125 AP126
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA42.2 MA43.2
MA44.1 MA44.2
MA61.1 MA66.2
MA70.1 MA75.1
MAI1.1
DTY-PMT-AMOUNT
Element: Intl Amt		Signed 18.2
The amount being paid against this record.
AP125 AP126
AP133 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP33.1
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA42.2 MA43.2
MA44.1 MA44.2
MA61.1 MA66.2
MAI1.1
DTY-PO-NUMBER
Element: Po Number		Alpha 14 (Right Justified)
This field contains the number representing the purchase order.
AP125 AP126
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA42.2 MA43.2
MA44.1 MA44.2
MA61.1 MA66.2
MAI1.1
DTY-PO-RELEASE
Element: Po Release		Numeric 4
Used to identify a purchase order release (created from a Blanket or Standing order).
AP125 AP126
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA42.2 MA43.2
MA44.1 MA44.2
MA61.1 MA66.2
MAI1.1
DTY-PO-CODE
Element: Po Code		Alpha 4
This is the purchase order code.
AP125 AP126
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA42.2 MA43.2
MA44.1 MA44.2
MA61.1 MA66.2
MAI1.1
DTY-LINE-NBR
Element: Line Nbr		Numeric 6
This field contains the line number.
AP125 AP126
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA42.2 MA43.2
MA44.1 MA44.2
MA61.1 MA66.2
MAI1.1
DTY-MAD-SEQ-NBR
Element: Seq Nbr		Numeric 4
System assigned sequence number to keep MAINVDTL records unique
AP125 AP126
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA42.2 MA43.2
MA44.1 MA44.2
MA61.1 MA66.2
MAI1.1
DTY-VEN-AGRMT-REF
Element: Agreement Ref		Alpha 30
AP125 AP126
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA42.2 MA43.2
MA44.1 MA44.2
MA61.1 MA66.2
MAI1.1
DTY-RET-CALC-AMT
Element: Intl Amt		Signed 18.2
If record is for retainage, this is the amount used to calculate the retainage payment amount (in PMT-AMOUNT field). This is similar to a taxable amount.
AP125 AP126
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA42.2 MA43.2
MA44.1 MA44.2
MA61.1 MA66.2
MAI1.1
DTY-RET-PCT
Element: Pct		Percent 5.2 (Percent)
This is the percent of retainage that this record represents. It is used in calculating the PMT-AMOUNT from the RET-CALC-AMT.
AP125 AP126
AP133 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP33.1
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA42.2 MA43.2
MA44.1 MA44.2
MA61.1 MA66.2
MAI1.1
DTY-PVN-OBJ-ID
Element: Obj Id		Numeric 12
This is the object identifier. It is used to relate commitments or posted transactions back to the originating subsystems. Each subsystem record that is updated as a commitment or posted transaction is assigned an object identifier. The object identifier is maintained in the subsystem files and in the Activity Commitments Detail and Activity Transaction files. The object identifier is a unique key used to drill back from Activity Management to the subsystems.
AP125 AP126
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA42.2 MA43.2
MA44.1 MA44.2
MA61.1 MA66.2
MAI1.1


APDISTPAY FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
DTYSET1 COMPANY
VENDOR
INVOICE
SUFFIX
PMT-SEQ-NBR
LINE-NBR
MAD-SEQ-NBR
DIST-SEQ-NBR
...
AP125 AP126
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP233 AP25.1
AP25.2 AP26.1
AP27.1 AP300
AP33.1 AP97.1
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA42.2 MA43.2
MA44.1 MA44.2
MA61.1 MA66.2
DTYSET2 COMPANY
VENDOR
INVOICE
SUFFIX
DIST-SEQ-NBR
LINE-NBR
MAD-SEQ-NBR
PMT-SEQ-NBR
MA70.1 MA75.1
DTYSET3 COMPANY
PO-NUMBER
PO-RELEASE
PO-CODE
LINE-NBR
MAD-SEQ-NBR
VENDOR
INVOICE
SUFFIX
PMT-SEQ-NBR
DIST-SEQ-NBR
AP233 AP97.1
AP97.2 AP97.3
DTYSET4 VENDOR
VEN-AGRMT-REF
PVN-OBJ-ID
COMPANY
PO-NUMBER
PO-RELEASE
PO-CODE
INVOICE
SUFFIX
PMT-SEQ-NBR
LINE-NBR
MAD-SEQ-NBR
DIST-SEQ-NBR
AP133 AP233
AP97.1 AP97.5


APDISTPAY FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Apdistrib APDISTRIB Required
DTY-API-OBJ-ID->APD-API-OBJ-ID
DTY-DIST-SEQ-NBR->APD-DIST-SEQ-NBR
Apinvoice APINVOICE Required
DTY-COMPANY->API-COMPANY
DTY-VENDOR->API-VENDOR
DTY-INVOICE->API-INVOICE
DTY-SUFFIX->API-SUFFIX
Zeroes->API-CANCEL-SEQ
Appayment APPAYMENT Required
DTY-COMPANY->APP-COMPANY
DTY-VENDOR->APP-VENDOR
DTY-INVOICE->APP-INVOICE
DTY-SUFFIX->APP-SUFFIX
Zeroes->APP-CANCEL-SEQ
DTY-PMT-SEQ-NBR->APP-SEQ-NBR
Zeroes->APP-VOID-SEQ
Mainvdtl MAINVDTL Required
DTY-COMPANY->MAD-COMPANY
DTY-VENDOR->MAD-VENDOR
DTY-INVOICE->MAD-INVOICE
DTY-SUFFIX->MAD-SUFFIX
DTY-PO-NUMBER->MAD-PO-NUMBER
DTY-PO-RELEASE->MAD-PO-RELEASE
DTY-PO-CODE->MAD-PO-CODE
DTY-LINE-NBR->MAD-LINE-NBR
DTY-MAD-SEQ-NBR->MAD-SEQ-NBR
Pocompany POCOMPANY Required
DTY-COMPANY->PCY-COMPANY
Poline POLINE Required
DTY-COMPANY->PLI-COMPANY
DTY-PO-NUMBER->PLI-PO-NUMBER
DTY-PO-RELEASE->PLI-PO-RELEASE
DTY-PO-CODE->PLI-PO-CODE
DTY-LINE-NBR->PLI-LINE-NBR
Povagrmth POVAGRMTHD Required
PCY-PROCURE-GROUP->PVH-PROCURE-GROUP
DTY-VEN-AGRMT-REF->PVH-VENDOR
DTY-PO-NUMBER->PVH-PO-NUMBER
Povagrmtln POVAGRMTLN Required
DTY-PVN-OBJ-ID->PVN-PVN-OBJ-ID
Purchorder PURCHORDER Required
DTY-COMPANY->PCR-COMPANY
DTY-PO-CODE->PCR-PO-CODE
DTY-PO-NUMBER->PCR-PO-NUMBER
DTY-PO-RELEASE->PCR-PO-RELEASE


APDISTPAY FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Maaocdtl MAAOCDTL
DTY-COMPANY->MAA-COMPANY
DTY-VENDOR->MAA-VENDOR
DTY-INVOICE->MAA-INVOICE
DTY-SUFFIX->MAA-SUFFIX
DTY-PO-NUMBER->MAA-PO-NUMBER
DTY-PO-RELEASE->MAA-PO-RELEASE
DTY-PO-CODE->MAA-PO-CODE
DTY-LINE-NBR->MAA-LINE-NBR
  MAA-AOC-CODE
  MAA-SEQ-NBR

File created: Thu Jun 09 11:07:22 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.