POHDROUT – No description in the Lawson data dictionary

System
Purchase Order (PO)
Prefix
PIH
Primary key
COMPANY, PO-CODE, PO-NUMBER, PO-RELEASE, PO-REVISION, CREATION-DATE, CREATION-TIME
Fields
98
Updated by
222 programs
Referenced by
0 programs

POHDROUT is a Lawson Purchase Order table (prefix PIH); no description in the lawson data dictionary. It is indexed by COMPANY, PO-CODE, PO-NUMBER, PO-RELEASE, PO-REVISION, CREATION-DATE, CREATION-TIME (PIHSET1); alternate indexes: PIHSET2 and PIHSET3. It is related 1:1 to ICCOUT and 1:M to POLINEOUT. It is updated by AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 and 214 more. The table has 98 fields, 3 indexes and 2 documented relations.

About POHDROUT

No description in the Lawson data dictionary.

Fields (98)

Column = COBOL field name without the PIH- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
PIH-COMPANY PK
COMPANY
Numeric 4Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PIH-PO-NUMBER PK
PO_NUMBER
Alpha 14 (Right Justified)This field contains the number representing the purchase order.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PIH-PO-RELEASE PK
PO_RELEASE
Numeric 4Used to identify a purchase order release (created from a Blanket or Standing order).AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PIH-PO-CODE PK
PO_CODE
Alpha 4This is the purchase order code.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PIH-PO-REVISION PK
PO_REVISION
Numeric 3The PO Revision number. Assigned sequentially by the system when the PO is revised.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PIH-CREATION-DATE PK
CREATION_DATE
Numeric 8 (yyyymmdd)This is the date that this line was added to the requisition.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PIH-CREATION-TIME PK
CREATION_TIME
Numeric 6 (hhmmss)The creation time.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PIH-RECORD-TYPE
RECORD_TYPE
Alpha 1This field identifies the type of record defined. Valid values are:
  • S Summary
  • D Detail
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PIH-RECORD-STAT
RECORD_STAT
Numeric 1AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PIH-RETURN-NUMBER
RETURN_NUMBER
Numeric 10This is the number assigned to the return for purposes of referencing the return internally and with the customer or vendor.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PIH-VENDOR
VENDOR
Alpha 9 (Right Justified)The vendor's identification code.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PIH-PURCH-FR-LOC
PURCH_FR_LOC
Alpha 4The vendor's purchase from location.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PIH-BUYER-CODE
BUYER_CODE
Alpha 3AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PIH-BLKT-STD-AGRMT
BLKT_STD_AGRMT
Alpha 30AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PIH-PO-DATE
PO_DATE
Numeric 8 (yyyymmdd)This field displays the system date when this was created.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PIH-CURRENCY-CODE
CURRENCY_CODE
Alpha 5This field contains the company base currency code established in Company (GL10.1 ).AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PIH-ENT-CNV-RATE
ENT_CNV_RATE
Signed 14.7Currency conversion rate at Purchase Order entry time.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PIH-REC-CNV-RATE
REC_CNV_RATE
Signed 14.7Currency conversion rate at Purchase Order entry time.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PIH-CURR-SET-FLAG
CURR_SET_FLAG
Alpha 1Flag defines when the currency rate has been set for the Purchase Order.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PIH-REVALUE-FLAG
REVALUE_FLAG
Alpha 1AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PIH-DFLT-DL-DATE
DFLT_DL_DATE
Numeric 8 (yyyymmdd)This field displays the system date when this was created.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PIH-LOCATION
LOCATION
Alpha 5This field contains a valid stocking location within the company inventory.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PIH-SH-NAME
SH_NAME
Alpha 30 (Lower Case)Displays the company description.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PIH-SH-ADDR1
SH_ADDR1
Alpha 30 (Lower Case)This field contains the first line of address information.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PIH-SH-ADDR2
SH_ADDR2
Alpha 30 (Lower Case)This field contains the first line of address information.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PIH-SH-ADDR3
SH_ADDR3
Alpha 30 (Lower Case)This field contains the first line of address information.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PIH-SH-ADDR4
SH_ADDR4
Alpha 30 (Lower Case)This field contains the first line of address information.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PIH-SH-CITY-ADDR5
SH_CITY_ADDR5
Alpha 18 (Lower Case)This field contains the city of the address.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PIH-SH-STATE-PROV
SH_STATE_PROV
Alpha 2The state or province.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PIH-SH-POST-CODE
SH_POST_CODE
Alpha 10 (Lower Case)This is the ship to mail code.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PIH-SH-COUNTRY
SH_COUNTRY
Alpha 30 (Lower Case)This field contains the country of the address, or it can be used for additional information such as an attention name.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PIH-SH-COUNTY
SH_COUNTY
Alpha 25 (Lower Case)The county for the company address.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PIH-SH-PHONE-PREF
SH_PHONE_PREF
Alpha 6The telephone number country code.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PIH-SH-PHONE
SH_PHONE
Alpha 15Phone number.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PIH-SH-PHONE-EXT
SH_PHONE_EXT
Alpha 5This field contains the telephone extension number.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PIH-SH-CONTACT
SH_CONTACT
Alpha 30 (Lower Case)This is the name of the main contact.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PIH-NBR-LINES
NBR_LINES
Numeric 6This is the number of detail lines.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PIH-CLOSED-LINES
CLOSED_LINES
Numeric 6This is the number of closed detail lines on the requisition. When the number of closed lines equals the number of lines, the requisition status will be set to closed in RQ120.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PIH-DROPSHIP-FL
DROPSHIP_FL
Alpha 1This flag indicates whether goods being shipped by the vendor directly to a non standard location need to have the receiving process performed.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PIH-PRT-REC-FLAG
PRT_REC_FLAG
Alpha 1AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PIH-FAX-PREFIX
FAX_PREFIX
Alpha 6The telephone number country code.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PIH-FAX-NUMBER
FAX_NUMBER
Alpha 15Phone number.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PIH-FAX-EXT
FAX_EXT
Alpha 5This field contains the telephone extension number.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PIH-PROCESS-LEVEL
PROCESS_LEVEL
Alpha 5This field contains the process level, which is the reporting hierarchy below company.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PIH-WEIGHT
WEIGHT
Signed 9.3This field contains the unit weight of the item based on the stocking UOM.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PIH-CUBIC-FEET
CUBIC_FEET
Signed 9.3This field contains the unit cubic feet of the item based on the stocking UOM.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PIH-FREIGHT-TERMS
FREIGHT_TERMS
Alpha 1Freight terms are used to define who pays for freight costs incurred when goods are shipped. Prepaid, for instance, would normally mean that the vendor would pay for freight. Collect would mean the customer would pay for freight. A freight terms code can be entered on a purchase order, or defaulted by vendor or company.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PIH-FOB-CODE
FOB_CODE
Alpha 3The user defined Free On Board Code.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PIH-SHIP-VIA
SHIP_VIA
Alpha 12 (Lower Case)AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PIH-TERMS-CODE
TERMS_CODE
Alpha 5A user-defined code representing a method of determining invoice due and discount dates.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PIH-TAX-CODE
TAX_CODE
Alpha 10This field contains a code representing specific tax information. This must be valid Tax Code.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PIH-TOT-PRD-AMT
TOT_PRD_AMT
Signed 18.2AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PIH-TOT-TAXBLE-AMT
TOT_TAXBLE_AMT
Signed 18.2AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PIH-LETTER-OF-CR
LETTER_OF_CR
Alpha 20This field contains the letter of credit.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PIH-TOT-ORDER-AMT
TOT_ORDER_AMT
Signed 18.2AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PIH-USER-DATE-1
USER_DATE_1
Numeric 8 (yyyymmdd)This field displays the system date when this was created.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PIH-USER-DATE-2
USER_DATE_2
Numeric 8 (yyyymmdd)This field displays the system date when this was created.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PIH-LAST-LINE-NBR
LAST_LINE_NBR
Numeric 6This field contains the line number.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PIH-DFLT-TAXBL-FL
DFLT_TAXBL_FL
Alpha 1AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PIH-DFLT-ACCT-UNIT
DFLT_ACCT_UNIT
Alpha 15The accounting unit is a shorthand notation representing the variable level number. When used in the General Ledger Account Master file, the accounting unit must be defined in the General Ledger Names file as a posting accounting unit.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PIH-DFLT-ACCOUNT
DFLT_ACCOUNT
Numeric 6This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PIH-DFLT-SUB-ACCT
DFLT_SUB_ACCT
Numeric 4This field contains the subaccount from your general ledger chart of accounts that was charged with the amount carried on this record.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PIH-DFLT-DIST-CO
DFLT_DIST_CO
Numeric 4Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PIH-DFLT-ACTIVITY
DFLT_ACTIVITY
Alpha 15Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PIH-DFLT-ACCT-CAT
DFLT_ACCT_CAT
Alpha 5Account categories are groupings of costs, revenues, or a combination of both used for reporting and inquiries for activities in the Activity Management system. All transactions are posted to an account category within an activity. You can assign a specific General Ledger account or range of accounts (company, accounting unit, account, and subaccount) that make up the transactions posted to an account category using AC07.1 (Account Assignment). Period-to-date, year-to-date, and life-to-date balances are maintained by account category for activities. Account categories must be assigned to activities before you do any budgeting or transaction processing. Valid account category types are: cost revenue accrual pass thruAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PIH-DFLT-REQ-LOC
DFLT_REQ_LOC
Alpha 5The location requisitioning items. This location can be an inventory or noninventory location.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PIH-DFLT-REQUESTER
DFLT_REQUESTER
Alpha 10 (Lower Case)This is the person who requested this requisition.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PIH-DFLT-DEL-TO
DFLT_DEL_TO
Alpha 30 (Lower Case)This field can be used to specify where to deliver the items. This field prints on the delivery ticket when you run Delivery Ticket Print program.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PIH-DFLT-SRC-DOC
DFLT_SRC_DOC
Alpha 10AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PIH-RELEASED-FL
RELEASED_FL
Alpha 1AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PIH-ISSUED-FLAG
ISSUED_FLAG
Alpha 1AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PIH-REVISED-FL
REVISED_FL
Alpha 1AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PIH-CANCELLED-FL
CANCELLED_FL
Alpha 1AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PIH-CLOSED-FL
CLOSED_FL
Alpha 1The Closed Flag.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PIH-LAST-ACTIVITY
LAST_ACTIVITY
Numeric 8 (yyyymmdd)This field displays the system date when this was created.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PIH-CLOSE-DATE
CLOSE_DATE
Numeric 8 (yyyymmdd)Add on cost close date.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PIH-PO-USER-FLD-1
PO_USER_FLD_1
Alpha 1Purchase Order header user field one.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PIH-PO-USER-FLD-3
PO_USER_FLD_3
Alpha 30This is the second user definable field. This field can be used to enter any data that the user wants to capture for this item. The title of the field is setup in IC00.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PIH-PO-USER-FLD-5
PO_USER_FLD_5
Alpha 30 (Lower Case)AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PIH-INVC-MTHD-CODE
INVC_MTHD_CODE
Alpha 3The method the vendor is to use to invoice the order (manual, EDI, or evaluated receipts settlement).AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PIH-ISSUE-METH
ISSUE_METH
Alpha 1Specifies the method that will be used to issue the purchase order to the vendor.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PIH-REVISIONS-INCL
REVISIONS_INCL
Alpha 1Specifies what information will be included when a revised Purchase Order is re-issued. You may specify that only the revised information is included, along with messages that indicate what was revised (option O - Revisions Only). Alternately, you may specify that the entire PO is included, along with messages that indicate the revisions. Finally, you may specify that the entire PO is re-issued. No revision messages will appear. If the PO has not been printed, or the revised PO is not to be re-issued, this field will be blank (Not Applicable).AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PIH-ISSUE-PENDING
ISSUE_PENDING
Alpha 1Indicates whether the purchase order will be processed if it meets the selection criteria specified in PO120 (Purchase Order Issue).AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PIH-USER-ID
USER_ID
Alpha 10 (Lower Case)AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PIH-PO-AOC-TOTAL
PO_AOC_TOTAL
Signed 18.2AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PIH-PO-TAX-TOTAL
PO_TAX_TOTAL
Signed 18.2AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PIH-PO-PRINT-TOTAL
PO_PRINT_TOTAL
Signed 18.2AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PIH-POV-AOC-TOTAL
POV_AOC_TOTAL
Signed 18.2AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PIH-POV-ITAX-TOTAL
POV_ITAX_TOTAL
Signed 18.2AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PIH-POV-GRD-TOTAL
POV_GRD_TOTAL
Signed 18.2AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PIH-OV-AOC-TOTAL
OV_AOC_TOTAL
Signed 18.2AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PIH-OV-ITAX-TOTAL
OV_ITAX_TOTAL
Signed 18.2AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PIH-OV-GRD-TOTAL
OV_GRD_TOTAL
Signed 18.2AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PIH-ACCR-TAX-TOTAL
ACCR_TAX_TOTAL
Signed 18.2AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PIH-OPEN-PO-AMT
OPEN_PO_AMT
Signed 18.2AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PIH-INTRASTAT-NBR
INTRASTAT_NBR
Numeric 12The number assigned by the Intrastat system to a transaction that involves Intrastat reporting after it has been added.
PIH-TO-CNTRY-CD
TO_CNTRY_CD
Alpha 2The Ship-To country code. Must be defined in IN01.1 (Country Maintenaance).
PIH-SHIP-TO-REGION
SHIP_TO_REGION
Alpha 2The ship-to region code. Must be a valid region for the country, defined in IN02.1 (Region Maintenance).

Indexes (3)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
PIHSET1COMPANY, PO-CODE, PO-NUMBER, PO-RELEASE, PO-REVISION, CREATION-DATE, CREATION-TIMEPrimaryAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
PIHSET2COMPANY, VENDOR, PO-CODE, PO-NUMBER, PO-RELEASE, PO-REVISION
PIHSET3COMPANY, LOCATION, PO-CODE, PO-NUMBER, PO-RELEASE, PO-REVISION

Relations

One to one (1) — lookups and parents

RelationTableRulesConditionField map
HdrouticcoutICCOUTRequiredPIH-COMPANYOWC-COMPANY (OWCSET2), PIH-LOCATIONOWC-LOCATION

One to many (1) — child tables

RelationTableRulesConditionField map
HdroutlineoutPOLINEOUTPIH-COMPANYPLT-COMPANY, PIH-PO-CODEPLT-PO-CODE, PIH-PO-NUMBERPLT-PO-NUMBER, PIH-PO-RELEASEPLT-PO-RELEASE, PIH-PO-REVISIONPLT-PO-REVISION, PIH-CREATION-DATEPLT-CREATION-DATE, PIH-CREATION-TIMEPLT-CREATION-TIME, PLT-LINE-NBR

Programs

Updated by (222)