Agile_Lab / invoice_schema.py
jonels1988's picture
Update invoice_schema.py
4e5029e verified
Raw History Blame Contribute Delete
1.25 kB
from schemas import ColumnSchema, DatasetSchema
invoice_pipeline_schema = DatasetSchema(
name="invoice_pipeline",
strict_order=True,
strict_types=True,
columns=[
ColumnSchema("id", dtype="int64"),
ColumnSchema("document_type", dtype="string"),
ColumnSchema("document_number", dtype="string"),
ColumnSchema("reference_number", dtype="string", allow_null=True),
ColumnSchema("po_number", dtype="string", allow_null=True),
ColumnSchema("invoice_date", dtype="datetime64[ns]"),
ColumnSchema("due_date", dtype="datetime64[ns]", allow_null=True),
ColumnSchema("total_billed", dtype="float64"),
ColumnSchema("amount_outstanding", dtype="float64"),
ColumnSchema("discount", dtype="float64", allow_null=True),
ColumnSchema("credit_advances_applied", dtype="float64", allow_null=True),
ColumnSchema("payment_amount", dtype="float64", allow_null=True),
ColumnSchema("ar_status", dtype="string", allow_null=True),
ColumnSchema("open_balance", dtype="float64"),
],
)