USR$INV ADDINFO

Реквизиты ТТН

CREATE TABLE USR$INV_ADDINFO 
(
  ID	USR$INV_ADDINFO_DPK NOT NULL,
  USR$WAYSHEETNUMBER  DTEXT20,
  USR$ATTORNEYKEY     USR$INV_DATTORNEY,
  USR$BASE	      DTEXT80,
  USR$CARGOPLACECOUNT DQUANTITY,
  USR$CARKEY	      USR$INV_DCAR,
  USR$CAROWNERKEY     USR$INV_DCONT,
  USR$CODE1	      DTEXT20,
  USR$CODE2	      DTEXT20,
  USR$CODE3	      DTEXT20,
  USR$CODE4	      DTEXT20,
  USR$CODE5	      DTEXT20,
  USR$CODE6	      DTEXT20,
  USR$CODE7	      DTEXT20,
  USR$CONTRACTKEY     USR$INV_DCONTRACT,
  USR$CUSTOMERKEY     USR$INV_DCONT,
  USR$DRIVERKEY	      USR$INV_DCONT,
  USR$GARAGE	      DTEXT10,
  USR$GROSSWEIGHT     DQUANTITY,
  USR$HAULQUANTITY    DSMALLINT,
  USR$HOOKED	      DTEXT20,
  USR$LOADCODE	      DTEXT10,
  USR$LOADDOWNTIME    DTIME,
  USR$LOADERKEY	      USR$GS_DCUSTOMER,
  USR$LOADIN	      DTIMESTAMP,
  USR$LOADINGPOINT    DTEXT60,
  USR$LOADMETHOD      DTEXT20,
  USR$LOADOUT	      DTIMESTAMP,
  USR$PAYCONDKEY      USR$INV_DPAYCOND,
  USR$PERMITKEY	      USR$INV_DCONT,
  USR$PURPOSEKEY      USR$INV_DPURPOSE,
  USR$READDRESSING    DTEXT60,
  USR$RECEIVERKEY     USR$INV_DCONT,
  USR$RECIPIENTKEY    USR$INV_DCONT,
  USR$REMORDERABBR    DTEXT8,
  USR$REMORDERINFO    DTEXT40,
  USR$ROUTE	      DTEXT10,
  USR$SENDERKEY	      USR$INV_DCONT,
  USR$TRANSSUM	      DCURRENCY,
  USR$TYPETRANSKEY    USR$INV_DTYPETRANS,
  USR$UNLOADERKEY     USR$GS_DCUSTOMER,
  USR$UNLOADINGPOINT  DTEXT60,
  USR$ACCDATE	      DDATE,
  USR$BILL_DATE	      DDATE,
  USR$BILL_NUMBER     DTEXT40,
  USR$CMR_DATE	      DDATE,
  USR$CMR_NUMBER      DTEXT40,
  USR$CODEBLANK	      DTEXT10,
  CONSTRAINT USR$INV_ADDINFO_PK PRIMARY KEY (ID)
);