Localizations
T5018EFileRow
Rows that are specific to vendor's summarized transactions for a T5018 revision. Each row belongs to T5018MasterTable and is comprised of one or multiple APInvoiceEFileRevision records.
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
AmendmentRow | bit | - | ||
Description:A Boolean value that indicates if the row should be included in an amendment. | ||||
Amount | decimal | Amount to Report | - | |
Description:The summed amount of APAdjust records applicable for the vendor in the revision. | ||||
BAccountID | int | - | ||
Description:The business account ID of the associated vendor's account. The value of this field corresponds to the value of the BAccount.BAccountID field. | ||||
OrganizationID | int | T5018MasterTable | ||
Description:The organization ID of associated revision. The field is included in FK.T5018MasterTableFK. The value of this field corresponds to the value of the T5018MasterTable.OrganizationID field. | ||||
OrganizationName | nvarchar(60) | Payer | - | |
Description:The name of the organization associated with the revision. | ||||
ReportType | nvarchar | Report Type | - | |
Description:String value indicating the report type the row belongs to; Original, Amendment or Cancellation. | ||||
Revision | nvarchar(3) | Revision | T5018MasterTable | |
Description:The revision number of the associated revision. The field is included in FK.T5018MasterTableFK. The value of this field corresponds to the value of the T5018MasterTable.Revision field. | ||||
TaxRegistrationID | nvarchar(50) | Tax Registration ID | - | |
Description:The tax registration number of the vendor. The value of this field corresponds to the value of the T5018VendorExt.BusinessNumber field. | ||||
TotalServiceAmount | decimal | Total Service Amount | - | |
Description:The summed amount of APAdjust records applicable for the vendor in the revision. | ||||
VAcctCD | nvarchar(30) | Vendor | - | |
Description:The vendor account CD. The value of this field corresponds to the value of the BAccount.AcctCD field. | ||||
VendorName | nvarchar(60) | Vendor Name | - | |
Description:The name of the vendor. The value of this field corresponds to the value of the BAccount.AcctName field. | ||||
Year | nvarchar(4) | - | ||
Description:The year of the associated revision. The field is included in FK.T5018MasterTableFK. The value of this field corresponds to the value of the T5018MasterTable.Year field. | ||||