RdsDiagram
stock_rawdata_header
row_id: INTEGER
suppliername: VARCHAR(50)
invno: INTEGER
invdate: INTEGER
ponum: VARCHAR(61)
NET: DECIMAL(11,3)
VAT: DECIMAL(11,3)
gross: DECIMAL(11,3)
originfilepath: VARCHAR(100)
reqFlags: VARCHAR(10)
stock_BPOdata_header
row_id: INTEGER
suppliername: VARCHAR(50)
suppliercode: VARCHAR(20)
invno: VARCHAR(20)
invdate: DATE
ponum: VARCHAR(61)
NET: DECIMAL(11,3)
VAT: DECIMAL(11,3)
Gross: DECIMAL(11,3)
costcentre: VARCHAR(10)
imported: VARCHAR(2)
reqFlags: VARCHAR(10)
invuFlag: VARCHAR(10)
originfilepath: VARCHAR(100)
stock_TRAXS_goods_received
row_id: INTEGER
datetime: DATE
barcode: VARCHAR(20)
description: VARCHAR(100)
quantity: DECIMAL(38,3)
unit_cost: DECIMAL(11,4)
line_cost: DECIMAL(38,7)
move_doc_no: VARCHAR(61)
supplier: VARCHAR(50)
supplier_code: VARCHAR(20)
po_no: VARCHAR(61)
po_supplier_ref: VARCHAR(61)
supp_prod_code: VARCHAR(30)
known_discrepancy: DECIMAL(11,4)
branch_code: VARCHAR(10)
SageData_Suppliers
PLSupplierAccountID: VARCHAR(10)
SupplierAccountNumber: VARCHAR(20)
SupplierAccountName: VARCHAR(50)
DefaultNominalAccountNumber: VARCHAR(10)
DefaultNominalCostCentre: VARCHAR(10)
DefautNominalDepartment: VARCHAR(10)
PaymentTermsInDays: INTEGER
MainTelephoneAreaCode: VARCHAR(10)
MainTelephoneSubscriberNumber: VARCHAR(8)
TelephoneNumber: VARCHAR(12)
AddressLine1: VARCHAR(20)
PostCode: VARCHAR(10)
Country: VARCHAR(10)