For invoices with retainage, it is required to track what has been paid
against a vendor agreement or purchase order line and thier distributiosn. The
APDISTPAY file is used to link payment records for retainage invoices to the
invoice distributions and purchase order or vendor agreement lines.
| 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.
|
|
DTY-VENDOR
Element: Vendor | Alpha 9 (Right Justified)
The vendor's identification code.
|
|
DTY-INVOICE
Element: Invoice | Alpha 22
Used to identify the invoice.
|
|
DTY-SUFFIX
Element: Suffix | Numeric 3
This is the suffix for the invoice.
|
|
DTY-PMT-SEQ-NBR
Element: Seq Nbr | Numeric 4
|
|
DTY-API-OBJ-ID
Element: Obj Id | Numeric 12
System assigned number for the invoice.
Used to tie invoice to distribution
records.
|
|
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.
|
|
DTY-PMT-AMOUNT
Element: Intl Amt | Signed 18.2
The amount being paid against this
record.
|
|
DTY-PO-NUMBER
Element: Po Number | Alpha 14 (Right Justified)
This field contains the number
representing the purchase order.
|
|
DTY-PO-RELEASE
Element: Po Release | Numeric 4
Used to identify a purchase order
release (created from a Blanket or
Standing order).
|
|
DTY-PO-CODE
Element: Po Code | Alpha 4
This is the purchase order code.
|
|
DTY-LINE-NBR
Element: Line Nbr | Numeric 6
This field contains the line number.
|
|
DTY-MAD-SEQ-NBR
Element: Seq Nbr | Numeric 4
System assigned sequence number to keep
MAINVDTL records unique
|
|
DTY-VEN-AGRMT-REF
Element: Agreement Ref | Alpha 30
|
|
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.
|
|
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.
|
|
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.
|
|
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
|
| 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 |
|
