AuditFile |
Header |
AuditFileVersion |
|
CompanyID |
|
TaxRegistrationNumber |
|
TaxAccountingBasis Invoice Accounting, Cash Accounting, Delivery, other ...
|
|
CompanyName |
|
CompanyAddress |
BuildingNumber |
|
StreetName |
|
AddressDetail |
|
City |
|
PostalCode |
|
Region |
|
Country |
|
|
TaxEntity |
|
FiscalYear |
|
StartDate |
|
EndDate |
|
CurrencyCode |
|
DateCreated |
|
ProductID |
|
ProductVersion |
|
Taxonomy |
|
HeaderComment Comments on header file
|
|
|
MasterFiles |
(Choice)
{1,unbounded}
|
GeneralLedger |
AccountID |
|
AccountDescription |
|
AccountType |
|
LeadCode |
|
LeadDescription |
|
(Choice)
|
OpeningDebitBalance |
|
OpeningCreditBalance |
|
|
|
Customer |
CustomerID |
|
CustomerTaxID |
TaxRegistrationNumber |
|
TaxType |
|
TaxVerificationDate |
|
|
CompanyName |
|
Contact |
|
BillingAddress |
BuildingNumber |
|
StreetName |
|
AddressDetail |
|
City |
|
PostalCode |
|
Region |
|
Country |
|
|
ShipToAddress |
BuildingNumber |
|
StreetName |
|
AddressDetail |
|
City |
|
PostalCode |
|
Region |
|
Country |
|
|
Telephone |
|
Fax |
|
Email |
|
Website |
|
|
Supplier |
SupplierID |
|
SupplierTaxID |
TaxRegistrationNumber |
|
TaxType |
|
TaxVerificationDate |
|
|
CompanyName |
|
Contact |
|
BillingAddress |
BuildingNumber |
|
StreetName |
|
AddressDetail |
|
City |
|
PostalCode |
|
Region |
|
Country |
|
|
ShipToAddress |
BuildingNumber |
|
StreetName |
|
AddressDetail |
|
City |
|
PostalCode |
|
Region |
|
Country |
|
|
Telephone |
|
Fax |
|
Email |
|
Website |
|
|
TaxTable |
TaxType
{1,unbounded}
|
Description |
|
TaxCodeDetails
{1,unbounded}
|
TaxCode |
|
Description |
|
TaxPercentage |
|
|
|
|
|
|
GeneralLedgerEntries |
NumberOfEntries |
|
TotalDebit |
|
TotalCredit |
|
Journal
{0,unbounded}
|
JournalID Source GL journal identifier, or invoices and payments in single ledger systems
|
|
Description |
|
Type Grouping mechanism for journals
|
|
Transaction
{0,unbounded}
|
TransactionID |
|
Period |
|
TransactionDate |
|
SourceID Details of person or application entered the transaction
|
|
Description |
|
BatchID |
|
GLPostingDate |
|
CustomerID |
|
SupplierID |
|
SystemID |
|
Line
{0,unbounded}
|
RecordID |
|
AccountID |
|
Analysis
{0,unbounded}
|
|
SourceDocumentID Source document number to which line relates
|
|
SystemEntryDate Date captured by system
|
|
Description |
|
DebitAmount |
|
CreditAmount |
|
Tax
{0,unbounded}
|
TaxType |
|
TaxCode |
|
Currency |
CurrencyCode |
|
(Choice)
|
ExchangeRate |
@CalculationType D = Divide. M = Multiply
|
|
CurrencyDebitAmount |
|
CurrencyCreditAmount |
|
|
|
TaxPercentage |
|
TaxAmount |
|
TaxExemptionReason |
|
SysInfo System Information and controls - generic holder for information on above.
|
|
|
Currency |
CurrencyCode |
|
(Choice)
|
ExchangeRate |
@CalculationType D = Divide. M = Multiply
|
|
CurrencyDebitAmount |
|
CurrencyCreditAmount |
|
|
|
|
|
|
|
SourceDocuments |
(Choice)
{1,unbounded}
|
SalesInvoices |
NumberOfEntries |
|
TotalDebit |
|
TotalCredit |
|
Invoice
{1,unbounded}
|
InvoiceNo |
|
Period |
|
InvoiceDate |
|
InvoiceType |
|
GLPostingDate |
|
BatchID |
|
SystemID |
|
TransactionID |
|
Line
{1,unbounded}
|
LineNumber |
|
AccountID |
|
Analysis
{0,unbounded}
|
|
CustomerID |
|
OrderReferences
{0,unbounded}
|
|
ShipTo
{0,unbounded}
|
DeliveryID |
|
DeliveryDate |
|
UCR |
|
Address |
BuildingNumber |
|
StreetName |
|
AddressDetail |
|
City |
|
PostalCode |
|
Region |
|
Country |
|
|
|
ShipFrom
{0,unbounded}
|
DeliveryID |
|
DeliveryDate |
|
UCR |
|
Address |
BuildingNumber |
|
StreetName |
|
AddressDetail |
|
City |
|
PostalCode |
|
Region |
|
Country |
|
|
|
ProductCode |
|
ProductDescription |
|
Quantity |
|
UnitOfMeasure |
|
UnitPrice |
|
TaxPointDate |
|
References |
|
Description |
|
DebitAmount |
|
CreditAmount |
|
Tax
{0,unbounded}
|
TaxType |
|
TaxCode |
|
Currency |
CurrencyCode |
|
(Choice)
|
ExchangeRate |
@CalculationType D = Divide. M = Multiply
|
|
CurrencyDebitAmount |
|
CurrencyCreditAmount |
|
|
|
TaxPercentage |
|
TaxAmount |
|
TaxExemptionReason |
|
SysInfo System Information and controls - generic holder for information on above.
|
|
|
Currency |
CurrencyCode |
|
(Choice)
|
ExchangeRate |
@CalculationType D = Divide. M = Multiply
|
|
CurrencyDebitAmount |
|
CurrencyCreditAmount |
|
|
|
|
DocumentTotals |
TaxPayable |
|
NetTotal |
|
GrossTotal |
|
Currency |
CurrencyCode |
|
(Choice)
|
ExchangeRate |
@CalculationType D = Divide. M = Multiply
|
|
CurrencyDebitAmount |
|
CurrencyCreditAmount |
|
|
|
Settlement |
SettlementDiscount Settlement / Other Discount
|
|
SettlementAmount Settlement amount
|
|
SettlementDate Date settled
|
|
PaymentMechanism Payment mechanism
|
|
|
|
|
|
PurchaseInvoices |
NumberOfEntries |
|
TotalDebit |
|
TotalCredit |
|
Invoice
{1,unbounded}
|
InvoiceNo |
|
Period |
|
InvoiceDate |
|
InvoiceType |
|
GLPostingDate |
|
BatchID |
|
SystemID |
|
TransactionID |
|
Line
{1,unbounded}
|
LineNumber |
|
AccountID |
|
Analysis
{0,unbounded}
|
|
SupplierID |
|
OrderReferences
{0,unbounded}
|
|
ShipTo
{0,unbounded}
|
DeliveryID |
|
DeliveryDate |
|
UCR |
|
Address |
BuildingNumber |
|
StreetName |
|
AddressDetail |
|
City |
|
PostalCode |
|
Region |
|
Country |
|
|
|
ShipFrom
{0,unbounded}
|
DeliveryID |
|
DeliveryDate |
|
UCR |
|
Address |
BuildingNumber |
|
StreetName |
|
AddressDetail |
|
City |
|
PostalCode |
|
Region |
|
Country |
|
|
|
ProductCode |
|
ProductDescription |
|
Quantity |
|
UnitOfMeasure |
|
UnitPrice |
|
TaxPointDate |
|
References |
|
Description |
|
DebitAmount |
|
CreditAmount |
|
Tax
{0,unbounded}
|
TaxType |
|
TaxCode |
|
Currency |
CurrencyCode |
|
(Choice)
|
ExchangeRate |
@CalculationType D = Divide. M = Multiply
|
|
CurrencyDebitAmount |
|
CurrencyCreditAmount |
|
|
|
TaxPercentage |
|
TaxAmount |
|
TaxExemptionReason |
|
SysInfo System Information and controls - generic holder for information on above.
|
|
|
Currency |
CurrencyCode |
|
(Choice)
|
ExchangeRate |
@CalculationType D = Divide. M = Multiply
|
|
CurrencyDebitAmount |
|
CurrencyCreditAmount |
|
|
|
|
DocumentTotals |
TaxPayable |
|
NetTotal |
|
GrossTotal |
|
Currency |
CurrencyCode |
|
(Choice)
|
ExchangeRate |
@CalculationType D = Divide. M = Multiply
|
|
CurrencyDebitAmount |
|
CurrencyCreditAmount |
|
|
|
Settlement |
SettlementDiscount Settlement / Other Discount
|
|
SettlementAmount Settlement amount
|
|
SettlementDate Date settled
|
|
PaymentMechanism Payment mechanism
|
|
|
|
|
|
Payments |
NumberOfEntries |
|
TotalDebit |
|
TotalCredit |
|
Payment
{1,unbounded}
|
PaymentRefNo |
|
Period |
|
TransactionID |
|
TransactionDate |
|
PaymentType |
|
Description |
|
BatchID |
|
SystemID |
|
Line
{1,unbounded}
|
LineNumber |
|
SourceDocumentRef The source document to which the line relates
|
|
AccountID |
|
Analysis
{0,unbounded}
|
|
CustomerID |
|
SupplierID |
|
TaxPointDate |
|
Description |
|
DebitAmount |
|
CreditAmount |
|
Tax
{0,unbounded}
|
TaxType |
|
TaxCode |
|
Currency |
CurrencyCode |
|
(Choice)
|
ExchangeRate |
@CalculationType D = Divide. M = Multiply
|
|
CurrencyDebitAmount |
|
CurrencyCreditAmount |
|
|
|
TaxPercentage |
|
TaxAmount |
|
TaxExemptionReason |
|
SysInfo System Information and controls - generic holder for information on above.
|
|
|
Currency |
CurrencyCode |
|
(Choice)
|
ExchangeRate |
@CalculationType D = Divide. M = Multiply
|
|
CurrencyDebitAmount |
|
CurrencyCreditAmount |
|
|
|
|
DocumentTotals |
TaxPayable |
|
NetTotal |
|
GrossTotal |
|
Currency |
CurrencyCode |
|
(Choice)
|
ExchangeRate |
@CalculationType D = Divide. M = Multiply
|
|
CurrencyDebitAmount |
|
CurrencyCreditAmount |
|
|
|
Settlement |
SettlementDiscount Settlement / Other Discount
|
|
SettlementAmount Settlement amount
|
|
SettlementDate Date settled
|
|
PaymentMechanism Payment mechanism
|
|
|
|
|
|
|
|
|