Accounts payable
File layout
- Recommend the file name begin with “AP_”
- Example: AP_Actual2020_JAN
-
Each month should have a file, and each file should have a unique file name.
| Field | Description | Field Type | Length |
|---|---|---|---|
| Entity | Entity or Hospital Identification Code | Numeric | 5 |
| Dept | Department or Cost Center Number | Numeric | 10 |
| Acct | GL Account Number | Numeric | 10 |
| Vendor Number | Vendor Number | Text | 25 |
| Vendor Name | Vendor Name | Text | 50 |
| PONum | Purchase Order Number | Text | 25 |
| ItemNoDesc | Item\Line Number Description | Text | 100 |
| InvoiceNum | Invoice Number | Text | 50 |
| Amount | Dollar Amount | Decimal | 11.2 |
| CheckNo | Check Number | Text | 25 |
| VendorImageLink | URL to vendor image location | Text | 1000 |
Sample file layout
