One level Up / One level Up: Структура таблиц / Table structure Epicor iScala 3.3 (x64) — 3.3.0419 :: Список таблиц модуля /List of tables of module «Purchase Order»

Структура таблиц / Table structure Epicor iScala 3.3 (x64) — 3.3.0419 :: Таблица / Table PC01 — Purchase Order Head

Таблица / Table: PC01 — «Purchase Order Head». Маска имени таблицы / Table name mask: «PC01%cc00»

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
PC01001 NCHAR STRING 10 0 10 PurchOrderNo Purchase Order Number   1 Да / Yes
PC01002 INT INTEGER 0 0 1 OrderType Order Type 0 — Purchase Order Proposal / Request for Quotation

1 — Normal Order

2 — Back Order

3 — Direct Delivery to Customer

4 — Replenishment Order
   
PC01003 NVARCHAR VSTRING 10 0 10 OrdSupplCode Order Supplier Code      
PC01004 NVARCHAR VSTRING 10 0 10 CustCodeDel Customer Code Delivery      
PC01005 NVARCHAR VSTRING 25 0 25 Remark1 Remark Line 1      
PC01006 NVARCHAR VSTRING 25 0 25 Remark2 Remark Line 2      
PC01007 INT INTEGER 0 0 1 FLPurchOrder Purchase Order Print Status 0 — Document not ready for printing

1 — Print document

2 — Document sent
   
PC01008 INT INTEGER 0 0 1 FLRemConf Reminder of Confirmation Print Status 0 — Document not ready for printing

1 — Print document

2 — Document sent
   
PC01009 INT INTEGER 0 0 1 FLRemShipm Reminder of Shipment Print Status 0 — Document not ready for printing

1 — Print document

2 — Document sent
   
PC01010 NCHAR SWITCH 1 0 1 FLDispNotEnt Delivery Note Entered      
PC01011 NCHAR SWITCH 1 0 1 FLInvEntered Invoice Entered      
PC01012 INT INTEGER 0 0 2 TermsOfPaym Payment Terms      
PC01013 INT INTEGER 0 0 2 TermsOfDel Delivery Terms      
PC01014 INT INTEGER 0 0 2 WayOfDel Delivery Method      
PC01015 DATETIME DATE 0 0 8 OrderDate Order Date      
PC01016 DATETIME DATE 0 0 8 DelDate Delivery Date      
PC01017 NVARCHAR VSTRING 35 0 35 OurReference Our Reference      
PC01018 NVARCHAR VSTRING 35 0 35 YourReferenc Your Reference      
PC01019 NUMERIC X_NUMERIC 14 8 6 OrderDiscoun Order Discount      
PC01020 NUMERIC MONEY 28 8 20 OrderValue Order Value (Local Currency)      
PC01021 NVARCHAR VSTRING 3 0 3 LanguageCode Language      
PC01022 INT INTEGER 0 0 2 CurrCode Currency Code      
PC01023 NVARCHAR VSTRING 6 0 6 WareHouse Warehouse      
PC01024 NCHAR SWITCH 1 0 1 ExternalControl External Control      
PC01025 NVARCHAR VSTRING 1 0 1 SPARE (obsolete)      
PC01026 NVARCHAR VSTRING 1 0 1 FLGRNXML Goods Received Note Sent (XML) 0 — Document not ready for sending

1 — Send document

2 — Document sent
   
PC01027 NVARCHAR VSTRING 1 0 1 ProposedPOType Proposed Purchase Order Type The default order type that shall be suggested when converting a purchase order proposal to an order. See PC01002 for description of the different order types.    
PC01028 NVARCHAR VSTRING 1 0 1 FLGRN Goods Received Note Printed 0 — Document not ready for printing

1 — Print document

2 — Document sent
   
