CreatedById | Created By | Lookup → UserAccount | Yes | |
CreatedDateTime | Created On | DateAndTime | Yes | |
GSTIN | GSTIN | Text | | The buyer's GSTIN, taken from the GSTIN field of the sales invoice when it was posted. On the portal side it is the GSTIN GSTN returned. Reconciliation pairs B2B invoices on this GSTIN and the invoice number. It is blank for an SEZ supply posted without a GSTIN. |
GSTR1B2BSupplyId | B2B Supply | Lookup → GSTR1B2BSupply | | The B2B Supply group (one per buyer GSTIN) the invoice sits under. Carry Forward places the copy under next month's group for the same buyer GSTIN. |
Id | Id | Guid | Yes | |
InvoiceDate | Invoice Date | Date | | The document date of the source sales invoice, or the invoice date GSTN returned. It does not affect reconciliation pairing. |
InvoiceNumber | Invoice Number | Text | | The name of the source sales invoice on the books side, or the invoice number GSTN returned on the portal side. |
InvoiceType | Invoice Type | Text | | Regular for an ordinary B2B invoice. For a document whose Tax Supply Type contains SEZ: SezWP when it carries integrated tax, SezWOP when it does not. Portal-side rows can also read DeemedExport. Save to GSTN sends R, SEWP or SEWOP. SEZ invoices go to GSTR-3B table 3.1(b) and to GSTR-9 row 4D (SezWP) or 5B (SezWOP). |
InvoiceValue | Invoice Value | Currency | | The taxable value plus every tax head of the invoice, rounded to two decimals. On the portal side, the value GSTN returned. Matched requires it to agree within 1 rupee. |
IsCarriedForward | Carried Forward | Boolean | | Set when you choose Carry Forward. The invoice is left out of this return, and a copy is added to next month's return under the group for the same buyer GSTIN. |
IsIgnored | Ignored | Boolean | | Set when you choose Ignore on the invoice's reconciliation row. An ignored invoice is left out of the Overview figures, out of what Save to GSTN sends and out of GSTR-3B. |
Label | Label | Text | | Not set by xMatix. It stays blank. |
ModifiedById | Modified By | Lookup → UserAccount | Yes | |
Name | Name | Text | Yes | First a number from the B2B Invoices Name Setting (series B2BINV). After the next processing run that is not skipped, it becomes the invoice number. |
OwnerId | Owner | Lookup → UserAccount | Yes | |
PlaceOfSupply | Place Of Supply | Text | | The two-digit state code of the invoice's place of supply. Save to GSTN sends it as the invoice's place of supply. |
RecordTypeId | Record Type | Guid | | |
ReverseCharge | Reverse Charge | Boolean | | Taken from the Reverse Charge (eInvoice) setting of the sales invoice, or the reverse-charge flag GSTN returned. Reverse-charge invoices are counted under B2B Reverse Charge on the Overview, sent with flag Y, added to GSTR-3B table 3.1(a) like other B2B invoices, and put in GSTR-9 row 5C. |
Source | Source | Text | | Books for invoices built by Process GSTR1 from your posted sales, Portal for invoices imported by Pull from GSTIN. Processing only changes Books rows, and a pull only replaces Portal rows. |
SourceRecordId | Source Record | Guid, hidden | | On the books side, the posted sales invoice the row was built from. Re-processing matches on it, so the row keeps its identity and its decision from one run to the next. Empty on portal rows and on carried-forward copies. |
TaxableRate | Taxable Rate | Decimal | | The rate of the invoice's first tax line, recorded when the row was first built and not refreshed by later processing. For an intra-state invoice it is the central tax rate, not the combined rate. The rate-wise detail is on the GSTR-1 line items. |
TaxAmount | Tax Amount | Decimal | | The total of every tax head on the invoice. Refreshed on every processing run. |
UIProps | UI Props | Text | | |
UpdatedDateTime | Modified On | DateAndTime | Yes | |