| Search Online Doc | |
| Current Release Notes | |
|
Column Name |
Max Character |
Max Numeric |
Decimal Positions |
Required |
Notes |
|
H |
1
|
|
|
Yes | Each header line should have a 'H' in this column |
|
VendorNo |
15 |
|
|
Yes |
Set to 'OneTime' for one time vendor. |
|
InvoiceNo |
15 |
|
|
Yes |
|
|
Description |
50 |
|
|
|
|
|
Org |
15 |
|
|
Yes |
|
|
InvoiceDueDate |
|
|
|
|
MM/DD/YYYY |
|
InvoiceDate |
|
|
|
|
MM/DD/YYYY |
|
InvoiceRecvdDate |
|
|
|
|
MM/DD/YYYY |
|
TransactDate |
|
|
|
|
MM/DD/YYYY |
|
Period |
|
5 |
0 |
|
|
|
Year |
|
5 |
0 |
|
|
|
InvoiceTotal |
|
19 |
4 |
|
|
|
PayToName |
50 |
|
|
|
|
|
PayToAddressLine1 |
50 |
|
|
|
|
|
PayToAddressLine2 |
50 |
|
|
|
|
|
PayToAddressLine3 |
50 |
|
|
|
|
|
PayToCity |
30 |
|
|
|
|
|
PayToState |
2 |
|
|
|
|
|
PayToZipCode |
10 |
|
|
|
|
|
PayToCountry |
30 |
|
|
|
|
|
PaymentTerms |
10 |
|
|
|
|
|
DiscountAmt |
|
19 |
4 |
|
|
|
DiscountDate |
|
|
|
|
MM/DD/YYYY |
|
DiscountableAmt |
|
19 |
4 |
|
|
|
DiscountTerms |
10 |
|
|
|
|
|
CheckNo |
|
5 |
0 |
|
|
|
CheckDate |
|
|
|
|
MM/DD/YYYY |
|
InvoicingLoc |
15 |
|
|
|
|
|
InvoicingAPLoc |
15 |
|
|
|
|
|
PayingVendorNo |
15 |
|
|
|
|
|
PayingAPLocation |
15 |
|
|
|
|
|
InterOrgAcctsYN |
|
1 |
|
|
0 or 1 |
|
Code1099 |
2 |
|
|
|
|
|
TaxableAmt |
|
17 |
2 |
|
|
|
PayingOrg |
15 |
|
|
|
|
|
PaymentPriority |
|
1 |
|
|
|
|
SepPmtPerInvYN |
|
1 |
|
|
0 or 1 |
|
HoldPmtAmtYN |
|
1 |
|
|
0 or 1 |
|
OutstandingAmt |
|
17 |
2 |
|
|
|
HoldAmt |
|
17 |
2 |
|
|
|
ExternalSystem |
15 |
|
|
|
External system name. |
|
ExternalID |
15 |
|
|
|
Unique identifier of invoice in external system. |
|
PONo |
15 |
|
|
|
; |
|
ImportAsPostedYN |
1 |
|
|
0 or 1 | ||
ProjectCode |
10 |
|
|
|
Must be defined and valid for Org on header | |
FundCode |
10 |
|
|
|
Must be defined and valid for Org on header |
|
| DirectApprover | 20 |
|
|
|
Optional. Must be a valid invoice approver. | |
| ApproverGroup | 15 | ; |
|
|
Optional, must be valid invoice approver group | |
| DistReviewDirectApprover | 20 | Optional. Distribution review direct approver. Must be a valid invoice approver. | ||||
| DistReviewAprvGroup | 15 | Optional. Distribution review approver group. Must be a valid invoice approver group. | ||||
| FinReptFld1 | 15 | Optional. Financial reporting field. | ||||
| FinReptFld2 | 15 | Optional. Financial reporting field. | ||||
| FinReptFld2 | 15 | Optional. Financial reporting field. | ||||
| ImageFilename | 100 |
|
||||
| PayingOrgOverrideYN | 1 | Optional. Value can be 0 or 1. You can omit this column if you do not need it; but if you keep the column, do not leave it "blank."
When the column value is set to Yes (1), the PayingOrg on the invoice import overrides the Default Paying Organization on the organization record. |
||||
Column Name |
Max Character Length |
Max Numeric Length |
Decimal Positions |
Required |
Notes |
|
D |
1 |
|
|
Yes |
Each detail line should have a 'D' in this column |
|
InvLineNo |
|
5 |
0 |
|
|
|
GLAcct |
45 |
|
|
|
Formatted or unformatted |
|
LineAmount |
|
17 |
2 |
|
|
|
LineDesc |
50 |
|
|
|
|
|
Code1099 |
2 |
|
|
|
|
|
| InvLineType |
|
1 | 0 |
|
1=Goods, 2=Tax, 3=Charge | |
| TaxableYN |
|
1 | 0 |
|
0 or 1 (for InvLineType= 3 only) | |
| ProjectCode | 10 | Must be defined and valid for Org on header | ||||
FundCode |
10 |
|
|
|
Must be defined and valid for Org on header |
|
<EOF> |
|
|
|
|
|
Copyright © 2023 by Premier Inc. All rights reserved.