Exporting Vendor payment status by Dataentity
/// <summary>
/// Entity for exporting file of payment status.
/// </summary>
public class KGSPMIVendorPaymentStatusEntity extends common
{
/// <summary>
/// Updates the unmapped fields after population.
/// </summary>
public void postLoad()
{
str recordTypeValue = '600';
str paymentMethodCheck = 'C';
VendTrans tmpVendTrans;
VendSettlement vendSettlement;
super();
vendSettlement = VendSettlement::find(this.RecId1);
this.RecordType = recordTypeValue;
this.TotalAmount = abs(this.SettleAmountCur);
this.PaymentDate = date2Str(this.TransDate,321,2,DateSeparator::None,2,DateSeparator::None,4);
this.Account = VendTable::find(this.AccountNum).vendorName();
if(this.PaymMode == "Check")
{
this.PaymentMethod = paymentMethodCheck;
}
else
{
this.PaymentMethod = "";
}
tmpVendTrans = VendTrans::findByCompany(vendSettlement.company(), vendSettlement.TransRecId);
this.Invoice = tmpVendTrans.Invoice;
}
}
1.1
Privileges
1.1.1.1
KGSPMIVendorPaymentstatusEntityMaintain
1.1.1.2
KGSPMIVendorPaymentStatusEntityView
1.1.1.1
KGSPMIVendorPaymentStatusEntity
1.1.1.1
KGSPMIVendorPaymentStatusStaging
/// Entity for exporting file of payment status.
/// </summary>
public class KGSPMIVendorPaymentStatusEntity extends common
{
/// <summary>
/// Updates the unmapped fields after population.
/// </summary>
public void postLoad()
{
str recordTypeValue = '600';
str paymentMethodCheck = 'C';
VendTrans tmpVendTrans;
VendSettlement vendSettlement;
super();
vendSettlement = VendSettlement::find(this.RecId1);
this.RecordType = recordTypeValue;
this.TotalAmount = abs(this.SettleAmountCur);
this.PaymentDate = date2Str(this.TransDate,321,2,DateSeparator::None,2,DateSeparator::None,4);
this.Account = VendTable::find(this.AccountNum).vendorName();
if(this.PaymMode == "Check")
{
this.PaymentMethod = paymentMethodCheck;
}
else
{
this.PaymentMethod = "";
}
tmpVendTrans = VendTrans::findByCompany(vendSettlement.company(), vendSettlement.TransRecId);
this.Invoice = tmpVendTrans.Invoice;
}
}
1.1
Privileges
1.1.1.1
KGSPMIVendorPaymentstatusEntityMaintain
Entry points
Name
|
Object Name
|
Object Type
|
Access Level
|
KGSPMIVendorPaymentStatusEntity
|
KGSPMIVendorPaymentStatusEntity
|
DataEntity
|
Delete
|
1.1.1.2
KGSPMIVendorPaymentStatusEntityView
Entry points
Name
|
Object Name
|
Object Type
|
Access Level
|
KGSPMIVendorPaymentStatusEntity
|
KGSPMIVendorPaymentStatusEntity
|
DataEntity
|
Read
|
1.1.1.1
KGSPMIVendorPaymentStatusEntity
Change type: Add
Field name
|
(Extended) data type
|
Change type
|
Configuration key
|
Other properties
|
RecordType
|
Str
|
ADD
|
|
|
PaymentDate
|
Str
|
ADD
|
|
|
Account
|
Str
|
ADD
|
|
|
PaymentMethod
|
Str
|
ADD
|
|
|
Check
|
BankChequeNum
|
ADD
|
|
|
InvoiceValue
|
VendInvoiceId
|
ADD
|
|
|
Currency
|
CurrencyCode
|
ADD
|
|
|
Reserved1
|
Description255
|
ADD
|
|
|
Reserved2
|
Description255
|
ADD
|
|
|
Reserved3
|
Description255
|
ADD
|
|
|
Reserved4
|
Description255
|
ADD
|
|
|
Reserved5
|
Description255
|
ADD
|
|
|
TotalAmount
|
Real
|
ADD
|
|
|
TransDate
|
TransDate
|
ADD
|
|
|
Voucher
|
Voucher
|
ADD
|
|
|
SettleAmoountCur
|
Real
|
ADD
|
|
|
AccountNum
|
VendAccount
|
ADD
|
|
|
RecId1
|
RefRecId
|
ADD
|
|
|
PaymMode
|
PaymMode
|
ADD
|
|
|
Methods (Put NA if not used) but keep the
section
Method name
|
Method signature
|
Pseudo code
|
Remarks
|
PostLoad( )
|
public void postLoad()
|
//implement most of their business logic related
to integrations
|
To update unMapped fields on
update as we are not receiving these in the file and these are mandatory for Vendor
Payment Status.
|
1.1.1.1
KGSPMIVendorPaymentStatusStaging
Change type: Add
This table is the staging table of data entity created for Vendor
Payment Status Export.
Fields (Put NA Is not used)
Field name
|
(Extended) data type or Enum
|
Change type
|
Configuration key
|
Other properties
|
DefinitionGroup
|
DMFDefinitionGroupName
|
ADD
|
|
|
ExecutionId
|
DMFExecutionId
|
ADD
|
|
|
IsSelected
|
DMFIsSelected
|
ADD
|
|
|
TransferStatus
|
DMFTransferStatus
|
ADD
|
|
|
RecordType
|
Str
|
ADD
|
|
|
PaymentDate
|
Str
|
ADD
|
|
|
PaymentMethod
|
Str
|
ADD
|
|
|
InvoiceValue
|
VendInvoiceId
|
ADD
|
|
|
Reserved1
|
Description255
|
ADD
|
|
|
Reserved2
|
Description255
|
ADD
|
|
|
Reserved3
|
Description255
|
ADD
|
|
|
Reserved4
|
Description255
|
ADD
|
|
|
Reserved5
|
Description255
|
ADD
|
|
|
Account
|
str
|
ADD
|
|
|
TotalAmount
|
Real
|
ADD
|
|
|
Check
|
BankChequeNum
|
ADD
|
|
|
Currency
|
CurrencyCode
|
ADD
|
|
|
Field groups (Put NA Is not used)
Field group
name
|
Fields
|
Justification
|
ExtensionList
|
DefinitionGroup
|
|
|
ExecutionId
|
|
|
IsSelected
|
|
|
TransferStatus
|
|
Field groups (Put NA Is not used)
Field group
name
|
Fields
|
Justification
|
AutoIdentification
|
DefinitionGroup
|
|
|
ExecutionId
|
|
|
InvoiceValue
|
|
Indexes (PUT NA is not used)
Index
|
Allow duplicates
|
Fields
|
Justification
|
StagingIdx
|
No
|
DefinitionGroup, ExecutionId, InvoiceValue
|
|
Relations
Relation
|
Table
|
Validate
|
Justification
|
DataEntity
|
KGSPMIVendorPaymentStatusEntity
|
No
|
|
Comments
Post a Comment