| IntId
|
Primary key in local database |
| InvoiceId
|
Date+BILL_NO (130806190) (YYAAGGBILLNO) |
| InvoiceNo
|
Invoice no |
| ManualInvoiceNo
|
null (Invoice No on the paper) |
| Description
|
Payee Name |
| InvoiceDate
|
format is "yyyy-mm-dd" , eg: "2012-03-13" |
| InvoiceType
|
Static value "1" |
| ScenarioType
|
1 (default) |
| OrderNo
|
Order number |
| FicheNo
|
Fiche no of systems like Logo/Netsis |
| CheckNo
|
Check no of systems like Micros |
| Description
|
Invoice decription |
| FolioNo
|
Folio$_Tax table BILL_NO field |
| TotalAmount
|
Folio$_Tax table TOTAL_GROSS field |
| TotalPayAmount
|
Folio$_Tax table CLPAY fields |
| CurrencyCode
|
"TRY" |
| DiscountAmount
|
0 |
| TaxableAmount
|
Folio$_Tax table TOT_REV_TAXABLE field |
| RoundingAmount
|
Rounding amount |
| TaxAmount
|
Folio$_Tax TAX1_AMT…. + TAX10_AMT fields total |
| WithholdingTax
|
Withholding tax amount total |
| TaxExemption
|
Tax exemption amount total
|
| FolderIntId
|
Refers to a portal+ folder id that this invoice will be listed inside. |
| EnvelopeNo
|
GIB Envelope No (GUID) |
| InvoiceStatus
|
Current status of the invoice |
| ResponseState
|
Commercial invoice approval state. (Approved / rejected) |
| ExternalTrackNo
|
This is EInvoice integrator invoice number (eg: Netle Invoice Id) |
| Direction
|
Always "2" (means outgoing) |
| CreatedOn
|
Record insert datetime |
| CreatedBy
|
References which portal+ user inserted this record |
| ModifiedOn
|
Last invoice modify date |
| ModifiedBy
|
References which portal+ user inserted this record, null means "portal+ system" |
| ErrorMessage
|
Error message (if invoice is in error status) |
| SourceIntId
|
Source id of the invoice (EG: The Marmara Istanbul - Suite8, or Starbucks Üsküdar - MC, these are all added as a source in portal+) |
| GIBStatusCode
|
This field is updated when portal+ got a notification from GIB by EInvoice integrator about the status of the invoice |
| GIBStatus
|
This field is updated when portal+ got a notification from GIB by integrator about the status of the invoice |
| IntegratorSourceIntId
|
This field stores the EInvoice integrator source id that is selected to send this invoice to GIB (integrators are configured as sources in portal+) |
| CustomerId
|
Payee_name_id |
| CustomerName
|
Payee_name |
| CustomerTaxOffice
|
Payee_name Tax2_no |
| CustomerTaxNo
|
Payee_name Tax1_no |
| CustomerWebsite
|
Payee_name WEBADDRESS |
| CustomerEMail
|
Payee_name EMAIL |
| CustomerTel
|
Payee_name TELEPHONE |
| CustomerFax
|
Payee_name FAX |
| CustomerRoom
|
Payee_name Room |
| CustomerStreetName
|
Address1,address2,address3,address4 |
| CustomerBuildingName
|
Payee_name building name |
| CustomerBuildingNumber
|
Payee_name building number |
| CustomerCitySubdivisionName
|
Payee_name city or subdivision name |
| CustomerCityName
|
City in name_address |
| CustomerPostalZone
|
Postal code in name_Address |
| CustomerCountryName
|
COUNTRY description in name_address |
| SupplierIntId
|
Internal supplier account id |
| SupplierId
|
Supplier account id |
| SupplierName
|
Name of the Supplier |
| SupplierTaxOffice
|
Tax office of the Supplier account. This value is required to use this account inside an invoice that have to be sent to GIB |
| SupplierTaxNo
|
Tax number of the Supplier account. This value is required to use this account inside an invoice that have to be sent to GIB |
| SupplierWebsite
|
Website of the Supplier account |
| SupplierEMail
|
Email of the Supplier account |
| SupplierTel
|
Supplier account phone |
| SupplierFax
|
Supplier account fax |
| SupplierRoom
|
Supplier room number |
| SupplierStreetName
|
Supplier street name |
| SupplierBuildingName
|
Supplier building name |
| SupplierBuildingNumber
|
Supplier building number |
| SupplierCitySubdivisionName
|
Supplier city or subdivision name |
| SupplierCityName
|
Supplier city name |
| SupplierPostalZone
|
Supplier posta code |
| SupplierCountryName
|
Supplier country name |
| Invoice Lines
|
List of child invoice detail records
|
