POINTCMTS FILE
Interface Comments
This file contains comments associated with a Interface File record. These
comments are created by the system that creates the Interface File record and
becomes part of the purchase order created from that Interface File record.
REFERENCED BY
PO100
UPDATED BY
BL92.1 MA300 OE10.1 OE10.2 OE10.3 OE10.4
OE10.5 OE10.6 OE10.7 OE10.8 OE11.1 OE11.4
OE11.8 OE11.9 OE110 OE113 OE114 OE129
OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5
OE15.7 OE510 OE810 OE920 RQ125 WH20.2
WH20.7
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PIC-COMPANY Numeric 4 BL92.1 OE10.1
Company The company number. OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 RQ125
WH20.2 WH20.7
PIC-ORIGIN-CD Alpha 2 BL92.1 OE10.1
Origin Code This field identifies the system that OE10.2 OE10.3
created this record. OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 RQ125
WH20.2 WH20.7
PIC-IF-REF-NBR Numeric 9 BL92.1 OE10.1
Reference Number This is an internally generated OE10.2 OE10.3
reference number used by the Requisition OE10.4 OE10.5
system. OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 RQ125
WH20.2 WH20.7
PIC-ORDER-NBR Numeric 8 BL92.1 OE10.1
Order Number The Order Entry order number for which OE10.2 OE10.3
this comment line was entered. OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 RQ125
WH20.2 WH20.7
PIC-LINE-NBR Numeric 6 BL92.1 OE10.1
Line Number This field contains the line number. OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 RQ125
WH20.2 WH20.7
PIC-SEQ Numeric 3 BL92.1 OE10.1
Sequence Number This field contains the record sequence OE10.2 OE10.3
number. OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 RQ125
WH20.2 WH20.7
PIC-COMMENT Alpha 40 (Lower Case) BL92.1 OE10.1
Comment Line This field contains the comment OE10.2 OE10.3
narrative. OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 RQ125
WH20.2 WH20.7
PIC-PRINT-CODE Alpha 1 BL92.1 OE10.1
Print Code This field contains the print code, OE10.2 OE10.3
which defines where comments are OE10.4 OE10.5
displayed or printed. OE10.6 OE10.7
B = Display and Print OE10.8 OE11.1
D = Display Only OE11.4 OE11.8
P = Purchase Order OE11.9 OE110
R = Receiver OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 RQ125
WH20.2 WH20.7
POINTCMTS FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PICSET1 COMPANY MA300 PO100
ORIGIN-CD
IF-REF-NBR
ORDER-NBR
LINE-NBR
SEQ
POINTCMTS FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Pocompany POCOMPANY Required
PIC-COMPANY -> PCY-COMPANY
POINTCMTS FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Pointerfac POINTERFAC
PIC-COMPANY -> PIF-COMPANY
PIC-ORIGIN-CD -> PIF-ORIGIN-CD
PIC-IF-REF-NBR -> PIF-IF-REF-NBR
PIC-ORDER-NBR -> PIF-ORDER-NBR
PIC-LINE-NBR -> PIF-LINE-NBR
PIF-SEQ
|