PC01029 NVARCHAR VSTRING 1 0 1 UserOption3 (obsolete)      
PC01030 NCHAR SWITCH 1 0 1 CurrContract Currency Contract      
PC01031 NUMERIC X_NUMERIC 28 8 20 FixedExcRate Fixed Exchange Rate      
PC01032 NVARCHAR VSTRING 15 0 15 ContractNo Currency Contract Number      
PC01033 NVARCHAR ACCSTR 120 0 120 DefaultAcc Accounting String      
PC01034 NCHAR SWITCH 1 0 1 LetterOfCred Letter of Credit      
PC01035 DATETIME DATE 0 0 8 LetterOfCrOp Letter of Credit Open Date      
PC01036 DATETIME DATE 0 0 8 LetterOfCrDu Letter of Credit Due Date      
PC01037 NVARCHAR VSTRING 20 0 20 LettOfCreRef Letter of Credit Reference      
PC01038 NCHAR SWITCH 1 0 1 PartiaDelCde Partial Delivery Option      
PC01039 INT INTEGER 0 0 2 EDITransmCou EDI Transmit Count      
PC01040 INT INTEGER 0 0 2 EDIRecveCoun EDI Received Count      
PC01041 NCHAR SWITCH 1 0 1 EDIFlag1 EDI Flag 1 Currently not used for any specific functionality    
PC01042 NCHAR SWITCH 1 0 1 EDIFlag2 EDI Flag 2      
PC01043 NCHAR SWITCH 1 0 1 EDIFlag3 EDI Flag 3      
PC01044 NCHAR SWITCH 1 0 1 EDIFlag4 EDI Flag 4      
PC01045 NVARCHAR VSTRING 2 0 2 ShippAddrNo Shipping Address Number      
PC01046 NVARCHAR VSTRING 6 0 6 Purchaser Purchaser Code      
PC01047 NUMERIC X_NUMERIC 18 8 10 FixedExchgRate2 Fixed Exchange Rate 2      
PC01048 NCHAR STRING 3 0 3 FixedExchgAlgtm Fixed Exchange Algorithm      
PC01049 NCHAR SWITCH 1 0 1 EDIContractSwitch EDI Contract      
PC01050 NCHAR STRING 3 0 3 OrAdminCode Order Administrator      
PC01051 NVARCHAR VSTRING 30 0 30 ProjManagActivityID Project Activity Reference      
PC01052 NCHAR STRING 20 0 20 SupplierOrderNo Supplier Order Number      
PC01053 INT INTEGER 0 0 1 FLPurchOrderXML Purchase Order Sent Status (XML) 0 — Document not ready for sending

1 — Send document

2 — Document sent
   
PC01054 INT INTEGER 0 0 1 FLRenConfXML Reminder of Confirmation Send (XML) 0 — Document not ready for sending

1 — Send document

2 — Document sent
   
PC01055 INT INTEGER 0 0 1 FLRemShipmXML Reminder of Shipment Sent (XML) 0 — Document not ready for sending

1 — Send document

2 — Document sent
   
PC01056 NCHAR STRING 12 0 12 ProjectNumber Project Number      
PC01057 NCHAR STRING 25 0 25 SiteCode Site Code      
PC01058 NVARCHAR VSTRING 30 0 30 CustomerPoNumber Customer Purchase Order Number      
PC01059 NCHAR STRING 20 0 20 Spare (obsolete)      
PC01060 NCHAR STRING 30 0 30 ExtRemark1 Extended Remark Line 1      
PC01061 NCHAR STRING 30 0 30 ExtRemark2 Extended Remark Line 2      
PC01062 NCHAR STRING 10 0 10 RequestNo Customer Request Number      
PC01063 INT INTEGER 0 0 2 ImportOrder Import Order 0 — Not an Import Order

1 — Import Order
   
PC01064 INT INTEGER 0 0 2 ImportDocument Import Document Status 0 — Document not ready for printing

1 — Print document

2 — Document sent
   
PC01065 INT INTEGER 0 0 2 TransportDocument Transport Document Status 0 — Document not ready for printing

1 — Print document

2 — Document sent
   
PC01066 NVARCHAR VSTRING 25 0 25 InvoiceNoLast Invoice Number      
PC01067 NCHAR STRING 10 0 10 ContractNumber Contract Number      
PC01068 NCHAR STRING 1 0 1 LinkedToProject Project Linked Option 0 — Not Linked to Project

1 — Linked to Standard Cost Activity

2 — Linked to Purchase Order Activity (type 6)
   
