PayablesPayments
PayablesPayments
Columns
Name | Type | Description |
CheckId [KEY] | String | CheckId |
PaymentId | String | PaymentId |
PaymentReference | String | PaymentReference |
PaperDocumentNumber | String | PaperDocumentNumber |
PaymentNumber | String | PaymentNumber |
PaymentFileReference | String | PaymentFileReference |
PaymentProcessRequest | String | PaymentProcessRequest |
PaymentAmount | String | PaymentAmount |
PaymentDate | Date | PaymentDate |
AccountingDate | Date | AccountingDate |
PaymentDescription | String | PaymentDescription |
ConversionRate | String | ConversionRate |
ConversionDate | Date | ConversionDate |
ConversionRateType | String | ConversionRateType |
ClearingDate | Date | ClearingDate |
ClearingAmount | String | ClearingAmount |
ClearingLedgerAmount | String | ClearingLedgerAmount |
ClearingConversionRate | String | ClearingConversionRate |
ClearingConversionDate | Date | ClearingConversionDate |
ClearingConversionRateType | String | ClearingConversionRateType |
CrossCurrencyRateType | String | CrossCurrencyRateType |
MaturityDate | Date | MaturityDate |
MaturityConversionRateType | String | MaturityConversionRateType |
MaturityConversionDate | Date | MaturityConversionDate |
MaturityConversionRate | String | MaturityConversionRate |
AnticipatedValueDate | Date | AnticipatedValueDate |
ClearingValueDate | Date | ClearingValueDate |
StopDate | Date | StopDate |
VoidDate | Date | VoidDate |
VoidAccountingDate | Date | VoidAccountingDate |
PaymentStatus | String | PaymentStatus |
SeparateRemittanceAdviceCreated | String | SeparateRemittanceAdviceCreated |
AccountingStatus | String | AccountingStatus |
ReconciledFlag | Bool | ReconciledFlag |
PaymentType | String | PaymentType |
PaymentCurrency | String | PaymentCurrency |
WithheldAmount | String | WithheldAmount |
BankChargeAmount | String | BankChargeAmount |
LegalEntity | String | LegalEntity |
BusinessUnit | String | BusinessUnit |
PaymentFunction | String | PaymentFunction |
Payee | String | Payee |
PartyId | String | PartyId |
ProcurementBU | String | ProcurementBU |
PayeeSite | String | PayeeSite |
EmployeeAddress | String | EmployeeAddress |
SupplierNumber | String | SupplierNumber |
ThirdPartySupplier | String | ThirdPartySupplier |
ThirdPartyAddressName | String | ThirdPartyAddressName |
ExternalBankAccountId | String | ExternalBankAccountId |
RemitToAccountNumber | String | RemitToAccountNumber |
DisbursementBankAccountNumber | String | DisbursementBankAccountNumber |
DisbursementBankAccountName | String | DisbursementBankAccountName |
PaymentMethodCode | String | PaymentMethodCode |
PaymentMethod | String | PaymentMethod |
PaymentDocument | String | PaymentDocument |
PaymentProcessProfileCode | String | PaymentProcessProfileCode |
PaymentProcessProfile | String | PaymentProcessProfile |
DocumentCategory | String | DocumentCategory |
DocumentSequence | String | DocumentSequence |
VoucherNumber | String | VoucherNumber |
PaymentBaseAmount | String | PaymentBaseAmount |
PaymentBaseCurrency | String | PaymentBaseCurrency |
AddressLine1 | String | AddressLine1 |
AddressLine2 | String | AddressLine2 |
AddressLine3 | String | AddressLine3 |
AddressLine4 | String | AddressLine4 |
City | String | City |
County | String | County |
Province | String | Province |
State | String | State |
Country | String | Country |
Zip | String | Zip |
CreatedBy | String | CreatedBy |
CreationDate | Datetime | CreationDate |
LastUpdatedBy | String | LastUpdatedBy |
LastUpdateDate | Datetime | LastUpdateDate |
LastUpdateLogin | String | LastUpdateLogin |