Vendor statement
These tables show the field mapping information of the fields that you can use to build your vendor statement IDM template.
List: VendorStatementHeaderList
VendorStatement/VendorStatementHeader
| XML field | Description |
|---|---|
| VendorGroup | VendorGroup |
| Vendor | Vendor |
| VendorName | Vendor.VendorName |
| VendorAddressLine1 | Vendor.VendorAddress.DeliveryAddress.AddressLine1 |
| VendorAddressLine2 | Vendor.VendorAddress.DeliveryAddress.AddressLine2 |
| VendorAddressLine3 | Vendor.VendorAddress.DeliveryAddress.AddressLine3 |
| VendorAddressLine4 | Vendor.VendorAddress.DeliveryAddress.AddressLine4 |
| VendorMunicipality | Vendor.VendorAddress.Municipality |
| VendorStateProvince | Vendor.VendorAddress.StateProvince |
| VendorCountry | Vendor.VendorAddress.Country |
| VendorPostalCode | Vendor.VendorAddress.PostalCode |
| TaxID | Vendor.TaxID |
| Company | Company |
| CompanyName | Company.CompanyName |
| StatementDate | DerivedStatementDate |
| BeginningDebitAmount | BeginningDebitAmount |
| BeginningCreditAmount | BeginningCreditAmount |
| EndingDebitAmount | EndingDebitAmount |
| EndingCreditAmount | EndingCreditAmount |
| BeginningBalance | DerivedBeginningBalance |
| EndingBalance | DerivedEndingBalance |
| PeriodYear | PeriodYear |
List: VendorStatementDetailList
Path: VendorStatement/VendorStatementHeader/VendorStatementDetail
| XML field | Description |
|---|---|
| TransactionDate | TransDate |
| TransactionID | TransID |
| Suffix | DerivedSuffix |
| TransactionType | TransType |
| DueDate | DueDate |
| PurchaseOrder | PurchaseOrder |
| Description | Description |
| DebitAmount | DebitAmount |
| CreditAmount | CreditAmount |
| Currency | VendorStatementHeader.Currency |
| RunningBalance | RunningBalance |