The Invoice Distribution Header file contains invoice distribution records.
The presence of a tax code identifies the record as a tax distribution.
Distribution records that have an asset number or asset template assigned will
also have an associated record in the Asset Detail file.
| FIELD NAME |
DESCRIPTION/VALID VALUES |
UPDATED BY |
APD-COMPANY
Element: Company | Numeric 4
The company number. Must be a valid
record in the Accounts Payable Company
file.
|
|
APD-API-OBJ-ID
Element: API Object ID | Numeric 12
A unique identifier assigned to this
file record.
|
|
APD-VENDOR
Element: Vendor | Alpha 9 (Right Justified)
The vendor number. Must be a valid
record in the Vendor file.
|
|
APD-INVOICE
Element: Invoice | Alpha 22
The invoice number. Represents a unique
identifier for the invoice. Must be a
valid record in the Accounts Payable
Invoice file.
|
|
APD-SUFFIX
Element: Suffix | Numeric 3
The invoice suffix number. Represents
the occurrence value of the invoice. The
suffix is assigned by the system to
recurring invoices, employee advances,
and prepayment credit memos.
|
|
APD-CANCEL-SEQ
Element: Seq Nbr | Numeric 4
The sequence number assigned upon the
cancellation of a distributed invoice.
The first sequence assigned is 9999.
|
|
APD-ORIG-DIST-SEQ
Element: Dist Seq Nbr | Numeric 6
A unique sequence number.
|
|
APD-DIST-SEQ-NBR
Element: Dist Seq Nbr | Numeric 6
A unique sequence number assigned to
the distribution record.
|
|
APD-DIST-TYPE
Element: Dist Type | Alpha 1
The distribution type. Valid values are:
D = Distribution.
I = Intercompany Distribution. (Not
used for distributions that originate in
the Accounts Payable system.)
G = Gain/Loss Distribution.
R = Tax/Reversal Distribution.
|
|
APD-PROC-LEVEL
Element: Process Level | Alpha 5
The process level associated with the
distribution. Must be a valid record in
the Accounts Payable Process Level file.
|
|
APD-POST-OPTION
Element: Post Option | Alpha 1
The general ledger posting option
associated with the distribution record.
Valid values are:
D = Detail.
S = Summary.
|
|
APD-INVOICE-TYPE
Element: Invoice Type | Alpha 1
The type of invoice associated with the
distribution. Valid values are:
Blank = Invoice.
C = Credit Memo.
D = Debit Memo.
P = Prepayment.
Y = Prepayment Credit Memo.
A = Employee Advance.
M = Employee Advance Credit Memo.
E = Employee Expense.
|
|
APD-REC-STATUS
Element: Record Status | Numeric 1
The distribution record status. Valid
values are:
0 = Unreleased.
1 = Unposted (released).
9 = Posted by AP175.
5 = Pending
6 = Approved
7 = Rejected |
|
APD-INV-CURRENCY
Element: To Base Curr | Alpha 5
The currency of the invoice. Must be a
valid record in the Currency Code file.
|
|
APD-TAX-RATE
Element: Chrg Rate | Percent 7.5 (Percent)
The tax rate applied to the invoice.
|
|
APD-CURR-RATE
Currency Exchange
Rate | Signed 14.7
The currency exchange rate applied to
the invoice.
|
|
APD-ORIG-BASE-AMT
Base Distribution
Amount | Signed 18.2
The amount of the distribution in
company base currency.
|
|
APD-BASE-ND
Base Currency Nbr
of Decimals | Numeric 1
The number of decimals positions
defined for the company base currency.
|
|
APD-ORIG-TRAN-AMT
Element: Distribution Amount | Signed 18.2
The amount of the distribution in the
currency of the invoice.
|
|
APD-TRAN-ND
Trans Curr Nbr of
Decimals | Numeric 1
The number of decimals defined for the
invoice currency.
|
|
APD-TO-BASE-AMT
Distribution
Company Base Amt | Signed 18.2
The amount of the distribution in the
distribution company's base currency.
|
|
APD-TO-BASE-ND
Dist Company Nbr of
Decimals | Numeric 1
The number of decimal positions defined
for the distribution company's currency.
|
|
APD-TAXABLE-AMT
Element: Intl Amt | Signed 18.2
The taxable amount of the distribution.
|
|
APD-UNT-AMOUNT
Element: Unit Amount | Signed 18.2
The total unit amount allocated to the
expense distribution.
|
|
APD-DIST-COMPANY
Element: Company | Numeric 4
The distribution company assigned to
the distribution. Must be a valid record
in the General Ledger Company file and a
valid relationship record must exist in
the Intercompany Relationship file.
|
|
APD-DIS-ACCT-UNIT
Element: Acct Unit | Alpha 15
The general ledger distribution
accounting unit. Must be a valid record
in the General Ledger Names file.
|
|
APD-DIS-ACCOUNT
Element: Account | Numeric 6
The general ledger distribution account
number. Must be a valid record in the
General Ledger Account Master file.
|
|
APD-DIS-SUB-ACCT
Element: Sub Acct | Numeric 4
The general ledger distribution
subaccount number. Must be a valid
record in the General Ledger Account
Master file.
|
|
APD-DISTRIB-DATE
Element: Post Date | Numeric 8 (yyyymmdd)
The date used for posting the
distribution to the general ledger.
|
|
APD-TAX-INDICATOR
Element: Tax Indicator | Numeric 1
0
1 = Exempt
2 = Taxable |
|
APD-TAX-SEQ-NBR
Element: Tax Seq Nbr | Numeric 4
|
|
APD-TAX-CODE
Element: Tax Code | Alpha 10
The tax code assigned to the
distribution. Represents tax
information. If present, identifies the
distribution as a tax distribution. Must
be a valid tax code in Tax.
|
|
APD-TAX-TYPE
Element: Tax Type | Alpha 1
Indicates the type of tax defined for
the Tax Code. Valid values are:
I = Invoiced. Default value. The tax
represents an increase to the invoice
amount.
A = Accrued. The tax does not increase
the invoice amount.
|
|
APD-DESCRIPTION
Element: Description | Alpha 30 (Lower Case)
The distribution description.
|
|
APD-DST-REFERENCE
Element: Cross Ref | Alpha 10
The distribution reference.
|
|
APD-ACTIVITY
Element: Activity | Alpha 15
The activity assigned to the
distribution, if applicable. Used to
group expense distribution amounts to
track costs for projects, jobs,
construction, and so on, without having
to define additional general ledger
account numbers. Must be a valid
activity in Project Accounting.
|
|
APD-ACCT-CATEGORY
Element: Acct Category | Alpha 5
The account category assigned to the
distribution, if applicable. Used to
group distributions under an activity.
Must be a valid account category for the
activity in Project Accounting.
|
|
APD-BILL-CATEGORY
Element: Bill Category | Alpha 32
|
|
APD-ACCR-CODE
Element: Invoice Accrual Code | Alpha 4
The invoice accrual code associated
with the distribution. Represents a
general ledger accrual account. Must be
a valid record in the Invoice Accrual
Code file.
|
|
APD-PO-NUMBER
Element: Po Number | Alpha 14 (Right Justified)
This field contains the number
representing the purchase order.
|
|
APD-PO-RELEASE
Element: Po Release | Numeric 4
The purchase order release number
associated with the distribution. Used
to identify a purchase order release
(created from a blanket or standing
order).
|
|
APD-PO-CODE
Element: Purchase Order Code | Alpha 4
Purchase order number code. Used to
keep purchase orders unique. Can also be
used for reporting purposes.
|
|
APD-PO-LINE-NBR
Element: Line Nbr | Numeric 6
The purchase order line number
associated with the distribution.
|
|
APD-PO-AOC-CODE
Purchase Order Add
On Cost | Alpha 2
Indicates whether this distribution
record represents an add-on cost for a
purchase order. Valid values are:
Y = Yes.
N = No.
|
|
APD-GLT-OBJ-ID
GL Interface Object
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.
|
|
APD-ATN-OBJ-ID
Activity Interface
Object ID | Numeric 12
A subsystem activity interface
identification number. Used for Drill
Around purposes.
|
|
APD-ASSET-FLAG
Element: Asset Exists | Alpha 1
Indicates whether an asset or asset
repair record exists for the
distribution. Valid values are:
A = Asset.
R = Repair Asset.
Blank = No asset information is defined
for the distribution.
Y = Asset or Repair |
|
APD-DIST-CODE
Element: Dist Code | Alpha 9
The distribution code assigned to the
distribution. Used to split an expense
distribution into multiple distribution
lines. Must be a valid record in the
Distribution Code Header file.
|
|
APD-TAX-POINT
Element: Tax Point | Alpha 1
Indicates when the tax amount is
calculated for the invoice distribution,
if applicable. Valid values are:
I = Invoice.
P = Payment.
G = GL Post Date |
|
APD-VAT-REVERSE-FL
Element: VAT Reversal | Alpha 1
Used in AP190 (Invoice Reinstatement)
to create reversing tax due general
ledger records. This field is No if
reversing tax transactions have not been
sent to the general ledger. When the
transactions are sent to the general
ledger, this field changes to Yes. Valid
values are:
N = No.
Y = Yes.
|
|
APD-DST-OBJ-ID
Distribution Object
ID | Numeric 12
An object identifier to keep the record
unique.
|
|
APD-MA-CREATE-FL
Matching Creation
Flag | Alpha 1
Indicates the distribution was
generated during matching, as opposed to
entered manually during invoicing.
Also used during the match reversal
process to determine whether the
distribution should be deleted (match
distribution) or left untouched
(miscellaneous distribution).
|
|
APD-TAX-USAGE-CD
Element: Tax Usage Cd | Alpha 10
The tax usage coe for the vendor. This
filed is required if the AP Company
inidcates that VAT reporting required.
|
|
APD-TRAN-DIST-FLAG
Element: Final Dst Flag | Alpha 1
|
|
APD-PULL-FOR-FR-FL
Element: Pull For Fr Fl | Alpha 1
|
|
APD-AC-UPD-STATUS
Element: Ac Upd Status | Numeric 1
AC provides status that the activity
reflects "cash basis" billing. Status
change will reflect AP invoice for
distibution has been paid and message of
payment has been sent to AC.
0 = No payment information impact
1 = Requires payment information
9 = AP invoice paid. AC updated. |
|
APD-AC-UPD-DATE
Element: Ac Upd Date | Numeric 8 (yyyymmdd)
Last Ac distribtion record status change
date.
|
|
APD-AC-UPD-TIME
Element: Ac Upd Time | Numeric 6 (hhmmss)
Last AC distribution record change time.
|
|
APD-DIVERSE-CODE
Element: Diverse Code | Alpha 5
Diversity Code for Account Payable
Vendors
|
|
APD-DISTRIB-ADJ
Element: Distrib Adj | Numeric 1
Identifies distribution as one that was
created from AP30.2 Distribution
Adjustments. If created in AP30.2 form
value equal to '1'. Used to determine
source code to send to GLTRANS and
ACTRANS.
1 = Distribution Adjustment
0 |
|
APD-DIST-STATUS
Element: Dist Status | Derived
Indicates whether the distribution is
posted or unposted.
|
|
APD-TAX-FLAG
Element: All Flag | Alpha 1
|
|
APD-ICN-CODE
Element: Icn Code | Alpha 8
|
|
APD-WEIGHT
Element: Weight | Signed 9.3
This field contains the unit weight of
the item based on the stocking UOM.
|
|
APD-SUPLMNTARY-QTY
Element: Quantity | Signed 13.4
This field contains the desired
quantity.
|
|
APD-LINE-TYPE
Element: Line Type | Alpha 1
This field contains the type of
inventory on this line.
G = Goods
S = Service |
|
APD-STATEMENT
Element: Invoice | Alpha 22
Used to identify the invoice.
|
|
APD-TXN-NBR
Element: Transaction | Alpha 22
|
|
APD-RETAINAGE
Element: Flag Num | Numeric 1
0 = No
1 = Yes |
|
APD-PROD-TAX-CAT
Element: Prod Tax Cat | Alpha 15
|
|
APD-CREATED-BY
Element: Operator | Alpha 10
|
|
APD-LAST-UPDT-DATE
Element: Date | Numeric 8 (yyyymmdd)
|
|
APD-LAST-UPDT-TIME
Element: Time | Numeric 8
|
|
APD-LAST-UPDATE-BY
Element: Operator | Alpha 10
|
|
