One level Up / One level Up: Структура таблиц Epicor iScala 3.0 FSP4 — 3.0.4267 :: Список таблиц модуля «Purchase Order»

Структура таблиц Epicor iScala 3.0 FSP4 — 3.0.4267 :: Таблица PC41 — Purchase Order Head History

Таблица: PC41 — «Purchase Order Head History». Маска имени таблицы: «PC41%cc00»

Поле Тип поля Тип поля Scala Длина поля Точ­ность Длина Scala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
PC41001 NCHAR STRING 10 0 10 PurchOrderNo Purchase Order Number   1 Да
PC41002 INT INTEGER 0 0 1 OrderType Order Type      
PC41003 NVARCHAR VSTRING 10 0 10 SuppCodBuyer Supplier Code      
PC41004 NVARCHAR VSTRING 10 0 10 CustCodeDel Customer Code Delivery      
PC41005 NVARCHAR VSTRING 25 0 25 Remark1 Remark Line 1      
PC41006 NVARCHAR VSTRING 25 0 25 Remark2 Remark Line 2      
PC41007 INT INTEGER 0 0 1 FLPurchOrder Purchase Order Print Status      
PC41008 INT INTEGER 0 0 1 FLRemConf Reminder of Confirmation Print Status      
PC41009 INT INTEGER 0 0 1 FLRemShipm Reminder of Shipment Print Status      
PC41010 NCHAR SWITCH 1 0 1 FLDispNotEnt Delivery Note Entered      
PC41011 NCHAR SWITCH 1 0 1 FLInvEntered Invoice Entered      
PC41012 INT INTEGER 0 0 2 TermsOfPaym Payment Terms      
PC41013 INT INTEGER 0 0 2 TermsOfDel Delivery Terms      
PC41014 INT INTEGER 0 0 2 WayOfDel Delivery Method      
PC41015 DATETIME DATE 0 0 8 OrderDate Order Date      
PC41016 DATETIME DATE 0 0 8 DelDate Delivery Date      
PC41017 NVARCHAR VSTRING 20 0 20 OurReference Our Reference      
PC41018 NVARCHAR VSTRING 20 0 20 YourReferenc Your Reference      
PC41019 NUMERIC X_NUMERIC 14 8 6 OrderDiscoun Order Discount      
PC41020 NUMERIC MONEY 28 8 20 OrderValue Order Value (Local Currency)      
PC41021 NVARCHAR VSTRING 3 0 3 LanguageCode Language      
PC41022 INT INTEGER 0 0 2 CurrCode Currency Code      
PC41023 NVARCHAR VSTRING 6 0 6 WareHouse Warehouse      
PC41024 NCHAR SWITCH 1 0 1 ExternalControl External Control      
PC41025 NVARCHAR VSTRING 1 0 1 SPARE (obsolete)      
PC41026 NVARCHAR VSTRING 1 0 1 FLGRNXML Goods Received Note Sent (XML)      
PC41027 NVARCHAR VSTRING 1 0 1 ProposedPOType Proposed Purchase Order Type      
PC41028 NVARCHAR VSTRING 1 0 1 FLGRN Goods Received Note Printed      
PC41029 NVARCHAR VSTRING 1 0 1 UserOption3 (obsolete)      
PC41030 NCHAR SWITCH 1 0 1 CurrContract Currency Contract      
PC41031 NUMERIC X_NUMERIC 28 8 20 FixedExcRate Fixed Exchange Rate      
PC41032 NVARCHAR VSTRING 15 0 15 ContractNo Currency Contract Number      
PC41033 NVARCHAR ACCSTR 50 0 50 DefaultAcc Accounting String      
PC41034 NCHAR SWITCH 1 0 1 LetterOfCred Letter of Credit      
PC41035 DATETIME DATE 0 0 8 LetterOfCrOp Letter of Credit Open Date      
PC41036 DATETIME DATE 0 0 8 LetterOfCrDu Letter of Credit Due Date      
PC41037 NVARCHAR VSTRING 20 0 20 LettOfCreRef Letter of Credit Reference      
PC41038 NCHAR SWITCH 1 0 1 PartiaDelCde Partial Delivery Option      
PC41039 INT INTEGER 0 0 2 EDITransmCou EDI Transmit Count      
PC41040 INT INTEGER 0 0 2 EDIRecveCoun EDI Received Count      
PC41041 NCHAR SWITCH 1 0 1 EDIFlag1 EDI Flag 1      
PC41042 NCHAR SWITCH 1 0 1 EDIFlag2 EDI Flag 2      
PC41043 NCHAR SWITCH 1 0 1 EDIFlag3 EDI Flag 3      
PC41044 NCHAR SWITCH 1 0 1 EDIFlag4 EDI Flag 4      
PC41045 NVARCHAR VSTRING 2 0 2 ShippAddrNo Shipping Address Number      
PC41046 NVARCHAR VSTRING 6 0 6 Purchaser Purchaser Code      
PC41047 NUMERIC X_NUMERIC 18 8 10 FixedExchgRate2 Fixed Exchange Rate 2      
PC41048 NCHAR STRING 3 0 3 FixedExchgAlgtm Fixed Exchange Algorithm      
PC41049 NCHAR SWITCH 1 0 1 EDIContractSwitch EDI Contract      
PC41050 NCHAR STRING 3 0 3 OrAdminCode Order Administrator      
PC41051 NVARCHAR VSTRING 30 0 30 ProjManagActivityID Project Activity Reference      
PC41052 NCHAR STRING 20 0 20 SupplierOrderNo Supplier Order Number      
PC41053 INT INTEGER 0 0 1 FLPurchOrderXML Purchase Order Sent Status (XML)      
PC41054 INT INTEGER 0 0 1 FLRenConfXML Reminder of Confirmation Send (XML)      
PC41055 INT INTEGER 0 0 1 FLRemShipmXML Reminder of Shipment Sent (XML)      
PC41056 NCHAR STRING 12 0 12 ProjectNumber Project Number      
PC41057 NCHAR STRING 25 0 25 SiteCode Site Code      
PC41058 NCHAR STRING 20 0 20 CustomerPoNumber Customer Purchase Order Number      
PC41059 NCHAR STRING 20 0 20 Spare (obsolete)      
PC41060 NCHAR STRING 30 0 30 ExtRemark1 Extended Remark Line 1      
PC41061 NCHAR STRING 30 0 30 ExtRemark2 Extended Remark Line 2      
PC41062 NCHAR STRING 10 0 10 RequestNo Customer Request Number      
PC41063 INT INTEGER 0 0 2 ImportOrder Import Order      
PC41064 INT INTEGER 0 0 2 ImportDocument Import Document Status      
PC41065 INT INTEGER 0 0 2 TransportDocument Transport Document Status      
PC41066 NVARCHAR VSTRING 25 0 25 InvoiceNoLast Invoice Number   2 Да
PC41067 NCHAR STRING 10 0 10 ContractNumber Contract Number      
PC41068 NCHAR STRING 1 0 1 LinkedToProject Project Linked Option      
PC41069 NCHAR SWITCH 1 0 1 FLAGReceivingClosed Closed for Receiving      
PC41070 NVARCHAR VSTRING 10 0 10 InstallationCustomer Installation Customer      
PC41071 NVARCHAR VSTRING 4 0 4 InstallationSite Installation Site      
PC41072 NCHAR STRING 10 0 10 ServiceMasterOrder Service Master Order      
PC41073 NVARCHAR VSTRING 8 0 8 UserID User ID for entry      
PC41074 NCHAR STRING 6 0 6 TaxLiability Tax Liability      
PC41075 NVARCHAR VSTRING 10 0 10 OperationType Operation Type      
PC41076 NVARCHAR VSTRING 10 0 10 FinOperationCode Financial Operation Code      
PC41077 NVARCHAR VSTRING 10 0 10 FiscTxtCode Fiscal Text Code      
PC41078 NVARCHAR VSTRING 25 0 25 FiscNoteNo Fiscal Note Number      
PC41079 DATETIME DATE 0 0 8 FiscNoteDate Fiscal Note Date      
PC41080 NCHAR SWITCH 1 0 1 Instalment Instalment      
PC41081 NUMERIC X_NUMERIC 18 8 10 NetWeight Net Weight      
PC41082 NUMERIC X_NUMERIC 18 8 10 GrossWeight Gross Weight      
PC41083 NUMERIC X_NUMERIC 18 8 10 NumberOfBoxes Number of Boxes      
PC41084 NVARCHAR VSTRING 15 0 15 KindOfBox Kind of Box      
PC41085 NVARCHAR VSTRING 15 0 15 BoxNumbering Box numbering      
PC41086 NVARCHAR VSTRING 15 0 15 NumberOfPallets Number of pallets      
PC41087 NVARCHAR VSTRING 10 0 10 TransportCompanyCode Transport Company Code      
PC41088 NUMERIC MONEY 28 8 20 FreightAmount Freight Amount      
PC41089 NUMERIC MONEY 28 8 20 PackingAmount Packing Amount      
PC41090 NUMERIC MONEY 28 8 20 InsuranceAmount Insurance Amount      
PC41091 NUMERIC MONEY 28 8 20 InvoicingFee Invoicing Fee      
PC41092 NUMERIC MONEY 28 8 20 OwnFreightAmount Own Freight Amount      
PC41093 NVARCHAR VSTRING 10 0 10 VehicleState Vehicle State/Province      
PC41094 NVARCHAR VSTRING 15 0 15 VehicleLicensePlate Vehicle License Plate      
PC41095 NCHAR STRING 6 0 6 FreightTaxCode Freight Tax Code      
PC41096 NCHAR STRING 6 0 6 PackingTaxCode Packing Tax Code      
PC41097 NCHAR STRING 6 0 6 InsuranceTaxCode Insurance Tax Code      
PC41098 NCHAR STRING 6 0 6 InvoicingTaxCode Invoicing Tax Code      
PC41099 NCHAR STRING 6 0 6 OwnFreightTaxCode Own Freight Tax Code      
PC41100 INT INTEGER 0 0 3 ReasonCode Reason Code      
PC41101 NVARCHAR VSTRING 200 0 200 EmailAddress Email address      
PC41102 DATETIME DATE 0 0 8 OrgReqDeliveryDate Org. Req. Delivery Date      
PC41103 NVARCHAR VSTRING 10 0 10 CodeANTT Code ANTT      
PC41104 NCHAR SWITCH 1 0 1 RedStornoOrd Red Storno Order      
PC41105 NCHAR STRING 1 0 1 TaxPoint Tax Point      
PC41106 NVARCHAR VSTRING 20 0 20 PublicProcuremCode1 Public Procurement Code1      
PC41107 NVARCHAR VSTRING 20 0 20 PublicProcuremCode2 Public Procurement Code2      
PC41108 NCHAR STRING 10 0 10 InvSupplCode Invoice Supplier Code      

Навигация: