ORD_LTTR_DOCS (SQL Table)	Index Back
Order Letter of Credit Documnt This table stores the multi-media attachments identifiers for an order header, line or schedule.

ORD_LTTR_DOCS

(SQL Table)

Order Letter of Credit Documnt

This table stores the multi-media attachments identifiers for an order header, line or schedule.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Prompt Table: BUS_UNIT_TBL_OM

2 ORDER_NO Character(10) VARCHAR2(10) NOT NULL Identifies a customer order number that appears as a reference on a receivables pending item. Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop
Prompt Table: ORD_HEADER

3 CR_LTTR_DOC Character(3) VARCHAR2(3) NOT NULL Required Documents
1=Commercial Invoices
2=Export Declaration
3=Packing List
4=Bill of Lading
5=Certificate of Origin
6=Export License
7=Import Certificate
8=Consular Invoices
9=Certificate of Compliance

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: BUS_UNIT_TBL_OM
2	ORDER_NO	Character(10)	VARCHAR2(10) NOT NULL	Identifies a customer order number that appears as a reference on a receivables pending item. Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop Prompt Table: ORD_HEADER
3	CR_LTTR_DOC	Character(3)	VARCHAR2(3) NOT NULL	Required Documents 1=Commercial Invoices 2=Export Declaration 3=Packing List 4=Bill of Lading 5=Certificate of Origin 6=Export License 7=Import Certificate 8=Consular Invoices 9=Certificate of Compliance