PC01069 NCHAR SWITCH 1 0 1 FLAGReceivingClosed Closed for Receiving      
PC01070 NVARCHAR VSTRING 10 0 10 InstallationCustomer Installation Customer      
PC01071 NVARCHAR VSTRING 4 0 4 InstallationSite Installation Site      
PC01072 NCHAR STRING 10 0 10 ServiceMasterOrder Service Master Order      
PC01073 NVARCHAR VSTRING 8 0 8 UserID User ID for entry      
PC01074 NCHAR STRING 6 0 6 TaxLiability Tax Liability      
PC01075 NVARCHAR VSTRING 10 0 10 OperationType Operation Type      
PC01076 NVARCHAR VSTRING 10 0 10 FinOperationCode Financial Operation Code      
PC01077 NVARCHAR VSTRING 10 0 10 FiscTxtCode Fiscal Text Code      
PC01078 NVARCHAR VSTRING 25 0 25 FiscalNoteNo Number of printed Fiscal Note      
PC01079 DATETIME DATE 0 0 8 FiscalNoteDate Date of printed Fiscal Note      
PC01080 NCHAR SWITCH 1 0 1 Instalment Instalment      
PC01081 NUMERIC X_NUMERIC 18 8 10 NetWeight Net Weight      
PC01082 NUMERIC X_NUMERIC 18 8 10 GrossWeight Gross Weight      
PC01083 NUMERIC X_NUMERIC 18 8 10 NumberOfBoxes Number of Boxes      
PC01084 NVARCHAR VSTRING 15 0 15 KindOfBox Kind of Box      
PC01085 NVARCHAR VSTRING 15 0 15 BoxNumbering Box numbering      
PC01086 NVARCHAR VSTRING 15 0 15 NumberOfPallets Number of pallets      
PC01087 NVARCHAR VSTRING 10 0 10 TransportCompanyCode Transport Company Code      
PC01088 NUMERIC MONEY 28 8 20 FreightAmount Freight Amount      
PC01089 NUMERIC MONEY 28 8 20 PackingAmount Packing Amount      
PC01090 NUMERIC MONEY 28 8 20 InsuranceAmount Insurance Amount      
PC01091 NUMERIC MONEY 28 8 20 InvoicingFee Invoicing Fee      
PC01092 NUMERIC MONEY 28 8 20 OwnFreightAmount Own Freight Amount      
PC01093 NVARCHAR VSTRING 10 0 10 VehicleState Vehicle State/Province      
PC01094 NVARCHAR VSTRING 15 0 15 VehicleLicensePlate Vehicle License Plate      
PC01095 NCHAR STRING 6 0 6 FreightTaxCode Freight Tax Code      
PC01096 NCHAR STRING 6 0 6 PackingTaxCode Packing Tax Code      
PC01097 NCHAR STRING 6 0 6 InsuranceTaxCode Insurance Tax Code      
PC01098 NCHAR STRING 6 0 6 InvoicingTaxCode Invoicing Tax Code      
PC01099 NCHAR STRING 6 0 6 OwnFreightTaxCode Own Freight Tax Code      
PC01100 INT INTEGER 0 0 3 ReasonCode Reason Code      
PC01101 NVARCHAR VSTRING 200 0 200 EmailAddress Email address      
PC01102 DATETIME DATE 0 0 8 OrgReqDeliveryDate Org. Req. Delivery Date      
PC01103 NVARCHAR VSTRING 10 0 10 CodeANTT Code ANTT      
PC01104 NCHAR SWITCH 1 0 1 RedStornoOrd Red Storno Order      
PC01105 NCHAR STRING 1 0 1 TaxPoint Tax Point      
PC01106 NVARCHAR VSTRING 20 0 20 PublicProcuremCode1 Public Procurement Code1      
PC01107 NVARCHAR VSTRING 20 0 20 PublicProcuremCode2 Public Procurement Code2      
PC01108 NCHAR STRING 10 0 10 InvSupplCode Invoice Supplier Code      
PC01109 NCHAR STRING 1 0 1 PaymentFlag Payment Flag      

Навигация / Navigation: